Recherche Images Maps Play YouTube Actualités Gmail Drive Plus »
Connexion
Les utilisateurs de lecteurs d'écran peuvent cliquer sur ce lien pour activer le mode d'accessibilité. Celui-ci propose les mêmes fonctionnalités principales, mais il est optimisé pour votre lecteur d'écran.

Brevets

  1. Recherche avancée dans les brevets
Numéro de publicationCN103514295 A
Type de publicationDemande
Numéro de demandeCN 201310471385
Date de publication15 janv. 2014
Date de dépôt10 oct. 2013
Date de priorité10 oct. 2013
Autre référence de publicationCN103514295B
Numéro de publication201310471385.5, CN 103514295 A, CN 103514295A, CN 201310471385, CN-A-103514295, CN103514295 A, CN103514295A, CN201310471385, CN201310471385.5
Inventeurs冯卫勇, 吴卫荣, 刘玉龙, 张权, 刘燕伟, 白思杰, 耿宏宇, 李思昊, 王燕, 陶安
Déposant中国电子科技集团公司第十五研究所
Exporter la citationBiBTeX, EndNote, RefMan
Liens externes:  SIPO, Espacenet
Method and device for archiving historical data
CN 103514295 A
Résumé
The invention discloses a method for archiving historical data. The method for archiving the historical data comprises the steps of (1) extracting the historical data matched with a task to be edited from a whole historical database containing data which are collected, are stored and are related to tasks; (2) editing the extracted historical data, and forming archived historical data; (3) setting a task identification for the archived historical data, and storing the archived historical data with the task identification on a preset task archived historical database. When the method for archiving the historical data is applied, the access speed of the historical data of the task can be increased.
Revendications(10)  Langue du texte original : Chinois
1.一种历史数据归档方法,该方法包括: 从采集并存储的包含了与各任务相关数据的整体历史数据库中,提取与待编辑任务相匹配的历史数据; 对提取的历史数据进行编辑并形成归档历史数据; 为归档历史数据设置任务标识,并将设置有任务标识的归档历史数据存储到预先设置的任务归档历史数据库中。 A historical data archiving, the method comprising: collecting and storing from the history database and includes the whole data in each task, the task to be edited is extracted and matched historical data; extracted historical data can be edited and forming archiving historical data; for archiving historical data set task identity, and is provided with an archive of historical data storage tasks identified pre-set to the task of archiving historical database.
2.根据权利要求1所述的方法,其中,所述提取的历史数据包括:预操作数据、与所述预操作数据关联的预操作从属数据、条件数据;其中, 所述预操作数据为当前待编辑任务所需进行更新维护操作的数据; 所述预操作从属数据为与当前待编辑任务相关,且随所述预操作数据的改变而变化的数据; 所述条件数据为与当前待编辑任务相关,但无需进行更新的数据。 2. The method of claim 1, wherein the extracted history data comprising: a pre-operation data, the pre-operation with the slave data associated with the pre-operation data, condition data; wherein, the pre-operating data for the current editing tasks needed to be updated to maintain the operation of the data; the pre-operation dependent data associated with the current task to be edited, and with the pre-change operation data and changing data; the condition data for the current task to be edited correlation, but without the need for updated data.
3.根据权利要求2所述的方法,其中,在所述提取与待编辑任务相匹配的历史数据之前,同时或之后,所述方法进一步包括: 为待编辑任务设置任务标识及任务编辑时间段; 构建包含任务标识栏、预操作数据栏、与预操作数据关联的预操作从属数据栏以及条件数据栏的任务数据关系表; 在所述对提取的历史数据进行编辑形成归档历史数据之前,所述方法进一步包括:将所述为待编辑任务设置的任务标识写入任务数据关系表中的任务标识栏,并根据待编辑任务、任务标识以及与待编辑任务的相匹配历史数据之间的对应关系,将所述提取的历史数据写入任务数据关系表中的相应栏。 3. The method according to claim 2, wherein, in which prior to the extraction and editing tasks to be matched historical data, or after, the method further comprises: for editing tasks to be set the task to identify the time period and the task editor ; Build tab contains the task, the task of data pre-operating subordinate relational table data fields pre-operational data fields, data associated with the pre-operation and condition data column; the formation of archived historical data before editing extracted historical data, the the method further comprising: the writing task data in relational tables tasks tab for the task to identify the task set to be edited, and according to edit tasks, task identity and task to be edited with the corresponding match between the historical data relationship, will be written the history of the extracted data task data in relational tables corresponding column.
4.根据权利要求3所述的方法,其中,所述对提取的历史数据进行编辑并形成归档历史数据,具体为, 在待编辑任务的编辑时间段内,对任务历史数据表中与为待编辑任务设置的任务标识对应的预操作数据进行更新维护; 根据预操作数据的改变更新预操作从属数据。 4. The method of claim 3, wherein, the historical data of the extracted editing and archiving historical data is formed, specifically, to be edited in the editing task period, the historical data of the table and the task is to be Task identity editing tasks set corresponding pre-operation data updating and maintenance; update data based on the pre-change operation dependent pre-operational data.
5.根据权利要求4所述的方法,其中,所述归档历史数据包括:任务数据关系表中已完成更新维护的预操作数据、根据预操作数据的改变而作出相应更新的预操作从属数据,以及条件数据。 5. The method according to claim 4, wherein, the historical data archive comprising: task data in relational tables have been updated to maintain the pre-operation data, the operation data according to the change of the pre-made pre-operation of the slave data updated, and condition data.
6.根据权利要求4所述的方法,其中,在所述对提取的历史数据进行编辑并形成归档历史数据之后,该方法包括: 为已编辑的历史数据分别建立预操作数据备份表、预操作从属数据备份表及条件数据备份表;其中, 所述预操作数据备份表用于存储已编辑的历史数据中的预操作数据,并设置有与当前待编辑任务相应的任务标识; 所述预操作从属数据备份表用于存储已编辑的历史数据中的预操作从属数据,并设置有与当前待编辑任务相应的任务标识; 所述条件数据备份表用于存储已编辑的历史数据中的条件数据,并设置有与当前待编辑任务相应的任务标识。 6. The method of claim 4, wherein, after the extracted history data for editing and archiving historical data is formed, the method comprising: for historical data edited data backup operation establishing a pre-table, respectively, the pre-operation table and condition dependent data backup data backup table; wherein the pre-operation history data tables are used to store data backup edited the pre-operation data, and provided with the current task to edit the corresponding task ID; the pre-operation Dependent Data Backup table for storing historical data in the pre-edited slave operation data and settings have to be edited with the current task to identify the appropriate task; the condition table for historical data backup data storage conditions in the edited data and be provided with current editing task to identify the appropriate task. 进一步地,将所述预操作数据备份表、所述从属数据备份表及所述条件数据备份表存储到预先设置的任务归档历史数据库中。 Further, the pre-table operation data backup, the backup sheet and the slave data backup condition data table stored in the job archive preset historical database.
7.根据权利要求5所述的方法,其中,在所述为归档历史数据设置任务标识,并将设置有任务标识的归档历史数据存储到预先设置的任务归档历史数据库中之后,该方法进一步包括: 接收以任务标识表示的任务历史数据查询请求,并根据接收的任务标识从任务归档历史数据库中筛选出与任务标识对应的归档历史数据。 7. The method of claim 5, wherein, in the data set for the historical archive task ID and the task ID is provided with the historical data stored in the archive after task archives history database set in advance, the method further comprising : historical data query request receiving task to task ID represented and documented historical database with the task of screening to identify corresponding archiving historical data from the task according to the task identifier received.
8.一种历史数据归档装置,其特征在于,该装置包括:任务数据管理模块、归档数据更新模块、任务历史数据存储模块;其特征在于, 所述任务数据管理模块,用于从采集并存储的包含了与各待编辑任务相关数据的整体历史数据库中,提取与待编辑任务相匹配的历史数据; 所述归档数据更新模块,用于对由所述任务数据管理模块提取的历史数据进行编辑并形成归档历史数据; 所述任务历史数据存储模块,用于为由所述归档数据更新模块形成的归档历史数据设置任务标识,并将设置有任务标识的归档历史数据存储到预先设置的任务归档历史数据库中。 A historical data archiving means, characterized in that, the apparatus comprising: a mission data management module, the archive data updating module, the task history data storage means; wherein said task data management module for collecting and storing from contains the whole history database editing tasks associated with the data to be extracted with the task to be edited to match the historical data; the archive data updating module, for the task data by the extracted history data management module for editing and forming archiving historical data; the task history data storage means for archiving historical data provided by the task ID archived data update module is formed, and includes a task identification data stored in the job archive historical archive set in advance history database.
9.根据权利要求8所述的装置,其特征在于,所述提取的历史数据包括:预操作数据、与所述预操作数据关联的预操作从属数据,以及条件数据;其中, 所述预操作数据为当前待编辑任务所需进行更新维护操作的数据; 所述预操作从属数据为与当前待编辑任务相关,且随所述预操作数据的改变而变化的数据; 所述条件数据为与当前待编辑任务相关,但无需进行更新的数据。 9. The apparatus according to claim 8, characterized in that the extracted history data comprising: a pre-operation data, the pre-operation with the slave data associated with the pre-operation data, and the condition data; wherein, the pre-operation Data for the current editing tasks needed to be updated to maintain the operation of the data; the pre-operation dependent data associated with the current task to edit and change the operating data with the pre-change data; the data for the current condition to edit task dependencies, but without the need for updated data.
10.根据权利要求9所述的装置,其特征在于,所述任务数据管理模块进一步用于为待编辑任务设置任务标识及任务编辑时间段;构建包含任务标识栏、预操作数据栏、预操作从属数据栏以及条件数据栏的任务数据关系表; 将为待编辑任务设置的任务标识写入任务数据关系表中的任务标识栏,并根据待编辑任务、任务标识以及与待编辑任务相匹配的历史数据之间的对应关系,将所述提取的历史数据写入任务数据关系表中的相应栏。 10. The apparatus of claim 9, wherein, wherein said task data management module is further used for editing tasks to be set the task to identify and task editing period; construct contains the task tab, pre-operational data bars, pre-operation Dependent data field and task condition data table column data relationships; editing tasks will be set the task of identification data in relational tables Writing Tasks tab of the task, and the task to be edited according to the task to identify and editing tasks and to be matched corresponding relationship between historical data, writing the history data extracted mission data in relational tables corresponding column.
Description  Langue du texte original : Chinois

