Web-based: A data warehouse on osteoporosis data warehouse in the osteoporosis community health information management system

Objective: To establish an interactive management model for community-oriented high-risk osteoporosis in conjunction with a rural community health service center. Materials and Methods: Toward multidimensional analysis of data, the system we developed combines basic principles of data warehouse technology oriented to the needs of community health services. This paper introduces the steps we took in constructing the data warehouse;the case presented here is that of a district community health management information system in Changshu, Jiangsu Province, China. For our data warehouse, we chose the MySQL 4.5 relational database, the Browser/Server, (B/S) model, and hypertext preprocessor as the development tools. Results: The system allowed online analysis processing and next-stage work preparation, and provided a platform for data management, data query, online analysis, etc., in community health service center, specialist outpatient for osteoporosis, and health administration sectors. Conclusion: The users of remote management system and data warehouse can include community health service centers, osteoporosis departments of hospitals, and health administration departments;provide reference for policymaking of health administrators, residents’ health information, and intervention suggestions for general practitioners in community health service centers, patients’ follow-up information for osteoporosis specialists in general hospitals.

High-quality genome assembly and pan-genome studies facilitate genetic discovery in mung bean and its improvement

Mung bean is an economically important legume crop species that is used as a food,consumed as a vegetable,and used as an ingredient and even as a medicine.To explore the genomic diversity of mung bean,we assembled a high-quality reference genome(Vrad_JL7)that was479.35 Mb in size,with a contig N50 length of 10.34 Mb.A total of 40,125 protein-coding genes were annotated,representing96.9%of the genetic region.We also sequenced 217 accessions,mainly landraces and cultivars from China,and identified 2,229,343 high-quality single-nucleotide polymorphisms(SNPs).Population structure revealed that the Chinese accessions diverged into two groups and were distinct from non-Chinese lines.Genetic diversity analysis based on genomic data from 750 accessions in 23 countries supported the hypothesis that mung bean was first domesticated in south Asia and introduced to east Asia probably through the Silk Road.We constructed the first pan-genome of mung bean germplasm and assembled 287.73 Mb of non-reference sequences.Among the genes,83.1%were core genes and 16.9%were variable.Presence/absence variation(PAV)events of nine genes involved in the regulation of the photoperiodic flowering pathway were identified as being under selection during the adaptation process to promote early flowering in the spring.Genomewide association studies(GWASs)revealed 2,912 SNPs and 259 gene PAV events associated with 33 agronomic traits,including a SNP in the coding region of the SWEET10 homolog(jg24043)involved in crude starch content and a PAV event in a large fragment containing 11 genes for color-related traits.This high-quality reference genome and pan-genome will provide insights into mung bean breeding.