发明授权
US08195602B2 Relational database management system (RDBMS) employing a relational datastore and a multi-dimensional database (MDDB) for serving query statements from client machines
有权
使用关系数据存储和多维数据库(MDDB)的关系数据库管理系统(RDBMS)用于从客户机提供查询语句
- 专利标题: Relational database management system (RDBMS) employing a relational datastore and a multi-dimensional database (MDDB) for serving query statements from client machines
- 专利标题(中): 使用关系数据存储和多维数据库(MDDB)的关系数据库管理系统(RDBMS)用于从客户机提供查询语句
-
申请号: US12455664申请日: 2009-06-04
-
公开(公告)号: US08195602B2公开(公告)日: 2012-06-05
- 发明人: Reuven Bakalash , Guy Shaked , Joseph Caspi
- 申请人: Reuven Bakalash , Guy Shaked , Joseph Caspi
- 申请人地址: US DE Wilmington
- 专利权人: Yanicklo Technology Limited Liability Company
- 当前专利权人: Yanicklo Technology Limited Liability Company
- 当前专利权人地址: US DE Wilmington
- 代理机构: Knobbe Martens Olson & Bear LLP
- 主分类号: G06F17/30
- IPC分类号: G06F17/30 ; G06F7/00
摘要:
A relational database management system (RDBMS) for servicing query statements from one or more client machines, using a relational data store and a multi-dimensional database (MDDB). The RDBMS includes a query interface which is adapted to receive query statements from the client machines, and to generate one or more query requests. The RDBMS includes a query handling mechanism which receives each request from the query interface, extracts a set of dimensions associated with the request, uses the dimensions to retrieve aggregated fact data from the MDDB, and forwards retrieved aggregated fact data to the query processing mechanism for subsequent processing. When the query processing mechanism of the RDBMS determines that servicing one or more query requests requires data stored in the relational tables, then the query handling mechanism automatically routes the requests to the relational data tables, so that data can be accessed from the relational tables and forwarded to the query processing mechanism for use in servicing the requests, in a manner transparent to the client machine. When the query processing mechanism determines that servicing one or more query requests requires aggregated data from the MDDB, then the query handling mechanism automatically routes the requests to the MDDB, so that data can be accessed from the MDDB and forwarded to the query processing mechanism for use in servicing the requests, in a manner transparent to the client machine.
公开/授权文献
信息查询