CN1987855A - Data processing method and system - Google Patents
Data processing method and system Download PDFInfo
- Publication number
- CN1987855A CN1987855A CN 200510135320 CN200510135320A CN1987855A CN 1987855 A CN1987855 A CN 1987855A CN 200510135320 CN200510135320 CN 200510135320 CN 200510135320 A CN200510135320 A CN 200510135320A CN 1987855 A CN1987855 A CN 1987855A
- Authority
- CN
- China
- Prior art keywords
- data
- field
- definition
- record
- critical
- 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
This invention discloses a data processing method and system, after the processing of the original data it can automatically forms the data the format of which is required by the user. The data processing system at least includes the data defined area, a data pick-up module, a data temporary storage area and data processing module. This invention can automatically realize the data processing method and system and it can quickly and conveniently finish the data processing without the manual way. Even largely increase and cutting ready analysis data during latter design and modify, there is no need to waste large time to process data, so it improve the work schedule and efficient. More this data processing method and system can process data automatically, it can avoid the data leak, data repeat, wrong write which cause by the manual way.
Description
Technical field
The invention relates to a kind of data processing method and system, particularly about a kind of to printed circuit board (PCB) (Printed Circuit Board; PCB) each notes record of the raw data of wiring process generation is generated as the data processing method and the system of the required formatted data of user after treatment automatically.
Background technology
At printed circuit board (PCB) (Printed Circuit Board; PCB) in the wiring, be example, whether satisfy high speed cabling wiring rule (HighSpeed Routing Rule), will be directly connected to the reliability and the stability of mainboard for wiring with the wiring of mainboard (Motherboard).Whether definite wiring satisfies the method for high speed cabling wiring rule, generally be that particular file format is arrived in the data importing that the allegro wiring software produces, the excel software in the Office system of Microsoft exploitation for example, and can make required data content by this excel software, with manual mode this data preparation is become data orderly, that planning is arranged then, be convenient to the processing that follow-up data is analyzed operation.
Yet, the data that produce by the allegro wiring software are various, data content generally has 2000 multirows, and DATA DISTRIBUTION is mixed and disorderly, thousands of line data need carry out Treatment Analysis with manual mode, therefore, require a great deal of time in data preparation, have a strong impact on the progress and the efficient of motherboard design work, and engineering technical personnel use so innumerable and disordered data of manual mode long time treatment analysis, occur situations such as visual fatigue and spiritual fatigue easily, for example may producing, data fail to write, write more, mistake such as writes at human error, causes subsequent design generation problem and incurs loss through delay time of product turnout.
In sum, how a kind of data processing method and system are proposed, avoid disadvantages of the prior art, can save time, improve design effort progress and efficient, also can avoid because of human errors such as for example data that manual working causes fail to write, write more, mistake is write, real in needing the technical task of solution at present badly.
Summary of the invention
For overcoming the shortcoming of above-mentioned prior art, fundamental purpose of the present invention is to provide a kind of data processing method and system, can realize the fast processing and analysis of data with automated manner, saves time, improves job schedule and efficient.
A further object of the present invention is to provide a kind of data processing method and system, human error such as for example data of avoiding causing because of the manual mode operation in the prior art fail to write, write more, mistake is write.
For reaching above-mentioned and other purpose, the invention provides a kind of data processing method, each notes record of one raw data is become to give birth to after treatment automatically the data of the required form of user, this data processing method may further comprise the steps at least: set up a data field definition with a plurality of fields according to user's request definition, these fields comprise a critical field at least; From each notes record of this raw data, extract the field data with the corresponding field of field of this data field definition, and the field data that each notes record is extracted is formed notes record, and be stored in the data working area; And with reference to the critical field of this data field definition definition, from this data working area, take out the record corresponding and carry out packet transaction with this critical field, when each the notes record that stores in this data working area is identical with the field data of the critical field corresponding field of this data field definition, the record identical with the field data of this critical field corresponding field is divided into one group of data.
For reaching above-mentioned identical purpose, the present invention also provides a kind of data handling system, each notes record of one raw data is generated as after treatment automatically the data of the required form of user, this data handling system comprises at least: a data field definition, comprise at least one field, and this field comprises a critical field at least according to the user's request definition; One data extraction module is extracted the field data with the corresponding field of field of this data field definition from each notes record of this raw data, the field data that each notes record is extracted is formed notes and recorded; One data working area stores each notes record that this data extraction module is formed; An and data processing module, critical field according to this data field definition definition, from this data working area, take out the record corresponding and carry out packet transaction with this critical field, when each the notes record that stores in this data working area is identical with the field data of the critical field corresponding field of this data field definition, the record identical with the field data of this critical field corresponding field is divided into one group of data.
Compared with prior art, data processing method of the present invention and system extract from this raw data and corresponding each the notes record of the field of this data field definition, and corresponding being stored in each data field in this data working area, and the critical field that defines with reference to this data field definition via this data processing module, the record that is stored in this data working area is carried out packet transaction, and then automatically the data in the raw data of disperseing are classified by demand and return, and generate user requested data.
Therefore, the method and system of data processing of the present invention need not raw data to be generated required data fast automaticly by manual mode, even increase or delete the data of a large amount of processing to be analyzed in the subsequent job, must consuming timely not reach the difference of finding out data arduously yet, improve whole job schedule and efficient.The generation of human errors such as moreover data processing method of the present invention and system adopt automated manner, and the data that can avoid causing because of the manual mode operation in the prior art fail to write, write more, mistake is write.
Description of drawings
Fig. 1 is the basic framework block schematic diagram of data handling system of the present invention;
Fig. 2 A is the content synoptic diagram of data handling system raw data of the present invention;
Fig. 2 B is the content synoptic diagram that data handling system of the present invention is generated as the raw data of allegro wiring software generation user requested data automatically;
Fig. 3 is the synoptic diagram that another raw data that allegro wiring software is produced of data handling system of the present invention is generated as user requested data automatically; And
Fig. 4 is the operation workflow synoptic diagram of data processing method of the present invention.
Embodiment
Embodiment
Fig. 1 is the basic framework block schematic diagram of data handling system of the present invention.Data handling system 1 of the present invention is applied in printed circuit board (PCB) (Printed Circuit Board; PCB) in the wiring, respectively the taking down notes of raw data that produces in one wiring process recorded, automatically generate the data of the required form of user after treatment, need not to finish and to obtain required data layout fast by manual mode, as shown in the figure, data handling system 1 of the present invention comprises raw data 10, data field definition 12, data extraction module 14, data working area 16 and data processing module 18, in data handling system 1 of the present invention, the data that this raw data 10 and data field definition 12 store can be the forms forms.Below promptly data handling system 1 of the present invention is elaborated.
This data field definition 12 comprises a plurality of according to the predefined field of user's request (Field), these fields comprise a critical field (Key Field) at least, to data that should critical field grouping benchmark as the follow-up data processing operation, this critical field quantity can define according to the actual requirements, holds the back explanation about this critical field quantity and data processing relation.
This data extraction module 14 is extracted the field data with the corresponding field of field of this data field definition 12 from each notes record of this raw data 10, and the field data that each notes record is extracted is formed notes record.
This data working area 16 stores each notes record that this data extraction module 14 is formed, can comprise a plurality of and the corresponding data field of a plurality of fields this data field definition 12, wherein the data field corresponding with the critical field of this data field definition 12, this data working area 16 is the critical data district.
The record that stores in this data processing module 18 each data field with this data working area 16 carries out packet transaction, wherein identical with the field data of the critical field corresponding field of this data field definition 12 according to each notes record of these data working area 16 storages, then the record identical with the field data of this critical field corresponding field is divided into one group of data, automatically the data in the raw data 10 of disperseing carried out sortmerge by demand and generate user requested data 2.
Generating the printed circuit board wiring user requested datas in order more clearly understand to use the raw data 10 how data handling system 1 of the present invention to produce the allegro wiring software, will further specify the interactively of data handling system 1 each member of the present invention for example at this.
At first, set up a data field definition 12 with a plurality of fields as required, in this example, these fields are respectively pin (pin) file-name field that comprises of cabling group name field, each cabling group and the spacing field corresponding respectively with each pin, wherein, the critical field (Key Field) that to define this cabling group name field be this data field definition 12; Secondly, set up a data working area 16, these data working area 16 corresponding these fields have a plurality of data fields (being cabling group name data field, pin name data field and spacing data district), and wherein this example is as the critical data district with cabling group name data field; Then, take down notes the record by this data extraction module 14 each from this raw data 10, extract field data with the corresponding field of field of this data field definition 12, and the field data that each notes record is extracted is formed a notes record, and corresponding being stored in each data field in this data working area 16, and the critical field that defines with reference to this data field definition 12 via this data processing module 18, the record that is stored in this data working area 16 is carried out packet transaction, automatically with the data in the raw data 10 of disperseing, carry out sortmerge on demand and generate user requested data 2.
For example, number notes record is arranged in raw data 10, shown in Fig. 2 A, these records have fields such as cabling group name field, pin file-name field and spacing field respectively.With regard to this example, the field of user's request has only cabling group name field, pin file-name field and three fields of spacing field, and to define this cabling group name field be critical field, and these definition information promptly are stored in this data field definition 12.So this data extraction module 14 is promptly from each notes record (shown in Fig. 2 A) of this raw data 10, extract and the corresponding record of these data field definition 12 define fields, and make the series arrangement of increasing or decreasing with the critical field data according to user's request by this data processing module 18, or with identical the dividing of data of critical field, i.e. forms shown in Fig. 2 B.
Consult Fig. 3, it is the content synoptic diagram that another raw data that allegro wiring software is produced of data handling system of the present invention is generated as user requested data.Be that with the difference of above-mentioned processing procedure maximum the data field definition 12 of above-mentioned processing procedure is critical field of definition, the data field definition among Fig. 3 is a definition both keyword section, is respectively primary key section and secondary key section.So this data extraction module 14 is promptly extracted and the corresponding record of these data field definition 12 define fields from each notes record of this raw data 10, and by this data processing module 18 according to user's request, do the ordering of increasing or decreasing with the data of primary key section and secondary key section, or the critical field data identical be one group of division of writing down block.
Need to prove herein, critical field quantity is not exceeded so that present embodiment is described, it can correspondingly increase and reduction according to the actual requirements, but, increase along with critical field quantity, only need to adopt to carry out progressive grouping according to the mutual relation of inclusion of critical field, can finish processing operation this batch data in this raw data 10 as the way of present embodiment.
Fig. 4 is the operation workflow of data processing method of the present invention, and data processing method of the present invention is applied in the printed circuit board wiring, each notes record of a raw data is generated as after treatment automatically the data of the required form of user.
Please consult Fig. 4 and Fig. 1 simultaneously, at first carry out step S100, set up a data field definition 12 with a plurality of fields (Field) according to user's request definition, these fields comprise a critical field (Key Field) at least, to data that should critical field are grouping benchmark as the follow-up data processing operation, and this critical field quantity can define according to the actual requirements, then carries out step S110.
In step S110, set up a data working area 16, a plurality of fields that 16 pairs in this data working area should data field definition 12 have a plurality of data fields, are the critical data districts to data field that should critical field wherein, then carry out step S120.
In step S120, from this raw data 10, extract and corresponding each the notes record of these data field definition 12 fields, and in corresponding each data field that is stored into the temporary definition 12 of these data, then carry out step S130.
In step S130, the record that stores in this data processing module 18 each data field with this data working area 16 carries out packet transaction, wherein each the notes record that stores according to this data working area 16 is identical with the field data of the critical field corresponding field of this data field definition 12, then the record identical with the field data of this critical field corresponding field is divided into one group of data, then carries out step S140.
In step S140, this data processing module 18 will generate the required data of user after the packet transaction, answer the user to need these data to be exported with tabulation or will be offered the user after the file storage.
In sum, data processing method of the present invention and system extract raw data and the predefined critical field of this data field definition and handle, when each the notes record that stores in this data working area is identical with the field data of the critical field corresponding field of this data field definition, the record identical with the field data of this critical field corresponding field is divided into one group of data, use it as the grouping benchmark that follow-up data is handled, automatically the data in the raw data 10 of disperseing are carried out sortmerge by demand, generate user requested data 2.
Correspondingly, of the present inventionly can realize data processing method and system automatically, need not to finish data quickly and easily and generate processing operation by manual mode, even increase or delete the data of a large amount of processing to be analyzed in the work such as subsequent design or change newly, also need not expend when too many and energy carries out deal with data, improve the progress and the efficient of work.Human errors such as moreover data processing method of the present invention and system adopt automated manner that data are handled, and the data that can avoid causing because of the manual mode operation in the prior art fail to write, write more, mistake is write.
Claims (8)
1. a data processing method is recorded the data that become to give birth to the required form of user after treatment automatically with each notes of a raw data, and this data processing method may further comprise the steps at least:
Set up a data field definition with a plurality of fields according to user's request definition, these fields comprise a critical field at least;
From each notes record of this raw data, extract the field data with the corresponding field of field of this data field definition, and the field data that each notes record is extracted is formed notes record, and be stored in the data working area; And
Critical field with reference to this data field definition definition, from this data working area, take out the record corresponding and carry out packet transaction with this critical field, when each the notes record that stores in this data working area is identical with the field data of the critical field corresponding field of this data field definition, the record identical with the field data of this critical field corresponding field is divided into one group of data.
2. data processing method as claimed in claim 1, it is characterized in that, after will the record identical being divided into one group of data with the field data of this critical field corresponding field, the data that obtain after can will dividing according to user's request with the field data of this critical field corresponding field as the foundation that puts in order.
3. data processing method as claimed in claim 2 is characterized in that, this increasing or decreasing that puts in order.
4. data processing method as claimed in claim 1 is characterized in that, the user requested data that generates after packet transaction is exported or stored into file mode in the tabulation mode and offers the user.
5. a data handling system is recorded the data that are generated as the required form of user after treatment automatically with each notes of a raw data, it is characterized in that this data handling system comprises at least:
One data field definition comprise at least one field according to the user's request definition, and this field comprises a critical field at least;
One data extraction module is extracted the field data with the corresponding field of field of this data field definition from each notes record of this raw data, the field data that each notes record is extracted is formed notes and recorded;
One data working area stores each notes record that this data extraction module is formed; And
One data processing module, critical field according to this data field definition definition, from this data working area, take out the record corresponding and carry out packet transaction with this critical field, when each the notes record that stores in this data working area is identical with the field data of the critical field corresponding field of this data field definition, the record identical with the field data of this critical field corresponding field is divided into one group of data.
6. data handling system as claimed in claim 5, it is characterized in that, after will the record identical being divided into one group of data with the field data of this critical field corresponding field, the data that obtain after can will dividing according to user's request, with the field data of this critical field corresponding field as the foundation that puts in order.
7. data handling system as claimed in claim 6 is characterized in that, this increasing or decreasing that puts in order.
8. data handling system as claimed in claim 6 is characterized in that, the user requested data that generates after packet transaction is to export or be stored as file mode in the tabulation mode to offer the user.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN 200510135320 CN1987855A (en) | 2005-12-20 | 2005-12-20 | Data processing method and system |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN 200510135320 CN1987855A (en) | 2005-12-20 | 2005-12-20 | Data processing method and system |
Publications (1)
Publication Number | Publication Date |
---|---|
CN1987855A true CN1987855A (en) | 2007-06-27 |
Family
ID=38184654
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN 200510135320 Pending CN1987855A (en) | 2005-12-20 | 2005-12-20 | Data processing method and system |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN1987855A (en) |
Cited By (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN102004763A (en) * | 2010-11-03 | 2011-04-06 | 北京世纪高通科技有限公司 | Data detection method and device |
CN102298623A (en) * | 2011-08-15 | 2011-12-28 | 北京神州泰岳软件股份有限公司 | Method for acquiring dialog list data |
CN107301210A (en) * | 2017-06-06 | 2017-10-27 | 福建中经汇通有限责任公司 | A kind of data processing method |
-
2005
- 2005-12-20 CN CN 200510135320 patent/CN1987855A/en active Pending
Cited By (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN102004763A (en) * | 2010-11-03 | 2011-04-06 | 北京世纪高通科技有限公司 | Data detection method and device |
CN102298623A (en) * | 2011-08-15 | 2011-12-28 | 北京神州泰岳软件股份有限公司 | Method for acquiring dialog list data |
CN107301210A (en) * | 2017-06-06 | 2017-10-27 | 福建中经汇通有限责任公司 | A kind of data processing method |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN101739292B (en) | Based on isomeric group operation self-adapting dispatching method and the system of application characteristic | |
CN104361018B (en) | Electronic archives information reorganization method and device | |
CN103955577B (en) | Computer automatic design method for mechanical equipment | |
CN102087657B (en) | IO (Input/output) to point method and IO (Input/output) to point for nuclear power plant simulation platform | |
CN107992492B (en) | Data block storage method, data block reading method, data block storage device, data block reading device and block chain | |
CN102521723B (en) | The online acquisition methods of a kind of discrete workshop logistics information based on REID | |
CN102208057A (en) | Method, platform and system for processing audit information | |
CN112115145A (en) | Data acquisition method and device, electronic equipment and storage medium | |
CN111738674A (en) | Contract mobile approval implementation method and system | |
CN102169491A (en) | Dynamic detection method for multi-data concentrated and repeated records | |
CN110766369A (en) | Visual webpage intelligent storage position arrangement system | |
CN102915488A (en) | Online intelligent design system of engineering project and method of system | |
CN101706829A (en) | Data storage method and device | |
CN1987855A (en) | Data processing method and system | |
CN114706915A (en) | Method for building BOM information from PLM system by EDA software | |
CN110532535A (en) | A kind of government intelligence list interactive system | |
CN101504610A (en) | Management software development method and system | |
CN202331554U (en) | Equipment management system | |
CN115018413A (en) | Automobile part technical description information cross-system transmission system and transmission method thereof | |
CN106570682A (en) | Production control method based on drawing inspection optimization | |
CN109685453B (en) | Method for intelligently identifying effective paths of workflow | |
CN107291614A (en) | File method for detecting abnormality and electronic equipment | |
CN103366234A (en) | System and method for operation procedure management | |
EP1193630A1 (en) | Agile information system and management method | |
CN111651259A (en) | Dependency relationship-based system management method and device and storage medium |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
C06 | Publication | ||
PB01 | Publication | ||
C10 | Entry into substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
C02 | Deemed withdrawal of patent application after publication (patent law 2001) | ||
WD01 | Invention patent application deemed withdrawn after publication |