CN111382226B - Database query and retrieval method and device and electronic equipment - Google Patents
Database query and retrieval method and device and electronic equipment Download PDFInfo
- Publication number
- CN111382226B CN111382226B CN201811641248.0A CN201811641248A CN111382226B CN 111382226 B CN111382226 B CN 111382226B CN 201811641248 A CN201811641248 A CN 201811641248A CN 111382226 B CN111382226 B CN 111382226B
- Authority
- CN
- China
- Prior art keywords
- index
- database
- template
- query
- search
- 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.)
- Active
Links
- 238000000034 method Methods 0.000 title claims abstract description 43
- 238000013515 script Methods 0.000 claims description 8
- 238000004891 communication Methods 0.000 claims description 2
- 238000001914 filtration Methods 0.000 claims 1
- 230000006870 function Effects 0.000 description 12
- 238000010586 diagram Methods 0.000 description 9
- 229920001971 elastomer Polymers 0.000 description 6
- 239000000806 elastomer Substances 0.000 description 6
- 230000008569 process Effects 0.000 description 6
- 238000004590 computer program Methods 0.000 description 5
- 238000013507 mapping Methods 0.000 description 5
- 238000012545 processing Methods 0.000 description 4
- 230000001360 synchronised effect Effects 0.000 description 4
- 238000011161 development Methods 0.000 description 3
- 238000007726 management method Methods 0.000 description 2
- 230000003287 optical effect Effects 0.000 description 2
- 238000004458 analytical method Methods 0.000 description 1
- 230000005540 biological transmission Effects 0.000 description 1
- 230000008859 change Effects 0.000 description 1
- 238000013500 data storage Methods 0.000 description 1
- 238000013461 design Methods 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 238000004519 manufacturing process Methods 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 238000010223 real-time analysis Methods 0.000 description 1
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The application discloses a database query and retrieval method, a 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 an elastic search of the full-text search engine according to the acquired data; receiving a query retrieval request containing index template identifiers by using the full-text search engine; searching a corresponding index template from a plurality of index templates established in advance according to the index template identification, and searching in one or a plurality of different indexes indicated in the index template to obtain a search result. The technical scheme of the embodiment of the application solves the problems of poor performance and low efficiency in query and retrieval of cross-service, cross-database and the like, and the query function is not developed, so that manpower and time are saved.
Description
Technical Field
The present application relates to the field of database technologies, and in particular, to a method and an apparatus for searching and querying a database, and an electronic device.
Background
At present, in business systems of enterprises, databases are mostly used for data storage, and the databases comprise a plurality of Qracles, SQL servers, mySQL and the like. In each service system, library tables with corresponding functions are respectively designed according to service function division, and specific service data are added, deleted, revised and checked. The query function is an indispensable function of a service module of each service system, and needs to be developed with time and manpower, so that the development difficulty is high. In addition, if multiple business systems or multiple databases of different database languages are involved, the traditional database query mode has poor performance and low efficiency.
Disclosure of Invention
The application provides a database query and retrieval method, a device and electronic equipment, which solve the problems of poor database query and retrieval performance and low efficiency, and the query function is not developed, so that manpower and time are saved.
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 an elastic search of the full-text search engine according to the acquired data;
receiving a query retrieval request containing index template identifiers by using the full-text search engine;
searching a corresponding index template from a plurality of index templates established in advance according to the index template identification, and searching in one or a plurality of different indexes indicated in the index template to obtain a search result.
According to another aspect of the present application, there is provided a database query retrieval apparatus comprising:
the index generation module is used for acquiring data from a plurality of database tables with different table structures and correspondingly generating an index of the full-text search engine elastic search according to the acquired data;
the request receiving module is used for receiving a query retrieval request containing index template identifiers by utilizing the full-text search engine elastic search;
and the query retrieval module is used for searching a corresponding index template in a plurality of index templates which are established in advance according to the index template identification, and performing query retrieval in one or a plurality of different indexes indicated in the index templates to obtain a query retrieval result.
According to still another aspect of the present application, there is provided an electronic device including: the device comprises a memory and a processor, wherein the memory and the processor are in communication connection through an internal bus, the memory stores program instructions capable of being executed by the processor, and the program instructions can realize the method according to one aspect of the application when being executed by the processor.
By applying the database query and search method disclosed by the embodiment of the application, data are acquired from a plurality of database tables with different table structures, the index of the full-text search engine is correspondingly generated according to the acquired data, the full-text search engine is utilized to receive a query and search request containing index template identification, the corresponding index template is searched in a plurality of index templates established in advance according to the index template identification, and query and search are carried out in one or a plurality of different indexes indicated in the index templates, so that a query and search result is obtained. Therefore, by utilizing the unstructured characteristic of the elastic search, unified query and search of cross-service, cross-database and cross-system are realized, the performance and the efficiency of query are improved, the query function is not developed, the manpower and the time are saved, and the method is convenient for large-scale popularization and application.
Drawings
FIG. 1 is a flow diagram of a database query retrieval method according to one embodiment of the application;
FIG. 2 is a flowchart of a database query retrieval method according to another embodiment of the present application;
FIG. 3 is a block diagram of a database query retrieval apparatus according to one embodiment of the present application;
fig. 4 is a schematic structural diagram of an electronic device according to an embodiment of the present application.
Detailed Description
In order that the above-recited objects, features and advantages of the present application will become more readily apparent, a more particular description of the application will be rendered by reference to the appended drawings and appended detailed description. It will be apparent that the described embodiments are some, but not all, embodiments of the application. All other embodiments, which can be made by those skilled in the art based on the embodiments of the application without making any inventive effort, are intended to be within the scope of the application.
The design concept of the application is as follows: aiming at the problems that in the prior art, a database query and retrieval needs to be independently developed, the query module is labor-consuming, the efficiency is low, the instantaneity is poor and the like in cross-system and cross-database query, the database query and retrieval scheme is provided.
For ease of understanding, the search engine elastic search is briefly described herein. The elastic search is a distributed and expandable real-time search and analysis engine, is designed to be used in cloud computing, can achieve real-time search, is stable, reliable and quick, not only comprises a full-text search function, but also can perform the following work: the distributed real-time file is stored and each field is indexed so that it can be searched. The distributed search engine for real-time analysis can be extended to hundreds of servers to process large amounts of structured or unstructured data.
The elastomer search is a document-oriented database, where a piece of data is a document, in JSON as the format in which the document is serialized. There are several important concepts of the elastic search, which are described below:Indexthe index is a logical storage of the elastomer search, which can be understood as a database in a relational database, and the elastomer search can store index data on one server or can be stored on a plurality of servers after being segmented, each index has one or more segments, and each segment can have a plurality of copies.Index typeIn the elastic search, one index object may store a plurality of objects of different purposes, and different objects in a single index may be distinguished by index types, which may be understood as tables in a relational database, each index type may have a different structure, but different index types may not set different types for the same attribute.Document and method for producing the sameThe main entities stored in the elastomer search are called documents, which can be understood as a row of records in a relational database, each document being made up of a number of fields, which can be understood as a column in the relational database, an unstructured database, each document can have different fields, and a unique identifier.Mapping(mapping), the mapping of indexes and index types is dynamically created by the elastomer search default, which provides a RESTful API, which can create a mapping of indexes through post requests.
The embodiment of the application mainly uses the unstructured characteristic of the elastic search to solve the problem of low search performance of cross-service and cross-database query.
Fig. 1 is a flow chart of a database query search method according to an embodiment of the present application, referring to fig. 1, the database query search method of the present 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 an elastic search of a full-text search engine according to the acquired data;
step S102, receiving a query retrieval request containing index template identification by using the full-text search engine elastic search;
step S103, searching a corresponding index template in a plurality of index templates established in advance according to the index template identification, and carrying out query retrieval in one or a plurality of different indexes indicated in the index templates to obtain a query retrieval result.
As can be seen from fig. 1, in the database query search method according to the embodiment of the present application, data are obtained from a plurality of database tables with different table structures, and an index of an elastic search of a full-text search engine is correspondingly generated according to the obtained data, and then when the elastic search receives a query search request including an index template identifier, a corresponding index template is found in a plurality of index templates established in advance according to the index template identifier, and further query search is performed in one or more different indexes indicated in the index templates to obtain a query search result.
In general, the database query and search method of the embodiment of the application has the following implementation ideas: SQL statement scripts of a database table of a specific business system to be queried are written, the SQL statement scripts are accurately synchronized to an index library of an elastic search engine in real time through Logstahs, and then different index templates are generated for use in 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). Finally, a uniform query and search of a single service table or a plurality of service tables, a plurality of service systems and a plurality of database languages is realized by combining a vector template engine for page presentation, and the independent development of query modules aiming at different service systems is avoided.
Fig. 2 is a flowchart of a database query search method according to another embodiment of the present application, and the implementation steps of the database query search method according to the embodiment of the present application are described below with reference to fig. 2.
Referring to fig. 2, the overall view from top to bottom includes: step one, a query retrieval request is received in an elastic search engine.
The query request includes index template identifiers, such as 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 table 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.
In this embodiment, the service combination is performed according to the query requirement to generate the elastic search index template, so that the query requests are different, and the index templates used are different.
And step two, inquiring database tables of all business systems synchronized to the elastic search.
Referring to fig. 2, according to the index indicated by the index template, corresponding indexes, such as index 1, index 2, and index 3, are found in the index library. The index here is correspondingly generated from the database table of the business system. The index generation process comprises the following steps:
step 2.1, a pre-written SQL script containing database table query SQL statements.
For example, the SQL (Structured Query Language, structured query language, abbreviated as SQL) query statement of all the service tables (such as table 1, table 2, table 3) in each service library 1,2, … … n which needs to be searched is written into an SQL script.
Step 2.2, configuring Logstahs and starting;
the configuration information of databases of the service systems to which the plurality of database tables with different table structures belong is firstly obtained, then the Logstar is utilized to obtain data from the database tables of the corresponding databases according to the configuration information of the databases, and the obtained data is correspondingly stored in the index of the full-text search engine elastic search after being analyzed and filtered.
Referring to fig. 2, logstack acquisition data may acquire data from a database table of a corresponding database through a pre-written SQL script containing a database table query SQL statement. In particular implementation, database configuration information related to a specific service system is configured in Logstahs, such as: database links, drivers, account numbers, passwords and the like, and the mapping relation between a database table corresponding to the service system and an index library of the elastic search is configured in the Logstahs.
The configured Logstahs is started, and the configured database table data can be automatically synchronized in real time after the Logstahs is started, namely, the index of the elastic search is kept consistent with the database table data corresponding to the service system.
Logstack is a platform for application logging, event transmission, processing, management and searching. It can be used to unify the collection management of application logs, and this embodiment only uses its function of synchronizing data, such as synchronizing data in the Oraloce database into the elastomer search.
And step three, the page presents the query retrieval result.
In the embodiment, the query search result is sent to the template engine, so that the template engine reads the page template and generates a page according to the query search result and the page template.
Referring to FIG. 2, a customizable query search results page presentation is implemented in accordance with an elastic search index template in conjunction with a vector template engine. Specifically, in the embodiment of the application, the query search result is sent to the template engine, so that the template engine reads the page templates (see fig. 2, the page templates are multiple and can be set according to the requirements) and generates the page according to the query search result and the page templates, thereby realizing personalized page presentation and meeting the actual requirements. The template engine, such as a Vecity template engine, is a Java-based template engine framework, and the template language provided can be used on objects and variables defined in Java, and the Vecity can be used for enabling HTML to have the characteristic of dynamic content without using JSP.
The database query and search method of the embodiment of the application supports unified search of different service functions of the independent service query and search functions, such as cross-service, cross-database and cross-system unified query and search, and supports unified search of table data with different structures. And the real-time change of database data is monitored through the Logstar synchronous data, so that the timeliness and the accuracy of inquiry are ensured. Finally, independent development of query functions for different service systems is avoided, and time and labor are saved.
As well as the database query search method described above, the embodiment of the present application further provides a database query search device, and fig. 3 is a block diagram of the database query search device according to an embodiment of the present application, referring to fig. 3, the database query search device 300 of this embodiment includes:
the index generation module 301 is configured to obtain data from a plurality of database tables with different table structures and correspondingly generate an index of the full-text search engine elastsearch according to the obtained data;
a request receiving module 302, configured to receive a query search request including an index template identifier by using the full text search engine elastic search;
the query searching module 303 is configured to search a corresponding index template among a plurality of index templates established in advance according to the index template identifier, and perform query searching in one or more different indexes indicated in the index templates, so as to obtain a query searching result.
The pre-established index templates here include: the system comprises a full-text search index template, a cross-database index template, a single database index template and a single database table index template, wherein the full-text search index template comprises all indexes, the cross-database index template comprises indexes corresponding to database tables of different databases, and the single database index template comprises indexes corresponding to different database tables in the same database.
In one embodiment of the present application, the database query retrieval apparatus 300 further includes: and the page presentation module is used for sending the query search result to the template engine, so that the template engine reads the page template and generates a page according to the query search result and the page template.
In one embodiment of the present application, 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 logstack, analyze and filter the obtained data, and store the analyzed and filtered data in an index of an elastic search of a full-text search engine.
In one embodiment of the present application, the index generation module 301 is configured to obtain data from a database table of a corresponding database by using logstack through a pre-written SQL script including a database table query SQL statement.
It should be noted that, the explanation of the working process of each module of the database query and search device shown in fig. 3 is identical to the explanation of each step in the foregoing method embodiment, so reference may be made to the explanation in the foregoing embodiment, and the description is omitted here.
Fig. 4 is a schematic structural diagram of an electronic device according to an embodiment of the present application. As shown in fig. 4, the electronic device includes a memory 401 and a processor 402, where the memory 401 and the processor 402 are communicatively connected through an internal bus 403, and the memory 401 stores program instructions that can be executed by the processor 402, and the program instructions when executed by the processor 402 can implement the database query search method described above.
Further, the logic instructions in the memory 401 described above may be implemented in the form of software functional units and may be stored in a computer readable storage medium when sold or used as a stand alone product. Based on this understanding, the technical solution of the present application may be embodied essentially or in a part contributing to the prior art or in a part of the technical solution, in the form of a software product stored in a storage medium, comprising several instructions for causing a computer device (which may be a personal computer, a server, a network device, etc.) to perform all or part of the steps of the method according to 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, random Access Memory), a magnetic disk, or an optical disk, or other various media capable of storing program codes.
Another embodiment of the present application provides a computer-readable storage medium storing computer instructions that cause a computer to perform the above-described method.
It will be appreciated by those skilled in the art that embodiments of the present application may be provided as a method, system, or computer program product. Accordingly, the present application may take the form of an entirely hardware embodiment, an entirely software embodiment or an embodiment combining software and hardware aspects. Furthermore, the present application 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 application is described with reference to flowchart illustrations and/or block diagrams of methods, apparatus (systems) and computer program products according to embodiments of the application. It will be understood that each flow and/or block of the flowchart illustrations and/or block diagrams, and combinations of flows and/or blocks in the flowchart illustrations 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 should 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 one … …" does not exclude the presence of other like elements in a process, method, article, or apparatus that comprises the element.
In the description of the present application, numerous specific details are set forth. It may be evident, however, that the embodiments of the present application 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 application, various features of the application 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 construed as reflecting the intention that: i.e., the claimed application 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 application.
The foregoing is merely a specific embodiment of the application and other modifications and variations can be made by those skilled in the art in light of the above teachings. It is to be understood by persons skilled in the art that the foregoing detailed description is provided for the purpose of illustrating the application more fully, and that the scope of the application is defined by the appended claims.
Claims (7)
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 an elastic search of the full-text search engine according to the acquired data;
receiving a query retrieval request containing index template identifiers by using the full-text search engine;
searching a corresponding index template from a plurality of index templates established in advance according to the index template identification, and searching in one or a plurality of different indexes indicated in the index template to obtain a search result; the pre-established index template comprises: the system comprises a full-text search index template, a cross-database index template, a single database index template and a single database table index template, wherein the full-text search index template comprises all indexes, the cross-database index template comprises indexes corresponding to database tables of different databases, and the single database index template comprises indexes corresponding to different database tables in the same database; combining the indexes of the full-text search engine elastic search to generate different index templates for use in query;
the obtaining data from a plurality of database tables with different table structures and correspondingly generating the index of the full text search engine elastic search according to the obtained data comprises the following steps:
acquiring configuration information of databases of service systems to which a plurality of database tables with different table structures belong, acquiring data from the database tables of the corresponding databases according to the configuration information of the databases by using Logstar, analyzing and filtering the acquired data, and correspondingly storing the acquired data into an index of an elastic search of a full-text search engine.
2. The method according to claim 1, characterized in that the method further comprises:
and sending the query search result to a template engine, so that the template engine reads a page template and generates a page according to the query search result and the page template.
3. The method of claim 1, wherein the obtaining data from the database table of the corresponding database using logstack according to the configuration information of the database comprises:
and acquiring data from the database table of the corresponding database by utilizing the logstack through a pre-written SQL script comprising database table query SQL statements.
4. A database query search apparatus, comprising:
the index generation module is used for acquiring data from a plurality of database tables with different table structures and correspondingly generating an index of the full-text search engine elastic search according to the acquired data;
the request receiving module is used for receiving a query retrieval request containing index template identifiers by utilizing the full-text search engine elastic search;
the query retrieval module is used for searching a corresponding index template in a plurality of index templates which are established in advance according to the index template identification, and performing query retrieval in one or a plurality of different indexes indicated in the index templates to obtain a query retrieval result; the pre-established index template comprises: the system comprises a full-text search index template, a cross-database index template, a single database index template and a single database table index template, wherein the full-text search index template comprises all indexes, the cross-database index template comprises indexes corresponding to database tables of different databases, and the single database index template comprises indexes corresponding to different database tables in the same database; combining the indexes of the full-text search engine elastic search to generate different index templates for use in query;
the index generation module is specifically configured to obtain configuration information of databases of the service systems to which the plurality of database tables with different table structures belong, obtain data from the database tables of the corresponding databases according to the configuration information of the databases by using logstack, analyze and filter the obtained data, and store the analyzed and filtered data in an index of the full-text search engine.
5. The apparatus of claim 4, wherein the apparatus further comprises: and the page presentation module is used for sending the query search result to the template engine, so that the template engine reads the page template and generates a page according to the query search result and the page template.
6. The apparatus of claim 4, wherein the index generation module is configured to obtain data from a database table of a corresponding database by using logstack through a pre-written SQL script comprising database table query SQL statements.
7. An electronic device, the electronic device comprising: the memory and the processor are in communication connection through an internal bus, and the memory stores program instructions capable of being executed by the processor, and the program instructions are capable of implementing the method of any one of claims 1-3 when executed by the processor.
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 CN111382226A (en) | 2020-07-07 |
| CN111382226B true 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 (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US12235856B1 (en) | 2024-08-26 | 2025-02-25 | Dropbox, Inc. | Performing unified search using a hybrid search index |
| US12332949B1 (en) | 2024-08-26 | 2025-06-17 | Dropbox, Inc. | Generating a hybrid search index for unified search |
Families Citing this family (20)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111881086B (en) * | 2020-07-23 | 2024-03-19 | 杭州安恒信息技术股份有限公司 | Big data storage method, query method, electronic device and storage medium |
| CN111767303A (en) * | 2020-07-28 | 2020-10-13 | 腾讯科技（深圳）有限公司 | A data query method, device, server and readable storage medium |
| CN111858833A (en) * | 2020-07-29 | 2020-10-30 | 广州海鹚网络科技有限公司 | Asynchronous indexing method, apparatus, computer equipment and storage medium |
| CN112000669B (en) * | 2020-08-14 | 2021-08-03 | 中科三清科技有限公司 | Environment monitoring data processing method and device, storage medium and terminal |
| CN112148938B (en) * | 2020-10-16 | 2023-05-26 | 成都中科大旗软件股份有限公司 | Cross-domain heterogeneous data retrieval system and retrieval method |
| CN114490917A (en) * | 2020-11-11 | 2022-05-13 | 北京神州泰岳软件股份有限公司 | Method and device for realizing full-text retrieval function and electronic equipment |
| CN112417223B (en) * | 2020-11-27 | 2024-06-11 | 亿企赢网络科技有限公司 | 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 |
| CN112612905B (en) * | 2020-12-28 | 2024-07-26 | 南京明略科技有限公司 | Data processing method, system, computer and readable storage medium based on elastic search |
| CN112988863A (en) * | 2021-02-09 | 2021-06-18 | 苏州中科蓝迪软件技术有限公司 | Elasticissearch-based efficient search engine method for heterogeneous multiple data sources |
| CN113377771A (en) * | 2021-06-07 | 2021-09-10 | 广发银行股份有限公司 | Data exploration method, system, equipment and storage medium |
| CN113760952A (en) * | 2021-08-09 | 2021-12-07 | 深圳前海爱客风信息技术有限公司 | Data query method and device, storage medium and electronic device |
| CN115994192A (en) * | 2021-10-18 | 2023-04-21 | 中国移动通信集团贵州有限公司 | Method, device and system for implementing Elasticsearch retrieval in relational database retrieval system |
| CN114153909B (en) * | 2021-11-26 | 2024-06-07 | 北京人大金仓信息技术股份有限公司 | Database table structure translation method and device based on vector template engine |
| CN114138785B (en) * | 2021-11-30 | 2024-07-30 | 中国平安财产保险股份有限公司 | Data retrieval method, device, equipment and storage medium suitable for large data volume |
| CN114490723A (en) * | 2022-02-23 | 2022-05-13 | 阿波罗智联(北京)科技有限公司 | A unified retrieval method, device, electronic device and storage medium |
| CN114564554A (en) * | 2022-03-04 | 2022-05-31 | 中信银行股份有限公司 | Data retrieval method, device and equipment and readable storage medium |
| CN116016240B (en) * | 2022-12-23 | 2025-01-28 | 赛尔网络有限公司 | Network quality monitoring report generation method, device, electronic equipment and medium |
| CN116881391B (en) * | 2023-09-06 | 2024-01-02 | 安徽商信政通信息技术股份有限公司 | Full text retrieval method and system |
| CN117931893A (en) * | 2024-01-25 | 2024-04-26 | 中科世通亨奇(北京)科技有限公司 | Data retrieval method and system based on distributed search engine |
Citations (6)
| 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 | 尤尼瑟奇有限公司 | Systems and methods for searching data sources |
| 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 |
| CN107609154A (en) * | 2017-09-23 | 2018-01-19 | 浪潮软件集团有限公司 | A 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 |
Family Cites Families (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| 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 |
| US8799308B2 (en) * | 2007-10-19 | 2014-08-05 | Oracle International Corporation | Enhance search experience using logical collections |
| US9348870B2 (en) * | 2014-02-06 | 2016-05-24 | International Business Machines Corporation | Searching content managed by a search engine using relational database type queries |
| US10019510B2 (en) * | 2014-07-29 | 2018-07-10 | Ca, Inc. | Indexing and searching log records using templates index and attributes index |
-
2018
- 2018-12-29 CN CN201811641248.0A patent/CN111382226B/en active Active
Patent Citations (6)
| 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 | 尤尼瑟奇有限公司 | Systems and methods for searching data sources |
| 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 |
| CN107609154A (en) * | 2017-09-23 | 2018-01-19 | 浪潮软件集团有限公司 | A 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 (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US12235856B1 (en) | 2024-08-26 | 2025-02-25 | Dropbox, Inc. | Performing unified search using a hybrid search index |
| US12332949B1 (en) | 2024-08-26 | 2025-06-17 | Dropbox, Inc. | Generating a hybrid search index for unified search |
Also Published As
| Publication number | Publication date |
|---|---|
| CN111382226A (en) | 2020-07-07 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN111382226B (en) | Database query and retrieval method and device and electronic equipment | |
| CN109299102B (en) | A HBase secondary index system and method based on Elastcisearch | |
| US10565208B2 (en) | Analyzing multiple data streams as a single data object | |
| CN104182405B (en) | Method and device for connection query | |
| US9165049B2 (en) | Translating business scenario definitions into corresponding database artifacts | |
| CN109446279A (en) | Based on neo4j big data genetic connection management method, system, equipment and storage medium | |
| CN113505128B (en) | Method, device, equipment and storage medium for creating data table | |
| CN111506621B (en) | Data statistical method and device | |
| CN106294695A (en) | A kind of implementation method towards the biggest data search engine | |
| CN109213756A (en) | Data storage, search method, device, server and storage medium | |
| CN113934750A (en) | Data blood relationship analysis method based on compiling mode | |
| CN112579578A (en) | Metadata-based data quality management method, device and system and server | |
| CN103729463A (en) | Method for implementing full-text retrieval based on Lucene and Solr | |
| CN111125199B (en) | Database access method and device and electronic equipment | |
| CN113656469B (en) | Big data processing method and device | |
| CN113779349A (en) | Data retrieval system, apparatus, electronic device, and readable storage medium | |
| US11567957B2 (en) | Incremental addition of data to partitions in database tables | |
| CN109739882A (en) | A kind of big data enquiring and optimizing method based on Presto and Elasticsearch | |
| CN103034650A (en) | System and method for processing data | |
| CN110659283A (en) | Data tag processing method, device, computer equipment and storage medium | |
| CN111177244A (en) | Data association analysis method for multiple heterogeneous databases | |
| CN105787090A (en) | Index building method and system of OLAP system of electric data | |
| CN117472940A (en) | Data blood relationship construction method and device, electronic equipment and storage medium | |
| CN117573734A (en) | Performance optimization method based on real-time data statistics of query large data volume result set | |
| CN113515564A (en) | Data access method, device, equipment and storage medium based on J2EE |
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 | ||
| 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. |
|
| GR01 | Patent grant | ||
| GR01 | Patent grant |