CN108108434A - A kind of method and device for managing database - Google Patents
A kind of method and device for managing database Download PDFInfo
- Publication number
- CN108108434A CN108108434A CN201711372569.0A CN201711372569A CN108108434A CN 108108434 A CN108108434 A CN 108108434A CN 201711372569 A CN201711372569 A CN 201711372569A CN 108108434 A CN108108434 A CN 108108434A
- Authority
- CN
- China
- Prior art keywords
- query interface
- default
- target matrix
- query
- split
- 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
- 238000000034 method Methods 0.000 title claims abstract description 44
- 239000011159 matrix material Substances 0.000 claims abstract description 92
- 238000004891 communication Methods 0.000 claims description 19
- 238000012545 processing Methods 0.000 claims description 13
- 238000004590 computer program Methods 0.000 claims description 8
- 238000010586 diagram Methods 0.000 description 4
- 230000008569 process Effects 0.000 description 4
- 238000005194 fractionation Methods 0.000 description 3
- 230000005540 biological transmission Effects 0.000 description 2
- 238000005516 engineering process Methods 0.000 description 2
- 230000006870 function Effects 0.000 description 2
- 230000004048 modification Effects 0.000 description 2
- 238000012986 modification Methods 0.000 description 2
- 230000002093 peripheral effect Effects 0.000 description 2
- 230000009467 reduction Effects 0.000 description 2
- 230000008901 benefit Effects 0.000 description 1
- 235000013399 edible fruits Nutrition 0.000 description 1
- 238000000802 evaporation-induced self-assembly Methods 0.000 description 1
- 230000008140 language development Effects 0.000 description 1
- 238000002360 preparation method Methods 0.000 description 1
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
-
- 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/2282—Tablespace storage structures; Management thereof
-
- 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/25—Integrating or interfacing systems involving database management systems
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Computational Linguistics (AREA)
- Software Systems (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
An embodiment of the present invention provides it is a kind of manage database method and device, the described method includes：Default query interface judges whether the corresponding target matrix of the query interface meets preset condition；If it has, then the query interface divides table by what the target matrix was split as default quantity；When application program inquires about the target matrix by the query interface, the query interface inquiry default quantity divides table, and the query result for dividing table is returned to the application program.Quick search tables of data can be realized using the embodiment of the present invention.
Description
Technical field
The present invention relates to database technical field, more particularly to a kind of method and device for managing database.
Background technology
The use of MySQL database inquiry tables of data is the common function of database processing.When the data volume of tables of data is hundred
Ten thousand grades or during millions, many reasons are waited since the low memory or I/O handling capacities of running equipment are smaller, the speed that causes to table look-up is non-
It is often slow, influence the treatment effeciency of database.
The content of the invention
The embodiment of the present invention is designed to provide a kind of method and device for managing database, to realize quick search number
According to table.Specific technical solution is as follows：
The embodiment of the present invention provides a kind of method for managing database, and method includes：
Default query interface judges whether the corresponding target matrix of query interface meets preset condition；
If it has, then query interface divides table by what target matrix was split as default quantity；
When application program inquires about target matrix by query interface, the table that divides of quantity is preset in query interface inquiry, and
The query result for dividing table is returned into application program.
Optionally, default query interface judges whether the corresponding target matrix of query interface meets the step of preset condition
Suddenly, including：
Default query interface judges whether the data volume of the corresponding target matrix of query interface is more than preset data amount
Threshold value.
Optionally, default query interface judges whether the corresponding target matrix of query interface meets the step of preset condition
Suddenly, including：
Default query interface judges whether the corresponding target matrix of query interface carries default split and identify.
Optionally, target matrix is split as default the step of dividing table of quantity by query interface, including：
Query interface determines the target data amount area residing for the data volume of target matrix according to default data volume section
Between；
Query interface corresponds to target data amount section according to default data volume section and the correspondence for dividing table quantity
Divide what table quantity was determined as target matrix to divide table quantity；
Query interface divides table by what target matrix was split as point table quantity.
Optionally, the step of query result for dividing table being returned into application program, including：
Summarize the query result of point table；
Query result after summarizing is returned into application program.
The embodiment of the present invention also provides a kind of device for managing database, and device includes：
Judging unit judges whether the corresponding target matrix of query interface meets default item for default query interface
Part；
Split cells, if meeting default item for the judging result of judging unit for the corresponding target matrix of query interface
Part, then query interface divide table by what target matrix was split as default quantity；
Query unit, for when application program inquires about target matrix by query interface, query interface inquiry to be default
Quantity divides table, and the query result for dividing table is returned to application program.
Optionally, judging unit judges the corresponding target matrix of query interface specifically for default query interface
Whether data volume is more than preset data amount threshold value.
Optionally, judging unit judges that the corresponding target matrix of query interface is specifically for default query interface
It is no to carry default fractionation mark.
Optionally, split cells specifically for query interface according to default data volume section, determines target matrix
Target data amount section residing for data volume；Query interface according to default data volume section and the correspondence for dividing table quantity,
Divide table quantity by what corresponding point of target data amount section table quantity was determined as target matrix；Query interface is by target matrix
Be split as point table quantity divides table.
Optionally, query unit, specifically for summarizing the query result of point table；Query result after summarizing is returned to should
Use program.
The embodiment of the present invention provides a kind of electronic equipment again, total including processor, communication interface, memory and communication
Line, wherein, processor, communication interface, memory completes mutual communication by communication bus；
Memory, for storing computer program；
Processor during for performing the program stored on memory, realizes any of the above-described management database
Method.
The embodiment of the present invention provides a kind of computer readable storage medium again, is stored in computer readable storage medium
Instruction, when run on a computer so that the method that computer performs any of the above-described management database.
The embodiment of the present invention provides a kind of computer program product for including instruction again, when it runs on computers
When so that the method that computer performs any of the above-described management database.
A kind of method and device for managing database provided in an embodiment of the present invention, first, when default query interface quilt
During access, judge whether target matrix to be checked meets preset condition；If target database meets preset condition, by target
What tables of data was split as default quantity divides table；Then, accessed using query interface and divide table after splitting；Finally, looking into for table will be divided
It askes as a result, returning to application program by query interface.In this way, the method for management database provided in an embodiment of the present invention, it can
To realize the query processing to dividing table by the way that the larger table of data volume is split as multiple points of tables, it is big to avoid the occurrence of directly inquiry
The problem of inquiry velocity is slow caused by watch can improve speed of tabling look-up, and improve the treatment effeciency to database.Certainly, this is implemented
Any product or method of invention must be not necessarily required to reach all the above advantage simultaneously.
Description of the drawings
It in order to illustrate more clearly about the embodiment of the present invention or technical scheme of the prior art, below will be to embodiment or existing
There is attached drawing needed in technology description to be briefly described, it should be apparent that, the accompanying drawings in the following description is only this
Some embodiments of invention, for those of ordinary skill in the art, without creative efforts, can be with
Other attached drawings are obtained according to these attached drawings.
Fig. 1 is a kind of flow chart of the method for the management database of the embodiment of the present invention；
Fig. 2 is a kind of schematic diagram of the device of the management database of the embodiment of the present invention；
Fig. 3 is the schematic diagram of the electronic equipment of the embodiment of the present invention.
Specific embodiment
Below in conjunction with the attached drawing in the embodiment of the present invention, the technical solution in the embodiment of the present invention is carried out clear, complete
Site preparation describes, it is clear that described embodiment is only part of the embodiment of the present invention, instead of all the embodiments.It is based on
Embodiment in the present invention, those of ordinary skill in the art are obtained every other without making creative work
Embodiment belongs to the scope of protection of the invention.
The use of MySQL database inquiry tables of data is the common function of database processing.When the data volume of tables of data is hundred
Ten thousand grades or during millions, many reasons are waited since the low memory or I/O handling capacities of running equipment are smaller, cause looking into for tables of data
It is very slow to ask speed, influences the treatment effeciency of database.
To solve the above-mentioned problems, it is default an embodiment of the present invention provides a kind of method and device for managing database
Target matrix can be split as by query interface after the corresponding target matrix of definite query interface meets preset condition
Default quantity divides table；When application program inquires about target matrix by query interface, query interface can inquire about present count
Amount divides table, and the query result for dividing table is returned to application program.In this way, when the larger big table of application program inquiry data volume
When, it can improve speed of tabling look-up by inquiring about multiple points of tables after big table is split by query interface, improve to database
Treatment effeciency.
An embodiment of the present invention provides a kind of methods for managing database.Referring to Fig. 1, Fig. 1 is the pipe of the embodiment of the present invention
A kind of flow chart of the method for database is managed, is included the following steps：
Step 101, default query interface judges whether the corresponding target matrix of query interface meets preset condition, if
It is yes, performs step 102.
In this step, default query interface may determine that whether corresponding target matrix meets preset condition,
Under normal circumstances, when the data volume of target matrix is larger, for example data volume is million grades or millions, it is believed that the mesh
Mark tables of data meets preset condition, and then carries out deconsolidation process to target matrix by performing subsequent step, is tabled look-up with improving
Speed.
Specifically, default query interface can be understood as database middleware.MySQL database usually monitors transmission control
On 3306 ports of agreement (Transmission Control Protocol, TCP) processed, application program, such as by supertext
The application program of (Hypertext Preprocessor, PHP) language development is pre-processed, 3306 ports can be led to and access MySQL
Database.Default query interface can monitor 3306 ports of TCP as MySQL, and therefore, application program need not appoint
What modification can access MySQL database by default query interface.
In a kind of realization method, step 101 can include：
Default query interface judges whether the data volume of the corresponding target matrix of query interface is more than preset data amount
Threshold value.
Specifically, preset condition can be whether judge the data volume of target matrix more than preset data amount threshold value, when
When the data volume of target matrix is more than preset data amount threshold value, it is believed that target matrix meets preset condition；Work as target
When the data volume of tables of data is not above preset data amount threshold value, it is believed that target matrix does not meet preset condition.
In another realization method, step 101 can include：
Default query interface judges whether the corresponding target matrix of query interface carries default split and identify.
Specifically, preset condition can be to judge whether target matrix carries default split and identify, work as target data
When table carries default fractionation mark, it is believed that target matrix meets preset condition；When target matrix data volume not
When carrying default fractionation mark, it is believed that target matrix does not meet preset condition.Wherein it is possible in advance to speed of tabling look-up
It sets to split mark or set in more frequent tables of data is inquired about in the more demanding tables of data of degree and splits mark.
It is of course also possible to according to actual conditions, the particular content of preset condition is set, for example, preset condition can also be
Whether the inquiry times in preset time period are more than default inquiry threshold value, when target matrix looking into preset time period
When asking number more than default inquiry threshold value, it is believed that target matrix meets preset condition；When target matrix is default
When inquiry times in period are not above default inquiry threshold value, it is believed that target matrix does not meet preset condition.
Step 102, query interface divides table by what target matrix was split as default quantity.
In this step, when target matrix meets preset condition, target matrix can be split as by query interface
Default quantity divides table.In this manner it is possible to by inquiring about corresponding point of table of target matrix, query result is obtained, is avoided the occurrence of
The problem of inquiry velocity caused by directly inquiring about big watch is slow can improve speed of tabling look-up, and improve the treatment effeciency to database.
In a kind of realization method, step 102 can include：
Query interface determines the target data amount area residing for the data volume of target matrix according to default data volume section
Between；
Query interface corresponds to target data amount section according to default data volume section and the correspondence for dividing table quantity
Divide what table quantity was determined as target matrix to divide table quantity；
Query interface divides table by what target matrix was split as point table quantity.
Specifically, multiple data volume sections and each data volume section can be pre-set with dividing the corresponding of table quantity
Relation.Query interface can be first according to default data volume section, residing for the data volume for determining currently processed target matrix
Target data amount section, then, according to default data volume section and the correspondence for dividing table quantity, by target data amount area
Between corresponding point of table quantity be determined as target matrix divide table quantity, finally, target matrix is split as point table quantity
Divide table.
For example, default data volume section is with dividing the correspondence of table quantity：
Section one：Between data volume section is 1 million to two million, corresponding point of table quantity is 100；Section two：Number
According to amount section between 1,000 ten thousand to two thousand ten thousand, corresponding point of table quantity is 1000.When the data volume of target matrix is one
When million, target data amount section residing for the data volume of target matrix is section one, corresponding point of target data amount section
Table quantity is 100, then, corresponding point of table quantity of target matrix is 100, and query interface can be by the target matrix
It is split as 100 points of tables.
Step 103, when application program inquires about target matrix by query interface, the default quantity of query interface inquiry
Divide table, and the query result for dividing table is returned into application program.
In this step, when application program inquires about target matrix by query interface, query interface can be by looking into
That askes default quantity divides table to obtain query result, and the query result for dividing table is returned to application program；In this way, application program without
Target matrix need to be directly inquired about, and can just get query result by inquiring about corresponding point of table of target matrix,
Speed of tabling look-up can be improved, improves the treatment effeciency to database.
In a kind of realization method, the step of query result for dividing table is returned into application program, it can include：
Summarize the query result of point table；
Query result after summarizing is returned into application program.
Specifically, query interface can summarize the query result of corresponding point of table of target matrix, by the inquiry after summarizing
As a result application program is returned to, not only ensures the accuracy for the query result that application program is got, but also can improve and table look-up
Speed improves the treatment effeciency to database.
As it can be seen that the method for management database provided in an embodiment of the present invention, first, when default query interface is accessed
When, judge whether target matrix to be checked meets preset condition；If target database meets preset condition, by target data
What table was split as default quantity divides table；Then, accessed using query interface and divide table after splitting；Finally, the inquiry knot of table will be divided
Fruit returns to application program by query interface.In this way, the method for management database provided in an embodiment of the present invention, Ke Yitong
It crosses and the larger table of data volume is split as multiple points of tables to realize the query processing to dividing table, avoid the occurrence of and directly inquire about big table and lead
The problem of inquiry velocity of cause is slow can improve speed of tabling look-up, and improve the treatment effeciency to database；In addition, the application on upper strata
Program need not know the situation of bottom data, it is only necessary to simply call query interface, just can obtain needed for query result, can be with
Database performance is improved by reducing the load of program realization, and it is possible to improve the efficiency searched for generally, reduces fuzzy searches
Rope is to the expense of server CPU.
The embodiment of the present invention additionally provides a kind of device for managing database.Referring to Fig. 2, Fig. 2 is the embodiment of the present invention
A kind of schematic diagram of the method for database is managed, including unit：
It is pre- to judge whether the corresponding target matrix of query interface meets for default query interface for judging unit 201
If condition；
Split cells 202, if for judging unit judging result for the corresponding target matrix of query interface meet it is pre-
If condition, then query interface divides table by what target matrix was split as default quantity；
Query unit 203, for when application program inquires about target matrix by query interface, query interface inquiry to be pre-
If quantity divides table, and the query result for dividing table is returned to application program.
Optionally, judging unit 201 judge the corresponding target matrix of query interface specifically for default query interface
Data volume whether be more than preset data amount threshold value.
Optionally, judging unit 201 judge the corresponding target matrix of query interface specifically for default query interface
Default split whether is carried to identify.
Optionally, split cells 202 specifically for query interface according to default data volume section, determine target data
Target data amount section residing for the data volume of table；Query interface is according to default data volume section and the corresponding pass for dividing table quantity
System divides table quantity by what corresponding point of target data amount section table quantity was determined as target matrix；Query interface is by number of targets
Divide table according to what table was split as point table quantity.
Optionally, query unit 203, specifically for summarizing the query result of point table；Query result after summarizing returns
To application program.
As it can be seen that the device of management database provided in an embodiment of the present invention, it can be by the way that the larger table of data volume be split
It is multiple points of tables to realize the query processing to dividing table, avoids the occurrence of the problem of inquiry velocity caused by directly inquiring about big watch is slow,
Speed of tabling look-up can be improved, improves the treatment effeciency to database；In addition, the application program on upper strata need not know bottom data
Situation, it is only necessary to query interface is simply called, can just obtain required query result, the load that can be realized by reducing program
Database performance is improved, and it is possible to improve the efficiency searched for generally, reduces the expense searched for generally to server CPU.
The embodiment of the present invention additionally provides a kind of electronic equipment, and with reference to figure 3, Fig. 3 is the electronic equipment of the embodiment of the present invention
Schematic diagram, as shown in figure 3, electronic equipment include processor 301, communication interface 302, memory 303 and communication bus 304,
Wherein, processor 301, communication interface 302, memory 303 complete mutual communication by communication bus 304,
Memory 303, for storing computer program；
Processor 301 during for performing the program stored on memory 303, realizes following steps：
Default query interface judges whether the corresponding target matrix of query interface meets preset condition；
If it has, then query interface divides table by what target matrix was split as default quantity；
When application program inquires about target matrix by query interface, the table that divides of quantity is preset in query interface inquiry, and
The query result for dividing table is returned into application program.
The communication bus that above-mentioned electronic equipment is mentioned can be Peripheral Component Interconnect standard (Peripheral Component
Interconnect, abbreviation PCI) bus or expanding the industrial standard structure (Extended Industry Standard
Architecture, abbreviation EISA) bus etc..The communication bus can be divided into address bus, data/address bus, controlling bus etc..
For ease of representing, only represented in figure with a thick line, it is not intended that an only bus or a type of bus.
Communication interface is for the communication between above-mentioned electronic equipment and other equipment.
Memory can include random access memory (Random Access Memory, abbreviation RAM), can also include
Nonvolatile memory (non-volatile memory), for example, at least a magnetic disk storage.Optionally, memory may be used also
To be at least one storage device for being located remotely from aforementioned processor.
Above-mentioned processor can be general processor, including central processing unit (Central Processing Unit,
Abbreviation CPU), network processing unit (Network Processor, abbreviation NP) etc.；It can also be digital signal processor
(Digital Signal Processing, abbreviation DSP), application-specific integrated circuit (Application Specific
Integrated Circuit, abbreviation ASIC), field programmable gate array (Field-Programmable Gate Array,
Abbreviation FPGA) either other programmable logic device, discrete gate or transistor logic, discrete hardware components.
As it can be seen that electronic equipment provided in an embodiment of the present invention, it can be by the way that the larger table of data volume be split as multiple points
Table avoids the occurrence of the problem of inquiry velocity caused by directly inquiring about big watch is slow, can improve to realize the query processing to dividing table
It tables look-up speed, improves the treatment effeciency to database；In addition, the application program on upper strata need not know the situation of bottom data, only
It needs simply to call query interface, can just obtain required query result, can be improved by reducing the load of program realization
Database performance and it is possible to improve the efficiency searched for generally, reduces the expense searched for generally to server CPU.
In another embodiment provided by the invention, a kind of computer readable storage medium is additionally provided, which can
It reads to be stored with instruction in storage medium, when run on a computer so that computer performs any institute in above-described embodiment
The method for the management database stated.
As it can be seen that computer readable storage medium provided in an embodiment of the present invention, it can be by the way that the larger table of data volume be torn open
It is divided into multiple points of tables to realize the query processing to dividing table, avoids the occurrence of that inquiry velocity caused by directly inquiring about big watch is slow to ask
Topic, can improve speed of tabling look-up, improve the treatment effeciency to database；In addition, the application program on upper strata need not know bottom number
According to situation, it is only necessary to simply call query interface, just can obtain needed for query result, can by reduce program realization
It loads to improve database performance, and it is possible to improve the efficiency searched for generally, reduction searches for generally opening server CPU
Pin.
In another embodiment provided by the invention, a kind of computer program product for including instruction is additionally provided, when it
When running on computers so that the method that computer performs any management database in above-described embodiment.
As it can be seen that the computer program product provided in an embodiment of the present invention for including instruction, it can be by larger by data volume
Table be split as multiple points of tables to realize the query processing to dividing table, it is slow to avoid the occurrence of inquiry velocity caused by directly inquiring about big watch
The problem of, speed of tabling look-up can be improved, improves the treatment effeciency to database；In addition, the application program on upper strata need not know bottom
The situation of layer data, it is only necessary to query interface is simply called, can just obtain required query result, it can be by reducing program reality
Existing load improves database performance, and it is possible to improve the efficiency searched for generally, reduction is searched for generally to server CPU
Expense.
It should be noted that herein, relational terms such as first and second and the like are used merely to a reality
Body or operation are distinguished with another entity or operation, are deposited without necessarily requiring or implying between these entities or operation
In any this actual relation or order.Moreover, term " comprising ", "comprising" or its any other variant are intended to
Non-exclusive inclusion, so that process, method, article or equipment including a series of elements not only will including those
Element, but also including other elements that are not explicitly listed or further include as this process, method, article or equipment
Intrinsic element.In the absence of more restrictions, the element limited by sentence "including a ...", it is not excluded that
Also there are other identical elements in process, method, article or equipment including the element.
Each embodiment in this specification is described using relevant mode, identical similar portion between each embodiment
Point just to refer each other, and the highlights of each of the examples are difference from other examples.It is real especially for system
For applying example, since it is substantially similar to embodiment of the method, so description is fairly simple, related part is referring to embodiment of the method
Part explanation.
The foregoing is merely illustrative of the preferred embodiments of the present invention, is not intended to limit the scope of the present invention.It is all
Any modifications, equivalent replacements and improvements are made within the spirit and principles in the present invention, are all contained in protection scope of the present invention
It is interior.
Claims (10)
- A kind of 1. method for managing database, which is characterized in that the described method includes：Default query interface judges whether the corresponding target matrix of the query interface meets preset condition；If it has, then the query interface divides table by what the target matrix was split as default quantity；When application program inquires about the target matrix by the query interface, the query interface inquires about the present count Amount divides table, and the query result for dividing table is returned to the application program.
- 2. according to the method described in claim 1, it is characterized in that, the default query interface judges the query interface pair The step of whether target matrix answered meets preset condition, including：Default query interface judges whether the data volume of the corresponding target matrix of the query interface is more than preset data amount Threshold value.
- 3. according to the method described in claim 1, it is characterized in that, the default query interface judges the query interface pair The step of whether target matrix answered meets preset condition, including：Default query interface judges whether the corresponding target matrix of the query interface carries default split and identify.
- 4. according to the method described in claim 1, it is characterized in that, the query interface target matrix is split as it is pre- If the step of dividing table of quantity, including：The query interface determines the target data residing for the data volume of the target matrix according to default data volume section Measure section；The query interface is according to default data volume section and the correspondence for dividing table quantity, by the target data amount section What corresponding point of table quantity was determined as the target matrix divides table quantity；The query interface by the target matrix be split as it is described divide table quantity divide table.
- 5. according to the method described in claim 1, it is characterized in that, described return to described answer by the query result for dividing table The step of with program, including：Summarize the query result for dividing table；Query result after summarizing is returned into the application program.
- 6. a kind of device for managing database, which is characterized in that described device includes：Judging unit judges whether the corresponding target matrix of the query interface meets default item for default query interface Part；Split cells, if for the judging unit judging result for the corresponding target matrix of the query interface meet it is pre- If condition, then the query interface divides table by what the target matrix was split as default quantity；Query unit, for when application program by the query interface inquire about the target matrix when, the query interface The table that divides of the default quantity is inquired about, and the query result for dividing table is returned into the application program.
- 7. device according to claim 6, which is characterized in thatThe judging unit judges the data of the corresponding target matrix of the query interface specifically for default query interface Whether amount is more than preset data amount threshold value.
- 8. device according to claim 6, which is characterized in thatThe judging unit judges whether the corresponding target matrix of the query interface is taken specifically for default query interface Mark is split with default.
- 9. a kind of electronic equipment, which is characterized in that including processor, communication interface, memory and communication bus, wherein, processing Device, communication interface, memory complete mutual communication by communication bus；Memory, for storing computer program；Processor during for performing the program stored on memory, realizes any method and steps of claim 1-5.
- 10. a kind of computer readable storage medium, which is characterized in that the computer readable storage medium memory contains computer Program realizes claim 1-5 any method and steps when the computer program is executed by processor.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201711372569.0A CN108108434A (en) | 2017-12-19 | 2017-12-19 | A kind of method and device for managing database |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201711372569.0A CN108108434A (en) | 2017-12-19 | 2017-12-19 | A kind of method and device for managing database |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN108108434A true CN108108434A (en) | 2018-06-01 |
Family
ID=62211197
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201711372569.0A Pending CN108108434A (en) | 2017-12-19 | 2017-12-19 | A kind of method and device for managing database |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN108108434A (en) |
Cited By (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111104672A (en) * | 2018-10-25 | 2020-05-05 | 迈普通信技术股份有限公司 | Data processing method and device |
| CN111190898A (en) * | 2019-11-25 | 2020-05-22 | 泰康保险集团股份有限公司 | Data processing method and device, electronic equipment and storage medium |
| CN111814441A (en) * | 2020-06-30 | 2020-10-23 | 平安科技（深圳）有限公司 | Report generation method, device, electronic device and storage medium |
| CN112685402A (en) * | 2019-10-17 | 2021-04-20 | 拉扎斯网络科技（上海）有限公司 | Data storage and query method and device, electronic equipment and storage medium |
| CN112685444A (en) * | 2020-12-24 | 2021-04-20 | 江苏苏宁云计算有限公司 | Data query method and device, computer equipment and storage medium |
| CN113849838A (en) * | 2021-10-11 | 2021-12-28 | 京东城市(北京)数字科技有限公司 | Authority data management method and device, electronic equipment and storage medium |
| CN118227620A (en) * | 2024-03-12 | 2024-06-21 | 深圳市租享生活科技有限公司 | Database management method for enterprise supply chain |
Citations (11)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102197372A (en) * | 2008-10-24 | 2011-09-21 | 微软公司 | Partition management in a partitioned, scalable, and available structured storage |
| JP2012032858A (en) * | 2010-07-28 | 2012-02-16 | Nippon Telegr & Teleph Corp <Ntt> | Operation method of document search device and computer program for making computer execute the same |
| CN102867071A (en) * | 2012-10-19 | 2013-01-09 | 烽火通信科技股份有限公司 | Management method for massive network management historical data |
| CN103473321A (en) * | 2013-09-12 | 2013-12-25 | 华为技术有限公司 | Database management method and system |
| CN103714097A (en) * | 2012-10-09 | 2014-04-09 | 阿里巴巴集团控股有限公司 | Method and device for accessing database |
| CN104731951A (en) * | 2015-03-31 | 2015-06-24 | 北京奇艺世纪科技有限公司 | Data query method and device |
| CN105045816A (en) * | 2015-06-26 | 2015-11-11 | 上海斐讯数据通信技术有限公司 | Access method and system for mass data |
| CN105095393A (en) * | 2015-06-30 | 2015-11-25 | 努比亚技术有限公司 | Method and device for data storage |
| CN106886568A (en) * | 2017-01-12 | 2017-06-23 | 掌阅科技股份有限公司 | One kind point table method, device and electronic equipment |
| CN107239485A (en) * | 2017-04-18 | 2017-10-10 | 北京小度信息科技有限公司 | Database operation method, apparatus and system |
| CN107423387A (en) * | 2017-07-19 | 2017-12-01 | 北京北信源软件股份有限公司 | The method and apparatus of table is divided in a kind of point storehouse based on middleware |
-
2017
- 2017-12-19 CN CN201711372569.0A patent/CN108108434A/en active Pending
Patent Citations (11)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102197372A (en) * | 2008-10-24 | 2011-09-21 | 微软公司 | Partition management in a partitioned, scalable, and available structured storage |
| JP2012032858A (en) * | 2010-07-28 | 2012-02-16 | Nippon Telegr & Teleph Corp <Ntt> | Operation method of document search device and computer program for making computer execute the same |
| CN103714097A (en) * | 2012-10-09 | 2014-04-09 | 阿里巴巴集团控股有限公司 | Method and device for accessing database |
| CN102867071A (en) * | 2012-10-19 | 2013-01-09 | 烽火通信科技股份有限公司 | Management method for massive network management historical data |
| CN103473321A (en) * | 2013-09-12 | 2013-12-25 | 华为技术有限公司 | Database management method and system |
| CN104731951A (en) * | 2015-03-31 | 2015-06-24 | 北京奇艺世纪科技有限公司 | Data query method and device |
| CN105045816A (en) * | 2015-06-26 | 2015-11-11 | 上海斐讯数据通信技术有限公司 | Access method and system for mass data |
| CN105095393A (en) * | 2015-06-30 | 2015-11-25 | 努比亚技术有限公司 | Method and device for data storage |
| CN106886568A (en) * | 2017-01-12 | 2017-06-23 | 掌阅科技股份有限公司 | One kind point table method, device and electronic equipment |
| CN107239485A (en) * | 2017-04-18 | 2017-10-10 | 北京小度信息科技有限公司 | Database operation method, apparatus and system |
| CN107423387A (en) * | 2017-07-19 | 2017-12-01 | 北京北信源软件股份有限公司 | The method and apparatus of table is divided in a kind of point storehouse based on middleware |
Cited By (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111104672A (en) * | 2018-10-25 | 2020-05-05 | 迈普通信技术股份有限公司 | Data processing method and device |
| CN112685402A (en) * | 2019-10-17 | 2021-04-20 | 拉扎斯网络科技（上海）有限公司 | Data storage and query method and device, electronic equipment and storage medium |
| CN111190898A (en) * | 2019-11-25 | 2020-05-22 | 泰康保险集团股份有限公司 | Data processing method and device, electronic equipment and storage medium |
| CN111814441A (en) * | 2020-06-30 | 2020-10-23 | 平安科技（深圳）有限公司 | Report generation method, device, electronic device and storage medium |
| CN112685444A (en) * | 2020-12-24 | 2021-04-20 | 江苏苏宁云计算有限公司 | Data query method and device, computer equipment and storage medium |
| CN113849838A (en) * | 2021-10-11 | 2021-12-28 | 京东城市(北京)数字科技有限公司 | Authority data management method and device, electronic equipment and storage medium |
| CN118227620A (en) * | 2024-03-12 | 2024-06-21 | 深圳市租享生活科技有限公司 | Database management method for enterprise supply chain |
| CN118227620B (en) * | 2024-03-12 | 2024-09-20 | 深圳市租享生活科技有限公司 | Database management method for enterprise supply chain |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN108108434A (en) | A kind of method and device for managing database | |
| US11886802B2 (en) | Adaptive autofill systems and methods | |
| CN104408073B (en) | Data manipulation method and device | |
| CN108427748A (en) | Distributed data base secondary index querying method, device and server | |
| CN110826978A (en) | Unified backlog processing method and device based on enterprise browser | |
| US20170139836A1 (en) | Near-memory accelerator for offloading pointer chasing operations from a processing element | |
| CN109450969A (en) | The method, apparatus and server of data are obtained from third party's data source server | |
| CN117076720B (en) | Embedded table access method and device, electronic equipment and storage medium | |
| CN103370695A (en) | Database update notification method | |
| CN113778644A (en) | Task processing method, device, equipment and storage medium | |
| CN115438087B (en) | Data query method, device, storage medium and equipment based on cache library | |
| US9645873B2 (en) | Integrated configuration management and monitoring for computer systems | |
| CN114996557B (en) | Service stability determination method, device, equipment and storage medium | |
| CN118524059B (en) | Method, computer device and medium for hardware flow table management | |
| CN111104198A (en) | Method, equipment and medium for improving operation efficiency of scanning system plug-in | |
| CN104536785B (en) | Real-time system update method and device | |
| US20200057761A1 (en) | Adaptive metadata refreshing | |
| CN108763421B (en) | Data searching method and system based on logic circuit | |
| CN115580497A (en) | Data transmission control method and equipment in container environment and storage medium | |
| CN116680295A (en) | Method, system and device for processing data by multiple databases | |
| CN115168358A (en) | Database access method and device, electronic equipment and storage medium | |
| CN108089895A (en) | The register method of Activity, device, electronic equipment and storage medium in a kind of plug-in unit | |
| CN108846141B (en) | Offline cache loading method and device | |
| CN109284328B (en) | Relational data processing method, device, server and medium | |
| CN114064710A (en) | Data query method and device |
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: 20180601 |
|
| RJ01 | Rejection of invention patent application after publication |