CN102467547B - Historical data storage method and device - Google Patents
Historical data storage method and device Download PDFInfo
- Publication number
- CN102467547B CN102467547B CN 201010546371 CN201010546371A CN102467547B CN 102467547 B CN102467547 B CN 102467547B CN 201010546371 CN201010546371 CN 201010546371 CN 201010546371 A CN201010546371 A CN 201010546371A CN 102467547 B CN102467547 B CN 102467547B
- Authority
- CN
- China
- Prior art keywords
- model
- isomorphism
- data
- historical data
- isomorphic
- 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.)
- Active
Links
Images
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention relates to a historical data storage method and a historical data storage device. The method comprises the following steps of: constructing a data dictionary platform, wherein a data dictionary comprises field entity descriptions and table entity descriptions; constructing a data model according to the data dictionary; constructing an isomorphic historical data platform according tothe data dictionary and the data model; and generating historical data according to isomorphic tables, isomorphic models and historical data control logics in the historical data platform, and storing the historical data. By the method and the device, service personnel are only required to perform corresponding regulation in the data dictionary, the data model and the historical data platform to rapidly realize the construction and regulation of historical data tables and table structure entities of the historical data tables and the storage and application of the historical data without professional developers by the construction of the isomorphic tables and the isomorphic models and relationships between isomorphic master and detail tables.
Description
Technical field
The present invention relates to the data sheet technical field, relate in particular to a kind of history data store method and device.
Background technology
At present, storage for the historical data of simple business does not have the uniform platform logic, all is that service logic is write in the program code, finishes professional historical data separately according to different business, if the user will carry out the adjustment of service logic, can only carry out secondary development or program adjustment; When carrying out the data list structure adjustment, there is not unified instrument yet, carry out corresponding list structure adjustment but write SQL statement by the developer; The relation of business datum table and historical business datum table all is to make up in code or write in program by the programmer, does not have unified data entity relationship description.
Based on the problems referred to above, make prior art can't realize structure and the adjustment of the list structure entity of business datum table and historical data table fast, can't realize the storage of the historical data of simple business fast.
Summary of the invention
Fundamental purpose of the present invention is to provide a kind of history data store method and device, is intended to improve the processing speed of historical data.
In order to achieve the above object, the present invention proposes a kind of history data store method, comprising:
Make up the data dictionary platform, described data dictionary comprises: field entity description and table entity description;
Make up data model according to described data dictionary;
According to described data dictionary and data model isomorphism historical data platform;
Generate historical data and storage according to the isomorphism table in the described historical data platform, isomorphic model and historical data steering logic.
Preferably, described step according to data dictionary structure data model comprises:
Model description information is set, and described model description information comprises that model ID, model name, model description, master meter are described, serial number;
The model table is set, and that described model table comprises is newly-increased, modification, deletion, pattern exhibiting table;
Model table relation is set, and described model table relation comprises: model ID, Table I D, master-salve table setting, master-salve table relation arrange, the relationship type setting;
Preferably, described step according to data dictionary and data model isomorphism historical data platform comprises:
Make up the isomorphism table, described isomorphism table comprises isomorphism ID, source Table I D, isomorphism Table I D, the description of isomorphism table;
Make up isomorphic model, described isomorphic model comprises that isomorphism ID, source model ID, source Table I D, isomorphic model ID, isomorphism Table I D, isomorphic model are described, the isomorphism table is described;
Make up the historical data steering logic, described historical data steering logic comprises store control logic and the logic control of historical data.
Preferably, described step according to the isomorphism table in the historical data platform, isomorphic model and historical data steering logic generation historical data and storage comprises:
Obtain described isomorphism table and isomorphic model, according to the setting of described isomorphism table and isomorphic model, determine to carry out the tables of data of history data store;
Obtain the historical data steering logic, according to described historical data steering logic, determine storage control and the logic control information of historical data;
Storage control and logic control information according to described historical data generate corresponding historical data table and historical data and storage.
Preferably, the described step that generates corresponding historical data table and historical data and storage according to storage control and the logic control information of historical data comprises:
The storage control model of judging historical data is simple mode or iteration pattern;
When the storage control model of described historical data is simple mode, obtain the temporal frequency of simple mode;
Make up isomorphism from table according to described temporal frequency;
Write-back dictionary, data model and isomorphism are from the table descriptor;
Shift isomorphism master meter legacy data, the write-back isomorphism is from table;
Increase or revise isomorphism master meter data newly;
Historical data is preserved.
Preferably, the storage control model of described judgement historical data is also to comprise after the step of simple mode or iteration pattern:
When the storage control model of described historical data is iteration pattern, obtain isomorphism from table;
Copy the master meter legacy data, the write-back isomorphism is from table;
Increase or revise isomorphism master meter data newly;
Historical data is preserved.
The present invention also proposes a kind of history data store device, comprising:
Data dictionary makes up module, is used for making up the data dictionary platform, and described data dictionary comprises: field entity description and table entity description;
Data model makes up module, is used for making up data model according to described data dictionary;
Historical data platform isomorphism module is used for according to described data dictionary and data model isomorphism historical data platform;
The history data store module, the isomorphism table, isomorphic model and the historical data steering logic that are used for according to described historical data platform generate historical data and storage.
Preferably, described data model structure module comprises:
Descriptor arranges the unit, is used for arranging model description information, and described model description information comprises that model ID, model name, model description, master meter are described, serial number;
Table arranges the unit, is used for the model table is set, and that described model table comprises is newly-increased, modification, deletion, pattern exhibiting table;
The table relation arranges the unit, is used for arranging model table relation, and described model table relation comprises: model ID, Table I D, master-salve table setting, master-salve table relation arrange, the relationship type setting;
Preferably, described historical data platform isomorphism module comprises:
Isomorphism table construction unit is used for making up the isomorphism table, and described isomorphism table comprises isomorphism ID, source Table I D, isomorphism Table I D, the description of isomorphism table;
The isomorphic model construction unit makes up isomorphic model, and described isomorphic model comprises that isomorphism ID, source model ID, source Table I D, isomorphic model ID, isomorphism Table I D, isomorphic model are described, the isomorphism table is described;
The steering logic construction unit is used for making up the historical data steering logic, and described historical data steering logic comprises store control logic and the logic control of historical data.
Preferably, described history data store module comprises:
The tables of data acquiring unit is used for obtaining described isomorphism table and isomorphic model, according to the setting of described isomorphism table and isomorphic model, determines to carry out the tables of data of history data store;
The steering logic information acquisition unit is used for obtaining the historical data steering logic, according to described historical data steering logic, determines storage control and the logic control information of historical data;
The history data store unit is used for generating corresponding historical data table and historical data and storage according to storage control and the logic control information of described historical data.
Preferably, described history data store unit comprises:
Judgment sub-unit is used for judging that the storage control model of historical data is simple mode or iteration pattern;
The history data store subelement is used for obtaining the temporal frequency of simple mode when the storage control model of described historical data is simple mode; Make up isomorphism from table according to described temporal frequency; Write-back dictionary, data model and isomorphism are from the table descriptor; Shift isomorphism master meter legacy data, the write-back isomorphism is from table; Increase or revise isomorphism master meter data newly; Historical data is preserved.
Preferably, described history data store subelement also is used for obtaining isomorphism from table when the storage control model of described historical data is iteration pattern; Copy the master meter legacy data, the write-back isomorphism is from table; Increase or revise isomorphism master meter data newly; Historical data is preserved.
A kind of history data store method and device that the present invention proposes, by the description to the data structure, make up a database entity description table, on the basis of database description table, make up corresponding data model, the relation of description list inter-entity, in conjunction with data entity descriptor and data object descriptive model, abstract and realize the isomorphism table of data model, make up the logic rules of the historical data of data, in the storing process of historical data, according to the history data store rule that arranges in the historical data platform, realize the history data store of data, do not need to specialize in personnel, the business personnel only needs at data dictionary, data model, adjust accordingly in the historical data platform, can realize the structure of historical data table and storage and the application of historical data fast.
Description of drawings
Fig. 1 is history data store method one embodiment schematic flow sheet of the present invention;
Fig. 2 is the schematic flow sheet that makes up data model among history data store method one embodiment of the present invention according to data dictionary;
Fig. 3 is according to the schematic flow sheet of data dictionary and data model isomorphism historical data platform among history data store method one embodiment of the present invention;
Fig. 4 is the schematic flow sheet that generates historical data and storage among history data store method one embodiment of the present invention according to the isomorphism table in the historical data platform, isomorphic model and historical data steering logic;
Fig. 5 is the schematic flow sheet that generates corresponding historical data table and historical data and storage among history data store method one embodiment of the present invention according to the storage control of historical data and logic control information;
Fig. 6 is history data store device one example structure synoptic diagram of the present invention;
Fig. 7 is the structural representation that data model makes up mould among history data store device one embodiment of the present invention;
Fig. 8 is the structural representation of historical data platform isomorphism module among history data store device one embodiment of the present invention;
Fig. 9 is the structural representation of history data store module among history data store device one embodiment of the present invention;
Figure 10 is the structural representation of history data store unit among history data store device one embodiment of the present invention.
In order to make technical scheme of the present invention clearer, clear, be described in further detail below in conjunction with accompanying drawing.
Embodiment
Solution for embodiment of the invention mainly is by the description to the data structure, make up a database entity description table, on the basis of database description table, make up corresponding data model, the relation of description list inter-entity, in conjunction with data entity descriptor and data object descriptive model, abstract and realize the isomorphism table of data model, make up the logic rules of the historical data of data, in the storing process of data, according to the history data store rule that arranges in the historical data platform, realize the history data store of data.
Implementation method and device with professional historical data in the following specific embodiment mode are that example describes technical solution of the present invention, but are not limited to the situation that data are business datum.
The Relational database term that the embodiment of the invention relates to comprises: data dictionary, isomorphism table, isomorphism master meter, isomorphism are from table and business model.
Data dictionary is the description platform of a data library structure (table, field), can realize showing newly-increased, modification, deletion and related service logic with field;
The isomorphism table refers to one group of data bank service entity list that data structure is identical;
The isomorphism master meter refers to one group of business datum table in the business datum isomorphism table, has only an isomorphism master meter in one group of isomorphism table, and the isomorphism master meter is used for the phylogenetic service data information of storage current business;
Isomorphism refers to one group of historical data table the business datum isomorphism table from table, many isomorphisms can be arranged from table in one group of isomorphism table, and isomorphism is mainly used in storing historical business datum from table;
Business model mainly is to remove to describe the data structuring model of a complete business function from the aspect of business.
The database entity that the embodiment of the invention relates to comprises: data structure description list, business model table and professional historical data description list, wherein:
The data structure description list comprises:
HRMS_Table: table information is described, and is used for descriptive data base entity list information;
HRMS_Fields: the field information description list is used for descriptive data base literary name segment information;
Above-mentioned two tables are mainly used in the stored data base entity, and the information of table and field of finishing is described, and comprises title explanation, data structure show and phase related control information.
The business model table comprises:
HR_Base_Model: the Business Entity table is used for describing the business model that makes up;
HR_Base_Table: traffic table is used for describing business model and comprises how many database table entities;
HR_Base_Reference: the traffic table related information, for the incidence relation of describing the business model traffic table;
Above-mentioned three tables, the main table that comprises in the business model that makes up and the business model and the relation between the table described makes up the data structure of a tables of data set from the aspect of business.
Professional historical data description list comprises:
HR_Base_SameStructTable: isomorphism table description list, be used for describing business datum table and historical data table, make up isomorphism master-salve table relation;
HR_Base_HistoryRule: historical data table control law table, for the control law of describing the historical data table;
Above-mentioned two tables are mainly used in making up the historical data platform, describe business datum table and the isomorphism master slave relation of historical data table and the steering logic rule of professional historical data table.
As shown in Figure 1, one embodiment of the invention proposes a kind of history data store method, comprising:
Step S101 makes up the data dictionary platform;
In the present embodiment, data dictionary comprises: field entity description and table entity description; The field entity description comprises that field information is described and the field control information is described; Field information is described and to be comprised: field name, table name claim, field classification, field type, field length, field precision, whether allow for sky, serial number, default value, whether lock, whether built-in; Described table entity description information comprises that table information is described and the table control information is described; Described table information is described and is comprised that table name claims, table physical name, table classification, whether built-in table, major key field setting, the setting of table type, whether allow new field, whether allow to revise field, whether be locking list, whether be the isomorphism table.
Structure by field entity description and table entity description information, finished complete descriptor and the control information of database entity (list structure), generate real physical database entity description table record, above-mentioned these descriptor essential records are in two database tables of HRMS_Table, HRMS_Fields, constitute a data dictionary platform, can realize showing newly-increased, modification, deletion and related service logic with field.
Step S102 makes up data model according to data dictionary;
In the present embodiment, data model is specially business data model, and as mentioned above, business model mainly is to remove to describe the data structuring model of a complete business function from the aspect of business, and it has the function of following three parts:
1, business model is described: comprise that business model ID, business model title, business model are described, master meter is described, serial number;
2, the business model table arranges: arrange and comprise which table and field in the business model; That the business model table comprises is newly-increased, modification, deletion, pattern exhibiting table etc.
3, business model table relation arranges: business model is set comprises relation between the table; Business model table relation comprises: business model ID, traffic table ID, master-salve table setting, master-salve table relation arrange, the relationship type setting.
Step S103 is according to data dictionary and data model isomorphism historical data platform;
In the present embodiment, data model is specially business data model, and isomorphism historical data platform comprises structure isomorphism traffic table, isomorphism business model and historical data steering logic, wherein:
Make up the isomorphism table that the isomorphism traffic table refers to make up a table, the isomorphism traffic table comprises: isomorphism ID, and source Table I D, isomorphism Table I D, the isomorphism table is described;
Make up the isomorphism table that the isomorphism business model refers to make up by business model many tables, the isomorphism business model comprises: isomorphism ID, and source business model ID, source Table I D, isomorphism business model ID, isomorphism Table I D, the isomorphism business model is described, the isomorphism table is described;
Make up store control logic and service logic control that the historical data steering logic refers to arrange historical data, wherein the storage control model of historical data comprises: simple mode and iteration pattern.
Span was divided the historical data table between simple mode referred on time, and is as shown in table 1 below, to employee's wage tables of data on time between span divide the historical data table, wherein temporal frequency can be week, the moon, season, half a year, year, accounting period or self-defined cycle etc.Be characterized in dividing by the time dimension, the business datum in the certain hour cycle shifts the formation historical data automatically.
Table 1
In the above-mentioned table 1, attribute 1 is employee's name; Attribute 2 is year; During attribute 3 was, attribute 4 was basic wage; Attribute 5 is bonus.
Iteration pattern refers to the change by data attribute, be historical data with original business datum iteration, new change becomes the change of the attribute of business datum, and is as shown in table 2 below, be characterized in carrying out the iteration store historical data according to service needed, it is the historical data of time point.
Table 2
Step S104 generates historical data and storage according to the isomorphism table in the historical data platform, isomorphic model and historical data steering logic.
In the present embodiment, the isomorphism table is specially the isomorphism traffic table, and isomorphic model is specially the isomorphism business model.
When historical data is stored, at first need from the historical data platform, to obtain isomorphism traffic table and isomorphism business model, according to the setting of isomorphism traffic table and isomorphism business model, define which business datum table and need carry out professional history data store.Obtain the historical data steering logic again, according to the historical data steering logic, determine storage control and the service logic control information of professional historical data, generate corresponding professional historical data table and professional historical data according to storage control and the service logic control information of the professional historical data of determining.
As shown in Figure 2, step S102 comprises:
Step S1021 arranges model description information;
For professional historical data, model description information is the business model descriptor, and this business model descriptor comprises that business model ID, business model title, business model are described, master meter is described, serial number;
Step S1022 arranges the model table;
For professional historical data, the model table is the business model table, and that this business model table comprises is newly-increased, modification, deletion, pattern exhibiting table;
Step S1023 arranges model table relation.
For professional historical data, model table relation is specially business model table relation, and this business model table relation comprises: business model ID, traffic table ID, master-salve table setting, master-salve table relation arrange, the relationship type setting;
As shown in Figure 3, step S103 comprises:
Step S1031 makes up the isomorphism table;
For professional historical data, the isomorphism table is specially the isomorphism traffic table, and this isomorphism traffic table comprises isomorphism ID, source Table I D, isomorphism Table I D, the description of isomorphism table;
Step S1032 makes up isomorphic model;
For professional historical data, isomorphic model is specially the isomorphism business model, and this isomorphism business model comprises that isomorphism ID, source business model ID, source Table I D, isomorphism business model ID, isomorphism Table I D, isomorphism business model are described, the isomorphism table is described;
Step S1033 makes up the historical data steering logic;
For professional historical data, the historical data steering logic comprises store control logic and the service logic control of historical data.
As shown in Figure 4, step S104 comprises:
Step S1041 obtains isomorphism table and isomorphic model, according to the setting of isomorphism table and isomorphic model, determines to carry out the tables of data of history data store;
Step S1042 obtains the historical data steering logic, according to the historical data steering logic, determines storage control and the logic control information of historical data;
Logic control information is specifically as follows the service logic control information.
Step S1043 generates corresponding historical data table and historical data and storage according to the storage control of historical data and logic control information.
As shown in Figure 5, step S1043 comprises:
Step S10431 judges that the storage control model of historical data is simple mode or iteration pattern, if simple mode then enters step S10432, if iteration pattern then enters step S10438;
Step S10432 obtains the temporal frequency of simple mode;
Step S10433 makes up isomorphism from table according to temporal frequency;
Step S10434, write-back dictionary, data model and isomorphism are from the table descriptor;
Step S10435 shifts isomorphism master meter legacy data, and the write-back isomorphism is from table;
Step S10436, newly-increased or modification isomorphism master meter data;
Step S10437 preserves historical data;
Step S10438 obtains isomorphism from table;
Step S10439 copies isomorphism master meter legacy data, and the write-back isomorphism is from table; Enter step S10436.
Present embodiment makes up a database entity description table by the description to the data structure, on the basis of database entity description list, makes up corresponding business model, realizes structure and the adjustment of the list structure entity of business datum table and historical data table fast; Relation by the description list inter-entity, in conjunction with data entity descriptor and business object descriptive model, abstract and realize the isomorphism table of business model, make up the service logic rule of the historical data of business datum, in the storing process of business datum, according to the history data store rule that arranges in the historical data platform, realize the history data store of business datum fast.
As shown in Figure 6, one embodiment of the invention proposes a kind of history data store device, comprising: data dictionary makes up module 601, data model makes up module 602 historical data platform isomorphism module 603 and history data store modules 604, wherein:
Data dictionary makes up module 601, is used for making up the data dictionary platform, and data dictionary comprises: field entity description information and table entity description information;
In the present embodiment, data dictionary comprises: field entity description and table entity description; The field entity description comprises that field information is described and the field control information is described; Field information is described and to be comprised: field name, table name claim, field classification, field type, field length, field precision, whether allow for sky, serial number, default value, whether lock, whether built-in; Table entity description information comprises that table information is described and the table control information is described; Table information is described and to be comprised that table name claims, table physical name, table classification, whether built-in table, major key field setting, the setting of table type, whether allow new field, whether allow to revise field, whether be locking list, whether be the isomorphism table.
Structure by field entity description and table entity description information, finished complete descriptor and the control information of database entity (list structure), generate real physical database entity description table record, above-mentioned these descriptor essential records are in two database tables of HRMS_Table, HRMS_Fields, constitute a data dictionary platform, can realize showing newly-increased, modification, deletion and related service logic with field.
Data model makes up module 602, is used for making up data model according to data dictionary;
In the present embodiment, data model is specially business data model, and as mentioned above, business model mainly is to remove to describe the data structuring model of a complete business function from the aspect of business, and it has the function of following three parts:
1, business model is described: comprise that business model ID, business model title, business model are described, master meter is described, serial number;
2, the business model table arranges: arrange and comprise which table and field in the business model; That the business model table comprises is newly-increased, modification, deletion, pattern exhibiting table etc.
3, business model table relation arranges: business model is set comprises relation between the table; Business model table relation comprises: business model ID, traffic table ID, master-salve table setting, master-salve table relation arrange, the relationship type setting.
Historical data platform isomorphism module 603 is used for according to data dictionary and data model isomorphism historical data platform;
In the present embodiment, data model is specially business data model, and isomorphism historical data platform comprises structure isomorphism traffic table, isomorphism business model and historical data steering logic, wherein:
Make up the isomorphism table that the isomorphism traffic table refers to make up a table, the isomorphism traffic table comprises: isomorphism ID, and source Table I D, isomorphism Table I D, the isomorphism table is described;
Make up the isomorphism table that the isomorphism business model refers to make up by business model many tables, the isomorphism business model comprises: isomorphism ID, and source business model ID, source Table I D, isomorphism business model ID, isomorphism Table I D, the isomorphism business model is described, the isomorphism table is described;
Make up store control logic and service logic control that the historical data steering logic refers to arrange historical data, wherein the storage control model of historical data comprises: simple mode and iteration pattern.
Span was divided the historical data table between simple mode referred on time, and wherein temporal frequency can be week, the moon, season, half a year, year, accounting period or self-defined cycle etc.Be characterized in dividing by the time dimension, the business datum in the certain hour cycle shifts the formation historical data automatically.
Iteration pattern refers to the change by data attribute, is historical data with original business datum iteration, and new change becomes the change of the attribute of business datum, is characterized in carrying out the iteration store historical data according to service needed, and it is the historical data of time point.
History data store module 604, the isomorphism table, isomorphic model and the historical data steering logic that are used for according to the historical data platform generate historical data and storage.
In the present embodiment, the isomorphism table is specially the isomorphism traffic table, and isomorphic model is specially the isomorphism business model.
When historical data is stored, at first need from the historical data platform, to obtain isomorphism traffic table and isomorphism business model, according to the setting of isomorphism traffic table and isomorphism business model, define which business datum table and need carry out professional history data store.Obtain the historical data steering logic again, according to the historical data steering logic, determine storage control and the service logic control information of professional historical data, generate corresponding professional historical data table and professional historical data according to storage control and the service logic control information of the professional historical data of determining.
As shown in Figure 7, data model makes up 602 of moulds and comprises: descriptor arranges unit 6021, unit 6022 is set table and the table relation arranges unit 6023, wherein:
Descriptor arranges unit 6021, be used for arranging model description information, for professional historical data, model description information is the business model descriptor, and this business model descriptor comprises that business model ID, business model title, business model are described, master meter is described, serial number;
Table arranges unit 6022, is used for the model table is set, and for professional historical data, the model table is the business model table, and that this business model table comprises is newly-increased, modification, deletion, pattern exhibiting table;
The table relation arranges unit 6023, be used for arranging model table relation, for professional historical data, model table relation is specially business model table relation, and this business model table relation comprises: business model ID, traffic table ID, master-salve table setting, master-salve table relation arrange, the relationship type setting;
As shown in Figure 8, historical data platform isomorphism module 603 comprises: isomorphism table construction unit 6031, isomorphic model construction unit 6032, steering logic construction unit 6033, wherein:
Isomorphism table construction unit 6031 is used for making up the isomorphism table, and for professional historical data, the isomorphism table is specially the isomorphism traffic table, and this isomorphism traffic table comprises isomorphism ID, source Table I D, isomorphism Table I D, the description of isomorphism table;
Isomorphic model construction unit 6032, make up isomorphic model, for professional historical data, isomorphic model is specially the isomorphism business model, and this isomorphism business model comprises that isomorphism ID, source business model ID, source Table I D, isomorphism business model ID, isomorphism Table I D, isomorphism business model are described, the isomorphism table is described;
Steering logic construction unit 6033 is used for making up the historical data steering logic, and for professional historical data, described historical data steering logic comprises store control logic and the service logic control of historical data.
As shown in Figure 9, history data store module 604 comprises: tables of data acquiring unit 6041, steering logic information acquisition unit 6042 and history data store unit 6043, wherein:
Tables of data acquiring unit 6041 is used for obtaining isomorphism table and isomorphic model, according to the setting of isomorphism table and isomorphic model, determines to carry out the tables of data of history data store;
Steering logic information acquisition unit 6042 is used for obtaining the historical data steering logic, according to the historical data steering logic, determines storage control and the logic control information of historical data;
In the present embodiment, logic control information is specially the service logic control information.History data store unit 6043 is used for generating corresponding historical data table and historical data and storage according to storage control and the logic control information of historical data.
As shown in figure 10, history data store unit 6043 comprises: judgment sub-unit 60431 and history data store subelement 60432, wherein:
History data store subelement 60432 is used for obtaining the temporal frequency of simple mode when the storage control model of historical data is simple mode; Make up isomorphism from table according to temporal frequency; Write-back dictionary, data model and isomorphism are from the table descriptor; Shift isomorphism master meter legacy data, the write-back isomorphism is from table; Increase or revise isomorphism master meter data newly; Historical data is preserved.
Further, history data store subelement 60432 also is used for obtaining isomorphism from table when the storage control model of historical data is iteration pattern; Copy isomorphism master meter legacy data, the write-back isomorphism is from table; Increase or revise isomorphism master meter data newly, and historical data is preserved.
Embodiment of the invention history data store method and device, by the description to the data structure, make up a database entity description table, on the basis of database description table, make up corresponding model, the relation of description list inter-entity, in conjunction with data entity descriptor and data object descriptive model, abstract and realize the isomorphism table of data model, make up the logic rules of the historical data of data, in the storing process of historical data, according to the history data store rule that arranges in the historical data platform, realize the history data store of data, do not need to specialize in personnel, the business personnel only needs at data dictionary, data model, adjust accordingly in the historical data platform, can realize the structure of historical data table and storage and the application of historical data fast.
The above only is the preferred embodiments of the present invention; be not so limit claim of the present invention; every equivalent structure or flow process conversion that utilizes instructions of the present invention and accompanying drawing content to do; or directly or indirectly be used in other relevant technical field, all in like manner be included in the scope of patent protection of the present invention.
Claims (10)
1. a history data store method is characterized in that, comprising:
Make up the data dictionary platform, described data dictionary comprises: field entity description and table entity description;
Make up data model according to described data dictionary;
According to described data dictionary and data model isomorphism historical data platform; Specifically comprise: make up the isomorphism table, described isomorphism table comprises isomorphism ID, source Table I D, isomorphism Table I D, the description of isomorphism table; Make up isomorphic model, described isomorphic model comprises that isomorphism ID, source model ID, source Table I D, isomorphic model ID, isomorphism Table I D, isomorphic model are described, the isomorphism table is described; Make up the historical data steering logic, described historical data steering logic comprises store control logic and the logic control of historical data;
Generate historical data and storage according to the isomorphism table in the described historical data platform, isomorphic model and historical data steering logic.
2. method according to claim 1 is characterized in that, described step according to data dictionary structure data model comprises:
Model description information is set, and described model description information comprises that model ID, model name, model description, master meter are described, serial number;
The model table is set, and that described model table comprises is newly-increased, modification, deletion, pattern exhibiting table;
Model table relation is set, and described model table relation comprises: model ID, Table I D, master-salve table setting, master-salve table relation arrange, the relationship type setting.
3. method according to claim 2 is characterized in that, described step according to the isomorphism table in the historical data platform, isomorphic model and historical data steering logic generation historical data and storage comprises:
Obtain described isomorphism table and isomorphic model, according to the setting of described isomorphism table and isomorphic model, determine to carry out the tables of data of history data store;
Obtain the historical data steering logic, according to described historical data steering logic, determine storage control and the logic control information of historical data;
Storage control and logic control information according to described historical data generate corresponding historical data table and historical data and storage.
4. method according to claim 3 is characterized in that, the described step that generates corresponding historical data table and historical data and storage according to storage control and the logic control information of historical data comprises:
The storage control model of judging historical data is simple mode or iteration pattern;
When the storage control model of described historical data is simple mode, obtain the temporal frequency of simple mode;
Make up isomorphism from table according to described temporal frequency;
Write-back dictionary, data model and isomorphism are from the table descriptor;
Shift isomorphism master meter legacy data, the write-back isomorphism is from table;
Increase or revise isomorphism master meter data newly;
Historical data is preserved.
5. method according to claim 4 is characterized in that, the storage control model of described judgement historical data is that the step of simple mode or iteration pattern also comprises afterwards:
When the storage control model of described historical data is iteration pattern, obtain isomorphism from table;
Copy the master meter legacy data, the write-back isomorphism is from table;
Increase or revise isomorphism master meter data newly;
Historical data is preserved.
6. a history data store device is characterized in that, comprising:
Data dictionary makes up module, is used for making up the data dictionary platform, and described data dictionary comprises: field entity description and table entity description;
Data model makes up module, is used for making up data model according to described data dictionary;
Historical data platform isomorphism module is used for according to described data dictionary and data model isomorphism historical data platform; Described historical data platform isomorphism module comprises: isomorphism table construction unit, be used for making up the isomorphism table, and described isomorphism table comprises isomorphism ID, source Table I D, isomorphism Table I D, the description of isomorphism table; The isomorphic model construction unit is used for making up isomorphic model, and described isomorphic model comprises that isomorphism ID, source model ID, source Table I D, isomorphic model ID, isomorphism Table I D, isomorphic model are described, the isomorphism table is described; The steering logic construction unit is used for making up the historical data steering logic, and described historical data steering logic comprises store control logic and the logic control of historical data;
The history data store module, the isomorphism table, isomorphic model and the historical data steering logic that are used for according to described historical data platform generate historical data and storage.
7. device according to claim 6 is characterized in that, described data model makes up module and comprises:
Descriptor arranges the unit, is used for arranging model description information, and described model description information comprises that model ID, model name, model description, master meter are described, serial number;
Table arranges the unit, is used for the model table is set, and that described model table comprises is newly-increased, modification, deletion, pattern exhibiting table;
The table relation arranges the unit, is used for arranging model table relation, and described model table relation comprises: model ID, Table I D, master-salve table setting, master-salve table relation arrange, the relationship type setting.
8. device according to claim 7 is characterized in that, described history data store module comprises:
The tables of data acquiring unit is used for obtaining described isomorphism table and isomorphic model, according to the setting of described isomorphism table and isomorphic model, determines to carry out the tables of data of history data store;
The steering logic information acquisition unit is used for obtaining the historical data steering logic, according to described historical data steering logic, determines storage control and the logic control information of historical data;
The history data store unit is used for generating corresponding historical data table and historical data and storage according to storage control and the logic control information of described historical data.
9. device according to claim 8 is characterized in that, described history data store unit comprises:
Judgment sub-unit is used for judging that the storage control model of historical data is simple mode or iteration pattern;
The history data store subelement is used for obtaining the temporal frequency of simple mode when the storage control model of described historical data is simple mode; Make up isomorphism from table according to described temporal frequency; Write-back dictionary, data model and isomorphism are from the table descriptor; Shift isomorphism master meter legacy data, the write-back isomorphism is from table; Increase or revise isomorphism master meter data newly; Historical data is preserved.
10. device according to claim 9 is characterized in that, described history data store subelement also is used for obtaining isomorphism from table when the storage control model of described historical data is iteration pattern; Copy the master meter legacy data, the write-back isomorphism is from table; Increase or revise isomorphism master meter data newly; Historical data is preserved.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN 201010546371 CN102467547B (en) | 2010-11-16 | 2010-11-16 | Historical data storage method and device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN 201010546371 CN102467547B (en) | 2010-11-16 | 2010-11-16 | Historical data storage method and device |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN102467547A CN102467547A (en) | 2012-05-23 |
| CN102467547B true CN102467547B (en) | 2013-10-09 |
Family
ID=46071190
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN 201010546371 Active CN102467547B (en) | 2010-11-16 | 2010-11-16 | Historical data storage method and device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN102467547B (en) |
Families Citing this family (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105095457B (en) * | 2015-07-28 | 2019-08-09 | 驰众信息技术（上海）有限公司 | History data store management method |
| CN108681674B (en) * | 2018-04-23 | 2022-02-01 | 平安科技（深圳）有限公司 | Report module creating method and device, computer device and storage medium |
| CN110795430A (en) * | 2019-10-25 | 2020-02-14 | 新奥数能科技有限公司 | Data storage method and system |
| CN113220802A (en) * | 2021-05-28 | 2021-08-06 | 山东英信计算机技术有限公司 | Data processing method and system for large data volume under relational database |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US5881378A (en) * | 1990-08-31 | 1999-03-09 | Fujitsu Limited | Device accessing a database using one of old definition information and new definition information based on an access request |
| CN101673287A (en) * | 2009-10-16 | 2010-03-17 | 金蝶软件（中国）有限公司 | SQL sentence generation method and system |
| CN101794299A (en) * | 2010-01-27 | 2010-08-04 | 浪潮(山东)电子信息有限公司 | Method for increment definition and processing of historical data management |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JP3280660B2 (en) * | 2000-06-30 | 2002-05-13 | 尾州木材工業株式会社 | Method of manufacturing laminated processed wood and veneer with aligned annual rings |
-
2010
- 2010-11-16 CN CN 201010546371 patent/CN102467547B/en active Active
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US5881378A (en) * | 1990-08-31 | 1999-03-09 | Fujitsu Limited | Device accessing a database using one of old definition information and new definition information based on an access request |
| CN101673287A (en) * | 2009-10-16 | 2010-03-17 | 金蝶软件（中国）有限公司 | SQL sentence generation method and system |
| CN101794299A (en) * | 2010-01-27 | 2010-08-04 | 浪潮(山东)电子信息有限公司 | Method for increment definition and processing of historical data management |
Non-Patent Citations (1)
| Title |
|---|
| JP特开2002-11706A 2002.01.15 |
Also Published As
| Publication number | Publication date |
|---|---|
| CN102467547A (en) | 2012-05-23 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| Aumueller et al. | Schema and ontology matching with COMA++ | |
| US20190340163A1 (en) | Managing changes to information | |
| CN112364094A (en) | Visual modeling method, device and medium for data warehouse | |
| US11615076B2 (en) | Monolith database to distributed database transformation | |
| CN109271685A (en) | A kind of Urban renewal date storage method and device based on BIM | |
| CN105677625B (en) | Processing method is made a report in the collaboration of multi-layer collect statistics report | |
| CN110023925A (en) | It generates, access and display follow metadata | |
| CN102467547B (en) | Historical data storage method and device | |
| Roelofs | AIMMS 3. 10 Language Reference | |
| Wang et al. | Cleanix: A parallel big data cleaning system | |
| CN107885788A (en) | A kind of business datum check method | |
| CN108959515A (en) | Original data guard method, medium, device and calculating equipment | |
| Gui et al. | IFC-based partial data model retrieval for distributed collaborative design | |
| CN117033460B (en) | Automatic data model construction system and method based on bus matrix | |
| CN110209668A (en) | Dimension table correlating method, device, equipment and readable storage medium storing program for executing based on stream calculation | |
| CN103477321B (en) | Creating benchmark graph data | |
| CN110490761A (en) | A kind of power grid distribution net equipment account data model modelling approach | |
| EP2691881A2 (en) | Finding a data item of a plurality of data items stored in a digital data storage | |
| CN110414124A (en) | A kind of analysis method and device of model component file similarity | |
| Ouared et al. | Metricstore repository: on the leveraging of performance metrics in databases | |
| Jovanovic et al. | Ore: An iterative approach to the design and evolution of multi-dimensional schemas | |
| Long et al. | Object-Oriented Database for Managing Building Modeling Components and Metadata | |
| CN108121780A (en) | Data Analysis Model determines method and device | |
| Gil | Intelligent workflow systems and provenance-aware software | |
| Lano et al. | Optimising model-transformations using design patterns |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C14 | Grant of patent or utility model | ||
| GR01 | Patent grant |