Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Many tables in one database
- Thread starter OOzy
- Start date
Hello
It is hard to say whether that is too many tables as I don't know your data requirements. However 35 tables is not a lot in the grand scheme of things , I have worked with an Sybase ASE (Adaptive Server Anywhere) database with 200 tables. I heard that Siebel systems (the CRM app) has 8000(!) tables.
So it depends on the size of your system. A good indicator is if your creating too many tables is if your replacing a database. How many tables did the old one have, if your way over that number then it might be worth looking at de-normalizing your dbms.
De-Normalizing can be a very useful excercise, but I wouldn't worry about a particular numer of tables. If your doing selects that have complex outer joins etc in them for data that you will want to access frequently then consider aggregating them on fewer tables.
Regards
Justin
P.S if your using PD 9.5 it has wizards for denormalizing.
Regards
Justin
It is hard to say whether that is too many tables as I don't know your data requirements. However 35 tables is not a lot in the grand scheme of things , I have worked with an Sybase ASE (Adaptive Server Anywhere) database with 200 tables. I heard that Siebel systems (the CRM app) has 8000(!) tables.
So it depends on the size of your system. A good indicator is if your creating too many tables is if your replacing a database. How many tables did the old one have, if your way over that number then it might be worth looking at de-normalizing your dbms.
De-Normalizing can be a very useful excercise, but I wouldn't worry about a particular numer of tables. If your doing selects that have complex outer joins etc in them for data that you will want to access frequently then consider aggregating them on fewer tables.
Regards
Justin
P.S if your using PD 9.5 it has wizards for denormalizing.
Regards
Justin
- Status
Similar threads
