CN110515955A - Storage, querying method, system, electronic equipment and the storage medium of data - Google Patents
Storage, querying method, system, electronic equipment and the storage medium of data Download PDFInfo
- Publication number
- CN110515955A CN110515955A CN201910821324.4A CN201910821324A CN110515955A CN 110515955 A CN110515955 A CN 110515955A CN 201910821324 A CN201910821324 A CN 201910821324A CN 110515955 A CN110515955 A CN 110515955A
- Authority
- CN
- China
- Prior art keywords
- data
- production
- production test
- module
- erect
- 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.)
- Granted
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2455—Query execution
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/284—Relational databases
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Software Systems (AREA)
- Computational Linguistics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a kind of storage of data, querying method, system, electronic equipment and storage medium, the control method includes obtaining the production test tool of the production test erect-position corresponding production test data of different time stamp when produce current production;Obtain the characterize data for characterizing the production test data;Successively the characterize data is stored sequentially in time in the local data base into the production test erect-position.The present invention has greatly improved the stability of data transmission, shortens each mould group production test duration, improves mould group production test efficiency;The production test data being locally stored are obtained according to the characterize data of local SQLite database and are uploaded in MongoDB in its original format, to guarantee the consistency of data access;It inquires MongoDB, Production database and summary journal database respectively additionally by product ID and obtains required data, have the advantages that inquiry velocity is fastly and high-efficient.
Description
Technical field
The present invention relates to technical field of data storage, in particular to a kind of storage of data, querying method, system, electronics
Equipment and storage medium.
Background technique
MES (manufacturing enterprise's production process executes system) factory generates during production product (such as radio communication mold group)
A large amount of data file, for example the Log file (according to abstract will file) of 2,000,000 300B-4KB, 100,000,000 can be generated daily
Mould group Parameter File of 60KB-70KB etc., and these data files will at least retain 5 years, the relevant industries such as vehicle-mounted require at least
Retain 10 years.
Currently, mainly by the production test tool of each production test erect-position that Log file and mould group Parameter File is first
It is stored in local, associated data files synchronous classification is then uploaded to by FTP service by File Transfer Protocol (File Transfer Protocol)
Device, as long as production test tool could continue a piece of mould group under production test after the completion of current mould group data upload;Work as needs
It when retrieval, then needs to log in ftp server, searches file destination according to the set tree-like screening to save contents in layer,
Then it downloads and checks.
And the above-mentioned mode stored to the production test data of radio communication mold group in process of production exists such as
Lower problem:
1) it when by related data synchronized upload FTP, if uploading unsuccessfully is test crash, needs to retest, this mistake
Journey can cause testing efficiency to reduce or even stop line because of the factors such as unstable networks or ftp server problem, seriously affect production capacity;Or
When uploading failure without resurveying, and data file loss is easily lead in this way;
2) 100ms is needed with the upload of each file to calculate, 2,000,000 files amount to daily spends 55H, therefore can add up
Lose many production capacities;
3) mass small documents are stored in ftp server, and query and search is extremely difficult, and catalogue is easy to failure, inquiry effect
Rate is low;
4) mass small documents are stored in ftp server, are not easy to backup transfer;
5) higher to ftp server requirement in peak traffic, it is easy to appear choking phenomena at this time, will lead to upload
Time extends, and results even in the case where high-volume uploads failure.
Summary of the invention
The technical problem to be solved by the present invention is in order to overcome in the prior art to radio communication mold group in process of production
The mode that is stored of production test data be easy transmission failure, reduce testing efficiency, seriously affect production capacity;And there is inquiry
It is easy failure, search efficiency is low etc., and defects, storage, querying method, system, electronic equipment and the storage for providing a kind of data are situated between
Matter.
The present invention is to solve above-mentioned technical problem by following technical proposals:
The present invention provides a kind of control method of data storage in process of producing product, and the control method includes:
S1. production test tool corresponding production of different time stamp when producing current production of production test erect-position is obtained
Test data;
S2. the characterize data for characterizing the production test data is obtained;
Wherein, the corresponding data volume of the characterize data is less than the corresponding data volume of the production test data;
S3., the characterize data is successively stored to the local data base into the production test erect-position sequentially in time
In.
Preferably, when the local data transit module in the production test erect-position, step S3 includes:
S31. the characterize data is stored to the local data transit module;
S32. data storage request is obtained;
S33. according to the data storage request by the characterize data in the local data transit module store to
In the local data base in the production test erect-position.
Preferably, after rapid S1, before step S2 further include:
S11. the production test data are stored into being locally stored in module into the production test erect-position;
After step S3 further include:
S4. it when the local data transit module opens a data line journey, then successively reads sequentially in time
Take the characterize data in the local data base;
S5. the corresponding production test data in module are locally stored according to characterize data acquisition;
S6. the production test data that successively will acquire sequentially in time are uploaded in document data bank.
Preferably, the document data bank includes MongoDB (database based on distributed document storage);
When the production test data are the data of binary format, step S6 includes:
Successively the production test data storage of binary format is uploaded in MongoDB sequentially in time.
Preferably, the control method further include:
The corresponding production test tool data of production test tool in the production test erect-position is uploaded to creation data
Library;
The summary journal data that the production test erect-position generates in process of production are uploaded to summary journal database;
Wherein, the Production database and the summary journal database are relevant database;And/or
The local data base includes SQLite database (a kind of light-duty database).
Preferably, after step S3 further include:
Current production production after, control the production test erect-position production test tool continue to produce it is next
Product, and it re-execute the steps S1;And/or
When product includes wireless communication module, the production test data include the radio frequency of mould group test data, mould group
Parameter, erect-position data, product ID, data storage path and time stamp data;
The characterize data includes product ID, data storage path and time stamp data.
The present invention also provides a kind of data query method, the data query method is using in above-mentioned process of producing product
The control method of data storage realizes that the data query method includes:
Obtain the corresponding object representation data of target product;
Corresponding target production test data in the document data bank are obtained using the object representation data query.
Preferably, being uploaded to by the corresponding production test tool data of production test tool in the production test erect-position
Production database, and the summary journal data that the production test erect-position generates in process of production are uploaded to summary journal number
Behind library, the data query method further include:
It is inquired from the Production database and the summary journal database respectively according to the object representation data
To corresponding target production test tool data and target summary journal data.
The present invention also provides the control system that data in a kind of process of producing product store, the control system includes production
Test data obtains module, characterize data obtains module and the first memory module;
The production test tool that the production test data acquisition module is used to obtain production test erect-position is current in production
Different time stabs corresponding production test data when product;
The characterize data obtains module and is used to obtain the characterize data for characterizing the production test data;
Wherein, the corresponding data volume of the characterize data is less than the corresponding data volume of the production test data;
First memory module is for sequentially in time successively storing the characterize data to the production test
In local data base in erect-position.
Preferably, when the local data transit module in the production test erect-position, first memory module includes
Transfer storage unit, request unit and local storage unit;
The transfer storage unit is for storing the characterize data to the local data transit module;
The request unit is for obtaining data storage request;
The local storage unit is used for the institute in the local data transit module according to the data storage request
It states in the local data base that characterize data is stored into the production test erect-position.
Preferably, the control system further includes the second memory module and third memory module;
The production test data for being stored the local into the production test erect-position by second memory module
In memory module;
The characterize data obtains module and is also used to open a data line journey when the local data transit module
When, then the characterize data that is successively read sequentially in time in the local data base;
The production test data acquisition module is also used to be locally stored in module according to characterize data acquisition
The corresponding production test data;
The production test data that the third memory module is used to successively will acquire sequentially in time are uploaded to text
In part database.
Preferably, the document data bank includes MongoDB;
When the production test data are the data of binary format, the third memory module is used for suitable according to the time
The production test data storage of binary format is successively uploaded in MongoDB by sequence.
Preferably, the control system further includes the 4th memory module and the 5th memory module;
4th memory module is used for the corresponding production test work of production test tool in the production test erect-position
Tool data are uploaded to Production database;
5th memory module is used for the summary journal data for generating the production test erect-position in process of production
It is uploaded to summary journal database;
Wherein, the Production database and the summary journal database are relevant database;And/or
The local data base includes SQLite database.
Preferably, the control system further includes control module;
The control module is used to control the production test work of the production test erect-position after current production production
Tool continues to produce next product, and re-calls the production test data acquisition module;And/or
When product includes wireless communication module, the production test data include the radio frequency of mould group test data, mould group
Parameter, erect-position data, product ID, data storage path and time stamp data;
The characterize data includes product ID, data storage path and time stamp data.
The present invention also provides a kind of data query system, the data query system is using in above-mentioned process of producing product
The control system of data storage realizes that the data query system includes that target data obtains module and enquiry module;
The target data obtains module for obtaining the corresponding object representation data of target product;
The enquiry module is used to obtain corresponding mesh in the document data bank using the object representation data query
Mark production test data.
Preferably, being uploaded to by the corresponding production test tool data of production test tool in the production test erect-position
Production database, and the summary journal data that the production test erect-position generates in process of production are uploaded to summary journal number
Behind library, the enquiry module is also used to according to the object representation data respectively from the Production database and the abstract day
Inquiry obtains corresponding target production test tool data and target summary journal data in will database.
The present invention also provides a kind of electronic equipment, including memory, processor and storage on a memory and can handled
The computer program run on device, the processor realize that data are deposited in above-mentioned process of producing product when executing computer program
The control method of storage, and realize above-mentioned data query method.
The present invention also provides a kind of computer readable storage mediums, are stored thereon with computer program, the computer journey
The step of control method that data store in above-mentioned process of producing product is realized when sequence is executed by processor, and realize above-mentioned
The step of data query method.
The positive effect of the present invention is that:
In the present invention, by the way that by production test erect-position, different time stabs the life generated during producing radio communication mold group
The corresponding characterize data (product ID, data storage path etc.) of test data is produced uniformly to deposit by local transfer memory module
Storage continues production test erect-position after current production production under production test into local SQLite database
One mould group, this process belongs to local data interaction, is not related to network, so that the stability of data transmission has been greatly improved,
Each mould group production test duration is shortened, mould group production test efficiency is improved;According to the characterization of local SQLite database
Production test data that data acquisition is locally stored simultaneously are uploaded in MongoDB in its original format, to guarantee data
The consistency of access;Furthermore it is possible to inquire MongoDB, Production database and summary journal data respectively by product ID
Library obtains required data, and inquiry velocity is fastly and high-efficient.
Detailed description of the invention
Fig. 1 is the flow chart of the control method of data storage in the process of producing product of the embodiment of the present invention 1.
Fig. 2 is the flow chart of the control method of data storage in the process of producing product of the embodiment of the present invention 2.
Fig. 3 is the flow chart of the data query method of the embodiment of the present invention 3.
Fig. 4 is the module diagram of the control system of data storage in the process of producing product of the embodiment of the present invention 4.
Fig. 5 is the module diagram of the control system of data storage in the process of producing product of the embodiment of the present invention 5.
Fig. 6 is the module diagram of the data query system of the embodiment of the present invention 6.
Fig. 7 is the electronic equipment for realizing the control method of data storage in process of producing product of the embodiment of the present invention 7
Structure flow chart.
Specific embodiment
The present invention is further illustrated below by the mode of embodiment, but does not therefore limit the present invention to the reality
It applies among a range.
Embodiment 1
As shown in Figure 1, the control method that data store in the process of producing product of the present embodiment includes:
S101, the production test tool corresponding life of different time stamp when producing current production for obtaining production test erect-position
Produce test data;
S102, characterize data for characterizing production test data is obtained;
Wherein, the corresponding data volume of characterize data is less than the corresponding data volume of production test data;
Specifically, when product includes wireless communication module, production test data include but is not limited to mould group test data,
Radio frequency parameter, erect-position data, product ID, data storage path and the time stamp data of mould group;
Then characterize data includes product ID, data storage path and time stamp data, i.e. characterize data is that production is surveyed
Try the corresponding index information of data.
S103, successively characterize data is stored sequentially in time in local data base into production test erect-position.
Wherein, local data base includes SQLite database.
In the present embodiment: 1) in data storage procedure do not depend on network, belong to local data interaction, and by data it is synchronous with
Production test tool is independent, has greatly improved the stability of data transmission, has been effectively prevented from because of unstable networks or FTP service
Test crash caused by device problem or loss of data, or even the case where stop line;The time of existing synchrodata is also eliminated, is had
Increase production capacity to effect;2) without sending data itself in real time, but by the production test tool of each production test erect-position
Corresponding characterize data real-time Transmission and is uniformly stored into local SQLite database respectively, and this data storage method can
Ensure the timely quick storage of each mould group data, and can be to avoid loss of data the case where;3) also realize do not delay it is next
The production test procedure of mould group can continue directly to the next mould group of production test after current production production, to contract
Short each mould group production test duration improves the production test efficiency of production radio communication mold group.
Embodiment 2
As shown in Fig. 2, the control method that data store in the process of producing product of the present embodiment is to embodiment 1 into one
Step is improved, specifically:
After step S101, before step S102 further include:
S1011, production test data are stored into being locally stored in module into production test erect-position;
When the local data transit module in production test erect-position, step S3 includes:
S1031, characterize data is stored to local data transit module;
S1032, data storage request is obtained;
S1033, the characterize data in local data transit module is stored to production test station according to data storage request
In local data base in position.
In peak traffic period, local data transit module can valid cache characterize data, and by characterize data timing
It is transmitted in SQLite database.
When there is the case where uploading failure, meeting autonomous retransmission, until transmission success, and related management personnel is notified to check
Problem, to effectively avoid the case where influencing normal production process generation.
After step S103 further include:
After current production production, the production test tool of control production test erect-position continues to produce next production
Product, and it re-execute the steps S101.
After step S103 further include:
S104, when local data transit module open a data line journey when, then be successively read sequentially in time
Characterize data in local data base;
S105, corresponding production test data in module are locally stored according to characterize data acquisition;
S106, the production test data that successively will acquire sequentially in time are uploaded in document data bank.
Wherein, document data bank includes MongoDB, and radio communication mold group is uniformly stored using document data bank and is surveyed in production
The small documents data generated during examination, can greatly promote the efficiency of backup transfer, and safety is higher.
Specifically, for each production test erect-position, by the way that production test tool timing therein is arranged to local data
Transit module sends data storage request, the characterize data that local data transit module is stored according to the data storage request
It is successively sent to SQLite database sequentially in time and carries out unified storage.
When local data transit module opens a data line journey, sequentially in time from SQLite database
It is successively read characterize data, and according to the corresponding data storage path of characterize data and timestamp information from production test erect-position
It is locally stored in module and successively obtains corresponding production test data, and be uploaded in MongoDB.
When production test data are the data of binary format, step S106 is specifically included:
Successively the production test data storage of binary format is uploaded in MongoDB sequentially in time, i.e., will be counted
According to unprocessed form be stored in MongoDB, guarantee that accessing operation will not all change the consistency of data, realize lossless deposit
Storage, to meet the data storage requirement of various formats.Such as the corresponding Excel formatted file of mould group test data, mould group are penetrated
Corresponding TXT format text of the corresponding compressed format files of frequency parameter, the tool of production etc..In addition, corresponding according to various data
Different text types distinguish storage.
In addition, the control method of the present embodiment further include:
The corresponding production test tool data of production test tool in production test erect-position is uploaded to Production database;
The summary journal data that production test erect-position generates in process of production are uploaded to summary journal database;
Wherein, Production database and summary journal database are relevant database, such as SQL Server database.
In the present embodiment, pass through different time stamp generation during producing radio communication mold group by production test erect-position
It is unified that the corresponding characterize data of production test data (product ID, data storage path etc.) passes through local transfer memory module
It stores into local SQLite database, production test erect-position after current production production is allowed to continue production test
Next mould group, this process belongs to local data interaction, is not related to network, to greatly improve the stabilization of data transmission
Property, each mould group production test duration is shortened, mould group production test efficiency is improved;According to the table of local SQLite database
It levies the production test data that data acquisition is locally stored and is uploaded in MongoDB in its original format, to guarantee number
According to the consistency of access.
Embodiment 3
The data query method of the present embodiment is real using the control method of data storage in the process of producing product of embodiment 2
It is existing.
As shown in figure 3, the data query method of the present embodiment includes:
S201, the corresponding object representation data of target product are obtained;
S202, corresponding target production test data in document data bank are obtained using object representation data query.
Wherein, object representation data include the corresponding target product sequence number of target product, using target product sequence number
Document data bank Central Plains file data can be read directly.In addition it can including data storage path and time stamp data.
The corresponding production test tool data of production test tool in production test erect-position is being uploaded to Production database,
After being uploaded to summary journal database with the summary journal data for generating production test erect-position in process of production, data query
Method further include:
S203, according to object representation data respectively from Production database and summary journal database inquiry obtain it is corresponding
Target production test tool data and target summary journal data.
Specifically, there are many production test erect-positions in the production line of MES factory, each production test erect-position is configured with
Many platform PC machine (personal computer) are used for production test.It will be installed production test tool in every PC machine and one be used to count
According to the local data transit module of collection;The mould group data text that local data transit module generates local production test tool
Part and Log file timing are uploaded to the document data bank in server, while production test tool can also be incited somebody to action according to production requirement
Some supplemental characteristics of reflection production test tool itself are stored in Production database, and pluck what is generated in production test procedure
Daily record data is wanted to be uploaded to summary journal database, wherein Production database and summary journal database are relational data
Library, document data bank use non-relational document database (MongoDB).
Wherein, Production database is mainly used as the flow management and control in production process, and summary journal database is mainly for production
Quick search and simple analysis afterwards, data file database store mainly for the investigation of detailed problems and data, these three are counted
Combine according to library, so that it may efficiently realize the control, monitoring, analysis and decision of entire production process.
In the present embodiment, MongoDB, Production database and summary journal data can be inquired respectively by product ID
Library obtains required data, and above-mentioned data, which deposit framework, can greatly improve the efficiency of data retrieval and analysis statistics, for example inquire
To the whole test cases, whole test cases of certain work order, the test case of certain erect-position etc. of certain mould group, have inquiry velocity fast
And the advantages that high-efficient.
Embodiment 4
As shown in figure 4, the control system that data store in the process of producing product of the present embodiment includes production test data
Obtain module 1, characterize data obtains module 2 and the first memory module 3.
Production test data acquisition module 1 is used to obtain the production test tool of production test erect-position in production current production
When different time stab corresponding production test data;
Characterize data obtains module 2 and is used to obtain the characterize data for characterizing production test data;
Wherein, the corresponding data volume of characterize data is less than the corresponding data volume of production test data;
Specifically, when product includes wireless communication module, production test data include but is not limited to mould group test data,
Radio frequency parameter, erect-position data, product ID, data storage path and the time stamp data of mould group;
Then characterize data includes product ID, data storage path and time stamp data, i.e. characterize data is that production is surveyed
Try the corresponding index information of data.
Characterize data for successively being stored the local into production test erect-position by the first memory module 3 sequentially in time
In database.
Wherein, local data base includes SQLite database.
In the present embodiment: 1) in data storage procedure do not depend on network, belong to local data interaction, and by data it is synchronous with
Production test tool is independent, has greatly improved the stability of data transmission, has been effectively prevented from because of unstable networks or FTP service
Test crash caused by device problem or loss of data, or even the case where stop line;The time of existing synchrodata is also eliminated, is had
Increase production capacity to effect;2) without sending data itself in real time, but by the production test tool of each production test erect-position
Corresponding characterize data real-time Transmission and is uniformly stored into local SQLite database respectively, and this data storage method can
Ensure the timely quick storage of each mould group data, and can be to avoid loss of data the case where;3) also realize do not delay it is next
The production test procedure of mould group can continue directly to the next mould group of production test after current production production, to contract
Short each mould group production test duration improves the production test efficiency of production radio communication mold group.
Embodiment 5
As shown in figure 5, the control system that data store in the process of producing product of the present embodiment is to embodiment 4 into one
Step is improved, specifically:
When the local data transit module in production test erect-position, the first memory module 3 include transfer storage unit 4,
Request unit 5 and local storage unit 6.
Transfer storage unit 4 is for storing characterize data to local data transit module.
Request unit 5 is for obtaining data storage request;
Local storage unit 6 be used for according to data storage request by the characterize data in local data transit module store to
In local data base in production test erect-position.
In peak traffic period, local data transit module can valid cache characterize data, and by characterize data timing
It is transmitted in SQLite database.
When there is the case where uploading failure, meeting autonomous retransmission, until transmission success, and related management personnel is notified to check
Problem, to effectively avoid the case where influencing normal production process generation.
Control system further includes control module 7, and control module 7 is used for after current production production, and control production is surveyed
The production test tool of examination erect-position continues to produce next product, and re-calls production test data acquisition module 1.
Control system further includes the second memory module 8 and third memory module 9.
Second memory module 8 is used to the production test data storing being locally stored into the production test erect-position
In module;
Characterize data obtains module 2 and is also used to then press when local data transit module opens a data line journey
The characterize data being successively read according to time sequencing in local data base;
Production test data acquisition module 1, which is also used to be obtained according to characterize data, is locally stored corresponding production survey in module
Try data.
The production test data that third memory module 9 is used to successively will acquire sequentially in time are uploaded to number of files
According in library.
Wherein, document data bank includes MongoDB, and radio communication mold group is uniformly stored using document data bank and is surveyed in production
The small documents data generated during examination, can greatly promote the efficiency of backup transfer, and safety is higher.
Specifically, for each production test erect-position, by the way that production test tool timing therein is arranged to local data
Transit module sends data storage request, the characterize data that local data transit module is stored according to the data storage request
It is successively sent to SQLite database sequentially in time and carries out unified storage.
When local data transit module opens a data line journey, sequentially in time from SQLite database
It is successively read characterize data, and according to the corresponding data storage path of characterize data and timestamp information from production test erect-position
It is locally stored in module and successively obtains corresponding production test data, and be uploaded in MongoDB.
When production test data are the data of binary format, third memory module for successively will sequentially in time
The production test data storage of binary format is uploaded in MongoDB, i.e., the unprocessed form of data is stored in MongoDB
In, guarantee that accessing operation will not all change the consistency of data, realize lossless storage, to meet the data storage of various formats
Demand.Such as the corresponding Excel formatted file of mould group test data, the corresponding compressed format files of radio frequency parameter of mould group, life
Corresponding TXT format text of production tool etc..In addition, distinguishing storage according to the corresponding different text types of various data.
In addition, control system further includes the 4th memory module 10 and the 5th memory module 11;
4th memory module 10 is used for the corresponding production test tool data of production test tool in production test erect-position
It is uploaded to Production database;
The summary journal data that production test erect-position generates in process of production for being uploaded to by the 5th memory module 11
Summary journal database;
Wherein, Production database and summary journal database are relevant database, such as SQL Server database.
In the present embodiment, pass through different time stamp generation during producing radio communication mold group by production test erect-position
The corresponding characterize data of production test data passes through local transfer memory module and uniformly stores into local SQLite database, makes
The next mould group of production test can be continued by obtaining production test erect-position after current production production, this process belongs to local number
According to interaction, it is not related to network, so that the stability of data transmission has been greatly improved, when shortening each mould group production test
It is long, improve mould group production test efficiency;The production being locally stored is obtained according to the characterize data of local SQLite database to survey
Examination data are simultaneously uploaded in MongoDB in its original format, to guarantee the consistency of data access.
Embodiment 6
As shown in fig. 6, the data query system of the present embodiment is using data storage in the process of producing product of embodiment 5
Control system realizes that data query system includes that target data obtains module 12 and enquiry module 13.
Target data obtains module 12 for obtaining the corresponding object representation data of target product;
Enquiry module 13 is used to obtain corresponding target production test in document data bank using object representation data query
Data.
Wherein, object representation data include the corresponding target product sequence number of target product, using target product sequence number
Document data bank Central Plains file data can be read directly.In addition it can including data storage path and time stamp data.
The corresponding production test tool data of production test tool in production test erect-position is being uploaded to Production database,
After being uploaded to summary journal database with the summary journal data for generating production test erect-position in process of production, enquiry module
13 be also used to according to object representation data respectively from Production database and summary journal database inquiry obtain corresponding target
Production test tool data and target summary journal data.
Specifically, there are many production test erect-positions in the production line of MES factory, each production test erect-position is configured with
Many platform PC machine are used for production test.It will be installed production test tool and a local for data collection in every PC machine
Data relay module;The mould group data file and Log file that local data transit module generates local production test tool
Timing is uploaded to the document data bank in server, while production test tool also can will reflect production test according to production requirement
Some supplemental characteristics of tool itself are stored in Production database, and will be in the summary journal data that generated in production test procedure
Summary journal database is reached, wherein Production database and summary journal database are relevant database, document data bank
Using non-relational document database (MongoDB).
Wherein, Production database is mainly used as the flow management and control in production process, and summary journal database is mainly for production
Quick search and simple analysis afterwards, data file database store mainly for the investigation of detailed problems and data, these three are counted
Combine according to library, so that it may efficiently realize the control, monitoring, analysis and decision of entire production process.
In the present embodiment, MongoDB, Production database and summary journal data can be inquired respectively by product ID
Library obtains required data, and above-mentioned data, which deposit framework, can greatly improve the efficiency of data retrieval and analysis statistics, for example inquire
To the whole test cases, whole test cases of certain work order, the test case of certain erect-position etc. of certain mould group, have inquiry velocity fast
And the advantages that high-efficient.
Embodiment 7
Fig. 7 is the structural schematic diagram for a kind of electronic equipment that the embodiment of the present invention 7 provides.Electronic equipment include memory,
Processor and storage are on a memory and the computer program that can run on a processor, processor realize implementation when executing program
The control method that data store in product production process in example 1 or 2 in any one embodiment.The electronic equipment 30 that Fig. 7 is shown is only
Only an example, should not function to the embodiment of the present invention and use scope bring any restrictions.
As shown in fig. 7, electronic equipment 30 can be showed in the form of universal computing device, such as it can set for server
It is standby.The component of electronic equipment 30 can include but is not limited to: at least one above-mentioned processor 31, above-mentioned at least one processor
32, the bus 33 of different system components (including memory 32 and processor 31) is connected.
Bus 33 includes data/address bus, address bus and control bus.
Memory 32 may include volatile memory, such as random access memory (RAM) 321 and/or cache
Memory 322 can further include read-only memory (ROM) 323.
Memory 32 can also include program/utility 325 with one group of (at least one) program module 324, this
The program module 324 of sample includes but is not limited to: operating system, one or more application program, other program modules and journey
It may include the realization of network environment in ordinal number evidence, each of these examples or certain combination.
Processor 31 by operation storage computer program in memory 32, thereby executing various function application and
The controlling party that data store in product production process in data processing, such as the embodiment of the present invention 1 or 2 in any one embodiment
Method.
Electronic equipment 30 can also be communicated with one or more external equipments 34 (such as keyboard, sensing equipment etc.).It is this
Communication can be carried out by input/output (I/O) interface 35.Also, the equipment 30 that model generates can also pass through Network adaptation
Device 36 and one or more network (such as local area network (LAN), wide area network (WAN) and/or public network, such as internet) logical
Letter.As shown in fig. 7, the other modules for the equipment 30 that network adapter 36 is generated by bus 33 and model communicate.It should be understood that
Although not shown in the drawings, the equipment 30 that can be generated with binding model uses other hardware and/or software module, including but unlimited
In: microcode, device driver, redundant processor, external disk drive array, RAID (disk array) system, magnetic tape drive
Device and data backup storage system etc..
It should be noted that although being referred to several units/modules or subelement/mould of electronic equipment in the above detailed description
Block, but it is this division be only exemplary it is not enforceable.In fact, embodiment according to the present invention, is retouched above
The feature and function for two or more units/modules stated can embody in a units/modules.Conversely, above description
A units/modules feature and function can with further division be embodied by multiple units/modules.
Embodiment 8
The embodiment of the present invention 8 provides a kind of electronic equipment, and electronic equipment includes memory, processor and is stored in storage
On device and the computer program that can run on a processor, processor realize the data query side in embodiment 3 when executing program
Method, referring to the electronic equipment in embodiment 7, working principle is set the specific structure of the electronic equipment with the electronics in embodiment 7
Standby working principle is almost the same, and details are not described herein.
Embodiment 9
A kind of computer readable storage medium is present embodiments provided, computer program is stored thereon with, program is processed
The step in the product production process in embodiment 1 or 2 in any one embodiment in the control method of data storage is realized when device executes
Suddenly.
Wherein, what readable storage medium storing program for executing can use more specifically can include but is not limited to: portable disc, hard disk, random
Access memory, read-only memory, erasable programmable read only memory, light storage device, magnetic memory device or above-mentioned times
The suitable combination of meaning.
In possible embodiment, the present invention is also implemented as a kind of form of program product comprising program generation
Code, when described program product is run on the terminal device, said program code is realized in fact for executing the terminal device
Apply the step in the control method that data store in the product production process in example 1 or 2 in any one embodiment.
Wherein it is possible to be write with any combination of one or more programming languages for executing program of the invention
Code, said program code can be executed fully on a user device, partly execute on a user device, is only as one
Vertical software package executes, part executes on a remote device or executes on a remote device completely on a user device for part.
Embodiment 10
A kind of computer readable storage medium is present embodiments provided, computer program is stored thereon with, program is processed
The step in the data query method in embodiment 3 is realized when device executes.
Wherein, what readable storage medium storing program for executing can use more specifically can include but is not limited to: portable disc, hard disk, random
Access memory, read-only memory, erasable programmable read only memory, light storage device, magnetic memory device or above-mentioned times
The suitable combination of meaning.
In possible embodiment, the present invention is also implemented as a kind of form of program product comprising program generation
Code, when described program product is run on the terminal device, said program code is realized in fact for executing the terminal device
Apply the step in the data query method in example 3.
Wherein it is possible to be write with any combination of one or more programming languages for executing program of the invention
Code, said program code can be executed fully on a user device, partly execute on a user device, is only as one
Vertical software package executes, part executes on a remote device or executes on a remote device completely on a user device for part.
Although specific embodiments of the present invention have been described above, it will be appreciated by those of skill in the art that this is only
For example, protection scope of the present invention is to be defined by the appended claims.Those skilled in the art without departing substantially from
Under the premise of the principle and substance of the present invention, many changes and modifications may be made, but these change and
Modification each falls within protection scope of the present invention.
Claims (18)
1. the control method that data store in a kind of process of producing product, which is characterized in that the control method includes:
S1. production test tool corresponding production test of different time stamp when producing current production of production test erect-position is obtained
Data;
S2. the characterize data for characterizing the production test data is obtained;
Wherein, the corresponding data volume of the characterize data is less than the corresponding data volume of the production test data;
S3. successively the characterize data is stored sequentially in time in the local data base into the production test erect-position.
2. the control method that data store in process of producing product as described in claim 1, which is characterized in that when the production
When testing the local data transit module in erect-position, step S3 includes:
S31. the characterize data is stored to the local data transit module;
S32. data storage request is obtained;
S33. the characterize data in the local data transit module is stored to described according to the data storage request
In the local data base in production test erect-position.
3. in process of producing product as claimed in claim 2 data store control method, which is characterized in that step S1 it
Afterwards, before step S2 further include:
S11. the production test data are stored into being locally stored in module into the production test erect-position;
After step S3 further include:
S4. when the local data transit module opens a data line journey, then it is successively read institute sequentially in time
State the characterize data in local data base;
S5. the corresponding production test data in module are locally stored according to characterize data acquisition;
S6. the production test data that successively will acquire sequentially in time are uploaded in document data bank.
4. the control method that data store in process of producing product as claimed in claim 3, which is characterized in that the number of files
It include MongoDB according to library;
When the production test data are the data of binary format, step S6 includes:
Successively the production test data storage of binary format is uploaded in MongoDB sequentially in time.
5. the control method that data store in process of producing product as described in claim 1, which is characterized in that the controlling party
Method further include:
The corresponding production test tool data of production test tool in the production test erect-position is uploaded to Production database;
The summary journal data that the production test erect-position generates in process of production are uploaded to summary journal database;
Wherein, the Production database and the summary journal database are relevant database;And/or
The local data base includes SQLite database.
6. the control method that data store in process of producing product as described in claim 1, which is characterized in that after step S3
Further include:
After current production production, the production test tool for controlling the production test erect-position continues to produce next production
Product, and it re-execute the steps S1;And/or
When product includes wireless communication module, the production test data include mould group test data, mould group radio frequency parameter,
Erect-position data, product ID, data storage path and time stamp data;
The characterize data includes product ID, data storage path and time stamp data.
7. a kind of data query method, which is characterized in that the data query method uses production as claimed in claim 2
The control method of data storage realizes that the data query method includes: in the process
Obtain the corresponding object representation data of target product;
Corresponding target production test data in the document data bank are obtained using the object representation data query.
8. data query method as claimed in claim 7, which is characterized in that by production test in the production test erect-position
The corresponding production test tool data of tool is uploaded to Production database, and the production test erect-position is produced in process of production
After raw summary journal data are uploaded to summary journal database, the data query method further include:
According to the object representation data, inquiry is obtained pair from the Production database and the summary journal database respectively
The target production test tool data and target summary journal data answered.
9. the control system that data store in a kind of process of producing product, which is characterized in that the control system includes that production is surveyed
Try data acquisition module, characterize data obtains module and the first memory module;
The production test data acquisition module is used to obtain the production test tool of production test erect-position in production current production
When different time stab corresponding production test data;
The characterize data obtains module and is used to obtain the characterize data for characterizing the production test data;
Wherein, the corresponding data volume of the characterize data is less than the corresponding data volume of the production test data;
First memory module is for sequentially in time successively storing the characterize data to the production test erect-position
In local data base in.
10. the control system that data store in process of producing product as claimed in claim 9, which is characterized in that when the life
When producing the local data transit module in test erect-position, first memory module includes transfer storage unit, request list
Member and local storage unit;
The transfer storage unit is for storing the characterize data to the local data transit module;
The request unit is for obtaining data storage request;
The local storage unit is used for the table in the local data transit module according to the data storage request
Sign data store in the local data base into the production test erect-position.
11. the control system that data store in process of producing product as claimed in claim 10, which is characterized in that the control
System further includes the second memory module and third memory module;
Second memory module is used to the production test data storing being locally stored into the production test erect-position
In module;
The characterize data obtains module and is also used to when the local data transit module opens a data line journey, then
The characterize data being successively read in the local data base sequentially in time;
The production test data acquisition module is also used to be locally stored in module according to characterize data acquisition corresponding
The production test data;
The production test data that the third memory module is used to successively will acquire sequentially in time are uploaded to number of files
According in library.
12. the control system that data store in process of producing product as claimed in claim 11, which is characterized in that the file
Database includes MongoDB;
When the production test data be binary format data when, the third memory module for sequentially in time according to
It is secondary that the production test data storage of binary format is uploaded in MongoDB.
13. the control system that data store in process of producing product as claimed in claim 9, which is characterized in that the control
System further includes the 4th memory module and the 5th memory module;
4th memory module is used for the corresponding production test tool number of production test tool in the production test erect-position
According to being uploaded to Production database;
The summary journal data that 5th memory module is used in process of production generate the production test erect-position upload
To summary journal database;
Wherein, the Production database and the summary journal database are relevant database;And/or
The local data base includes SQLite database.
14. the control system that data store in process of producing product as claimed in claim 9, which is characterized in that the control
System further includes control module;
The control module is used for after current production production, control the production test tool of the production test erect-position after
The continuous next product of production, and re-call the production test data acquisition module;And/or
When product includes wireless communication module, the production test data include mould group test data, mould group radio frequency parameter,
Erect-position data, product ID, data storage path and time stamp data;
The characterize data includes product ID, data storage path and time stamp data.
15. a kind of data query system, which is characterized in that the data query system is raw using product described in any one of claim 10
The control system that data store during production realizes that the data query system includes that target data obtains module and inquiry mould
Block;
The target data obtains module for obtaining the corresponding object representation data of target product;
The enquiry module is used to obtain corresponding target in the document data bank using the object representation data query raw
Produce test data.
16. data query system as claimed in claim 15, which is characterized in that surveyed will be produced in the production test erect-position
Trial work has corresponding production test tool data and is uploaded to Production database, and in process of production by the production test erect-position
After the summary journal data of generation are uploaded to summary journal database, the enquiry module is also used to according to the object representation number
According to inquiry obtains corresponding target production test tool number from the Production database and the summary journal database respectively
According to target summary journal data.
17. a kind of electronic equipment including memory, processor and stores the calculating that can be run on a memory and on a processor
Machine program, which is characterized in that the processor realizes product of any of claims 1-6 when executing computer program
The control method that data store in production process, and realize data query method described in claim 7 or 8.
18. a kind of computer readable storage medium, is stored thereon with computer program, which is characterized in that the computer program
The control method that data store in process of producing product of any of claims 1-6 is realized when being executed by processor
Step, and the step of realizing data query method described in claim 7 or 8.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201910821324.4A CN110515955B (en) | 2019-09-02 | 2019-09-02 | Data storage and query method and system, electronic equipment and storage medium |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201910821324.4A CN110515955B (en) | 2019-09-02 | 2019-09-02 | Data storage and query method and system, electronic equipment and storage medium |
Publications (2)
Publication Number | Publication Date |
---|---|
CN110515955A true CN110515955A (en) | 2019-11-29 |
CN110515955B CN110515955B (en) | 2023-09-15 |
Family
ID=68630207
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201910821324.4A Active CN110515955B (en) | 2019-09-02 | 2019-09-02 | Data storage and query method and system, electronic equipment and storage medium |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN110515955B (en) |
Cited By (1)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN113821409A (en) * | 2021-09-23 | 2021-12-21 | 中国建设银行股份有限公司 | Method, device, storage medium and equipment for monitoring data transmission |
Citations (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20050246584A1 (en) * | 2004-04-16 | 2005-11-03 | Hon Hai Precision Industry Co., Ltd. | Test data managing system and method |
CN103473260A (en) * | 2013-06-25 | 2013-12-25 | 北京控制工程研究所 | Concurrency OLAP (On-Line Analytical Processing)-oriented test data hierarchy cluster query processing system and method |
CN105550333A (en) * | 2015-12-22 | 2016-05-04 | 歌尔声学股份有限公司 | MongoDB-based test data storage query method and system |
CN109117375A (en) * | 2018-08-30 | 2019-01-01 | 上海携程金融信息服务有限公司 | Database interface test method, system, equipment and storage medium |
-
2019
- 2019-09-02 CN CN201910821324.4A patent/CN110515955B/en active Active
Patent Citations (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20050246584A1 (en) * | 2004-04-16 | 2005-11-03 | Hon Hai Precision Industry Co., Ltd. | Test data managing system and method |
CN103473260A (en) * | 2013-06-25 | 2013-12-25 | 北京控制工程研究所 | Concurrency OLAP (On-Line Analytical Processing)-oriented test data hierarchy cluster query processing system and method |
CN105550333A (en) * | 2015-12-22 | 2016-05-04 | 歌尔声学股份有限公司 | MongoDB-based test data storage query method and system |
CN109117375A (en) * | 2018-08-30 | 2019-01-01 | 上海携程金融信息服务有限公司 | Database interface test method, system, equipment and storage medium |
Non-Patent Citations (1)
Title |
---|
孙美卫: "基于MongoDB的Web信息采集***应用研究", 《湖南邮电职业技术学院学报》 * |
Cited By (2)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN113821409A (en) * | 2021-09-23 | 2021-12-21 | 中国建设银行股份有限公司 | Method, device, storage medium and equipment for monitoring data transmission |
CN113821409B (en) * | 2021-09-23 | 2024-06-04 | 中国建设银行股份有限公司 | Method, device, storage medium and equipment for monitoring data transmission |
Also Published As
Publication number | Publication date |
---|---|
CN110515955B (en) | 2023-09-15 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN103064933B (en) | Data query method and system | |
CN106327055B (en) | A kind of electricity expense control method and system based on big data technology | |
CN101587152B (en) | Power quality monitoring system | |
CN103325074B (en) | Power system real-time data processing method | |
CN104298726B (en) | A kind of BMS data-storage systems and its method based on database | |
CN103793479A (en) | Log management method and log management system | |
CN104090889A (en) | Method and system for data processing | |
CN102750326A (en) | Log management optimization method of cluster system based on downsizing strategy | |
CN104239377A (en) | Platform-crossing data retrieval method and device | |
CN104362757A (en) | Transformer substation on-line monitoring system based on IEC61850 | |
CN104584524A (en) | Aggregating data in a mediation system | |
CN105989140B (en) | A kind of data block processing method and equipment | |
CN111459944A (en) | MR data storage method, device, server and storage medium | |
CN107506422A (en) | The distributed information log processing system and method for a kind of multi-data source | |
CN114880405A (en) | Data lake-based data processing method and system | |
CN111400393A (en) | Data processing method and device based on multi-application platform and storage medium | |
WO2017000592A1 (en) | Data processing method, apparatus and system | |
CN114915634A (en) | Industrial data acquisition and storage system and method based on data lake | |
CN108763323A (en) | Meteorological lattice point file application process based on resource set and big data technology | |
CN110515955A (en) | Storage, querying method, system, electronic equipment and the storage medium of data | |
CN116629802A (en) | Big data platform system for railway port station | |
CN111625517B (en) | New energy real-time data processing method and device based on change storage | |
CN115460072A (en) | Log processing system integrating log collection, analysis, storage and service | |
CN110134690B (en) | Method and system for rapidly storing oversized data of Oracle database | |
CN111104416A (en) | Distributed electric power data management 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 | ||
GR01 | Patent grant | ||
GR01 | Patent grant |