Query optimization method based on join index in data warehouse
A technology for connecting indexes and data warehouses, which is applied in the field of query processing, and can solve the problems of increasing the calculation cost of the number of values, high update frequency, and large index storage space cost, so as to reduce storage overhead and maintenance cost, and achieve high performance. Effect
- Summary
- Abstract
- Description
- Claims
- Application Information
AI Technical Summary
Problems solved by technology
Method used
Image
Examples
Example Embodiment
[0019] The present invention will be described in detail below with reference to the accompanying drawings and embodiments.
[0020] like figure 1 As shown, the present invention provides a query optimization method based on a join index in a data warehouse. The method is a join index optimization processing method based on a data warehouse star model and a snowflake model, which includes the following steps:
[0021] 1) Create a foreign key join index of the fact table based on the surrogate key of the dimension table. When the dimension table uses column storage or row storage of fixed-length records, the surrogate key of the dimension table can be directly mapped to the offset address of the dimension table record, and the value of the foreign key column of the fact table can be directly mapped to the offset address of the dimension table record. Join index based query processing.
[0022] Among them, creating a join index includes the following strategies:
[0023] (1) ...
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.
© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap