CN107995248A - Spectroscopic data storage method and system - Google Patents

Spectroscopic data storage method and system Download PDF

Info

Publication number
CN107995248A
CN107995248A CN201610969712.3A CN201610969712A CN107995248A CN 107995248 A CN107995248 A CN 107995248A CN 201610969712 A CN201610969712 A CN 201610969712A CN 107995248 A CN107995248 A CN 107995248A
Authority
CN
China
Prior art keywords
spectroscopic data
spectrogram
data bag
server
spectroscopic
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
Application number
CN201610969712.3A
Other languages
Chinese (zh)
Other versions
CN107995248B (en
Inventor
陈辉
曹永兵
柳艳
沈杨
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
SHANGHAI DIYA KAITE BIOMEDICAL TECHNOLOGY Co Ltd
Original Assignee
SHANGHAI DIYA KAITE BIOMEDICAL TECHNOLOGY Co Ltd
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by SHANGHAI DIYA KAITE BIOMEDICAL TECHNOLOGY Co Ltd filed Critical SHANGHAI DIYA KAITE BIOMEDICAL TECHNOLOGY Co Ltd
Priority to CN201610969712.3A priority Critical patent/CN107995248B/en
Publication of CN107995248A publication Critical patent/CN107995248A/en
Application granted granted Critical
Publication of CN107995248B publication Critical patent/CN107995248B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Classifications

    • HELECTRICITY
    • H04ELECTRIC COMMUNICATION TECHNIQUE
    • H04LTRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
    • H04L67/00Network arrangements or protocols for supporting network services or applications
    • H04L67/01Protocols
    • H04L67/10Protocols in which an application is distributed across nodes in the network
    • H04L67/1097Protocols in which an application is distributed across nodes in the network for distributed storage of data in networks, e.g. transport arrangements for network file system [NFS], storage area networks [SAN] or network attached storage [NAS]
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/22Indexing; Data structures therefor; Storage structures
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/28Databases characterised by their database models, e.g. relational or object models
    • G06F16/284Relational databases

Landscapes

  • Engineering & Computer Science (AREA)
  • Databases & Information Systems (AREA)
  • Theoretical Computer Science (AREA)
  • Data Mining & Analysis (AREA)
  • Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Computer Networks & Wireless Communication (AREA)
  • Signal Processing (AREA)
  • Software Systems (AREA)
  • Measuring And Recording Apparatus For Diagnosis (AREA)
  • Data Exchanges In Wide-Area Networks (AREA)

Abstract

The invention discloses a kind of spectroscopic data storage method and system, including:Server-side receives multiple encrypted and compression spectroscopic data bag;Judge whether the spectroscopic data bag data transmission exception situation occurs, if not then decompressed and decryption obtains the spectroscopic data bag, all spectroscopic datas therein are deposited into database;Spectral quality in each spectroscopic data bag is analyzed, when the spectral quality in spectroscopic data bag meets standard, the spectroscopic data in the spectroscopic data bag is pre-processed to obtain optimization spectroscopic data;Spectral quality in spectroscopic data bag information not up to standard is exported when not being inconsistent standardization;Server-side stores the optimization spectroscopic data into a standard database.The present invention is able to ensure that final spectroscopic data meets pre-set quality analysis requirement, and finally realizes and add database, for follow-up analysis.

Description

Spectroscopic data storage method and system
Technical field
The present invention relates to the analysis of the spectroscopic data to medicine, more particularly to a kind of spectroscopic data storage method and is System.
Background technology
At present, in the epoch of internet fast development, establish big data, cloud computing has become the mainstream of current era, and The structure of database can more specification, the efficient practicality for ensuring data and its relevant information, and the data realized pair " increase and change Delete " etc. function, but to ensure that the data loading of reliable in quality is also complex, system a process.Now it is directed to medicine Spectrum analysis field, there is not yet perfect, effective spectroscopic data storage method, to transmit come spectroscopic data carry out one The discriminant analysis of change, such as quality control, to filter out the spectroscopic data for meeting certain standard, used in subsequent treatment, so that Build a kind of intelligent, efficient, spectrum storage method of easy.
The content of the invention
The technical problem to be solved in the present invention is in order to overcome in the prior art be directed to medicine spectral data analysis field There is not yet the defects of perfect, effective spectroscopic data storage method, there is provided a kind of spectroscopic data storage method and system.
The present invention is to solve above-mentioned technical problem by following technical proposals:
The present invention provides a kind of spectroscopic data storage method, its feature is that it comprises the following steps:
S1, a server-side are received by its api interface multiple contains multiple spectrum numbers through data encryption and data compression According to spectroscopic data bag, each spectroscopic data bag include medicine name, the authentication code of medicine, manufacturer, production batch, instrument Model, spectrogram and in-stockroom operation request;
Whether S2, the spectroscopic data bag for judging to receive there is data transmission exception situation, if not S3 is then entered step, Otherwise S8 is entered step;
S3, the server-side obtain the spectroscopic data bag through data decompression and data deciphering, and by the spectroscopic data bag All spectroscopic datas store into a SQL database;
S4, the server-side analyze the spectral quality in each spectroscopic data bag, the light in the spectroscopic data bag When spectrum quality meets an established standards, S5 is entered step, otherwise enters step S7;
S5, the server-side pre-process the spectroscopic data in the spectroscopic data bag to obtain an optimization spectroscopic data;
S6, the server-side store the optimization spectroscopic data into a standard database;
S7, the server-side export spectral quality in spectroscopic data bag information not up to standard;
The information of S8, the server-side output data transmission abnormality.
It is preferred that in step s 6, in step s 6, the server-side by the optimization spectroscopic data and the standard database The optimization spectroscopic data of storage carries out similarity mode, if the optimization spectroscopic data has been stored with a certain in the standard database Optimization spectroscopic data similarity when being more than a given threshold, then judge the corresponding medicine name of the optimization spectroscopic data and the matching Whether the corresponding medicine name of optimization spectroscopic data gone out is identical, if then entering step S7, otherwise enters step S9:The server-side Export the spectroscopic data in the spectroscopic data bag and do not meet the information that storage requires.
It is preferred that step S4 comprises the following steps:
S41, the server-side judge whether the spectrogram quantity in the spectroscopic data bag is more than one first setting value, if then S42 is entered step, otherwise enters step S47;
S42, the server-side are directed to each spectrogram in the spectroscopic data bag:Judge the Raman shift range of the spectrogram Whether in a setting displacement range, if then retaining the spectrogram and entering step S43, otherwise give up the spectrogram;
S43, the server-side are directed to each spectrogram retained in the spectroscopic data bag:Judge adjacent Raman in the spectrogram Whether intensity level is less than one the 3rd setting value more than the quantity of one second setting value, if then retaining the spectrogram and entering step S44, otherwise gives up the spectrogram;
S44, the server-side are directed to each spectrogram retained in the spectroscopic data bag:Judge the spectrogram with the presence or absence of Peak, if retaining the spectrogram there is no and if entering step S45, otherwise gives up the spectrogram;
S45, the server-side are directed to each spectrogram retained in the spectroscopic data bag:Judge that signal-to-noise ratio surpasses in the spectrogram Whether the quantity for crossing one the 4th setting value is more than one the 5th setting value, if then retaining the spectrogram and entering step S46, otherwise Give up the spectrogram;
S46, the server-side are directed to each spectrogram retained in the spectroscopic data bag:Whether at least to judge in the spectrogram There are a characteristic peak intensity level to reach one the 6th setting value, if then retaining the spectrogram and entering step S5, otherwise gives up The spectrogram;
S47, the server-side export spectral quality in spectroscopic data bag information not up to standard.
It is preferred that in step sl, which receives the spectroscopic data bag by way of multithreading.
It is preferred that the server-side shows the spectroscopic data by a display screen, which receives the not visible spectrum The instruction of data, and the spectroscopic data is denoted as one according to the instruction and has deleted spectroscopic data.
The present invention also provides a kind of spectroscopic data Input System, its feature is, it is realized using a server-side, the service End includes:
One receiving module, multiple contains multiple light for being received by its api interface through data encryption and data compression The spectroscopic data bag of modal data, each spectroscopic data bag include medicine name, the authentication code of medicine, manufacturer, production batch, Instrument model, spectrogram and in-stockroom operation request;
Whether one first judgment module, the spectroscopic data bag for judging to receive there is data transmission exception situation, if It is not to call a parsing module, otherwise calls one first output module;
The parsing module is used to obtain the spectroscopic data bag through data decompression and data deciphering, and by the spectroscopic data bag In all spectroscopic datas store into a SQL database;
One analysis module, for analyzing the spectral quality in each spectroscopic data bag, in the spectroscopic data bag Spectral quality call a pretreatment module when meeting an established standards, otherwise call one second output module;
The pretreatment module is used to pre-process the spectroscopic data in the spectroscopic data bag to obtain an optimization spectrum Data;
One memory module, for storing the optimization spectroscopic data into a standard database;
Second output module information not up to standard for exporting the spectral quality in the spectroscopic data bag;
First output module is used for the information of output data transmission abnormality.
It is preferred that the spectroscopic data Input System further includes a matching module, one the 3rd judgment module and one the 3rd output Module;
The matching module is used to carry out the stored optimization spectroscopic data of the optimization spectroscopic data and the standard database Similarity mode, if the optimization spectroscopic data and a certain stored optimization spectroscopic data similarity in the standard database are big When a given threshold, then the 3rd judgment module is called to judge that the optimization spectroscopic data corresponding medicine name is matched with this Whether identical optimize the corresponding medicine name of spectroscopic data, if then calling the memory module, otherwise call the 3rd output module Export the spectroscopic data in the spectroscopic data bag and do not meet the information that storage requires.
It is preferred that the analysis module includes:
One first judging unit, for judging whether the spectrogram quantity in the spectroscopic data bag is more than one first setting Value, if then calling one second judging unit, otherwise calls second output module;
Second judging unit is used for each spectrogram being directed in the spectroscopic data bag:Judge the Raman position of the spectrogram Scope is moved whether in a setting displacement range, if then a stick unit is used to retain the spectrogram and calls one the 3rd to judge Unit, otherwise one gives up unit for giving up the spectrogram;
3rd judging unit is used to be directed to each spectrogram retained in the spectroscopic data bag:Judge phase in the spectrogram Whether adjacent raman scattering intensity value is less than one the 3rd setting value more than the quantity of one second setting value, if then call the stick unit and One the 4th judging unit, otherwise calls this to give up unit;
4th judging unit is used to be directed to each spectrogram retained in the spectroscopic data bag:Whether judge the spectrogram There are negative peak, if calling the stick unit and one the 5th judging unit there is no if, otherwise calls this to give up unit;
5th judging unit is used to be directed to each spectrogram retained in the spectroscopic data bag:Judge to believe in the spectrogram Make an uproar than whether the quantity more than one the 4th setting value is more than one the 5th setting value, if then calling the stick unit and one the 6th to sentence Disconnected unit, otherwise calls this to give up unit;
6th judging unit is used to be directed to each spectrogram retained in the spectroscopic data bag:Judge be in the spectrogram No at least there are a characteristic peak intensity level to reach one the 6th setting value, if then calling the stick unit and the pretreatment mould Block, otherwise calls this to give up unit.
It is preferred that the receiving module is used to receive the spectroscopic data bag by way of multithreading.
It is preferred that the server-side shows the spectroscopic data by a display screen, which receives the not visible spectrum The instruction of data, and the spectroscopic data is denoted as one according to the instruction and has deleted spectroscopic data.
On the basis of common knowledge of the art, above-mentioned each optimum condition, can be combined, each preferably real up to the present invention Example.
The positive effect of the present invention is:
The present invention passes through in order to bring more easily medicine spectroscopic data acquiring way to vast Pharmaceutical Analysis worker A series of spectral quality control flow, pretreatment process etc., it is ensured that final spectroscopic data meets pre-set quality point Analysis requires, and finally realizes and add database, for all users to share.It is to realize that the whole people establish database, efficiently number at the same time Lay the foundation according to storehouse, the quick drugs analysis result that obtains.
Brief description of the drawings
Fig. 1 is the flow chart of the spectroscopic data storage method of present pre-ferred embodiments.
Fig. 2 is the spectral quality analysis process figure in the spectroscopic data storage method of present pre-ferred embodiments.
Fig. 3 is the structure diagram of the spectroscopic data Input System of present pre-ferred embodiments.
Embodiment
To make the purpose, technical scheme and advantage of the embodiment of the present invention clearer, below in conjunction with the embodiment of the present invention In attached drawing, the technical solution in the embodiment of the present invention is clearly and completely described, it is clear that described embodiment is Part of the embodiment of the present invention, instead of all the embodiments.Based on the embodiments of the present invention, those of ordinary skill in the art The all other embodiments obtained on the premise of creative work is not made, belong to the scope of protection of the invention.
As shown in Figure 1, the present embodiment provides a kind of spectroscopic data storage method, it is realized by a server-side, this method Comprise the following steps:
Step 101, the server-side received by way of its api interface is by multithreading it is multiple through data encryption (such as Md5 encryption algorithm) and data compression (such as zip compression) spectroscopic data bag, which includes multiple spectroscopic datas.
Wherein, each spectroscopic data bag includes medicine name, the authentication code of medicine, manufacturer, production batch, instrument type Number, spectral response value, spectrum wave-number range, spectrogram and the operation requests for the spectroscopic data, specifically, the operation requests Including storage and fast inspection.
Whether the spectroscopic data bag that step 102, the server-side judge to receive, which data transmission exception situation occurs, (such as is lost Bag or data distortion), if not then entering step 103, otherwise enter step 110.
Step 103, the server-side obtain the spectroscopic data bag after data decompression and data deciphering, and by the spectrum number Stored according to all spectroscopic datas in bag into a SQL database.
Step 104, the server-side analyze the spectral quality in each spectroscopic data bag, in the spectroscopic data bag Spectral quality when meeting the standard of a setting, enter step 105, otherwise enter step 109.
Step 105, the server-side pre-process the spectroscopic data in the spectroscopic data bag to obtain an optimization spectrum Data.
Step 106, the server-side judge whether the operation requests of the optimization spectroscopic data are in-stockroom operation requests, if then Enter step 107.
Step 107, by the optimization spectroscopic data and the standard database it is stored optimization spectroscopic data carry out similarity Matching, if the optimization spectroscopic data is set with a certain stored optimization spectroscopic data similarity in the standard database more than one When determining threshold value, then the corresponding medicine name of optimization spectroscopic data medicine name corresponding with the optimization spectroscopic data that this is matched is judged It is whether identical, if then entering step 108, otherwise enter step 111.
Step 108, the server-side store the optimization spectroscopic data into a standard database.
Step 109, the server-side export spectral quality in spectroscopic data bag information not up to standard.
The information of step 110, the server-side output data transmission abnormality.
The spectroscopic data that step 111, the server-side are exported in the spectroscopic data bag does not meet the information that storage requires.
Wherein, for the spectral quality analytic process of step 104, comprise the following steps as shown in Fig. 2, can refine again:
S41, the server-side judge whether spectrogram quantity in the spectroscopic data bag is more than one first setting value (such as 6 It is a), if then entering step S42, S47 is entered step if less than 6.
S42, the server-side are directed to each spectrogram in the spectroscopic data bag:Judge the Raman shift range of the spectrogram Whether in a setting displacement range, if then retaining the spectrogram and entering step S43, otherwise give up the spectrogram.
For example, the minimum value in judging the Raman shift range of the spectrogram whether be less than or equal to 200 and maximum be It is no to be more than or equal to 2600, if then retaining the spectrogram, otherwise show that this spectrogram is undesirable, then by this spectrogram Give up to fall.
S43, the server-side are directed to each spectrogram retained in the spectroscopic data bag:Judge adjacent Raman in the spectrogram Whether intensity level is less than one the 3rd setting value (such as 5) more than the quantity of one second setting value, if then retaining the spectrogram And S44 is entered step, otherwise give up the spectrogram.
S44, the server-side are directed to each spectrogram retained in the spectroscopic data bag:Judge the spectrogram with the presence or absence of Peak, if retaining the spectrogram there is no and if entering step S45, otherwise gives up the spectrogram.
S45, the server-side are directed to each spectrogram retained in the spectroscopic data bag:Judge that signal-to-noise ratio surpasses in the spectrogram Whether the quantity for crossing one the 4th setting value (such as 10) is more than one the 5th setting value (such as 5), if then retaining the spectrogram simultaneously S46 is entered step, otherwise gives up the spectrogram.
S46, the server-side are directed to each spectrogram retained in the spectroscopic data bag:Whether at least to judge in the spectrogram There are a characteristic peak intensity level to reach one the 6th setting value (such as 3000), if then retaining the spectrogram and entering step 105, otherwise give up the spectrogram;
S47, the server-side export spectral quality in spectroscopic data bag information not up to standard.
In addition, the server-side shows the spectroscopic data by a display screen, which receives the not visible spectrum number According to instruction, and the spectroscopic data is denoted as one according to the instruction and has deleted spectroscopic data.
As shown in figure 3, this hair embodiment also provides a kind of spectroscopic data Input System, it is realized using a server-side, should Server-side includes a receiving module 1, one first judgment module 2, a parsing module 3, one first output module 4, an analysis module 5th, a pretreatment module 6, one second output module 7, one second judgment module 8, a matching module 9, one the 3rd judgment module 10, One the 3rd output module 11 and a memory module 12.
Each function module that the spectroscopic data Input System includes is described above, lower mask body introduces each function module institute The function of possessing:
The receiving module 1 is used to receive by its api interface multiple contains multiple light through data encryption and data compression The spectroscopic data bag of modal data, each spectroscopic data bag include medicine name, the authentication code of medicine, manufacturer, production batch, Instrument model, spectrogram and operation requests;
Whether the spectroscopic data bag that first judgment module 2 is used to judge to receive there is data transmission exception situation, if It is not to call the parsing module 3, otherwise calls the information of the 4 output data transmission abnormality of the first output module;
The parsing module 3 is used to obtain the spectroscopic data bag through data decompression and data deciphering, and by the spectroscopic data All spectroscopic datas in bag are stored into a SQL database;
The analysis module 5 is used to analyze the spectral quality in each spectroscopic data bag, in the spectroscopic data bag Spectral quality call the pretreatment module 6 when meeting an established standards, otherwise call second output module 7 to export the spectrum Spectral quality in data packet information not up to standard;
The pretreatment module 6 is used to pre-process the spectroscopic data in the spectroscopic data bag to obtain an optimization spectrum Data;
Second judgment module 8 is used to judge whether the operation requests of the optimization spectroscopic data to be in-stockroom operation requests, if It is to call the matching module 9 to be used to carry out the stored optimization spectroscopic data of the optimization spectroscopic data and the standard database Similarity mode, if the optimization spectroscopic data and a certain stored optimization spectroscopic data similarity in the standard database are big When a given threshold, then the 3rd judgment module 10 is called to judge that the corresponding medicine name of the optimization spectroscopic data is matched with this The corresponding medicine name of optimization spectroscopic data it is whether identical, if then calling the memory module, otherwise call the 3rd output mould The spectroscopic data that block 11 is exported in the spectroscopic data bag does not meet the information that storage requires;
The memory module 12 is used to store the optimization spectroscopic data into a standard database.
Preferably, which can further comprise:
One first judging unit, for judging whether the spectrogram quantity in the spectroscopic data bag is more than one first setting Value, if then calling one second judging unit, otherwise calls second output module;
Second judging unit is used for each spectrogram being directed in the spectroscopic data bag:Judge the Raman position of the spectrogram Scope is moved whether in a setting displacement range, if then a stick unit is used to retain the spectrogram and calls one the 3rd to judge Unit, otherwise one gives up unit for giving up the spectrogram;
3rd judging unit is used to be directed to each spectrogram retained in the spectroscopic data bag:Judge phase in the spectrogram Whether adjacent raman scattering intensity value is less than one the 3rd setting value more than the quantity of one second setting value, if then call the stick unit and One the 4th judging unit, otherwise calls this to give up unit;
4th judging unit is used to be directed to each spectrogram retained in the spectroscopic data bag:Whether judge the spectrogram There are negative peak, if calling the stick unit and one the 5th judging unit there is no if, otherwise calls this to give up unit;
5th judging unit is used to be directed to each spectrogram retained in the spectroscopic data bag:Judge to believe in the spectrogram Make an uproar than whether the quantity more than one the 4th setting value is more than one the 5th setting value, if then calling the stick unit and one the 6th to sentence Disconnected unit, otherwise calls this to give up unit;
6th judging unit is used to be directed to each spectrogram retained in the spectroscopic data bag:Judge be in the spectrogram No at least there are a characteristic peak intensity level to reach one the 6th setting value, if then calling the stick unit and the pretreatment mould Block, otherwise calls this to give up unit.
Although the foregoing describing the embodiment of the present invention, it will be appreciated by those of skill in the art that these It is merely illustrative of, protection scope of the present invention is defined by the appended claims.Those skilled in the art is not carrying on the back On the premise of from the principle of the present invention and essence, various changes or modifications can be made to these embodiments, but these are changed Protection scope of the present invention is each fallen within modification.

Claims (10)

1. a kind of spectroscopic data storage method, it is characterised in that it comprises the following steps:
S1, a server-side by its api interface receive it is multiple through data encryption and data compression containing multiple spectroscopic datas Spectroscopic data bag, each spectroscopic data bag include medicine name, the authentication code of medicine, manufacturer, production batch, instrument type Number, spectrogram and in-stockroom operation request;
Whether S2, the spectroscopic data bag for judging to receive there is data transmission exception situation, if not then entering step S3, otherwise Enter step S8;
S3, the server-side obtain the spectroscopic data bag through data decompression and data deciphering, and by the institute in the spectroscopic data bag There is spectroscopic data to store into a SQL database;
S4, the server-side analyze the spectral quality in each spectroscopic data bag, the spectrum matter in the spectroscopic data bag When amount meets an established standards, S5 is entered step, otherwise enters step S7;
S5, the server-side pre-process the spectroscopic data in the spectroscopic data bag to obtain an optimization spectroscopic data;
S6, the server-side store the optimization spectroscopic data into a standard database;
S7, the server-side export spectral quality in spectroscopic data bag information not up to standard;
The information of S8, the server-side output data transmission abnormality.
2. spectroscopic data storage method as claimed in claim 1, it is characterised in that in step s 6, the server-side is excellent by this Change the stored optimization spectroscopic data of spectroscopic data and the standard database and carry out similarity mode, if the optimization spectroscopic data with When a certain stored optimization spectroscopic data similarity in the standard database is more than a given threshold, then the optimization light is judged Whether the corresponding medicine name of modal data medicine name corresponding with the optimization spectroscopic data that this is matched is identical, if then entering step S7, otherwise enters step S9:The spectroscopic data that the server-side is exported in the spectroscopic data bag does not meet the information that storage requires.
3. spectroscopic data storage method as claimed in claim 1, it is characterised in that step S4 comprises the following steps:
S41, the server-side judge whether the spectrogram quantity in the spectroscopic data bag is more than one first setting value, if then entering Step S42, otherwise enters step S47;
S42, the server-side are directed to each spectrogram in the spectroscopic data bag:Judge the spectrogram Raman shift range whether In a setting displacement range, if then retaining the spectrogram and entering step S43, otherwise give up the spectrogram;
S43, the server-side are directed to each spectrogram retained in the spectroscopic data bag:Judge adjacent raman scattering intensity in the spectrogram Whether the quantity being worth more than one second setting value is less than one the 3rd setting value, if then retaining the spectrogram and entering step S44, Otherwise the spectrogram is given up;
S44, the server-side are directed to each spectrogram retained in the spectroscopic data bag:Judge that the spectrogram whether there is negative peak, If retaining the spectrogram there is no and if entering step S45, otherwise give up the spectrogram;
S45, the server-side are directed to each spectrogram retained in the spectroscopic data bag:Judge that signal-to-noise ratio is more than one in the spectrogram Whether the quantity of the 4th setting value is more than one the 5th setting value, if then retaining the spectrogram and entering step S46, otherwise gives up The spectrogram;
S46, the server-side are directed to each spectrogram retained in the spectroscopic data bag:Judge whether at least exist in the spectrogram One characteristic peak intensity level reaches one the 6th setting value, if then retaining the spectrogram and entering step S5, otherwise gives up the light Spectrogram;
S47, the server-side export spectral quality in spectroscopic data bag information not up to standard.
4. spectroscopic data storage method as claimed in claim 1, it is characterised in that in step sl, which passes through more The mode of thread receives the spectroscopic data bag.
5. spectroscopic data storage method as claimed in claim 1, it is characterised in that the server-side shows this by a display screen Spectroscopic data, the server-side receive the instruction of a not visible spectroscopic data, and are denoted as the spectroscopic data according to the instruction One has deleted spectroscopic data.
6. a kind of spectroscopic data Input System, it is characterised in that it realizes that the server-side includes using a server-side:
One receiving module, multiple contains multiple spectrum numbers for being received by its api interface through data encryption and data compression According to spectroscopic data bag, each spectroscopic data bag include medicine name, the authentication code of medicine, manufacturer, production batch, instrument Model, spectrogram and in-stockroom operation request;
Whether one first judgment module, the spectroscopic data bag for judging to receive there is data transmission exception situation, if not A parsing module is then called, otherwise calls one first output module;
The parsing module is used to obtain the spectroscopic data bag through data decompression and data deciphering, and by the spectroscopic data bag All spectroscopic datas are stored into a SQL database;
One analysis module, for analyzing the spectral quality in each spectroscopic data bag, the light in the spectroscopic data bag Spectrum quality calls a pretreatment module when meeting an established standards, otherwise calls one second output module;
The pretreatment module is used to pre-process the spectroscopic data in the spectroscopic data bag to obtain an optimization spectroscopic data;
One memory module, for storing the optimization spectroscopic data into a standard database;
Second output module information not up to standard for exporting the spectral quality in the spectroscopic data bag;
First output module is used for the information of output data transmission abnormality.
7. spectroscopic data Input System as claimed in claim 6, it is characterised in that the spectroscopic data Input System further includes one Matching module, one the 3rd judgment module and one the 3rd output module;
The matching module is used for the optimization spectroscopic data is similar to the stored optimization spectroscopic data progress of the standard database Degree matching, if the optimization spectroscopic data is more than one with a certain stored optimization spectroscopic data similarity in the standard database During given threshold, then the 3rd judgment module is called to judge the optimization that the corresponding medicine name of the optimization spectroscopic data is matched with this Whether the corresponding medicine name of spectroscopic data is identical, if then calling the memory module, otherwise calls the 3rd output module to export Spectroscopic data in the spectroscopic data bag does not meet the information that storage requires.
8. spectroscopic data Input System as claimed in claim 6, it is characterised in that the analysis module includes:
One first judging unit, for judging whether the spectrogram quantity in the spectroscopic data bag is more than one first setting value, if It is then to call one second judging unit, otherwise calls second output module;
Second judging unit is used for each spectrogram being directed in the spectroscopic data bag:Judge the Raman shift model of the spectrogram Enclose whether in a setting displacement range, if then a stick unit is used to retain the spectrogram and calls one the 3rd to judge list Member, otherwise one gives up unit for giving up the spectrogram;
3rd judging unit is used to be directed to each spectrogram retained in the spectroscopic data bag:Judge adjacent drawing in the spectrogram Whether graceful intensity level is less than one the 3rd setting value more than the quantity of one second setting value, if then calling the stick unit and one Four judging units, otherwise call this to give up unit;
4th judging unit is used to be directed to each spectrogram retained in the spectroscopic data bag:Judge that the spectrogram whether there is Negative peak, if calling the stick unit and one the 5th judging unit there is no if, otherwise calls this to give up unit;
5th judging unit is used to be directed to each spectrogram retained in the spectroscopic data bag:Judge signal-to-noise ratio in the spectrogram Whether the quantity more than one the 4th setting value is more than one the 5th setting value, if then calling the stick unit and one the 6th to judge list Member, otherwise calls this to give up unit;
6th judging unit is used to be directed to each spectrogram retained in the spectroscopic data bag:Whether extremely to judge in the spectrogram There are a characteristic peak intensity level less to reach one the 6th setting value, no if then calling the stick unit and the pretreatment module Then this is called to give up unit.
9. spectroscopic data Input System as claimed in claim 6, it is characterised in that the receiving module is used for by multithreading Mode receives the spectroscopic data bag.
10. spectroscopic data Input System as claimed in claim 6, it is characterised in that the server-side is shown by a display screen The spectroscopic data, the server-side receive the instruction of a not visible spectroscopic data, and are indicated the spectroscopic data according to the instruction Spectroscopic data has been deleted for one.
CN201610969712.3A 2016-10-27 2016-10-27 Spectral data storage method and system Active CN107995248B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201610969712.3A CN107995248B (en) 2016-10-27 2016-10-27 Spectral data storage method and system

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201610969712.3A CN107995248B (en) 2016-10-27 2016-10-27 Spectral data storage method and system

Publications (2)

Publication Number Publication Date
CN107995248A true CN107995248A (en) 2018-05-04
CN107995248B CN107995248B (en) 2021-12-10

Family

ID=62029431

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201610969712.3A Active CN107995248B (en) 2016-10-27 2016-10-27 Spectral data storage method and system

Country Status (1)

Country Link
CN (1) CN107995248B (en)

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN110530841A (en) * 2019-07-16 2019-12-03 河北伊诺光学科技股份有限公司 A kind of spectrogram validation verification method, system, electronic equipment and storage medium

Citations (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20120203510A1 (en) * 2011-02-09 2012-08-09 Cic Photonics, Inc. Spectral analysis operating system
US8395769B2 (en) * 2002-01-10 2013-03-12 Chemimage Corporation Method for analysis of pathogenic microorganisms using raman spectroscopic techniques
CN103592255A (en) * 2013-11-22 2014-02-19 山东东阿阿胶股份有限公司 Soft method for measuring total protein content of donkey-hide gelatin skin solution on basis of near infrared spectrum technology
CN104062256A (en) * 2013-04-15 2014-09-24 山东东阿阿胶股份有限公司 Soft measurement method based on near infrared spectroscopy
CN104596974A (en) * 2015-01-30 2015-05-06 云南中烟工业有限责任公司 Method for measuring paper process reconstituted tobacco filling value via near infrared diffuse reflection spectroscopy

Patent Citations (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US8395769B2 (en) * 2002-01-10 2013-03-12 Chemimage Corporation Method for analysis of pathogenic microorganisms using raman spectroscopic techniques
US20120203510A1 (en) * 2011-02-09 2012-08-09 Cic Photonics, Inc. Spectral analysis operating system
CN104062256A (en) * 2013-04-15 2014-09-24 山东东阿阿胶股份有限公司 Soft measurement method based on near infrared spectroscopy
CN103592255A (en) * 2013-11-22 2014-02-19 山东东阿阿胶股份有限公司 Soft method for measuring total protein content of donkey-hide gelatin skin solution on basis of near infrared spectrum technology
CN104596974A (en) * 2015-01-30 2015-05-06 云南中烟工业有限责任公司 Method for measuring paper process reconstituted tobacco filling value via near infrared diffuse reflection spectroscopy

Non-Patent Citations (1)

* Cited by examiner, † Cited by third party
Title
钱小峰: "基于药用辅料的拉曼光谱鉴别络活喜仿冒药研究", 《药学实践杂志2015年7月25日第33卷第4期》 *

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN110530841A (en) * 2019-07-16 2019-12-03 河北伊诺光学科技股份有限公司 A kind of spectrogram validation verification method, system, electronic equipment and storage medium

Also Published As

Publication number Publication date
CN107995248B (en) 2021-12-10

Similar Documents

Publication Publication Date Title
US12019695B2 (en) Using content identification as context for search
EP3807785B1 (en) Regular expression generation using longest common subsequence algorithm on regular expression codes
US10229208B2 (en) Optimization of query execution
CN111967538A (en) Feature fusion method, device and equipment applied to small target detection and storage medium
CN110221822A (en) Merging method, device, electronic equipment and the computer readable storage medium of special efficacy
US20220148232A1 (en) Systems and methods of generating color palettes with a generative adversarial network
US11762899B1 (en) Lightness filter
CN105095721A (en) Fingerprint authentication display device and method
Yang et al. cDeepArch: A compact deep neural network architecture for mobile sensing
CN107819863A (en) A kind of Explore of Unified Management Ideas and device of cloud platform user
US20240305736A1 (en) Method of processing video frame, electronic device, and storage medium
CN113130086A (en) Health medical big data platform
CN107995248A (en) Spectroscopic data storage method and system
JP6781820B2 (en) Distributed Computing Framework and Distributed Computing Method (DISTRIBUTED COMPUTING FRAMEWORK AND DISTRIBUTED COMPUTING METHOD)
CN110349164A (en) A kind of image, semantic dividing method, device and terminal device
CN107995237A (en) Spectroscopic data compatibility method and system
CN105550240B (en) A kind of method and device of recommendation
CN107995239A (en) Spectroscopic data optimization method and system
US20230180917A1 (en) Method for processing makeup and electronic device
KR102405886B1 (en) Apparatus and method of providing solution of source transformation for architectural changes
CN103150401B (en) A kind of field entirety replacement method based on MapReduce
CN106250510B (en) Searching method, device and system
CN108009173A (en) Spectroscopic data exchange method and system
US11106689B2 (en) System and method for self-service data analytics
CN106304410A (en) A kind of data migration method and mobile terminal

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