Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Data warehouse model construction method and apparatus, and data query method, apparatus and device

A data warehouse and construction method technology, applied in the computer field, can solve the problems of difficult data warehouse management, difficult operation and maintenance of physical wide tables, and difficult changes.

Pending Publication Date: 2020-01-10
ADVANCED NEW TECH CO LTD
View PDF3 Cites 10 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] In order to realize the application of data in the data warehouse, in the construction process of the above-mentioned traditional database, the data warehouse is required to produce a complete physical wide table or even a summary table in advance. However, the physical wide table has the disadvantages of being difficult to maintain and change. Make data warehouse management difficult

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Data warehouse model construction method and apparatus, and data query method, apparatus and device
  • Data warehouse model construction method and apparatus, and data query method, apparatus and device
  • Data warehouse model construction method and apparatus, and data query method, apparatus and device

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0023] In order to facilitate the understanding of the technical solutions mentioned in the embodiments of the present application, some technical terms involved in the present application will be briefly described below.

[0024] Hive is a data warehouse infrastructure built on Hadoop. It provides a series of tools that can be used for data extraction, conversion and loading, which is a mechanism for storing, querying and analyzing large-scale data stored in Hadoop. Hive defines a simple SQL-like query language.

[0025] Data topics, also known as topics and business topics, are formed by integrating all related data of a certain business entity. For example, all relevant data of a user is integrated to form a user topic, and all relevant data of an order is integrated to form an order topic. Typically, data subjects can be described using dimensional models such as star schemas, snowflake schemas. Data related to a data subject is called subject data.

[0026] Indicator ...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

Abstract

The embodiment of the invention discloses a data warehouse construction method and apparatus, and a data query method, apparatus and device. The data warehouse construction method comprises the steps:acquiring a physical fact table; obtaining and establishing an association relationship between the logic topic table and the physical fact table in the metadata according to the logic topic table configuration information; and obtaining and establishing an association relationship between the indexes and the logic topic table in metadata according to the index configuration information. The dataquery method is applied to the data warehouse constructed by the data warehouse construction method, and comprises the following steps: receiving a query request which comprises indexes; determininga corresponding logic topic table according to an association relationship between the index and the logic topic table in the metadata; determining a corresponding physical fact table according to theassociation relationship between the logic theme table and the physical fact table; and determining a query result of the index according to the content of the corresponding physical fact table.

Description

technical field [0001] The present application relates to the field of computer technology, in particular to a data warehouse model building and data query method, device and equipment. Background technique [0002] A data warehouse is a structured data environment, which is a collection of subject-oriented, integrated, relatively stable data that reflects historical changes, and is used to support management decisions. [0003] The construction process of the data warehouse usually follows the following process: collect the business database and original log data to the big data storage system, analyze and clean to obtain the formatted data warehouse base layer (ODS), and then classify with the goal of restoring the business process The middle layer (DW) of data warehouse details obtained through transformation, transformation and association, and then the application layer (DM) of data warehouse bazaar obtained through association integration and subject classification wit...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
IPC IPC(8): G06F16/28G06F16/21G06F16/22G06F16/242G06F16/2455
CPCG06F16/283G06F16/212G06F16/2282G06F16/242G06F16/2455
Inventor 张力叶文军琚克俭虞睿
Owner ADVANCED NEW TECH CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products

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