System and method for online analytical processing using dimension attributes and multiple hierarchies per dimension
摘要
A data model for accessing data in a relational database in an OLAP system utilizes a multiple-hierarchy dimension. The dimension includes a set of attributes. Each attribute is bound to a column in the relational database. A logical structure is defined, indicating the relationships between the attributes. Hierarchies are defined. Each hierarchy includes a sequence of attributes. A hierarchy provides a common drill-down path that a database user can utilize to access the database. A hierarchy can include a single attribute or a combination of attributes. Both the relationships between the attributes and the sequence of attributes in a hierarchy are defined independent of any restrictions associated with the database. <IMAGE>
申请公布号
EP1492030(B1)
申请公布日期
2016.10.19
申请号
EP20040102562
申请日期
2004.06.07
申请人
MICROSOFT TECHNOLOGY LICENSING, LLC
发明人
PETCULESCU, CHRISTIAN;NETZ, AMIR;PASUMANSKY, MOSHA;DUMITRU, MARIUS;BERGER, ALEXANDER;SANDERS, PAUL JONATHON