发明授权
US07590638B2 System and method for online analytical processing using dimension attributes and multiple hierarchies where first hierarchy has at least one attribute from the defined dimension not present in the second hierarchy
有权
使用维度属性和多层次结构的在线分析处理的系统和方法，其中第一层次具有至少一个不存在于第二层次中的定义维度的属性
- 专利标题： System and method for online analytical processing using dimension attributes and multiple hierarchies where first hierarchy has at least one attribute from the defined dimension not present in the second hierarchy
- 专利标题（中）： 使用维度属性和多层次结构的在线分析处理的系统和方法，其中第一层次具有至少一个不存在于第二层次中的定义维度的属性
-
申请号： US10603037申请日： 2003-06-24
-
公开(公告)号： US07590638B2公开(公告)日： 2009-09-15
- 发明人: Cristian Petculescu , Amir Netz , Mosha Pasumansky , Marius Dumitru , Alexander Berger , Paul Jonathon Sanders
- 申请人： Cristian Petculescu , Amir Netz , Mosha Pasumansky , Marius Dumitru , Alexander Berger , Paul Jonathon Sanders
- 申请人地址： US WA Redmond
- 专利权人： Microsoft Corporation
- 当前专利权人： Microsoft Corporation
- 当前专利权人地址： US WA Redmond
- 代理机构： Woodcock Washburn LLP
- 主分类号： G06F17/00
- IPC分类号： G06F17/00 ; G06F17/30
摘要：
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.
公开/授权文献
信息查询
