CN109710677A - Processing for Data Analysis in Physics, device, computer equipment and storage medium - Google Patents
Processing for Data Analysis in Physics, device, computer equipment and storage medium Download PDFInfo
- Publication number
- CN109710677A CN109710677A CN201811610344.9A CN201811610344A CN109710677A CN 109710677 A CN109710677 A CN 109710677A CN 201811610344 A CN201811610344 A CN 201811610344A CN 109710677 A CN109710677 A CN 109710677A
- Authority
- CN
- China
- Prior art keywords
- data
- list
- mapping
- data structure
- processed
- 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
Landscapes
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
This application involves a kind of Processing for Data Analysis in Physics, device, computer equipment and storage mediums.The described method includes: obtaining third-party experimental data to be processed, parse experimental data to be processed, obtain the corresponding data structure list of experimental data to be processed, according to data structure list, matching obtains the corresponding mapping table of data structure table list in pre-set mapping database, according to mapping table and data structure list, normal data list is generated.It can be improved the treatment effeciency of experimental data using this method, and save exploiting natural resources for Information software.
Description
Technical field
This application involves field of computer technology, set more particularly to a kind of Processing for Data Analysis in Physics, device, computer
Standby and storage medium.
Background technique
With the development of computer technology, software platform technologies have also been obtained great development.By instrument
When work station is tested, identifying processing can be carried out to the experimental result that instrument work station exports by software platform, thus
Convenient for forming experimental analysis report.By taking biological detection as an example, Clinical Institutions, scientific research institutions, CRO (Contract Research
Organization, Contract Research Organization), all kinds of medicines enterprise using software platform carry out Bioexperiment data acquisition and point
Analysis, using software platform carry out Bioexperiment when, it is necessary first to define SOP (Standard Operating Procedure,
S.O.P.), so that software platform exports the experimental result based on SOP.However the instrument work station that constituent parts use is not
Consistent or SOP defines the different experimental result formats that may cause output and field name difference, to need based on different instrument
Device work station and SOP customize different software platforms.
However, current software platform can not be known for the inconsistent experimental result with SOP variation of instrument work station
Not, low so as to cause experimental result treatment effeciency, cause the waste of resource again for the carry out adaptability design of software platform.
Summary of the invention
Based on this, it is necessary to which in view of the above technical problems, different realities can not be identified by providing one kind and being able to solve software platform
Test Processing for Data Analysis in Physics, device, computer equipment and the storage medium of data template problem.
A kind of Processing for Data Analysis in Physics, which comprises
Obtain third-party experimental data to be processed;
The experimental data to be processed is parsed, the corresponding data structure list of the experimental data to be processed is obtained;
According to the data structure list, matching obtains the data structure list in pre-set mapping database
Corresponding mapping table;
According to the mapping table and the data structure list, normal data list is generated.
In one of the embodiments, further include: extract every experimental result in the experimental data to be processed;It obtains
The corresponding field name of the experimental result;According to the field name, inquires and obtain in pre-set structural database
The corresponding data structure table of the experimental data to be processed;The experimental result is filled to the data structure table, number is generated
According to structure list.
In one of the embodiments, further include: according to the field name of the data structure list, pre-set
It is matched in mapping database, obtains the corresponding mapping table of the data structure table list;The mapping table includes
The mapping relations of the field name and criteria field title.
In one of the embodiments, further include: according to the mapping relations in the mapping table, described in reading
Experimental result in data structure list in each field name;According to pre-set transfer algorithm, by the experimental result
Be converted to normal data;The normal data is filled to corresponding in the normal data table of the data structure table, mark is generated
Quasi- data form.
In one of the embodiments, further include: receive the access request of user;According to the access request, verifying is used
The identity at family;When the authentication of user passes through, the mapping data that user sends are received, the mapping data are stored in data
In library, mapping database is obtained.
A kind of Data Processing in Experiment device, described device include:
Data acquisition module, for obtaining third-party experimental data to be processed;
It is corresponding to obtain the experimental data to be processed for parsing the experimental data to be processed for data resolution module
Data structure list;
Mapping relations obtain module, for according to the data structure list, in pre-set mapping database
With obtaining the corresponding mapping table of the data structure table list;
Processing module, for generating normal data list according to the mapping table and the data structure list.
A kind of Data Processing in Experiment platform based on middleware, the platform include: access interface, database module and in
Between part module;
The access interface receives the experimental data to be processed of first work station platform;
The middleware module parses the experimental data to be processed, obtains the corresponding data of the experimental data to be processed
Structure list;According to the data structure list, the mapping database in the database module is called, in the mapping data
Matching obtains the corresponding mapping table of the data structure table list in library;According to the mapping table and the data structure
List generates normal data list;
The normal data list is sent to second work station platform by the access interface by the middleware module.
In one of the embodiments, further include: login module;Login module receives the access request of user, according to institute
Access request is stated, the identity of user is verified;When the authentication of user passes through, the database module receives what user sent
Data are mapped, the mapping data are stored in the mapping database.
A kind of computer equipment, including memory and processor, the memory are stored with computer program, the processing
Device performs the steps of when executing the computer program
Obtain third-party experimental data to be processed;
The experimental data to be processed is parsed, the corresponding data structure list of the experimental data to be processed is obtained;
According to the data structure list, matching obtains the data structure list in pre-set mapping database
Corresponding mapping table;
According to the mapping table and the data structure list, normal data list is generated.
A kind of computer readable storage medium, is stored thereon with computer program, and the computer program is held by processor
It is performed the steps of when row
Obtain third-party experimental data to be processed;
The experimental data to be processed is parsed, the corresponding data structure list of the experimental data to be processed is obtained;
According to the data structure list, matching obtains the data structure list in pre-set mapping database
Corresponding mapping table;
According to the mapping table and the data structure list, normal data list is generated.
Above-mentioned Processing for Data Analysis in Physics, device, computer equipment and storage medium receive experimental data to be processed
When, experimental data to be processed is parsed, the corresponding data structure list of experimental data to be processed is obtained, to complete to test
Then the parsing of data structure carries out mapping and generates normal data table according to data structure list by mapping relations list
It is single, it can recognize normal data so as to convert different platform for the experimental data to be processed of different platform.The present embodiment
The treatment effeciency of experimental data can be improved, and save exploiting natural resources for platform.
Detailed description of the invention
Fig. 1 is the application scenario diagram of Processing for Data Analysis in Physics in one embodiment;
Fig. 2 is the flow diagram of Processing for Data Analysis in Physics in one embodiment;
Fig. 3 is the flow diagram that data structure table single stage is generated in one embodiment;
Fig. 4 is the flow diagram that normal data list step is generated in another embodiment;
Fig. 5 is the structural block diagram of Data Processing in Experiment device in one embodiment;
Fig. 6 is the structural block diagram of the Data Processing in Experiment platform based on middleware in one embodiment;
Fig. 7 is the internal structure chart of computer equipment in one embodiment.
Specific embodiment
It is with reference to the accompanying drawings and embodiments, right in order to which the objects, technical solutions and advantages of the application are more clearly understood
The application is further elaborated.It should be appreciated that specific embodiment described herein is only used to explain the application, not
For limiting the application.
Processing for Data Analysis in Physics provided by the present application can be applied in application environment as shown in Figure 1.Wherein,
One terminal 102 is communicated with second terminal 104 by network by network, and server 106 is first by middleware Technology
Terminal 102 provides data processing service.Wherein, first terminal 102 and second terminal can be, but not limited to be various individual calculus
Machine, laptop, smart phone, tablet computer and portable wearable device, server 106 can use independent server
The either server cluster of multiple servers composition is realized.
Different Information softwares is disposed in first terminal 102 and second terminal 104, Information software for knowing automatically
The experimental data of other instrument work station output, the experimental data of the corresponding identification different-format of different Information softwares.
After 104 output of second terminal corresponding third-party experimental data to be processed, first terminal 102 is to reality to be processed
Testing data has demand, then the data processing service provided by server 106, by middleware Technology, to second terminal 104
The third-party experimental data to be processed of output is parsed, and converts experimental data to the data structure list of form structure,
Then it by data structure list, is matched in mapping database, obtains the corresponding mapping table of data structure table list, mapped
Relation table has recorded the mapping relations between the 104 output experimental data of data and second terminal of reference format, so as to root
According to mapping table, data structure table single-turn is turned into normal data list.
It on the other hand, can be with criterion of identification number after first terminal 102 passes through the data processing service that server 106 provides
According to list, without additionally being developed to the Information software in first terminal 102 again, it only need to connect server 106 and mention
The service of confession, so that it may realize the identification of experimental data in third party's Information software.
In one embodiment, as shown in Fig. 2, providing a kind of Processing for Data Analysis in Physics, it is applied to Fig. 1 in this way
In server for be illustrated, comprising the following steps:
Step 202, third-party experimental data to be processed is obtained.
Third party refers to the platform different from the Information software of server providing services, and difference can be the number of use
When customizing difference according to acquisition standard, or being tested, used SOP (Standard Operating Procedure, mark
Quasi- operation sequence) it is different.
Experimental data to be processed is referred to according to SOP program, by the experimental data of third party's instrument work station output, wait locate
SOP can be obtained not for different data acquisition standard by third party's Information software automatic identification by managing experimental data
Together, it can not be identified by other information software.
Obtaining experimental data to be processed can be the interface provided by server, receive the reality to be processed that third party sends
Test data.
Step 204, experimental data to be processed is parsed, the corresponding data structure list of experimental data to be processed is obtained.
Data structure list refers to the rule specified by server, carries out ordering to the field in list, thus
Reach the list of orderly identifying purpose.
Server after receiving experimental data to be processed, can by middleware to the structure of experimental data to be processed into
Row identification, to convert data structure list for experimental data to be processed.
Step 206, according to data structure list, matching obtains data structure list in pre-set mapping database
Corresponding mapping table.
The corresponding relationship and data structure of instrument workbench output result and normal data are had recorded in mapping table
The mapping relations of the field name of the field name and normal data list of list, therefore, the letter based on offer server service
The quantity of breathization software may include a large amount of mapping table in mapping database, thus when providing data processing service,
It can complete the identification of big measuring appratus workbench output result.
Server can be matched in mapping data when obtaining data structure list according to data structure list,
Matching can be using matching ways such as keyword, fields, to obtain the corresponding mapping table of data structure table list.
Step 208, according to mapping table and data structure list, normal data list is generated.
Normal data list is the final result of Data Processing in Experiment, and normal data list can be database list,
It, can be with outputting standard data form for using, in addition, normal data list is also possible to Excel table by the way that SQL statement is arranged
List, Word list etc..
After server obtains mapping table, by mapping table and data structure form filling to middleware, by centre
Part generates normal data list.
In above-mentioned Processing for Data Analysis in Physics, when receiving experimental data to be processed, experimental data to be processed is solved
Analysis, obtains the corresponding data structure list of experimental data to be processed, so that the parsing of experimental data structure is completed, then according to number
According to structure list, by mapping relations list, carry out mapping and generate normal data list, so as to by different platform wait locate
Reason experimental data, which is converted into different platform, can recognize normal data.The treatment effeciency of experimental data can be improved in the present embodiment,
And save exploiting natural resources for Information software.
In one embodiment, as shown in figure 3, providing a kind of schematic flow chart for generating data structure table single stage, tool
Steps are as follows for body:
Step 302, every experimental result in experimental data to be processed is extracted.
Experimental data to be processed be third party's instrument work station output laboratory report as a result, laboratory report result by field
And therefore the corresponding content composition of field according to the field in laboratory report result, it is corresponding each can to extract each field
Item experimental result.
Step 304, the corresponding field name of experimental result is obtained.
It can be by obtaining the field in laboratory report result, to obtain the corresponding field name of laboratory report result.
Step 306, according to field name, inquiry obtains experimental data pair to be processed in pre-set structural database
The data structure table answered.
It include data structure template predetermined in structural database, server is providing clothes for different Information softwares
When business, using the same structural database, so that uniform data structure, improves the accuracy of different Information software identifications.Number
It according to structure table is obtained according to data structure template.
Step 308, experimental result is filled to data structure table, generates data structure list.
Data structure table is one according to normal structure template generation, by the filling of experimental result, thus for difference
Instrument work station, the equal isostructural data structure list of output phase.
In the embodiment of the present invention, since the format of the laboratory report of different instrument work stations output is different, cause different soft
The difficulty of part land identification, by way of laboratory report of the server to different-format is converted into the list of reference format.From
And the treatment effeciency of server had both been improved, also improve the accuracy that different informatization platforms carry out experimental data identification.
For step 302, each instrument work station is pre-set in one embodiment, in server for each experiment
As a result the keyword defined, so that every experimental result in experimental data to be processed can be recognized by keyword.
For step 306, in one embodiment, normal structure template is contained in data structure library, in normal structure mould
In plate, orderly arrangement has been carried out for each field, thus in matched data structure table, by each field name,
Each field in matching criteria stay in place form generates new data structure table according to its sequence by the field being matched to.
The embodiment of the present invention can be with the data structure table of outputting standard, thus being counted for different experimental datas to be processed
When according to processing, treatment effeciency is improved.
Above scheme of the invention can be directed to different third-party experimental datas to be processed, can be converted into mark
The data structure list of quasi- data structure, so that improving server provides the adaptability of Data Processing in Experiment service.
In one embodiment, it when inquiring mapping table, can be accomplished by the following way: according to data structure list
Field name, matched in pre-set mapping database, obtain the corresponding mapping table of data structure table list;
Mapping table includes the mapping relations of field name Yu criteria field title.In the present embodiment, due to being deposited in mapping database
Multiple mapping tables of storage, mapping table includes the corresponding relationship of field name and criteria field title, thus, pass through solution
Obtained field name is analysed, can match to obtain corresponding mapping table.
Specifically, can parse to obtain multiple field names in experimental data to be processed, since different instrument work stations are defeated
Otherness and similitude in laboratory report result out, to set matching rule to when in field name and mapping table
Field name it is completely the same when, determine the mapping table be the corresponding mapping table of pending data.In the present embodiment,
By the way that specific matching rule is arranged, thus avoid similar instrument workbench and caused by accidentally processing result.
In specific implementation, corresponding SQL statement can be arranged by field name and matching rule, thus in mapping number
According to the SQL statement is executed in library, specific mapping table is filtered out.
In one embodiment, as shown in figure 4, providing a kind of schematic flow chart for generating normal data list step, tool
Steps are as follows for body:
Step 402, it according to the mapping relations in mapping table, reads in data structure list in each field name
Experimental result.
Server deposits data structure list and mapping list after obtaining data structure list and mapping list
Storage, and data are completed by middleware and generate task.
Middleware determines the corresponding field name of map field according to the mapping relations of mapping table, is closed according to mapping
System generates the normal data table for corresponding to data structure table.By mapping relations, the corresponding experiment of field name can also be read
As a result.
Step 404, according to pre-set transfer algorithm, experimental result is converted into normal data.
After determining mapping relations, according to pre-set transfer algorithm, experimental result can be completed to normal data
Conversion, transfer algorithm is configured according to the SOP of instrument work station.
Step 406, normal data is filled to corresponding in the normal data table of data structure table, generates normal data table
It is single.
Server can complete the filling of normal data table by the normal data and map field of generation, thus
To normal data list.
In the embodiment of the present invention, by mapping relations and transfer algorithm, data structure table one-way criterion data are completed
Conversion.Since transfer algorithm is arranged according to different instrument work stations, it is adapted to different instrument work stations, thus
It improves server and the adaptability of Data Processing in Experiment service is provided.
In addition, in one embodiment, mapping database is the corresponding database of server, it is Information software in server
When Data Processing in Experiment service is provided, the access request that the corresponding user of Information software sends also can receive, according to access
Request, verifies the identity of user, after authentication passes through, receives the mapping data that user sends, and mapping data are stored in number
According in library, mapping database is obtained,
Specifically, the corresponding user of Information software needs to carry out server before providing Data Processing in Experiment service
Configuration, Information software receive the map field of server offer, to generate mapping number according to corresponding instrument work station
According to and feeding back to server, server is saved data are mapped to database, can be with by the service of bulk information software
It obtains largely mapping data, to can establish mapping database according to mapping data.
Below with a specific embodiment, technical solution of the present invention is further described:
Above-mentioned Processing for Data Analysis in Physics, when can be used in Bioexperiment analysis field, using middleware and database
Technology forms server, and server provides Data Processing in Experiment solution, Information software for each Information software platform
Platform is by integrated with middleware, with middleware progress logic decoupling, it can obtain at experimental data provided by the server
Manage function, the Data Processing in Experiment function realize when, specifically includes the following steps:
1, the middleware of Information software platform and server is integrated.
, only need to be integrated with middleware without constructing other logical frameworks in Information software platform development, carry out logic
Decoupling.
2, server provides the standard data structure in a set of biological field, to realize laboratory report construction standard
Analysis.
Standard data structure can be exported by SDMS software and be realized.When the input of third-party laboratory report result, lead to
It crosses SDMS software and laboratory report result is subjected to normal structure conversion, in the database for then exporting result deposit server.
Specifically, normal structure list is as shown in table 1.
Table 1
3, middleware identification table 1 in each field, field include Set Name, Item Name, Sample Type,
Sample Position, Injection Volume and Component name.Then by each field in mapping data
It is matched in library, available mapping table.
Specifically, mapping table specifically can be as shown in table 2.
Explanation of field | Middleware standard field | Field is arranged in work station |
Sample introduction table name | Table Name | Set Name |
Sample number into spectrum | Sample NO | Item Name |
Sample type | Sample Type | Sample Type |
Sample introduction position | Sample Position | Sample Position |
Sample volume | Injection Volume | Injection Volume |
Analyte | Analyte | Component Name |
Normal structure list and mapping table are pushed to middleware by table 24, are handled by middleware, obtain standard
Data form.
Normal data list can be as shown in table 3.
Table 3
In normal data list, server is by defining unified standard, thus in conversion, using converting algorithm,
Standard results are converted by experimental result, such as convert A0001 for M-V1.1-04.
Specifically, Information software platform, in integration middleware, user needs register account number in the server, server
It will be in the account information list of account storage in the server.Therefore, information software platform is needed when configuring to server
The account registered is inputted in login interface, be verified by server, determine the permission of the correspondence user of Information software, if
Permission with configuration database, the then mark that user can define according to corresponding instrument workbench, the rule of SOP and server
Standard establishes mapping table in the database, to complete the dilatation of data in mapping database.Increase in server user's quantity
When long, the scale of mass data can also be arrived in mapping database.
In addition, whether the user of Information software can also check mapping logic when using Data Processing in Experiment for the first time
Correctly, if it is problematic, it can modify to the mapping table in mapping database, to guarantee Data Processing in Experiment
Accuracy.
It should be understood that although each step in the flow chart of Fig. 2-4 is successively shown according to the instruction of arrow,
These steps are not that the inevitable sequence according to arrow instruction successively executes.Unless expressly stating otherwise herein, these steps
Execution there is no stringent sequences to limit, these steps can execute in other order.Moreover, at least one in Fig. 2-4
Part steps may include that perhaps these sub-steps of multiple stages or stage are not necessarily in synchronization to multiple sub-steps
Completion is executed, but can be executed at different times, the execution sequence in these sub-steps or stage is also not necessarily successively
It carries out, but can be at least part of the sub-step or stage of other steps or other steps in turn or alternately
It executes.
In one embodiment, as shown in figure 5, providing a kind of Data Processing in Experiment device, comprising: data acquisition module
502, data resolution module 504, mapping relations obtain module 506 and processing module 508, in which:
Data acquisition module 502, for obtaining third-party experimental data to be processed.
Data resolution module 504 obtains the corresponding data knot of experimental data to be processed for parsing experimental data to be processed
Structure list.
Mapping relations obtain module 506, for being matched in pre-set mapping database according to data structure list
Obtain the corresponding mapping table of data structure table list.
Processing module 508, for generating normal data list according to mapping table and data structure list.
It is real to be also used to extract the items in experimental data to be processed for data resolution module 504 in one of the embodiments,
Test result;Obtain the corresponding field name of experimental result;According to field name, inquired in pre-set structural database
To the corresponding data structure table of experimental data to be processed;Experimental result is filled to data structure table, data structure list is generated.
Mapping relations obtain module 506 and are also used to the field name according to data structure list in one of the embodiments,
Claim, is matched in pre-set mapping database, obtain the corresponding mapping table of data structure table list;Mapping relations
Table includes the mapping relations of field name Yu criteria field title.
Conversion processing module 508 is also used to be read according to the mapping relations in mapping table in one of the embodiments,
Take the experimental result in data structure list in each field name;According to pre-set transfer algorithm, experimental result is turned
It is changed to normal data;Normal data is filled to corresponding in the normal data table of data structure table, normal data list is generated.
It in one of the embodiments, further include Database module, for receiving the access request of user;According to visit
It asks request, verifies the identity of user;When the authentication of user passes through, the mapping data that user sends are received, number will be mapped
According in deposit database, mapping database is obtained.
Specific about Data Processing in Experiment device limits the limit that may refer to above for Processing for Data Analysis in Physics
Fixed, details are not described herein.Modules in above-mentioned Data Processing in Experiment device can fully or partially through software, hardware and its
Combination is to realize.Above-mentioned each module can be embedded in the form of hardware or independently of in the processor in computer equipment, can also be with
It is stored in the memory in computer equipment in a software form, in order to which processor calls the above modules of execution corresponding
Operation.
In one embodiment, as shown in fig. 6, providing a kind of Data Processing in Experiment platform based on middleware, platform packet
It includes: access interface 602, database module 604 and middleware module 606.
The experimental data to be processed of the reception first work station platform of access interface 602.
Middleware module 606 parses experimental data to be processed, obtains the corresponding data structure list of experimental data to be processed,
According to data structure list, the mapping database in database module 604 is called, matching obtains data knot in mapping database
Data structure table single-turn is turned to normal data list according to mapping table by the corresponding mapping table of structure list.
Normal data list is sent to second work station platform by access interface 602 by middleware module 606.
In the present embodiment, Data Processing in Experiment platform provides data processing service, the first work for second work station platform
Platform belongs to third-party platform, the structure of the laboratory report data of first work station platform and second work station platform institute output
It is different.Data Processing in Experiment platform is constructed by middleware, each workstation platform can be served, to solve different operating
The problem of experimental data difference is mutually distinguishable between platform reduces the cost of experimental data identification.
Middleware module 606 is parsing experimental data to be processed in one of the embodiments, obtains experiment number to be processed
When according to corresponding data structure list, the every experimental result extracted in experimental data to be processed specifically may is that;Obtain experiment
As a result corresponding field name;According to field name, inquiry obtains experiment number to be processed in pre-set structural database
According to corresponding data structure table;Experimental result is filled to data structure table, data structure list is generated.
Middleware module 606 calls database module 604 according to data structure list in one of the embodiments,
In mapping database specifically can be with when matching obtains data structure table list corresponding mapping table in mapping database
It is: according to the field name of data structure list, is matched in pre-set mapping database, obtain data structure table
Single corresponding mapping table;Mapping table includes the mapping relations of field name Yu criteria field title.
Middleware module 606 turns to data structure table single-turn according to mapping table in one of the embodiments,
When normal data list, it specifically may is that according to the mapping relations in mapping table, read each word in data structure list
Experimental result in name section;According to pre-set transfer algorithm, experimental result is converted into normal data;By normal data
Filling generates normal data list to corresponding in the normal data table of data structure table.
It in one of the embodiments, further include login module, login module receives the access request of user, according to access
Request, verifies the identity of user, and when the authentication of user passes through, database module receives the mapping data that user sends,
Mapping data are stored in mapping database.
In one embodiment, a kind of computer equipment is provided, which can be server, internal junction
Composition can be as shown in Figure 7.The computer equipment include by system bus connect processor, memory, network interface and
Database.Wherein, the processor of the computer equipment is for providing calculating and control ability.The memory packet of the computer equipment
Include non-volatile memory medium, built-in storage.The non-volatile memory medium is stored with operating system, computer program and data
Library.The built-in storage provides environment for the operation of operating system and computer program in non-volatile memory medium.The calculating
The database of machine equipment is used for storage mapping relation table data.The network interface of the computer equipment is used for logical with external terminal
Cross network connection communication.To realize a kind of Processing for Data Analysis in Physics when the computer program is executed by processor.
It will be understood by those skilled in the art that structure shown in Fig. 7, only part relevant to application scheme is tied
The block diagram of structure does not constitute the restriction for the computer equipment being applied thereon to application scheme, specific computer equipment
It may include perhaps combining certain components or with different component layouts than more or fewer components as shown in the figure.
In one embodiment, a kind of computer equipment, including memory and processor are provided, which is stored with
Computer program, the processor perform the steps of when executing computer program
Obtain third-party experimental data to be processed;
Experimental data to be processed is parsed, the corresponding data structure list of experimental data to be processed is obtained;
According to data structure list, matching obtains that data structure table list is corresponding to be reflected in pre-set mapping database
Penetrate relation table;
According to mapping table and data structure list, normal data list is generated.
In one embodiment, it is also performed the steps of when processor executes computer program and extracts experiment number to be processed
Every experimental result in;Obtain the corresponding field name of experimental result;According to field name, in pre-set structure number
The corresponding data structure table of experimental data to be processed is obtained according to inquiry in library;Experimental result is filled to data structure table, is generated
Data structure list.
In one embodiment, it also performs the steps of when processor executes computer program according to data structure list
Field name, matched in pre-set mapping database, obtain the corresponding mapping table of data structure table list;
Mapping table includes the mapping relations of field name Yu criteria field title.
In one embodiment, it also performs the steps of when processor executes computer program according in mapping table
Mapping relations, read the experimental result in data structure list in each field name;According to pre-set transfer algorithm,
Experimental result is converted into normal data;Normal data is filled to corresponding in the normal data table of data structure table, is generated
Normal data list.
In one embodiment, the access that reception user is also performed the steps of when processor executes computer program is asked
It asks;According to access request, the identity of user is verified;When the authentication of user passes through, the mapping data that user sends are received,
Mapping data are stored in database, mapping database is obtained.
In one embodiment, a kind of computer readable storage medium is provided, computer program is stored thereon with, is calculated
Machine program performs the steps of when being executed by processor
Obtain third-party experimental data to be processed;
Experimental data to be processed is parsed, the corresponding data structure list of experimental data to be processed is obtained;
According to data structure list, matching obtains that data structure table list is corresponding to be reflected in pre-set mapping database
Penetrate relation table;
According to mapping table and data structure list, normal data list is generated.
In one embodiment, it is also performed the steps of when computer program is executed by processor and extracts experiment to be processed
Every experimental result in data;Obtain the corresponding field name of experimental result;According to field name, in pre-set structure
Inquiry obtains the corresponding data structure table of experimental data to be processed in database;Experimental result is filled to data structure table, it is raw
At data structure list.
In one embodiment, it also performs the steps of when computer program is executed by processor according to data structure table
Single field name, is matched in pre-set mapping database, obtains the corresponding mapping relations of data structure table list
Table;Mapping table includes the mapping relations of field name Yu criteria field title.
In one embodiment, it also performs the steps of when computer program is executed by processor according to mapping table
In mapping relations, read the experimental result in data structure list in each field name;It is calculated according to pre-set conversion
Experimental result is converted to normal data by method;Normal data is filled into corresponding to the normal data table of data structure table, it is raw
At normal data list.
In one embodiment, the access for receiving user is also performed the steps of when computer program is executed by processor
Request;According to access request, the identity of user is verified;When the authentication of user passes through, the mapping number that user sends is received
According to, will mapping data deposit database in, obtain mapping database.
Those of ordinary skill in the art will appreciate that realizing all or part of the process in above-described embodiment method, being can be with
Relevant hardware is instructed to complete by computer program, the computer program can be stored in a non-volatile computer
In read/write memory medium, the computer program is when being executed, it may include such as the process of the embodiment of above-mentioned each method.Wherein,
To any reference of memory, storage, database or other media used in each embodiment provided herein,
Including non-volatile and/or volatile memory.Nonvolatile memory may include read-only memory (ROM), programming ROM
(PROM), electrically programmable ROM (EPROM), electrically erasable ROM (EEPROM) or flash memory.Volatile memory may include
Random access memory (RAM) or external cache.By way of illustration and not limitation, RAM is available in many forms,
Such as static state RAM (SRAM), dynamic ram (DRAM), synchronous dram (SDRAM), double data rate sdram (DDRSDRAM), enhancing
Type SDRAM (ESDRAM), synchronization link (Synchlink) DRAM (SLDRAM), memory bus (Rambus) direct RAM
(RDRAM), direct memory bus dynamic ram (DRDRAM) and memory bus dynamic ram (RDRAM) etc..
Each technical characteristic of above embodiments can be combined arbitrarily, for simplicity of description, not to above-described embodiment
In each technical characteristic it is all possible combination be all described, as long as however, the combination of these technical characteristics be not present lance
Shield all should be considered as described in this specification.
The several embodiments of the application above described embodiment only expresses, the description thereof is more specific and detailed, but simultaneously
It cannot therefore be construed as limiting the scope of the patent.It should be pointed out that coming for those of ordinary skill in the art
It says, without departing from the concept of this application, various modifications and improvements can be made, these belong to the protection of the application
Range.Therefore, the scope of protection shall be subject to the appended claims for the application patent.
Claims (10)
1. a kind of Processing for Data Analysis in Physics, which comprises
Obtain third-party experimental data to be processed;
The experimental data to be processed is parsed, the corresponding data structure list of the experimental data to be processed is obtained;
According to the data structure list, matching obtains the data structure table single pair and answers in pre-set mapping database
Mapping table;
According to the mapping table and the data structure list, normal data list is generated.
2. the method according to claim 1, wherein the parsing experimental data to be processed, obtains described wait locate
Manage the corresponding data structure list of experimental data, comprising:
Extract every experimental result in the experimental data to be processed;
Obtain the corresponding field name of the experimental result;
According to the field name, it is corresponding to obtain the experimental data to be processed for inquiry in pre-set structural database
Data structure table;
The experimental result is filled to the data structure table, data structure list is generated.
3. according to the method described in claim 2, it is characterized in that, being reflected according to the data structure list pre-set
It penetrates matching in database and obtains the corresponding mapping table of the data structure table list, comprising:
It according to the field name of the data structure list, is matched, is obtained described in pre-set mapping database
The corresponding mapping table of data structure table list;The mapping table includes the field name and criteria field title is reflected
Penetrate relationship.
4. according to the method described in claim 3, it is characterized in that, according to the mapping table and the data structure table
It is single, generate normal data list, comprising:
According to the mapping relations in the mapping table, read in the data structure list in each field name
Experimental result;
According to pre-set transfer algorithm, the experimental result is converted into normal data;
The normal data is filled to corresponding in the normal data table of the data structure table, normal data list is generated.
5. method according to any one of claims 1 to 4, which is characterized in that establish the mode of mapping database, comprising:
Receive the access request of user;
According to the access request, the identity of user is verified;
When the authentication of user pass through, the mapping data that user sends are received, the mapping data are stored in database,
Obtain mapping database.
6. a kind of Data Processing in Experiment device, which is characterized in that described device includes:
Data acquisition module, for obtaining third-party experimental data to be processed;
Data resolution module obtains the corresponding data of the experimental data to be processed for parsing the experimental data to be processed
Structure list;
Mapping relations obtain module, for being matched in pre-set mapping database according to the data structure list
To the corresponding mapping table of the data structure table list;
Processing module, for generating normal data list according to the mapping table and the data structure list.
7. a kind of Data Processing in Experiment platform based on middleware, which is characterized in that the platform includes: access interface, data
Library module and middleware module;
The access interface receives the experimental data to be processed of first work station platform;
The middleware module parses the experimental data to be processed, obtains the corresponding data structure of the experimental data to be processed
List;According to the data structure list, the mapping database in the database module is called, in the mapping database
Matching obtains the corresponding mapping table of the data structure table list;According to the mapping table, by the data structure table
Single-turn turns to normal data list;
The normal data list is sent to second work station platform by the access interface by the middleware module.
8. the Data Processing in Experiment platform according to claim 7 based on middleware, which is characterized in that further include: it logs in
Module;
The access request that login module receives user verifies the identity of user according to the access request;
When the authentication of user passes through, the database module receives the mapping data that user sends, by the mapping number
According in the deposit mapping database.
9. a kind of computer equipment, including memory and processor, the memory are stored with computer program, feature exists
In the step of processor realizes any one of claims 1 to 7 the method when executing the computer program.
10. a kind of computer readable storage medium, is stored thereon with computer program, which is characterized in that the computer program
The step of method described in any one of claims 1 to 7 is realized when being executed by processor.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201811610344.9A CN109710677B (en) | 2018-12-27 | 2018-12-27 | Experiment data processing method and device, computer equipment and storage medium |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201811610344.9A CN109710677B (en) | 2018-12-27 | 2018-12-27 | Experiment data processing method and device, computer equipment and storage medium |
Publications (2)
Publication Number | Publication Date |
---|---|
CN109710677A true CN109710677A (en) | 2019-05-03 |
CN109710677B CN109710677B (en) | 2021-03-05 |
Family
ID=66258748
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201811610344.9A Active CN109710677B (en) | 2018-12-27 | 2018-12-27 | Experiment data processing method and device, computer equipment and storage medium |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN109710677B (en) |
Cited By (11)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN110704632A (en) * | 2019-08-26 | 2020-01-17 | 南京医渡云医学技术有限公司 | Method and device for processing clinical data, readable medium and electronic equipment |
CN110768952A (en) * | 2019-09-09 | 2020-02-07 | 中国科学院上海微系统与信息技术研究所 | Data verification method, device and system and storage medium |
CN110895533A (en) * | 2019-11-29 | 2020-03-20 | 北京锐安科技有限公司 | Form mapping method and device, computer equipment and storage medium |
CN111026757A (en) * | 2019-12-10 | 2020-04-17 | 首都医科大学附属北京友谊医院 | Method, device, equipment and storage medium for generating standard statistical format data |
CN111126018A (en) * | 2019-11-25 | 2020-05-08 | 泰康保险集团股份有限公司 | Form generation method and device, storage medium and electronic equipment |
CN111274484A (en) * | 2020-01-20 | 2020-06-12 | 上海风秩科技有限公司 | Method and device for managing interactive data |
CN112182084A (en) * | 2020-09-27 | 2021-01-05 | 上海亚新建设工程有限公司 | Data format-based data automatic processing method and equipment |
CN112258015A (en) * | 2020-10-19 | 2021-01-22 | 上海飞域实验室设备有限公司 | Laboratory management early warning system based on cloud data analysis and early warning method thereof |
CN112988868A (en) * | 2021-03-17 | 2021-06-18 | 首钢京唐钢铁联合有限责任公司 | Steel laboratory data processing method and system |
CN113111047A (en) * | 2021-03-18 | 2021-07-13 | 上海宜员网络技术有限公司 | Data processing method and device and electronic equipment |
CN113761858A (en) * | 2021-09-07 | 2021-12-07 | 平安国际智慧城市科技股份有限公司 | Form data processing method and device, computer equipment and storage medium |
Citations (6)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN101452503A (en) * | 2008-11-28 | 2009-06-10 | 上海生物信息技术研究中心 | Isomerization clinical medical information shared system and method |
CN101901220A (en) * | 2009-05-27 | 2010-12-01 | 北京启明星辰信息技术股份有限公司 | General data display method and equipment |
CN102999610A (en) * | 2012-11-22 | 2013-03-27 | 用友软件股份有限公司 | Data access system and data access method |
CN104978307A (en) * | 2015-06-25 | 2015-10-14 | 中铁四局集团有限公司 | List processing method and device |
US20160179857A1 (en) * | 2014-12-18 | 2016-06-23 | International Business Machines Corporation | Database joins using uncertain criteria |
CN108416043A (en) * | 2018-03-14 | 2018-08-17 | 中煤科工集团重庆研究院有限公司 | Multi-platform spatial data fusion and synchronization method |
-
2018
- 2018-12-27 CN CN201811610344.9A patent/CN109710677B/en active Active
Patent Citations (6)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN101452503A (en) * | 2008-11-28 | 2009-06-10 | 上海生物信息技术研究中心 | Isomerization clinical medical information shared system and method |
CN101901220A (en) * | 2009-05-27 | 2010-12-01 | 北京启明星辰信息技术股份有限公司 | General data display method and equipment |
CN102999610A (en) * | 2012-11-22 | 2013-03-27 | 用友软件股份有限公司 | Data access system and data access method |
US20160179857A1 (en) * | 2014-12-18 | 2016-06-23 | International Business Machines Corporation | Database joins using uncertain criteria |
CN104978307A (en) * | 2015-06-25 | 2015-10-14 | 中铁四局集团有限公司 | List processing method and device |
CN108416043A (en) * | 2018-03-14 | 2018-08-17 | 中煤科工集团重庆研究院有限公司 | Multi-platform spatial data fusion and synchronization method |
Cited By (15)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN110704632A (en) * | 2019-08-26 | 2020-01-17 | 南京医渡云医学技术有限公司 | Method and device for processing clinical data, readable medium and electronic equipment |
CN110768952A (en) * | 2019-09-09 | 2020-02-07 | 中国科学院上海微系统与信息技术研究所 | Data verification method, device and system and storage medium |
CN111126018B (en) * | 2019-11-25 | 2023-08-08 | 泰康保险集团股份有限公司 | Form generation method and device, storage medium and electronic equipment |
CN111126018A (en) * | 2019-11-25 | 2020-05-08 | 泰康保险集团股份有限公司 | Form generation method and device, storage medium and electronic equipment |
CN110895533A (en) * | 2019-11-29 | 2020-03-20 | 北京锐安科技有限公司 | Form mapping method and device, computer equipment and storage medium |
CN111026757A (en) * | 2019-12-10 | 2020-04-17 | 首都医科大学附属北京友谊医院 | Method, device, equipment and storage medium for generating standard statistical format data |
CN111026757B (en) * | 2019-12-10 | 2023-10-10 | 首都医科大学附属北京友谊医院 | Method, device, equipment and storage medium for generating standard statistical format data |
CN111274484A (en) * | 2020-01-20 | 2020-06-12 | 上海风秩科技有限公司 | Method and device for managing interactive data |
CN112182084A (en) * | 2020-09-27 | 2021-01-05 | 上海亚新建设工程有限公司 | Data format-based data automatic processing method and equipment |
CN112258015A (en) * | 2020-10-19 | 2021-01-22 | 上海飞域实验室设备有限公司 | Laboratory management early warning system based on cloud data analysis and early warning method thereof |
CN112988868B (en) * | 2021-03-17 | 2022-12-13 | 首钢京唐钢铁联合有限责任公司 | Steel laboratory data processing method and system |
CN112988868A (en) * | 2021-03-17 | 2021-06-18 | 首钢京唐钢铁联合有限责任公司 | Steel laboratory data processing method and system |
CN113111047A (en) * | 2021-03-18 | 2021-07-13 | 上海宜员网络技术有限公司 | Data processing method and device and electronic equipment |
CN113111047B (en) * | 2021-03-18 | 2023-09-01 | 宜员(上海)信息科技有限公司 | Data processing method and device and electronic equipment |
CN113761858A (en) * | 2021-09-07 | 2021-12-07 | 平安国际智慧城市科技股份有限公司 | Form data processing method and device, computer equipment and storage medium |
Also Published As
Publication number | Publication date |
---|---|
CN109710677B (en) | 2021-03-05 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN109710677A (en) | Processing for Data Analysis in Physics, device, computer equipment and storage medium | |
CN109474578B (en) | Message checking method, device, computer equipment and storage medium | |
CN108573371A (en) | The data measures and procedures for the examination and approval, device, computer equipment and storage medium | |
CN109446068A (en) | Interface test method, device, computer equipment and storage medium | |
CN110209652A (en) | Tables of data moving method, device, computer equipment and storage medium | |
CN108446362A (en) | Data cleansing processing method, device, computer equipment and storage medium | |
CN109408746A (en) | Portrait information query method, device, computer equipment and storage medium | |
CN110069297A (en) | Abnormality eliminating method, device, computer equipment and storage medium based on Spring MVC | |
CN111930617B (en) | Automatic test method and device based on data objectification | |
CN112256321A (en) | Static library packaging method and device, computer equipment and storage medium | |
CN107171897A (en) | A kind of interface test method and data-interface test system | |
CN109726134B (en) | Interface test method and system | |
CN109816364A (en) | Transaction data processing method, device, computer equipment and storage medium | |
CN110099414A (en) | Network resource transmission method, apparatus, computer equipment and storage medium | |
CN112187713A (en) | Message conversion method, device, computer equipment and storage medium | |
CN107450909A (en) | The treating method and apparatus of validity check is integrated for SDK | |
CN114465937A (en) | Network card testing method, device, server, medium, and computer program product | |
CN109815139A (en) | Interface test method, device, computer equipment and storage medium | |
CN117493309A (en) | Standard model generation method, device, equipment and storage medium | |
CN117033212A (en) | Method for automatically generating interface test case and test case generating device | |
CN114429408B (en) | Method, device, equipment and system for checking configuration file of intelligent substation | |
CN115269040A (en) | Tenant business application expanding method, device and system | |
CN110471708B (en) | Method and device for acquiring configuration items based on reusable components | |
CN107885604A (en) | Method and device, computer equipment and the storage medium of communications between heterogeneous systems | |
CN110532186B (en) | Method, device, electronic equipment and storage medium for testing by using verification code |
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 |