number of tables (67 Views)
Reply
Occasional Contributor
Balakumar
Posts: 2
Registered: ‎04-07-2005
Message 1 of 4 (67 Views)

number of tables

Please let me know,for a database size of 35GB, what will be the approximate number of tables
Please use plain text.
Occasional Visitor
Roshan Shah_1
Posts: 2
Registered: ‎04-16-2005
Message 2 of 4 (67 Views)

Re: number of tables

Bala,

You will never get a right answer to this question and you already probably know why!

Roshan
Please use plain text.
Honored Contributor
Chuck Ciesinski
Posts: 830
Registered: ‎10-03-2000
Message 3 of 4 (67 Views)

Re: number of tables

Balakumar,

I do not believe that there is a clear rule of thumb for IMAGE data sets to ORACLE or SQL tables. I could be wrong, but I've NEVER seen one.

Chuck Ciesinski
"Show me the $$$$$"
Please use plain text.
Frequent Advisor
Gary Tinnes
Posts: 30
Registered: ‎07-12-2000
Message 4 of 4 (67 Views)

Re: number of tables

You cannot equate database size with number tables. That is dependent on your data model. There is a loose correlation between Image datasets & tables. I say loose for two reasons:

1) Performance issues moving from a networked hierarchical to relational model.

2) Data types & DBMS management overhead.
Please use plain text.
The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation