CN115587115A - Database query optimization method and system - Google Patents
Database query optimization method and system Download PDFInfo
- Publication number
- CN115587115A CN115587115A CN202211587212.5A CN202211587212A CN115587115A CN 115587115 A CN115587115 A CN 115587115A CN 202211587212 A CN202211587212 A CN 202211587212A CN 115587115 A CN115587115 A CN 115587115A
- Authority
- CN
- China
- Prior art keywords
- retrieval
- data
- database
- fuzzy
- 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
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2453—Query optimisation
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2458—Special types of queries, e.g. statistical queries, fuzzy queries or distributed queries
- G06F16/2468—Fuzzy queries
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/26—Visual data mining; Browsing structured data
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- Databases & Information Systems (AREA)
- General Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Computational Linguistics (AREA)
- Fuzzy Systems (AREA)
- Mathematical Physics (AREA)
- Software Systems (AREA)
- Automation & Control Theory (AREA)
- Probability & Statistics with Applications (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention relates to the relevant field of database query, and discloses a database query optimization method and a system, wherein the database query optimization method comprises a retrieval space establishing module, a retrieval space mapping module, a characteristic association retrieval module and a data display verification module; by setting a physical optimization space independent of the database, the occupation of a data throughput channel of the database and the occupation of the operational capacity of the database in the retrieval process can be effectively reduced, and meanwhile, a multi-feature contact ratio retrieval method for performing characteristic scattering on the data objects is performed.
Description
Technical Field
The invention relates to the field related to database query, in particular to a database query optimization method and a database query optimization system.
Background
In the field of databases, the query capability of data in the database is one of important items for measuring the database, and in the process of data query, the efficiency of data query is too low, which results in poor feedback response of the whole database and difficulty in meeting the requirement of a user on quick query and acquisition of data content in the database; meanwhile, the data throughput and the occupation of the operational capacity of the database during data query can also affect the experience feedback of the user during the data query process and the healthy consumption rate of the database.
In the data query mode in the prior art, the database is queried and compared without difference through the ' and ' or ' relation of multiple terms of a user, so that a large amount of data throughput and calculation capacity are occupied, and meanwhile, the problem that the required data content cannot be queried correctly due to query result deviation after multiple terms are combined when the terms deviate due to the retrieval mode of the data content.
Disclosure of Invention
The present invention is directed to a database query optimization method and system, so as to solve the problems set forth in the foregoing background art.
In order to achieve the purpose, the invention provides the following technical scheme:
a database query optimization system, comprising:
the retrieval space establishing module is used for establishing a physical optimized space for retrieval, the physical optimized space comprises an optimized storage unit and an optimized retrieval unit, the optimized storage unit is used for storing retrieval characteristics, the optimized retrieval unit is used for responding to a data query instruction from a user to traverse the optimized storage unit, and the physical optimized space is in communication connection with the database;
the retrieval space mapping module is used for establishing data pointing links which are in one-to-one corresponding connection with data in a database and storing the data pointing links in the optimized storage unit, acquiring retrieval characteristics of corresponding data in the database through a characteristic acquisition program, binding the retrieval characteristics with the corresponding data pointing links, and merging the retrieval characteristics with the same content, wherein the retrieval characteristics comprise title characteristics, content characteristics and user mark characteristics of the data;
the characteristic correlation retrieval module is used for acquiring a data query instruction from a user, wherein the data query instruction comprises a plurality of groups of retrieval characteristics, traversing the optimized storage unit in sequence based on the retrieval characteristics to acquire a plurality of data pointing links, and performing traversal response counting on the data pointing links through a retrieval counter to generate a correlation retrieval result;
and the data display verification module is used for performing descending order on a plurality of data pointing links in the associated retrieval result based on the result of the traversal response count, acquiring partial content of corresponding data in a database through the data pointing links to generate verification preview, outputting the verification preview and receiving query confirmation feedback from a user.
As a further scheme of the invention: the retrieval space mapping module comprises:
the media characteristic acquisition module is used for identifying the media contents through a preset media object identification program, acquiring element content constitution of the media images, and setting characteristic ratio for corresponding retrieval characteristics based on the matching degree of the element contents and comparison elements in a preset identification library, wherein each comparison element comprises a plurality of retrieval characteristics, different retrieval characteristics of the same comparison element are used for distinguishing different expression modes, and the characteristic ratio is used for endowing a counting coefficient when traversing response counting is carried out.
As a further scheme of the invention: the feature association retrieval module comprises:
and the additional screening unit is used for receiving additional query conditions from a user and screening the data pointing links based on the additional query conditions, the additional query conditions are independent of the retrieval characteristics and act on each data pointing link and the database data, and the additional query conditions comprise time information, a file uploading object, a file type and a file data volume.
As a further scheme of the invention: still include the characteristic fuzzy module, the characteristic fuzzy module specifically includes:
the word fuzzy unit is used for carrying out word fuzzy on the retrieval characteristics, acquiring the retrieval characteristics close to the character expression of the retrieval characteristics as fuzzy retrieval characteristics, and carrying out characteristic ratio assignment on the fuzzy retrieval characteristics based on the coincidence degree of the character expression and the retrieval characteristics;
and the word meaning fuzzy unit is used for carrying out word meaning fuzzy on the retrieval characteristics, acquiring the retrieval characteristics which are close to the character expression of the retrieval characteristics as fuzzy retrieval characteristics, and carrying out characteristic ratio assignment on the fuzzy retrieval characteristics based on a preset word meaning fuzzy level library, wherein the word meaning fuzzy level library comprises a plurality of similar vocabulary storage spaces respectively corresponding to different characteristic ratios.
As a further scheme of the invention: the system also comprises an object association module;
the object association module is used for establishing retrieval feature association trees of different users based on retrieval preferences of different users and final results of query confirmation feedback, and the retrieval feature association trees are used for representing the association between retrieval features which are not input by other users possibly contained in the retrieved object when the user retrieves through a certain retrieval feature.
The embodiment of the invention aims to provide a database query optimization method, which comprises the following steps:
constructing a retrieved physical optimization space, wherein the physical optimization space comprises an optimization storage unit and an optimization retrieval unit, the optimization storage unit is used for storing retrieval characteristics, the optimization retrieval unit is used for responding to a data query instruction from a user to traverse the optimization storage unit, and the physical optimization space is in communication connection with a database;
establishing data pointing links which are in one-to-one corresponding connection with data in a database and storing the data pointing links in the optimized storage unit, acquiring retrieval characteristics of corresponding data in the database through a characteristic acquisition program, binding the retrieval characteristics with the corresponding data pointing links, and combining the retrieval characteristics with the same content, wherein the retrieval characteristics comprise a title characteristic, a content characteristic and a user mark characteristic of the data;
acquiring a data query instruction from a user, wherein the data query instruction comprises a plurality of groups of retrieval characteristics, traversing the optimized storage unit in sequence based on the retrieval characteristics to acquire a plurality of data pointing links, and traversing response counting is performed on the data pointing links through a retrieval counter to generate an associated retrieval result;
and performing descending order arrangement on a plurality of data pointing links in the associated retrieval result based on the result of the traversal response count, acquiring partial content of corresponding data in a database through the data pointing links to generate a verification preview, outputting the verification preview and receiving query confirmation feedback from a user.
As a further scheme of the invention: the step of obtaining the retrieval characteristics of the corresponding data in the database through the characteristic obtaining program comprises the following steps:
the media content is identified through a preset media object identification program, the element content constitution of the media image is obtained, feature occupation ratios are set for corresponding retrieval features based on the matching degree of the element content and comparison elements in a preset identification library, each comparison element comprises a plurality of retrieval features, different retrieval features of the same comparison element are used for distinguishing different expression modes, and the feature occupation ratios are used for endowing counting coefficients when traversing response counting is carried out.
As a still further scheme of the invention: further comprising the additional retrieval step of:
receiving additional query conditions from a user, and screening the data pointing links based on the additional query conditions, wherein the additional query conditions are independent of the retrieval characteristics and act on each data pointing link and database data, and the additional query conditions comprise time information, file uploading objects, file types and file data volumes.
As a further scheme of the invention: further comprising the steps of:
carrying out vocabulary fuzzy on the retrieval characteristics, acquiring the retrieval characteristics close to the character expression of the retrieval characteristics as fuzzy retrieval characteristics, and carrying out characteristic ratio assignment on the fuzzy retrieval characteristics based on the coincidence degree of the character expression and the retrieval characteristics;
and carrying out word sense fuzzy on the retrieval characteristics, acquiring the retrieval characteristics close to the character expression of the retrieval characteristics as fuzzy retrieval characteristics, and carrying out characteristic ratio assignment on the fuzzy retrieval characteristics based on a preset word sense fuzzy level library, wherein the word sense fuzzy level library comprises a plurality of similar vocabulary storage spaces respectively corresponding to different characteristic ratios.
As a further scheme of the invention: further comprising the steps of:
and establishing a retrieval feature association tree of different users based on the retrieval preference of the different users and the final result of the query confirmation feedback, wherein the retrieval feature association tree is used for representing the association between other users possibly contained in the retrieved object and the uninput retrieval features when the user retrieves through a certain retrieval feature.
Compared with the prior art, the invention has the beneficial effects that: by setting a physical optimization space independent of the database, the occupation of a database data throughput channel and the occupation of the operational capacity of the database in the retrieval process can be effectively reduced, and meanwhile, a multi-feature overlap ratio retrieval method for performing feature scattering on the data objects is carried out.
Drawings
FIG. 1 is a block diagram of a database query optimization system.
FIG. 2 is a block diagram of a feature obfuscation module in a database query optimization system.
FIG. 3 is a flow chart diagram of a database query optimization method.
Detailed Description
In order to make the objects, technical solutions and advantages of the present invention more apparent, the present invention is further described in detail below with reference to the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are merely illustrative of the invention and are not intended to limit the invention.
The following detailed description of specific embodiments of the present invention is provided in connection with specific embodiments.
As shown in fig. 1, a database query optimization system provided for an embodiment of the present invention includes:
the retrieval space establishing module 100 is configured to construct a physical optimized space for retrieval, where the physical optimized space includes an optimized storage unit and an optimized retrieval unit, the optimized storage unit is used to store retrieval characteristics, the optimized retrieval unit is used to respond to a data query instruction from a user to traverse the optimized storage unit, and the physical optimized space is in communication connection with the database.
The retrieval space mapping module 300 is configured to establish data pointing links in one-to-one correspondence with data in a database, store the data pointing links in the optimized storage unit, obtain retrieval characteristics of corresponding data in the database through a characteristic obtaining program, bind the retrieval characteristics with the corresponding data pointing links, and merge the retrieval characteristics having the same content, where the retrieval characteristics include a title characteristic, a content characteristic, and a user mark characteristic of the data.
The feature association retrieval module 500 is configured to obtain a data query instruction from a user, where the data query instruction includes multiple groups of retrieval features, sequentially traverse the optimized storage unit based on the retrieval features, obtain multiple data pointing links, and perform traversal response counting on the data pointing links through a retrieval counter to generate an association retrieval result.
The data display verification module 700 is configured to perform descending order arrangement on a plurality of data pointing links in the associated search result based on the result of the traversal response count, acquire partial content of corresponding data in a database through the data pointing links to generate a verification preview, output the verification preview, and receive query confirmation feedback from a user.
In the embodiment, a data query optimization system is provided, and by setting a physical optimization space independent of a database, occupation of a database data throughput channel and occupation of database computing capacity in a retrieval process can be effectively reduced, and meanwhile, a multi-feature overlap ratio retrieval method for performing feature scattering on data objects is performed, so that on the basis of feature merging, the retrieval data amount in the retrieval process can be greatly reduced, the retrieval efficiency is improved, and a large number of feature-conforming data objects can be obtained in a short time and are subjected to combined screening; specifically, a physical optimization space connected in parallel with a database is established, when new data are stored in the database, retrieval characteristics (data characteristics, such as keywords of titles, content keywords of data bodies or high-frequency vocabularies and the like) are acquired, a data direction link connected with the data in the database is established and bound with each characteristic, and the characteristics and the same characteristics in the physical optimization space are combined.
As another preferred embodiment of the present invention, the search space mapping module 300 includes:
the media feature acquisition module is used for identifying the media content through a preset media object identification program, acquiring element content constitution of the media image, and setting feature ratio for corresponding retrieval features based on the matching degree of the element content and comparison elements in a preset identification library, wherein each comparison element comprises a plurality of retrieval features, different retrieval features of the same comparison element are used for distinguishing different expression modes, and the feature ratio is used for endowing a counting coefficient when traversing response counting is carried out.
In this embodiment, the retrieval space mapping module 300 is supplemented with a media feature obtaining module, which is set depending on data types, because data of media types (mainly referred to as image media and video media, where video media may be regarded as continuous multiple groups of picture media) are different from data contents of types such as basic texts, and retrieval features (i.e., keywords of contents) of the data are uncertain, and for the same image element, expression manners of the keywords may be multiple, and expression manners of similar elements may also be similar, so that special content element identification and keyword extraction need to be performed, and each element corresponds to multiple keywords, and different similar expression manners should also set a certain feature proportion for expressing a coincidence degree of the two, so as to perform coefficient multiplication during query retrieval, and improve reliability of data generated in a counting process.
As another preferred embodiment of the present invention, the feature association retrieving module 500 includes:
and the additional screening unit is used for receiving additional query conditions from a user and screening the data pointing links based on the additional query conditions, the additional query conditions are independent of the retrieval characteristics and act on each data pointing link and the database data, and the additional query conditions comprise time information, a file uploading object, a file type and a file data volume.
In this embodiment, the additional filtering unit may narrow the range of the search by setting the additional query condition, for example, setting the time range of the search data object, which may greatly reduce the amount of the search data and effectively improve the success rate of the search.
As shown in fig. 2, as another preferred embodiment of the present invention, the present invention further includes a feature obfuscation module 900, where the feature obfuscation module 900 specifically includes:
a vocabulary fuzzy unit 901, configured to perform vocabulary fuzzy on the search features, acquire the search features similar to the text expression of the search features as fuzzy search features, and perform feature ratio assignment on the fuzzy search features based on the coincidence degree of the text expression and the search features.
A word sense fuzzy unit 902, configured to perform word sense fuzzy on the search features, acquire the search features similar to the text expression of the search features as fuzzy search features, and perform feature ratio assignment on the fuzzy search features based on a preset word sense fuzzy level library, where the word sense fuzzy level library includes a plurality of similar vocabulary storage spaces respectively corresponding to different feature ratios.
In this embodiment, the feature fuzzy module 900 is used to perform fuzzy association on words input by a user during a retrieval process, and may be used to expand a retrieval range and improve a success rate of retrieving corresponding contents when the user memorizes a wrong or inaccurate content of data to be retrieved.
As another preferred embodiment of the present invention, the present invention further comprises an object association module;
the object association module is used for establishing retrieval feature association trees of different users based on retrieval preferences of the different users and final results of query confirmation feedback, and the retrieval feature association trees are used for representing the association between retrieval features which are not input by other users possibly contained in the retrieved object when the user retrieves through a certain retrieval feature.
In this embodiment, the object association module is set for different users, and according to the search query habit of the user, an association tree of search keywords belonging to the user can be established, so that the fuzzy accuracy of system association in the search query process can be improved.
As shown in fig. 3, the present invention further provides a database query optimization method, which comprises the steps of:
s200, constructing a physical optimization space for retrieval, wherein the physical optimization space comprises an optimization storage unit and an optimization retrieval unit, the optimization storage unit is used for storing retrieval characteristics, the optimization retrieval unit is used for responding to a data query instruction from a user to traverse the optimization storage unit, and the physical optimization space is in communication connection with a database.
S400, establishing data pointing links in one-to-one corresponding connection with data in a database, storing the data pointing links in the optimized storage unit, acquiring retrieval characteristics of corresponding data in the database through a characteristic acquisition program, binding the retrieval characteristics with the corresponding data pointing links, and merging the retrieval characteristics with the same content, wherein the retrieval characteristics comprise a title characteristic, a content characteristic and a user mark characteristic of the data.
S600, a data query instruction from a user is obtained, the data query instruction comprises a plurality of groups of retrieval characteristics, the optimized storage unit is traversed in sequence based on the retrieval characteristics, a plurality of data pointing links are obtained, traversal response counting is conducted on the data pointing links through a retrieval counter, and a correlation retrieval result is generated.
S800, based on the result of the traversal response counting, performing descending order arrangement on a plurality of data pointing links in the associated retrieval result, acquiring partial content of corresponding data in a database through the data pointing links to generate verification preview, outputting the verification preview and receiving query confirmation feedback from a user.
As another preferred embodiment of the present invention, the step of obtaining the retrieval characteristics of the corresponding data in the database by the characteristic obtaining program includes:
the media content is identified through a preset media object identification program, the element content constitution of the media image is obtained, feature occupation ratios are set for corresponding retrieval features based on the matching degree of the element content and comparison elements in a preset identification library, each comparison element comprises a plurality of retrieval features, different retrieval features of the same comparison element are used for distinguishing different expression modes, and the feature occupation ratios are used for endowing counting coefficients when traversing response counting is carried out.
As another preferred embodiment of the present invention, in the step of generating the associated search result, an additional search step is further included:
receiving additional query conditions from a user, and screening the data pointing links based on the additional query conditions, wherein the additional query conditions are independent of the retrieval characteristics and act on each data pointing link and database data, and the additional query conditions comprise time information, file uploading objects, file types and file data volumes.
As another preferred embodiment of the present invention, further comprising the steps of:
and carrying out vocabulary fuzzy on the retrieval characteristics, acquiring the retrieval characteristics close to the character expression of the retrieval characteristics as fuzzy retrieval characteristics, and carrying out characteristic proportion assignment on the fuzzy retrieval characteristics based on the coincidence degree of the character expression and the retrieval characteristics.
And carrying out word sense fuzzy on the retrieval characteristics, acquiring the retrieval characteristics close to the character expression of the retrieval characteristics as fuzzy retrieval characteristics, and carrying out characteristic ratio assignment on the fuzzy retrieval characteristics based on a preset word sense fuzzy level library, wherein the word sense fuzzy level library comprises a plurality of similar vocabulary storage spaces respectively corresponding to different characteristic ratios.
As another preferred embodiment of the present invention, further comprising the steps of:
and establishing a retrieval feature association tree of different users based on the retrieval preference of the different users and the final result of the query confirmation feedback, wherein the retrieval feature association tree is used for representing the association between other users possibly contained in the retrieved object and the uninput retrieval features when the user retrieves through a certain retrieval feature.
It will be understood by those skilled in the art that all or part of the processes of the methods of the embodiments described above can be implemented by a computer program, which can be stored in a non-volatile computer-readable storage medium, and can include the processes of the embodiments of the methods described above when the program is executed. Any reference to memory, storage, database, or other medium used in the embodiments provided herein may include non-volatile and/or volatile memory, among others. Non-volatile memory can include read-only memory (ROM), programmable ROM (PROM), electrically Programmable ROM (EPROM), electrically Erasable Programmable ROM (EEPROM), or flash memory. Volatile memory can include Random Access Memory (RAM) or external cache memory. By way of illustration and not limitation, RAM is available in a variety of forms such as Static RAM (SRAM), dynamic RAM (DRAM), synchronous DRAM (SDRAM), double Data Rate SDRAM (DDRSDRAM), enhanced SDRAM (ESDRAM), synchronous Link DRAM (SLDRAM), rambus (Rambus) direct RAM (RDRAM), direct memory bus dynamic RAM (DRDRAM), and memory bus dynamic RAM (RDRAM).
Other embodiments of the disclosure will be apparent to those skilled in the art from consideration of the specification and practice of the disclosure herein. This application is intended to cover any variations, uses, or adaptations of the disclosure following, in general, the principles of the disclosure and including such departures from the present disclosure as come within known or customary practice in the art to which the disclosure pertains. It is intended that the specification and examples be considered as exemplary only, with a true scope and spirit of the disclosure being indicated by the following claims.
It will be understood that the present disclosure is not limited to the precise arrangements that have been described above and shown in the drawings, and that various modifications and changes may be made without departing from the scope thereof. The scope of the present disclosure is limited only by the appended claims.
Claims (10)
1. A database query optimization system, comprising:
the system comprises a retrieval space establishing module, a database searching module and a searching module, wherein the retrieval space establishing module is used for establishing a physical optimized space for retrieval, the physical optimized space comprises an optimized storage unit and an optimized retrieval unit, the optimized storage unit is used for storing retrieval characteristics, the optimized retrieval unit is used for responding to a data query instruction from a user to traverse the optimized storage unit, and the physical optimized space is in communication connection with the database;
the retrieval space mapping module is used for establishing data pointing links which are in one-to-one corresponding connection with data in a database and storing the data pointing links in the optimized storage unit, acquiring retrieval characteristics of corresponding data in the database through a characteristic acquisition program, binding the retrieval characteristics with the corresponding data pointing links, and merging the retrieval characteristics with the same content, wherein the retrieval characteristics comprise title characteristics, content characteristics and user mark characteristics of the data;
the characteristic correlation retrieval module is used for acquiring a data query instruction from a user, wherein the data query instruction comprises a plurality of groups of retrieval characteristics, traversing the optimized storage unit in sequence based on the retrieval characteristics to acquire a plurality of data pointing links, and performing traversal response counting on the data pointing links through a retrieval counter to generate a correlation retrieval result;
and the data display verification module is used for performing descending order arrangement on a plurality of data pointing links in the associated retrieval result based on the result of the traversal response counting, acquiring partial content of corresponding data in a database through the data pointing links to generate verification preview, outputting the verification preview and receiving query confirmation feedback from a user.
2. The database query optimization system of claim 1, wherein the search space mapping module comprises:
the media feature acquisition module is used for identifying the media content through a preset media object identification program, acquiring element content constitution of the media image, and setting feature ratio for corresponding retrieval features based on the matching degree of the element content and comparison elements in a preset identification library, wherein each comparison element comprises a plurality of retrieval features, different retrieval features of the same comparison element are used for distinguishing different expression modes, and the feature ratio is used for endowing a counting coefficient when traversing response counting is carried out.
3. The database query optimization system of claim 2, wherein the feature association retrieval module comprises:
and the additional screening unit is used for receiving an additional query condition from a user and screening the data pointing links based on the additional query condition, wherein the additional query condition is independent of the retrieval characteristics and acts on each data pointing link and the database data, and the additional query condition comprises time information, a file uploading object, a file type and a file data volume.
4. The database query optimization system according to claim 3, further comprising a feature fuzzy module, wherein the feature fuzzy module specifically comprises:
the word fuzzy unit is used for carrying out word fuzzy on the retrieval characteristics, acquiring the retrieval characteristics close to the character expression of the retrieval characteristics as fuzzy retrieval characteristics, and carrying out characteristic proportion assignment on the fuzzy retrieval characteristics based on the coincidence degree of the character expression and the retrieval characteristics;
and the word meaning fuzzy unit is used for carrying out word meaning fuzzy on the retrieval characteristics, acquiring the retrieval characteristics which are close to the character expression of the retrieval characteristics as fuzzy retrieval characteristics, and carrying out characteristic ratio assignment on the fuzzy retrieval characteristics based on a preset word meaning fuzzy level library, wherein the word meaning fuzzy level library comprises a plurality of similar vocabulary storage spaces respectively corresponding to different characteristic ratios.
5. The database query optimization system of claim 1, further comprising an object association module;
the object association module is used for establishing retrieval feature association trees of different users based on retrieval preferences of the different users and final results of query confirmation feedback, and the retrieval feature association trees are used for representing the association between retrieval features which are not input by other users possibly contained in the retrieved object when the user retrieves through a certain retrieval feature.
6. A method for optimizing a database query, comprising the steps of:
constructing a retrieved physical optimization space, wherein the physical optimization space comprises an optimization storage unit and an optimization retrieval unit, the optimization storage unit is used for storing retrieval characteristics, the optimization retrieval unit is used for responding to a data query instruction from a user to traverse the optimization storage unit, and the physical optimization space is in communication connection with a database;
establishing data pointing links in one-to-one corresponding connection with data in a database and storing the data pointing links in the optimized storage unit, acquiring retrieval characteristics of corresponding data in the database through a characteristic acquisition program, binding the retrieval characteristics with the corresponding data pointing links, and merging the retrieval characteristics with the same content, wherein the retrieval characteristics comprise a title characteristic, a content characteristic and a user mark characteristic of the data;
acquiring a data query instruction from a user, wherein the data query instruction comprises a plurality of groups of retrieval characteristics, traversing the optimized storage unit in sequence based on the retrieval characteristics to acquire a plurality of data pointing links, and traversing response counting is performed on the data pointing links through a retrieval counter to generate an associated retrieval result;
and performing descending order arrangement on a plurality of data pointing links in the associated retrieval result based on the result of the traversal response count, acquiring partial content of corresponding data in a database through the data pointing links to generate a verification preview, outputting the verification preview and receiving query confirmation feedback from a user.
7. The method according to claim 6, wherein the step of obtaining the search features of the corresponding data in the database by the feature obtaining program comprises:
the media content is identified through a preset media object identification program, the element content constitution of the media image is obtained, feature proportion is set for corresponding retrieval features based on the matching degree of the element content and comparison elements in a preset identification library, each comparison element comprises a plurality of retrieval features, different retrieval features of the same comparison element are used for distinguishing different expression modes, and the feature proportion is used for endowing a counting coefficient when traversing response counting is carried out.
8. The database query optimization method of claim 7, further comprising the additional retrieval step of:
receiving an additional query condition from a user, and screening the data pointing links based on the additional query condition, wherein the additional query condition is independent of the retrieval characteristics and acts on each data pointing link and database data, and the additional query condition comprises time information, a file uploading object, a file type and a file data volume.
9. The database query optimization method according to claim 8, further comprising the steps of:
carrying out vocabulary fuzzy on the retrieval characteristics, acquiring the retrieval characteristics close to the character expression of the retrieval characteristics as fuzzy retrieval characteristics, and carrying out characteristic ratio assignment on the fuzzy retrieval characteristics based on the coincidence degree of the character expression and the retrieval characteristics;
and carrying out word sense fuzzy on the retrieval characteristics, acquiring the retrieval characteristics close to the character expression of the retrieval characteristics as fuzzy retrieval characteristics, and carrying out characteristic ratio assignment on the fuzzy retrieval characteristics based on a preset word sense fuzzy level library, wherein the word sense fuzzy level library comprises a plurality of similar vocabulary storage spaces respectively corresponding to different characteristic ratios.
10. The database query optimization method according to claim 6, further comprising the steps of:
and establishing a retrieval feature association tree of different users based on the retrieval preference of different users and the final result of query confirmation feedback, wherein the retrieval feature association tree is used for representing the association between the retrieval features which are not input by other users possibly contained in the object to be retrieved when the user retrieves through a certain retrieval feature.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202211587212.5A CN115587115B (en) | 2022-12-12 | 2022-12-12 | Database query optimization method and system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202211587212.5A CN115587115B (en) | 2022-12-12 | 2022-12-12 | Database query optimization method and system |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN115587115A true CN115587115A (en) | 2023-01-10 |
| CN115587115B CN115587115B (en) | 2023-02-28 |
Family
ID=84782998
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202211587212.5A Active CN115587115B (en) | 2022-12-12 | 2022-12-12 | Database query optimization method and system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN115587115B (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN116151370A (en) * | 2023-04-24 | 2023-05-23 | 西南石油大学 | Model parameter optimization selection system |
Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20110295839A1 (en) * | 2010-05-27 | 2011-12-01 | Salesforce.Com, Inc. | Optimizing queries in a multi-tenant database system environment |
| CN105912649A (en) * | 2016-04-08 | 2016-08-31 | 南京邮电大学 | Database fuzzy retrieval method and system |
| CN107077512A (en) * | 2015-03-28 | 2017-08-18 | 华为技术有限公司 | Optimize the system and method for the inquiry on view |
| CN109977334A (en) * | 2019-03-26 | 2019-07-05 | 浙江度衍信息技术有限公司 | Retrieval rate optimization method |
| CN111339244A (en) * | 2020-02-29 | 2020-06-26 | 山东浪潮通软信息科技有限公司 | Tax policy and regulation inquiry method, computer equipment and storage medium |
| CN113407807A (en) * | 2020-12-15 | 2021-09-17 | 腾讯科技（深圳）有限公司 | Query optimization method and device for search engine and electronic equipment |
| CN113934869A (en) * | 2021-09-23 | 2022-01-14 | 阿里云计算有限公司 | Database construction method, multimedia file retrieval method and device |
-
2022
- 2022-12-12 CN CN202211587212.5A patent/CN115587115B/en active Active
Patent Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20110295839A1 (en) * | 2010-05-27 | 2011-12-01 | Salesforce.Com, Inc. | Optimizing queries in a multi-tenant database system environment |
| CN107077512A (en) * | 2015-03-28 | 2017-08-18 | 华为技术有限公司 | Optimize the system and method for the inquiry on view |
| CN105912649A (en) * | 2016-04-08 | 2016-08-31 | 南京邮电大学 | Database fuzzy retrieval method and system |
| CN109977334A (en) * | 2019-03-26 | 2019-07-05 | 浙江度衍信息技术有限公司 | Retrieval rate optimization method |
| CN111339244A (en) * | 2020-02-29 | 2020-06-26 | 山东浪潮通软信息科技有限公司 | Tax policy and regulation inquiry method, computer equipment and storage medium |
| CN113407807A (en) * | 2020-12-15 | 2021-09-17 | 腾讯科技（深圳）有限公司 | Query optimization method and device for search engine and electronic equipment |
| CN113934869A (en) * | 2021-09-23 | 2022-01-14 | 阿里云计算有限公司 | Database construction method, multimedia file retrieval method and device |
Non-Patent Citations (3)
| Title |
|---|
| J. GRANT ET AL.: "Logic-based query optimization for object databases" * |
| 樊敏: "基于分布式关系型数据库的查询算法优化", 《中国优秀硕士学位论文全文数据库 (信息科技辑)》 * |
| 罗光红: "分布式面向对象数据库的查询优化及应用研究", 《中国优秀硕士学位论文全文数据库 (信息科技辑)》 * |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN116151370A (en) * | 2023-04-24 | 2023-05-23 | 西南石油大学 | Model parameter optimization selection system |
Also Published As
| Publication number | Publication date |
|---|---|
| CN115587115B (en) | 2023-02-28 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN108921221B (en) | User feature generation method, device, equipment and storage medium | |
| CN108304530B (en) | Knowledge base entry classification method and device and model training method and device | |
| CN112527970B (en) | Data dictionary standardization processing method, device, equipment and storage medium | |
| CN110362798B (en) | Method, apparatus, computer device and storage medium for judging information retrieval analysis | |
| CN113535817B (en) | Feature broad table generation and service processing model training method and device | |
| CN115587115B (en) | Database query optimization method and system | |
| CN116431837B (en) | Document retrieval method and device based on large language model and graph network model | |
| CN112286934A (en) | Database table importing method, device, equipment and medium | |
| CN112560444A (en) | Text processing method and device, computer equipment and storage medium | |
| CN112070550A (en) | Keyword determination method, device and equipment based on search platform and storage medium | |
| CN111382570A (en) | Text entity recognition method and device, computer equipment and storage medium | |
| CN113626571A (en) | Answer sentence generating method and device, computer equipment and storage medium | |
| CN115422372A (en) | Knowledge graph construction method and system based on software test | |
| RU2015129559A (en) | SYSTEM AND METHOD FOR SEARCHING A RECENTLY PREFERRED NON-TEXT ELEMENT | |
| Hess et al. | C-salt: Mining class-specific alterations in boolean matrix factorization | |
| CN115577694B (en) | Intelligent recommendation method for standard writing | |
| CN116932694A (en) | Intelligent retrieval method, device and storage medium for knowledge base | |
| CN114003685B (en) | Word segmentation position index construction method and device, and document retrieval method and device | |
| CN110781404A (en) | Friend relationship chain matching method, system, computer equipment and readable storage medium | |
| CN114036371A (en) | Search term recommendation method, device, equipment and computer-readable storage medium | |
| CN111340580A (en) | Method and device for determining house type, computer equipment and storage medium | |
| CN114491197B (en) | Database expansion method and device based on big data | |
| KR102419956B1 (en) | Method for automatically generating metadata for structured data and apparatus for generating metadata using a machine learning/deep learning model for the same | |
| CN116955300B (en) | File generation method and system based on label technology | |
| WO2024069941A1 (en) | Information processing device, search method, and search program |
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 | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |