CN112800027A - Construction method of cynomolgus monkey data warehouse - Google Patents
Construction method of cynomolgus monkey data warehouse Download PDFInfo
- Publication number
- CN112800027A CN112800027A CN202110065067.3A CN202110065067A CN112800027A CN 112800027 A CN112800027 A CN 112800027A CN 202110065067 A CN202110065067 A CN 202110065067A CN 112800027 A CN112800027 A CN 112800027A
- Authority
- CN
- China
- Prior art keywords
- data
- cynomolgus monkey
- cynomolgus
- data acquisition
- management
- 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
- 241000282567 Macaca fascicularis Species 0.000 title claims abstract description 211
- 238000010276 construction Methods 0.000 title claims abstract description 19
- 238000007726 management method Methods 0.000 claims abstract description 87
- 238000000034 method Methods 0.000 claims abstract description 69
- 230000008569 process Effects 0.000 claims abstract description 56
- 238000009395 breeding Methods 0.000 claims abstract description 20
- 230000001488 breeding effect Effects 0.000 claims abstract description 20
- 238000004458 analytical method Methods 0.000 claims abstract description 14
- 238000007619 statistical method Methods 0.000 claims abstract description 14
- 238000013480 data collection Methods 0.000 claims description 29
- 238000003908 quality control method Methods 0.000 claims description 23
- 238000013461 design Methods 0.000 claims description 15
- 201000010099 disease Diseases 0.000 claims description 10
- 208000037265 diseases, disorders, signs and symptoms Diseases 0.000 claims description 10
- 238000011160 research Methods 0.000 claims description 10
- 238000012550 audit Methods 0.000 claims description 9
- 238000012544 monitoring process Methods 0.000 claims description 9
- 238000007405 data analysis Methods 0.000 claims description 6
- 230000010354 integration Effects 0.000 claims description 6
- 208000027889 monkey disease Diseases 0.000 claims description 6
- 238000012360 testing method Methods 0.000 claims description 4
- 230000008859 change Effects 0.000 claims description 3
- 238000000546 chi-square test Methods 0.000 claims description 3
- 238000010219 correlation analysis Methods 0.000 claims description 3
- 238000013211 curve analysis Methods 0.000 claims description 3
- 238000001914 filtration Methods 0.000 claims description 3
- 210000001503 joint Anatomy 0.000 claims description 3
- 230000007246 mechanism Effects 0.000 claims description 3
- 238000012545 processing Methods 0.000 claims description 3
- 238000000611 regression analysis Methods 0.000 claims description 3
- 238000005070 sampling Methods 0.000 claims description 3
- 230000004083 survival effect Effects 0.000 claims description 3
- 238000012353 t test Methods 0.000 claims description 3
- 238000012546 transfer Methods 0.000 claims description 3
- 238000012800 visualization Methods 0.000 claims description 3
- 238000013523 data management Methods 0.000 abstract description 2
- 241000282693 Cercopithecidae Species 0.000 description 3
- 241000700605 Viruses Species 0.000 description 2
- 238000009472 formulation Methods 0.000 description 2
- 239000000203 mixture Substances 0.000 description 2
- 238000012827 research and development Methods 0.000 description 2
- 230000007547 defect Effects 0.000 description 1
- 230000002950 deficient Effects 0.000 description 1
- 238000011161 development Methods 0.000 description 1
- 238000010586 diagram Methods 0.000 description 1
- 239000002360 explosive Substances 0.000 description 1
- 238000007689 inspection Methods 0.000 description 1
- 238000004445 quantitative analysis Methods 0.000 description 1
- 230000001360 synchronised effect Effects 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/21—Design, administration or maintenance of databases
- G06F16/211—Schema design and management
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
- G06F16/2291—User-Defined Types; Storage management thereof
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/25—Integrating or interfacing systems involving database management systems
- G06F16/254—Extract, transform and load [ETL] procedures, e.g. ETL data flows in data warehouses
Abstract
The invention discloses a method for constructing a cynomolgus monkey data warehouse, which comprises the following steps: the first stage is as follows: the existing database and the data structure are maintained unchanged, data from the existing independent information system or recorded breeding, quarantine, veterinarian and the like are integrated and merged into a unified information system, and the requirements of the existing business are met; and a second stage: after certain data are accumulated in the existing database, the construction mode of the data acquisition and data warehouse of the cynomolgus monkey is switched to the complete life cycle of feeding the cynomolgus monkey as guidance, and the existing data are completely converted into a data structure system corresponding to a new normal form. The invention establishes a complete data warehouse system of the cynomolgus monkey, and perfects the whole chain process of various data acquisition, personnel distribution, data management, sample management, data application interface, statistical analysis and omics analysis in the whole life cycle of the cynomolgus monkey from birth registration in an application form on the basis.
Description
Technical Field
The invention relates to the technical field of data warehouse construction, in particular to a cynomolgus monkey data warehouse construction method.
Background
The cynomolgus monkey database is designed from 6 months in 2018, and basic database design and webpage development are completed in 12 months. At present, the database mainly stores basic data of the cynomolgus monkey, including sex, age, appearance and the like of the monkey and the storage information of the monkey in the breeding process. The database also simply records the data related to parents of the monkeys, the data related to virus inspection and the like which can be used as scientific research data. The technical framework adopts a MySQL database, and the front end of the webpage is developed by using a PHP and Laravel framework. The early-stage research and development of the database are mainly used for meeting the scientific internal management of company specifications and meeting the management requirements; the marketing requirement in the marketing process is met; and preliminary quantitative analysis of data is realized, and the requirements of scientific research are met.
The previous research finds that the previous database design mainly aims at the use purpose of data, namely feeding, managing, selling and the like of the cynomolgus monkey, and is designed as the branch table basis of the relational database. The database currently contains 16 data fields for recording cynomolgus monkeys, wherein the number of fields related to virus test is 5, and the total data amount is 12183. The current database design can basically support the research and development of the current webpage basic functions.
However, in the general situation of data collection at present, the data fields contained in the database of the cynomolgus monkey are too few, on one hand, the data cannot be interfaced with information systems in the aspects of feeding, breeding, epidemic diseases, veterinarians and the like of the cynomolgus monkey at the data level, and the data generated by the information systems cannot be effectively collected and integrated, so that the integrity of the data collection is deficient. On the other hand, as the database is designed for use, the defects exist in the aspects of originality, objectivity, comprehensiveness and data standardization of data, and under the condition of foreseeable explosive growth of data quantity and data fields, the current design mode, namely the method of storing heterogeneous data in a sub-table mode, is difficult to bear and support the construction of a data warehouse, and also causes difficulty in searching, using and analyzing the data at the later stage. Therefore, starting from the cynomolgus monkey, the data warehouse of the cynomolgus monkey is redesigned from the perspective of pure data, and the data acquisition, management and flow control of the whole flow are carried out on each link of the cynomolgus monkey breeding, management, sale, scientific research and the like, so that the method is very important and imperative.
Disclosure of Invention
Based on the technical problems in the background art, the invention provides a cynomolgus monkey data warehouse construction method.
The invention provides a method for constructing a cynomolgus monkey data warehouse, which comprises the following steps:
s1 first stage: the existing database and the data structure are maintained unchanged, data from the existing independent information system or recorded breeding, quarantine, veterinarian and the like are integrated and merged into a unified information system, and the requirements of the existing business are met;
s2 second stage: after certain data are accumulated in the existing database, the construction mode of data acquisition and data warehouse of the cynomolgus monkey is switched to the complete life cycle of feeding the cynomolgus monkey as guidance, and the existing data are completely converted into a data structure system corresponding to a new normal form, so that the acquired data are more original, objective and standardized, and more comprehensive data types and data fields are accommodated.
Preferably, the step S1 includes 14 fields for breeding related data according to the current research situation, and generates about 300 records per month; quarantine related data has 33 fields, and about 700 records are generated each month; the veterinary related data has 21 fields, about 1500 records are generated each month, and the integration of the three parts of data effectively increases the field number and the data volume of the existing database and promotes the integration of the data of the independent information system into a unified database.
Preferably, the construction method of the cynomolgus monkey data acquisition and data warehouse of the step S2 includes an acquisition personnel and authority management system, a cynomolgus monkey registration system, a cynomolgus monkey data acquisition system, a cynomolgus monkey data quality control system, a data acquisition process management system, a data acquisition questionnaire management system, a cynomolgus monkey storage and transfer management system, and a cynomolgus monkey sample management system.
Preferably, the collection staff and the right management system: the system comprises a user and user group management module and a role and authority management module, wherein the user and user group module is a basic management module and is used for managing basic information of all users participating in data acquisition and management, including user names, mailboxes, contact ways, mechanisms, system roles, current states, passwords and the like, the user and user management module is only opened for a system administrator with platform authority and comprises functions of creating account numbers, editing account numbers, stopping account numbers, deleting account numbers and the like, the role and authority management module is a system-level user authority definition module and is responsible for defining and setting all function authorities of various roles in the system, wherein authority in the authority management module is determined according to functions in the system, new roles can be added according to specific platform use requirements, and each function authority is set.
Preferably, the cynomolgus monkey registration system uses a cynomolgus monkey as a central entry system in the data acquisition process, and is responsible for registering an individual in the system before the acquisition work of a certain cynomolgus monkey, uniquely recording the individual, optimizing the data acquisition efficiency in the subsequent data acquisition process by using an informatization means, and ensuring the accuracy of the data corresponding relationship, the data acquisition process management system is a formulation, monitoring and management system for the data acquisition process of the cynomolgus monkey, and when the data acquisition of the cynomolgus monkey is divided into a plurality of steps at a time or a large batch of cynomolgus monkeys is required to be acquired at a time, it is necessary to reasonably design the data acquisition process by the informatization means, and the set process is used for monitoring and managing the whole data acquisition process and the acquisition completion degree in the data acquisition process.
Preferably, the data collection in the data collection questionnaire management system is mainly divided into two types: one is to collect the relevant data of the cynomolgus monkey by sampling the cynomolgus monkey and using special instruments or equipment, and the other belongs to the observation class, namely, through the pre-designed collection options and the collection questionnaire at different stages in the breeding process of the cynomolgus monkey, the cynomolgus monkey is observed and data is collected, questionnaire management in the data collection questionnaire management system is divided into different types aiming at different data collection purposes, the cynomolgus monkey data collection system is a main system for collecting data of the cynomolgus monkey, the system is combined with an acquisition personnel and authority management system, a cynomolgus monkey registration system, a data acquisition process management system and a data acquisition questionnaire management system, and a data acquisition interface aiming at different platforms is designed, and the data collected by special instruments or equipment are combined to realize flexible and efficient cynomolgus monkey data collection on site.
Preferably, the quality control system for the cynomolgus monkey data is divided into two modules and is responsible for performing quality control on the collected cynomolgus monkey data, wherein one module is called a real-time quality control module and is integrated with the data collection system for the cynomolgus monkey, and the real-time quality control module performs basic quality control on the collected data in the real-time data collection process and feeds the data back to a collector in real time; the other module is called a data processing quality control module and is used for controlling and filtering the quality of data after data acquisition and before warehousing, the cynomolgus monkey store and circulation management system is combined with a cynomolgus monkey registration system, records the store and circulation information of different breeding places in the registration, breeding, quarantine and sale processes of the cynomolgus monkeys and is used for recording the change of the living environment in the life cycle of the cynomolgus monkeys and analyzing and counting the whole living condition of the cynomolgus monkeys, the cynomolgus monkey sample management system is combined with the cynomolgus monkey registration system, registers and manages the sample information acquired by the cynomolgus monkeys in the data acquisition process, associates the cynomolgus monkeys with the samples and the samples, associates the cynomolgus monkeys with the samples and the individuals, and manages the circulation and the use of the cynomolgus monkeys.
A construction method of a cynomolgus monkey data warehouse comprises the steps of developing a series of management, scientific research and industrial application related to cynomolgus monkeys around the cynomolgus monkey data warehouse MDR: the system comprises a data acquisition related KPI management system, a cynomolgus monkey data use safety audit system, a cynomolgus monkey disease early warning control system, a cynomolgus monkey data search engine and interface, a cynomolgus monkey data statistical analysis system and a cynomolgus monkey multigroup mathematical data analysis system.
Preferably, the data collection related KPI management system: one of cynomolgus monkey data warehouse applications uses KPI in the data statistics data acquisition process in MDR, including making statistics on the contribution to data acquisition process design, the contribution to data acquisition questionnaire design, the contribution to data acquisition, the contribution to data quality control, and the like, and embodies providing quantitative basis for KPI management, the data use safety audit system: and the second application of the cynomolgus monkey data warehouse is to use data in the MDR to perform safety audit on the specific data use of the cynomolgus monkey in an automatic and manual combined mode, analyze the data ethical condition and the data leakage risk related to the data use application and save the record of the use and access of all data applications, and the cynomolgus monkey disease early warning control system comprises: and thirdly, the data acquired in the MDR is used for carrying out global analysis regularly, real-time monitoring and early warning are carried out on the disease risk of each stage in the whole process of the cynomolgus monkey feeding, quarantine and sale according to set risk indexes, risk threshold values, risk scales and the like, and a disease control rapid plan is provided according to the corresponding disease risk condition.
Preferably, the cynomolgus monkey data search engine and interface: the cynomolgus monkey data warehouse is applied to design a multi-dimensional, multi-scale and multi-condition data search engine for data in the MDR, so that a user can inquire the data in the MDR from the use requirement. Meanwhile, a controlled programming access interface is designed, so that a user can conveniently obtain authorized data in batches, and the cynomolgus monkey data statistical analysis system comprises: the cynomolgus monkey data warehouse is applied to realize conventional statistical analysis functions such as t test, difference square analysis, chi square test, rank sum test, survival curve analysis, correlation analysis, regression analysis and the like, is combined with data in the MDR, and is used for carrying out online butt joint on data of the cynomolgus monkey in the MDR, defining parameters and realizing statistical analysis and visualization, and the cynomolgus monkey multi-group data analysis system comprises: and the cynomolgus monkey data warehouse is applied six times, and the basic analysis process of the cynomolgus monkey omics data is realized aiming at different omic data types and analysis purposes by combining the cynomolgus monkey sample-related omic original data and the cynomolgus monkey data in the MDR.
In the invention, the construction of the cynomolgus monkey data warehouse is divided into two stages, the first stage is to continuously collect the existing resources, enrich the data types and the field quantity in the database and provide support for the feeding, management and sale of the cynomolgus monkeys at the current stage, the second stage is to convert the design paradigm of the cynomolgus monkey data warehouse from the use purpose as the guide to the complete life cycle of the cynomolgus monkey feeding as the guide, the data collected in the first stage are comprehensively converted, synchronized and standardized to establish a complete cynomolgus monkey data warehouse system, and on the basis, the whole chain process of various data acquisition, personnel distribution, data management, sample management, data application interfaces, statistical analysis and omics analysis in the whole life cycle of the cynomolgus monkey from birth registration is perfected in an application form.
Drawings
Fig. 1 is a system block diagram of a cynomolgus monkey data warehouse construction method provided by the invention.
Detailed Description
The technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are only a part of the embodiments of the present invention, and not all of the embodiments.
Referring to fig. 1, a cynomolgus monkey data warehouse construction method includes the following steps:
s1 first stage: the existing database and the data structure are maintained unchanged, data from the existing independent information system or recorded breeding, quarantine, veterinarian and the like are integrated and merged into a unified information system, and the requirements of the existing business are met;
s2 second stage: after certain data are accumulated in the existing database, the construction mode of data acquisition and data warehouse of the cynomolgus monkey is switched to the complete life cycle of feeding the cynomolgus monkey as guidance, and the existing data are completely converted into a data structure system corresponding to a new normal form, so that the acquired data are more original, objective and standardized, and more comprehensive data types and data fields are accommodated.
In the present invention, the step S1 is to generate about 300 records per month according to the current research situation, wherein the total number of the breeding related data is 14 fields; quarantine related data has 33 fields, and about 700 records are generated each month; the veterinary related data has 21 fields, about 1500 records are generated each month, and the integration of the three parts of data effectively increases the field number and the data volume of the existing database and promotes the integration of the data of the independent information system into a unified database.
In the present invention, the construction method of the cynomolgus monkey data acquisition and data warehouse of step S2 includes an acquisition personnel and authority management system, a cynomolgus monkey registration system, a cynomolgus monkey data acquisition system, a cynomolgus monkey data quality control system, a data acquisition process management system, a data acquisition questionnaire management system, a cynomolgus monkey storage and transfer management system, and a cynomolgus monkey sample management system.
In the invention, the acquisition personnel and the authority management system: the system comprises a user and user group management module and a role and authority management module, wherein the user and user group module is a basic management module and is used for managing basic information of all users participating in data acquisition and management, including user names, mailboxes, contact ways, mechanisms, system roles, current states, passwords and the like, the user and user management module is only opened for a system administrator with platform authority and comprises functions of creating account numbers, editing account numbers, stopping account numbers, deleting account numbers and the like, the role and authority management module is a system-level user authority definition module and is responsible for defining and setting all function authorities of various roles in the system, wherein authority in the authority management module is determined according to functions in the system, new roles can be added according to specific platform use requirements, and each function authority is set.
The entrance system of the cynomolgus monkey registration system in the data acquisition process with the cynomolgus monkey as the center is responsible for registering an individual in the system before the acquisition work of a certain cynomolgus monkey, uniquely recording the individual, optimizing the data acquisition efficiency by using an informatization means in the subsequent data acquisition process and ensuring the accuracy of the data corresponding relation, the data acquisition process management system is a formulation, monitoring and management system for the data acquisition process of the cynomolgus monkey, the data acquisition of the cynomolgus monkey is divided into a plurality of steps once or a large batch of cynomolgus monkeys are acquired, the data acquisition process needs to be reasonably designed by the informatization means, and the set process is used for monitoring and managing the whole data acquisition process and the acquisition completion degree in the data acquisition process.
In the invention, the data acquisition in the data acquisition questionnaire management system is mainly divided into two types: one is to collect the relevant data of the cynomolgus monkey by sampling the cynomolgus monkey and using special instruments or equipment, and the other belongs to the observation class, namely, through the pre-designed collection options and the collection questionnaire at different stages in the breeding process of the cynomolgus monkey, the cynomolgus monkey is observed and data is collected, questionnaire management in the data collection questionnaire management system is divided into different types aiming at different data collection purposes, the cynomolgus monkey data collection system is a main system for collecting data of the cynomolgus monkey, the system is combined with an acquisition personnel and authority management system, a cynomolgus monkey registration system, a data acquisition process management system and a data acquisition questionnaire management system, and a data acquisition interface aiming at different platforms is designed, and the data collected by special instruments or equipment are combined to realize flexible and efficient cynomolgus monkey data collection on site.
In the invention, the quality control system for the cynomolgus monkey data is divided into two modules and is responsible for performing quality control on the collected cynomolgus monkey data, wherein one module is called a real-time quality control module and is integrated with the data collection system for the cynomolgus monkey, and the real-time quality control module performs basic quality control on the collected data in the real-time data collection process and feeds the data back to a collector in real time; the other module is called a data processing quality control module and is used for controlling and filtering the quality of data after data acquisition and before warehousing, the cynomolgus monkey store and circulation management system is combined with a cynomolgus monkey registration system, records the store and circulation information of different breeding places in the registration, breeding, quarantine and sale processes of the cynomolgus monkeys and is used for recording the change of the living environment in the life cycle of the cynomolgus monkeys and analyzing and counting the whole living condition of the cynomolgus monkeys, the cynomolgus monkey sample management system is combined with the cynomolgus monkey registration system, registers and manages the sample information acquired by the cynomolgus monkeys in the data acquisition process, associates the cynomolgus monkeys with the samples and the samples, associates the cynomolgus monkeys with the samples and the individuals, and manages the circulation and the use of the cynomolgus monkeys.
A construction method of a cynomolgus monkey data warehouse comprises the steps of developing a series of management, scientific research and industrial application related to cynomolgus monkeys around the cynomolgus monkey data warehouse MDR: the system comprises a data acquisition related KPI management system, a cynomolgus monkey data use safety audit system, a cynomolgus monkey disease early warning control system, a cynomolgus monkey data search engine and interface, a cynomolgus monkey data statistical analysis system and a cynomolgus monkey multigroup mathematical data analysis system.
In the invention, the data acquisition related KPI management system comprises: one of cynomolgus monkey data warehouse applications uses KPI in the data statistics data acquisition process in MDR, including making statistics on the contribution to data acquisition process design, the contribution to data acquisition questionnaire design, the contribution to data acquisition, the contribution to data quality control, and the like, and embodies providing quantitative basis for KPI management, the data use safety audit system: and the second application of the cynomolgus monkey data warehouse is to use data in the MDR to perform safety audit on the specific data use of the cynomolgus monkey in an automatic and manual combined mode, analyze the data ethical condition and the data leakage risk related to the data use application and save the record of the use and access of all data applications, and the cynomolgus monkey disease early warning control system comprises: and thirdly, the data acquired in the MDR is used for carrying out global analysis regularly, real-time monitoring and early warning are carried out on the disease risk of each stage in the whole process of the cynomolgus monkey feeding, quarantine and sale according to set risk indexes, risk threshold values, risk scales and the like, and a disease control rapid plan is provided according to the corresponding disease risk condition.
In the present invention, the cynomolgus monkey data search engine and interface: the cynomolgus monkey data warehouse is applied to design a multi-dimensional, multi-scale and multi-condition data search engine for data in the MDR, so that a user can inquire the data in the MDR from the use requirement. Meanwhile, a controlled programming access interface is designed, so that a user can conveniently obtain authorized data in batches, and the cynomolgus monkey data statistical analysis system comprises: the cynomolgus monkey data warehouse is applied to realize conventional statistical analysis functions such as t test, difference square analysis, chi square test, rank sum test, survival curve analysis, correlation analysis, regression analysis and the like, is combined with data in the MDR, and is used for carrying out online butt joint on data of the cynomolgus monkey in the MDR, defining parameters and realizing statistical analysis and visualization, and the cynomolgus monkey multi-group data analysis system comprises: and the cynomolgus monkey data warehouse is applied six times, and the basic analysis process of the cynomolgus monkey omics data is realized aiming at different omic data types and analysis purposes by combining the cynomolgus monkey sample-related omic original data and the cynomolgus monkey data in the MDR.
The invention comprises the following steps: the first stage is as follows: the existing database and the data structure are maintained unchanged, data from the existing independent information system or recorded breeding, quarantine, veterinarian and the like are integrated and merged into a unified information system, and the requirements of the existing business are met; and a second stage: after certain data are accumulated in the existing database, the construction mode of data acquisition and data warehouse of the cynomolgus monkey is switched to the complete life cycle of feeding the cynomolgus monkey as guidance, and the existing data are completely converted into a data structure system corresponding to a new normal form, so that the acquired data are more original, objective and standardized, and more comprehensive data types and data fields are accommodated.
The above description is only for the preferred embodiment of the present invention, but the scope of the present invention is not limited thereto, and any person skilled in the art should be considered to be within the technical scope of the present invention, and the technical solutions and the inventive concepts thereof according to the present invention should be equivalent or changed within the scope of the present invention.
Claims (10)
1. A cynomolgus monkey data warehouse construction method is characterized by comprising the following steps:
s1 first stage: the existing database and the data structure are maintained unchanged, data from the existing independent information system or recorded breeding, quarantine, veterinarian and the like are integrated and merged into a unified information system, and the requirements of the existing business are met;
s2 second stage: after certain data are accumulated in the existing database, the construction mode of data acquisition and data warehouse of the cynomolgus monkey is switched to the complete life cycle of feeding the cynomolgus monkey as guidance, and the existing data are completely converted into a data structure system corresponding to a new normal form, so that the acquired data are more original, objective and standardized, and more comprehensive data types and data fields are accommodated.
2. The method as claimed in claim 1, wherein the step S1 includes 14 fields for breeding related data according to the current research situation, and generates about 300 records per month; quarantine related data has 33 fields, and about 700 records are generated each month; the veterinary related data has 21 fields, about 1500 records are generated each month, and the integration of the three parts of data effectively increases the field number and the data volume of the existing database and promotes the integration of the data of the independent information system into a unified database.
3. The method for constructing a cynomolgus monkey data warehouse according to claim 1, wherein the step S2 comprises a collecting staff and authority management system, a cynomolgus monkey registration system, a cynomolgus monkey data collection system, a cynomolgus monkey data quality control system, a data collection process management system, a data collection questionnaire management system, a cynomolgus monkey storage flow transfer management system, and a cynomolgus monkey sample management system.
4. The method of claim 3, wherein the collection personnel and the rights management system: the system comprises a user and user group management module and a role and authority management module, wherein the user and user group module is a basic management module and is used for managing basic information of all users participating in data acquisition and management, including user names, mailboxes, contact ways, mechanisms, system roles, current states, passwords and the like, the user and user management module is only opened for a system administrator with platform authority and comprises functions of creating account numbers, editing account numbers, stopping account numbers, deleting account numbers and the like, the role and authority management module is a system-level user authority definition module and is responsible for defining and setting all function authorities of various roles in the system, wherein authority in the authority management module is determined according to functions in the system, new roles can be added according to specific platform use requirements, and each function authority is set.
5. The method of claim 3, wherein the database of cynomolgus monkeys is stored in a database of cynomolgus monkeys, the entrance system of the cynomolgus monkey registration system in the data acquisition process with the cynomolgus monkey as the center is responsible for registering an individual in the system before the acquisition work of a certain cynomolgus monkey, uniquely recording the individual, and optimizes the data acquisition efficiency by using an informatization means in the subsequent data acquisition process, and the accuracy of the corresponding relation of the data is ensured, the data acquisition process management system is a system for formulating, monitoring and managing the data acquisition process of the cynomolgus monkey, when the data acquisition of the cynomolgus monkey is divided into a plurality of steps once or a large amount of cynomolgus monkeys are required to be acquired at one time, the data acquisition flow needs to be reasonably designed by an informatization means, and the set flow is used for monitoring and managing the whole data acquisition process and the acquisition completion degree in the data acquisition process.
6. The method for constructing a cynomolgus monkey data warehouse according to claim 3, wherein the data collection in the data collection questionnaire management system is mainly divided into two types: one is to collect the relevant data of the cynomolgus monkey by sampling the cynomolgus monkey and using special instruments or equipment, and the other belongs to the observation class, namely, through the pre-designed collection options and the collection questionnaire at different stages in the breeding process of the cynomolgus monkey, the cynomolgus monkey is observed and data is collected, questionnaire management in the data collection questionnaire management system is divided into different types aiming at different data collection purposes, the cynomolgus monkey data collection system is a main system for collecting data of the cynomolgus monkey, the system is combined with an acquisition personnel and authority management system, a cynomolgus monkey registration system, a data acquisition process management system and a data acquisition questionnaire management system, and a data acquisition interface aiming at different platforms is designed, and the data collected by special instruments or equipment are combined to realize flexible and efficient cynomolgus monkey data collection on site.
7. The method for constructing the cynomolgus monkey data warehouse according to claim 3, wherein the cynomolgus monkey data quality control system is divided into two modules, which are responsible for performing quality control on the collected cynomolgus monkey data, one of the modules is called as a real-time quality control module, is integrated with the cynomolgus monkey data collection system, performs basic quality control on the collected data in the real-time data collection process, and feeds back the data to a collector in real time; the other module is called a data processing quality control module and is used for controlling and filtering the quality of data after data acquisition and before warehousing, the cynomolgus monkey store and circulation management system is combined with a cynomolgus monkey registration system, records the store and circulation information of different breeding places in the registration, breeding, quarantine and sale processes of the cynomolgus monkeys and is used for recording the change of the living environment in the life cycle of the cynomolgus monkeys and analyzing and counting the whole living condition of the cynomolgus monkeys, the cynomolgus monkey sample management system is combined with the cynomolgus monkey registration system, registers and manages the sample information acquired by the cynomolgus monkeys in the data acquisition process, associates the cynomolgus monkeys with the samples and the samples, associates the cynomolgus monkeys with the samples and the individuals, and manages the circulation and the use of the cynomolgus monkeys.
8. The method of claim 1, comprising a cynomolgus monkey data warehouse MDR, wherein the cynomolgus monkey data warehouse MDR is used for carrying out a series of management, scientific research and industrial applications related to cynomolgus monkeys: the system comprises a data acquisition related KPI management system, a cynomolgus monkey data use safety audit system, a cynomolgus monkey disease early warning control system, a cynomolgus monkey data search engine and interface, a cynomolgus monkey data statistical analysis system and a cynomolgus monkey multigroup mathematical data analysis system.
9. The method of claim 8, wherein the data collection-related KPI management system: one of cynomolgus monkey data warehouse applications uses KPI in the data statistics data acquisition process in MDR, including making statistics on the contribution to data acquisition process design, the contribution to data acquisition questionnaire design, the contribution to data acquisition, the contribution to data quality control, and the like, and embodies providing quantitative basis for KPI management, the data use safety audit system: and the second application of the cynomolgus monkey data warehouse is to use data in the MDR to perform safety audit on the specific data use of the cynomolgus monkey in an automatic and manual combined mode, analyze the data ethical condition and the data leakage risk related to the data use application and save the record of the use and access of all data applications, and the cynomolgus monkey disease early warning control system comprises: and thirdly, the data acquired in the MDR is used for carrying out global analysis regularly, real-time monitoring and early warning are carried out on the disease risk of each stage in the whole process of the cynomolgus monkey feeding, quarantine and sale according to set risk indexes, risk threshold values, risk scales and the like, and a disease control rapid plan is provided according to the corresponding disease risk condition.
10. The method of claim 8, wherein the cynomolgus monkey data search engine and interface: the cynomolgus monkey data warehouse is applied to design a multi-dimensional, multi-scale and multi-condition data search engine for data in the MDR, so that a user can inquire the data in the MDR from the use requirement. Meanwhile, a controlled programming access interface is designed, so that a user can conveniently obtain authorized data in batches, and the cynomolgus monkey data statistical analysis system comprises: the cynomolgus monkey data warehouse is applied to realize conventional statistical analysis functions such as t test, difference square analysis, chi square test, rank sum test, survival curve analysis, correlation analysis, regression analysis and the like, is combined with data in the MDR, and is used for carrying out online butt joint on data of the cynomolgus monkey in the MDR, defining parameters and realizing statistical analysis and visualization, and the cynomolgus monkey multi-group data analysis system comprises: and the cynomolgus monkey data warehouse is applied six times, and the basic analysis process of the cynomolgus monkey omics data is realized aiming at different omic data types and analysis purposes by combining the cynomolgus monkey sample-related omic original data and the cynomolgus monkey data in the MDR.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110065067.3A CN112800027A (en) | 2021-01-18 | 2021-01-18 | Construction method of cynomolgus monkey data warehouse |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110065067.3A CN112800027A (en) | 2021-01-18 | 2021-01-18 | Construction method of cynomolgus monkey data warehouse |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN112800027A true CN112800027A (en) | 2021-05-14 |
Family
ID=75810241
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202110065067.3A Pending CN112800027A (en) | 2021-01-18 | 2021-01-18 | Construction method of cynomolgus monkey data warehouse |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112800027A (en) |
Citations (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101136101A (en) * | 2007-04-02 | 2008-03-05 | 四川亚元防伪科技有限公司 | 'Amount-checking invoice-control, invoice-checking tax-controlling' 'data greatly tracking' tax controlling method, system constructing and operation method |
| CN102054025A (en) * | 2010-12-01 | 2011-05-11 | 北京中交通信科技有限公司 | Traffic information resource integration processing method and system |
| CN102968699A (en) * | 2012-12-12 | 2013-03-13 | 贵州电网公司六盘水供电局 | Power network planning collection data platform |
| CN103793399A (en) * | 2012-10-31 | 2014-05-14 | 北京航天长峰科技工业集团有限公司 | Method for integrating information resources of system of politics and law |
| CN104574196A (en) * | 2013-10-21 | 2015-04-29 | 中国农业科学院作物科学研究所 | Automatic field data acquisition management system for crops |
| CN106056292A (en) * | 2016-06-03 | 2016-10-26 | 武汉铁锚焊接材料股份有限公司 | Business operation intelligent decision support system and method thereof |
| CN109410110A (en) * | 2018-10-22 | 2019-03-01 | 上海市疾病预防控制中心 | The system of public health data interaction control is realized in regional health information platform |
| CN110232098A (en) * | 2019-04-22 | 2019-09-13 | 汇通达网络股份有限公司 | A kind of data warehouse administered based on data and genetic connection designs |
| CN110415831A (en) * | 2019-07-18 | 2019-11-05 | 天宜(天津)信息科技有限公司 | A kind of medical treatment big data cloud service analysis platform |
-
2021
- 2021-01-18 CN CN202110065067.3A patent/CN112800027A/en active Pending
Patent Citations (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101136101A (en) * | 2007-04-02 | 2008-03-05 | 四川亚元防伪科技有限公司 | 'Amount-checking invoice-control, invoice-checking tax-controlling' 'data greatly tracking' tax controlling method, system constructing and operation method |
| CN102054025A (en) * | 2010-12-01 | 2011-05-11 | 北京中交通信科技有限公司 | Traffic information resource integration processing method and system |
| CN103793399A (en) * | 2012-10-31 | 2014-05-14 | 北京航天长峰科技工业集团有限公司 | Method for integrating information resources of system of politics and law |
| CN102968699A (en) * | 2012-12-12 | 2013-03-13 | 贵州电网公司六盘水供电局 | Power network planning collection data platform |
| CN104574196A (en) * | 2013-10-21 | 2015-04-29 | 中国农业科学院作物科学研究所 | Automatic field data acquisition management system for crops |
| CN106056292A (en) * | 2016-06-03 | 2016-10-26 | 武汉铁锚焊接材料股份有限公司 | Business operation intelligent decision support system and method thereof |
| CN109410110A (en) * | 2018-10-22 | 2019-03-01 | 上海市疾病预防控制中心 | The system of public health data interaction control is realized in regional health information platform |
| CN110232098A (en) * | 2019-04-22 | 2019-09-13 | 汇通达网络股份有限公司 | A kind of data warehouse administered based on data and genetic connection designs |
| CN110415831A (en) * | 2019-07-18 | 2019-11-05 | 天宜(天津)信息科技有限公司 | A kind of medical treatment big data cloud service analysis platform |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN107609835B (en) | Power grid manpower configuration application system and method | |
| CN111611458B (en) | Method for realizing system data architecture carding based on metadata and data analysis technology in big data processing | |
| CN111916161B (en) | Method and device for collecting and converting multiple data sources in clinical test process | |
| CN104966172A (en) | Large data visualization analysis and processing system for enterprise operation data analysis | |
| CN108538340A (en) | A kind of system and method for Visual Interactive clinical test and Clinical Follow-up | |
| CN111695836B (en) | Clinical trial online operation management and control integrated system | |
| CN102385667A (en) | On-site epidemiology intelligent investigation system | |
| CN115458140A (en) | Internet hospital intelligent operation system based on medical big data | |
| CN106096812A (en) | A kind of hospital care quality examination management system and method | |
| CN111063444A (en) | Excel VBA-based death cause monitoring data analysis method | |
| CN114038524A (en) | Medical satisfaction monitoring system and method based on intelligent questionnaire survey | |
| CN113871025A (en) | Dermatological clinical special disease database construction method and system | |
| CN112800027A (en) | Construction method of cynomolgus monkey data warehouse | |
| Hadzhikoleva et al. | Conceptual Model of a Quality Assurance System in Higher Education | |
| CN111739594A (en) | Method and system for acquiring clinical scientific research data | |
| Hu | Research on monitoring system of daily statistical indexes through big data | |
| CN109242431A (en) | A kind of enterprise management method and its system based on data system | |
| Standridge | The Simulation Data Language (Sdl™) Applications and Examples | |
| CN112926882A (en) | Full life cycle medical equipment intelligent performance management analysis method and system | |
| CN111861223A (en) | GLP laboratory information management system | |
| CN111401776A (en) | Public health service quality control method and system | |
| CN112270619A (en) | Intelligent lean overhaul management system for power transformation equipment based on big data | |
| Morris | The epidemiological approach to animal health—building on strong foundations | |
| Himami et al. | Utilization of Data Warehouse in Business Intelligence with Kimball Method at Company XYZ | |
| Silva et al. | Evaluation of the National Immunization Program Surveillance System-Vaccination Record Module, Brazil, 2017 |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20210514 |