历史数据归档方法及历史数据归档装置 Historical data archiving methods and historical data archiving device

技术领域 FIELD

[0001] 本发明涉及信息技术领域,尤其涉及一种历史数据归档方法及历史数据归档装置。 [0001] The present invention relates to the field of information technology, particularly to a method and historical data archiving historical data archiving device.

背景技术 BACKGROUND

[0002] 实际应用中,金融、通讯等行业需要建立关系数据库应用系统,通过整体历史数据库来实时记录大量的数据,同时,往往为了满足某一任务需求,需要对预先存储的整体数据中与任务相关的资料进行更新维护。 [0002] practical applications, finance, telecommunications and other industries need to build a relational database applications, through the whole history database to record large amounts of data in real time, at the same time, often in order to meet the needs of a particular task, you need the whole data stored in the task relevant information to be updated to maintain. 例如,对于一个大型的功能系统模块,在运行该功能系统模块时,会对该功能系统模块的所有性能指标参数进行实时记录,而所有实时记录的性能指标参数构成整体历史数据;而为了进行一项关于在X条件下性能指标Y对于性能指标Z的影响研究,需要对与该研究相关的数据进行编辑。 For example, for a large functional system modules, when you run the function of the system module, will carry out all the functions of the system performance parameters of real-time recording module, and all performance parameters in real time, constitutes the entire history of recorded data; and in order to carry out a items on conditions of performance indicators in the X-Y for the performance index Z of research, the need for data associated with the study for editing.

[0003] 现有,在待编辑任务开始之后,对当前时刻包含了各待编辑任务相关数据的整体数据中与任务相关的资料进行编辑更新,在任务结束时,将已编辑的整体数据作为整体历史数据归档存储到整体历史数据库中,其中,已编辑的整体数据包括与任务相关的数据以及与任务无关的数据。 [0003] existing, to be edited after the start of the task of the present time include the overall data for each task-related data to be edited in task-related information for editing update at the end of the task, the overall data has been edited as a whole historical data archive storage to the overall history of the database, which has been edited overall data, including data related to the task, and the task-independent data. 由于在不同的时间段为满足不同的任务需求会产生不同的整体历史数据,因此,可以根据执行该任务的编辑时间段建立索引信息,用以对产生的不同的历史整体数据作出区分。 Since different time periods to meet the needs of different tasks will produce different overall historical data, therefore, may be indexed based on the execution time of the task of editing, for the whole of different historical data generated to distinguish.

[0004] 这种基于任务资料更新的历史数据归档方法,需要占用较大的存储空间来存储这些不同时间段产生的整体历史数据;而且,产生的整体历史数据中与任务无关的数据存在重复存储的问题,造成了存储空间的浪费。 [0004] This task-based updating of historical data archiving method, you need to occupy a larger overall storage space to store historical data generated by these different time periods; moreover, the whole history of the data generated in the task-independent data storage duplicate The problem, resulting in a waste of storage space. 另一方面,当需要获取某一历史时间段内满足任务需求并与任务相关的任务历史数据时,必须根据与该历史时间段相应的索引信息从整体历史数据库中获取相应的整体历史数据,然后,遍寻整个获取的整体历史数据,从中筛选出该历史时间段内满足任务需求并与任务相关的任务历史数据,存在任务历史数据访问速度慢的问题。 On the other hand, when you need to get a certain historical period to meet the mission requirements and tasks related to the task of historical data, you must obtain the appropriate data from the whole history of the whole history of the database based on the historical time period corresponding index information, and then overall historical data anywhere to be found throughout the acquisition, which filter out the historical time period to meet the mission requirements and tasks related to the task of historical data, there is a task of historical data access speed slow.

[0005] 为解决存储空间浪费的问题,现有提出在对整体数据中与任务相关的数据进行更新维护之后,将与任务相关的且进行更新维护的数据单独归档存储,形成历史更新数据;在不同时间段内,为满足不同的任务需求会产生不同的历史更新数据,因此,可以通过添加时间戳或记录编号等标识信息对不同的历史更新数据作出区分。 [0005] In order to solve the problem of wasted storage space, made after the existing data in the overall data associated with the task to update the maintenance, the task-related maintenance and updating of data stored in a separate filing, formation history update data; in different time periods, in order to meet the needs of different tasks will have different histories update data, so you can add a timestamp or record number and other identifying information to make a distinction between different historical update data. 该改进的技术方案,虽然解决了与任务无关的数据的重复存储问题,但在需要获取某一历史时间段内满足任务需求并与任务相关的任务历史数据时,需根据标识信息获取该历史时间段内更新维护的并与任务相关的历史更新数据;同时需从历史整体数据库中调取同一历史时间段内的整体历史数据,获取与任务相关但未进行更新的历史数据,这样才能准确完整地获取该历史时间段内所有与任务相关的任务历史数据。 When the improved technical solutions, solves the problem of duplicate data storage and task-independent, but need to get a certain historical period to meet the mission requirements and tasks related to the task of historical data, the need to obtain the history of time based on the identification information update and maintain the inner segment and the history associated with the task to update the data; while overall demand retrieval of historical data in the same database as a whole historical period of history, but did not get the update task-related historical data, so as to accurately and completely Get all the historical period related tasks and tasks of historical data. 当需要获取不同历史时间段的数据时,则需要在不同的历史更新数据与整体数据之间频繁访问,造成任务历史数据访问速度慢。 When you need to get data from different historical periods, you need frequent access between different historical data and update the overall data, resulting in the task of historical data access speed.

发明内容[0006] 本发明的实施例提供一种历史数据归档方法,能够提高任务历史数据访问速度。 SUMMARY OF THE INVENTION [0006] Embodiments of the present invention there is provided a method of historical data archiving, it is possible to improve the task history data access speed.

[0007] 根据本发明的另一方面,本发明实施例还提供了一种历史数据归档装置,能够提高任务历史数据访问速度。 [0007] According to another aspect of the invention, embodiments of the present invention also provides a historical data archiving means, possible to improve the task history data access speed.

[0008] 为达到上述目的,本发明实施例提供的一种历史数据归档方法,该方法包括: [0008] To achieve the above object, the present invention is a method of archiving historical data provided by the embodiment, the method comprises:

[0009] 从采集并存储的包含了与各待编辑任务相关数据的整体历史数据库中,提取与待编辑任务相匹配的历史数据; [0009] From the collected and stored comprising the whole history database editing tasks associated with the data to be extracted with the task to be edited to match the historical data;

[0010] 对提取的历史数据进行编辑并形成归档历史数据; [0010] The extracted data can be edited and the formation of the historical archive of historical data;

[0011] 为归档历史数据设置任务标识,并将设置有任务标识的归档历史数据存储到预先设置的任务归档历史数据库中。 [0011] for archiving historical data set the task to identify and set a mission logo archive of historical data stored in the archive task preset historical database.

[0012] 较佳地,所述提取的历史数据包括:预操作数据、与所述预操作数据关联的预操作从属数据、条件数据;其中, [0012] Preferably, the extracted history data comprising: a pre-operation data, the data associated with the pre-operation of the pre-operation dependent data, condition data; wherein,

[0013] 所述预操作数据为当前待编辑任务所需进行更新维护操作的数据; [0013] The operating data for the current pre-editing tasks needed to be updated to maintain the operation of the data;

[0014] 所述预操作从属数据为与当前待编辑任务相关,且随所述预操作数据的改变而变化的数据; [0014] The pre-operation dependent data associated with the current task to be edited, and with the pre-operational data changes and changes in the data;

[0015] 所述条件数据为与当前待编辑任务相关,但无需进行更新的数据。 [0015] The condition data is associated with the current task to be edited, but without the need for updated data.

[0016] 较佳地,在所述提取与待编辑任务相匹配的历史数据之前、同时或之后,所述方法进一步包括: [0016] Preferably, prior to the extraction and the task to be edited to match the historical data, simultaneously with or after, the method further comprising:

[0017] 为待编辑任务设置任务标识及任务编辑时间段; [0017] to be set the task to identify and editing tasks Task Editor period;

[0018] 构建包含任务标识栏、预操作数据栏、与预操作数据关联的预操作从属数据栏以及条件数据栏的任务数据关系表; [0018] construct contains the task tab, pre-operational data column, the data associated with the pre-operation data pre-operation task bar, and condition data dependent data columns of relational tables;

[0019] 在所述对提取的历史数据进行编辑形成归档历史数据之前,所述方法进一步包括: Before [0019] in the extracted history data editing history data archiving is formed, the method further comprising:

[0020] 将所述为待编辑任务设置的任务标识写入任务数据关系表中的任务标识栏,并根据待编辑任务、任务标识以及与待编辑任务的相匹配历史数据之间的对应关系,将所述提取的历史数据写入任务数据关系表中的相应栏。 [0020] the task set for the task to be edited to write the task to identify the relationship between the data in the table identifies the task bar and task to be edited according to the task to be edited with the mission to identify and match the corresponding relationship between the historical data, writing the history data extracted mission data in relational tables corresponding column.

[0021] 较佳地,所述对提取的历史数据进行编辑并形成归档历史数据,具体为, [0021] Preferably, the extracted history data for editing and archiving historical data is formed, specifically,

[0022] 在待编辑任务的编辑时间段内,对任务历史数据表中与为待编辑任务设置的任务标识对应的预操作数据进行更新维护; [0022] In the period to be edited editing tasks, tasks and tasks of historical data table editing tasks to be identified as corresponding to the pre-set data update maintenance operations;

[0023] 根据预操作数据的改变更新预操作从属数据。 [0023] According to the pre-change operation to update the data pre-operation dependent data.

[0024] 较佳地,所述归档历史数据包括:任务数据关系表中已完成更新维护的预操作数据、根据预操作数据的改变而作出相应更新的预操作从属数据,以及条件数据。 [0024] Preferably, the archived historical data include: task data in relational tables have been updated to maintain the pre-operation data, in accordance with changes in the pre-operational data and make the appropriate updates pre-operation dependent data, and condition data.

[0025] 较佳地,在所述对提取的历史数据进行编辑并形成归档历史数据之后,在所述形成归档历史数据之前,该方法包括: [0025] Preferably, after the extracted history data for editing and archiving historical data is formed, prior to the formation of archiving historical data, the method comprising:

[0026] 为已编辑的历史数据分别建立预操作数据备份表、预操作从属数据备份表及条件数据备份表;其中, [0026] for the historical data were edited to establish a pre-operational data backup table, pre-operating condition dependent data backup data backup tables and tables; which,

[0027] 所述预操作数据备份表用于存储已编辑的历史数据中的预操作数据,并设置有与当前待编辑任务相应的任务标识; [0027] The pre-operation history data tables are used to store data backup edited the pre-operation data, and provided with the current task to edit the corresponding task ID;

[0028] 所述预操作从属数据备份表用于存储已编辑的历史数据中的预操作从属数据,并设置有与当前待编辑任务相应的任务标识;[0029] 所述条件数据备份表用于存储已编辑的历史数据中的条件数据,并设置有与当前待编辑任务相应的任务标识。 [0028] The pre-operation history data table used to store data backup slave edited the pre-operation dependent data, and provided with the current task to edit the corresponding task ID; [0029] The condition table for data backup Historical data is stored in the edited condition data, and provided with the current task to edit the corresponding task ID.

[0030] 进一步地,将所述预操作数据备份表、所述从属数据备份表及所述条件数据备份表存储到预先设置的任务归档历史数据库中。 [0030] Further, the pre-table operation data backup, the backup sheet and the slave data backup condition data table stored in the job archive preset historical database.

[0031] 较佳地,在所述为归档历史数据设置任务标识,并将设置有任务标识的归档历史数据存储到预先设置的任务归档历史数据库中之后,该方法进一步包括: After [0031] Preferably, in the data set for the historical archive task ID, and includes a task identification data stored in the job archive historical archive preset historical database, the method further comprising:

[0032] 接收以任务标识表示的任务历史数据查询请求,并根据接收的任务标识从任务归档历史数据库中筛选出与任务标识对应的归档历史数据。 [0032] The task of historical data query request is received to indicate the task to identify and filter out the archive historical database and archiving historical data to identify the corresponding task from the task according to the task identifier received.

[0033] 根据本发明的另一方面,还提供了一种历史数据归档装置,该装置包括:任务数据管理模块、归档数据更新模块、任务历史数据存储模块;其中, [0033] According to another aspect of the present invention, there is also provided a historical data filing apparatus, the apparatus comprising: a mission data management module, the archive data updating module, the task history data storage means; wherein,

[0034] 所述任务数据管理模块,用于从采集并存储的包含了与各待编辑任务相关数据的整体历史数据库中,提取与待编辑任务相匹配的历史数据; [0034] The task of the data management module is used to contain the whole history database associated with the task to be edited from the data collected and stored, extracts the task to be edited to match the historical data;

[0035] 所述归档数据更新模块,用于对由所述任务数据管理模块提取的历史数据进行编辑并形成归档历史数据; [0035] The archived data updating module, for extracting data from the task management module and form editing historical data archiving historical data;

[0036] 所述任务历史数据存储模块,用于为由所述归档数据更新模块形成的归档历史数据设置任务标识,并将设置有任务标识的归档历史数据存储到预先设置的任务归档历史数据库中。 [0036] The task of historical data storage module for archiving historical data set the task to identify the grounds of the archived data update module form, and has the task of setting the historical archive database archiving historical data storage tasks identified in the pre-set .

[0037] 较佳地,所述提取的历史数据包括:预操作数据、与预操作数据关联的预操作从属数据、条件数据;其中, [0037] Preferably, the extraction of historical data include: pre-operational data, the slave data and pre-operational data associated with the pre-operation condition data; wherein,

[0038] 所述预操作数据为当前待编辑任务所需进行更新维护操作的数据; [0038] The operating data for the current pre-editing tasks needed to be updated to maintain the operation of the data;

[0039] 所述预操作从属数据为与当前待编辑任务相关,且随所述预操作数据的改变而变化的数据; [0039] The pre-operation dependent data associated with the current task to be edited, and with the pre-operational data changes and changes in the data;

[0040] 所述条件数据为与当前待编辑任务相关,但无需进行更新的数据。 [0040] The condition data is associated with the current task to be edited, but without the need for updated data.

[0041] 较佳地,所述任务数据管理模块进一步用于为待编辑任务设置任务标识及任务编辑时间段;构建包含任务标识栏、预操作数据栏、预操作从属数据栏以及条件数据栏的任务数据关系表; [0041] Preferably, the task of data management module is further used for editing tasks to be set the task to identify and task editing period; construct contains the task tab, pre-operational data field, pre-operating condition dependent data columns and columns of data task data relational tables;

[0042] 将为待编辑任务设置的任务标识写入任务数据关系表中的任务标识栏,并根据待编辑任务、任务标识以及与待编辑任务相匹配的历史数据之间的对应关系,将所述提取的历史数据写入任务数据关系表中的相应栏。 [0042] will be the task of editing tasks set identification task writes data in a relational table identifies the task bar, and according to the corresponding relation to edit tasks, task identity and historical data to be matched between editing tasks will the referred to extract historical data write task data in relational tables corresponding column.

