Retrieval method and device based on star shape database
A database and data technology, applied in the computer field, can solve the problems of increased query statement complexity, inconvenient maintenance, unfavorable understanding, etc., and achieve the effects of facilitating the modification of query conditions, simple query statements, and simplified query codes.
Active Publication Date: 2017-06-06
BEIJING GRIDSUM TECH CO LTD
View PDF11 Cites 0 Cited by
- Summary
- Abstract
- Description
- Claims
- Application Information
AI Technical Summary
Problems solved by technology
As the user's demand for data display becomes more and more in-depth, the linkage query requirements between various modules become more and more complex
[0003] In the prior art, the search for the star database is solved by splicing different where conditions in SQL with different conditions, and the query statement is very complicated
Moreover, as the user's demand for this combined query increases, the complexity of the query statement will further increase
If you need to modify a certain condition, you need to modify all the places related to the query condition in batches, which is not convenient for code maintenance. SQL statements written in the traditional way are not conducive to business understanding
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 moreImage
Smart Image Click on the blue labels to locate them in the text.
Smart ImageViewing Examples
Examples
Experimental program
Comparison scheme
Effect test
Embodiment Construction
[0022] Exemplary embodiments of the present disclosure will be described in more detail below with reference to the accompanying drawings. Although exemplary embodiments of the present disclosure are shown in the drawings, it should be understood that the present disclosure may be embodied in various forms and should not be limited by the embodiments set forth herein. Rather, these embodiments are provided for more thorough understanding of the present disclosure and to fully convey the scope of the present disclosure to those skilled in the art.
[0023] In order to facilitate the understanding of the embodiments of the present invention, the following briefly introduces the star database. In the star schema, any number of dimension tables can be referenced in one or more fact tables, and the fact tables and dimension tables can assist users in analysis and classification at different levels. Among them, the fact table contains the main data. A fact table will usually inclu...
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
Login to View More Abstract
The invention discloses a retrieval method and device based on a star shape database, relates to the field of computer. The retrieval method mainly comprises that a query condition selected by the user is received; the query condition is parsed to obtain a conditions large collection; the database is queried and the large collection of query results based on the conditions large collection is obtained; the large collection of query results are classified, and the query results corresponding to each query module based on each query module are obtained. The retrieval method and device has the advantages of being simple in inquiry statement, and good for the maintenance of the code and the modification of the inquiry condition.
Description
technical field [0001] The invention relates to the field of computers, in particular to a retrieval method and device based on a star database. Background technique [0002] With the continuous improvement of computer computing and processing capabilities, people have more and more requirements for extracting target data from large databases. A star database is composed of one or more fact tables and any number of dimension tables referenced in the fact tables. As the user's demand for data display becomes more and more in-depth, the linkage query requirements between various modules become more and more complex. [0003] In the prior art, the search for the star database is solved by splicing different where conditions in SQL with different conditions, and the query statement is very complicated. Moreover, as the user's demand for this combined query increases, the complexity of the query statement will further increase. If you need to modify a certain condition, you ne...
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
Login to View More Patent Type & Authority Applications(China)
IPC IPC(8): G06F17/30
CPCG06F16/283
Inventor 樊思国
Owner BEIJING GRIDSUM TECH CO LTD