技术交易 > OLAP query processing method orient...
OLAP query processing method oriented to database and HADOOP hybrid platform （专利授权号：US13/514296）
中国人民大学理工处V6 （ 中国人民大学 ）
技术摘要
介绍了一种面向数据库和Hadoop混合平台的OLAP查询处理方法。当执行OLAP查询处理时，首先对主工作副本执行该处理，并且将查询处理结果记录在本地数据库的聚合结果表中；当工作节点发生故障时，通过namenode查找主工作副本对应的容错副本的节点信息，调用MapReduce任务完成对容错副本的OLAP查询处理任务。将数据库技术与Hadoop技术相结合，将数据库的存储性能与Hadoop的高扩展性和高可用性相结合；数据库查询处理和MapReduce查询处理以松散耦合的方式集成在一起，从而保证了较高的查询处理性能，并保证了较高的容错性能。
技术说明
An OLAP query processing method oriented to a database and Hadoop hybrid platform is described. When OLAP query processing is performed, the processing is executed first on a main working copy, and a query processing result is recorded in an aggregate result table of a local database; when a working node is faulty, node information of a fault-tolerant copy corresponding to the main working copy is searched for through namenode, and a MapReduce task is invoked to complete the OLAP query processing task on the fault-tolerant copy. The database technology and the Hadoop technology are combined, and the storage performance of the database and the high expandability and high availability of the Hadoop are combined; the database query processing and the MapReduce query processing are integrated in a loosely-coupled mode, thereby ensuring the high query processing performance, and ensuring the high fault-tolerance performance.
成熟度
通过小试
技术来源
中国人民大学
