I am working on a database design. The problem is that the structure of the information is hierarchal, which means the primary keys from the upper level is always a part of the primary key of below levels making it incremental composite primary key.
VARCHAR(5) SHOP_ID (PK)
VARCHAR(5) SHOP_ID (FK)
VARCHAR(5) MENU_ID (PK)
what do you think about the Oracle LDAP solution. It is much easier to build hierarchaly structure with a LDAP protocol than in a relational database.
You can also use PL/SQL to access datas from an "normal" relational Oracle DB to an Oracle LDAP and vice versa.
I think this is the only way to design hierachic structures ... otherwise you will get in trouble with performance ....