Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

A Local Database System and Its Retrieval and Update Method

A database and local technology, applied in the computer field, can solve the problems of low data retrieval efficiency, easy redundancy, and complicated updating of data.

Active Publication Date: 2015-08-19
SHANGHAI METABOLOME INST WUHAN
View PDF3 Cites 2 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

Therefore, the metabolite database faces the problem of huge data volume and easy redundancy, which leads to low data retrieval efficiency and complex update data

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • A Local Database System and Its Retrieval and Update Method
  • A Local Database System and Its Retrieval and Update Method
  • A Local Database System and Its Retrieval and Update Method

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0055] Example 1: Analyzing metabolites based on relevant 1H and 13C chemical shifts obtained from nuclear magnetic resonance spectra.

[0056] (1) Experimental materials and methods

[0057] The spectrogram was collected from the aqueous phase extract of the biological sample using a nuclear magnetic resonance spectrometer, and the 1H chemical shift of a certain group in the spectrogram was 3.54ppm, and the 13C chemical shift was 43.00ppm. Open the local database, enter the search device, enter 3.54 at the 1H chemical shift in the pop-up window, the default value is 0.02, enter 43.00 at the 13C chemical shift, the default value is 5.00, click the search button to enter the search device. First, the analysis unit analyzes the input data, and then enters the retrieval unit, and searches through the chemical shift in the merge domain.

[0058] (2) Results

[0059] Such as Figure 4 As shown, the report outputs the search results within 1 second, showing that several metabolit...

Embodiment 2

[0060] Embodiment 2: Perform data update on the local database.

[0061] (1) Experimental materials and methods

[0062] The spectrograms of the known chemical substances were collected by a nuclear magnetic resonance spectrometer, and the 1H chemical shift of a certain group in the spectrogram was 3.27ppm, and the 13C chemical shift was 38.31ppm. Open the local database, enter the retrieval device, find that there is no qualified result, enter the update device to add the data to the local database, first analyze the input data by the analysis unit, and then enter the update unit, and update the data of each sub-domain in the merge domain to multiple related data tables in the database.

[0063] (2) Results

[0064] The form outputs the update result successfully within 1 second.

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

Abstract

The invention provides a local database system and a retrieving and updating method of the local database system. The local database system comprises a local database and a retrieving and updating device. The local database comprises a metabolin nuclear magnetic resonance spectrogram information data table, a metabolin nuclear magnetic resonance spectrogram information domain processing unit and a metabolin nuclear magnetic resonance spectrogram information report form processing unit. When the local database is retrieved and updated, domains of a plurality of related data tables are combined into one domain, a query condition and update contents are input through a window, retrieving and updating are carried out in subdomains of the combined domain through an operation expression, a query result is output through a report form, and an updating result is output through the window. According to the local database system and the retrieving and updating method of the local database system, the data memory space is effectively reduced, and the retrieving efficiency is improved; the metabolin data tables do not need to be directly and repeatedly operated, the operating steps are simplified, the operating difficulty is lowered, and the updating efficiency and the data safety are improved.

Description

technical field [0001] The invention belongs to the field of computer technology, and more specifically relates to a local database system and a retrieval and update method thereof, which are mainly used for fast analysis of metabolite nuclear magnetic resonance spectra. Background technique [0002] Metabolomics is an emerging discipline born in the 1990s. The research object is small molecular metabolites with a molecular weight less than 1000 Daltons. The research methods mainly rely on nuclear magnetic resonance and chromatography-mass spectrometry. At present, the most complicated and time-consuming step in NMR-based metabolomics research is to analyze the NMR spectra of metabolites, and assign the 1H and 13C signals in the NMR spectra to the corresponding groups of metabolites. This step mainly relies on manual analysis. H-H correlation, C-H correlation COZY, TOCSY, HSQC, HMBC, and J decomposition spectra, a complete set of two-dimensional spectra, are analyzed one by ...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
Patent Type & Authority Patents(China)
IPC IPC(8): G06F17/30
CPCG06F16/2282G06F16/23G06F16/24
Inventor 喻门
Owner SHANGHAI METABOLOME INST WUHAN
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products