Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

If Hydrate is about laying an object model over an existing database, why are there no tools to convert a relational schema into objects?

0
Posted

If Hydrate is about laying an object model over an existing database, why are there no tools to convert a relational schema into objects?

0

There are many commercial and open source tools that enable you to generate an object model from a relational schema. The problem with a schema generated in this way is that it shows its heredity. The data in a relational schema has generally been forced against its will into what, let’s face it, is a somewhat unnatural representation, in order to reap the benefits from the relational engine. Also, a typical relational schema that has been around for more than one system enhancement will often be less than ideal in structure. The decisions about how much to normalize, what primary and foreign keys are used, etc. is generally driven more by performance, resource needs and history, that by data modelling purity. Unless you are very lucky with your relational database schema, an object model generated from will always look like an object model generated from a relational schema. In summary, tools that write your object model from a database are impressive at first, because you make a lot

Related Questions

What is your question?

*Sadly, we had to bring back ads too. Hopefully more targeted.

Experts123