CN108319620A - A kind of method preventing database index entanglement, system, device and storage medium - Google Patents
A kind of method preventing database index entanglement, system, device and storage medium Download PDFInfo
- Publication number
- CN108319620A CN108319620A CN201710036801.7A CN201710036801A CN108319620A CN 108319620 A CN108319620 A CN 108319620A CN 201710036801 A CN201710036801 A CN 201710036801A CN 108319620 A CN108319620 A CN 108319620A
- Authority
- CN
- China
- Prior art keywords
- slowly
- record
- structured query
- index
- sql
- 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.)
- Pending
Links
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/21—Design, administration or maintenance of databases
- G06F16/217—Database tuning
-
- 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/22—Indexing; Data structures therefor; Storage structures
- G06F16/2228—Indexing structures
-
- 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/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/284—Relational databases
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Software Systems (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The present invention relates to a kind of method preventing database index entanglement, system, device and storage mediums.The method of the present invention includes：Sql files are obtained, and record the slow inquiry in the sql files；Judge in index management system with the presence or absence of corresponding to the record inquired slowly；If in the presence of in the database by the slow inquiry record；Otherwise, the explanation results inquired slowly are compared with optimal explanation results, judge exception and send out alarm.
Description
Technical field
The present invention relates to technical field of the computer network more particularly to a kind of preventing the method for database index entanglement, be
System, device and storage medium.
Background technology
If database is not arranged for a long time, then it is possible that indexing entanglement, and then cause database pressure prominent
So drastically increase.And since this situation is more uncommon, majority of case cannot position abnormal position at once, to meeting
Delay the long period in positioning, seriously affects the performance of inline system.
But there is no this automatic discoveries to index entanglement at present, and carry out the method for alerting or voluntarily handling.It is big susceptible
When being that application system is slack-off or unavailable under condition, dba (database administrator), dba is given to pass through the row of some row condition feedback
It looks into, is likely to navigate to abnormal position.This cannot not only pinpoint the problems in time alert or voluntarily handle, and can't carry out
Large-scale management.
Invention content
In view of this, the present invention provides a kind of method preventing database index entanglement, system, device and storage medium,
Can automatic decision go out exception and send out alarm, and then solve cannot pinpoint the problems in time, navigate to abnormal position with
And the problem of alarm.
To achieve the above object, according to an aspect of the invention, there is provided a kind of side preventing database index entanglement
Method.
The method of the present invention includes：Sql files are obtained, and record the slow inquiry in the sql files；Judge index management
With the presence or absence of corresponding to the record inquired slowly in system；If being not present, in the database by the slow inquiry record；It is no
Then, the explanation results inquired slowly are compared with optimal explanation results, judge exception and send out alarm.
Optionally, method of the invention further includes：Syntactic analysis is carried out to the slow inquiry and extracts trunk processing；According to
Trunk is extracted treated slow inquiry, judges in index management system with the presence or absence of corresponding to the record inquired slowly.
Optionally, method of the invention further includes：By the explanation of structured query sentence and the structured query sentence
As a result it carries out being entered into index management system；Syntactic analysis is carried out to the structured query sentence and extracts trunk processing；It will
The explanation results of the structured query sentence are added in the corresponding record of index management system；And adjust the structuring
The optimal explanation results of structured query sentence after adjustment are saved in index management system by query statement.
Optionally, method of the invention further includes：The interval time for reading sql files is set, by the interval time
Afterwards, sql files are read automatically and record the slow inquiry in the sql files.
Optionally, method of the invention further includes：According to abnormal judging result, operation automatically processes order, deletion and institute
It states and inquires related all threads slowly.
Optionally, method of the invention further includes：Operation order show processlist, check the shape of each thread
State；It finds out and inquires related all threads slowly with described；Cycle executes kill thread id orders, has with the slow inquiry to delete
All threads closed.
According to another aspect of the present invention, a kind of system preventing database index entanglement is provided.
The present invention system include：Logging modle for obtaining sql files, and records looking into slowly in the sql files
It askes；Analysis and alarm module, for judging in index management module with the presence or absence of corresponding to the record inquired slowly；If not depositing
Then in the database by the slow inquiry record；Otherwise, the explanation results inquired slowly and optimal explanation results are carried out
Compare, judge exception and sends out alarm.Index management module, for storing and managing and inquire relevant record slowly.
Optionally, analysis module and alarm are additionally operable to：Syntactic analysis is carried out to the slow inquiry and extracts trunk processing；Root
According to extracting trunk treated slow inquiry, judge whether there is corresponding to the record inquired slowly.
Optionally, the index management module includes：Typing unit is used for structured query sentence and the structuring
The explanation results of query statement carry out typing；Processing unit, for carrying out syntactic analysis and pumping to the structured query sentence
Trunk is taken to handle；And the explanation results of the structured query sentence are added in corresponding record；Optimal explanation results
Acquiring unit, for adjusting the structured query sentence, by the optimal explanation results of the structured query sentence after adjustment into
Row preserves.
Optionally, system of the invention further includes setup module, when reading the interval of sql files for logging modle to be arranged
Between, after the interval time, logging modle reads sql files and records the slow inquiry in the sql files automatically.
Optionally, system of the invention further includes automatically process module, for according to abnormal judging result, running automatic place
Reason order, deletes and inquires related all threads slowly with described.
Optionally, automatically process module is additionally operable to operation order show processlist, checks the state of each thread；
It finds out and inquires related all threads slowly with described；Cycle execute kill thread id orders, with delete it is described inquire slowly it is related
All threads.
According to another aspect of the present invention, a kind of device preventing database index entanglement is provided.
The inventive system comprises at least one processors；And the storage at least one processor communication connection
Device；Wherein, the memory stores the instruction executed by one processor, and described instruction is by least one processor
It executes, so that at least one processor is able to carry out any one of above-mentioned method for preventing database index entanglement side
Method.
According to another aspect of the present invention, providing a kind of prevents the non-transient computer of database index entanglement is readable from depositing
Storage media.
The non-transient computer readable storage medium of the present invention stores computer instruction, and the computer instruction is for making institute
It states computer and executes any one of the above-mentioned method for preventing database index entanglement method.
According to the technique and scheme of the present invention, by recording the slow inquiry (slow sql) in the sql files obtained, lead to
It crosses and whether there is corresponding record in judgement index management system, if being not present, by the explanation results inquired slowly and optimal explanation
As a result it is compared, judges exception and sends out alarm.The technical program can be by automatically recording slow inquiry, and then can be to big
Exception sql carries out automatic unified monitoring in scale mysql, pinpoints the problems in time, and by that will inquire slowly and index management system
Record multilevel iudge in system can will orient the abnormal position of abnormal sql, and send out alarm.To effective solution
The problem of cannot pinpointing the problems in time, and abnormal position cannot be navigated to, cannot alerting.
Further effect possessed by above-mentioned non-usual optional mode adds hereinafter in conjunction with specific implementation mode
With explanation.
Description of the drawings
Attached drawing does not constitute inappropriate limitation of the present invention for more fully understanding the present invention.Wherein：
Fig. 1 is a kind of schematic diagram of method key step for preventing database index entanglement according to the ... of the embodiment of the present invention；
Fig. 2 is a kind of schematic diagram of system main modular for preventing database index entanglement according to the ... of the embodiment of the present invention；
Fig. 3 is a kind of schematic diagram of device for preventing database index entanglement according to the ... of the embodiment of the present invention；
Fig. 4 is a kind of hardware architecture diagram of device for preventing database index entanglement according to the ... of the embodiment of the present invention.
Specific implementation mode
It explains to the exemplary embodiment of the present invention below in conjunction with attached drawing, including the various of the embodiment of the present invention
Details should think them only exemplary to help understanding.Therefore, those of ordinary skill in the art should recognize
It arrives, various changes and modifications can be made to the embodiments described herein, without departing from scope and spirit of the present invention.Together
The description to known function and structure is omitted for clarity and conciseness in sample in following description.
Fig. 1 is a kind of schematic diagram of method key step for preventing database index entanglement according to the ... of the embodiment of the present invention.
As shown in Figure 1, a kind of of the embodiment of the present invention prevents the key step of the method for database index entanglement from including：
S11：Sql files are obtained, and record the slow inquiry in sql files.Corresponding software is deployed to corresponding mysql clothes
It is engaged on device, obtains sql files, and the interval time (such as 2 seconds) for reading sql files is set, not after interval time, automatically
Sql files are opened, the sql files are read since the position that last time reads.By those execution more than certain in reading process
The slow inquiry (slow sql) of time (such as 1 second) is recorded.
S12：Judge in index management system with the presence or absence of corresponding to the record inquired slowly.Middle extraction step is removed from data
The slow inquiry recorded in S11 carries out syntactic analysis and extracts trunk to handle to inquiring slowly, and according to trunk is extracted, treated
Slow inquiry judges in index management system with the presence or absence of corresponding to the record inquired slowly.
S13：If being not present, record will be inquired slowly in the database, and dba or developer is notified to optimize.After optimization,
Optimal index is also added in database.
S14：If in the presence of the explanation results inquired slowly are compared with optimal explanation results, exception is judged and sends out
Alarm.Before this, dba or developer tie the explanation (explain) of structured query sentence and structured query sentence
Fruit carries out being entered into index management system；Syntactic analysis is carried out to structured query sentence and extracts trunk processing；By structuring
The explanation results of query statement are added in index management system in corresponding record；And structured query sentence is adjusted, it will
The optimal explanation results of structured query sentence after adjustment carry out being saved in index management system.
Explanation (explain) by important sql (carrying out marking judge according to business demand etc.) and database to the sql
As a result it is entered into index management system, which is to execute abnormal sentence occur on mysql.Such as knowledge base system
There is a slow sql on mysql：
SELECT kk.id,CAST(kk.id AS CHAR(10))AS id_str,kk.sup_id,kk.k_title,
kk.erp_account,kk.area,kk.sum_grade,IFNULL(kk.k_key1,kk.k_key2)k_key1,kkc.k_
Content, CAST (sum (case WHEN kc.id>1000then kc.id else 1000end)AS SIGNED)AS
mon_click_count
FROM know_knowledge kk
LEFT JOIN know_knowledge_content kkc ON kk.id=kkc.id AND kkc.yn=1
LEFT JOIN know_user ku ON ku.erp_account=kk.erp_account
LEFT JOIN know_click kc ON kc.know_id=kk.id AND kc.create_time>DATE_
SUB (NOW (), INTERVAL 6DAY)
LEFT JOIN know_knowledge_addition kka ON kka.know_id=kk.id and
Kka.yn=1
WHERE kk.k_status in (11,12,1) AND kk.k_type=20AND kk.yn=1GROUP BY
kk.id
Explain result such as following tables of the Mysql to above-mentioned slow sql：
After important sql typings, syntactic analysis and extraction trunk, groundwork that this sql sentence is carried out are exactly
All variable parts of this sql are all eliminated, and trunk is left.And the explain results of this sql are added to sql correspondences
Record in, such as have in legend above 5 as a result, 5 records can be then preserved in systems, including at least 10 in every record
A field corresponds to each row of upper figure respectively.Then, important sql sentences are adjusted, by the optimal explanation results of sql after adjustment into
Row is saved in index management system, and optimal index is also preserved into the system.
Corresponding record is inquired slowly with this if being found in index management system, illustrates that this slow inquiry sql exists at present
Occur exception in the execution of mysql originally, is then compared the explanation results inquired slowly with optimal explanation results.For
The comparison of two explanation results, can be by executing explain orders.If do not have in explanation results a row can with unique mark row,
Several row (such as second and third, four row) therein can be combined into a row, by it come the sub- result of each explain of unique mark.It should
After processing, program can analyze every height result, check whether the key of the sub- result of each correspondence is consistent, if not
Unanimously, then illustrate that the index of the sub- result goes wrong, then record.The comparison for carrying out sub- result successively, until a side is complete
At finally comparison result is all recorded.And, it may be found that the problem of notify to give treatment measures system, treatment measures system
System carries out respective handling by preset mode, and main processing mode is mobile phone notice, and mail notification can also be according to exception
Judging result, operation automatically process order, delete and inquire related all threads slowly with described.The process automatically processed is：Fortune
The order show processlist of row mysql；Check each thread state in current mysql；Find out institute related with the sql
There is thread number；These threads are deleted in circular flow kill thread id orders；Table collating order, being arranged to the table (can
It can be since than relatively time-consuming, default situations be not execute).
Fig. 2 is the flow of pressure test in a kind of method for realizing Hadoop cluster monitorings according to the ... of the embodiment of the present invention
Figure.
Fig. 2 is a kind of signal of the main modular of system for preventing database index entanglement according to the ... of the embodiment of the present invention
Figure.As shown in Fig. 2, a kind of of the embodiment of the present invention prevents the system 2 of database index entanglement from including mainly：Logging modle 21,
For obtaining sql files, and record the slow inquiry in sql files；Analysis and alarm module 22, for judging index management module
With the presence or absence of corresponding to the record inquired slowly in 23；If being not present, record will be inquired slowly in the database；Otherwise, it will look into slowly
The explanation results of inquiry are compared with optimal explanation results, are judged exception and are sent out alarm.Also, analysis and alarm module 22
It is additionally operable to：It carries out syntactic analysis and extracts trunk to handle to inquiring slowly；According to extracting trunk treated slow inquiry, judge whether
Have corresponding to the record inquired slowly.
Index management module 23 is for storing and managing and inquire relevant record, including typing, modification, deletion, guarantor slowly
It deposits and inquires relevant record etc. slowly.Index management module 23 includes that typing unit, processing unit and optimal explanation results obtain
Unit.Typing unit is used to the explanation results of structured query sentence and structured query sentence carrying out typing.Processing unit
For carrying out syntactic analysis to structured query sentence and extracting trunk processing, and by the explanation results of structured query sentence
It is added in corresponding record.Optimal explanation results acquiring unit is for adjusting structured query sentence, by the structure after adjustment
The optimal explanation results for changing query statement are preserved.
The a kind of of the embodiment of the present invention prevents the system 2 of database index entanglement from further including setup module and automatically processing mould
Block.Setup module is used to be arranged the interval time that logging modle reads sql files, and after interval time, logging modle is automatic
It reads sql files and records the slow inquiry in sql files.Automatically process module is used for according to abnormal judging result, and operation is automatic
Processing order deletes and inquires related all threads slowly.Automatically process module is additionally operable to operation order show
Processlist checks the state of each thread；It finds out and inquires related all threads slowly；Cycle executes kill threads id
Order, to delete and inquire related all threads slowly.Wherein, with oracle, sqlserver etc. can provide slow sql daily records,
The database of sql parsings.
Important sql and database are entered into the index management module in present system to its explanation results, reported
Both common socket transmission may be used, can also be transmitted by MQ, redis, memcache.By logging modle portion
It affixes one's name on corresponding mysql servers, often excessively specified time (such as 2 seconds), logging modle open sql files, logging modle
Sql files are read since the position that last time reads.It it is more than certain time (such as 1 second) to those execution in reading process
Sql record, and before in this, (reading interlude) completes work period, slow sql is reported to by logging modle
Analysis and alarm module, this, which is reported, both may be used common socket transmission, can also by MQ, redis, memcache come
It is transmitted.Analysis and alarm module extract every slow sql successively from the data field that each logging modle reports, and slow to this
Sql carries out syntactic analysis and extracts trunk processing, according to this extraction trunk treated slow sql, into index management module
It has searched whether corresponding sql records, if not finding, then the slow sql has been added in database, notifies dba or exploitation
It optimizes, and optimal index is also added in database.If finding corresponding sql records, then illustrate this slow sql at present
It is executed on original mysql and exception occurs, then primary analysis done to the slow sql (before not extracting trunk), obtain it
Explain from index management module as a result, and taking out dba or developing the optimal explain of typing as a result, to this 2
Explain results are compared.To be compared by this, can determine whether out abnormal place, then realization is timely, pinpoints the problems automatically, and
And it quickly positions abnormal position and sends out alarm.After pinpointing the problems, respective handling can be carried out by way of systemic presupposition, it is main
The processing mode wanted is mobile phone notice, mail notification and is automatically processed.For automatically processing, automatically process module can delete and institute
It states and inquires related all threads slowly, and then realize the limited administration to indexing extremely.Also, unified monitoring, management are extensive
Mysql systems in exception sql, more can quickly position, open speed find appearance it is abnormal due to, to similar 618, double ten
First-class important daily record, the stable operation of safeguards system can play obvious action.
Fig. 3 is a kind of schematic diagram of device for preventing database index entanglement according to the ... of the embodiment of the present invention.Such as Fig. 3 institutes
Showing, a kind of device 3 preventing database index entanglement of the embodiment of the present invention includes memory 31 and at least one processor 32,
Wherein, memory 31 is connect at least one processor 32 by bus, and memory 31, which is stored with, to be executed by a processor
Instruction, when the present embodiment device operation when, instruction executed by least one processor so that at least one processor can
Execute method flow as shown in Figure 1.
Fig. 4 is a kind of hardware architecture diagram of device for preventing database index entanglement according to the ... of the embodiment of the present invention.
As shown in Fig. 4 (by taking a processor as an example), the device of the present embodiment further includes input unit 43 and output device 44.Memory
41, processor 42 can be connected with input unit 43, output device 44 by bus or other modes, with by total in Fig. 4
For line connection.Memory 41 be used as a kind of non-transient computer readable storage medium, can be used for storing non-transient software program,
Non-transient computer executable program and module, as the method for preventing database index entanglement in the embodiment of the present application corresponds to
Program instruction/module (for example, attached logging modle shown in Fig. 2 21, analysis and alarm module 22 and index management module
23).Processor 42 is stored in non-transient software program, instruction and module in memory 41 by operation, to execute clothes
The various function application of device of being engaged in and data processing, i.e. realization above method embodiment prevent the processing side of database index entanglement
Method.
Memory 41 may include storing program area and storage data field, wherein storing program area can storage program area,
At least one required application program of function；Storage data field can be stored to be made according to the device for preventing database index entanglement
With the data etc. created.In addition, memory 41 may include high-speed random access memory, can also include non-transient storage
Device, for example, at least a disk memory, flush memory device or other non-transient solid-state memories.In some embodiments,
It includes the memory remotely located relative to processor 42 that memory 41 is optional, these remote memories can pass through network connection
To the device for preventing database index entanglement.The example of above-mentioned network includes but not limited to internet, intranet, local
Net, mobile radio communication and combinations thereof.
Input unit 43 can receive the number or character information of input, and generate and prevent the dress of database index entanglement
The related key signals input of user setting and function control set.Output device 44 may include that display screen etc. shows equipment.
One or more module is stored in memory 41, when being executed by one or more processor 42, is executed
The processing method for preventing database index entanglement in above-mentioned any means embodiment.
The said goods can perform the method that the embodiment of the present application is provided, and has the corresponding function module of execution method and has
Beneficial effect.The not technical detail of detailed description in the present embodiment, reference can be made to the method that the embodiment of the present application is provided.
One of ordinary skill in the art will appreciate that realizing all or part of flow in above-described embodiment method, being can be with
Relevant hardware is instructed to complete by computer program, the program, which can be stored in a non-transient computer and can be read, deposits
In storage media, the program is when being executed, it may include such as the flow of the embodiment of above-mentioned each method.Wherein, the storage medium
Can be magnetic disc, CD, read-only memory (Read-Only Memory, ROM) or random access memory
(RandomAccessMemory RAM) etc..
Above-mentioned specific implementation mode, does not constitute limiting the scope of the invention.Those skilled in the art should be bright
It is white, design requirement and other factors are depended on, various modifications, combination, sub-portfolio and replacement can occur.It is any
Modifications, equivalent substitutions and improvements made by within the spirit and principles in the present invention etc., should be included in the scope of the present invention
Within.
Claims (14)
1. a kind of method preventing database index entanglement, which is characterized in that including：
Sql files are obtained, and record the slow inquiry in the sql files；
Judge in index management system with the presence or absence of corresponding to the record inquired slowly；
If being not present, in the database by the slow inquiry record；Otherwise, by the explanation results and optimal solution inquired slowly
It releases result to be compared, judge exception and sends out alarm.
2. according to the method described in claim 1, it is characterized in that, further including：
Syntactic analysis is carried out to the slow inquiry and extracts trunk processing；
According to extracting trunk treated slow inquiry, judge in index management system with the presence or absence of corresponding to the note inquired slowly
Record.
3. according to the method described in claim 1, it is characterized in that, further including：
The explanation results of structured query sentence and the structured query sentence are carried out to be entered into index management system；
Syntactic analysis is carried out to the structured query sentence and extracts trunk processing；
The explanation results of the structured query sentence are added in index management system in corresponding record；And
The structured query sentence is adjusted, the optimal explanation results of the structured query sentence after adjustment are saved in index pipe
Reason system.
4. according to the method described in claim 1, it is characterized in that, further including：
The interval time for reading sql files is set, it is automatic to read sql files and record the sql after the interval time
Slow inquiry in file.
5. according to the method described in claim 1, it is characterized in that, further including：
According to abnormal judging result, operation automatically processes order, deletes and inquires related all threads slowly with described.
6. according to the method described in claim 5, it is characterized in that, further including：
Operation order show processlist, check the state of each thread；
It finds out and inquires related all threads slowly with described；
Cycle executes kill thread id orders, and related all threads are inquired slowly with described to delete.
7. a kind of system preventing database index entanglement, which is characterized in that including：
Logging modle for obtaining sql files, and records the slow inquiry in the sql files；
Analysis and alarm module, for judging in index management module with the presence or absence of corresponding to the record inquired slowly；If no
In the presence of then in the database by the slow inquiry record；Otherwise, by the explanation results inquired slowly and optimal explanation results into
Row compares, and judges exception and sends out alarm；
Index management module, for storing and managing and inquire relevant record slowly.
8. system according to claim 7, which is characterized in that analysis and alarm module are additionally operable to：
Syntactic analysis is carried out to the slow inquiry and extracts trunk processing；
According to extracting trunk treated slow inquiry, judge whether there is corresponding to the record inquired slowly.
9. system according to claim 7, which is characterized in that the index management module includes：
Typing unit, for the explanation results of structured query sentence and the structured query sentence to be carried out typing；
Processing unit, for carrying out syntactic analysis to the structured query sentence and extracting trunk processing；And by the knot
The explanation results of structure query statement are added in corresponding record；
Optimal explanation results acquiring unit, for adjusting the structured query sentence, by the structured query sentence after adjustment
Optimal explanation results preserved.
10. system according to claim 7, which is characterized in that further include setup module, read for logging modle to be arranged
The interval time of sql files, after the interval time, logging modle reads sql files and records the sql files automatically
In slow inquiry.
11. system according to claim 7, which is characterized in that further include automatically process module, for according to abnormal judgement
As a result, operation automatically processes order, deletes and inquire related all threads slowly with described.
12. system according to claim 7, which is characterized in that automatically process module is additionally operable to operation order show
Processlist checks the state of each thread；It finds out and inquires related all threads slowly with described；Cycle executes kill lines
Journey id orders inquire related all threads slowly to delete with described.
13. a kind of device preventing database index entanglement, which is characterized in that including：
At least one processor；And
With the memory of at least one processor communication connection；Wherein
The memory stores the instruction executed by one processor, and described instruction is held by least one processor
Row, so that at least one processor is able to carry out method as claimed in any one of claims 1 to 6.
14. a kind of non-transient computer readable storage medium preventing database index entanglement, which is characterized in that described non-transient
Computer-readable recording medium storage computer instruction, the computer instruction is for making the computer perform claim require 1-
6 any one of them methods.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710036801.7A CN108319620A (en) | 2017-01-18 | 2017-01-18 | A kind of method preventing database index entanglement, system, device and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710036801.7A CN108319620A (en) | 2017-01-18 | 2017-01-18 | A kind of method preventing database index entanglement, system, device and storage medium |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN108319620A true CN108319620A (en) | 2018-07-24 |
Family
ID=62891335
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201710036801.7A Pending CN108319620A (en) | 2017-01-18 | 2017-01-18 | A kind of method preventing database index entanglement, system, device and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN108319620A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112613176A (en) * | 2020-12-23 | 2021-04-06 | 贝壳技术有限公司 | Slow SQL statement prediction method and system |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102073640A (en) * | 2009-11-19 | 2011-05-25 | 阿里巴巴集团控股有限公司 | Method, system and server for testing structured query language (SQL) statements |
| US20130254210A1 (en) * | 2008-12-30 | 2013-09-26 | Teradata Corporation | Index selection in a multi-system database management system |
| CN104714984A (en) * | 2013-12-17 | 2015-06-17 | 中国移动通信集团湖南有限公司 | Database optimization method and device |
| CN105718593A (en) * | 2016-01-28 | 2016-06-29 | 长春师范大学 | Database query optimization method and system |
| CN106156623A (en) * | 2016-07-29 | 2016-11-23 | 江西师范大学 | Based on the SQLIA defence method being intended to |
-
2017
- 2017-01-18 CN CN201710036801.7A patent/CN108319620A/en active Pending
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20130254210A1 (en) * | 2008-12-30 | 2013-09-26 | Teradata Corporation | Index selection in a multi-system database management system |
| CN102073640A (en) * | 2009-11-19 | 2011-05-25 | 阿里巴巴集团控股有限公司 | Method, system and server for testing structured query language (SQL) statements |
| CN104714984A (en) * | 2013-12-17 | 2015-06-17 | 中国移动通信集团湖南有限公司 | Database optimization method and device |
| CN105718593A (en) * | 2016-01-28 | 2016-06-29 | 长春师范大学 | Database query optimization method and system |
| CN106156623A (en) * | 2016-07-29 | 2016-11-23 | 江西师范大学 | Based on the SQLIA defence method being intended to |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112613176A (en) * | 2020-12-23 | 2021-04-06 | 贝壳技术有限公司 | Slow SQL statement prediction method and system |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US11397722B2 (en) | Applications of automated discovery of template patterns based on received requests | |
| US10469320B2 (en) | Versioning system for network states in a software-defined network | |
| KR101956236B1 (en) | Data replication technique in database management system | |
| CN106164865B (en) | The method and system of the affairs batch processing of dependence perception for data duplication | |
| KR101114149B1 (en) | Ultra-shared-nothing parallel database | |
| US5706499A (en) | Functional compensation in a heterogeneous, distributed database environment | |
| CN110837585B (en) | Multi-source heterogeneous data association query method and system | |
| US9916368B2 (en) | Non-exclusionary search within in-memory databases | |
| CN110300963A (en) | Data management system in large-scale data repository | |
| CN109997125A (en) | System for importing data to data storage bank | |
| CN110168515A (en) | System for analyzing data relationship to support query execution | |
| US11314717B1 (en) | Scalable architecture for propagating updates to replicated data | |
| CN109902130A (en) | A kind of date storage method, data query method and apparatus, storage medium | |
| CN105723335A (en) | Data flow exploration | |
| CN105144162B (en) | Integrated data base frame | |
| CN106164897A (en) | For depositing the system and method for memory database | |
| CN108885724A (en) | Information processing unit, information processing method and message handling program | |
| CN106484853A (en) | document analysis method and device | |
| US20140258217A1 (en) | View Based Table Replacement for Applications | |
| US7653663B1 (en) | Guaranteeing the authenticity of the data stored in the archive storage | |
| Chouder et al. | Enabling Self-Service BI on Document Stores. | |
| US7805462B2 (en) | Portfolio management methods, systems, and computer programs | |
| CN108319620A (en) | A kind of method preventing database index entanglement, system, device and storage medium | |
| US20040181510A1 (en) | System and method for cooperative database acceleration | |
| Yasser et al. | Implementing business intelligence system-Case study |
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 | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20180724 |
|
| RJ01 | Rejection of invention patent application after publication |