[0043] 由上述技术方案可见,本发明实施例提供的一种历史数据归档方法以及历史数据归档装置,通过将预先存储的整体数据中与待编辑任务相关的所有历史数据部署给该待编辑任务,并对与该待编辑任务相关的历史数据进行更新维护,形成归档历史数据;为归档历史数据设置任务标识,并作为任务历史数据存储到任务归档历史数据库中,这样,就实现了整体数据与任务历史数据的分离。 [0043] can be seen from the above technical solutions, as well as a method of historical data archiving historical data archiving device according to an embodiment of the present invention, will be deployed by all historical data previously stored in the overall data to be edited and tasks related to the task to be edited , and editing tasks to be associated with the historical data to be updated to maintain form archiving historical data; for archiving historical data set task identity, and historical data is stored as a task to the task of archiving historical database, so that to achieve the overall data separation task of historical data. 当需要查询或获取某一历史时间段内满足任务需求并与任务相关的任务历史数据时,可以通过任务标识,从任务归档历史数据库中直接筛选出与该任务对应的任务历史数据,而无需访问整体历史数据库,访问速度快。 When you need to check or obtain a certain historical period to meet the mission requirements and tasks associated with the task of historical data, you can identify by the task, the task archives from the historical database with the task of screening task corresponding historical data, without having to visit overall historical database access speed.

附图说明 Brief Description

[0044] 为了更清楚地说明本发明实施例或现有技术中的技术方案,以下将对实施例或现有技术描述中所需要使用的附图作简单地介绍。 [0044] In order to more clearly illustrate the prior art embodiment or aspect of the practice of this invention, the following embodiments reference will be made in the described embodiments or the prior art need to use brief. 显而易见地,以下描述中的附图仅仅是本发明的一些实施例,对于本领域普通技术人员而言,还可以根据这些附图所示实施例得到其它的实施例及其附图。 Apparently, the drawings in the following description are only some embodiments of the present invention, those of ordinary skill, can also obtain other drawings according to the embodiment and the embodiment shown in these drawings.

[0045] 图1为本发明实施例历史数据归档方法流程示意图。 [0045] Figure 1 is a schematic invention historical data archiving process flow diagram of the implementation.

[0046]图2为本发明实施例历史数据归档装置结构示意图。 [0046] Figure 2 is a schematic configuration example of a schematic view of the historical data filing apparatus embodiment.

具体实施方式 DETAILED DESCRIPTION

[0047]以下将结合附图对本发明各实施例的技术方案进行清楚、完整的描述,显然,所描述的实施例仅仅是本发明的一部分实施例,而不是全部的实施例。 [0047] Hereinafter, with reference to the present invention according to various embodiments be clear, complete description of the embodiment, obviously, only a part of the described embodiment of the present invention, but not all embodiments. 基于本发明中的实施例,本领域普通技术人员在没有做出创造性劳动的前提下所得到的所有其它实施例,都属于本发明所保护的范围。 Based on the embodiments of the present invention, all other embodiments to those of ordinary skill in memory without making creative labor obtained, are within the scope of protection of the present invention.

[0048] 现有将与任务相关的数据进行更新维护后的整体数据作为整体历史数据存储到整体历史数据库中,存在浪费存储空间及任务历史数据访问速度慢的问题;即使采用改进的技术方案把与任务相关的数据进行更新维护后的更新数据作为历史更新数据进行单独存储,虽然解决了存储空间浪费问题,但由于需结合历史更新数据与整体数据才能获取完整的任务历史数据,仍然存在任务历史数据访问速度慢的问题。 Overall data [0048] existing data associated with the task to update the maintenance history as a whole after the data is stored into the whole history database, there is a waste of storage space and slow task of historical data access issues; even with improved technology solutions to Data associated with the task to update the data maintenance update after update as historical data is stored separately, although the solution to the waste storage problem, but because of the need to update the data and the overall combination of historical data in order to obtain the full task of historical data, there remains the task of history the problem of slow data access.

[0049] 本发明实施例提供的历史数据归档方法,在任务开始之前,将预先存储的整体数据中与任务相关的所有历史数据部署给该任务。 [0049] historical data archiving method according to an embodiment of the present invention, before the task is started, all the historical data previously stored in the overall data associated with the task of deploying to the task. 然后,在该待编辑任务执行期间,可以对历史数据进行更新维护,形成归档历史数据;当任务结束时,为归档历史数据设置任务标识,并将设置了任务标识的归档历史数据作为任务历史数据存储到任务归档历史数据库中,这样,实现了整体数据与任务历史数据的分离。 Then, during the execution of the task to be edited, you can update and maintain historical data, forming an archive of historical data; when the end of the task, the task set for archiving historical data to identify and set up an archive of historical data to identify the task as a task of historical data stored in the historical database archiving tasks, so to achieve a separation of data and the overall mission of historical data. 在需要获取某一历史时间段内满足任务需求并与任务相关的历史数据时,可以直接通过任务标识,从任务归档历史数据库中筛选出与该任务对应的任务历史数据,访问速度快。 When meet mission requirements and the need to obtain a certain historical period historical data associated with the task, the task can be identified directly from the task history database archiving selected task and the task corresponding historical data access speed.

[0050] 图1为本发明实施例历史数据归档方法流程示意图。 [0050] Figure 1 is a schematic invention historical data archiving process flow diagram of the implementation. 在根据任务需求对预先存储的整体数据中与任务相关的数据进行更新维护之前,较佳地,预先在数据库系统中构建任务表以及任务数据关系表;其中, According to the task before the overall demand for data stored in the data associated with the task to update the maintenance, preferably, pre-built task list and task data in a relational table in the database system; which,

[0051] 构建的任务表中包括任务标识栏、起始时间栏以及终止时间栏,用于存储与各项任务对应的任务标识以及任务的编辑时间段;当然,也可以将起始时间栏及终止时间栏整合成编辑时间段栏; [0051] constructed in the task list includes tasks tab, start time and end time field fence for storing various tasks corresponding task identity and task of editing time; of course, you can also start the time bar and termination time bar integrated into the editing time bar;

[0052] 构建任务与数据的关系表,即任务数据关系表,其中,任务数据关系表中包括任务标识栏、数据栏,用于存储与各项待编辑任务对应的任务标识,以及与当前待编辑任务相关的数据。 [0052] build tasks and data to relational tables, that task data relational tables, which task data in relational tables including identification task bar, the data field for storing the various tasks to be edited corresponding task identity, and to be with the current data editing task.

[0053] 本发明实施例中,预先存储的整体数据可以由不同的共享数据表及共享数据关系表组成,其中,共享数据关系表中存储的数据随共享数据表中数据的改变而改变。 Embodiment [0053] In the present invention, the overall data can be stored in advance by different shared data and shared data relation table tables, wherein data sharing the data stored in relational tables in the shared data with the changes in the data table is changed.

[0054] 例如,整体数据由共享数据表A、共享数据表B以及共享数据关系表C组成;其中,共享数据表A中由数据Ai (i=l、2、3、4……)组成,共享数据表B中由数据Bj (j=l、2、3、4......)组成;共享数据关系表C中由数据Cn (n=l、2、3、4......)组成。 [0054] For example, the overall data by a shared data table A, table B shared data and shared data relation table C the composition; wherein the shared data by the data in Table A Ai (i = l, 2,3,4 ......) composition, shared data from the data in Table B Bj (j = l, 2,3,4 ......) composition; sharing of data by the data in relational tables C Cn (n = l, 2,3,4 .... ..) components.

[0055] 其中,假设当共享数据表A中的数据Al发生改变时,共享数据关系表C中的数据Cl将随数据Al的变化而产生相应的改变;[0056] 当共享数据表B中的数据B2发生改变时,共享数据关系表C中的数据C2将随数据B2的变化而产生相应的改变; [0055] wherein, when the data is assumed that the shared data in Table A Al changed, data sharing data in relational tables C Al Cl will change with a corresponding change in the data generated; [0056] When the shared data in Table B When data B2 changes, the shared data in the relational table data C C2 and B2 will change with data to produce the corresponding change;

[0057] 当共享数据表A中添加或删除数据A3,则共享数据关系表C将相应的添加或删除数据C3 ; [0057] When the shared data in Table A to add or delete data A3, the shared data in a relational table C will add or remove data corresponding C3;

[0058] 当共享数据表A中的数据A2、A4,和/或,共享数据表B中的数据B1、B3发生改变时,共享数据关系表C中的数据不发生改变。 [0058] When data is shared data in Table A A2, A4, and / or sharing of data in the data table B B1, B3 changes, the shared data in the relational table change data C does not occur.

