MySQL Forums
Forum List  »  Database Design & Data Modelling

Advanced Search
New Topic

Re: What's the worst that can happen with below database design? Immediately or in the future?
Posted by: Peter Brawley
Date: September 05, 2014 03:15PM

SQL isn't a complete computer language. It's very literal-minded, and it handles time, hierarchies and abstracted data models very badly indeed. So EAV SQL databases, like hierarchical SQL databases and complicated time computations in SQL, fail to scale. Sure your model can be thought of as relational, but in effect it's also EAV. I think it would introduce maintenance and performance nightmares.

Navigate: Previous Message• Next Message
Options: Reply• Quote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.