multiple level database hierarchy

I seems that mysql and may SQL has only two levels databases->tables.
Where there many tables, it become hard to properly name the tables
and databases. I'm wondering if there is any variant of SQL or some
other database that support arbitrary levels of complexity.

--
Regards,
Peng

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Re: multiple level database hierarchy

Hi!


Peng Yu wrote:
> I seems that mysql and may SQL has only two levels databases->table=
s.
> Where there many tables, it become hard to properly name the tables
> and databases. I'm wondering if there is any variant of SQL or some
> other database that support arbitrary levels of complexity.

When I last dealt with the SQL standard, there was no additional leve=
l
(or other structuring concept, like nesting) in it.

Back then, the SQL standard had "schema" at the top level, then "tabl=
e";
in implementations, typically (like with MySQL) "schema" is called
"database".

If you want additional levels, you can use your own system of naming
databases and tables, like using proper prefixes in the identifiers.


HTH,
Jörg

--=20
Joerg Bruehe, MySQL Build Team, Joerg.Bruehe@Sun.COM
Sun Microsystems GmbH, Komturstrasse 18a, D-12099 Berlin
Geschaeftsfuehrer: Juergen Kunz
Amtsgericht Muenchen: HRB161028


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg