CN113868480A - Graph database-based agricultural breeding management system and method - Google Patents

Graph database-based agricultural breeding management system and method Download PDF

Info

Publication number
CN113868480A
CN113868480A CN202111165821.7A CN202111165821A CN113868480A CN 113868480 A CN113868480 A CN 113868480A CN 202111165821 A CN202111165821 A CN 202111165821A CN 113868480 A CN113868480 A CN 113868480A
Authority
CN
China
Prior art keywords
crops
graph database
breeding
information
crop
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
Application number
CN202111165821.7A
Other languages
Chinese (zh)
Inventor
张晨
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Zhejiang Create Link Technology Co ltd
Original Assignee
Zhejiang Create Link Technology Co ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Zhejiang Create Link Technology Co ltd filed Critical Zhejiang Create Link Technology Co ltd
Priority to CN202111165821.7A priority Critical patent/CN113868480A/en
Publication of CN113868480A publication Critical patent/CN113868480A/en
Pending legal-status Critical Current

Links

Images

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/90Details of database functions independent of the retrieved data types
    • G06F16/901Indexing; Data structures therefor; Storage structures
    • G06F16/9024Graphs; Linked lists
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/90Details of database functions independent of the retrieved data types
    • G06F16/903Querying
    • G06F16/90335Query processing
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q50/00Information and communication technology [ICT] specially adapted for implementation of business processes of specific business sectors, e.g. utilities or tourism
    • G06Q50/02Agriculture; Fishing; Forestry; Mining

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Databases & Information Systems (AREA)
  • Physics & Mathematics (AREA)
  • General Physics & Mathematics (AREA)
  • Business, Economics & Management (AREA)
  • Data Mining & Analysis (AREA)
  • General Engineering & Computer Science (AREA)
  • Marine Sciences & Fisheries (AREA)
  • General Health & Medical Sciences (AREA)
  • Agronomy & Crop Science (AREA)
  • Animal Husbandry (AREA)
  • Software Systems (AREA)
  • Mining & Mineral Resources (AREA)
  • Computational Linguistics (AREA)
  • Health & Medical Sciences (AREA)
  • Economics (AREA)
  • Life Sciences & Earth Sciences (AREA)
  • Human Resources & Organizations (AREA)
  • Marketing (AREA)
  • Primary Health Care (AREA)
  • Strategic Management (AREA)
  • Tourism & Hospitality (AREA)
  • General Business, Economics & Management (AREA)
  • Management, Administration, Business Operations System, And Electronic Commerce (AREA)

Abstract

The embodiment of the invention discloses an agricultural breeding management system and method based on a graph database, wherein the system comprises a sample data module, a data storage module and a data processing module, wherein the sample data module is used for acquiring breeding data generated in each breeding period in the agricultural breeding process; a graph data module for constructing a graph database from the breeding data; the interaction module is used for acquiring query information, transmitting the query information to the graph database for querying, and displaying the fed-back query result; the beneficial effects are as follows: a graph database of agricultural breeding is formed according to information of crops, planting places, characters and the like, and full-dimension presentation is carried out on parental relations among the crops, storage and planting conditions of the crops, so that an expert of the agricultural breeding can know the association condition of each seed and each crop more quickly, conveniently and comprehensively, the problem of mass data association query is solved, and the efficiency of the agricultural breeding is improved.

Description

