Method and system for handling multiple dimensions in relational databases

摘要: The invention relates to a method for structuring data in computerized relational database system. includes generating dimension type table (dim_type) of descriptions dimensions, dimensional item (dim_item) items, location (location) locations representing intersection points between the various and connection (dim_conn) defining connections each items with which they are associated. Preferably, values stored entered separate value (data_value). also system structured accordance method. invented structure makes it possible achieve flexibility reuse code without sacrificing scalability performance searching reporting. Particularly, facilitates building queries reports focusing on subset limited by criteria simultaneously involving an arbitrary number retrieving contained regular classified according