[0059] 本发明实施例中,需进行数据维护的任务可以以T表示,如第一任务表示为Tl,起始时间为2013年8月I日,终止时间为2013年8月5日;第二任务表示为T2,起始时间为2013年8月8日,终止时间为2013年8月20日。 [0059] In embodiments of the invention, the need for data maintenance tasks can be expressed in T, as the first task is represented as Tl, the start time for the August 2013 I day, ending time for August 5, 2013; the first two tasks represented as T2, the start time for the August 8, 2013, the termination time for August 20, 2013. 则建立的相应的任务表中可以包括:第一任务的任务标识Tl以及第一任务的起始时间2013.08.01,以及终止时间2013.08.05,或第一任务的编辑时间段2013.08.01-2013.08.05 ;第二任务标识T2以及第二任务的起始时间2013.08.08,以及终止时间2013.08.20,或第二任务的编辑时间段2013.08.08-2013.08.20。 Corresponding task table is created may include: edit period start time of the first task and the first task Tl identification task 2013.08.01, 2013.08.05 and the end time, or the first task 2013.08.01-2013.08 .05; editing time start time of the second task and the second task of identification T2 2013.08.08, 2013.08.20 and end time, or the second task 2013.08.08-2013.08.20.

[0060] 进一步地,假设在整体数据中与第一任务Tl相关的数据包括共享数据表A中的A1、A2、A3、A4,共享数据表B中的B1、B2、B3 ;因此共享数据关系表C中的数据C1、C2、C3也与第一任务Tl相关,而整体数据中,如共享数据表A中的数据A5、A6等,共享数据表中的数据B4、B5等均为与第一任务Tl无关的数据。 [0060] Further, it is assumed in the overall data associated with the first task Tl data include shared data in Table A, A1, A2, A3, A4, shared data table B in B1, B2, B3; therefore share data relationships Table C data C1, C2, C3 are also associated with the first task Tl, and the overall data, such as shared data in Table A data A5, A6, etc., sharing data in the table data B4, B5, and so are the first a task Tl-independent data. 这样,建立的相应的任务数据关系表中可以包括:第一任务的任务标识Tl以及与任务相关的数据Al、A2、A3、A4、B1、B2、B3、Cl、C2、C3,其中,数据Al、A3及B2为第一任务Tl预执行更新维护的数据,数据A2、A4、B1、B3为与第一任务Tl相关但不需进行更新维护的数据。 Thus, the corresponding task relation table established data may include: a first task with the task ID and the task-related Tl data Al, A2, A3, A4, B1, B2, B3, Cl, C2, C3, wherein the data Al, A3 and B2 for the first task Tl preactuator update maintenance data, A2, A4, B1, B3 is associated with the first task Tl but do not need to be updated to maintain the data.

[0061] 如图1所示,本发明实施例提供的历史数据归档方法包括: Historical data archiving method provided by [0061] As shown in Figure 1, the present invention comprises:

[0062] 步骤101,从采集并存储的包含了各待编辑任务相关数据的整体历史数据库中,提取与待编辑任务相匹配的历史数据; [0062] Step 101, from the collection and storage of a whole with a database containing all relevant data to be edited in the task, the task to be edited is extracted and matched historical data;

[0063] 本步骤中,从整体历史数据库中提取的与当前待编辑任务相匹配的历史数据包括:预操作数据、与预操作数据关联的预操作从属数据、条件数据;其中, [0063] In this step, extracted from the whole history of the database with the current task to be edited to match the historical data include: pre-operational data, operational data associated with the pre-pre-operation dependent data, condition data; which,

[0064] 预操作数据为当前待编辑任务所需进行维护或删除等更新维护操作的数据; [0064] Pre-operational data to be edited for the current maintenance tasks required to update or delete data maintenance operations;

[0065] 预操作从属数据为与当前待编辑任务相关,且随预操作数据的改变而变化的数据; [0065] Pre-Operational dependent data associated with the current task to be edited, and with changes in the pre-operational data and changing data;

[0066] 条件数据为与当前待编辑任务相关,但无需进行更新的数据。 [0066] condition data associated with the current task to be edited, but without the need for updated data.

[0067] 例如,从存储的整体历史数据库中筛选出与第一任务Tl相关的数据:共享数据表A中的A1、A2、A3、A4,共享数据表B中的B1、B2、B3以及共享数据关系表C中的数据C1、C2、C3。 [0067] For example, screening a whole history database stored in the first task Tl relevant data: the shared data in Table A, A1, A2, A3, A4, shared data table B in B1, B2, B3 and share Data relation Table C data C1, C2, C3. 其中,预操作数据是指数据Al、A3及B2 ;预操作从属数据是指数据Cl、C2、C3,而条件数据是指数据A2、A4、B1、B3。 Wherein, the pre-operation data refers to data Al, A3 and B2; pre-operating slave data refers to data Cl, C2, C3, and the condition data refers to data A2, A4, B1, B3.

[0068] 较佳地,本发明实施例中,在提取与待编辑任务相匹配的历史数据之前,同时或之后,该方法进一步还可以包括: [0068] Preferably, the embodiment of the present invention, prior to extraction with the task to be edited to match the historical data, simultaneously with or after, the method further may include:

[0069] 为待编辑任务设置任务标识及任务编辑时间段; [0069] to be set the task to identify and editing tasks Task Editor period;

[0070] 构建包含任务标识栏、预操作数据栏、与预操作数据关联的预操作从属数据栏以及条件数据栏的任务数据关系表; [0070] construct contains the task tab, pre-operational data column, the data associated with the pre-operation data pre-operation task bar, and condition data dependent data columns of relational tables;

[0071] 在对提取的历史数据进行编辑形成归档历史数据之前,该方法进一步包括:将为待编辑任务设置的任务标识写入任务数据关系表中的任务标识栏,并根据待编辑任务、任务标识以及与待编辑任务的相匹配历史数据之间的对应关系,将提取的历史数据写入任务数据关系表中的相应栏。 [0071] Prior to extract historical data can be edited to form an archive of historical data, the method further comprising: editing tasks will be set the task to identify the data in relational tables Writing Tasks tab of the task, and the task to be edited according to the task identification as well as the task to be edited to match the corresponding relationship between the historical data, the extracted data is written to the historical task data in relational tables corresponding column.

[0072] 具体地,可以在预先构建的任务表中添加与当前待编辑任务对应的任务标识及任务编辑时间段并将当前编辑任务的起始时间及终止时间以编辑时间段的方式存储到编辑时间段栏中。 [0072] In particular, you can add pre-built in the task list to be edited with the current task corresponding task ID and task editing time and the start time and end time of the current editing task to edit the storage period to edit time bar.

[0073] 本发明实施例中,任务是指一次活动,该活动涉及预先存储的整体数据中的部分数据,并需对涉及的部分数据中的某些数据进行更新维护。 [0073] In embodiments of the invention, the task means one activity that involves the whole data stored in the part of the data, and the need on the part of the data involved in the maintenance of some of the data to be updated. 其中,每一次活动对应一个任务标识及活动编辑时间段,这样,每一个任务对应一个任务标识、任务编辑时间段,例如第一任务表示为Tl,起始时间为2013年8月I日,终止时间为2013年8月5日,则将第一任务的任务标识Tl以及第一任务的编辑时间段2013.08.01-2013.08.05分别写入任务表中的相应栏。 Where every activity corresponds to a task ID and active editor periods, so that each task corresponds to a task identity, task editing time periods, for example, the first task is represented as Tl, the start time for the August 2013 I date, termination Time for August 5, 2013, will be the first task of the task to identify the time period Tl and editing tasks 2013.08.01-2013.08.05 first tasks are written form to the appropriate column. 实际应用中,通过在任务表中记录待编辑任务的任务标识、任务起始时间以及任务结束时间,便于后续应用中,用户可以通过任务标识或编辑时间段来查询并获取与执行的任务相关的任务历史数据。 Practical application, to be edited by the task in the task table identifies the record task, the task start time and end time mission to facilitate the subsequent application, the user can query and get through the task ID or editing periods associated with the task execution Task historical data.

[0074] 本发明实施例中,预先构建的任务数据关系表中的数据栏可以拆分为预操作数据栏、预操作数据关联的预操作数据从属栏以及条件数据栏。 Implementation [0074] The present invention, the task data in relational tables prebuilt data fields can be split into a pre-selected operating data, pre-operation data pre-operation data and the conditions associated with the dependent column data field. 这样,就完成了与当前任务相关的数据的任务部署。 This completes the task with the current deployment of data-related tasks.