Graph database-based agricultural breeding management system and method
Technical Field
The invention relates to the technical field of agricultural breeding, in particular to a graph database-based agricultural breeding management system and method.
Background
As more and more people leave the rural areas and come to cities, more and more land is changed into urban use, and the cultivated land area and the population engaged in agriculture are reduced. Therefore, in addition to maintaining the strictest red line of cultivated land, agricultural breeding techniques should be vigorously developed in the method for guaranteeing the grain yield.
Modern agricultural breeding technology, whether in college laboratories or corporate laboratories, works around the breeding cycle. Researchers in agricultural breeding select two parents with desirable traits to cross, and each breeding cycle will produce hundreds of thousands or even millions of offspring. Although plants with only specific desirable traits are selected in each cycle and pollinated to each other to drive on to the next breeding cycle, the data accumulated over decades and the large amount of new data per year still leaves agricultural breeding researchers very painful.
The data contains a large number of genetic, trait, parent-offspring and other association relations, in addition, seeds need to be stored in different warehouses and planted in different planting places in the breeding process, and the performance of the traditional relational database is challenged by the deep association query requirement of the large number of data. The relational database used in the prior art needs to establish and associate dozens of tables and scan and traverse billions of rows of data, so that the query efficiency is very low, and related personnel can not conveniently and quickly, conveniently and comprehensively know the association condition of each seed and each crop; therefore, the problem of correlation query of mass data in the agricultural breeding process is urgently needed to be solved.
Disclosure of Invention
The invention aims to: the graph database-based agricultural breeding management system and method are convenient for relevant personnel to quickly, conveniently and comprehensively know the association condition of breeding data.
In a first aspect: a graph database-based agricultural breeding management system, comprising:
the sample data module is used for acquiring breeding data generated in each breeding cycle in the agricultural breeding process; wherein the breeding data comprises basic information of the crops, parent-offspring information of the crops and trait information of the crops;
a graph data module for constructing a graph database from the breeding data; wherein, crops and characters are used as vertexes, and the character of each generation of crops and the corresponding cultivation are used as sides;
and the interaction module is used for acquiring query information, transmitting the query information to the graph database for querying, and displaying the fed-back query result.
Preferably, the basic information of the crop includes a crop number;
the parent-offspring information of the crops comprises maternal crops and parental crops;
the trait information possessed by the crop includes a trait name possessed by each generation of crop.
Preferably, when the point type is a crop, the corresponding attribute is a crop number;
when the point type is a property, the corresponding attribute is a property name.
Preferably, when the edge type is cultivation, the corresponding starting point type and the corresponding ending point type are both crops;
the edge type is a certain type, the corresponding starting point type is crops, and the ending point type is characters.
Preferably, the graph database employs a graph query language.
In a second aspect: a graph database-based agricultural breeding management method applied to the graph database-based agricultural breeding management system according to the first aspect, the method comprising:
obtaining breeding data generated in each breeding period in the agricultural breeding process; wherein the breeding data comprises basic information of the crops, parent-offspring information of the crops and trait information of the crops;
constructing a graph database according to the breeding data; wherein, crops and characters are used as vertexes, and the character of each generation of crops and the corresponding cultivation are used as sides;
and acquiring query information, transmitting the query information to the graph database for querying, and displaying the fed-back query result.
Preferably, the basic information of the crop includes a crop number;
the parent-offspring information of the crops comprises maternal crops and parental crops;
the trait information possessed by the crop includes a trait name possessed by each generation of crop.
Preferably, when the point type is a crop, the corresponding attribute is a crop number;
when the point type is a property, the corresponding attribute is a property name.
Preferably, when the edge type is cultivation, the corresponding starting point type and the corresponding ending point type are both crops;
the edge type is a certain type, the corresponding starting point type is crops, and the ending point type is characters.
Preferably, the graph database employs a graph query language.
By adopting the technical scheme, the method has the following advantages: according to the agricultural breeding management system and method based on the graph database, the graph database of agricultural breeding is formed according to the information of crops, planting places, properties and the like, and the whole-dimension presentation is carried out on the parental relation between the crops and the storage and planting conditions of the crops, so that an agricultural breeding expert can know the association condition of each seed and each crop more quickly, more conveniently and more comprehensively, the problem of mass data association query is solved, and the agricultural breeding efficiency is improved.
Drawings
FIG. 1 is a system block diagram of a graph database based agricultural breeding management system provided by an embodiment of the present invention;
FIG. 2 is a schematic diagram of a model of a graph database according to an embodiment of the present invention;
FIG. 3 is a schematic diagram illustrating results of a crop query according to an embodiment of the present invention;
FIG. 4 is a schematic diagram of a paternity relationship of a crop screened for drought resistance provided by an embodiment of the present invention;
FIG. 5 is a schematic diagram of the paternity pathway of FIG. 4 that stabilizes the inherited drought resistance trait;
FIG. 6 is a flowchart of a graph database based agricultural breeding management method according to an embodiment of the present invention.
Detailed Description
Specific embodiments of the present invention will be described in detail below, and it should be noted that the embodiments described herein are only for illustration and are not intended to limit the present invention. In the following description, numerous specific details are set forth in order to provide a thorough understanding of the present invention. However, it will be apparent to one of ordinary skill in the art that: it is not necessary to employ these specific details to practice the present invention. In other instances, well-known circuits, software, or methods have not been described in detail so as not to obscure the present invention.
Throughout the specification, reference to "one embodiment," "an embodiment," "one example," or "an example" means: the particular features, structures, or characteristics described in connection with the embodiment or example are included in at least one embodiment of the invention. Thus, the appearances of the phrases "in one embodiment," "in an embodiment," "one example" or "an example" in various places throughout this specification are not necessarily all referring to the same embodiment or example. Furthermore, the particular features, structures, or characteristics may be combined in any suitable combination and/or sub-combination in one or more embodiments or examples. Further, those of ordinary skill in the art will appreciate that the illustrations provided herein are for illustrative purposes and are not necessarily drawn to scale.
The present invention will be described in detail below with reference to the accompanying drawings.
Referring to fig. 1 and fig. 2, an embodiment of the present invention provides a graph database-based agricultural breeding management system, including:
the sample data module is used for acquiring breeding data generated in each breeding cycle in the agricultural breeding process; wherein the breeding data comprises basic information of the crops, parent-offspring information of the crops and trait information of the crops.
Specifically, the generated breeding data is constructed into a sample data set, the scale of which is: the sample data set comprises 5 generation cultivation relations of 26 seeds and information of whether the seeds have properties of drought resistance, disease resistance, insect resistance and the like; wherein:
the basic information of the crops comprises crop numbers;
the parent-offspring information of the crops comprises maternal crops and parental crops;
the trait information possessed by the crop includes a trait name and a number possessed by each generation of the crop.
A graph data module for constructing a graph database from the breeding data; wherein the crop and the trait are taken as vertexes, and the trait of each generation of crop and the corresponding cultivation are taken as sides.
Specifically, referring to table 1, when the point type is a crop, the corresponding attribute is a crop number; when the point type is a property, the corresponding attribute is a property name.
TABLE 1
Dot type Properties
Crops Crop number
Traits Name of property
Correspondingly, referring to table 2, when the edge type is cultivation, the corresponding starting point type and ending point type are both crops;
the edge type is a certain type, the corresponding starting point type is crops, and the ending point type is characters.
TABLE 2
Type of starting point Edge type Type of end point Properties
Crops Cultivation of Crops /
Crops Has the advantages of Traits /
And the interaction module is used for acquiring query information, transmitting the query information to the graph database for querying, and displaying the fed-back query result.
Specifically, when the method is applied, graph query languages such as Cypher and Gremlin adopted by the graph database can concentrate dozens of associated queries of the original relational database into one, so that the code amount is reduced by 90%, and the development efficiency of developers is greatly improved.
Further, in order to better understand the present solution, specific service requirements are exemplified below.
The service appeal is 1:
based on the atlas (namely graph database) of agricultural breeding, scientific research personnel can quickly inquire all filial generation information cultivated by the female parent, visually display the breeding condition of the female parent and assist the quick agricultural breeding work.
And (3) query description:
all progeny crops of crop number 01 were quickly queried.
Inquiring crops with the crop number of 01;
and (3) taking the crop with the number of 01 as a starting point, inquiring at most 10 hops while cultivating, and returning all crop information and cultivation relations.
And (3) query statement:
// query for progeny crop grown from crop numbered 01
MATCH p ═ n (crop { crop number: "seed 01" }) - [ r: cultivation 1..10] - > (n1: crop)
V/returning all crop information and cultivation relations
RETURN p
The query results are shown in FIG. 3, which shows that seed 01 has been stably bred for 3 generations.
And (3) service appeal 2:
agricultural breeding work needs to produce seeds with stable hereditary characters, researchers can customize configuration rules based on maps of agricultural breeding, the seeds with stable hereditary drought characters can be screened out from complex cultivation relations, agricultural workers in drought environments are helped to improve grain yield, and screening results are shown in fig. 4.
And (3) query description:
tracing upward from each seed, and finding a breeding link with more than 3 generations of female parents;
further screening the screened links, and screening paths with drought resistance characters for more than 3 generations from the most filial generation of the links;
and returning the path meeting the condition.
And (3) query statement:
over 3 generations cultivation female parent of traceable crops
MATCH p ═ (n: crops) <- [ r 1. ] 3 [ - (m: crops)
Screening a path with a drought-resistant character in more than 3 successive generations from the source tracing of filial generations
WHERE ALL (x IN NODES (p) WHERE (x) - (: Property { Property name: "drought-resistant" })) AND NOT (n) - - > (: crop)
// returning incubation paths that satisfy conditions
RETURN p
As can be seen from fig. 5, the breeding link of the seeds 03-05-15-17-19 has more than three generations of stable genetic drought-resistant property capabilities, and the same batch of seeds of the most filial generation seeds can be sold to drought regions as drought-resistant seeds, so that the local seed yield is increased.
By adopting the scheme, the graph database of agricultural breeding is formed according to the information of crops, planting places, characters and the like, and the full-dimension presentation is carried out on the parental relation among the crops and the storage and planting conditions of the crops, so that an agricultural breeding expert can know the association condition of each seed and each crop more quickly, more conveniently and more comprehensively, the problem of mass data association query is solved, and the efficiency of agricultural breeding is improved.
Based on the inventive concept of the system, referring to fig. 6, an embodiment of the present invention further provides a graph database-based agricultural breeding management method, applied to the graph database-based agricultural breeding management system, where the method includes:
s101, obtaining breeding data generated in each breeding period in the agricultural breeding process; wherein the breeding data comprises basic information of the crops, parent-offspring information of the crops and trait information of the crops.
Specifically, the generated breeding data is constructed into a sample data set, and the contents specifically comprise:
the basic information of the crops comprises crop numbers;
the parent-offspring information of the crops comprises maternal crops and parental crops;
the trait information possessed by the crop includes a trait name and a number possessed by each generation of the crop.
S102, constructing a database according to the breeding data; wherein the crop and the trait are taken as vertexes, and the trait of each generation of crop and the corresponding cultivation are taken as sides.
Specifically, when the point type is a crop, the corresponding attribute is a crop number;
when the point type is a property, the corresponding attribute is a property name.
Correspondingly, when the side type is cultivation, the corresponding starting point type and the corresponding ending point type are both crops;
the edge type is a certain type, the corresponding starting point type is crops, and the ending point type is characters.
S103, acquiring query information, transmitting the query information to the graph database for querying, and displaying the fed-back query result.
Specifically, when the method is applied, graph query languages such as Cypher and Gremlin adopted by the graph database can concentrate dozens of associated queries of the original relational database into one, so that the code amount is reduced by 90%, and the development efficiency of developers is greatly improved.
It should be noted that, for more specific working processes and examples of the method, please refer to the foregoing system embodiment, which is not described herein again.
By adopting the method, the constructed graph database is utilized to perform full-dimensional presentation on the parental relation among the crops and the storage and planting conditions of the crops, so that an agricultural breeding expert can more quickly, conveniently and comprehensively know the association condition of each seed and each crop, the problem of mass data association query is solved, and the agricultural breeding efficiency is improved.
Finally, it should be noted that: the above embodiments are only used to illustrate the technical solution of the present invention, and not to limit the same; while the invention has been described in detail and with reference to the foregoing embodiments, it will be understood by those skilled in the art that: the technical solutions described in the foregoing embodiments may still be modified, or some or all of the technical features may be equivalently replaced; such modifications and substitutions do not depart from the spirit and scope of the present invention, and they should be construed as being included in the following claims and description.

Claims (10)

1. A graph database-based agricultural breeding management system is characterized in that: the method comprises the following steps:
the sample data module is used for acquiring breeding data generated in each breeding cycle in the agricultural breeding process; wherein the breeding data comprises basic information of the crops, parent-offspring information of the crops and trait information of the crops;
a graph data module for constructing a graph database from the breeding data; wherein, crops and characters are used as vertexes, and the character of each generation of crops and the corresponding cultivation are used as sides;
and the interaction module is used for acquiring query information, transmitting the query information to the graph database for querying, and displaying the fed-back query result.
2. A graph database based agricultural breeding management system according to claim 1, wherein: the basic information of the crops comprises crop numbers;
the parent-offspring information of the crops comprises maternal crops and parental crops;
the trait information possessed by the crop includes a trait name possessed by each generation of crop.
3. A graph database based agricultural breeding management system according to claim 1, wherein: when the point type is a crop, the corresponding attribute is a crop number;
when the point type is a property, the corresponding attribute is a property name.
4. A graph database based agricultural breeding management system according to claim 1, wherein: when the side type is cultivation, the corresponding starting point type and the ending point type are both crops;
the edge type is a certain type, the corresponding starting point type is crops, and the ending point type is characters.
5. A graph database based agricultural breeding management system according to any of claims 1 to 4, wherein: the graph database employs a graph query language.
6. A graph database-based agricultural breeding management method is characterized in that: a graph database based agricultural breeding management system for use according to claim 1, said method comprising:
obtaining breeding data generated in each breeding period in the agricultural breeding process; wherein the breeding data comprises basic information of the crops, parent-offspring information of the crops and trait information of the crops;
constructing a graph database according to the breeding data; wherein, crops and characters are used as vertexes, and the character of each generation of crops and the corresponding cultivation are used as sides;
and acquiring query information, transmitting the query information to the graph database for querying, and displaying the fed-back query result.
7. A graph database based agricultural breeding management method according to claim 6, characterized in that: the basic information of the crops comprises crop numbers;
the parent-offspring information of the crops comprises maternal crops and parental crops;
the trait information possessed by the crop includes a trait name possessed by each generation of crop.
8. A game synchronization method according to claim 7, wherein: when the point type is a crop, the corresponding attribute is a crop number;
when the point type is a property, the corresponding attribute is a property name.
9. A graph database based agricultural breeding management method according to claim 7 or 8, wherein: when the side type is cultivation, the corresponding starting point type and the ending point type are both crops;
the edge type is a certain type, the corresponding starting point type is crops, and the ending point type is characters.
10. A graph database based agricultural breeding management method according to claim 9, characterized by: the graph database employs a graph query language.
CN202111165821.7A 2021-09-30 2021-09-30 Graph database-based agricultural breeding management system and method Pending CN113868480A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202111165821.7A CN113868480A (en) 2021-09-30 2021-09-30 Graph database-based agricultural breeding management system and method

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202111165821.7A CN113868480A (en) 2021-09-30 2021-09-30 Graph database-based agricultural breeding management system and method

Publications (1)

Publication Number Publication Date
CN113868480A true CN113868480A (en) 2021-12-31

Family

ID=79001514

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202111165821.7A Pending CN113868480A (en) 2021-09-30 2021-09-30 Graph database-based agricultural breeding management system and method

Country Status (1)

Country Link
CN (1) CN113868480A (en)

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN115131042A (en) * 2022-07-22 2022-09-30 华智生物技术有限公司 Biotechnological product tracing method and system

Cited By (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN115131042A (en) * 2022-07-22 2022-09-30 华智生物技术有限公司 Biotechnological product tracing method and system
CN115131042B (en) * 2022-07-22 2023-10-24 华智生物技术有限公司 Biotechnological product tracing method and system

Similar Documents

Publication Publication Date Title
Smith et al. Field assessment of avocado rootstock selections for resistance to Phytophthora root rot
CN113868480A (en) Graph database-based agricultural breeding management system and method
CN111949828A (en) Automatic construction method of rice cultivation mode knowledge graph facing semi-structured form
CN1085040C (en) Distant hybridization and breeding method for cotton
Byrne et al. Survey of the rose community: desired rose traits and research issues
Agarwal et al. A socioeconomic study on pros and cons of SRI method of paddy cultivation in Ormanjhi block of Ranchi district, Jharkhand, India
CN105426458A (en) Weed identification and prevention and control information consultation system and weed information query method
Gaaliche et al. Shoot architecture and morphology of different branch orders in fig tree (Ficus carica L.)
CN113947269A (en) Planting management method and device based on crop ecological planting database
Silva et al. Temporal variation and spatial distribution of the pest insect Edessa meditabunda in cotton (Gossypium hirsutum) as an alternative host plant
Gibson et al. Identifying indoor plant propagation research and education needs of specialty crop growers
Paine et al. Constraints perceived by the vegetable growers towards excessive use of chemicals in Bankura district of West Bengal
Schmid et al. Ecological intensification of agriculture through biodiversity management: introduction
Plucknett Prospects of meeting future food needs through new technology
SEKLOKA et al. Phenological, morphological and agronomic characterization of sixteen genotypes of cotton plant (Gossypium hirsutum L.) in rainfed condition in Benin
CN116597896A (en) Genetic analysis system and method applied to agricultural breeding
Dimelu Involvement of Farm Households in Banana and Plantain Production in Aguata Agricultural Zone of Anambra State, Nigeria.
Ilić et al. Productivity assessment of common bean (Phaseolus vulgaris) germplasm from Serbia
Narcisse et al. Contribution to the construction of an ontology for the phytosanitary surveillance of cotton in Côte d'Ivoire
Quamruzzaman et al. Genetic Diversity and Variability of Eggplant in Bangladesh
Rubauskis et al. Performance of apple orchard systems in the Nordic climate
Habib et al. Data modelling for database design in apple production monitoring systems for a producer organization
Bala et al. Adoption gap in the improved maize technology
Gaede et al. Integrating perennial staple food crops in agroforestry systems: A case study of chestnut (Castanea sp.) in Germany
Haq et al. Trouble in the rice field: Distribution ecology and indicator value of weed species in the rice fields of Himalayan region

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