Check patentability & draft patents in minutes with Patsnap Eureka AI!

Cross-database data extraction method and device, electronic equipment and storage medium

A data extraction and database technology, applied in database indexing, database management systems, structured data retrieval, etc., can solve problems such as long processing links, heavy preparation workload, and low efficiency, so as to reduce link processes and improve development efficiency effect

Pending Publication Date: 2021-03-09
CHINA LIFE INSURANCE COMPANY
View PDF0 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] The inventors have found that in the prior art, data extraction through ETL data extraction tools has at least the following defects: the preparatory workload for each extraction (data extraction) is large, and it is necessary to build some series of data tables in the merged database in advance to undertake the other tasks. The table data of the physical database; and the data needs to be merged and centralized in advance, and the processing link is long, resulting in low efficiency

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
  • Cross-database data extraction method and device, electronic equipment and storage medium
  • Cross-database data extraction method and device, electronic equipment and storage medium
  • Cross-database data extraction method and device, electronic equipment and storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment

[0068] Obtain the original withdrawal task information, for example, the original withdrawal task information input by the user is: "Retrieve the first-year regular payment information of individual insurance policies";

[0069] Feature words are extracted from the above-mentioned original withdrawal task information: "individual insurance", "policy" and "first-year regular premium";

[0070] Select the standard withdrawal task information including any one of "individual insurance", "policy" and "first-year regular premium" as the withdrawal task information to be selected;

[0071] Calculate the matching degree for each task information to be selected;

[0072] According to the order of matching degree from high to low, sort all the extraction task information to be selected, obtain the number extraction task list, and output it to the user for the user to choose;

[0073] The user selects the task to be performed. Here, it is assumed that the user selects "extract first-ye...

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

According to across-database data extraction method and device, electronic equipment and a storage medium provided by one or more embodiments of the invention, for cross-physical-library data mart associated query data extraction, automatic data merging and cross-library joint query are realized by adopting inter-database session-level associated query; data extraction and merging processes of different databases are omitted, development efficiency is improved, and link processes are reduced.

Description

technical field [0001] One or more embodiments of this specification relate to the technical field of data extraction, and in particular to a cross-database data extraction method, device, electronic device, and storage medium. Background technique [0002] At present, data extraction cannot achieve data extraction across physical databases. The conventional method is to use ETL data extraction tools to extract data from different data sources in advance, merge and summarize them into a single database, and then perform associated query processing in the single database. , export the data that meets the conditions. [0003] ETL: Extract-Transform-Load, the process of extracting, transforming, and loading data from the source to the destination. [0004] The inventors have found that in the prior art, data extraction through ETL data extraction tools has at least the following defects: the preparatory workload for each data extraction (data extraction) is large, and it is ne...

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 Applications(China)
IPC IPC(8): G06F16/22G06F16/245G06F16/248G06F16/25G06F40/279
CPCG06F16/2282G06F16/245G06F16/248G06F16/25G06F40/279
Inventor 白龙陈辰袁慧斌张锐马乐王厚玉
Owner CHINA LIFE INSURANCE COMPANY
Features
  • R&D
  • Intellectual Property
  • Life Sciences
  • Materials
  • Tech Scout
Why Patsnap Eureka
  • Unparalleled Data Quality
  • Higher Quality Content
  • 60% Fewer Hallucinations
Social media
Patsnap Eureka Blog
Learn More

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.

© 2025 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com