[0075] 本发明实施例中,将与第一任务Tl相关的数据:A1、A2、A3、A4、B1、B2、B3、C1、C2、CS作为归档数据添加到任务数据关系表中,并与第一任务的任务标识Tl进行关联存储;关于如何将数据与任务通过任务标识进行关联为本领域技术人员所公知的技术,在此不再赘述。 [0075] embodiment of the present invention, the first task Tl associated with the data: A1, A2, A3, A4, B1, B2, B3, C1, C2, CS added data as archive data to a task relationship table, and The first task of the mission to identify and associate Tl storage; about how to identify the data and tasks performed tasks related to those skilled in the well-known techniques, are not discussed here.

[0076] 步骤102,对提取的历史数据进行编辑并形成归档历史数据; [0076] Step 102, the extracted history data for editing and archiving historical data is formed;

[0077] 本步骤中,在对提取的历史数据添加到任务数据关系表中之后,可以在待编辑任务的编辑时间段内,对任务数据关系表中与为待编辑任务设置的任务标识对应的预操作数据进行更新维护;同时,根据预操作数据的改变更新预操作从属数据。 [0077] In this step, after the extraction of the historical data is added to the task data in relational tables that can be edited in the task of editing period of task data in relational tables and task editing tasks to be identified as corresponding to the set pre-operational data, updating and maintenance; at the same time, according to the pre-change operation to update the data pre-operation dependent data. 这样,任务数据关系表中与为待编辑任务设置的任务标识对应的已完成更新维护的预操作数据、预操作从属数据,以及条件数据构成归档历史数据。 Thus, the task data in relational tables and editing tasks to be set up to identify the corresponding task has been completed updating and maintenance of the pre-operational data, pre-operation dependent data, and condition data constitute archiving historical data.

[0078] 本发明实施例中,如前所述,在第一任务Tl的起始时间2013年8月I日至终止时间2013年8月5日之内,可以对归档数据中的预操作数据Al、A3及B2进行更新维护,相应地,预操作从属数据C1、C2、C3将根据预操作数据A1、A3、B2的变化而作出相应的更新。 [0078] In embodiments of the invention, as described above, in the start time of the first task Tl of August 2013 to the end time I August 5, 2013, the archived data can manipulate the data in the pre- Al, A3 and B2 maintenance updates, and accordingly, the pre-operation dependent data C1, C2, C3 will be based on the pre-operational data A1, A3, B2, and make the appropriate changes in the update. 假设,当第一任务Tl终止时,预操作数据Al、B2更新为数据Al '、B2';数据A3被删除,相应地,预操作从属数据Cl、C2、C3更新为数据Cl '、C2 '。 Assuming, when the first task Tl terminated, the pre-operation data Al, B2 updated data Al ', B2'; data A3 is deleted, accordingly, the pre-operating slave data Cl, C2, C3 is updated to data Cl ', C2' . 这样,已完成更新维护的数据Al ; , B2 ;,数据Cl ^ , C2 ;,以及条件数据A2、A4、B1、B3构成与任务标识Tl对应的归档历史数据。 Thus, the data have been updated to maintain Al;, B2;, data Cl ^, C2;, and condition data A2, A4, B1, B3 constitute identification task Tl corresponding archiving historical data.

[0079] 实际应用中,当该任务内需要更新维护处理的数据量较大时,在处理数据间的逻辑关系时就会耗费一定的时间,因此,为了保证主进程的顺利进行,将打开一个异步进程处理该数据更新事务;数据更新处理完成后将回写一个完成状态,以便通知主进程数据处理完成,并将处理结果反馈至任务数据关系表中;如果中途出现异常,则回写一个异常状态,以便通知主进程进行其他相关处理。 [0079] The actual application, when the task needs to be updated in the processing of large amounts of data maintenance, in the relationship between the data processing logic will spend some time, therefore, in order to ensure the smooth conduct of the primary process, will open a asynchronous process to handle the data update transaction; data update process is completed after a complete write-back state to notify the main process of data processing is completed, and the results are fed back to the task data in relational tables; if she is abnormal, then write back an exception state, in order to inform other main processes related processing. 当该任务需要更新维护处理的数据量较小时,则可以采用同步处理机制,直接在任务数据关系表中同步更新处理结果。 When the task needs to be updated when a small amount of data processing maintenance, you can use the synchronization mechanism for handling direct synchronization task data update processing results in relational tables.

[0080] 步骤103,为归档历史数据设置任务标识,并将设置有任务标识的归档历史数据存储到预先设置的任务归档历史数据库中。 [0080] Step 103, set the task of archiving historical data to identify and set there an archive of historical data storage tasks identified pre-set to the task of archiving historical database.

[0081] 本步骤中,为由任务数据关系表中已完成更新维护的预操作数据、根据预操作数据的改变而作出相应更新的预操作从属数据,以及条件数据构成的归档历史数据设置任务标识,该任务标识与为当前待编辑任务设置的任务标识相同,并将设置了任务标识的归档历史数据作为任务历史数据存储到预先设置的任务归档历史数据库中。 [0081] In this step, by task data in relational tables have been updated to maintain the pre-operation data, according to the change made in the pre-operational data archiving historical data set the task to identify the appropriate pre-update operation dependent data, and condition data constituted The task identifies the current task ID to be set to the same editing tasks, and set the task of archiving historical data identified as a task of historical data stored in the archive task preset historical database.

[0082] 本发明实施例中,如前所述,当第一任务Tl终止时,预操作数据A1、B2更新为数据Al'、B2';数据A3被删除,相应地,预操作从属数据C1、C2、C3更新为数据Cl '、C2 ',则将任务数据关系表中已完成更新维护的预操作数据Al '、B2',预操作从属数据Cl'、C2丨以及条件数据A2、A4、B1、B3作为归档历史数据存储到任务归档历史数据库中,并以任务标识Tl作为该归档历史数据的索引信息。 [0082] embodiment of the invention, as described above, when the first task Tl terminated, the pre-operation data A1, B2 updated data Al ', B2'; data A3 is deleted, accordingly, the pre-operation dependent data C1 , C2, C3 updated data Cl ', C2', then the task data in relational tables have been updated to maintain the pre-operation data Al ', B2', the pre-operation dependent data Cl ', C2 Shu and condition data A2, A4, B1, B3 storage as an archive of historical data to the historical database archiving tasks, and task information as an index that identifies Tl archived historical data. 这样,就可将任务历史数据与整体数据进行分离。 This task can be historical data and the overall data to be separated. 当用户需获取某一时间段的任务历史数据时,只需根据任务标识即可获取完整的与任务相关的任务历史数据,包括经过更新维护的预操作数据、预操作从属数据以及条件数据。 When users need to get the task of historical data certain period of time, just to get the full identity of the task and the task of historical data-related tasks, including the updated maintenance of the pre-operational data, pre-operation and condition data dependent data.

[0083] 可替换地,本发明实施例中,在对提取的历史数据进行编辑之后,可以为已完成编辑的历史数据分别建立预操作数据备份表、预操作从属数据备份表及条件数据备份表; [0083] Alternatively, the embodiment of the invention, after the extraction of historical data editing, data backup can create pre-operating table as complete historical data were edited, pre-operating condition dependent data backup data backup tables and table ;

[0084] 其中,预操作数据备份表用于存储已编辑的历史数据中的预操作数据,并设置有与当前待编辑任务相应的任务标识; [0084] where the historical data for the pre-operation data backup tables store the edited data in the pre-operation, and is provided with the current task to edit the corresponding task ID;

[0085] 预操作从属数据备份表用于存储已编辑的历史数据中的预操作从属数据,并设置有与当前待编辑任务相应的任务标识; [0085] Pre-dependent data backup operation history data table used to store the edited data in the pre-operation dependent, and is provided with the current task to edit the corresponding task ID;

[0086] 条件数据备份表用于存储已编辑的历史数据中的条件数据,并设置有与当前待编辑任务相应的任务标识。 [0086] condition data backup table for historical data storage conditions in the edited data and settings have to be edited with the current task to identify the appropriate task.

