Unlock instant, AI-driven research and patent intelligence for your innovation.

Analytical database and full-text retrieval engine fusion method and related device

A fusion method and database technology, applied in the fusion field of analytical database and full-text search engine, can solve the problem of high computing resources and achieve the effect of improving query efficiency

Pending Publication Date: 2022-06-03
ZHEJIANG DAHUA TECH CO LTD
View PDF0 Cites 2 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

The compression ratio of some compression algorithms is relatively high, but the computing resources such as CPU consumed by compression will also be relatively high

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
  • Analytical database and full-text retrieval engine fusion method and related device
  • Analytical database and full-text retrieval engine fusion method and related device
  • Analytical database and full-text retrieval engine fusion method and related device

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0030] The following will clearly and completely describe the technical solutions in the embodiments of the present application with reference to the drawings in the embodiments of the present application. Obviously, the described embodiments are only some of the embodiments of the present application, not all of them. Based on the embodiments in this application, all other embodiments obtained by persons of ordinary skill in the art without making creative efforts belong to the scope of protection of this application.

[0031] Different types of analytical databases have their own trade-offs when making technical selections, which also leads to a wide variety of analytical databases, including OLAP analytical databases, OLTP analytical databases, full-text search analytical databases, and so on. Specifically, it is reflected at the business level. For example, analytical databases with strong analytical capabilities are lacking in transaction capabilities or concurrency capabi...

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 discloses a fusion method of an analytical database and a full-text retrieval engine and a related device. The method comprises the following steps: establishing an ES external table in the analytical database; wherein the ES external table comprises at least one index specified by the client and is used for storing related configuration information of the full-text retrieval engine; aiming at each index in the ES external table, creating an index in a full-text retrieval engine in response to verification that the related attribute of the index has no problem and in response to starting of an automatic creation function of the index, and establishing an association relationship between the analytical database and the full-text retrieval engine in the ES external table by utilizing the index; in response to successful establishment of the association relationship, connecting a full-text retrieval engine and obtaining associated information of the index from the full-text retrieval engine; and in response to the fact that the associated information is not abnormal, storing the associated information in the ES external table. And the data in the full-text retrieval engine can be accessed only by using the JDBC, so that the query efficiency is improved.

Description

technical field [0001] The present application relates to the technical field of distributed analytical databases, in particular to a fusion method and related devices of analytical databases and full-text search engines. Background technique [0002] With the popularization of the Internet and the wide application of the Internet of Things, the data volume of various business systems has also experienced rapid growth. The original stand-alone analytical database system can handle the technology, which has become difficult in the case of such a huge amount of data. Since the stand-alone analytical database cannot scale horizontally, a distributed analytical database emerges as the times require. However, distributed analytical databases introduce a series of new problems while solving one problem. Distributed analytical databases are flourishing, but no distributed analytical database can integrate the strengths of hundreds of schools, that is, it cannot be based on the sa...

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/242G06F16/22G06F16/27
CPCG06F16/2433G06F16/2282G06F16/2228G06F16/27
Inventor 朱林浩陶帅周明伟
Owner ZHEJIANG DAHUA TECH CO LTD