CN111382226A - Database query retrieval method and device and electronic equipment - Google Patents
Database query retrieval method and device and electronic equipment Download PDFInfo
- Publication number
- CN111382226A CN111382226A CN201811641248.0A CN201811641248A CN111382226A CN 111382226 A CN111382226 A CN 111382226A CN 201811641248 A CN201811641248 A CN 201811641248A CN 111382226 A CN111382226 A CN 111382226A
- Authority
- CN
- China
- Prior art keywords
- database
- index
- template
- query retrieval
- query
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
Images
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a database query retrieval method, a database query retrieval device and electronic equipment, wherein the method comprises the following steps: acquiring data from a plurality of database tables with different table structures and correspondingly generating an index of a full-text search engine Elasticissearch according to the acquired data; receiving a query retrieval request containing index template identification by utilizing the full-text search engine Elasticissearch; and searching corresponding index templates in a plurality of pre-established index templates according to the index template identification, and performing query retrieval in one or more different indexes indicated in the index templates to obtain a query retrieval result. The technical scheme of the embodiment of the invention solves the problems of poor performance and low efficiency in cross-business, cross-database and other query retrieval, and the query function is free from development, thereby saving manpower and time.
Description
Technical Field
The invention relates to the technical field of databases, in particular to a database query retrieval method, a database query retrieval device and electronic equipment.
Background
At present, in business systems of enterprises, databases are mostly used for data storage, and the databases include various databases such as Qracle, SQLServer, MySQL and the like. In each business system, base tables with corresponding functions are respectively designed according to business function division, and specific business data is added, deleted, modified and checked. The query function is an indispensable function of the service module of each service system, and the development needs to be performed by consuming time and manpower, so that the development difficulty is high. In addition, if a plurality of business systems or a plurality of databases of different database languages are involved, the traditional database query mode has poor performance and low efficiency.
Disclosure of Invention
The invention provides a database query retrieval method, a database query retrieval device and electronic equipment, which solve the problems of poor database query retrieval performance and low efficiency, and save manpower and time because the query function is free from development.
According to one aspect of the present application, there is provided a database query retrieval method, including:
acquiring data from a plurality of database tables with different table structures and correspondingly generating an index of a full-text search engine Elasticissearch according to the acquired data;
receiving a query retrieval request containing index template identification by utilizing the full-text search engine Elasticissearch;
and searching corresponding index templates in a plurality of pre-established index templates according to the index template identification, and performing query retrieval in one or more different indexes indicated in the index templates to obtain a query retrieval result.
According to another aspect of the present application, there is provided a database query retrieval apparatus including:
the index generating module is used for acquiring data from a plurality of database tables with different table structures and correspondingly generating an index of a full-text search engine Elasticissearch according to the acquired data;
the request receiving module is used for receiving a query retrieval request containing index template identification by utilizing the full-text search engine Elasticissearch;
and the query retrieval module is used for searching the corresponding index template in a plurality of pre-established index templates according to the index template identification, and performing query retrieval in one or more different indexes indicated in the index template to obtain a query retrieval result.
According to yet another aspect of the present application, there is provided an electronic device including: the system comprises a memory and a processor, wherein the memory and the processor are connected through an internal bus in a communication mode, the memory stores program instructions capable of being executed by the processor, and the program instructions are capable of realizing the method in one aspect of the application when being executed by the processor.
The database query retrieval method of the embodiment of the invention is applied, data are obtained from a plurality of database tables with different table structures, indexes of a full-text search engine Elasticissearch are correspondingly generated according to the obtained data, a query retrieval request containing index template identification is received by using the full-text search engine Elasticissearch, corresponding index templates are searched in a plurality of pre-established index templates according to the index template identification, and query retrieval is carried out in one or more different indexes indicated in the index templates to obtain a query retrieval result. Therefore, by utilizing the unstructured characteristic of the elastic search, cross-service, cross-database and cross-system unified query retrieval is realized, the query performance and efficiency are improved, the query function is free from development, the manpower and time are saved, and the large-scale popularization and application are facilitated.
Drawings
FIG. 1 is a flow diagram of a database query retrieval method according to one embodiment of the invention;
FIG. 2 is a flow diagram of a database query retrieval method according to another embodiment of the invention;
FIG. 3 is a block diagram of a database query retrieval apparatus according to an embodiment of the present invention;
fig. 4 is a schematic structural diagram of an electronic device according to an embodiment of the present invention.
Detailed Description
In order to make the aforementioned objects, features and advantages of the present invention comprehensible, embodiments accompanied with figures are described in further detail below. It is to be understood that the embodiments described are only a few embodiments of the present invention, and not all embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
The design concept of the invention is as follows: aiming at the problems that in the prior art, query modules need to be developed independently, the problems of high labor and time consumption, low efficiency, poor real-time performance and the like in cross-system and cross-database query are solved, the query retrieval scheme is realized based on a full-text search engine Elastic search, data are obtained from a plurality of database tables with different table structures, indexes of the full-text search engine Elastic search are generated correspondingly according to the obtained data, a query retrieval request is received by the full-text search engine Elastic search, query retrieval is carried out in the indexes to obtain query retrieval results, unified query search of cross-service, cross-database and cross-system is realized, the query function is free from development, and labor and time cost are saved.
For ease of understanding, the search engine elastic search is briefly described herein. The Elasticissearch is a distributed extensible real-time search and analysis engine, is designed for cloud computing, can achieve real-time search, is stable, reliable and fast, not only has a full-text search function, but also can perform the following work: distributed real-time file storage and indexes each field so that it can be searched. The distributed search engine for real-time analysis can be expanded to hundreds of servers and can process a large amount of structured or unstructured data.
The Elasticsearch is a document-oriented database, and one piece of data is a document, and JSON is used as a format for document serialization. There are several more important concepts of the Elasticsearch, which are described separately below:indexing(index), the index is a logical storage of an elastic search, which can be understood as a database in a relational database, the elastic search can store index data on one server, or store the index data on multiple servers after being fragmented, each index has one or more fragments, and each fragment can have multiple copies.Index type(index _ type) in the elastic search, one index object can store a plurality of objects with different purposes, different objects in a single index can be distinguished by index types, which can be understood as tables in a relational database, each index type can have a different structure, but different indexesThe types cannot be set to different types for the same attribute.Document(document), the main entity stored in the Elasticsearch is a document, which can be understood as a row of records in a table in a relational database, each document is composed of a plurality of fields (which can be understood as a column in a table in a relational database), and the Elasticsearch is an unstructured database, each document can have different fields and has a unique identifier.Mapping(mapping), mapping of index and index type is dynamically created by default for the elastic search, and RESTful API is provided for the elastic search, and mapping of index can be created by post request.
The embodiment of the invention mainly solves the problem of low cross-service and cross-database query retrieval performance by utilizing the unstructured characteristic of the elastic search.
Fig. 1 is a schematic flow chart of a database query retrieval method according to an embodiment of the present invention, and referring to fig. 1, the database query retrieval method according to the embodiment includes the following steps:
step S101, acquiring data from a plurality of database tables with different table structures and correspondingly generating an index of a full-text search engine Elasticissearch according to the acquired data;
step S102, receiving a query retrieval request containing index template identification by using the full-text search engine Elasticissearch;
step S103, searching corresponding index templates in a plurality of pre-established index templates according to the index template identification, and performing query retrieval in one or more different indexes indicated in the index templates to obtain query retrieval results.
As shown in fig. 1, the database query retrieval method according to the embodiment of the present invention obtains data from a plurality of database tables with different table structures and generates an index of a full-text search engine Elasticsearch according to the obtained data, and then searches for a corresponding index template in a plurality of pre-established index templates according to the index template identifier when the Elasticsearch request including the index template identifier is received by the Elasticsearch, and further performs query retrieval in one or more different indexes indicated in the index template to obtain a query retrieval result.
Generally, the database query retrieval method of the embodiment of the invention has the following implementation thought: writing SQL statement scripts of a specific service system database table to be queried, accurately synchronizing to an index library of an Elasticissearch search engine in real time through Logstash, and generating different index templates for query according to index combinations in the index library (Logstash is a platform for transmitting, processing, managing and searching application program logs and events, and can be used for uniformly collecting and managing the application program logs). And finally, the unified query retrieval of a single business table or a plurality of business tables, a plurality of business systems and a plurality of database languages is realized by combining the vector template engine for page presentation, and the independent development of query modules aiming at different business systems is avoided.
Fig. 2 is a flowchart of a database query retrieval method according to another embodiment of the present invention, and the following describes implementation steps of the database query retrieval method according to the embodiment of the present invention with reference to fig. 2.
Referring to fig. 2, the overall view includes from top to bottom: step one, receiving a query retrieval request in an Elasticissearch search engine.
The query request includes an index template identifier, for example, a partial service library index template (i.e., a cross-database index template), a full-text search index template, a single-database index template, and a single-database index template, where the full-text search index template includes identifiers of all indexes, the cross-database index template includes identifiers of indexes corresponding to database tables of different databases, and the single-database index template includes identifiers of indexes corresponding to different database tables in the same database.
It should be noted that, in this embodiment, service combination is performed according to query needs to generate an Elasticsearch index template, where query requests are different and used index templates are also different.
And step two, querying the database tables of all business systems synchronized to the Elasticissearch.
Referring to fig. 2, according to the indexes indicated by the index template, corresponding indexes, such as index 1, index 2, and index 3, are found in the index database. The index is correspondingly generated according to a database table of the business system. The process of index generation includes:
and 2.1, pre-writing an SQL script containing a database table query SQL statement.
For example, SQL (Structured Query Language, SQL for short) Query statements of all the service tables (such as table 1, table 2, and table 3) in each service library 1, 2, … … n that need to be queried and retrieved are compiled into an SQL script.
Step 2.2, configuring and starting Logstash;
the configuration information of the database of the business system to which a plurality of database tables with different table structures belong is obtained, the data is obtained from the database table of the corresponding database according to the configuration information of the database by using the Logstash, and the obtained data is analyzed, filtered and correspondingly stored in the index of the full-text search engine Elasticissearch.
Referring to fig. 2, the Logstash may obtain data from a database table of a corresponding database through a pre-written SQL script containing a database table query SQL statement. In specific implementation, the configuration information of the database related to a specific service system is configured in Logstahs, such as: the database links, drives, accounts, passwords and the like, and a mapping relation between a database table corresponding to the service system and an index database of the Elasticissearch is configured in the Logstash.
Starting the configured Logstash, and automatically synchronizing the configured database table data in real time after the Logstash is started, namely keeping the data consistency of the index of the Elasticissearch and the database table corresponding to the service system.
Logstash is a platform for application logging, transmission, processing, management, and searching of events. It can be used to uniformly collect and manage application program logs, and the embodiment only uses the function of synchronizing data, such as synchronizing data in an oracle database into an Elasticsearch.
And step three, the page presents the query retrieval result.
In this embodiment, the query retrieval result is sent to a template engine, so that the template engine reads a page template and generates a page according to the query retrieval result and the page template.
Referring to fig. 2, the customizable query retrieval result page presentation is realized according to the Elasticsearch index template in combination with the Velocity template engine. Specifically, in the embodiment of the present invention, the query and search result is sent to the template engine, so that the template engine reads the page templates (see fig. 2, a plurality of page templates can be set according to needs) and generates pages according to the query and search result and the page templates, thereby realizing personalized page presentation and satisfying actual needs. The template engine is, for example, a Velocity template engine, which is a Java-based template engine framework, and provides a template language that can use objects and variables defined in Java, and allows HTML to have dynamic content properties without using JSP.
Therefore, the database query retrieval method of the embodiment of the invention supports unified search of different service functions such as cross-service, cross-database and cross-system query retrieval with a single service query retrieval function, and supports unified retrieval of table data with different structures. And the data is synchronized through the Logstash, the real-time change of the database data is monitored, and the timeliness and the accuracy of query are ensured. Finally, the independent development of the query function aiming at different business systems is avoided, and the time and the labor are saved.
The same technical idea as the aforementioned database query retrieval method, the embodiment of the present invention further provides a database query retrieval apparatus, fig. 3 is a block diagram of the database query retrieval apparatus according to the embodiment of the present invention, referring to fig. 3, the database query retrieval apparatus 300 according to the embodiment includes:
the index generating module 301 is configured to obtain data from a plurality of database tables with different table structures and generate an index of a full-text search engine elastic search according to the obtained data;
a request receiving module 302, configured to receive, by using the full-text search engine Elasticsearch, a query retrieval request including an index template identifier;
the query retrieval module 303 is configured to find a corresponding index template from a plurality of pre-established index templates according to the index template identifier, and perform query retrieval in one or more different indexes indicated in the index template to obtain a query retrieval result.
The pre-established index template herein includes: the system comprises a full-text search index template, a cross-database index template, a single-database index template and a single-database index template, wherein the full-text search index template comprises identifications of all indexes, the cross-database index template comprises identifications of indexes corresponding to database tables of different databases, and the single-database index template comprises identifications of indexes corresponding to different database tables in the same database.
In one embodiment of the present invention, the database query retrieving apparatus 300 further comprises: and the page presentation module is used for sending the query retrieval result to the template engine, so that the template engine reads the page template and generates a page according to the query retrieval result and the page template.
In an embodiment of the present invention, the index generating module 301 is specifically configured to obtain configuration information of a database of a service system to which a plurality of database tables with different table structures belong, obtain data from a database table of a corresponding database according to the configuration information of the database by using Logstash, analyze and filter the obtained data, and store the data into an index of an elastic search engine of a full-text search engine.
In an embodiment of the present invention, the index generation module 301 is configured to utilize logstack to obtain data from a database table of a corresponding database through a pre-written SQL script containing a database table query SQL statement.
It should be noted that, an example of a working process of each module of the database query retrieval device shown in fig. 3 is consistent with an example of an explanation of each step in the foregoing method embodiment, so that reference may be made to the explanation in the foregoing embodiment, and details are not described here.
Fig. 4 is a schematic structural diagram of an electronic device according to an embodiment of the present invention. As shown in fig. 4, the electronic device includes a memory 401 and a processor 402, the memory 401 and the processor 402 are communicatively connected through an internal bus 403, the memory 401 stores program instructions executable by the processor 402, and the program instructions, when executed by the processor 402, can implement the above-mentioned database query retrieval method.
In addition, the logic instructions in the memory 401 may be implemented in the form of software functional units and may be stored in a computer readable storage medium when the logic instructions are sold or used as independent products. Based on such understanding, the technical solution of the present invention or a part thereof, which essentially contributes to the prior art, can be embodied in the form of a software product, which is stored in a storage medium and includes several instructions for causing a computer device (which may be a personal computer, a server, or a network device) to execute all or part of the steps of the method described in the embodiments of the present application. And the aforementioned storage medium includes: a U-disk, a removable hard disk, a Read-Only Memory (ROM), a Random Access Memory (RAM), a magnetic disk or an optical disk, and other various media capable of storing program codes.
Another embodiment of the present invention provides a computer-readable storage medium storing computer instructions that cause the computer to perform the above-described method.
As will be appreciated by one skilled in the art, embodiments of the present invention may be provided as a method, system, or computer program product. Accordingly, the present invention may take the form of an entirely hardware embodiment, an entirely software embodiment or an embodiment combining software and hardware aspects. Furthermore, the present invention may take the form of a computer program product embodied on one or more computer-usable storage media (including, but not limited to, disk storage, CD-ROM, optical storage, and the like) having computer-usable program code embodied therein.
The present invention is described with reference to flowchart illustrations and/or block diagrams of methods, apparatus (systems), and computer program products according to embodiments of the invention. It will be understood that each flow and/or block of the flow diagrams and/or block diagrams, and combinations of flows and/or blocks in the flow diagrams and/or block diagrams, can be implemented by computer program instructions. These computer program instructions may be provided to a processor of a general purpose computer, special purpose computer, embedded processor, or other programmable data processing apparatus to produce a machine, such that the instructions, which execute via the processor of the computer or other programmable data processing apparatus, create means for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
It is to be noted that the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or apparatus that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, method, article, or apparatus. Without further limitation, an element defined by the phrase "comprising an … …" does not exclude the presence of other identical elements in a process, method, article, or apparatus that comprises the element.
In the description of the present invention, numerous specific details are set forth. It is understood, however, that embodiments of the invention may be practiced without these specific details. In some instances, well-known methods, structures and techniques have not been shown in detail in order not to obscure an understanding of this description. Similarly, it should be appreciated that in the foregoing description of exemplary embodiments of the invention, various features of the invention are sometimes grouped together in a single embodiment, figure, or description thereof for the purpose of streamlining the disclosure and aiding in the understanding of one or more of the various inventive aspects. However, the disclosed method should not be interpreted as reflecting an intention that: that the invention as claimed requires more features than are expressly recited in each claim. Rather, as the following claims reflect, inventive aspects lie in less than all features of a single foregoing disclosed embodiment. Thus, the claims following the detailed description are hereby expressly incorporated into this detailed description, with each claim standing on its own as a separate embodiment of this invention.
While the foregoing is directed to embodiments of the present invention, other modifications and variations of the present invention may be devised by those skilled in the art in light of the above teachings. It should be understood by those skilled in the art that the foregoing detailed description is for the purpose of illustrating the invention rather than the foregoing detailed description, and that the scope of the invention is defined by the claims.
Claims (10)
1. A database query retrieval method, comprising:
acquiring data from a plurality of database tables with different table structures and correspondingly generating an index of a full-text search engine Elasticissearch according to the acquired data;
receiving a query retrieval request containing index template identification by utilizing the full-text search engine Elasticissearch;
and searching corresponding index templates in a plurality of pre-established index templates according to the index template identification, and performing query retrieval in one or more different indexes indicated in the index templates to obtain a query retrieval result.
2. The method of claim 1, further comprising:
and sending the query retrieval result to a template engine, enabling the template engine to read a page template and generating a page according to the query retrieval result and the page template.
3. The method of claim 1, wherein the obtaining data from a plurality of database tables with different table structures and correspondingly generating an index of a full text search engine elastic search according to the obtained data comprises:
acquiring configuration information of a database of a business system to which a plurality of database tables with different table structures belong,
and acquiring data from a database table of the corresponding database according to the configuration information of the database by using the Logstash, analyzing and filtering the acquired data, and correspondingly storing the data into an index of an Elasticissearch engine.
4. The method of claim 3, wherein the obtaining data from the database table of the corresponding database according to the configuration information of the database by using the Logstash comprises:
and acquiring data from the database table of the corresponding database by using the Logstash through a pre-written SQL script containing a database table query SQL statement.
5. The method of claim 1, wherein the pre-established index template comprises: :
full-text search index templates, cross-database index templates, single database index templates, and single data table index templates,
the full-text search index template comprises identifications of all indexes, the cross-database index template comprises identifications of indexes corresponding to database tables of different databases, and the single-database index template comprises identifications of indexes corresponding to different database tables in the same database.
6. A database query retrieval apparatus, comprising:
the index generating module is used for acquiring data from a plurality of database tables with different table structures and correspondingly generating an index of a full-text search engine Elasticissearch according to the acquired data;
the request receiving module is used for receiving a query retrieval request containing index template identification by utilizing the full-text search engine Elasticissearch;
and the query retrieval module is used for searching the corresponding index template in a plurality of pre-established index templates according to the index template identification, and performing query retrieval in one or more different indexes indicated in the index template to obtain a query retrieval result.
7. The apparatus of claim 6, further comprising: and the page presentation module is used for sending the query retrieval result to the template engine, so that the template engine reads the page template and generates a page according to the query retrieval result and the page template.
8. The apparatus according to claim 6, wherein the index generation module is specifically configured to obtain configuration information of a database of a service system to which a plurality of database tables with different table structures belong, obtain data from a database table of a corresponding database according to the configuration information of the database by using a Logstash, analyze and filter the obtained data, and store the data in an index of a full-text search engine Elasticsearch correspondingly.
9. The apparatus of claim 8, wherein the index generation module is configured to use logstack to obtain data from a database table of a corresponding database through a pre-written SQL script containing a database table query SQL statement.
10. An electronic device, characterized in that the electronic device comprises: a memory and a processor communicatively coupled via an internal bus, the memory storing program instructions executable by the processor, the program instructions when executed by the processor implementing the method of any of claims 1-5.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811641248.0A CN111382226B (en) | 2018-12-29 | 2018-12-29 | Database query and retrieval method and device and electronic equipment |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811641248.0A CN111382226B (en) | 2018-12-29 | 2018-12-29 | Database query and retrieval method and device and electronic equipment |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN111382226A true CN111382226A (en) | 2020-07-07 |
| CN111382226B CN111382226B (en) | 2023-09-19 |
Family
ID=71222410
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201811641248.0A Active CN111382226B (en) | 2018-12-29 | 2018-12-29 | Database query and retrieval method and device and electronic equipment |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111382226B (en) |
Cited By (11)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111858833A (en) * | 2020-07-29 | 2020-10-30 | 广州海鹚网络科技有限公司 | Asynchronous indexing method and device, computer equipment and storage medium |
| CN111881086A (en) * | 2020-07-23 | 2020-11-03 | 杭州安恒信息技术股份有限公司 | Big data storage method, big data query method, electronic device and storage medium |
| CN112000669A (en) * | 2020-08-14 | 2020-11-27 | 中科三清科技有限公司 | Environment monitoring data processing method and device, storage medium and terminal |
| CN112148938A (en) * | 2020-10-16 | 2020-12-29 | 成都中科大旗软件股份有限公司 | Cross-domain heterogeneous data retrieval system and retrieval method |
| CN112417223A (en) * | 2020-11-27 | 2021-02-26 | 亿企赢网络科技有限公司 | Database retrieval method and related device |
| CN112434041A (en) * | 2020-11-30 | 2021-03-02 | 中国人寿保险股份有限公司 | Cross-tenant and cross-bucket retrieval method, device, medium and equipment based on index alias |
| CN112612905A (en) * | 2020-12-28 | 2021-04-06 | 北京明略软件系统有限公司 | Elasticissearch-based data processing method, system, computer and readable storage medium |
| CN112988863A (en) * | 2021-02-09 | 2021-06-18 | 苏州中科蓝迪软件技术有限公司 | Elasticissearch-based efficient search engine method for heterogeneous multiple data sources |
| CN113760952A (en) * | 2021-08-09 | 2021-12-07 | 深圳前海爱客风信息技术有限公司 | Data query method and device, storage medium and electronic device |
| CN114153909A (en) * | 2021-11-26 | 2022-03-08 | 北京人大金仓信息技术股份有限公司 | Database table structure translation method and device based on Velocity template engine |
| CN116881391A (en) * | 2023-09-06 | 2023-10-13 | 安徽商信政通信息技术股份有限公司 | Full text retrieval method and system |
Citations (11)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2000079436A2 (en) * | 1999-06-24 | 2000-12-28 | Simpli.Com | Search engine interface |
| CN1653448A (en) * | 2001-11-20 | 2005-08-10 | 尤尼瑟奇有限公司 | System and method for searching data sources |
| US20060074881A1 (en) * | 2004-10-02 | 2006-04-06 | Adventnet, Inc. | Structure independent searching in disparate databases |
| US20060173813A1 (en) * | 2005-01-04 | 2006-08-03 | San Antonio Independent School District | System and method of providing ad hoc query capabilities to complex database systems |
| US20090132494A1 (en) * | 2007-10-19 | 2009-05-21 | Oracle International Corporation | Data Source-Independent Search System Architecture |
| CN101894166A (en) * | 2010-07-28 | 2010-11-24 | 郑茂 | Network intelligent search engine system |
| CN103365914A (en) * | 2012-04-10 | 2013-10-23 | 北京易盟天地信息技术有限公司 | Database query system and method based on search engine |
| US20150220594A1 (en) * | 2014-02-06 | 2015-08-06 | International Business Machines Corporation | Searching content managed by a search engine using relational database type queries |
| US20160034510A1 (en) * | 2014-07-29 | 2016-02-04 | Ca, Inc. | Indexing and searching log records using templates index and attributes index |
| CN107609154A (en) * | 2017-09-23 | 2018-01-19 | 浪潮软件集团有限公司 | Method and device for processing multi-source heterogeneous data |
| CN109086409A (en) * | 2018-08-02 | 2018-12-25 | 泰康保险集团股份有限公司 | Micro services data processing method, device, electronic equipment and computer-readable medium |
-
2018
- 2018-12-29 CN CN201811641248.0A patent/CN111382226B/en active Active
Patent Citations (11)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2000079436A2 (en) * | 1999-06-24 | 2000-12-28 | Simpli.Com | Search engine interface |
| CN1653448A (en) * | 2001-11-20 | 2005-08-10 | 尤尼瑟奇有限公司 | System and method for searching data sources |
| US20060074881A1 (en) * | 2004-10-02 | 2006-04-06 | Adventnet, Inc. | Structure independent searching in disparate databases |
| US20060173813A1 (en) * | 2005-01-04 | 2006-08-03 | San Antonio Independent School District | System and method of providing ad hoc query capabilities to complex database systems |
| US20090132494A1 (en) * | 2007-10-19 | 2009-05-21 | Oracle International Corporation | Data Source-Independent Search System Architecture |
| CN101894166A (en) * | 2010-07-28 | 2010-11-24 | 郑茂 | Network intelligent search engine system |
| CN103365914A (en) * | 2012-04-10 | 2013-10-23 | 北京易盟天地信息技术有限公司 | Database query system and method based on search engine |
| US20150220594A1 (en) * | 2014-02-06 | 2015-08-06 | International Business Machines Corporation | Searching content managed by a search engine using relational database type queries |
| US20160034510A1 (en) * | 2014-07-29 | 2016-02-04 | Ca, Inc. | Indexing and searching log records using templates index and attributes index |
| CN107609154A (en) * | 2017-09-23 | 2018-01-19 | 浪潮软件集团有限公司 | Method and device for processing multi-source heterogeneous data |
| CN109086409A (en) * | 2018-08-02 | 2018-12-25 | 泰康保险集团股份有限公司 | Micro services data processing method, device, electronic equipment and computer-readable medium |
Cited By (14)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111881086A (en) * | 2020-07-23 | 2020-11-03 | 杭州安恒信息技术股份有限公司 | Big data storage method, big data query method, electronic device and storage medium |
| CN111881086B (en) * | 2020-07-23 | 2024-03-19 | 杭州安恒信息技术股份有限公司 | Big data storage method, query method, electronic device and storage medium |
| CN111858833A (en) * | 2020-07-29 | 2020-10-30 | 广州海鹚网络科技有限公司 | Asynchronous indexing method and device, computer equipment and storage medium |
| CN112000669B (en) * | 2020-08-14 | 2021-08-03 | 中科三清科技有限公司 | Environment monitoring data processing method and device, storage medium and terminal |
| CN112000669A (en) * | 2020-08-14 | 2020-11-27 | 中科三清科技有限公司 | Environment monitoring data processing method and device, storage medium and terminal |
| CN112148938A (en) * | 2020-10-16 | 2020-12-29 | 成都中科大旗软件股份有限公司 | Cross-domain heterogeneous data retrieval system and retrieval method |
| CN112417223A (en) * | 2020-11-27 | 2021-02-26 | 亿企赢网络科技有限公司 | Database retrieval method and related device |
| CN112434041A (en) * | 2020-11-30 | 2021-03-02 | 中国人寿保险股份有限公司 | Cross-tenant and cross-bucket retrieval method, device, medium and equipment based on index alias |
| CN112612905A (en) * | 2020-12-28 | 2021-04-06 | 北京明略软件系统有限公司 | Elasticissearch-based data processing method, system, computer and readable storage medium |
| CN112988863A (en) * | 2021-02-09 | 2021-06-18 | 苏州中科蓝迪软件技术有限公司 | Elasticissearch-based efficient search engine method for heterogeneous multiple data sources |
| CN113760952A (en) * | 2021-08-09 | 2021-12-07 | 深圳前海爱客风信息技术有限公司 | Data query method and device, storage medium and electronic device |
| CN114153909A (en) * | 2021-11-26 | 2022-03-08 | 北京人大金仓信息技术股份有限公司 | Database table structure translation method and device based on Velocity template engine |
| CN116881391A (en) * | 2023-09-06 | 2023-10-13 | 安徽商信政通信息技术股份有限公司 | Full text retrieval method and system |
| CN116881391B (en) * | 2023-09-06 | 2024-01-02 | 安徽商信政通信息技术股份有限公司 | Full text retrieval method and system |
Also Published As
| Publication number | Publication date |
|---|---|
| CN111382226B (en) | 2023-09-19 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN111382226B (en) | Database query and retrieval method and device and electronic equipment | |
| CN109299102B (en) | HBase secondary index system and method based on Elastcissearch | |
| CN106547796B (en) | Database execution method and device | |
| CN109446279A (en) | Based on neo4j big data genetic connection management method, system, equipment and storage medium | |
| CN104133867A (en) | DOT in-fragment secondary index method and DOT in-fragment secondary index system | |
| CN104123288A (en) | Method and device for inquiring data | |
| CN106294695A (en) | A kind of implementation method towards the biggest data search engine | |
| CN111767303A (en) | Data query method and device, server and readable storage medium | |
| CN104102710A (en) | Massive data query method | |
| CN108052635A (en) | A kind of heterogeneous data source unifies conjunctive query method | |
| CN104239377A (en) | Platform-crossing data retrieval method and device | |
| US9734176B2 (en) | Index merge ordering | |
| WO2014110940A1 (en) | A method, apparatus and system for storing, reading the directory index | |
| CN103226608B (en) | A kind of parallel file searching method based on directory level telescopic Bloom Filter bitmap table | |
| CN109739882B (en) | Big data query optimization method based on Presto and Elasticissearch | |
| CN114461603A (en) | Multi-source heterogeneous data fusion method and device | |
| CN106815353A (en) | A kind of method and apparatus of data query | |
| CN106484694B (en) | Full-text search method and system based on distributed data base | |
| US9390131B1 (en) | Executing queries subject to different consistency requirements | |
| CN112579578A (en) | Metadata-based data quality management method, device and system and server | |
| CN113779349A (en) | Data retrieval system, apparatus, electronic device, and readable storage medium | |
| CN113468209A (en) | High-speed memory database access method for power grid monitoring system | |
| CN113515564A (en) | Data access method, device, equipment and storage medium based on J2EE | |
| US11567957B2 (en) | Incremental addition of data to partitions in database tables | |
| CN112417225A (en) | Joint query method and system for multi-source heterogeneous data |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| CB02 | Change of applicant information |
Address after: Room 818, 8 / F, 34 Haidian Street, Haidian District, Beijing 100080 Applicant after: ULTRAPOWER SOFTWARE Co.,Ltd. Address before: 100089 Beijing city Haidian District wanquanzhuang Road No. 28 Wanliu new building 6 storey block A Room 601 Applicant before: ULTRAPOWER SOFTWARE Co.,Ltd. |
|
| CB02 | Change of applicant information | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |