PHPMem v2.0.1

Version
1.6.45
Uptime
15 days 11 hours 11 minutes

Memory

Total
512MB
Used
16,30MB (3.18%)
Free
495,70MB

Keys

Current
19 578
Total (since start)
33 978
Evictions
0
Reclaimed
377
Expired Unfetched
0
Evicted Unfetched
0

Connections

Current
7 / 1 024 max
Total
172 449
Rejected
0
llm:d11d4b781c0258fb670f382309771c4afc6ce7bbc25cc18e827abfff696fb22e
TTL 6 days 2 hours 11 minutes 2 seconds Size 3,55KB Export
Edit
{
    "judgments": [
        {
            "dependent": "Category",
            "decision": "approve",
            "confidence": 0.93,
            "reason_code": "stable_reference_mapping",
            "reason_refers_to": null,
            "rationale": "A product belongs to one category, a coarser label than the product. All 20 products repeat heavily, and the category stayed fixed across every order, date and customer that varied inside a product.",
            "request_escalation": false,
            "claims": {
                "repetition": "repeated_owners",
                "population": "measured_eligible_rows",
                "collision": {
                    "direction": "reverse",
                    "columns": [
                        "Category"
                    ],
                    "conflicting_values": [
                        "electronics",
                        "accessories"
                    ],
                    "evidence_refs": [
                        "paired_values"
                    ],
                    "basis": "observed_in_evidence"
                },
                "scope_claim": {
                    "basis": "observed_in_evidence",
                    "coordinates": [
                        "OrderDate",
                        "CustomerID",
                        "OrderID"
                    ],
                    "evidence_refs": [
                        "measured_shape.coordinate_diversity"
                    ]
                },
                "evidence_refs": [
                    "candidate",
                    "measured_shape",
                    "paired_values",
                    "other_columns_in_this_table"
                ]
            },
            "scope": {
                "owning_determinant": [
                    "ProductID"
                ],
                "interpretation": "entity_property",
                "population": "all_eligible_rows",
                "conditions": [],
                "basis": "Category is a product classification. Order, date and customer coordinates all varied inside every product while category never moved, so the rows are order lines re-stating a product-level label.",
                "evidence": [
                    "candidate",
                    "measured_shape",
                    "paired_values",
                    "other_columns_in_this_table"
                ]
            }
        },
        {
            "dependent": "ProductName",
            "decision": "approve",
            "confidence": 0.96,
            "reason_code": "identifier_determines_descriptor",
            "reason_refers_to": null,
            "rationale": "A product id names one product, and the name is part of what the product is. All 20 ids repeat heavily and the name never changed, even where order, date and customer varied.",
            "request_escalation": false,
            "claims": {
                "repetition": "repeated_owners",
                "population": "measured_eligible_rows",
                "collision": null,
                "scope_claim": {
                    "basis": "observed_in_evidence",
                    "coordinates": [
                        "OrderDate",
                        "CustomerID",
                        "OrderID"
                    ],
                    "evidence_refs": [
                        "measured_shape.coordinate_diversity"
                    ]
                },
                "evidence_refs": [
                    "candidate",
                    "measured_shape",
                    "paired_values"
                ]
            },
            "scope": {
                "owning_determinant": [
                    "ProductID"
                ],
                "interpretation": "entity_property",
                "population": "all_eligible_rows",
                "conditions": [],
                "basis": "A product's name is part of what the product is. The order-line grain repeated each product thousands of times across varying orders, dates and customers without the name moving.",
                "evidence": [
                    "candidate",
                    "measured_shape",
                    "paired_values"
                ]
            }
        },
        {
            "dependent": "UnitPrice",
            "decision": "approve",
            "confidence": 0.85,
            "reason_code": "identifier_determines_descriptor",
            "reason_refers_to": null,
            "rationale": "A catalogue price is an entity property of the product. It stayed fixed across thousands of order lines per product, including across varying order dates, so it was not a per-sale price or versioned by date.",
            "request_escalation": false,
            "claims": {
                "repetition": "repeated_owners",
                "population": "measured_eligible_rows",
                "collision": null,
                "scope_claim": {
                    "basis": "observed_in_evidence",
                    "coordinates": [
                        "OrderDate",
                        "SignupDate",
                        "CustomerID"
                    ],
                    "evidence_refs": [
                        "measured_shape.coordinate_diversity"
                    ]
                },
                "evidence_refs": [
                    "candidate",
                    "measured_shape",
                    "paired_values",
                    "other_columns_in_this_table"
                ]
            },
            "scope": {
                "owning_determinant": [
                    "ProductID"
                ],
                "interpretation": "entity_property",
                "population": "all_eligible_rows",
                "conditions": [],
                "basis": "Unit price behaves as one list price per product. OrderDate moved inside all 20 products while price moved in none, which is the variation that would have shown a transaction or versioned price.",
                "evidence": [
                    "candidate",
                    "measured_shape",
                    "paired_values",
                    "other_columns_in_this_table"
                ]
            }
        }
    ]
}