CN103279863A - Automatic generation method and system of report file - Google Patents
Automatic generation method and system of report file Download PDFInfo
- Publication number
- CN103279863A CN103279863A CN2013102289473A CN201310228947A CN103279863A CN 103279863 A CN103279863 A CN 103279863A CN 2013102289473 A CN2013102289473 A CN 2013102289473A CN 201310228947 A CN201310228947 A CN 201310228947A CN 103279863 A CN103279863 A CN 103279863A
- Authority
- CN
- China
- Prior art keywords
- data
- report
- file
- report file
- formula
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Images
Abstract
The invention discloses an automatic generation method and system of a report file. The automatic generation method of the report file includes the following steps that a data mining server reads a data source in a laboratory information management system and collects a data set needed by report file generation according to a predefined rule; a report generation client defines a template of the report file according to input of a user; the report generation client receives the data set needed by the report file generation from the data mining server and generates the report file according to the defined template of the report file and obtained formulas used in the report file. Through the automatic generation method and system of the report file, the laboratory information management system can conduct data mining according to needs of the user and generates various report files with intact contents for the user by means of data obtained through mining.
Description
Technical field
The present invention relates to technical field of data processing, relate in particular to a kind of automatic generation method and system of report file.
Background technology
(Laboratory Information Management System LIMS) refers to by computer technology the laboratory Laboratory Information Management System, especially the computer software and hardware system that manages of the various information in sample analysis laboratory.It can for the running of the efficient and science in laboratory with the preservation of information, exchange and processing provides platform, can carry out the quality management of quantification to each link of laboratory work, it is the product that computer technology, management science and analytical technology combine, it the laboratory integrated environment as management object, improve general management to laboratory work by computer technology, to reach work efficiency, working level, the data analysis quality that improves the laboratory and the purpose that reduces cost.
In the real work, the user often needs Laboratory Information Management System that report file miscellaneous is provided, such as laboratory report, experiment progress report, laboratory budget message etc.In the information management system of current experiments chamber, some data is stored in database, and some data is not carried out the electronization storage, and storage mostly be raw data, the client need integrate the data of a plurality of systems or file, is manually searching, and whole process is consuming time also makes mistakes easily.
Summary of the invention
In view of this, the present invention proposes a kind of automatic generation method and system of report file, is used for generating the report file that various users need.
In first aspect, the embodiment of the invention provides a kind of automatic generation method of report file, and described method comprises:
Data mining server reads data source in the Laboratory Information Management System according to predefined rule, collect and generate the required data acquisition of report file, wherein, described data source comprises file, tables of data, data directory and the experimental apparatus in the described Laboratory Information Management System, and the required data acquisition of described generation report file comprises file, tables of data and the data directory that stores the required data of generation report;
Report generates client according to the template of user's input definition report file;
Report generates client and obtains the formula that uses in the report file according to user's input;
Report generates client and receives from described data mining server and generate the required data acquisition of report file, and generates report file according to the formula that uses in the template of the report file of definition and the report file that obtains.
Further, the template according to user's input definition report file comprises:
From the template of predefined report file, select to generate the template that report file uses according to user's input;
Utilize conventional data item and common data item to generate template fragment in the template of report file, wherein, described conventional data item is the fixing data item of value in report file, described common data item is often to use in report file, and the data item with fixing value obtain manner, described template fragment is to comprise conventional data item and common data item, and has determined the fragment of template of report file of the value of conventional data item and common data item.
Further, obtaining the formula that uses in the report file according to user's input comprises:
The data item that mathematical relation is had corresponding formula in the tabulation of predefine formula, input according to the user is selected suitable formula from described predefine formula tabulation, wherein, described predefine formula tabulation is the tabulation that predefined formula is formed in the Laboratory Information Management System;
Mathematical relation is not had the data item of corresponding formula in the tabulation of described predefine formula, obtain suitable formula according to user's input.
Further, receive from described data mining server and to generate the required data acquisition of report file, and generate report file according to the formula that uses in the template of the report file of definition and the report file that obtains and comprise:
Receive the required data acquisition of generation report file of described data mining server transmission, wherein, the required data acquisition of described generation report file comprises file, tables of data and the data directory that stores the required data of generation report;
Analyze and calculate to obtain file analysis result data collection to storing the file that generates the required data of report;
Analyze and calculate to obtain database analysis result data collection to storing the tables of data, the data directory that generate the required data of report;
Utilize described file analysis result data collection and described database analysis result data collection to generate report file.
In second aspect, the embodiment of the invention provides a kind of automatic creation system of report file, and the generation system of described report file comprises that data mining server and report generate client;
Described data mining server comprises data-mining module, described data-mining module is for the data source that reads according to predefined rule in the Laboratory Information Management System, collect and generate the required data acquisition of report file, wherein, described data source comprises file, tables of data, data directory and the experimental apparatus in the described Laboratory Information Management System, and the required data acquisition of described generation report file comprises file, tables of data and the data directory that stores the required data of generation report;
Described report generates client and comprises template definition module, formula acquisition module and report generation module;
Described template definition module is used for the template according to user's input definition report file;
Described formula acquisition module is used for obtaining the formula that report file uses according to user's input;
Described report generation module is used for receiving from described data mining server and generates the required data acquisition of report file, and generates report file according to the formula that uses in the template of the report file of definition and the report file that obtains.
Further, described template definition module comprises that template chooser module and template fragment generate submodule;
Described template chooser module is used for selecting to generate the template that report file uses according to user's input from the template of predefined report file;
Described template fragment generates submodule, be used for utilizing the conventional data item of the required data acquisition of generation report file and the template fragment that common data item generates report file, wherein, described conventional data item is the fixing data item of value in report file, described common data item is often to use in report file, and the data item with fixing value obtain manner, described template fragment is to comprise conventional data item and common data item, and has determined the fragment of template of report file of the value of conventional data item and common data item.
Further, described formula acquisition module comprises that first formula obtains submodule and second formula obtains submodule;
Described first formula obtains submodule, be used for mathematical relation is had in the tabulation of predefine formula the data item of corresponding formula, input according to the user is selected suitable formula from described predefine formula tabulation, wherein, described predefine formula tabulation is the tabulation that predefined formula is formed in the Laboratory Information Management System;
Described second formula obtains submodule, does not have the data item of corresponding formula for mathematical relation is tabulated at described predefine formula, obtains suitable formula according to user's input.
Further, described report generation module comprises that data receive submodule, file analysis and calculating sub module, database analysis and calculating sub module and document generates submodule;
Described data receive submodule, be used for receiving the required data acquisition of generation report file of described data mining server transmission, wherein, the required data acquisition of described generation report file comprises file, tables of data and the data directory that stores the required data of generation report;
Described file analysis and calculating sub module are used for analyzing and calculate to obtain file analysis result data collection to storing the file that generates the required data of report;
Described database analysis and calculating sub module are used for database analysis result data collection is analyzed and calculated to obtain to storage by the tables of data, the data directory that generate the required data of report;
Described document generates submodule, is used for utilizing described file analysis result data collection and described database analysis result data collection to generate report file.
The present invention is by carrying out data mining to the data in the Laboratory Information Management System, generate the report file template, obtain the formula in the report file and generate report, make Laboratory Information Management System can generate the report file of different-format according to user's various demands, the manual intervention that the generative process of document needs is few, and generative process is quick and easy.
Description of drawings
Fig. 1 is the schematic flow sheet of the generation method of the report file that provides of first embodiment of the invention;
Fig. 2 is the structural representation of the data mining server that provides of first embodiment of the invention;
Fig. 3 is the schematic flow sheet of the template definition of the report file that provides of first embodiment of the invention;
Fig. 4 is the schematic flow sheet that the formula of the report file that provides of first embodiment of the invention obtains;
Fig. 5 is the schematic flow sheet of the generation of the report file that provides of first embodiment of the invention;
Fig. 6 is the structural representation of the generation system of the report file that provides of second embodiment of the invention;
Fig. 7 is the structural representation of the template definition module that provides of second embodiment of the invention;
Fig. 8 is the structural representation of the formula acquisition module that provides of second embodiment of the invention;
Fig. 9 is the structural representation of the report generation module that provides of second embodiment of the invention.
Embodiment
Further specify technical scheme of the present invention below in conjunction with accompanying drawing and by embodiment.
Fig. 1 to Fig. 5 shows the first embodiment of the present invention.
Fig. 1 is the schematic flow sheet of the generation method of the report file that provides of first embodiment of the invention.
Referring to Fig. 1, the generation method of described report file comprises: step S101, data mining server reads data source in the Laboratory Information Management System according to predefined rule, collect and generate the required data acquisition of report file, wherein, described data source comprises file, tables of data, data directory and the experimental apparatus in the described Laboratory Information Management System, and the required data acquisition of described generation report file comprises file, tables of data and the data directory that stores the required data of generation report; Step S102, report generates client according to the template of user's input definition report file; Step S103, report generates client and obtains the formula that uses in the report file according to user's input; Step S104, report generates client and receives from described data mining server and generate the required data acquisition of report file, and generates report file according to the formula that uses in the template of the report file of definition and the report file that obtains.
In step S101, data mining server reads data source in the Laboratory Information Management System according to predefined rule, collects to generate the required data acquisition of report file.
Described data mining server is to generating the server that the useful data of report file are found and excavated.Fig. 2 shows structure and the course of work of described data mining server.Referring to Fig. 2, described data mining server comprises data processing unit 201 and data warehouse 202, it from the database 211 of Laboratory Information Management System inside and various file 212 sampling to generating the data that the various report document comes in handy, the data that extract are cleared up, changed and filter, it is the simplest to generate form at last, the required data acquisition of generation report file that can directly utilize.
Described data warehouse 202 is sampled out from the database 211 of Laboratory Information Management System inside and various file 212 to generating the data that report comes in handy according to predefined rule, the described data that the generation report is come in handy are cleared up and changed, and the storage of the result data that will clear up and change.Described predefined rule draws from experiment sample in advance, carries out the sampling of data rule that sampling of data uses for described data warehouse 202.
The database of Laboratory Information Management System inside comprises interior various tables of data and the data directory of database subsystem of described Laboratory Information Management System, the various data that need when described Laboratory Information Management System is moved in these tables of data and data directory, have been stored, for example, the data of lab assistant, the data of experimental apparatus, the financial data in laboratory, various experimental datas etc.Except database, report that to generating the data that come in handy also may be stored with the form of file.The file layout of file may have multiple, such as Microsoft Office file, pdf document etc.Except file, tables of data and data directory, the data source that described data warehouse 202 carries out sampling of data also might comprise experimental apparatus, for example, and saccharimeter, acidometer etc.
File, tables of data, data directory and the experimental apparatus of described data warehouse 202 from Laboratory Information Management System sampled out to after generating the data that report comes in handy, and clears up and changes generating the data that report comes in handy described.Report that to generating it mainly is that the described data that the generation report is come in handy are screened that the data that come in handy are cleared up with described, rejecting does not obviously have the data clauses and subclauses of help to generating report file.After finishing described data scrubbing, with changing generating the data that report comes in handy after the cleaning, mainly be to carry out format conversion to generating the data that report comes in handy after the cleaning.After finishing the cleaning and conversion to data, the result data after described data warehouse 202 will be cleared up and change is stored.
Described data processing unit 201 reads the cleaning of described data warehouse 202 storages and the result data after the conversion, and in process of reading the result data after described cleaning and the conversion is filtered.The purpose that result data after described cleaning and the conversion is filtered is further to reject the data irrelevant with the report file that generates.The result data process of filtering after described cleaning and the conversion comprised the result data after described cleaning and the conversion is analyzed and chosen.Through the filtration of described data processing unit 201, the result data after described Qinghe and the conversion is converted to and generates the required data acquisition of report file.
To the result data after described cleaning and the conversion read with filter process in, described data processing unit 201 may need to read other data of storage in the database 211 of Laboratory Information Management System.At this moment, if described data processing unit 201 need read other data of storing in the database 211 of Laboratory Information Management System, described data processing unit can carry out direct sampling to the data in the database 211, and does not need the processing through data warehouse 202.
Preferably, described data processing unit 211 can also be cleared up with integrated the data that are stored in the described database 211 according to the data filtering result.
In step S102, report generates client according to the template of user's input definition report file.
Fig. 3 is the schematic flow sheet of the template definition of the report file that provides of first embodiment of the invention.Referring to Fig. 3, described step S102 comprises substep S1021, selects to generate the template that report file uses according to user's input from the template of predefined report file; Substep S1022 utilizes conventional data item and common data item to generate template fragment in the template of report file.
In substep S1021, from the template of predefined report file, select to generate the template that report file uses according to user's input.
Though report file is of a great variety, all need to defer to certain form.In the Laboratory Information Management System be report file pre-defined the template of multiple report file.Before generating report file, generate the client reception from user's input with the report that data mining server is connected by LAN (Local Area Network), and in the template of multiple report file, select to be used for generating the template of report file according to user's input.
The report file that Laboratory Information Management System generates comprises simple report file and complicated report file.Simple report file is the report file that whole report file is all used the template generation of same report file.At simple report file, described Laboratory Information Management System is selected one according to user's input and is generated report file from the template of multiple report file.Complicated report file is to comprise different document sections, and different document sections is used the report file of the template of different report files.At the report file of complexity, described Laboratory Information Management System is divided into different document sections with described report file, selects the template of the report file of different document section application then from the template of multiple report file according to user's input.
In substep S1022, utilize conventional data item and common data item to generate template fragment in the template of report file.
The template of report file only defines the form of report file, wherein data item is not defined.Like this, if not to the concrete data item padding data of the report file that generates, then the report file of Sheng Chenging only comprises the format information of report file, and concrete data item wherein all is blank.These blank data item mostly are to obtain can fill behind the corresponding data value in the data source from Laboratory Information Management System.But conventional data item wherein and common data item do not need the data source from Laboratory Information Management System to obtain corresponding data value just can finish filling.
Described conventional data item is the fixing data item of value in report file, and it is usually included in some constants of often using in the calculating process of experimental result, such as, circular constant, Planck's constant, Avogadro's number.Because the value of these conventional data items is fixed, in the generative process of report file, can these data item not carried out data acquisition, directly determine their value, and generate corresponding template fragment.
Described common data item is often to use in report file, and has the data item of fixing value obtain manner, such as system time.Though common data item value is unfixing, obtains the mode of their value and fixes.Simultaneously, because the frequency that common data item occurs in report file is very high, thus just can determine the value of common data item in the stage of the template that generates report file, and generate corresponding template fragment.
In step S103, report generates client and obtains the formula that uses in the report file according to user's input.
It doesn't matter for the value of a lot of data item and other data item in the report file in the report file, still, also has the value of a lot of data item to depend on the value of other data item in the report file.For example, comprise once the gross mass of all reactants of experiment in a laboratory report, so, the gross mass of all reactants then is the summation of quality of participating in each reactant of current chemical reaction.If in report file, inserted the quality of each reactant, just can determine the gross mass of all reactants.Depend on the data item of the value of other data item in the report file for this its value, need edit formula to it.
Fig. 4 is the schematic flow sheet that the formula of the report file that provides of first embodiment of the invention obtains.Referring to Fig. 4, described step S103 comprises substep S1031, and mathematical relation is had the data item of corresponding formula in predefine formula tabulation, selects the formula that is suitable for from the tabulation of predefine formula according to user's input; Substep S1032 does not have the data item of corresponding formula to mathematical relation in predefine formula tabulation, obtain suitable formula according to user's input.
In substep S1031, mathematical relation there is the data item of corresponding formula in predefine formula tabulation, from the tabulation of predefine formula, select the formula that is suitable for according to user's input.
In report file, different data item can have multiple different mathematical relation.In these mathematical relations, it is very common that several mathematical relations are arranged, and in the generative process of report file, often use, for example, sue for peace, ask poor, compare etc.In Laboratory Information Management System, preset the tabulation of predefine formula, stored the formula that in the generative process of report file, often needs use in advance in the described predefine formula tabulation.If the mathematical relation that described data item comprises has been stored in the described predefine formula tabulation, then can from described predefine formula tabulation, select suitable formula according to user's input.
In substep S1032, to having the data item of multiple mathematical relation in the report file, from a plurality of formula, select to be suitable for the formula of described data item according to user's input.
Do not appear in the described predefine formula tabulation if be applicable to the formula of described data item, then can not from described predefine formula tabulation, select suitable formula according to user's input.Like this, Laboratory Information Management System need receive the input from the user, obtains the formula that is applicable to described data item.
In step S104, report generates client and receives from described data mining server and generate the required data acquisition of report file, and generates report file according to the formula that uses in the template of the report file of definition and the report file that obtains.
Finish the data mining to the data that need in the report file, to the definition of the template of report file with to the editor of the formula of report file, then can generate report file.Fig. 5 is the schematic flow sheet of the generation of the report file that provides of first embodiment of the invention.Referring to Fig. 5, described step S104 comprises substep S1041, receives the required data acquisition of generation report file of described data mining server transmission; Substep S1042 analyzes and calculates to obtain file analysis result data collection to storing the file that generates the required data of report; Substep S1043 analyzes and calculates to obtain database analysis result data collection to storing the tables of data, the data directory that generate the required data of report; Substep S1044 utilizes described file analysis result data collection and described database analysis result data collection to generate report file.
In substep S1041, receive the required data acquisition of generation report file of described data mining server transmission.
Described data mining server has been collected by sampling, cleaning, conversion and filtration in step S101 and has been generated the required data acquisition of report file.Generate in the required data acquisition of report file and stored the data item that the generation report file needs with the simplest form.And, passed through cleaning and filtration treatment owing to generate the required data acquisition of report file, be to comprise the less data acquisition that generates the necessary data of report file so generate the required data acquisition of report file.
The data that generate in the required data acquisition of report file are to store with different forms, for example, the data that generate in the required data acquisition of report file can be stored with the form of file, also can store with the form of tables of data or data directory.
In substep S1042, analyze and calculate to obtain file analysis result data collection to storing the file that generates the required data of report.
Generating the required data acquisition of report file can be to store with the form of file, and therefore report generates the required data acquisition of generation report file that client receives from data mining server and comprises that storage is by the file that generates the required data of report.
Though cleaning and filtration treatment through data mining server, generating the required data acquisition of report file has been to comprise the less data acquisition that generates the necessary data of report file, and still comprising data are still the raw data of collecting from the various data sources of Laboratory Information Management System.In the report file that the required data acquisition of generation report file will be applied to generate, also need the required data acquisition of generation report file of data mining server transmission is calculated.Such as, in report file, need to report the productive rate of the product of a chemical reaction, only include the title of the various reactants of this chemical reaction, quality separately in the required data acquisition of the generation report file that data mining server provides, with the title of the various products of this chemical reaction, separately quality.At this moment, report generates client to be needed at first according to the Mass Calculation of the various reactants of this chemical reaction Theoretical Mass of the product of chemical reaction this time, compares with the actual mass of the product of this chemical reaction again, obtains the productive rate of the product of this chemical reaction.
After described report generates client and receives the required data acquisition of the generation report file of data mining server transmission, from generate the required data acquisition of report file, take out the file that generates the required data of report, the file that generates the required data of report is calculated, obtain file analysis result data collection.
In substep S1043, analyze and calculate to obtain database analysis result data collection to storing the tables of data, the data directory that generate the required data of report.
Generating the required data acquisition of report file can be to store with the form of database, therefore and tables of data and data directory are data file layouts the most common in the database, and report generates and comprises storing the required data acquisition of generation report file that client receives from data mining server and generate report required tables of data and data directory.
Because the required data of generation report that receive from data mining server are the raw data of collecting from the various data sources of Laboratory Information Management System, in the report file that the required data acquisition of generation report file is applied to generate, also need to calculate generating the required data acquisition of report file.Generate the required tables of data of report and data directory as a kind of file layout that generates the required data acquisition of report file, the data that wherein comprise are also needed to calculate.
After described report generates client and receives the required data acquisition of the generation report file of data mining server transmission, from generate the required data acquisition of report file, take out tables of data and the data directory that generates the required data of report, tables of data and the data directory that generates the required data of report calculated, obtain database analysis result data collection.
In substep S1044, utilize described file analysis result data collection and described database analysis result data collection to generate report file.
Described file analysis result data collection is the result data collection that obtains after the file that generates the required data of report is analyzed and calculated, and described database analysis result data collection is the result data collection that obtains after the tables of data that generates the required data of report and data directory are analyzed and calculated.Described file analysis data set and described database analysis data centralization have been stored and can be directly used in the data that generate report file.After described report generation client obtains described file analysis data set and described database analysis data set, the data of described file analysis data set and described database analysis data centralization are applied to the template of described report file, have just generated complete report file.
Present embodiment is sampled, clears up, is changed and filter generating the required data of report by utilizing data mining server, and utilize report to generate the template of client definition report file, be the report file defined formula, realized from the mass data of Laboratory Information Management System, carrying out data screening and analysis, and the data of utilizing screening and analysis to obtain have generated, and form is clear, the report file of full-blooded multiple pattern.
Fig. 6 to Fig. 9 shows the second embodiment of the present invention.
Fig. 6 is the structural representation of the generation system of the report file that provides of second embodiment of the invention.
Referring to Fig. 6, the generation system of described report file comprises that data mining server 601 and report generate client 602.Described data mining server 601 and described report generate client 602 and interconnect by LAN (Local Area Network), and carry out data interaction by LAN (Local Area Network).Described data mining server 601 comprises data-mining module 6011.Described report generates client 602 and comprises template definition module 6021, formula acquisition module 6022 and report generation module 6023.
Described data-mining module 6011 is for the data source that reads according to predefined rule in the Laboratory Information Management System, collect and generate the required data acquisition of report file, wherein, described data source comprises file, tables of data, data directory and the experimental apparatus in the described Laboratory Information Management System, and the required data acquisition of described generation report file comprises file, tables of data and the data directory that stores the required data of generation report.
Described data-mining module 6011 is collected the process that generates the required data acquisition of report file can be divided into sampling of data, data scrubbing, data-switching and data filtration.Sampling of data refers to sample file, tables of data, data directory and other data sources from Laboratory Information Management System, to obtain generating the data that report comes in handy.Data scrubbing refers to the data that the generation report comes in handy are cleared up, and removes incoherent data, obtains wrapping the data that come in handy through what clear up to generating.It mainly is stylistic conversion to through the changing generating the data that report comes in handy of cleaning that data-switching refers to, makes through the form of the data that the provincial capital report is come in handy of cleaning more friendly.Data are filtered and are referred to obtain generating the required data acquisition of report file with further rejecting through the data that have nothing to do with the generation report in the data of data-switching.
Described template definition module 6021 is used for the template according to user's input definition report file.Fig. 7 is the structural representation of the template definition module that provides of second embodiment of the invention.Referring to Fig. 7, described template definition module 6021 comprises that template chooser module 60211 and template fragment generate submodule 60212.
Described template chooser module 60211 is used for according to user's input the template of the report file that will generate being selected.Described template chooser module 60211 can generate the template of a unified report file to the report file that will generate, and also the report file that can generate is divided into different document sections, different document sections is selected the template of different report files.
Described template fragment generates submodule 60212 and is used for utilizing the conventional data item of the required data acquisition of generation report file and the template fragment that common data item generates report file.Described conventional data item is the fixing data item of value in report file, such as, the various constants of often using in the experiment.Described common data item is often to use in report file, and has the data item of fixing value obtain manner, such as, system time.Described template fragment is to comprise conventional data item and common data item, and has determined the fragment of template of report file of the value of conventional data item and common data item.
Described formula acquisition module 6022 is used for obtaining the formula that report file uses according to user's input.Fig. 8 is the structural representation of the template definition module that provides of second embodiment of the invention.Referring to Fig. 8, described formula acquisition module 6022 comprises that first formula obtains submodule 60221 and second formula obtains submodule 60222.Described first formula obtains the data item that submodule 60221 is used for mathematical relation is had in the tabulation of predefine formula corresponding formula, input according to the user is selected suitable formula from the tabulation of predefine formula, wherein, described predefine formula tabulation is the tabulation that predefined formula is formed in the Laboratory Information Management System.Described second formula obtains submodule 60222 does not have the data item of corresponding formula for mathematical relation is tabulated at the predefine formula, obtains suitable formula according to user's input.
Described report generation module 6023 is used for receiving from described data mining server and generates the required data acquisition of report file, and generates report file according to the formula that uses in the template of the report file of definition and the report file that obtains.Fig. 9 is the structural representation of the report generation module that provides of second embodiment of the invention.Referring to Fig. 9, described report generation module 6023 comprises that data receive submodule 60231, file analysis and calculating sub module 60232, database analysis and calculating sub module 60233 and document generates submodule 60234.
Described data receive the required data acquisition of generation report file that submodule 60231 receives described data mining server transmission, wherein, the required data acquisition of described generation report file comprises file, tables of data and the data directory that stores the required data of generation report.
Described file analysis and calculating sub module 60232 are used for analyzing and calculate to obtain file analysis result data collection to storing the file that generates the required data of report.
The required data acquisition of generation report file that receives from data mining server can be the data acquisition of storing in a variety of forms.In the multiple file layout that generates the required data acquisition of report file, file is very common a kind of data file layout.To the required data acquisition of generation report file with the document form storage, report generates client and need further analyze and calculate it, to obtain file analysis result data collection.
Described database analysis and calculating sub module 60233 are used for database analysis result data collection is analyzed and calculated to obtain to storage by the tables of data, the data directory that generate the required data of report.
The required data acquisition of generation report file that receives from data mining server also can be to store with the form of database.To the required data acquisition of generation report file with the storage of database form, report generates client also to be needed it is further analyzed and calculates, to obtain database analysis result data collection.
Described document generates submodule 60234 and is used for utilizing described file analysis result data collection and described database analysis result data collection to generate report file.
Stored in described file analysis result data collection and the described database analysis result data collection and can be directly used in the data that generate the laboratory report file.Described document generates submodule 60234 and utilizes described file analysis result data to gather described database analysis result data collection, and the formula that uses in the template of the report file of applying template definition module 6021 definition and the report file that formula acquisition module 6022 obtains just can generate the report file of finishing.
Present embodiment is by arranging data-mining module in data mining server, and reporting that generating client arranges template definition module, formula acquisition module and report generation module, make Laboratory Information Management System can generate the report file of the different demands of the multiple users of satisfying according to various data sources wherein, expand the function of Laboratory Information Management System, made things convenient for the user of Laboratory Information Management System.
Obviously, those skilled in the art should be understood that, above-mentioned each module of the present invention or each step can realize with the general calculation device, they can concentrate on the single calculation element, perhaps be distributed on the network that a plurality of calculation elements form, alternatively, they can realize with the executable program code of computer installation, carried out by calculation element thereby they can be stored in the memory storage, perhaps they are made into each integrated circuit modules respectively, perhaps a plurality of modules in them or step are made into the single integrated circuit module and realize.Like this, the present invention is not restricted to the combination of any specific hardware and software.
Although at this illustrative embodiment of the present invention has been described with reference to the drawings, but should be appreciated that, the present invention is not limited to these embodiment that determines, and those skilled in the art can carry out various other variations and modification therein under the situation that does not depart from the claims scope.
Claims (8)
1. the automatic generation method of a report file is characterized in that, comprising:
Data mining server reads data source in the Laboratory Information Management System according to predefined rule, collect and generate the required data acquisition of report file, wherein, described data source comprises file, tables of data, data directory and the experimental apparatus in the described Laboratory Information Management System, and the required data acquisition of described generation report file comprises file, tables of data and the data directory that stores the required data of generation report;
Report generates client according to the template of user's input definition report file;
Report generates client and obtains the formula that uses in the report file according to user's input;
Report generates client and receives from described data mining server and generate the required data acquisition of report file, and generates report file according to the formula that uses in the template of the report file of definition and the report file that obtains.
2. the automatic generation method of report file according to claim 1 is characterized in that, comprises according to the template of user's input definition report file:
From the template of predefined report file, select to generate the template that report file uses according to user's input;
Utilize conventional data item and common data item to generate template fragment in the template of report file, wherein, described conventional data item is the fixing data item of value in report file, described common data item is often to use in report file, and the data item with fixing value obtain manner, described template fragment is to comprise conventional data item and common data item, and has determined the fragment of template of report file of the value of conventional data item and common data item.
3. the automatic generation method of report file according to claim 1 is characterized in that, obtains the formula that uses in the report file according to user's input and comprises:
The data item that mathematical relation is had corresponding formula in the tabulation of predefine formula, input according to the user is selected suitable formula from described predefine formula tabulation, wherein, described predefine formula tabulation is the tabulation that predefined formula is formed in the Laboratory Information Management System;
Mathematical relation is not had the data item of corresponding formula in the tabulation of described predefine formula, obtain suitable formula according to user's input.
4. the automatic generation method of report file according to claim 1, it is characterized in that, receive from described data mining server and to generate the required data acquisition of report file, and generate report file according to the formula that uses in the template of the report file of definition and the report file that obtains and comprise:
Receive the required data acquisition of generation report file of described data mining server transmission, wherein, the required data acquisition of described generation report file comprises file, tables of data and the data directory that stores the required data of generation report;
Analyze and calculate to obtain file analysis result data collection to storing the file that generates the required data of report;
Analyze and calculate to obtain database analysis result data collection to storing the tables of data, the data directory that generate the required data of report;
Utilize described file analysis result data collection and described database analysis result data collection to generate report file.
5. the automatic creation system of a report file is characterized in that, the generation system of described report file comprises that data mining server and report generate client;
Described data mining server comprises data-mining module, described data-mining module is for the data source that reads according to predefined rule in the Laboratory Information Management System, collect and generate the required data acquisition of report file, wherein, described data source comprises file, tables of data, data directory and the experimental apparatus in the described Laboratory Information Management System, and the required data acquisition of described generation report file comprises file, tables of data and the data directory that stores the required data of generation report;
Described report generates client and comprises template definition module, formula acquisition module and report generation module;
Described template definition module is used for the template according to user's input definition report file;
Described formula acquisition module is used for obtaining the formula that report file uses according to user's input;
Described report generation module is used for receiving from described data mining server and generates the required data acquisition of report file, and generates report file according to the formula that uses in the template of the report file of definition and the report file that obtains.
6. the automatic creation system of report file according to claim 5 is characterized in that, described template definition module comprises that template chooser module and template fragment generate submodule;
Described template chooser module is used for selecting to generate the template that report file uses according to user's input from the template of predefined report file;
Described template fragment generates submodule, be used for utilizing the conventional data item of the required data acquisition of generation report file and the template fragment that common data item generates report file, wherein, described conventional data item is the fixing data item of value in report file, described common data item is often to use in report file, and the data item with fixing value obtain manner, described template fragment is to comprise conventional data item and common data item, and has determined the fragment of template of report file of the value of conventional data item and common data item.
7. the automatic creation system of report file according to claim 5 is characterized in that, described formula acquisition module comprises that first formula obtains submodule and second formula obtains submodule;
Described first formula obtains submodule, be used for mathematical relation is had in the tabulation of predefine formula the data item of corresponding formula, input according to the user is selected suitable formula from described predefine formula tabulation, wherein, described predefine formula tabulation is the tabulation that predefined formula is formed in the Laboratory Information Management System;
Described second formula obtains submodule, does not have the data item of corresponding formula for mathematical relation is tabulated at described predefine formula, obtains suitable formula according to user's input.
8. the automatic creation system of report file according to claim 5 is characterized in that, described report generation module comprises that data receive submodule, file analysis and calculating sub module, database analysis and calculating sub module and document generates submodule;
Described data receive submodule, be used for receiving the required data acquisition of generation report file of described data mining server transmission, wherein, the required data acquisition of described generation report file comprises file, tables of data and the data directory that stores the required data of generation report;
Described file analysis and calculating sub module are used for analyzing and calculate to obtain file analysis result data collection to storing the file that generates the required data of report;
Described database analysis and calculating sub module are used for database analysis result data collection is analyzed and calculated to obtain to storage by the tables of data, the data directory that generate the required data of report;
Described document generates submodule, is used for utilizing described file analysis result data collection and described database analysis result data collection to generate report file.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2013102289473A CN103279863A (en) | 2013-06-08 | 2013-06-08 | Automatic generation method and system of report file |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2013102289473A CN103279863A (en) | 2013-06-08 | 2013-06-08 | Automatic generation method and system of report file |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN103279863A true CN103279863A (en) | 2013-09-04 |
Family
ID=49062374
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN2013102289473A Pending CN103279863A (en) | 2013-06-08 | 2013-06-08 | Automatic generation method and system of report file |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN103279863A (en) |
Cited By (17)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103617496A (en) * | 2013-11-30 | 2014-03-05 | 远光软件股份有限公司 | Informatization report automatic generating method and system |
| CN103839139A (en) * | 2014-03-25 | 2014-06-04 | 天津市康信医药科技有限公司 | Design method of biochemistry experiment recording template |
| CN104298727A (en) * | 2014-09-26 | 2015-01-21 | 广州金山移动科技有限公司 | Template matching method and device based on document |
| CN104820697A (en) * | 2015-04-28 | 2015-08-05 | 迈德高武汉生物医学信息科技有限公司 | Medical data mining method and system |
| CN105160198A (en) * | 2015-09-28 | 2015-12-16 | 深圳华大基因科技服务有限公司 | Data analysis report generation system and method |
| CN105740217A (en) * | 2014-12-08 | 2016-07-06 | 珠海金山办公软件有限公司 | Document generation method and device based on document template |
| CN106339451A (en) * | 2016-08-26 | 2017-01-18 | 成都汉康信息产业有限公司 | Data mining system based on large data |
| CN106598919A (en) * | 2015-10-14 | 2017-04-26 | 中兴通讯股份有限公司 | Document generation method and device |
| WO2017114177A1 (en) * | 2015-12-30 | 2017-07-06 | 阿里巴巴集团控股有限公司 | Travel guide generating method and system |
| CN106940693A (en) * | 2017-02-28 | 2017-07-11 | 广东智源信息技术有限公司 | Laboratory original record single structure processing method |
| CN107329941A (en) * | 2017-07-05 | 2017-11-07 | 福建省特种设备检验研究院 | A kind of editor and prebrowsing system based on special equipment survey report |
| CN107741990A (en) * | 2017-11-01 | 2018-02-27 | 深圳汇生通科技股份有限公司 | Data cleansing integration method and system |
| CN108184170A (en) * | 2017-11-27 | 2018-06-19 | 北京奇艺世纪科技有限公司 | A kind of data processing method and device |
| CN109657222A (en) * | 2018-12-14 | 2019-04-19 | 泰康保险集团股份有限公司 | For generating the method and system of report |
| CN109783785A (en) * | 2018-12-27 | 2019-05-21 | 长沙通诺信息科技有限责任公司 | Generate the method, apparatus and computer equipment of tryout test report |
| CN110097343A (en) * | 2019-05-08 | 2019-08-06 | 上海海洋大学 | Laboratory Intelligent office reporting system |
| CN111047172A (en) * | 2019-12-05 | 2020-04-21 | 山西云时代技术有限公司 | Wine quality inspection and test information system based on modular analysis technology |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101004758A (en) * | 2007-01-26 | 2007-07-25 | 华为技术有限公司 | Method and corresponding system for creating and obtaining report forms |
| CN101650710A (en) * | 2009-08-03 | 2010-02-17 | 金蝶软件（中国）有限公司 | Online software service system as well as method and device for generating report |
| CN101661460A (en) * | 2009-09-18 | 2010-03-03 | 上海宝信软件股份有限公司 | Method and device for generating management system report |
| CN102096688A (en) * | 2009-12-11 | 2011-06-15 | 中国移动通信集团山西有限公司 | Method and device for generating data report |
| US20110276161A1 (en) * | 2010-05-07 | 2011-11-10 | Taiwan Biotech Co., Ltd. | Server for Integrated Pharmaceutical Analysis and Report Generation Service, Method of Integrated Pharmaceutical Manufacturing and Research and Development Numerical Analysis, and Computer Readable Recording Medium |
| CN102708336A (en) * | 2012-05-02 | 2012-10-03 | 四川建设网有限责任公司 | Method and system for electronic document processing based on separation of key data from customized template |
-
2013
- 2013-06-08 CN CN2013102289473A patent/CN103279863A/en active Pending
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101004758A (en) * | 2007-01-26 | 2007-07-25 | 华为技术有限公司 | Method and corresponding system for creating and obtaining report forms |
| CN101650710A (en) * | 2009-08-03 | 2010-02-17 | 金蝶软件（中国）有限公司 | Online software service system as well as method and device for generating report |
| CN101661460A (en) * | 2009-09-18 | 2010-03-03 | 上海宝信软件股份有限公司 | Method and device for generating management system report |
| CN102096688A (en) * | 2009-12-11 | 2011-06-15 | 中国移动通信集团山西有限公司 | Method and device for generating data report |
| US20110276161A1 (en) * | 2010-05-07 | 2011-11-10 | Taiwan Biotech Co., Ltd. | Server for Integrated Pharmaceutical Analysis and Report Generation Service, Method of Integrated Pharmaceutical Manufacturing and Research and Development Numerical Analysis, and Computer Readable Recording Medium |
| CN102708336A (en) * | 2012-05-02 | 2012-10-03 | 四川建设网有限责任公司 | Method and system for electronic document processing based on separation of key data from customized template |
Cited By (23)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103617496A (en) * | 2013-11-30 | 2014-03-05 | 远光软件股份有限公司 | Informatization report automatic generating method and system |
| CN103839139A (en) * | 2014-03-25 | 2014-06-04 | 天津市康信医药科技有限公司 | Design method of biochemistry experiment recording template |
| CN104298727B (en) * | 2014-09-26 | 2018-11-16 | 广州金山移动科技有限公司 | A kind of template matching method and device based on document |
| CN104298727A (en) * | 2014-09-26 | 2015-01-21 | 广州金山移动科技有限公司 | Template matching method and device based on document |
| CN105740217A (en) * | 2014-12-08 | 2016-07-06 | 珠海金山办公软件有限公司 | Document generation method and device based on document template |
| CN104820697A (en) * | 2015-04-28 | 2015-08-05 | 迈德高武汉生物医学信息科技有限公司 | Medical data mining method and system |
| CN105160198A (en) * | 2015-09-28 | 2015-12-16 | 深圳华大基因科技服务有限公司 | Data analysis report generation system and method |
| CN106598919A (en) * | 2015-10-14 | 2017-04-26 | 中兴通讯股份有限公司 | Document generation method and device |
| WO2017114177A1 (en) * | 2015-12-30 | 2017-07-06 | 阿里巴巴集团控股有限公司 | Travel guide generating method and system |
| CN106339451A (en) * | 2016-08-26 | 2017-01-18 | 成都汉康信息产业有限公司 | Data mining system based on large data |
| CN106940693A (en) * | 2017-02-28 | 2017-07-11 | 广东智源信息技术有限公司 | Laboratory original record single structure processing method |
| CN106940693B (en) * | 2017-02-28 | 2020-09-01 | 广东智源信息技术有限公司 | Single structure processing method for laboratory original record |
| CN107329941A (en) * | 2017-07-05 | 2017-11-07 | 福建省特种设备检验研究院 | A kind of editor and prebrowsing system based on special equipment survey report |
| CN107329941B (en) * | 2017-07-05 | 2020-07-10 | 福建省特种设备检验研究院 | Special equipment inspection report based editing and previewing system |
| CN107741990A (en) * | 2017-11-01 | 2018-02-27 | 深圳汇生通科技股份有限公司 | Data cleansing integration method and system |
| CN107741990B (en) * | 2017-11-01 | 2023-05-16 | 深圳汇生通科技股份有限公司 | Data cleaning integration method and system |
| CN108184170A (en) * | 2017-11-27 | 2018-06-19 | 北京奇艺世纪科技有限公司 | A kind of data processing method and device |
| CN108184170B (en) * | 2017-11-27 | 2021-08-20 | 北京奇艺世纪科技有限公司 | Data processing method and device |
| CN109657222A (en) * | 2018-12-14 | 2019-04-19 | 泰康保险集团股份有限公司 | For generating the method and system of report |
| CN109783785A (en) * | 2018-12-27 | 2019-05-21 | 长沙通诺信息科技有限责任公司 | Generate the method, apparatus and computer equipment of tryout test report |
| CN109783785B (en) * | 2018-12-27 | 2023-04-18 | 长沙通诺信息科技有限责任公司 | Method and device for generating experiment detection report and computer equipment |
| CN110097343A (en) * | 2019-05-08 | 2019-08-06 | 上海海洋大学 | Laboratory Intelligent office reporting system |
| CN111047172A (en) * | 2019-12-05 | 2020-04-21 | 山西云时代技术有限公司 | Wine quality inspection and test information system based on modular analysis technology |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN103279863A (en) | Automatic generation method and system of report file | |
| CN110532019B (en) | Method for tracing history of software code segment | |
| CN105653537B (en) | Paging query method and device for database application system | |
| CN104933095A (en) | Heterogeneous information universality correlation analysis system and analysis method thereof | |
| Corradini et al. | RePROSitory: a Repository Platform for Sharing Business PROcess modelS. | |
| CN105353960A (en) | Talent platform-based interaction method and system and talent interaction platform | |
| CN111652468A (en) | Business process generation method and device, storage medium and computer equipment | |
| Luburić et al. | Comparing apache solr and elasticsearch search servers | |
| CN110717806B (en) | Product information pushing method, device, equipment and storage medium | |
| US20160086361A1 (en) | Analytics visualization | |
| CN109389972B (en) | Quality testing method and device for semantic cloud function, storage medium and equipment | |
| US20130159327A1 (en) | Apparatus and method for visualizing data | |
| CN113485983A (en) | Questionnaire data processing method and device | |
| CN113918606A (en) | Log query method and device | |
| CN103049518A (en) | System and method for providing application service for user based on intelligent device | |
| CN109522466B (en) | Distributed crawler system | |
| CN106557564A (en) | A kind of object data analysis method and device | |
| Wyborn et al. | Integrating ‘Big’geoscience data into the petascale national environmental research interoperability platform (NERDIP): Successes and unforeseen challenges | |
| JP6496078B2 (en) | Analysis support device, analysis support method, and analysis support program | |
| Koitz et al. | StakeCloud Tool: From cloud consumers' search queries to new service requirements | |
| CN117406990B (en) | Page generation method, page generation device, electronic equipment and computer readable storage medium | |
| CN104899309A (en) | Method and device for displaying event review opinions | |
| CN103473233A (en) | Method and device for determining optimization information of search promotion units | |
| Buono et al. | Insights on the development of visual tools for analysis of pollution data. | |
| KR102526044B1 (en) | Method and apparatus for providing information using a database in which a plurality of networked information is stored |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20130904 |