CN109241351A - A kind of multi-source heterogeneous data preparation method of board production - Google Patents
A kind of multi-source heterogeneous data preparation method of board production Download PDFInfo
- Publication number
- CN109241351A CN109241351A CN201810794098.0A CN201810794098A CN109241351A CN 109241351 A CN109241351 A CN 109241351A CN 201810794098 A CN201810794098 A CN 201810794098A CN 109241351 A CN109241351 A CN 109241351A
- Authority
- CN
- China
- Prior art keywords
- data
- excel
- database
- source heterogeneous
- heterogeneous data
- 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
Landscapes
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention discloses the multi-source heterogeneous data preparation methods of kind of board production, comprising: step 1 formulates the identifiable EXCEL document template of database；Step 2, the multi-source heterogeneous data that board production is obtained from sensor network；The multi-source heterogeneous data include: EXCEL formatted data, picture format data；The multi-source heterogeneous data are changed into the identifiable EXCEL document of database according to the EXCEL document template by step 3；The identifiable EXCEL document of database that step 3 obtains is entered into database by step 4.Using EXCEL document template as standard, by multi-source heterogeneous data according to the template unified standardization so that multi-source heterogeneous data with the storage of excel uniform format in the database, facilitate and carry out data call and data mining.This method can be used for the processing of industrial big data.
Description
Technical field
The present invention relates to technical field of data processing, in particular to the multi-source heterogeneous data preparation side of a kind of board production
Method.
Background technique
Industrial big data refers in industrial circle, around typical intelligence manufacture mode, from customer demand to selling, order
List, plan, research and development, design, technique, manufacture, buying, supply, inventory, delivery and delivery, O&M, are scrapped or are returned at after-sale service
Receive the general name for Various types of data and the relevant technologies and application caused by entire product lifecycle links such as remanufacturing.Its
Using product data as core, the traditional industry that greatly extended data area, while further including industrial big data the relevant technologies and answering
With.
The production line of available circuit plate generally comprises tin cream station, patch station, welding post, AOI detection station, survey
Trial work position, wherein upper tin cream station, patch station, welding post, AOI detection station all realize automation, and test station is also
It is to use based on artificial detection.For the ease of monitoring, upper tin cream station, patch station, welding post, AOI detection station, test
Station, workshop are equipped with the sensor network of signal acquisition, these sensor networks can transfer data to background terminal, with
Data preparation is carried out for factory management personnel.The characteristics of due to each station, is different, and the data of acquisition are then different.Due to acquisition
Data type and source it is different, these data can be described as multi-source heterogeneous data.For example, upper tin cream station, patch work
The data for the EXCEL format that the data of position, welding post acquisition and transmission are then automatically generated, the acquisition of AOI detection station and biography
What is sent is picture format data, and test station is then the data for the EXCEL format being manually entered.Wherein, the EXCEL automatically generated
The data of format and the data for the EXCEL format being manually entered are due to being EXCEL format, thus, it is believed that being same class number
According to, therefore, for the production line of circuit board, multi-source heterogeneous data include: EXCEL formatted data, picture format data,
The data of both types.But these data can not be all directly stored in database, be unfavorable for the later period to the tune of these data
With and excavate.
Summary of the invention
The object of the present invention is to provide a kind of multi-source heterogeneous data preparation methods of board production, to facilitate circuit
Plate creation data is entered into database.
The solution that the present invention solves its technical problem is: a kind of multi-source heterogeneous data preparation side of board production
Method, comprising:
Step 1 formulates the identifiable EXCEL document template of database；
Step 2, the multi-source heterogeneous data that board production is obtained from sensor network；
The multi-source heterogeneous data include: EXCEL formatted data, picture format data；
Step 3, that the multi-source heterogeneous data are changed into database according to the EXCEL document template is identifiable
EXCEL document；
The identifiable EXCEL document of database that step 3 obtains is entered into database by step 4.
Further, in step 3, the multi-source heterogeneous data are changed into the side of the identifiable EXCEL document of database
Method includes:
EXCEL formatted data is converted to XML document by step 3.1, and picture format data are converted to XML document；
Step 3.2, the EXCEL document template according to step 1, the XML document is converted to database by creation can
The script of the EXCEL format file of identification；
Step 3.3, the operation script, obtain the identifiable EXCEL format file of database.
Further, in step 3.1, include: by the method that picture format data are converted to XML document
Step 3.1.1, in picture format data being uploaded onto the server；
Step 3.1.2, server calls intelligent algorithm；
Step 3.1.3, the described intelligent algorithm identifies the information of the picture format data recordation, and by the information
Be converted to XML document.
The beneficial effects of the present invention are: using EXCEL document template as standard, by multi-source heterogeneous data according to the template
Unified standardization so that multi-source heterogeneous data with the storage of excel uniform format in the database, facilitate carry out data call and
Data mining.
Detailed description of the invention
To describe the technical solutions in the embodiments of the present invention more clearly, make required in being described below to embodiment
Attached drawing is briefly described.Obviously, described attached drawing is a part of the embodiments of the present invention, rather than is all implemented
Example, those skilled in the art without creative efforts, can also be obtained according to these attached drawings other designs
Scheme and attached drawing.
Fig. 1 is the step flow chart of the method for the present invention.
Specific embodiment
It is carried out below with reference to technical effect of the embodiment and attached drawing to design of the invention, specific structure and generation clear
Chu is fully described by, to be completely understood by the purpose of the present invention, feature and effect.Obviously, described embodiment is this hair
Bright a part of the embodiment, rather than whole embodiments, based on the embodiment of the present invention, those skilled in the art are not being paid
Other embodiments obtained, belong to the scope of protection of the invention under the premise of creative work.In addition, be previously mentioned in text
All connection/connection relationships not singly refer to that component directly connects, and referring to can be added deduct according to specific implementation situation by adding
Few couple auxiliary, to form more preferably coupling structure.Each technical characteristic in the invention, in not conflicting conflict
Under the premise of can be with combination of interactions.
Embodiment 1, with reference to Fig. 1, a kind of multi-source heterogeneous data preparation method of board production, comprising:
Step 1 formulates the identifiable EXCEL document template of database；
Step 2 obtains multi-source heterogeneous data when board production from sensor network；
Wherein, the multi-source heterogeneous data include: EXCEL formatted data, picture format data；
Step 3, that the multi-source heterogeneous data are changed into database according to the EXCEL document template is identifiable
EXCEL document；
The identifiable EXCEL document of database that step 3 obtains is entered into database by step 4.
Specifically, first according to board production the characteristics of, formulate can effective writing circuit plate creation data table, and
This table is generated as EXCEL format file, and is inserted into the program generation of input database on the EXCEL format file
Code is such as inserted into " insert sentence ", to obtain the identifiable EXCEL document template of database；Secondly, from sensor network
The multi-source heterogeneous data that generate when obtaining board production, wherein including from upper tin cream station, patch station, welding post, survey
The EXCEL formatted data that trial work position obtains, the picture format data obtained from AOI detection station；Again, according to EXCEL document
Template, the EXCEL formatted data and picture format data that will acquire are changed into the identifiable EXCEL document of database respectively；Its
In, include: by the method that formatted data and picture format data are changed into the identifiable EXCEL document of database respectively
EXCEL formatted data is converted to XML document by step 3.1, and picture format data are converted to XML document；
Step 3.2, the EXCEL document template according to step 1, the XML document is converted to database by creation can
The script of the EXCEL format file of identification；
Step 3.3, the operation script, obtain the identifiable EXCEL format file of database.
Specifically, firstly, EXCEL formatted data and picture format data are converted to XML document respectively, wherein will
EXCEL formatted data is converted to XML document, and script file can be converted by one format of creation, which converts script file
EXCEL formatted data is converted to XML document by executable format conversion instruction.By taking Windows system as an example, conversion script text
The process of the execution of part includes: that the mapping xml source file of a corresponding unloading xml is first write according to the attribute of excel table；Root again
According to " source " of xml, xml mapping window is obtained in excel window；The xml document of window Choose for user is mapped by xml again
Task.xml finds taskData node from task.xml；Finally, taskData node is loaded on the ID of excel table
The conversion of xml format can be completed, obtain XML document.
For picture format data are converted to XML document, since picture format data are interactive data, Wu Fazhuan
It is changed to XML document, therefore, picture format data are converted to XML document needs and the picture format data are uploaded onto the server
In, then, server calls intelligent algorithm, the intelligent algorithm has image recognition function, passes through artificial intelligence
Algorithm identifies the information of picture format data recordation, forms text information, and the text information is converted to XML text
Shelves.
, can be according to EXCEL document template after getting XML document, the XML document that creating will acquire is converted to database
The script of identifiable EXCEL format file；By Run Script, by XML document batch processing at the identifiable EXCEL of database
Document.
The identifiable EXCEL document of database is obtained, the identifiable EXCEL document of database can be imported into data
In library.
The invention is sought unity of standard using EXCEL document template as standard, by multi-source heterogeneous data according to the template
Change so that multi-source heterogeneous data with the storage of excel uniform format in the database, facilitate and carry out data call and data and dig
Pick.
A kind of multi-source heterogeneous data preparation method of board production can run on desktop PC, notes
Originally, palm PC and cloud server etc. calculate in equipment.A kind of multi-source heterogeneous data preparation method of the board production
The device that can be run may include, but be not limited only to, processor, memory.It will be understood by those skilled in the art that the example is only
It is only the example of a kind of multi-source heterogeneous data preparation method of board production, does not constitute the multi-source to a kind of board production
The restriction of isomeric data method for sorting may include component more more or fewer than example, perhaps combine certain components or not
With component, such as a kind of board production multi-source heterogeneous data preparation method can also include input-output equipment,
Network access equipment, bus etc..
Alleged processor can be central processing unit (Central Processing Unit, CPU), can also be it
His general processor, digital signal processor (Digital Signal Processor, DSP), specific integrated circuit
(Application Specific Integrated Circuit, ASIC), ready-made programmable gate array (Field-
Programmable Gate Array, FPGA) either other programmable logic device, discrete gate or transistor logic,
Discrete hardware components etc..General processor can be microprocessor or the processor is also possible to any conventional processor
Deng, the processor is a kind of control centre of the multi-source heterogeneous data preparation method running gear of board production, benefit
With various interfaces and connection entirely a kind of board production multi-source heterogeneous data preparation method can running gear it is each
Part.
The memory can be used for storing the computer program and/or module, and the processor is by operation or executes
Computer program in the memory and/or module are stored, and calls the data being stored in memory, described in realization
A kind of various functions of the multi-source heterogeneous data preparation method of board production.The memory can mainly include storing program area
The storage data area and, wherein storing program area can (such as the sound of application program needed for storage program area, at least one function
Sound playing function, image player function etc.) etc.；Storage data area can store according to mobile phone use created data (such as
Audio data, phone directory etc.) etc..In addition, memory may include high-speed random access memory, it can also include non-volatile
Memory, such as hard disk, memory, plug-in type hard disk, intelligent memory card (Smart Media Card, SMC), secure digital
(Secure Digital, SD) card, flash card (Flash Card), at least one disk memory, flush memory device or other
Volatile solid-state part.
Better embodiment of the invention is illustrated above, but the invention is not limited to the implementation
Example, those skilled in the art can also make various equivalent modifications on the premise of without prejudice to spirit of the invention or replace
It changes, these equivalent variation or replacement are all included in the scope defined by the claims of the present application.
Claims (3)
1. a kind of multi-source heterogeneous data preparation method of board production characterized by comprising
Step 1 formulates the identifiable EXCEL document template of database；
Step 2, the multi-source heterogeneous data that board production is obtained from sensor network；
The multi-source heterogeneous data include: EXCEL formatted data, picture format data；
The multi-source heterogeneous data are changed into the identifiable EXCEL text of database according to the EXCEL document template by step 3
Shelves；
The identifiable EXCEL document of database that step 3 obtains is entered into database by step 4.
2. a kind of multi-source heterogeneous data preparation method of board production according to claim 1, which is characterized in that
In step 3, include: by the method that the multi-source heterogeneous data are changed into the identifiable EXCEL document of database
EXCEL formatted data is converted to XML document by step 3.1, and picture format data are converted to XML document；
Step 3.2, the EXCEL document template according to step 1, the XML document is converted to database by creation can recognize
EXCEL format file script；
Step 3.3, the operation script, obtain the identifiable EXCEL format file of database.
3. a kind of multi-source heterogeneous data preparation method of board production according to claim 2, which is characterized in that in step
In rapid 3.1, include: by the method that picture format data are converted to XML document
Step 3.1.1, in picture format data being uploaded onto the server；
Step 3.1.2, server calls intelligent algorithm；
Step 3.1.3, the described intelligent algorithm identifies the information of the picture format data recordation, and the information is converted
For XML document.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810794098.0A CN109241351A (en) | 2018-07-19 | 2018-07-19 | A kind of multi-source heterogeneous data preparation method of board production |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810794098.0A CN109241351A (en) | 2018-07-19 | 2018-07-19 | A kind of multi-source heterogeneous data preparation method of board production |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN109241351A true CN109241351A (en) | 2019-01-18 |
Family
ID=65072095
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201810794098.0A Pending CN109241351A (en) | 2018-07-19 | 2018-07-19 | A kind of multi-source heterogeneous data preparation method of board production |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN109241351A (en) |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111125213A (en) * | 2019-11-29 | 2020-05-08 | 北京数起科技有限公司 | Data acquisition method, device and system |
| CN112148741A (en) * | 2020-10-16 | 2020-12-29 | 中石化重庆涪陵页岩气勘探开发有限公司 | Petroleum geological data loading method and device, server and storage medium |
| CN112232352A (en) * | 2020-11-12 | 2021-01-15 | 深圳聚谷科技有限公司 | Automatic pricing system and method for intelligently identifying PCB drawings |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103577611A (en) * | 2013-11-25 | 2014-02-12 | 方正国际软件有限公司 | Data unifying device and data unifying method |
| CN103744982A (en) * | 2014-01-15 | 2014-04-23 | 北京神州普惠科技股份有限公司 | Method for importing Excel data into database |
| CN104200402A (en) * | 2014-09-11 | 2014-12-10 | 国家电网公司 | Publishing method and system of source data of multiple data sources in power grid |
| CN104317974A (en) * | 2014-11-21 | 2015-01-28 | 武汉理工大学 | Reconfigurable multi-source data importing method in ERP system |
| CN107944013A (en) * | 2017-12-08 | 2018-04-20 | 珠海华索软件科技有限公司 | A kind of database code generation method and system |
-
2018
- 2018-07-19 CN CN201810794098.0A patent/CN109241351A/en active Pending
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103577611A (en) * | 2013-11-25 | 2014-02-12 | 方正国际软件有限公司 | Data unifying device and data unifying method |
| CN103744982A (en) * | 2014-01-15 | 2014-04-23 | 北京神州普惠科技股份有限公司 | Method for importing Excel data into database |
| CN104200402A (en) * | 2014-09-11 | 2014-12-10 | 国家电网公司 | Publishing method and system of source data of multiple data sources in power grid |
| CN104317974A (en) * | 2014-11-21 | 2015-01-28 | 武汉理工大学 | Reconfigurable multi-source data importing method in ERP system |
| CN107944013A (en) * | 2017-12-08 | 2018-04-20 | 珠海华索软件科技有限公司 | A kind of database code generation method and system |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111125213A (en) * | 2019-11-29 | 2020-05-08 | 北京数起科技有限公司 | Data acquisition method, device and system |
| CN112148741A (en) * | 2020-10-16 | 2020-12-29 | 中石化重庆涪陵页岩气勘探开发有限公司 | Petroleum geological data loading method and device, server and storage medium |
| CN112232352A (en) * | 2020-11-12 | 2021-01-15 | 深圳聚谷科技有限公司 | Automatic pricing system and method for intelligently identifying PCB drawings |
| CN112232352B (en) * | 2020-11-12 | 2024-05-28 | 深圳聚谷科技有限公司 | Automatic pricing system and method for intelligent recognition of PCB drawing |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US10048946B2 (en) | Converting visual diagrams into code | |
| US20210049711A1 (en) | Method of automatically transmitting data information and device of automatically transmitting data information | |
| CN104881318B (en) | A kind of interface call method, device and terminal | |
| US11797273B2 (en) | System and method for enhancing component based development models with auto-wiring | |
| US10354343B2 (en) | Automated process control hardware engineering using schema-represented requirements | |
| CN104102489A (en) | Third-party database APP (Application) construction system and construction method | |
| CN109241351A (en) | A kind of multi-source heterogeneous data preparation method of board production | |
| CN108536745B (en) | Shell-based data table extraction method, terminal, equipment and storage medium | |
| CN109636301A (en) | Workflow configuration method, system, terminal and the readable storage medium storing program for executing of financial business | |
| CN109917978B (en) | BiM model-based annotation corresponding component display method and device and storage device | |
| CN110866382A (en) | Document generation method, device, terminal equipment and medium | |
| CN108805590A (en) | A kind of agricultural product traceability system based on block chain | |
| CN107465687A (en) | A kind of implementation method of authority configuration, device and terminal | |
| CN111309868A (en) | Knowledge graph construction and retrieval method and device | |
| CN109726295A (en) | Brand knowledge map display methods, device, figure server and storage medium | |
| CN112328592A (en) | Data storage method, electronic device and computer readable storage medium | |
| CN115311399A (en) | Image rendering method and device, electronic equipment and storage medium | |
| CN114969215A (en) | Method for automatically loading data in batches on data warehouse source layer and related equipment | |
| CN114444478A (en) | Voucher visualization method and device, electronic equipment and storage medium | |
| CN112990783A (en) | Material allocation method, system, equipment and medium | |
| CN107679222A (en) | Image processing method, mobile terminal and computer-readable recording medium | |
| CN111695077A (en) | Asset information pushing method, terminal equipment and readable storage medium | |
| CN113867778B (en) | Image file generation method and device, electronic equipment and storage medium | |
| CN116739845A (en) | Contract generation method and device, electronic equipment and storage medium | |
| CN115114321A (en) | Dynamic query method and system |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20190118 |