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

number of tables

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

Re: number of tables

Bala,

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

Roshan
Honored Contributor
Chuck Ciesinski
Posts: 830
Registered: ‎10-03-2000
Message 3 of 4 (139 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 $$$$$"
Frequent Advisor
Gary Tinnes
Posts: 30
Registered: ‎07-12-2000
Message 4 of 4 (139 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.
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.