Multi-source database global search method and system

A global search and database technology, applied in the field of data search, can solve problems such as difficulty in global search, differences in understanding business fields, and prone to hand errors, etc., to achieve the effect of reducing manual configuration and improving work efficiency and accuracy

Pending Publication Date: 2020-11-10
山东合天智汇信息技术有限公司
View PDF0 Cites 5 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0005] (1) Data sources are diversified, whether they are collected from the Internet or from other manufacturers, or internal data provided by an organization or department. Each data source may provide dozens or hundreds of tables of data, but their data The structure is completely different and the meaning of the business fields is also independent. Manual comparison of hundreds of classification tables is not only time-consuming and labor-intensive, but also has some differences in the understanding of the business fields.
[0006] (2) In the case of multi-source data sources, it is necessary to ensure that the original data struct

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
  • Multi-source database global search method and system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0039] refer to figure 1 , a multi-source database global search method of the present embodiment, which includes:

[0040] S101: Summarize table fields in the multi-source database and write them into a database dictionary table for field management.

[0041] Specifically, in order to ensure that the original table structure in the original database will not be damaged, the table fields in the multi-source database are written into a database dictionary table field_dic for field management; this table covers the structure and Unstructured data storage structure, the dictionary table (field_dic) contains the main key business fields such as the original database table name, field name, field meaning, field type, field identification (whether the primary key), data table source, etc.

[0042] In the specific implementation, the way to write the table fields in the multi-source database into a database dictionary table field_dic is: through the analysis of the text language and...

Embodiment 2

[0058] This embodiment provides a multi-source database global search system, which includes:

[0059] (1) A table structure summary module, which is used for summarizing the table fields in the multi-source database and writing them into a database dictionary table for field management.

[0060] Specifically, in order to ensure that the original table structure in the original database will not be damaged, the table fields in the multi-source database are written into a database dictionary table field_dic for field management; this table covers the structure and Unstructured data storage structure, the dictionary table (field_dic) contains the main key business fields such as the original database table name, field name, field meaning, field type, field identification (whether the primary key), data table source, etc.

[0061] In the specific implementation, the way to write the table fields in the multi-source database into a database dictionary table field_dic is: through t...

Embodiment 3

[0077] This embodiment provides a computer-readable storage medium, on which a computer program is stored. When the program is executed by a processor, the steps in the multi-source database global search method described in Embodiment 1 are implemented.

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 belongs to the field of data search, and provides a multi-source database global search method and system. The multi-source database global search method comprises the steps: gathering and writting table fields in a multi-source database into a database dictionary table for field management; automatically processing table fields in the multi-source database according to a self-defined global search automation rule to generate a global search database dictionary table; taking a union set of a global search field and a global display field in the global search database dictionary table, dynamically generating a full-text retrieval data storage structure by taking the union set as a reference, and taking an original library table name as an index and a type; synchronizing all the original library table data which can be globally searched into a service database; and performing engine analysis on the business database according to the database dictionary table and the full-text retrieval data storage structure, and sending an analysis result to a front-end page for display.

Description

technical field [0001] The invention belongs to the field of data search, in particular to a multi-source database global search method and system. Background technique [0002] The statements in this section merely provide background information related to the present invention and do not necessarily constitute prior art. [0003] With the rapid development of network and information technology, the transparency of society is promoted, and data from all walks of life is gradually opened up. At present, with the continuous construction of various institutions and systems, the amount of accumulated data is increasing, and the types are becoming more and more abundant. Due to the wide variety of data, if a global search from these data requires a lot of manpower to understand the specific business data, often the front-end engineers of a certain system construction do not need to pay attention to the specific business, resulting in a gap between the front-end development engi...

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
IPC IPC(8): G06F16/33G06F16/338G06F16/31G06F16/22G06F40/216G06F40/30
CPCG06F16/334G06F16/2282G06F16/31G06F40/30G06F40/216G06F16/338
Inventor 田立娜高军王可鑫段文良
Owner 山东合天智汇信息技术有限公司
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

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

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap