CN101499162A - Medical research data management system and method - Google Patents
Medical research data management system and method Download PDFInfo
- Publication number
- CN101499162A CN101499162A CNA2009100471070A CN200910047107A CN101499162A CN 101499162 A CN101499162 A CN 101499162A CN A2009100471070 A CNA2009100471070 A CN A2009100471070A CN 200910047107 A CN200910047107 A CN 200910047107A CN 101499162 A CN101499162 A CN 101499162A
- Authority
- CN
- China
- Prior art keywords
- data
- module
- file
- database
- tables
- 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 relates to a medicine scientific research data management system and a method thereof. The system includes a database, a data table management module, a data table recording module and a file export module. The method includes steps as follows: the data table management operation, the data table record operation, an Excel file setting and exporting operation, a Word file templet management operation and a Word file export operation. Using the system and the method can realize function that cooperates researcher recording, storing, amending and exporting clinic data conveniently, furthermore, processing medicine statistic. Using the system and the method has convenient rapid realization course, stable reliable working performance, can generate recording interface directly and increase researching and working efficiency of medicine researcher greatly, can quicken recording speed, the program control SQL inquire single refurbishing amount is 50 pieces per time, time for exporting 998 data is 67.23 seconds and the exporting time is infinitude, which has wide application range and takes great convenient to medicine research work.
Description
Technical field
The present invention relates to the medical research field, particularly the medical research data management technical field specifically is meant a kind of medical research data management system.
Background technology
In the modern society, along with the continuous development of medical science and technology, the importance of medical research work more and more highlights.But, in the prior art,, all need the practical problems that faces thereby become basis and clinical research because the data acquisition project of medical research is various, form differs.Many medical research workers are subjected to data acquisition, the data typing, the puzzlement of data statistics, only data processing section just took one month even the time of some months finishes, work efficiency is low, especially in the Tu Chu collection process that shows clinical large sample amount data, experiment and clinical data for medical research also lacks unified management at present, can't assist the scientific research personnel conveniently clinical and experimental data to be carried out typing, storage, revise, derive, can't carry out medical statistics more, and need time update for the design that occurs in the medical research process, papery data management and retrieval are made troubles, data derivation workload is big simultaneously, team collaboration is comparatively unfavorable, and so just work has brought very big obstacle to medical research.
Simultaneously, ASP be Microsoft exploitation can carry out mutual a kind of programming tool simply and easily with database and other program.It is that a kind of server side scripts is write environment, can be used for creating and operation dynamic web page or web application.
Javascript is a kind of OO client script language that is come by the LiveScript development of Netscape, and fundamental purpose is for the settlement server end instruction, and such as Perl, the speed issue of leaving over is for the client provides more smooth result of browse.
XML (Extensible Markup Language) is an extend markup language, and it is the same with HTML, all is standard generalized markup language.Xml is cross-platform in the Internet environment, depends on the technology of content, is the strong instrument of current Processing Structure document information.
Access is the desktop relational database management system (rdbms) based on Windows that Microsoft releases, and is one of Office serial application software.It provides table, inquiry, forms, form, page or leaf, grand, 7 kinds of objects that are used for setting up Database Systems of module; Multiple guide, maker, template are provided, regularized operations such as data storage, data query, INTERFACE DESIGN, report generations; For the data base management system (DBMS) of setting up perfect in shape and function provides convenience, also make domestic consumer needn't write code, just can finish the task of most of data management.
ASP, Javascript, XML have efficiently characteristics easily with the exploitation that combines of Access, and many network software systems are to set up based on this technology, have become very proven technique at present.
Summary of the invention
The objective of the invention is to have overcome above-mentioned shortcoming of the prior art, provide a kind of and can realize effectively that medical research clinical and typing, storage, modification, derivation, implementation procedure experimental data are convenient and swift, stable and reliable working performance, the scope of application medical research data management system and method thereof comparatively widely.
In order to realize above-mentioned purpose, medical research data management system of the present invention and method thereof are as follows:
This medical research data management system, its principal feature are that described system comprises:
Database, storage medical research data message;
The management data table module is connected with described database, and creates and management data list in this database;
Tables of data typing module all is connected with database with described database management module, the data of typing correspondence in the tables of data that this management data table module is created; With
File is derived module, is connected with described database, according to the form of the data message spanned file form in the database.
File in this medical research data management system is derived module and is comprised:
The Excel file is provided with and derives module, is connected with described database, generates the tables of data of Excel document form according to the data message in the database; With
Management of Word file template and derivation module are connected with described database, generate and the pairing Word template of tables of data, and generate the tables of data of Word document form according to the data message in the database.
Also comprise in this medical research data management system:
The high-level data retrieval module is connected with described database, retrieves in database according to user's search operaqtion generation retrieve statement, and result for retrieval is exported.
High-level data retrieval module in this medical research data management system also all is connected with management of Word file template and derivation module with setting of described Excel file and derivation module, and described result for retrieval is delivered to this Excel file setting and derivation module and Word file template manage and derive in the module.
Also comprise in this medical research data management system:
User management module is connected with described database, carry out the system login account be provided with the management and user right management is set.
Database in this medical research data management system is the Access database.
Should realize the method for medical research data management based on above-mentioned system, its principal feature is, described method comprises management data table operation, tables of data typing operation, the Excel file is provided with and derivation operation, Word file template bookkeeping and Word file are derived operation, described management data table operation may further comprise the steps:
(1) described management data table module is obtained the database table relevant content information according to user's input operation;
(2) the management data table module is carried out the logic determines of database table relevant content information;
(3) if logic determines is passed through management data table module record data structure and create tables of data in database then; Otherwise return above-mentioned steps (1)
(4) described management data table module is selected corresponding tables of data according to user's input operation;
(5) the management data table module is obtained this data sheet field relevant content information according to user's input operation;
(6) the management data table module is carried out the logic determines of data sheet field relevant content information;
(7) if logic determines is passed through management data table module records field contents structure and insert field in tables of data then; Otherwise return above-mentioned steps (5);
Described tables of data typing operation may further comprise the steps:
(11) described tables of data typing module is selected corresponding tables of data according to user's input operation;
(12) tables of data typing module produces corresponding typing table according to the list structure of this tables of data;
(13) tables of data typing module is obtained corresponding medical research data message according to user's input operation;
(14) tables of data typing module is carried out the logic determines of medical research data message;
(15) if logic determines is passed through, then tables of data typing module is recorded to this medical research data message in the corresponding tables of data; Otherwise return above-mentioned steps (13);
Described Excel file is provided with and derives operation, may further comprise the steps:
(21) described file is derived module and is selected corresponding tables of data according to user's input operation;
(22) file is derived the logic determines that module is carried out the tables of data selection;
(23) if logic determines is passed through, then file is derived module and is selected corresponding derived field in the tables of data according to user's input operation; Otherwise return above-mentioned steps (21);
(24) file is derived the logic determines that module is carried out the field selection;
(25) if logic determines is passed through, then file derivation module deposits the structure of derived field in the database in;
(26) file derivation module is extracted corresponding data information and is generated the Excel file according to the structure of derived field from database;
Described Word file template bookkeeping may further comprise the steps:
(31) system produces and the corresponding Word template file of tables of data according to user's editing operation;
(32) described file is derived the input operation of module according to the user, imports corresponding Word template file;
(33) file is derived the logic determines that module is carried out the Word template file;
(34) if logic determines is passed through, then file is derived this Word template file of module analysis and is deposited in the database; Otherwise return above-mentioned steps (32);
Described Word file is derived operation, may further comprise the steps:
(41) file is derived the input operation of module according to the user, carries out the nested operation of coupling of tables of data and corresponding Word template file;
(42) file is derived the input operation of module according to the user, and the quantity of the data message that is generated is set;
(43) file derivation module is extracted corresponding data information and is generated the Word file according to this Word template file from database.
Database table relevant content information in the method for this realization medical research data management comprises submits to table name, database table name and tables of data profile information, described data sheet field relevant content information to comprise typing field name, Database field name, sequence number, field problem and xls row name information.
Also comprise the high-level data search operaqtion in the method for this realization medical research data management, may further comprise the steps:
(51) described high-level data retrieval module is selected the data retrieved table according to user's input operation;
(52) the high-level data retrieval module carries out the logic determines that tables of data is selected;
(53) if logic determines is passed through, then the high-level data retrieval module writes down corresponding search condition according to user's input operation; Otherwise return above-mentioned steps (51);
(54) the high-level data retrieval module carries out the logic determines that search condition is selected;
(55) if logic determines is passed through, then the high-level data retrieval module produces and preserves corresponding SQL query statement according to this search condition; Otherwise return above-mentioned steps (53);
(56) the high-level data retrieval module extracts corresponding data information according to this SQL query statement and this data message is exported from database;
(57) the high-level data retrieval module is sent to file with this data message and derives module;
(58) described file is derived module and is generated the Excel file according to this data message.
Word template file in the method for this realization medical research data management is the template file of Word XML form.
The medical research data management system and the method thereof of this invention have been adopted, because it utilizes ASP, Java, XML is in conjunction with the Access database, and with ASP, JavaScript, XML carries out ingenious the combination with the Access database, add the network programming technology, thereby realized that the assistance scientific research personnel makes things convenient for the clinical data typing, storage, revise, derive and then carry out the function of medical statistics, not only implementation procedure is convenient and swift, and can visualize generate input interface, memory capacity is decided according to Access, the high storage capacity of theory can reach 2GB, holds record about 100,000; The while stable and reliable working performance, can increase substantially medical research personnel's scientific research and work efficiency, after tested, the single piece of data of the papery of comparing typing, system and method for the present invention can be accelerated input speed, and programmed control SQL query single refreshes number (50/time), its time of deriving 998 data is 67.23 seconds, and it is unlimited to derive number of times, so the scope of application is comparatively extensive, and work has brought very big facility to medical research.
Description of drawings
Fig. 1 is the overall architecture synoptic diagram of medical research data management system of the present invention.
Fig. 2 is the research data management process synoptic diagram of medical research data management system of the present invention.
Fig. 3 is the user management process synoptic diagram of medical research data management system of the present invention.
Fig. 4 is the process flow diagram of the management data table operation of medical research data management method of the present invention.
Fig. 5 is the process flow diagram of the tables of data typing operation of medical research data management method of the present invention.
Fig. 6 is that the Excel of medical research data management method of the present invention is provided with and file is derived the process flow diagram of operating.
Fig. 7 is the process flow diagram of the Word Template Manager operation of medical research data management method of the present invention.
Fig. 8 is the process flow diagram that the Word file of medical research data management method of the present invention is derived operation.
Fig. 9 is the process flow diagram of the high-level data search operaqtion of medical research data management method of the present invention.
Embodiment
In order more to be expressly understood technology contents of the present invention, describe in detail especially exemplified by following examples.
See also Fig. 1 to shown in Figure 9, this medical research data management system, comprising:
(1) database, storage medical research data message; Described database is the Access database;
(2) management data table module is connected with described database, and creates and management data list in this database;
(3) tables of data typing module all is connected with database with described database management module, the data of typing correspondence in the tables of data that this management data table module is created; With
(4) file is derived module, be connected with described database, and according to the form of the data message spanned file form in the database, comprising:
(a) the Excel file is provided with and derives module, is connected with described database, generates the tables of data of Excel document form according to the data message in the database;
(b) management of Word file template and derivation module are connected with described database, generate and the pairing Word template of tables of data, and generate the tables of data of Word document form according to the data message in the database;
(5) high-level data retrieval module is connected with described database, retrieves in database according to user's search operaqtion generation retrieve statement, and result for retrieval is exported; This high-level data retrieval module also all is connected with management of Word file template and derivation module with setting of described Excel file and derivation module, and described result for retrieval is delivered to this Excel file setting and derivation module and Word file template manage and derive in the module;
(6) user management module is connected with described database, carry out the system login account be provided with the management and user right management is set.
Should realize the method for medical research data management based on above-mentioned system, derive operation and high-level data search operaqtion comprising management data table operation, tables of data typing operation, the setting of Excel file and derivation operation, Word file template bookkeeping, Word file, described management data table operation may further comprise the steps:
(1) described management data table module is obtained the database table relevant content information according to user's input operation, comprises submitting table name, database table name and tables of data profile information to;
(2) the management data table module is carried out the logic determines of database table relevant content information;
(3) if logic determines is passed through management data table module record data structure and create tables of data in database then; Otherwise return above-mentioned steps (1)
(4) described management data table module is selected corresponding tables of data according to user's input operation;
(5) the management data table module is obtained this data sheet field relevant content information according to user's input operation, comprises typing field name, Database field name, sequence number, field problem and xls row name information;
(6) the management data table module is carried out the logic determines of data sheet field relevant content information;
(7) if logic determines is passed through management data table module records field contents structure and insert field in tables of data then; Otherwise return above-mentioned steps (5);
Described tables of data typing operation may further comprise the steps:
(11) described tables of data typing module is selected corresponding tables of data according to user's input operation;
(12) tables of data typing module produces corresponding typing table according to the list structure of this tables of data;
(13) tables of data typing module is obtained corresponding medical research data message according to user's input operation;
(14) tables of data typing module is carried out the logic determines of medical research data message;
(15) if logic determines is passed through, then tables of data typing module is recorded to this medical research data message in the corresponding tables of data; Otherwise return above-mentioned steps (13);
Described Excel file is provided with and derives operation, may further comprise the steps:
(21) described file is derived module and is selected corresponding tables of data according to user's input operation;
(22) file is derived the logic determines that module is carried out the tables of data selection;
(23) if logic determines is passed through, then file is derived module and is selected corresponding derived field in the tables of data according to user's input operation; Otherwise return above-mentioned steps (21);
(24) file is derived the logic determines that module is carried out the field selection;
(25) if logic determines is passed through, then file derivation module deposits the structure of derived field in the database in;
(26) file derivation module is extracted corresponding data information and is generated the Excel file according to the structure of derived field from database;
Described Word file template bookkeeping may further comprise the steps:
(31) system produces and the corresponding Word template file of tables of data according to user's editing operation, and this Word template file is the template file of Word XML form;
(32) described file is derived the input operation of module according to the user, imports corresponding Word template file;
(33) file is derived the logic determines that module is carried out the Word template file;
(34) if logic determines is passed through, then file is derived this Word template file of module analysis and is deposited in the database; Otherwise return above-mentioned steps (32);
Described Word file is derived operation, may further comprise the steps:
(41) file is derived the input operation of module according to the user, carries out the nested operation of coupling of tables of data and corresponding Word template file;
(42) file is derived the input operation of module according to the user, and the quantity of the data message that is generated is set;
(43) file derivation module is extracted corresponding data information and is generated the Word file according to this Word template file from database.
Described high-level data search operaqtion may further comprise the steps:
(51) described high-level data retrieval module is selected the data retrieved table according to user's input operation;
(52) the high-level data retrieval module carries out the logic determines that tables of data is selected;
(53) if logic determines is passed through, then the high-level data retrieval module writes down corresponding search condition according to user's input operation; Otherwise return above-mentioned steps (51);
(54) the high-level data retrieval module carries out the logic determines that search condition is selected;
(55) if logic determines is passed through, then the high-level data retrieval module produces and preserves corresponding SQL query statement according to this search condition; Otherwise return above-mentioned steps (53);
(56) the high-level data retrieval module extracts corresponding data information according to this SQL query statement and this data message is exported from database;
(57) the high-level data retrieval module is sent to file with this data message and derives module;
(58) described file is derived module and is generated the Excel file according to this data message.
In the middle of practical application, the basic thought of medical research data management system of the present invention and method thereof is as follows:
1, scientific research and design part: the present invention can be according to medical research personnel's preliminary conception, by the management function of tables of data, and self-defined fully each clauses and subclauses that go out data acquisition.Various informative, can comprise the topic of filling a vacancy, multiple-choice question, scale calculating or the like.And the hmtl list of generation is relevant automatically Access tables of data, data sheet field and visual data typing, and can require according to the modification of problem to adjust at any time, solve the difficulty of problem Change In Design.The function of this part is finished by the management data table module.
2, the typing of data and retrieval scheme: the data that the typing of the visual typing list imagery that medical research personnel Ke Yi generates from system of the present invention is clinical or experiment obtains, submit to the back to preserve in the Access database, conveniently call and derive.And can generate the retrieval list according to every clauses and subclauses of data typing, make things convenient for the data that the scientific research personnel retrieves fast to be needed.The function of this part is finished by data typing module.
3, the solution that derives of data: because of the data of medical research gather and need carry out statistical treatment in data statistics softwares such as SPSS or SAS with the form of form.Therefore the invention provides the mode of operation that derives and generate the most frequently used Excel/TXT form as required.The medical research personnel can be according to the statistics needs of subject study, the derivation clauses and subclauses in the selection data table, data area or the like, and the present invention just can extract related data and derive and generate the Excel/TXT data form from the Access database.Thereby solved the problem that scientific research personnel in the statistic processes carries out uninteresting typing, makes mistakes easily in the face of SPSS or Excel form.The function of this part is provided with and is derived module and finishes by Excel.
4, the reverse derivation of written material: mode is similar to the generative process of electronic medical records, the scientific research personnel can import the Word template that designs voluntarily (saving as Word Xml file after promptly finishing the Word version of case MSDS, experimental data table or the like data acquisition form) in the system of the present invention, system of the present invention just can generate the Word data material of electronics in batches according to the content of Word template, only it need be printed and just can be used as the use of scientific research source book.The function of this part is finished by Word Template Manager and derivation module.
5, advanced search pattern: the user can retrieve arbitrarily according to database table and the Database field oneself set, and its mode can be that the inquiry of forms data table also can be the conjunctive query of multidata table.Querying condition also can be provided with arbitrarily and make up simultaneously, and the present invention will carry out statement optimization and process storage to query script, at last query script is carried out record.Except can directly browsing, also this result can be carried out the derivation of data form, convenient statistics to the data query result.The function of this part is finished by the high-level data retrieval module.
6, multi-user's collaboration mode: system of the present invention is provided with two kinds of user models, be system manager and data entry operator, authority between the two has difference, and the typing personnel only are responsible for the typing of data and the modification of own logging data, and the system manager has all operating rights.Because system of the present invention realizes having adopted the network programming language compilation, the fictitious host computer or the unique host that therefore only need it to be distributed to support ASP language get final product building of network system (website), need not special mounting, finish the multicenter association control.The function of this part is finished by user management module.
Because each module of the present invention can assist the medical research personnel to finish corresponding work, thereby has improved scientific research efficient.
In the specific implementation process, system of the present invention combines the numerous technology of ASP, Java, XML and Access, adopted UltraEditor 12.00E+ to cooperate Access to write, at first in the Access database, set up the structural table tablelist of storage " design data sheet ", and set up the field that the design epiphase closes within it, carry out interpolation, editor, the deletion of tables of data in conjunction with the Javascript language by ASP.In the Access database, set up the structural table zdlist of storage " design field " then, and set up the field that the design epiphase closes within it, carry out interpolation, editor, the deletion of tables of data by the ASP program.
Write list control common component form.asp in programming earlier, the generation function of each list of intension is so that each program module is called use.As typing conversation strip function:
Next writes public invocation component function.asp and common.asp, built-in public call function.
The user can finish the design (table and the field in it) of tables of data according to the problem designing requirement, and asp inserts new table and interior field thereof according to the list structure of submitting in the Access storehouse.
Adopt table.asp to call relevant field contents, generate the data input interface according to table name (transmitting variable tbmc).And the data storage of typing warehouse-in, data locking is id (automatic numbering field) location of master meter, adopts from table crossid=master meter id from being connected between table and the master meter, thereby sets up master meter and from being connected of showing.
Excel is provided with and derives module:
The data table name that at first calls among the tablelist is selected (multiselect) for derivation person, and program has judged whether the selection tables of data, and whether the selection master meter is arranged.
After judging that table name finishes, the relevant field among the table name variable location zdlist of transmission is selected for derivation person, and program has judged whether the selection field, and whether the selection mandatory field is arranged.
The table of all derivation and field unification thereof deposit among the relevant derived table xlslist, so that need call in the time of derivation.
When the user need derive, can be chosen in existing each derivation setting in the xlslist table fast, program can be provided with the data of extracting in each table according to derivation, synthesizes the Excel file.
Word is provided with and derives module:
The user needs embedded system regulation label in the word file is saved as the xml file of word2003/2007 version after finishing, and after program imports this xml, can judge whether automatically mistake to occur and return miscue into effective word template.
After correct word template imported, program was used the replace mode positioning label in the word xml file is analyzed automatically, finishes regularization, deposits in the word template table of database.
The user can import different word templates, to the nested different template of different project selections, so that generate the Word file at any time.
When needs generated the Word file, program was according to the composition within the system label in the nested Word template (" [] "), and the location replacement data adopts adodb.stream file operation assembly to generate word file (utf8 form).
The mode class that the pattern of finishing of high-level data retrieval and Excel derive seemingly, the SQL retrieval mode adopts the subquery pattern of optimization, its retrieval type is as follows:
Adopt the mode of crossid search id to connect between a plurality of tables of data, finally finish data retrieval.
The multi-user management module is set up the user table in the access database, give tacit consent to a built-in power user, the user is called admin, password: admin888, list field in the user table is used to control each user's concrete power limit, accomplishes the authority refinement, and the dj field is used to control user's grade, by the global reference among the function.asp, finish the control of authority of each module.
Above-mentioned medical research data management system and method thereof have been adopted, because it utilizes ASP, Java, XML is in conjunction with the Access database, and with ASP, JavaScript, XML carries out ingenious the combination with the Access database, add the network programming technology, thereby realized that the assistance scientific research personnel makes things convenient for the clinical data typing, storage, revise, derive and then carry out the function of medical statistics, not only implementation procedure is convenient and swift, and can visualize generate input interface, memory capacity is decided according to Access, the high storage capacity of theory can reach 2GB, holds record about 100,000; The while stable and reliable working performance, can increase substantially medical research personnel's scientific research and work efficiency, after tested, the single piece of data of the papery of comparing typing, system and method for the present invention can be accelerated input speed, and programmed control SQL query single refreshes number (50/time), its time of deriving 998 data is 67.23 seconds, and it is unlimited to derive number of times, so the scope of application is comparatively extensive, and work has brought very big facility to medical research.
In this instructions, the present invention is described with reference to its certain embodiments.But, still can make various modifications and conversion obviously and not deviate from the spirit and scope of the present invention.Therefore, instructions and accompanying drawing are regarded in an illustrative, rather than a restrictive.
Claims (10)
1, a kind of medical research data management system is characterized in that, described system comprises:
Database, storage medical research data message;
The management data table module is connected with described database, and creates and management data list in this database;
Tables of data typing module all is connected with database with described database management module, the data of typing correspondence in the tables of data that this management data table module is created; With
File is derived module, is connected with described database, according to the form of the data message spanned file form in the database.
2, medical research data management system according to claim 1 is characterized in that, described file is derived module and comprised:
The Excel file is provided with and derives module, is connected with described database, generates the tables of data of Excel document form according to the data message in the database; With
Management of Word file template and derivation module are connected with described database, generate and the pairing Word template of tables of data, and generate the tables of data of Word document form according to the data message in the database.
3, medical research data management system according to claim 2 is characterized in that, also comprises in the described system:
The high-level data retrieval module is connected with described database, retrieves in database according to user's search operaqtion generation retrieve statement, and result for retrieval is exported.
4, medical research data management system according to claim 3, it is characterized in that, described high-level data retrieval module also all is connected with management of Word file template and derivation module with setting of described Excel file and derivation module, and described result for retrieval is delivered to this Excel file setting and derivation module and Word file template manage and derive in the module.
5, according to each described medical research data management system in the claim 1 to 4, it is characterized in that, also comprise in the described system:
User management module is connected with described database, carry out the system login account be provided with the management and user right management is set.
According to each described medical research data management system in the claim 1 to 4, it is characterized in that 6, described database is the Access database.
7, a kind of method that realizes medical research data management based on the described system of claim 1, it is characterized in that, described method comprises management data table operation, tables of data typing operation, the Excel file is provided with and derivation operation, Word file template bookkeeping and Word file are derived operation, described management data table operation may further comprise the steps:
(1) described management data table module is obtained the database table relevant content information according to user's input operation;
(2) the management data table module is carried out the logic determines of database table relevant content information;
(3) if logic determines is passed through management data table module record data structure and create tables of data in database then; Otherwise return above-mentioned steps (1)
(4) described management data table module is selected corresponding tables of data according to user's input operation;
(5) the management data table module is obtained this data sheet field relevant content information according to user's input operation;
(6) the management data table module is carried out the logic determines of data sheet field relevant content information;
(7) if logic determines is passed through management data table module records field contents structure and insert field in tables of data then; Otherwise return above-mentioned steps (5);
Described tables of data typing operation may further comprise the steps:
(11) described tables of data typing module is selected corresponding tables of data according to user's input operation;
(12) tables of data typing module produces corresponding typing table according to the list structure of this tables of data;
(13) tables of data typing module is obtained corresponding medical research data message according to user's input operation;
(14) tables of data typing module is carried out the logic determines of medical research data message;
(15) if logic determines is passed through, then tables of data typing module is recorded to this medical research data message in the corresponding tables of data; Otherwise return above-mentioned steps (13);
Described Excel file is provided with and derives operation, may further comprise the steps:
(21) described file is derived module and is selected corresponding tables of data according to user's input operation;
(22) file is derived the logic determines that module is carried out the tables of data selection;
(23) if logic determines is passed through, then file is derived module and is selected corresponding derived field in the tables of data according to user's input operation; Otherwise return above-mentioned steps (21);
(24) file is derived the logic determines that module is carried out the field selection;
(25) if logic determines is passed through, then file derivation module deposits the structure of derived field in the database in;
(26) file derivation module is extracted corresponding data information and is generated the Excel file according to the structure of derived field from database;
Described Word file template bookkeeping may further comprise the steps:
(31) system produces and the corresponding Word template file of tables of data according to user's editing operation;
(32) described file is derived the input operation of module according to the user, imports corresponding Word template file;
(33) file is derived the logic determines that module is carried out the Word template file;
(34) if logic determines is passed through, then file is derived this Word template file of module analysis and is deposited in the database; Otherwise return above-mentioned steps (32);
Described Word file is derived operation, may further comprise the steps:
(41) file is derived the input operation of module according to the user, carries out the nested operation of coupling of tables of data and corresponding Word template file;
(42) file is derived the input operation of module according to the user, and the quantity of the data message that is generated is set;
(43) file derivation module is extracted corresponding data information and is generated the Word file according to this Word template file from database.
8, the method for realization medical research data management according to claim 7, it is characterized in that, described database table relevant content information comprises submits to table name, database table name and tables of data profile information, described data sheet field relevant content information to comprise typing field name, Database field name, sequence number, field problem and xls row name information.
9, the method for realization medical research data management according to claim 7, it is characterized in that, also comprise the high-level data retrieval module in the described system, this high-level data retrieval module is derived module with described database and file and all is connected, also comprise the high-level data search operaqtion in the described method, may further comprise the steps:
(51) described high-level data retrieval module is selected the data retrieved table according to user's input operation;
(52) the high-level data retrieval module carries out the logic determines that tables of data is selected;
(53) if logic determines is passed through, then the high-level data retrieval module writes down corresponding search condition according to user's input operation; Otherwise return above-mentioned steps (51);
(54) the high-level data retrieval module carries out the logic determines that search condition is selected;
(55) if logic determines is passed through, then the high-level data retrieval module produces and preserves corresponding SQL query statement according to this search condition; Otherwise return above-mentioned steps (53);
(56) the high-level data retrieval module extracts corresponding data information according to this SQL query statement and this data message is exported from database;
(57) the high-level data retrieval module is sent to file with this data message and derives module;
(58) described file is derived module and is generated the Excel file according to this data message.
According to the method for each described realization medical research data management in the claim 7 to 9, it is characterized in that 10, described Word template file is the template file of Word XML form.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CNA2009100471070A CN101499162A (en) | 2009-03-05 | 2009-03-05 | Medical research data management system and method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CNA2009100471070A CN101499162A (en) | 2009-03-05 | 2009-03-05 | Medical research data management system and method |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN101499162A true CN101499162A (en) | 2009-08-05 |
Family
ID=40946227
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CNA2009100471070A Pending CN101499162A (en) | 2009-03-05 | 2009-03-05 | Medical research data management system and method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN101499162A (en) |
Cited By (23)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102541919A (en) * | 2010-12-29 | 2012-07-04 | 王春雷 | Tibetan medicine well-known and old experts' medical skill database information system |
| CN102663136A (en) * | 2012-05-04 | 2012-09-12 | 中国科学院新疆理化技术研究所 | Method for resolving spectrum data of compound of natural product |
| CN102682035A (en) * | 2011-03-18 | 2012-09-19 | 富泰华工业（深圳）有限公司 | Data management method and system |
| CN102103573B (en) * | 2009-12-17 | 2012-10-03 | 北大方正集团有限公司 | Method and system for quickly generating files in open formats |
| CN102722769A (en) * | 2011-03-29 | 2012-10-10 | 上海凡默谷信息技术有限公司 | Experimental data processing system and method |
| CN103176992A (en) * | 2011-12-21 | 2013-06-26 | 苏州威世博知识产权服务有限公司 | Method and system for patent output |
| CN104111919A (en) * | 2013-04-16 | 2014-10-22 | 无锡南理工科技发展有限公司 | Certificate compilation method for measuring and testing service system |
| CN104346334A (en) * | 2013-07-23 | 2015-02-11 | 上海化工宝电子商务有限公司 | Remote visual interface database system |
| CN105373630A (en) * | 2015-12-18 | 2016-03-02 | 河南思维自动化设备股份有限公司 | Automatic identification and creation method for LKJ basic data filling table |
| WO2016029709A1 (en) * | 2014-08-27 | 2016-03-03 | 童云广 | Management system for processing high throughput experimental data based on network |
| CN105786932A (en) * | 2014-12-26 | 2016-07-20 | 北大医疗信息技术有限公司 | Query method and query apparatus for clinical business in medical system |
| CN106604073A (en) * | 2015-10-14 | 2017-04-26 | 北京国双科技有限公司 | Data processing method and device |
| CN107133447A (en) * | 2017-03-27 | 2017-09-05 | 牡丹江医学院 | A kind of medical research data management system and method |
| CN107220476A (en) * | 2017-04-06 | 2017-09-29 | 广州慧扬信息系统科技有限公司 | The statistical analysis system of medication effect |
| CN107480262A (en) * | 2017-08-05 | 2017-12-15 | 中山大学 | A kind of general management system of database based on webpage |
| CN107609077A (en) * | 2017-09-04 | 2018-01-19 | 中国核工业第五建设有限公司 | Wlding approaches to IM |
| CN107993692A (en) * | 2017-10-19 | 2018-05-04 | 麦迪特科技无锡有限公司 | The input of medical research data and store method |
| CN108875029A (en) * | 2018-06-22 | 2018-11-23 | 国网北京市电力公司 | Data processing method and device, storage medium and processor |
| CN109087707A (en) * | 2018-07-18 | 2018-12-25 | 上海理工大学 | It is a kind of for establishing the method and apparatus of lung image database |
| CN109273060A (en) * | 2018-09-27 | 2019-01-25 | 中国工程物理研究院材料研究所 | A kind of hydrogen isotope material database inquiry system |
| CN110928864A (en) * | 2019-11-26 | 2020-03-27 | 杭州皓智天诚信息科技有限公司 | Scientific research project management method and system |
| CN111180083A (en) * | 2019-12-31 | 2020-05-19 | 北京零研科技有限公司 | Clinical scientific research data management method and system |
| CN112182325A (en) * | 2020-09-15 | 2021-01-05 | 湖南汽车工程职业学院 | Scientific research document management method and management system applying same |
-
2009
- 2009-03-05 CN CNA2009100471070A patent/CN101499162A/en active Pending
Cited By (26)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102103573B (en) * | 2009-12-17 | 2012-10-03 | 北大方正集团有限公司 | Method and system for quickly generating files in open formats |
| CN102541919A (en) * | 2010-12-29 | 2012-07-04 | 王春雷 | Tibetan medicine well-known and old experts' medical skill database information system |
| CN102682035A (en) * | 2011-03-18 | 2012-09-19 | 富泰华工业（深圳）有限公司 | Data management method and system |
| CN102722769A (en) * | 2011-03-29 | 2012-10-10 | 上海凡默谷信息技术有限公司 | Experimental data processing system and method |
| CN103176992A (en) * | 2011-12-21 | 2013-06-26 | 苏州威世博知识产权服务有限公司 | Method and system for patent output |
| CN102663136A (en) * | 2012-05-04 | 2012-09-12 | 中国科学院新疆理化技术研究所 | Method for resolving spectrum data of compound of natural product |
| CN104111919A (en) * | 2013-04-16 | 2014-10-22 | 无锡南理工科技发展有限公司 | Certificate compilation method for measuring and testing service system |
| CN104346334A (en) * | 2013-07-23 | 2015-02-11 | 上海化工宝电子商务有限公司 | Remote visual interface database system |
| WO2016029709A1 (en) * | 2014-08-27 | 2016-03-03 | 童云广 | Management system for processing high throughput experimental data based on network |
| CN105786932A (en) * | 2014-12-26 | 2016-07-20 | 北大医疗信息技术有限公司 | Query method and query apparatus for clinical business in medical system |
| CN105786932B (en) * | 2014-12-26 | 2020-03-27 | 北大医疗信息技术有限公司 | Query method and query device for clinical business in medical system |
| CN106604073A (en) * | 2015-10-14 | 2017-04-26 | 北京国双科技有限公司 | Data processing method and device |
| CN106604073B (en) * | 2015-10-14 | 2019-12-24 | 北京国双科技有限公司 | Data processing method and device |
| CN105373630A (en) * | 2015-12-18 | 2016-03-02 | 河南思维自动化设备股份有限公司 | Automatic identification and creation method for LKJ basic data filling table |
| CN107133447A (en) * | 2017-03-27 | 2017-09-05 | 牡丹江医学院 | A kind of medical research data management system and method |
| CN107220476A (en) * | 2017-04-06 | 2017-09-29 | 广州慧扬信息系统科技有限公司 | The statistical analysis system of medication effect |
| CN107220476B (en) * | 2017-04-06 | 2020-08-11 | 广州慧扬健康科技有限公司 | Statistical analysis system for drug treatment effect |
| CN107480262A (en) * | 2017-08-05 | 2017-12-15 | 中山大学 | A kind of general management system of database based on webpage |
| CN107609077A (en) * | 2017-09-04 | 2018-01-19 | 中国核工业第五建设有限公司 | Wlding approaches to IM |
| CN107993692A (en) * | 2017-10-19 | 2018-05-04 | 麦迪特科技无锡有限公司 | The input of medical research data and store method |
| CN108875029A (en) * | 2018-06-22 | 2018-11-23 | 国网北京市电力公司 | Data processing method and device, storage medium and processor |
| CN109087707A (en) * | 2018-07-18 | 2018-12-25 | 上海理工大学 | It is a kind of for establishing the method and apparatus of lung image database |
| CN109273060A (en) * | 2018-09-27 | 2019-01-25 | 中国工程物理研究院材料研究所 | A kind of hydrogen isotope material database inquiry system |
| CN110928864A (en) * | 2019-11-26 | 2020-03-27 | 杭州皓智天诚信息科技有限公司 | Scientific research project management method and system |
| CN111180083A (en) * | 2019-12-31 | 2020-05-19 | 北京零研科技有限公司 | Clinical scientific research data management method and system |
| CN112182325A (en) * | 2020-09-15 | 2021-01-05 | 湖南汽车工程职业学院 | Scientific research document management method and management system applying same |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN101499162A (en) | Medical research data management system and method | |
| US9223817B2 (en) | Virtual repository management | |
| US7305656B2 (en) | Content management framework for use with a system for application development | |
| AU2009238294B2 (en) | Data transformation based on a technical design document | |
| US20100198778A1 (en) | Method and system for collecting and distributing user-created content within a data-warehouse-based computational system | |
| CN100449435C (en) | KBE and WEB technology based stamping design and production system | |
| CN111611458B (en) | Method for realizing system data architecture carding based on metadata and data analysis technology in big data processing | |
| US6889230B1 (en) | System and method for presenting survey data over a network | |
| US7788259B2 (en) | Locating, viewing and interacting with information sources | |
| US20110087708A1 (en) | Business object based operational reporting and analysis | |
| CN103226478A (en) | Method for automatically generating and using code | |
| US8260772B2 (en) | Apparatus and method for displaying documents relevant to the content of a website | |
| US20090199158A1 (en) | Apparatus and method for building a component to display documents relevant to the content of a website | |
| US20070282804A1 (en) | Apparatus and method for extracting database information from a report | |
| US20080263018A1 (en) | Method and System for Mapping Business Objects to Relational Database Tables | |
| US20070073765A1 (en) | Metadata-based schema generator | |
| US20050171966A1 (en) | Relational to hierarchical tree data conversion technique | |
| JP2002366401A (en) | Integral data mart structure, and operation supporting system | |
| Bai | SQL Server Database Programming with Visual Basic. NET: Concepts, Designs and Implementations | |
| Hu et al. | WebinTool: A generic Web to database interface building tool | |
| CN103092841A (en) | Method and device for processing data | |
| Novak et al. | Prototype of a Web ETL tool | |
| Shershakov | Multi-perspective process mining with embedding configurations into DB-based event logs | |
| CN111125045A (en) | Lightweight ETL processing platform | |
| Surla | Eclipse editor for MARC records |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C12 | Rejection of a patent application after its publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20090805 |