PHPMem v2.0.1
Version
1.6.45
Uptime
15 days 9 hours 28 minutes 40 seconds
Memory
Total
512MB
Used
24,01MB (4.69%)
Free
487,99MB
Keys
Current
27 650
Total (since start)
33 978
Evictions
0
Reclaimed
160
Expired Unfetched
0
Evicted Unfetched
0
Connections
Current
14 / 1 024 max
Total
170 496
Rejected
0
llm:5bc221fe8a4c2ed31c5cdad3fc01bd2c051a7d79a4e351fe056d950a2704d52c
Edit
```json
{
"classifications": [
{
"column": "Restaurant ID",
"role": "identifier",
"confidence": 1.0,
"reason": "Primary key for restaurant records, used to uniquely identify each restaurant"
},
{
"column": "Restaurant Name",
"role": "attribute",
"confidence": 0.95,
"reason": "Descriptive text displayed to users, high cardinality (7446 distinct), not typically grouped"
},
{
"column": "Country Code",
"role": "dimension",
"confidence": 0.95,
"reason": "Low cardinality (15 distinct) numeric code used to group/filter by country"
},
{
"column": "City",
"role": "dimension",
"confidence": 1.0,
"reason": "Categorical field for grouping and filtering, medium cardinality (141 distinct)"
},
{
"column": "Address",
"role": "attribute",
"confidence": 1.0,
"reason": "Free-form descriptive text for display, very high cardinality (8918 distinct)"
},
{
"column": "Locality",
"role": "dimension",
"confidence": 0.9,
"reason": "Medium cardinality (1208 distinct) categorical field for grouping by neighborhood/area"
},
{
"column": "Locality Verbose",
"role": "attribute",
"confidence": 0.85,
"reason": "Descriptive extended locality text, high cardinality (1265 distinct), primarily for display"
},
{
"column": "Longitude",
"role": "dimension",
"confidence": 0.95,
"reason": "Geographic coordinate used for spatial filtering and mapping, not aggregated"
},
{
"column": "Latitude",
"role": "dimension",
"confidence": 0.95,
"reason": "Geographic coordinate used for spatial filtering and mapping, not aggregated"
},
{
"column": "Cuisines",
"role": "dimension",
"confidence": 0.9,
"reason": "Categorical field for filtering and grouping, high cardinality (1826 distinct) but used as dimension"
},
{
"column": "Average Cost for two",
"role": "measure",
"confidence": 1.0,
"reason": "Numeric quantity that can be aggregated (avg, sum) for analysis"
},
{
"column": "Currency",
"role": "dimension",
"confidence": 1.0,
"reason": "Low cardinality (12 distinct) categorical field for grouping and filtering"
},
{
"column": "Has Table booking",
"role": "dimension",
"confidence": 1.0,
"reason": "Boolean flag used for filtering and grouping, 2 distinct values"
},
{
"column": "Has Online delivery",
"role": "dimension",
"confidence": 1.0,
"reason": "Boolean flag used for filtering and grouping, 2 distinct values"
},
{
"column": "Is delivering now",
"role": "dimension",
"confidence": 1.0,
"reason": "Boolean flag used for filtering and grouping, 2 distinct values"
},
{
"column": "Switch to order menu",
"role": "dimension",
"confidence": 0.9,
"reason": "Boolean flag (only 1 distinct value in sample), used for filtering"
},
{
"column": "Price range",
"role": "dimension",
"confidence": 0.95,
"reason": "Low cardinality (4 distinct) ordinal category used for grouping and filtering"
},
{
"column": "Aggregate rating",
"role": "measure",
"confidence": 1.0,
"reason": "Numeric rating that is aggregated (averaged) for analysis"
},
{
"column": "Rating color",
"role": "dimension",
"confidence": 1.0,
"reason": "Low cardinality (6 distinct) categorical field for grouping and filtering"
},
{
"column": "Rating text",
"role": "dimension",
"confidence": 1.0,
"reason": "Low cardinality (6 distinct) categorical field for grouping and filtering"
},
{
"column": "Votes",
"role": "measure",
"confidence": 1.0,
"reason": "Numeric count that can be aggregated (sum, avg) for analysis"
}
]
}
```