OLAP query processing method based on array storage and vector processing
A processing method and vector technology, applied in the field of database management, can solve the problems of increasing the complexity of hash grouping and aggregation calculation, and achieve the effect of improving query processing efficiency
- Summary
- Abstract
- Description
- Claims
- Application Information
AI Technical Summary
Problems solved by technology
Method used
Image
Examples
Embodiment Construction
[0037] The present invention will be further described in detail below in conjunction with the accompanying drawings and specific embodiments.
[0038] The invention provides an OLAP query processing method based on array storage and vector processing. This method simplifies the storage and processing of the complex multidimensional data model of the data warehouse. According to the referential integrity constraints in the data warehouse model, the array storage of data is completed at the bottom layer of the data warehouse design. The array storage uses array subscripts as implicit or explicit The primary key, the primary-foreign key reference relationship defined by the referential integrity constraint relationship is converted into an array subscript reference relationship between the table where the foreign key is located and the table where the primary key is located, so that the dimension table and the fact table pass the primary-foreign key reference relationship Direct...
PUM
Abstract
Description
Claims
Application Information
- R&D Engineer
- R&D Manager
- IP Professional
- Industry Leading Data Capabilities
- Powerful AI technology
- Patent DNA Extraction
Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.
© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com