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