Question : I’m trying to build a filter system for an e-commerce application. The following schema is given: http://sqlfiddle.com/#!9/18b93 A […]
Tag: eav
Proper way to store a value that could be multiple different types
Question : I have an Answers table and a Questions table. The Answers table has a value, but depending on […]
How best to store complex cost information
Question : I am creating a database to store data related to costs. The cost information can be very varied […]
Database Design for Preserving Values and Additional columns
Question : My colleague and I are having some trouble coming up with a database design, and I am doing […]
pulling multiple entries from a match of two tables
Question : I have two tables, attributes and attributes_entries attributes hold the title and attribute_entries hold the value of that […]
Model types of an entity [duplicate]
Question : This question already has answers here: what is a good use case for splitting user table by role […]
Optimal mySQL design for 500k+ products with up to 50 specs
Question : I facing a problem where I have to design a MySQL database capable of containing +500k products in […]
Alternatives to EAV model
Question : I am looking for a design pattern that would allow me to capture metadata relating to columns on […]
EAV, multiple left join query optimisation
Question : Any assitance would be greatly welcomed. Pardon my ignorance however I am wondering if anyone else has had […]
When 3rd NF is not the best solution? (Performance)
Question : I have 3 tables: Measurements (‘id’, ‘name’) Records (‘id’, ‘measurement_id’, ‘time’, ‘number’) – Measurement has many records Parameters […]