[0087] 进一步地,将预操作数据备份表、从属数据备份表以及条件数据备份表存储到任务归档历史数据库中;其中,设置有相同任务标识的所述预操作数据备份表、所述从属数据备份表及所述条件数据备份表中分别存储的预操作数据、预操作从属数据以及条件数据的综合即为与任务标识对应的归档历史数据。 [0087] Further, the pre-operation data backup sheet, and the conditions of the slave data backup table data table stored in the job archive backup history database; wherein said pre-operation data is provided with the same task ID of the backup table, said slave data pre-operational data backup data backup table and said conditions are stored in the table, the pre-operation shall be integrated with the task to identify the slave data and condition data corresponding to the archived historical data. 这样,在查询与任务相关的历史数据并获取准确完整的数据的同时,可以充分了解任务历史数据中的更新的预操作数据和未更新的条件数据,以及与更新的数据相关联的预操作从属数据,便于在获取任务历史数据之后与其他任务历史数据或当前数据的对比分析。 Thus, in the query associated with the task of historical data and obtain accurate and complete data at the same time, we can fully understand the pre-operation data dependent task of updating the historical data and does not update the condition data, as well as the pre-update data associated with the operation data for analysis and comparison of historical data or other tasks after the current data acquisition task historical data.

[0088] 本发明实施例中,在为归档历史数据设置任务标识,并存储到预先设置的任务归档历史数据库中之后,该方法还可以进一步包括: [0088] embodiment of the invention, after the historical data for the archive set task ID, and stored in the job archive historical database set in advance, the method may further comprise:

[0089] 接收以任务标识表示的任务历史数据查询请求,并根据接收的任务标识从任务归档历史数据库中筛选出与任务标识对应的归档历史数据。 [0089] receives the task of historical data query to identify tasks represented and documented historical database screening and archiving historical data to identify the corresponding task from the task according to the task identifier received.

[0090] 实际应用中,针对不同时间段执行的不同任务,都可以采用上述方法对与任务相关的数据进行更新维护,并形成与为待编辑任务设置的任务标识对应的任务历史数据。 [0090] practical applications for different tasks performed by different time periods, using the above method can be associated with the task of data update maintenance, and forms to be set the task of editing tasks identify the corresponding task historical data. 这样,当接收到用户的任务历史数据请求时,可以首先从任务表中筛选出与任务历史数据查询请求对应的任务标识及编辑时间段;然后,根据任务标识,从任务归档历史数据库中筛选出与任务标识对应的归档历史数据,包括预操作数据、预操作从属数据以及条件数据,从而获取与任务历史数据查询请求对应的详细完整的真实的任务历史数据。 Thus, when receiving the user's task of historical data requests can be first screened with the task of historical data query request corresponding task ID and editing time from the task list; then, according to the task ID, screened from the historical archive database task with the task to identify the corresponding archive historical data, including pre-operational data, pre-operation dependent data and condition data in order to gain real task of historical data and historical data query tasks detailed in the corresponding complete. [0091] 由上可见,本发明实施例提供的历史数据归档方法,通过将预先存储的整体数据中与待编辑任务相匹配的所有历史数据部署给该待编辑任务,并对与该待编辑任务相匹配的历史数据进行更新维护,形成归档历史数据,对归档历史数据设置任务标识,并作为任务历史数据存储到任务归档历史数据库中,这样,就实现了整体数据与任务历史数据的分离。 [0091] As seen from the historical data archiving method according to an embodiment of the present invention, will be deployed by all historical data previously stored in the overall data and editing tasks to be matched to the task to be edited, and the task to be edited matched historical data update maintenance, archiving historical data to form, set the task of archiving historical data to identify, and as a task of historical data stored in the job history database archive, so to achieve a separation of data and the overall mission of historical data. 而在需要查询或获取某一历史时间段内满足任务需求并与任务相关的任务历史数据时,可以通过任务标识,从任务归档历史数据库中直接筛选出与该任务对应的任务历史数据,而无需访问整体历史数据库,访问速度快。 And when you need to check or obtain a certain historical period to meet the mission requirements and tasks related to the task of historical data, the task can be identified from the task history database archiving tasks directly selected historical data corresponding to the task, without Access the whole history database access speed.

[0092] 图2为本发明实施例历史数据归档装置结构示意图。 [0092] Figure 2 is a schematic configuration example of a schematic view of the historical data filing apparatus embodiment. 如图2所示,该装置包括:任务数据管理模块21、归档数据更新模块22、任务历史数据存储模块23 ;其中, As shown, the apparatus comprises a 2: task data management module 21, the archive data updating module 22, the task history data storage means 23; wherein,

[0093] 任务数据管理模块21,用于从采集并存储的包含了与各待编辑任务相关数据的整体历史数据库中,提取与待编辑任务相匹配的历史数据; [0093] Mission data management module 21 for collecting and storing the whole history database contains editing tasks associated with the data to be extracted with the task to be edited to match the historical data;

[0094] 本发明实施例中,从整体历史数据库中筛选出的与当前待编辑任务相匹配的历史数据,包括预操作数据、与预操作数据关联的预操作从属数据、条件数据;其中, [0094] In embodiments of the invention, selected from the whole history of the database with the current task to be edited to match the historical data, including pre-operational data, the data associated with the pre-operation pre-operation dependent data, condition data; which,

[0095] 预操作数据为当前待编辑任务所需进行更新维护操作的数据; [0095] Pre-operational data for the current editing tasks needed to be updated to maintain the operation of the data;

[0096] 预操作从属数据为与待编辑任务相关,且随预操作数据的改变而变化的数据; [0096] Pre-Operational dependent data to be edited and task-related, and with the change in the pre-operational data and changing data;

[0097] 条件数据为与当前待编辑任务相关,但无需进行更新的数据。 [0097] condition data associated with the current task to be edited, but without the need for updated data.

[0098] 本发明实施例中,任务数据管理模块21进一步用于为待编辑任务设置任务标识及任务编辑时间段;构建包含任务标识栏、预操作数据栏、预操作从属数据栏以及条件数据栏的任务数据关系表; Embodiment [0098] The present invention, the task of data management module 21 is to be used for further editing task settings and task editing task to identify the time period; construct contains the task tab, pre-operational data field, pre-operating condition dependent data fields and data fields The task data relational tables;

[0099] 将为待编辑任务设置的任务标识写入任务数据关系表中的任务标识栏,并根据待编辑任务、任务标识以及与待编辑任务相匹配的历史数据之间的对应关系,将所述提取的历史数据写入任务数据关系表中的相应栏。 [0099] will be the task of editing tasks set identification task writes data in a relational table identifies the task bar, and according to the corresponding relation to edit tasks, task identity and historical data to be matched between editing tasks will the referred to extract historical data write task data in relational tables corresponding column. 本发明实施例中,可以构建任务表,并在构建的任务表中添加与当前任务对应的任务标识、起始时间及终止时间,或将起始时间及终止时间以任务编辑时间段的方式添加到任务表中。 Embodiment of the invention, it is possible to build a task table, and add the task table constructed in the task corresponding to the current task ID, start time and end time, or the start time and end time in the manner the task editor add period to the task list.

[0100] 本发明实施例中,构建的任务表中包括任务标识栏、任务编辑时间段栏,用于存储与各项待编辑任务对应的任务标识以及任务编辑时间段。 [0100] In embodiments of the invention, the task of constructing the table include identification task bar, task bar to edit the time period for storing the various tasks to be edited corresponding task identity and task editing time. 这样,通过记录所执行的任务,可以便于后续用户通过任务标识或编辑时间段来查询以及获取与执行的待编辑任务相关的任务历史数据。 Thus, the task performed by recording can facilitate subsequent identification or edit user task time to query and access and editing tasks to be performed by the historical data related tasks.

[0101] 归档数据更新模块22,用于对由所述任务数据管理模块提取的历史数据进行编辑并形成归档历史数据; [0101] archive data updating module 22, for extracting data from the task management module and form editing historical data archiving historical data;

[0102] 本发明实施例中,在对提取的历史数据添加到任务数据关系表中之后,可以在待编辑任务的编辑时间段内,对任务数据关系表中与为待编辑任务设置的任务标识对应的预操作数据进行更新维护;同时,根据预操作数据的改变更新预操作从属数据。 [0102] In embodiments of the invention, after the extraction of the historical data is added to the task data in relational tables that can be edited in the task of editing period of task data in relational tables and editing tasks to be set the task of identification corresponding pre-operation data updating and maintenance; at the same time, according to the pre-change operation to update the data pre-operation dependent data. 这样,任务数据关系表中与为待编辑任务设置的任务标识对应的已完成更新维护的预操作数据、预操作从属数据,以及条件数据构成归档历史数据。 Thus, the task data in relational tables and editing tasks to be set up to identify the corresponding task has been completed updating and maintenance of the pre-operational data, pre-operation dependent data, and condition data constitute archiving historical data.

[0103] 实际应用中,当该任务内需要更新维护处理的数据量较大时,在处理数据间的逻辑关系时就会耗费一定的时间,因此,为了保证主进程的顺利进行,将打开一个异步进程处理该数据更新事务;数据更新处理完成后将回写一个完成状态,以便通知主进程数据处理完成,并将处理结果反馈至任务数据关系表中;如果中途出现异常,则回写一个异常状态,以便通知主进程进行其他相关处理。 [0103] The actual application, when the task needs to be updated in the processing of large amounts of data maintenance, in the relationship between the data processing logic will spend some time, therefore, in order to ensure the smooth conduct of the primary process, will open a asynchronous process to handle the data update transaction; data update process is completed after a complete write-back state to notify the main process of data processing is completed, and the results are fed back to the task data in relational tables; if she is abnormal, then write back an exception state, in order to inform other main processes related processing. 当该任务需要更新维护处理的数据量较小时,则可以采用同步处理机制,直接在任务数据关系表中同步更新处理结果。 When the task needs to be updated when a small amount of data processing maintenance, you can use the synchronization mechanism for handling direct synchronization task data update processing results in relational tables.

[0104] 任务历史数据存储模块23,用于为由所述归档数据更新模块形成的归档历史数据设置任务标识,并将设置有任务标识的归档历史数据存储到预先设置的任务归档历史数据库中。 [0104] task history data storage means 23 for archiving historical data provided by the task ID archived data update module is formed, and includes a task identification data stored in the job archive historical archive preset historical database.

[0105] 本发明实施例中,为由任务数据关系表中已完成更新维护的预操作数据、根据预操作数据的改变而作出相应更新的预操作从属数据,以及条件数据构成的归档历史数据设置任务标识,该任务标识与为当前待编辑任务设置的任务标识相同,并将设置了任务标识的归档历史数据作为任务历史数据存储到预先设置的任务归档历史数据库中。 Implementation [0105] The present invention, by task data in relational tables have been updated to maintain the pre-operation data, in accordance with changes in the pre-operational data and make the appropriate updates pre-operation dependent data, and archiving historical data set consisting of condition data task ID, which identifies the tasks for the current task ID to be set to the same editing tasks, and set the task of archiving historical data identified as a task of historical data stored in the archive task preset historical database.

[0106] 可替换地,本发明实施例中,任务历史数据存储模块23还可以为已完成更新维护的预操作数据、预操作从属数据以及条件数据分别建立预操作数据备份表、从属数据备份表及条件数据备份表,将预操作数据备份表、从属数据备份表以及条件数据数据备份表存储到任务归档历史数据库中;其中,设置有相同任务标识的所述预操作数据备份表、所述从属数据备份表及所述条件数据备份表中分别存储的预操作数据、预操作从属数据以及条件数据的综合即为与任务标识对应的归档历史数据。 [0106] Alternatively, the embodiment of the invention, the task of historical data storage module 23 can also update and maintain the completed pre-operational data, pre-operation and condition data dependent data were established pre-operational data backup table, the slave data backup table and condition data backup table, the pre-operation data backup table, table and condition dependent data backup data backup data is stored in the task table archive historical database; which is provided with the pre-operational data backup tasks identified in the same table, the slave pre-operational data sheet and the conditions for data backup data backup are stored in the table, the pre-operation shall be integrated with the task to identify the slave data and condition data corresponding archived historical data. 这样,可以根据任务标识获取任务历史数据中的更新的预操作数据和未更新的条件数据,以及与更新的数据相关联的预操作从属数据,便于在获取任务历史数据之后与其他任务历史数据或当前数据的对比分析。 In this way, you can get a pre-operating data according to the task to identify the task of updating the historical data and does not update the condition data, and update the data associated with the pre-operation dependent data, historical data or easy task after the acquisition of historical data and other tasks Comparative analysis of the current data.

[0107] 实际应用中,针对不同时间段执行的不同任务,都可以采用上述装置对与任务相关的数据进行更新维护,并形成与任务的任务标识对应的任务历史数据。 [0107] practical applications for different tasks performed by different time periods, you can employ the apparatus of the data associated with the task to update the maintenance, and the formation of the task and the task of historical data to identify the corresponding task. 这样,当接收到用户的任务历史数据请求时,可以从构建的任务表中筛选出与任务历史数据请求对应的任务标识;根据任务标识,从任务归档历史数据库中调取与任务标识对应的任务历史数据,包括预操作数据备份表、从属数据备份表以及条件数据备份表中各自存储的数据,从而获取与查询请求对应的详细完整的真实的任务历史数据。 Thus, when receiving the user's task of historical data requests can be screened from the task table constructed with the task of historical data to identify the corresponding task request; according to the task to identify, collect and identify the corresponding task from the task history database archiving tasks historical data, including pre-operation data backup table, table and condition dependent data backup data backup table each store, thus obtaining the corresponding detailed and complete the task of real historical data and queries.

[0108] 进一步地,本发明实施例中,在为归档历史数据设置任务标识,并存储到预先设置的任务归档历史数据库中之后,该装置还可以包括:数据请求查询模块,用于接收以任务标识表示的任务历史数据查询请求,并根据接收的任务标识从由任务历史数据存储模块23存储任务归档历史数据库中筛选出与任务标识对应的归档历史数据。 [0108] Further, the embodiment of the present invention, after the historical data for the archive set task ID, and stored in the job archive historical database set in advance, the apparatus may further comprise: a data request query module, for receiving a task task identity, said historical data query and filter out the task ID corresponding archiving historical data from historical data is stored by the task module 23 historical archive database storage tasks according to task ID to receive.

[0109] 由上可见,本发明实施例提供的历史数据归档装置,通过任务数据管理模块21将整体历史数据中与待编辑任务相匹配的所有历史数据部署给该待编辑任务,并通过归档数据更新模块22对与该任务相匹配的历史数据进行更新维护形成归档历史数据,对归档历史数据设置任务标识,并作为任务历史数据存储到任务历史数据存储模块23中,这样,实现了整体历史数据与任务历史数据的分离。 [0109] As seen from the historical data archiving device according to an embodiment of the present invention, the task of data management module 21 will be deployed to all the historical data as a whole with the historical data to be edited to match the task to the task to be edited and archived data through Update Module 22 pairs matched with the task to update the maintenance history data to form an archive of historical data, for archiving historical data set task identity, and historical data is stored as a task to task history data storage means 23, so that to achieve the overall historical data separation of tasks and historical data. 当需要查询或获取某一历史时间段内满足任务需求并与任务相关的任务历史数据时,可以通过任务标识,从任务历史数据存储模块23中直接筛选出与该任务对应的任务历史数据。 When you need to check or obtain a certain historical period to meet the mission requirements and tasks associated with the task of historical data, you can identify by the task, the task of historical data from the memory module 23 with the task of screening task corresponding historical data.

[0110] 显然,本领域技术人员可以对本发明进行各种改动和变型而不脱离本发明的精神和范围。 [0110] Obviously, those skilled in the art may make various modifications of the present invention and modifications without departing from the spirit and scope of the invention. 这样,倘若对本发明的这些修改和变型属于本发明权利要求及其等同技术的范围之内,则本发明也包含这些改动和变型在内。 Thus, if these modifications and variations of the present invention and the claims of the invention belongs to the technical scope of equivalents, the present invention also includes these changes and variations included.

Citations de brevets
Brevet cité Date de dépôt Date de publication Déposant Titre
CN101364897A *17 sept. 200811 févr. 2009中兴通讯股份有限公司System for historical data archiving and implementing method
CN101639839A *30 juil. 20083 févr. 2010中兴通讯股份有限公司Method for searching multi-archive file based on temporary table
CN103106247A *31 déc. 201215 mai 2013普天新能源有限责任公司Data dump method and system
US20070112801 *28 sept. 200617 mai 2007Rockwell Automation Technologies, Inc.Distributed historian architecture
Citations hors brevets
Référence
1 *张岩: "数据仓库历史数据归档与重构的策略研究", 《中国优秀硕士学位论文全文数据库 信息科技辑》, 31 August 2005 (2005-08-31), pages 138 - 402
Référencé par
Brevet citant Date de dépôt Date de publication Déposant Titre
CN104052804A *9 juin 201417 sept. 2014深圳先进技术研究院Method, device and cluster for sharing data streams between different task topologies
Classifications
Classification internationaleG06F17/30
Classification coopérativeG06F17/30522, G06F17/30442, G06F17/30342
Événements juridiques
DateCodeÉvénementDescription
15 janv. 2014C06Publication
26 févr. 2014C10Entry into substantive examination
28 sept. 2016C14Grant of patent or utility model