CN117874009A - System for creating and managing several warehouse models - Google Patents
System for creating and managing several warehouse models Download PDFInfo
- Publication number
- CN117874009A CN117874009A CN202410282329.5A CN202410282329A CN117874009A CN 117874009 A CN117874009 A CN 117874009A CN 202410282329 A CN202410282329 A CN 202410282329A CN 117874009 A CN117874009 A CN 117874009A
- Authority
- CN
- China
- Prior art keywords
- model
- bin
- bin model
- module
- creating
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
- 238000005259 measurement Methods 0.000 claims abstract description 47
- 230000004048 modification Effects 0.000 claims abstract description 42
- 238000012986 modification Methods 0.000 claims abstract description 42
- 230000001419 dependent effect Effects 0.000 claims description 23
- 238000010586 diagram Methods 0.000 claims description 16
- 238000010276 construction Methods 0.000 claims description 4
- 230000006835 compression Effects 0.000 claims description 3
- 238000007906 compression Methods 0.000 claims description 3
- 238000005192 partition Methods 0.000 claims description 3
- 238000007726 management method Methods 0.000 description 7
- 125000004122 cyclic group Chemical group 0.000 description 4
- 238000000034 method Methods 0.000 description 4
- 230000009286 beneficial effect Effects 0.000 description 2
- 238000013499 data model Methods 0.000 description 2
- 208000024780 Urticaria Diseases 0.000 description 1
- 238000001514 detection method Methods 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a system for creating and managing a multi-bin model, which comprises a model creation module, a model modification module, a dimension word degree module, a measurement field module and a model analysis module, wherein the model creation module is respectively connected with a mysql relational database and a Neo4j graph database, and the model modification module is respectively connected with the mysql relational database and the Neo4j graph database. The invention reduces the use and management cost of the several-bin model and improves the retrospective analysis capability of the several-bin model.
Description
Technical Field
The invention relates to the technical field of big data, in particular to a system for creating and managing a multi-bin model.
Background
In the process of constructing a large data warehouse, the most important is a data warehouse model, namely a number bin model for short. At present, the creation and management of a number bin model are basically two methods: the first is to create and query by way of a background command line; the second is to create and query through open source products such as Hue (Hadoop User Experience, an open source Apache Hadoop UI system) and the like.
The two modes cannot well manage the bin models, and the following difficulties often occur: 1) The field names in different bin models are the same but the represented meanings are different; 2) The meaning of the field representation in different number bin models is the same but the field names are different; 3) The dependent links among the bin models are not known; 4) The overall construction condition of the several-bin model cannot be effectively analyzed; 5) The creation and modification of the number bin model have no history record, and the change history of the number bin model cannot be traced back; 6) A number bin model is modified, but it is not known which models depend on him, whether there is an impact; 7) It is difficult to use a certain bin model accurately, but it is not known what the granularity, dimension, and measure of the bin model are.
Therefore, the invention provides a system for creating and managing a multi-bin model, so as to at least solve part of the technical problems.
Disclosure of Invention
The invention aims to solve the technical problems that: the system for creating and managing the multi-bin model is provided, the use and management cost of the multi-bin model is reduced, and the retrospective analysis capability of the multi-bin model is improved.
In order to achieve the above purpose, the technical scheme adopted by the invention is as follows:
a system for creating and managing a digital bin model comprises a model creation module, a model modification module, a dimension word degree module, a measurement field module and a model analysis module;
the model creation module is used for creating a number bin model according to the data information to be created, wherein the number bin model comprises a measurement field, a dimension field and the attribute of the number bin model;
the model modification module is used for modifying the created several-bin model;
the dimension word degree module is used for managing dimension fields for creating a multi-bin model;
the measurement field module is used for managing measurement fields for creating a multi-bin model;
the model analysis module is used for analyzing the created several bin models;
the model creation module is respectively connected with a mysql relational database and a Neo4j graph database, wherein the mysql relational database is used for recording and managing creation information of the digital bin model, and the Neo4j graph database is used for constructing and managing a dependency relationship link graph of the created digital bin model and a pre-dependent digital bin model;
the model modification module is respectively connected with a mysql relational database and a Neo4j graph database, the mysql relational database is used for recording and managing modification information of the created several-bin model, a dependency relationship link graph of the modified several-bin model is obtained through the Neo4j graph database, and whether the current modification affects the post-dependent several-bin model is judged based on the dependency relationship link graph.
Further, creating the several bins model includes the steps of:
step A1, inputting a model name of a to-be-created multi-bin model;
a2, respectively selecting a number bin model from a dimension word degree module and a measurement field module to contain a dimension field and a measurement field, and confirming granularity of the dimension field and the measurement field;
a3, selecting attributes of the multi-bin model, including whether an external table, a partition, a storage format, a compression format and a transaction table;
step A4, outputting a first sql statement for creating a multi-bin model;
step A5, calling an API (application program interface) of the HiveServer2 to execute a first sql statement, and creating a corresponding digital bin model in the Hive;
step A6, inputting a preposed dependent number bin model of the current number bin model;
and A7, writing the operations and the information of the steps A1-A5 into a mysql relational database, wherein the operations and the information of the steps A1-A5 are the creation information of the database model.
Further, modifying the created several bins model comprises the steps of:
step B1, inputting a model name of a to-be-modified number bin model, and finding out the to-be-modified number bin model;
step B2, respectively selecting a dimension field and a measurement field to be modified of the modification number bin model from the dimension word degree module and the measurement field module, and confirming granularity of the dimension field and the measurement field;
step B3, outputting a second sql statement for modifying the multi-bin model;
step B4, calling an API interface of the HiveServer2 to execute a second sql statement modification number bin model;
step B5, obtaining a dependency relationship link diagram of the current number-bin model from the Neo4j diagram database, obtaining a number-bin model which is depended on the current number-bin model in a rear-mounted manner from the dependency relationship link diagram, and judging whether the current modification affects the number-bin model which is depended on the rear-mounted manner;
and B6, writing the operations and the information of the steps B1-B5 into a mysql relational database, wherein the operations and the information of the steps B1-B5 are modification information of the database model.
Further, the dimension word degree module is used for creating new construction, inquiry, use and analysis of dimension fields of the multi-bin model.
Further, the metric field module is used for creating new, inquiring, using and analyzing the metric field of the several bin model.
Further, the construction of the dependency link includes the following operations:
firstly, creating a node for each number bin model, and distributing a unique node label for each node;
secondly, marking the dependency relationship between the corresponding nodes of the number bin model with the dependency relationship;
thirdly, constructing all nodes, node labels and corresponding dependency relations into a dependency relation link diagram by using a Neo4j diagram database.
Further, the model analysis module analyzes the created several bin model based on the data of the mysql relational database and the Neo4j graph database.
Further, analyzing the created several bin model includes:
analyzing the number bin model through creator fields of the dimension fields;
analyzing the number bin model through the creation time field of the dimension field;
analyzing the number of the bin models through the number of the bin model modification times;
analyzing the number bin model through the dependency link graph.
Compared with the prior art, the invention has the following beneficial effects:
1. the invention creates, modifies and manages the several-bin model based on the model name, dimension field, measurement field and attribute, thereby greatly reducing the use and management cost of the several-bin model.
2. The invention has standard flow for creating and modifying the database of the mysql relation, records the information of creation and modification, and provides necessary analysis evidence for the retrospective analysis of the database model.
3. The invention solves the problems that the fields in the several bin model are synonymous with the same words and the pain points of the synonymous different words by standardizing and managing the dimension fields and the measurement fields.
4. The invention manages the dependency relationship of the log bin model, and is beneficial to the adjustment of the log bin model and the detection of data flow.
4. The invention realizes analysis of the several-bin models through the created and modified information, dimension fields and measurement fields, is convenient for solving the information of each several-bin model and finding out the problems in time.
Drawings
FIG. 1 is a block diagram of a system of the present invention.
Detailed Description
Term interpretation:
the mysql relational database is a relational database management system.
The Neo4j graph database is a graph database management system.
The sql statement is a structured query language.
HiveServer2 is a service that enables clients to perform queries for hives.
Hive is a Hadoop-based data warehouse tool.
The present invention will be described in further detail with reference to the accompanying drawings, in order to make the objects, technical solutions and advantages of the present invention more apparent. It will be apparent that the described embodiments are only some, but not all, embodiments of the invention. All other embodiments, which can be made by those skilled in the art based on the embodiments of the invention without making any inventive effort, are intended to be within the scope of the invention. Furthermore, the terms "first," "second," and the like are used for descriptive purposes only and are not to be construed as indicating or implying relative importance.
As shown in FIG. 1, the system for creating and managing the multi-bin model provided by the invention comprises a model creation module, a model modification module, a dimension word degree module, a measurement field module and a model analysis module;
the model creation module is used for creating a number bin model according to the data information to be created, wherein the number bin model comprises a measurement field, a dimension field and the attribute of the number bin model;
the model modification module is used for modifying the created several-bin model;
the dimension word degree module is used for managing dimension fields for creating a multi-bin model;
the measurement field module is used for managing measurement fields for creating a multi-bin model;
the model analysis module is used for analyzing the created several bin model.
The invention relates to a system integrating the creation, modification and management of a multi-bin model, wherein the multi-bin model is created through a model creation module, the created multi-bin model is modified through a model modification module, the created multi-bin model is analyzed through a model analysis module, and the measurement field and the dimension field of the created multi-bin model are managed through a dimension character degree module and a measurement field module respectively.
The field is an important component of the several-bin model, and the fields of the existing several-bin model are synonymous with different fields or are synonymous with the same field. For example, there are two fields in the several bins model a, the current explanatory (34,2) command 'bid amount', the composition_number_igcontent 'contract amount', but there are also two fields in the several bins model B, the current explanatory (34,2) command 'performance amount', the composition_cntbigcontent 'contract amount'. The names of fields of the amounts in the bin model a and the bin model B are the same, but the meanings are completely different, namely the same words are not synonymous, while the meanings of the con_num and the con_cnt in the bin model a and the bin model B are the same, but the names of the fields are different, namely the synonymous words are different, and the conditions can cause misuse for the subsequent use of the bin models. The invention manages the dimension word degree and the measurement field of the created number bin model through the dimension word degree module and the measurement field module respectively, namely, whether the meaning and the name of each field exist the same in the dimension word degree module or the measurement field module is checked, if so, the creation cannot be repeated, so that one field corresponds to one meaning, the disagreement can not be generated in the subsequent use, and the whole number bin model is ensured to be more standard and safer.
The present invention divides the fields into a dimension field, which is a field for describing feature or attribute data, and a measure field, which is a field for describing a measure of a feature or attribute and measuring data. Through a dimension field module and a measurement field module, firstly, a more normal number bin model is created; secondly, a user of the bin model inquires through the dimension field and the measurement field, and the used bin model is quickly inquired or the determination of which bin model should be used is helped, so that the use error is avoided.
The model creation module is respectively connected with a mysql relational database and a Neo4j graph database, wherein the mysql relational database is used for recording and managing creation information of a log-bin model, and the Neo4j graph database is used for constructing and managing a dependency relationship link graph of the created log-bin model and a pre-dependent log-bin model;
the model modification module is respectively connected with a mysql relational database and a Neo4j graph database, the mysql relational database is used for recording and managing modification information of the created several-bin model, a dependency relationship link graph of the modified several-bin model is obtained through the Neo4j graph database, and whether the current modification affects the post-dependent several-bin model is judged based on the dependency relationship link graph.
The mysql relational database records and manages the creation information and the modification information of the several-bin model, including what person, what time and what operation is done, so that the omnibearing management ensures the specification and the safety of the several-bin model.
A bin model has a bin model on which it depends, which is a dependent item, and which is a dependent item, also denoted as a pre-dependent bin model, the modification of which may have an impact on the bin model. Also a number bin model has a number bin model depending on it, which number bin model is a dependent item, also denoted as a post-dependent number bin model, which number bin model is a dependent item, and modification of this number bin model may have an influence on the post-dependent number bin model. According to the invention, through newly establishing one number bin model, the number bin model on which the number bin model is pre-dependent is input, so that the dependency relationship of a plurality of number bin models is constructed. The Neo4j graph database is used for storing the dependency relationship among the bin models, the bin models of the whole database are compared with a DAG (directed acyclic graph), each bin model is a node of the DAG, and the relationship among the bin models is the connection line among the nodes. The method comprises the following steps: firstly, creating a node for each number bin model, and distributing a unique node label for each node, wherein the node label is a model name of the corresponding number bin model; secondly, marking the dependency relationship between the corresponding nodes of the number bin model with the dependency relationship; thirdly, constructing all nodes, node labels and corresponding dependency relations into a dependency relation link diagram by using a Neo4j diagram database. Through the dependency relationship link diagram, whether cyclic dependency relationships exist between the several bin models is inquired, namely, all pairs of the several bin models with the cyclic dependency are inquired, and whether one several bin model is a dependency item or a depended item can be checked through traversing all the dependency relationships of the dependency relationship link diagram, so that when a certain follow-up several bin model is modified, the dependent several bin model (a post-dependent several bin model) is quickly acquired, and whether the modification has an influence on the post-dependent several bin model is judged.
The model analysis module of the invention analyzes information, uses and dependency links based on the data of the mysql relational database and the Neo4j graph database, and specific analysis configuration can be set according to actual requirements.
The invention also provides a method of the system for creating and managing the several-bin model, which comprises the steps of creating the several-bin model, modifying the created several-bin model and analyzing the created several-bin model.
The creation of the several bins model comprises the following steps:
step A1, inputting a model name of a to-be-created multi-bin model;
a2, selecting a number bin model to contain a dimension field and a measurement field, and confirming granularity of the dimension field and the measurement field;
a3, selecting attributes of the multi-bin model, including whether an external table, a partition, a storage format, a compression format and a transaction table;
step A4, outputting a first sql statement for creating a multi-bin model;
step A5, calling an API (application program interface) of the HiveServer2 to execute a first sql statement, and creating a corresponding digital bin model in the Hive;
and step A6, inputting a pre-dependent number bin model of the current number bin model.
In step A2, granularity is used to determine what a row in a data table represents, granularity must be declared before a dimension field or a measure field is selected, each dimension field or measure field must be consistent with a defined granularity.
In step A3, when the number bin model is selected from the dimension word degree module and the measurement field module to include the dimension field and the measurement field, the dimension field is in front, and the measurement field is in back. If the selected field does not exist, a new is created in the dimension field module or the measure field module, and the granularity of the created field is confirmed.
In the step A4, a first sql statement for creating the multi-bin model is output and displayed on a page, so that a developer can conveniently check whether the first sql statement is consistent with the required first sql statement or not.
In step A4, it is further required to check in the database whether there is a conflict between the to-be-created several-bin model and the created several-bin model, specifically, to query whether there is a several-bin model with the same model name in the database, and if there is already, not to create or modify the model name of the to-be-created several-bin model.
And (3) writing the operations and the information in the steps A1-A5 into a mysql relational database, namely creating information of the database model.
Modifying the created several bin model comprises the following steps:
step B1, inputting a model name of a to-be-modified number bin model, and finding out the to-be-modified number bin model;
step B2, modifying dimension fields and measurement fields to be modified of the multi-bin model, and confirming granularity of the dimension fields and the measurement fields;
step B3, outputting a second sql statement for modifying the multi-bin model;
step B4, calling an API interface of the HiveServer2 to execute a second sql statement modification number bin model;
and B5, judging whether the current modification affects the number bin model depending on the modified number bin model.
In step B2, the dimension field and the measurement field to be modified of the modification number bin model are selected from the dimension word degree module and the measurement field module respectively, namely, the selected dimension field and measurement field replace the original dimension field and measurement field respectively, and the granularity of the dimension field and measurement field is confirmed.
In step B5, based on the dependency link diagram of the Neo4j graph database, a post-dependent data model of the current number bin model is queried, and whether the current modification affects the post-dependent data model is judged. The query adopts a Cypher query, if the query returns a result, which indicates that the cyclic dependency exists, the returned path can be further checked to know the specific condition of the cyclic dependency.
And (3) writing the operation and information of the step B1-the step B5 into a mysql relational database, namely, modifying information of the database model.
Analysis of the created several bin model includes, but is not limited to, the following:
analyzing the number bin model through creator fields of the dimension fields;
analyzing the number bin model through the creation time field of the dimension field;
analyzing the number of the bin models through the number of the bin model modification times;
analyzing the number bin model through the dependency link graph.
The model analysis module can be analysis software of a third party, such as a report tool FineBI or a graphic tool, and the like, and can be used for making reports or graphs of various analysis dimensions according to mysql relational database and Neo4j graph database data.
Finally, it should be noted that: the above embodiments are merely preferred embodiments of the present invention for illustrating the technical solution of the present invention, and are not limiting, but are not limiting of the scope of the present invention; although the invention has been described in detail with reference to the foregoing embodiments, it will be understood by those of ordinary skill in the art that: the technical scheme described in the foregoing embodiments can be modified or some or all of the technical features thereof can be replaced by equivalents; such modifications and substitutions do not depart from the spirit of the corresponding technical solutions; that is, even though the main design concept and spirit of the present invention is modified or finished in an insubstantial manner, the technical problem solved by the present invention is still consistent with the present invention, and all the technical problems are included in the protection scope of the present invention; in addition, the technical scheme of the invention is directly or indirectly applied to other related technical fields, and the technical scheme is included in the scope of the invention.
Claims (8)
1. The system for creating and managing the digital bin model is characterized by comprising a model creation module, a model modification module, a dimension word degree module, a measurement field module and a model analysis module;
the model creation module is used for creating a number bin model according to the data information to be created, wherein the number bin model comprises a measurement field, a dimension field and the attribute of the number bin model;
the model modification module is used for modifying the created several-bin model;
the dimension word degree module is used for managing dimension fields for creating a multi-bin model;
the measurement field module is used for managing measurement fields for creating a multi-bin model;
the model analysis module is used for analyzing the created several bin models;
the model creation module is respectively connected with a mysql relational database and a Neo4j graph database, wherein the mysql relational database is used for recording and managing creation information of the digital bin model, and the Neo4j graph database is used for constructing and managing a dependency relationship link graph of the created digital bin model and a pre-dependent digital bin model;
the model modification module is respectively connected with a mysql relational database and a Neo4j graph database, the mysql relational database is used for recording and managing modification information of the created several-bin model, a dependency relationship link graph of the modified several-bin model is obtained through the Neo4j graph database, and whether the current modification affects the post-dependent several-bin model is judged based on the dependency relationship link graph.
2. The system for creating and managing a plurality of bin models according to claim 1, wherein the step of creating the plurality of bin models comprises the steps of:
step A1, inputting a model name of a to-be-created multi-bin model;
a2, respectively selecting a number bin model from a dimension word degree module and a measurement field module to contain a dimension field and a measurement field, and confirming granularity of the dimension field and the measurement field;
a3, selecting attributes of the multi-bin model, including whether an external table, a partition, a storage format, a compression format and a transaction table;
step A4, outputting a first sql statement for creating a multi-bin model;
step A5, calling an API (application program interface) of the HiveServer2 to execute a first sql statement, and creating a corresponding digital bin model in the Hive;
step A6, inputting a preposed dependent number bin model of the current number bin model;
and A7, writing the operations and the information of the steps A1-A5 into a mysql relational database, wherein the operations and the information of the steps A1-A5 are the creation information of the database model.
3. The system for creating and managing a plurality of models according to claim 1, wherein the modification of the created plurality of models comprises the steps of:
step B1, inputting a model name of a to-be-modified number bin model, and finding out the to-be-modified number bin model;
step B2, respectively selecting a dimension field and a measurement field to be modified of the modification number bin model from the dimension word degree module and the measurement field module, and confirming granularity of the dimension field and the measurement field;
step B3, outputting a second sql statement for modifying the multi-bin model;
step B4, calling an API interface of the HiveServer2 to execute a second sql statement modification number bin model;
step B5, obtaining a dependency relationship link diagram of the current number-bin model from the Neo4j diagram database, obtaining a number-bin model which is depended on the current number-bin model in a rear-mounted manner from the dependency relationship link diagram, and judging whether the current modification affects the number-bin model which is depended on the rear-mounted manner;
and B6, writing the operations and the information of the steps B1-B5 into a mysql relational database, wherein the operations and the information of the steps B1-B5 are modification information of the database model.
4. The system for creating and managing the multi-bin model according to claim 1, wherein the dimension word degree module is used for creating new, inquiring, using and analyzing dimension fields of the multi-bin model.
5. The system for creating and managing a number bin model of claim 1 wherein the metric field module is configured to create a new, query, use and analyze of the metric field of the number bin model.
6. The system for creating and managing a multi-bin model according to claim 1, wherein the construction of the dependency link comprises the following operations:
firstly, creating a node for each number bin model, and distributing a unique node label for each node;
secondly, marking the dependency relationship between the corresponding nodes of the number bin model with the dependency relationship;
thirdly, constructing all nodes, node labels and corresponding dependency relations into a dependency relation link diagram by using a Neo4j diagram database.
7. The system for creating and managing a multi-bin model according to claim 1, wherein the model analysis module analyzes the created multi-bin model based on data of a mysql relational database and a Neo4j graph database.
8. The system for creating and managing a plurality of models according to claim 1, wherein analyzing the created plurality of models comprises:
analyzing the number bin model through creator fields of the dimension fields;
analyzing the number bin model through the creation time field of the dimension field;
analyzing the number of the bin models through the number of the bin model modification times;
analyzing the number bin model through the dependency link graph.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202410282329.5A CN117874009A (en) | 2024-03-13 | 2024-03-13 | System for creating and managing several warehouse models |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202410282329.5A CN117874009A (en) | 2024-03-13 | 2024-03-13 | System for creating and managing several warehouse models |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN117874009A true CN117874009A (en) | 2024-04-12 |
Family
ID=90581451
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202410282329.5A Pending CN117874009A (en) | 2024-03-13 | 2024-03-13 | System for creating and managing several warehouse models |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN117874009A (en) |
Citations (13)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20060036637A1 (en) * | 2004-08-13 | 2006-02-16 | Mehmet Sayal | System and method for developing a star schema |
| US20070203933A1 (en) * | 2006-02-24 | 2007-08-30 | Iversen Heine K | Method for generating data warehouses and OLAP cubes |
| CN104794244A (en) * | 2015-05-13 | 2015-07-22 | 南京大学 | Method and device for realizing graph conversion based on MongoDB |
| CN104899284A (en) * | 2015-06-05 | 2015-09-09 | 北京京东尚科信息技术有限公司 | Method and device for driving scheduling system based on metadata |
| US20190095471A1 (en) * | 2016-03-21 | 2019-03-28 | Chunyang Liu | Heterogeneous Type Database Storage System based on Optical Disc, and Method for Using System |
| US20190180188A1 (en) * | 2017-12-13 | 2019-06-13 | Cognizant Technology Solutions U.S. Corporation | Evolution of Architectures For Multitask Neural Networks |
| CN110110211A (en) * | 2018-01-22 | 2019-08-09 | 北京京东尚科信息技术有限公司 | Data query method and apparatus based on universal model |
| CN111078766A (en) * | 2019-11-18 | 2020-04-28 | 江苏艾佳家居用品有限公司 | Data warehouse model construction system and method based on multidimensional theory |
| CN114595294A (en) * | 2022-03-11 | 2022-06-07 | 北京梦诚科技有限公司 | Data warehouse modeling and extracting method and system |
| CN115098600A (en) * | 2022-06-21 | 2022-09-23 | 平安普惠企业管理有限公司 | Directed acyclic graph construction method and device for data warehouse and computer equipment |
| CN115544181A (en) * | 2022-10-24 | 2022-12-30 | 广东电网有限责任公司 | Ontology-based automatic data loading method for power grid data mart |
| CN116401325A (en) * | 2023-05-15 | 2023-07-07 | 广州飞狮数字科技有限公司 | Data processing method and device based on data warehouse model |
| CN117573646A (en) * | 2023-11-24 | 2024-02-20 | 焦点科技股份有限公司 | Data management method and system based on dimension modeling |
-
2024
- 2024-03-13 CN CN202410282329.5A patent/CN117874009A/en active Pending
Patent Citations (13)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20060036637A1 (en) * | 2004-08-13 | 2006-02-16 | Mehmet Sayal | System and method for developing a star schema |
| US20070203933A1 (en) * | 2006-02-24 | 2007-08-30 | Iversen Heine K | Method for generating data warehouses and OLAP cubes |
| CN104794244A (en) * | 2015-05-13 | 2015-07-22 | 南京大学 | Method and device for realizing graph conversion based on MongoDB |
| CN104899284A (en) * | 2015-06-05 | 2015-09-09 | 北京京东尚科信息技术有限公司 | Method and device for driving scheduling system based on metadata |
| US20190095471A1 (en) * | 2016-03-21 | 2019-03-28 | Chunyang Liu | Heterogeneous Type Database Storage System based on Optical Disc, and Method for Using System |
| US20190180188A1 (en) * | 2017-12-13 | 2019-06-13 | Cognizant Technology Solutions U.S. Corporation | Evolution of Architectures For Multitask Neural Networks |
| CN110110211A (en) * | 2018-01-22 | 2019-08-09 | 北京京东尚科信息技术有限公司 | Data query method and apparatus based on universal model |
| CN111078766A (en) * | 2019-11-18 | 2020-04-28 | 江苏艾佳家居用品有限公司 | Data warehouse model construction system and method based on multidimensional theory |
| CN114595294A (en) * | 2022-03-11 | 2022-06-07 | 北京梦诚科技有限公司 | Data warehouse modeling and extracting method and system |
| CN115098600A (en) * | 2022-06-21 | 2022-09-23 | 平安普惠企业管理有限公司 | Directed acyclic graph construction method and device for data warehouse and computer equipment |
| CN115544181A (en) * | 2022-10-24 | 2022-12-30 | 广东电网有限责任公司 | Ontology-based automatic data loading method for power grid data mart |
| CN116401325A (en) * | 2023-05-15 | 2023-07-07 | 广州飞狮数字科技有限公司 | Data processing method and device based on data warehouse model |
| CN117573646A (en) * | 2023-11-24 | 2024-02-20 | 焦点科技股份有限公司 | Data management method and system based on dimension modeling |
Non-Patent Citations (1)
| Title |
|---|
| 齐红胤: "物流企业数据仓库的设计与实现", 中国优秀博硕士学位论文全文数据库 (硕士)信息科技辑, no. 3, 15 July 2005 (2005-07-15), pages 138 - 167 * |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN111563368B (en) | Report generation method, report generation device, computer equipment and storage medium | |
| CN112650766B (en) | Database data operation method, system and server | |
| CN112711591B (en) | Data blood margin determination method and device based on field level of knowledge graph | |
| CN111177176A (en) | Data detection method, device and storage medium | |
| CN106649394A (en) | Fusion knowledge base processing method and device and knowledge base management system | |
| US10713152B2 (en) | Automated path generator for optimized application testing | |
| CN113360519B (en) | Data processing method, device, equipment and storage medium | |
| CN110674117A (en) | Data modeling method and device, computer readable medium and electronic equipment | |
| CN114428822A (en) | Data processing method and device, electronic equipment and storage medium | |
| CN114116065A (en) | Method and device for acquiring topological graph data object and electronic equipment | |
| US20170161058A1 (en) | Integration of a catalog application with a monitoring application | |
| US10235100B2 (en) | Optimizing column based database table compression | |
| CN111858236A (en) | Knowledge graph monitoring method and device, computer equipment and storage medium | |
| CN117874009A (en) | System for creating and managing several warehouse models | |
| CN114492324A (en) | Component data statistical method and device | |
| CN114741392A (en) | Data query method and device, electronic equipment and storage medium | |
| CN111325007B (en) | Comment analysis method and terminal for PPTX file | |
| CN112597105A (en) | Processing method of file associated object, server side equipment and storage medium | |
| CN113221528A (en) | Automatic generation and execution method of clinical data quality evaluation rule based on openEHR model | |
| CN112699251A (en) | Data aggregation method and device, electronic equipment and storage medium | |
| CN112596719A (en) | Method and system for generating front-end and back-end codes | |
| CN117648339B (en) | Data exploration method and device, server and storage medium | |
| CN110297651A (en) | The update method and device of the common variable of protocol interface | |
| CN113935301B (en) | Report generation method and device, storage medium and electronic equipment | |
| CN114996319B (en) | Data processing method, device and equipment based on rule engine and storage medium |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination |