CN101699433A - Data reforming method and system - Google Patents
Data reforming method and system Download PDFInfo
- Publication number
- CN101699433A CN101699433A CN200910110263A CN200910110263A CN101699433A CN 101699433 A CN101699433 A CN 101699433A CN 200910110263 A CN200910110263 A CN 200910110263A CN 200910110263 A CN200910110263 A CN 200910110263A CN 101699433 A CN101699433 A CN 101699433A
- Authority
- CN
- China
- Prior art keywords
- pdi
- field
- data information
- rule
- reforming
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Images
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The embodiment of the invention discloses a data reforming method which comprises the following steps: making data reforming rules according to initial data information; storing the data reforming rules as a reforming scheme; and calling the reforming scheme to reform the initial data information. Correspondingly, the embodiment of the invention also provides a data reforming system. In the technical scheme of the embodiment of the invention, the data reforming rules can be stored as the reforming scheme after being made, and while reforming the initial data, the user only needs to directly call the corresponding rule in the reforming scheme. The embodiment of the invention provides the user with a data reforming method and a system which effectively save time and reduce the repetitive operation of the user.
Description
Technical field
The present invention relates to data processing field, more particularly, relate to a kind of data reforming method and system.
Background technology
Data reforming be meant the data of will collect or store for realize a certain purpose, according to the rule of appointment merge, operations such as deletion and adjustment so that the user uses.
In the prior art, when carrying out data reforming, generally include single reformation rule and two kinds of working methods of multiple reformation rule, when carrying out data reforming according to single reformation rule, such as, in a product data tabulation, wherein listed product is according to type divided, and the product data information after will dividing generates a new tabulation; And when carrying out data reforming according to multiple reformation rule, such as, in a product data tabulation, with wherein listed product except will according to type dividing, also need product is sorted according to price order from high to low, and carry out the reformation of this data list according to above rule.
When the user carries out data reforming when operation, need generate the data reforming rule according to the respective field of tables of data and relational operator and logical operator, and carry out the reformation of data according to the data rule that is generated.And at present, because the continuous development of database technology, institute's data quantity stored is increasing, and kind is also more and more, wants from huge database according to one or how each rule is carried out the reformation of data, and workload will be quite huge.And all need when carrying out data reforming each time to reset the data reforming rule one time, make user experience relatively poor.
So those skilled in the art press for develops a kind of user's repetitive operation of effectively saving time, reduce, make the user obtain the method for the better data reforming of experiencing.
Summary of the invention
In view of this, the embodiment of the invention provides a kind of data reforming method and system, makes the user can be more when carrying out data reforming quick, efficient, and better user experience is arranged.
The embodiment of the invention is achieved in that
The embodiment of the invention provides a kind of data reforming method, and this method comprises:
Carry out the formulation of data reforming rule according to primary data information (pdi);
Described data reforming rule is saved as the reformation scheme;
Calling described reformation scheme reforms to described primary data information (pdi).
Describedly carry out the formulation of data reforming rule, comprising according to primary data information (pdi):
Select the part field in the described primary data information (pdi), with the described part field chosen as merging according to field.
Describedly call described reformation scheme described primary data information (pdi) reformed, comprising:
Call merging in the described reformation scheme according to field;
To comprise in the primary data information (pdi) that the data message of described merging according to field merges.
Describedly carry out the formulation of data reforming rule, comprising according to primary data information (pdi):
Select the part field in the described primary data information (pdi), with the described part field chosen as deletion according to field.
Describedly call described reformation scheme described primary data information (pdi) reformed, comprising:
Call deletion in the described reformation scheme according to field;
Delete according to the data message of field comprising described deletion in the primary data information (pdi).
Described described data reforming rule is saved as the reformation scheme, comprising:
Described data reforming rule is converted into executable SQL statement;
By compiling, described data reforming rule is saved as the reformation scheme to described SQL statement.
The embodiment of the invention also provides a kind of data reforming system, comprising: formulate the unit, preserve unit and reformer unit, wherein,
Described formulation unit is used for carrying out according to primary data information (pdi) the formulation of data reforming rule;
Described preservation unit is used for described reformation rule is saved as the reformation scheme;
Described reformer unit is used to call described reformation scheme described primary data information (pdi) is reformed.
Described formulation unit comprises: the first chooser unit and merging Rulemaking subelement, wherein,
The described first chooser unit is used for selecting the part field of described primary data information (pdi);
Described merging Rulemaking subelement, the described part field that is used for choosing is as merging according to field.
Described reformer unit comprises: first calls subelement and merges subelement, wherein,
Described first calls subelement, is used for calling the merging of described reformation scheme according to field;
Described merging subelement is used for primary data information (pdi) is comprised that described merging merges according to the data message of field.
Described formulation unit comprises: the second chooser unit and deletion rule are formulated subelement, wherein,
The described second chooser unit is used for selecting the part field of described primary data information (pdi);
Described deletion rule is formulated subelement, and the described part field that is used for choosing is as deleting according to field.
Described reformer unit comprises: second calls subelement and deletion subelement, wherein,
Described second calls subelement, is used for calling the deletion of described reformation scheme according to field;
Described deletion subelement is used for primary data information (pdi) is comprised that described deletion deletes according to the data message of field.
Compared with prior art, the technical scheme that the embodiment of the invention provides has the following advantages and characteristics: the embodiment of the invention by with the data reforming Rulemaking well after, it is saved as the reformation scheme, when carrying out the reformation of raw data, the corresponding reformation rule that only need directly call in the reformation scheme gets final product.The embodiment of the invention provides a kind of data reforming method and system that effectively saves time, reduces user's repetitive operation for the user.
Description of drawings
In order to be illustrated more clearly in the embodiment of the invention or technical scheme of the prior art, to do to introduce simply to the accompanying drawing of required use in embodiment or the description of the Prior Art below, apparently, accompanying drawing in describing below only is some embodiments of the present invention, for those of ordinary skills, under the prerequisite of not paying creative work, can also obtain other accompanying drawing according to these accompanying drawings.
Fig. 1 is the related a kind of data reforming method process flow diagram of the embodiment of the invention;
Fig. 2 is the related a kind of data reforming system architecture synoptic diagram of the embodiment of the invention;
Fig. 3 is the structural representation of a certain unit in the related a kind of data reforming system of the embodiment of the invention;
Fig. 4 is the structural representation of a certain unit in the related a kind of data reforming system of the embodiment of the invention;
Fig. 5 is the structural representation of a certain unit in the related a kind of data reforming system of the embodiment of the invention;
Fig. 6 is the structural representation of a certain unit in the related a kind of data reforming system of the embodiment of the invention.
Embodiment
Below in conjunction with the accompanying drawing in the embodiment of the invention, the technical scheme in the embodiment of the invention is clearly and completely described, obviously, described embodiment only is the present invention's part embodiment, rather than whole embodiment.Based on the embodiment among the present invention, those of ordinary skills belong to the scope of protection of the invention not making the every other embodiment that is obtained under the creative work prerequisite.
In the system or software that the present invention can be applied to realize based on database, database is to organize and deposit in data acquisition in the second-level storage according to certain data model.This data acquisition has following characteristics: do not repeat as far as possible, mode with optimum is the multiple application service of certain particular organization, its data structure is independent of the application program of using it, increasing, delete, changing and retrieve by unifying software and manage and control data.
The embodiment of the invention provides a kind of data reforming method, and this method comprises the described step of Fig. 1:
Step 101: carry out the formulation of data reforming rule according to primary data information (pdi);
In step 101, when carrying out the formulation of data reforming rule since herein the data reforming of indication be can with primary data information (pdi) according to certain rule merge, operation such as deletion, generates new data message new, that be beneficial to user's use.
Therefore, when carrying out the formulation of data reforming rule,, then at first to select the field that will merge if the user need merge the data message that the part field is identical in the primary data information (pdi), and with this part field of choosing as merging according to field.In the production application of reality, for example, at import and export enterprise in when declaration, owing to handling goods to customs, article or means of transport are passed in and out in the process of formality and relevant customs affairs, need be to customs declaration, deliver for a check the document certificate, and owing to needed document certificate in the declaration process is of a great variety, if and required type of merchandize of declaring is various, bring huge workload for the customs staff undoubtedly, therefore, if the method for taking the embodiment of the invention to provide, then only need select voluntarily to need the field as merging rule get final product on the import documents of typing multirow material information, follow-up sequence of operations will be based on selected mergefield execution.Need to prove, when the selection of the field that merges rule, can select one section according to actual needs, also can select multistage according to actual needs, do not do particular restriction at this.
Except foregoing merging to primary data information (pdi) is reformed, can also carry out deletion action to primary data information (pdi), further be specially: if the user thinks that data table items is too much, need do suitably and simplify, thereby the data message that the part field is identical in the primary data information (pdi) need be deleted, finally only keep a data message.For realizing this purpose, at first need from primary data information (pdi) to select the field that will delete, and with this field as deleting according to field.Equally, when the selection of the field of carrying out deletion rule, can select one section according to actual needs, also can select multistage according to actual needs, not do particular restriction at this.
Step 102: described data reforming rule is saved as the reformation scheme;
In step 101, according to primary data information (pdi) and actual need of work, made corresponding data reforming rule, in step 102, use for ease of the user, the data reforming rule of being made need be preserved.
Still use a step given example, in carrying out the declaration process, the user is according to the actual goods that will declare at customs and the every document that will declare, therefore the user will be provided with a plurality of merging rules according to the document that will declare, for ease of using, these made merging rules of reserving are preserved declaring in the process of reality.Because this method can be applied in the Database Systems, therefore, in the application process of reality, can every rule that merges of being made be kept in the corresponding database by sql like language.
For the situation that primary data information (pdi) is deleted, similar with raw data is merged, also need the deletion rule of being made is preserved.
Step 103: call described reformation scheme described primary data information (pdi) is reformed.
In step 103, when carrying out the reformation of primary data information (pdi), data reforming can comprise the merging of data and the multiple modes such as deletion of data.
Like this, when carrying out the merging of data, draw together several data owing to stealthily substitute in the reformation scheme and merged rule, the user can be according to actual needs, from the reformation scheme, call corresponding data and merge rule, for example, can in the multiple merging rule of being preserved in advance, call corresponding merging rule, generate corresponding declaration in the declaration process of customs.Further be specially: if desired a certain goods is carried out declaration work, then need when document is correlated with in generation, merge all information of this goods.For achieving the above object, the user can call the title or the customs number of this goods in the merging rule that pre-establishes, and serves as to merge rule primary data information (pdi) is merged with the title of this goods or customs number, generates customs document that should goods etc.
And if primary data information (pdi) is too huge, loaded down with trivial details, can simplify primary data information (pdi), can carry out deletion work to primary data information (pdi) this moment so, for example can according to certain principle with many contents identical or similar data information delete, finally only keep a relevant information.For achieving the above object, the user can call corresponding deletion according to field in the deletion rule that pre-establishes, according to field, can will comprise that this deletion deletes according to the information data of field, according to this deletion of choosing to realize simplifying to primary data information (pdi).
A kind of data reforming method that the embodiment of the invention provided, by with the data reforming Rulemaking well after, it is saved as the reformation scheme, when carrying out the reformation of raw data, only need directly call regular the getting final product of corresponding reformations in the reformation scheme.The embodiment of the invention provides a kind of data reforming method of effectively saving time, reducing user's repetitive operation for the user.
Correspondingly, the embodiment of the invention also provides a kind of data reforming system, and this system's concrete structure comprises as described in Figure 2: formulate unit 201, preserve unit 202 and reformer unit 203, wherein:
Formulate unit 201, be used for carrying out the formulation of data reforming rule according to primary data information (pdi);
In addition, above-mentioned data reforming system can be carried out further specialize, for example:
Formulation unit in this system can comprise structure as shown in Figure 3, comprising: the first chooser unit 301 and merging Rulemaking subelement 302, wherein:
The first chooser unit 301 is used for selecting the part field of described primary data information (pdi);
The corresponding above structure of formulating the unit, then reformer unit can comprise structure as described in Figure 4, comprising: first calls subelement 401 and merges subelement 402, wherein:
First calls subelement 401, is used for calling the merging of described reformation scheme according to field;
Merge subelement 402, be used for primary data information (pdi) is comprised that described merging merges according to the data message of field.
In addition, the formulation unit in this data reforming system can comprise structure as shown in Figure 5, comprising: the second chooser unit 501 and deletion rule are formulated subelement 502, wherein:
The second chooser unit 501 is used for selecting the part field of described primary data information (pdi);
Deletion rule is formulated subelement 502, and the described part field that is used for choosing is as deleting according to field.
Corresponding above-mentioned formulation cellular construction, then reformer unit can comprise structure as described in Figure 6, comprising: second calls subelement 601 and deletion subelement 602, wherein:
Second calls subelement 601, is used for calling the deletion of described reformation scheme according to field;
Deletion subelement 602 is used for primary data information (pdi) is comprised that described deletion deletes according to the data message of field.
A kind of data reforming system that the embodiment of the invention provided, by with the data reforming Rulemaking well after, it is saved as the reformation scheme, when carrying out the reformation of raw data, only need directly call regular the getting final product of corresponding reformations in the reformation scheme.The embodiment of the invention provides a kind of data reforming system that effectively saves time, reduces user's repetitive operation for the user.
Need to prove, in this article, relational terms such as first and second grades only is used for an entity or operation are made a distinction with another entity or operation, and not necessarily requires or hint and have the relation of any this reality or in proper order between these entities or the operation.And, term " comprises ", " comprising " or its any other variant are intended to contain comprising of nonexcludability, thereby make and comprise that process, method, article or the equipment of a series of key elements not only comprise those key elements, but also comprise other key elements of clearly not listing, or also be included as this process, method, article or equipment intrinsic key element.Do not having under the situation of more restrictions, the key element that limits by statement " comprising ... ", and be not precluded within process, method, article or the equipment that comprises described key element and also have other identical element.
To the above-mentioned explanation of the disclosed embodiments, make this area professional and technical personnel can realize or use the present invention.Multiple modification to these embodiment will be conspicuous concerning those skilled in the art, and defined herein General Principle can realize under the situation that does not break away from the spirit or scope of the present invention in other embodiments.Therefore, the present invention will can not be restricted to these embodiment shown in this article, but will meet and principle disclosed herein and features of novelty the wideest corresponding to scope.
Claims (11)
1. a data reforming method is characterized in that, comprising:
Carry out the formulation of data reforming rule according to primary data information (pdi);
Described data reforming rule is saved as the reformation scheme;
Calling described reformation scheme reforms to described primary data information (pdi).
2. method according to claim 1 is characterized in that, describedly carries out the formulation of data reforming rule according to primary data information (pdi), comprising:
Select the part field in the described primary data information (pdi), with the described part field chosen as merging according to field.
3. method according to claim 2 is characterized in that, describedly calls described reformation scheme described primary data information (pdi) is reformed, and comprising:
Call merging in the described reformation scheme according to field;
To comprise in the primary data information (pdi) that the data message of described merging according to field merges.
4. method according to claim 1 is characterized in that, describedly carries out the formulation of data reforming rule according to primary data information (pdi), comprising:
Select the part field in the described primary data information (pdi), with the described part field chosen as deletion according to field.
5. method according to claim 4 is characterized in that, describedly calls described reformation scheme described primary data information (pdi) is reformed, and comprising:
Call deletion in the described reformation scheme according to field;
Delete according to the data message of field comprising described deletion in the primary data information (pdi).
6. according to each described method in the claim 1 to 5, it is characterized in that, described described data reforming rule saved as the reformation scheme, comprising:
Described data reforming rule is converted into executable SQL statement;
By compiling, described data reforming rule is saved as the reformation scheme to described SQL statement.
7. a data reforming system is characterized in that, comprising: formulate the unit, preserve unit and reformer unit, wherein,
Described formulation unit is used for carrying out according to primary data information (pdi) the formulation of data reforming rule;
Described preservation unit is used for described reformation rule is saved as the reformation scheme;
Described reformer unit is used to call described reformation scheme described primary data information (pdi) is reformed.
8. system according to claim 7 is characterized in that, described formulation unit comprises: the first chooser unit and merging Rulemaking subelement, wherein,
The described first chooser unit is used for selecting the part field of described primary data information (pdi);
Described merging Rulemaking subelement, the described part field that is used for choosing is as merging according to field.
9. system according to claim 8 is characterized in that, described reformer unit comprises: first calls subelement and merges subelement, wherein,
Described first calls subelement, is used for calling the merging of described reformation scheme according to field;
Described merging subelement is used for primary data information (pdi) is comprised that described merging merges according to the data message of field.
10. system according to claim 7 is characterized in that, described formulation unit comprises: the second chooser unit and deletion rule are formulated subelement, wherein,
The described second chooser unit is used for selecting the part field of described primary data information (pdi);
Described deletion rule is formulated subelement, and the described part field that is used for choosing is as deleting according to field.
11. system according to claim 10 is characterized in that, described reformer unit comprises: second calls subelement and deletion subelement, wherein,
Described second calls subelement, is used for calling the deletion of described reformation scheme according to field;
Described deletion subelement is used for primary data information (pdi) is comprised that described deletion deletes according to the data message of field.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN200910110263A CN101699433A (en) | 2009-10-28 | 2009-10-28 | Data reforming method and system |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN200910110263A CN101699433A (en) | 2009-10-28 | 2009-10-28 | Data reforming method and system |
Publications (1)
Publication Number | Publication Date |
---|---|
CN101699433A true CN101699433A (en) | 2010-04-28 |
Family
ID=42147892
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN200910110263A Pending CN101699433A (en) | 2009-10-28 | 2009-10-28 | Data reforming method and system |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN101699433A (en) |
Cited By (5)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN102467575A (en) * | 2010-11-09 | 2012-05-23 | 富士施乐株式会社 | Log consolidation device and log consolidation method |
CN107657049A (en) * | 2017-09-30 | 2018-02-02 | 深圳市华傲数据技术有限公司 | A kind of data processing method based on data warehouse |
CN109828974A (en) * | 2019-02-28 | 2019-05-31 | 上海达梦数据库有限公司 | Data reforming method, device, equipment and storage medium |
CN110765131A (en) * | 2019-10-09 | 2020-02-07 | 苏宁云计算有限公司 | Data compression method and device for goods source data, computer equipment and storage medium |
CN112862579A (en) * | 2021-01-21 | 2021-05-28 | 金蝶软件(中国)有限公司 | Material detail data adjusting method and related equipment thereof |
-
2009
- 2009-10-28 CN CN200910110263A patent/CN101699433A/en active Pending
Cited By (7)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN102467575A (en) * | 2010-11-09 | 2012-05-23 | 富士施乐株式会社 | Log consolidation device and log consolidation method |
CN102467575B (en) * | 2010-11-09 | 2016-08-17 | 富士施乐株式会社 | Log consolidation device and daily record integration method |
CN107657049A (en) * | 2017-09-30 | 2018-02-02 | 深圳市华傲数据技术有限公司 | A kind of data processing method based on data warehouse |
CN107657049B (en) * | 2017-09-30 | 2021-02-02 | 深圳市华傲数据技术有限公司 | Data processing method based on data warehouse |
CN109828974A (en) * | 2019-02-28 | 2019-05-31 | 上海达梦数据库有限公司 | Data reforming method, device, equipment and storage medium |
CN110765131A (en) * | 2019-10-09 | 2020-02-07 | 苏宁云计算有限公司 | Data compression method and device for goods source data, computer equipment and storage medium |
CN112862579A (en) * | 2021-01-21 | 2021-05-28 | 金蝶软件(中国)有限公司 | Material detail data adjusting method and related equipment thereof |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CA2510765C (en) | Design of spreadsheet functions for working with tables of data | |
US9690875B2 (en) | Providing search results for mobile computing devices | |
US7483880B2 (en) | User interface for database display | |
CN101699433A (en) | Data reforming method and system | |
CN101025805A (en) | Product-based bill of material generating method | |
EP2526479A1 (en) | Accessing large collection object tables in a database | |
CN102207861A (en) | Method for expressing personalized information in business | |
WO2003104983A2 (en) | Enter-then-act input handling | |
CN101609473A (en) | A kind of method of Structured Query Language (SQL) of reconstruct report query and device | |
US20210165773A1 (en) | On-demand, dynamic and optimized indexing in natural language processing | |
CN110674206A (en) | Knowledge sharing platform applied to enterprises | |
US20010030666A1 (en) | Computer-human interaction apparatus and interaction system | |
US20070239663A1 (en) | Parallel processing of count distinct values | |
CN102937948B (en) | A kind of image, text and data edit methods of mobile terminal | |
CN102844774A (en) | Web page control method, computer system and program | |
CN109344296A (en) | Realize domain life cycle control method, system, server and the storage medium of the HASH key of Redis | |
Oleksik et al. | Lightweight tagging expands information and activity management practices | |
CN111782703A (en) | Method and system for automatically managing and displaying incidence relation between irrigation area object data | |
US10521854B1 (en) | Selection and display of custom user interface controls | |
KR101688829B1 (en) | Method and apparatus for providing documents reflecting user pattern | |
CN102546961A (en) | Contact lookup method and mobile terminal | |
US11036710B2 (en) | Scalable selection management | |
CN101582069B (en) | Method and device for multi-drawing management | |
US7412452B2 (en) | Data storage and retrieval system with intensional category representations to provide dynamic categorization of information items | |
US20110022639A1 (en) | Hierarchy Nodes Derived Based On Parent/Child Foreign Key And/Or Range Values On Parent Node |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
C06 | Publication | ||
PB01 | Publication | ||
C10 | Entry into substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
C12 | Rejection of a patent application after its publication | ||
RJ01 | Rejection of invention patent application after publication |
Application publication date: 20100428 |