CN109542933A - A kind of data base query method, device, equipment and medium - Google Patents
A kind of data base query method, device, equipment and medium Download PDFInfo
- Publication number
- CN109542933A CN109542933A CN201811463886.8A CN201811463886A CN109542933A CN 109542933 A CN109542933 A CN 109542933A CN 201811463886 A CN201811463886 A CN 201811463886A CN 109542933 A CN109542933 A CN 109542933A
- Authority
- CN
- China
- Prior art keywords
- paging
- result set
- database
- preset
- data
- 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.)
- Withdrawn
Links
- 238000000034 method Methods 0.000 title claims abstract description 48
- 230000006870 function Effects 0.000 claims abstract description 76
- 238000011161 development Methods 0.000 claims abstract description 43
- 238000004590 computer program Methods 0.000 claims description 9
- 239000011159 matrix material Substances 0.000 claims description 7
- 239000010979 ruby Substances 0.000 claims description 6
- 229910001750 ruby Inorganic materials 0.000 claims description 6
- 230000009467 reduction Effects 0.000 abstract description 9
- 230000009286 beneficial effect Effects 0.000 abstract description 2
- 230000000694 effects Effects 0.000 description 6
- 238000005516 engineering process Methods 0.000 description 6
- 238000013507 mapping Methods 0.000 description 6
- 235000013399 edible fruits Nutrition 0.000 description 5
- 238000012905 input function Methods 0.000 description 5
- 238000000151 deposition Methods 0.000 description 4
- 230000008569 process Effects 0.000 description 4
- 230000003993 interaction Effects 0.000 description 3
- 238000012216 screening Methods 0.000 description 3
- 238000004364 calculation method Methods 0.000 description 2
- 238000012512 characterization method Methods 0.000 description 2
- 238000004891 communication Methods 0.000 description 2
- 230000006872 improvement Effects 0.000 description 2
- 230000004048 modification Effects 0.000 description 2
- 238000012986 modification Methods 0.000 description 2
- 230000002688 persistence Effects 0.000 description 2
- 238000013459 approach Methods 0.000 description 1
- 230000008901 benefit Effects 0.000 description 1
- 230000008859 change Effects 0.000 description 1
- 238000013523 data management Methods 0.000 description 1
- 238000013500 data storage Methods 0.000 description 1
- 230000003247 decreasing effect Effects 0.000 description 1
- 238000005538 encapsulation Methods 0.000 description 1
- 230000002045 lasting effect Effects 0.000 description 1
- 230000035800 maturation Effects 0.000 description 1
- 230000000750 progressive effect Effects 0.000 description 1
- 238000000926 separation method Methods 0.000 description 1
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a kind of data base query method, device, equipment and media.The step of this method includes: to call preset paging function in ORM development kit;Paging function is executed according to preset paging condition, paging is carried out to control target database to local data, obtains each paging result set;It is retrieved in each paging result set according to preset querying condition and returns to target paging result set.For current data base querying mode, the local data of database without being all transmitted to the paging that can be realized in the memory of arithmetic facility to local data by this method, therefore the resource overhead of the storage equipment where relative reduction database, and then with respect to the stability for ensuring database work.In addition, the present invention also provides a kind of database inquiry device, equipment and medium, beneficial effect is same as above.
Description
Technical field
The present invention relates to field of data storage, more particularly to a kind of data base query method, device, equipment and medium.
Background technique
Currently under the overall background of cloud computing technology continuous development and maturation, the treating capacity of data is continuously increased, number
A kind of common approach according to library as current memory-efficient data provides relatively reliable data for cloud computing and supports.Due to
In the course of work of cloud computing, need frequently to inquire and read in the database the data of substantial amounts, therefore " paging "
Technology is one of technology commonly used by current data library inquiry.
Paging is a kind of technology checked that all data are showed to user with segmented version, what user saw every time
It is not all of data, but a part therein, if not finding oneself desired content wherein, user can pass through system
The mode for determining the page number or page turning converts content visible.
Most of current data base querying is realized by " kaminari " tool packet technology, and the technology is when implementing
Operation content be mainly the memory for obtaining all data in database to cloud computing equipment, and then to getting in the memory
Total data carry out paging, and to inquire and extract respectively as unit of page required for cloud computing effectively in cloud computing equipment
Data.Database is inquired by current mode, biggish volume of transmitted data can be generated, and needs to store in equipment
Database continue with cloud computing equipment in memory progress communications, communication interaction degree is higher, therefore current logarithmic evidence
The inquiry mode of data in library needs to occupy the storage a large amount of available resources of equipment, and then causes to store available resources in equipment
Quantity is greatly decreased, and seriously affects the normal work of storage equipment, thus is difficult to ensure the work of database in storage equipment
Stability.
It can be seen that a kind of data base query method is provided, with the resource of the storage equipment where relative reduction database
Expense, and then the opposite stability for ensuring database work, are those skilled in the art's urgent problems to be solved.
Summary of the invention
The object of the present invention is to provide a kind of data base query method, device, equipment and media, with relative reduction database
The resource overhead of the storage equipment at place, and then the opposite stability for ensuring database work.
In order to solve the above technical problems, the present invention provides a kind of data base query method, comprising:
Call preset paging function in ORM development kit;
Paging function is executed according to preset paging condition, paging is carried out to control target database to local data, obtains
Take each paging result set;
It is retrieved in each paging result set according to preset querying condition and returns to target paging result set.
Preferably, preset paging function in ORM development kit is called specifically:
Call preset paging function in ActiveRecord ORM development kit.
Preferably, preset paging function in ActiveRecord ORM development kit is called specifically:
Preset paging function in ActiveRecord ORM development kit is called by way of executing Ruby script.
Preferably, paging function is executed according to preset paging condition, is carried out with controlling target database to local data
Paging, obtaining each paging result set includes:
Paging function is executed according to paging condition, generation includes the target SQL statement of paging parameter;
Target database is controlled by target SQL statement, paging is carried out to local data, obtain each paging result set.
Preferably, the content of paging condition specifically includes target matrix, number of pages and page size;
Correspondingly, the data in each paging result set belong to target matrix, the quantity and paging number of paging result set
Measure it is identical, and in each paging result set data item number maximum value it is consistent with page size.
Preferably, control target database carries out paging to local data, obtains each paging result set specifically:
It controls target database and paging is carried out to local data, generate each paging result set of array type.
In addition, the present invention also provides a kind of database inquiry devices, comprising:
Function call module, for calling preset paging function in ORM development kit;
Pagination module, for executing paging function according to preset paging condition, to control target database to local number
According to paging is carried out, each paging result set is obtained;
Enquiry module, for being retrieved in each paging result set according to preset querying condition and returning to target paging result
Collection.
Preferably, pagination module includes:
Sentence generation module, for executing paging function according to paging condition, generation includes the target SQL of paging parameter
Sentence;
Statement execution module carries out paging to local data for controlling target database by target SQL statement, obtains
Each paging result set.
In addition, the present invention also provides a kind of database inquiry facilities, comprising:
Memory, for storing computer program;
Processor is realized when for executing computer program such as the step of above-mentioned data base query method.
In addition, being stored with meter on computer readable storage medium the present invention also provides a kind of computer readable storage medium
Calculation machine program is realized when computer program is executed by processor such as the step of above-mentioned data base query method.
Data base query method provided by the present invention, the paging function for being included in calling ORM development kit first, in turn
The paging function is executed using preset paging condition as input function, this secondary control target database is according to paging condition to it
Local data carries out paging activity, generates corresponding each paging result set, and then according to preset querying condition in each paging knot
Fruit, which is concentrated, to be retrieved and returns to corresponding target paging result set.Since the model layer of ORM development kit is integrated with ORM (object relationship
Mapping) function, not only represented the entity comprising service logic in the database, but also represent data object, thus by ORM exploitation
Packet can directly control database and execute corresponding service logic, and obtain corresponding data object, on this basis, this method
By preset paging function in above-mentioned development kit, it is right inside it that target database is directly controlled according to preset paging adjusting
Local data carries out paging, the target paging result set for generating corresponding paging result set, and further retrieving and returning.It compares
For current data base querying mode, this method is it is not necessary that the local data of database to be all transmitted in arithmetic facility
It can be realized the paging to local data in depositing, therefore the resource overhead of the storage equipment where relative reduction database, into
And the opposite stability for ensuring database work.In addition, the present invention also provides a kind of database inquiry device, equipment and Jie
Matter, beneficial effect are same as above.
Detailed description of the invention
In order to illustrate the embodiments of the present invention more clearly, attached drawing needed in the embodiment will be done simply below
It introduces, it should be apparent that, drawings in the following description are only some embodiments of the invention, for ordinary skill people
For member, without creative efforts, it is also possible to obtain other drawings based on these drawings.
Fig. 1 is a kind of flow chart of data base query method provided in an embodiment of the present invention;
Fig. 2 is a kind of structure chart of database inquiry device provided in an embodiment of the present invention.
Specific embodiment
Following will be combined with the drawings in the embodiments of the present invention, and technical solution in the embodiment of the present invention carries out clear, complete
Site preparation description, it is clear that described embodiments are only a part of the embodiments of the present invention, rather than whole embodiments.Based on this
Embodiment in invention, those of ordinary skill in the art are without making creative work, obtained every other
Embodiment belongs to the scope of the present invention.
Core of the invention is to provide a kind of data base query method, with the storage equipment where relative reduction database
Resource overhead, and then the opposite stability for ensuring database work.Another core of the invention is to provide a kind of data base querying
Device, equipment and medium.
In order to enable those skilled in the art to better understand the solution of the present invention, with reference to the accompanying drawings and detailed description
The present invention is described in further detail.
Embodiment one
Fig. 1 is a kind of flow chart of data base query method provided in an embodiment of the present invention.Referring to FIG. 1, database is looked into
The specific steps of inquiry method include:
Step S10: preset paging function in ORM development kit is called.
It should be noted that ORM (object-relational mapping, Object Relation Mapping) is a kind of pair of data
Data object in program, can be automatically converted to corresponding tables of data sum number in relevant database by the encapsulation of library access
According to the data column in table, and then corresponding data content in tables of data can also be obtained according to data object, be used without user
SQL statement can be interacted with database.Realize that with concrete operations content when data interaction include: creation number based on ORM
According to table;State the corresponding class of the tables of data;Instantiation operation is carried out to such, generates data table example;Pass through data table example
The corresponding control function of ORM is called and executed, realizes a series of interactions with database.
Preset paging function in signified calling ORM development kit in this step, essential purpose are load ORM development kits,
And the class in ORM development kit is instantiated, and then call paging function on the basis of instance object.In this step
Paging function is only the function for having two-page separation function to data in database, and paging function can be specially that ORM development kit is consolidated
Some functions are also possible to the function that user voluntarily writes according to practical paging demand, are not specifically limited herein.
Step S11: executing paging function according to preset paging condition, is carried out with controlling target database to local data
Paging obtains each paging result set.
It should be noted that the paging condition in this step is specifically specific restriction when executing to paging function, specifically
What is limited is specification or quantity of paging of paging etc..And then this step is using preset paging condition as the execution of paging function
Parameter, so that paging function carries out corresponding paging activity to local data according to paging condition control target database, in turn
Data result included in each page is at least wrapped in each page due to the paging condition according to user preset after acquisition paging
Data result containing one or more quantity, therefore the data result in each page accessed by this step, be with
What the form of result set was presented, i.e. paging result set.
Step S12: retrieving in each paging result set according to preset querying condition and returns to target paging result set.
Since this method is the querying method to database, final purpose is to get and be stored in database
Data, and in above-mentioned steps, the data in database are got in the form of paging result set, therefore in this step
In, it is the target paging result set needed for retrieving in each paging result set according to the querying condition of user and return to user.?
On the basis of this, the screening conditions to target paging result intensive data can be further arranged in user, and then in objective result collection
In further screening and returned to user and meet the data content of data screening condition, further increased with this to number in database
According to accuracy when being inquired.
Data base query method provided by the present invention, the paging function for being included in calling ORM development kit first, in turn
The paging function is executed using preset paging condition as input function, this secondary control target database is according to paging condition to it
Local data carries out paging activity, generates corresponding each paging result set, and then according to preset querying condition in each paging knot
Fruit, which is concentrated, to be retrieved and returns to corresponding target paging result set.Since the model layer of ORM development kit is integrated with ORM (object relationship
Mapping) function, not only represented the entity comprising service logic in the database, but also represent data object, thus by ORM exploitation
Packet can directly control database and execute corresponding service logic, and obtain corresponding data object, on this basis, this method
By preset paging function in above-mentioned development kit, it is right inside it that target database is directly controlled according to preset paging adjusting
Local data carries out paging, the target paging result set for generating corresponding paging result set, and further retrieving and returning.It compares
For current data base querying mode, this method is it is not necessary that the local data of database to be all transmitted in arithmetic facility
It can be realized the paging to local data in depositing, therefore the resource overhead of the storage equipment where relative reduction database, into
And the opposite stability for ensuring database work.
Embodiment two
On the basis of the above embodiments, the present invention also provides a series of preferred embodiments.
As a preferred embodiment, calling preset paging function in ORM development kit specifically:
Call preset paging function in ActiveRecord ORM development kit.
It should be noted that ActiveRecord is the one mode of ORM, the code of persistence can be integrated into data
In object, i.e., the data object can store data to database according to the code of persistence, can also in the database with
Certain constraint condition reads data.It is different with traditional ORM, traditional ORM can data object and be responsible for it is lasting
The code of change separates, and data object is a simple structural body comprising data, transmits in model layer and ORM layers, and
In ActiveRecord, model layer is integrated with the function of ORM, they both represent entity, includes service logic, and be data pair
As, therefore ActiveRecord ORM development kit has higher code integrated level, efficiency when mutually calling between code compared with
Height, and then in the present embodiment, by preset paging function in calling ActiveRecord ORM development kit to database
In data carry out paging and obtain paging result set overall process have higher execution efficiency.
On the basis of the above embodiment, as a preferred embodiment, calling ActiveRecordORM exploitation
Preset paging function in packet specifically:
Preset paging function in ActiveRecord ORM development kit is called by way of executing Ruby script.
It should be noted that Ruby scripting language have it is succinct, efficiently program advantage, can be by the script language that shortens
Speech develops the relatively powerful Ruby script of function, therefore under present embodiment, relatively short by executing the development cycle
Ruby script calls preset paging function in ActiveRecord ORM development kit, opposite can reduce user realize to point
The overall overhead when calling of page function.
In addition, as a preferred embodiment, paging function is executed according to preset paging condition, to control target
Database carries out paging to local data, and obtaining each paging result set includes:
Paging function is executed according to paging condition, generation includes the target SQL statement of paging parameter;
Target database is controlled by target SQL statement, paging is carried out to local data, obtain each paging result set.
It should be noted that the paging function in present embodiment generates corresponding target SQL statement according to paging condition,
Include in target SQL statement meet the paging parameter of paging condition, and then by target SQL statement control target database according to
Paging is carried out to its local data according to paging parameter, and obtains each paging result set.Due to SQL statement collection data definition, number
According to operation, data management function in one, diction is unified, can with all operationss of complete independently database, therefore this
Paging is carried out to local data using SQL statement control target database in embodiment, opposite can be guaranteed to target data
The comprehensive and flexibility of library control.
In addition, as a preferred embodiment, the content of paging condition specifically includes target matrix, number of pages
And page size;
Correspondingly, the data in each paging result set belong to target matrix, the quantity and paging number of paging result set
Measure it is identical, and in each paging result set data item number maximum value it is consistent with page size.
It should be noted that in present embodiment, the content of paging condition specifically include target matrix, number of pages with
And page size, what target matrix characterized is the specific source for the data that user is inquired in the database;Number of pages characterization
Be user need in the tables of data data carry out paging specific number of pages;Page size characterization is the number for including in each page
According to amount.It can be relatively accurate by above-mentioned three paging conditions and uniquely to the data progress paging in database, it is ensured that
The availability of paging result set.
In addition, on the basis of a series of above-mentioned embodiments, as a preferred embodiment, control target data
Library carries out paging to local data, obtains each paging result set specifically:
It controls target database and paging is carried out to local data, generate each paging result set of array type.
It should be noted that the paging result set in present embodiment is the generation in the form of array, due to consideration that
Array can store mass data, and relatively high according to index traversal array efficiency, therefore the paging in present embodiment
Result set is specially the form of data, can be with respect to the data normal storage that ensure in each paging in paging result set, and is divided
Data in page result set and paging result set can improve the whole reliable of data base querying by the reading of relative efficiency
Property and high efficiency.
Embodiment three
Hereinbefore the embodiment of data base query method is described in detail, the present invention also provides it is a kind of with
The corresponding database inquiry device of this method, since the embodiment of device part is corresponded to each other with the embodiment of method part, because
The embodiment of this device part refers to the description of the embodiment of method part, wouldn't repeat here.
Fig. 2 is a kind of structure chart of database inquiry device provided in an embodiment of the present invention.It is provided in an embodiment of the present invention
Database inquiry device, comprising:
Function call module 10, for calling preset paging function in ORM development kit.
Pagination module 11, for executing paging function according to preset paging condition, to control target database to local
Data carry out paging, obtain each paging result set.
Enquiry module 12, for being retrieved in each paging result set according to preset querying condition and returning to target paging knot
Fruit collection.
Database inquiry device provided by the present invention, the paging function for being included in calling ORM development kit first, in turn
The paging function is executed using preset paging condition as input function, this secondary control target database is according to paging condition to it
Local data carries out paging activity, generates corresponding each paging result set, and then according to preset querying condition in each paging knot
Fruit, which is concentrated, to be retrieved and returns to corresponding target paging result set.Since the model layer of ORM development kit is integrated with ORM (object relationship
Mapping) function, not only represented the entity comprising service logic in the database, but also represent data object, thus by ORM exploitation
Packet can directly control database and execute corresponding service logic, and obtain corresponding data object, on this basis, the present apparatus
By preset paging function in above-mentioned development kit, it is right inside it that target database is directly controlled according to preset paging adjusting
Local data carries out paging, the target paging result set for generating corresponding paging result set, and further retrieving and returning.It compares
For current data base querying mode, the present apparatus is it is not necessary that the local data of database to be all transmitted in arithmetic facility
It can be realized the paging to local data in depositing, therefore the resource overhead of the storage equipment where relative reduction database, into
And the opposite stability for ensuring database work.
On the basis of embodiment three, pagination module includes:
Sentence generation module, for executing paging function according to paging condition, generation includes the target SQL of paging parameter
Sentence.
Statement execution module carries out paging to local data for controlling target database by target SQL statement, obtains
Each paging result set.
Example IV
The present invention also provides a kind of database inquiry facilities, comprising:
Memory, for storing computer program;
Processor is realized when for executing computer program such as the step of above-mentioned data base query method.
Database inquiry facility provided by the present invention, the paging function for being included in calling ORM development kit first, in turn
The paging function is executed using preset paging condition as input function, this secondary control target database is according to paging condition to it
Local data carries out paging activity, generates corresponding each paging result set, and then according to preset querying condition in each paging knot
Fruit, which is concentrated, to be retrieved and returns to corresponding target paging result set.Since the model layer of ORM development kit is integrated with ORM (object relationship
Mapping) function, not only represented the entity comprising service logic in the database, but also represent data object, thus by ORM exploitation
Packet can directly control database and execute corresponding service logic, and obtain corresponding data object, on this basis, this equipment
By preset paging function in above-mentioned development kit, it is right inside it that target database is directly controlled according to preset paging adjusting
Local data carries out paging, the target paging result set for generating corresponding paging result set, and further retrieving and returning.It compares
For current data base querying mode, this equipment is it is not necessary that the local data of database to be all transmitted in arithmetic facility
It can be realized the paging to local data in depositing, therefore the resource overhead of the storage equipment where relative reduction database, into
And the opposite stability for ensuring database work.
In addition, being stored with meter on computer readable storage medium the present invention also provides a kind of computer readable storage medium
Calculation machine program is realized when computer program is executed by processor such as the step of above-mentioned data base query method.
Computer readable storage medium provided by the present invention, the paging function for being included in calling ORM development kit first,
And then the paging function is executed using preset paging condition as input function, this secondary control target database is according to paging condition
Paging activity is carried out to its local data, generates corresponding each paging result set, and then according to preset querying condition at each point
It is retrieved in page result set and returns to corresponding target paging result set.Since the model layer of ORM development kit is integrated with ORM (object
Relationship map) function, not only represented the entity comprising service logic in the database, but also represent data object, therefore pass through ORM
Development kit can directly control database and execute corresponding service logic, and obtain corresponding data object, on this basis, this
Computer readable storage medium directly controls mesh by preset paging function in above-mentioned development kit, according to preset paging adjusting
It marks database and paging is carried out to local data inside it, generate corresponding paging result set, and further retrieve and return
Target paging result set.For current data base querying mode, this computer readable storage medium is not necessarily to data
The local data in library is all transmitted to the paging that can be realized in the memory of arithmetic facility to local data, therefore relative reduction
The resource overhead of storage equipment where database, and then the opposite stability for ensuring database work.
A kind of data base query method provided by the present invention, device, equipment and medium are described in detail above.
Each embodiment is described in a progressive manner in specification, the highlights of each of the examples are with other embodiments not
Same place, the same or similar parts in each embodiment may refer to each other.For the device disclosed in the embodiment, due to it
It corresponds to the methods disclosed in the examples, so being described relatively simple, reference may be made to the description of the method.It should
It points out, it for those skilled in the art, without departing from the principle of the present invention, can also be to this hair
Bright some improvement and modification can also be carried out, and these improvements and modifications also fall within the scope of protection of the claims of the present invention.
It should also be noted that, in the present specification, relational terms such as first and second and the like be used merely to by
One entity or operation are distinguished with another entity or operation, without necessarily requiring or implying these entities or operation
Between there are any actual relationship or orders.Moreover, the terms "include", "comprise" or its any other variant meaning
Covering non-exclusive inclusion, so that the process, method, article or equipment for including a series of elements not only includes that
A little elements, but also including other elements that are not explicitly listed, or further include for this process, method, article or
The intrinsic element of equipment.In the absence of more restrictions, the element limited by sentence "including a ...", is not arranged
Except there is also other identical elements in the process, method, article or apparatus that includes the element.
Claims (10)
1. a kind of data base query method characterized by comprising
Call preset paging function in ORM development kit;
The paging function is executed according to preset paging condition, paging is carried out to control target database to local data, obtains
Take each paging result set;
It is retrieved in each paging result set according to preset querying condition and returns to target paging result set.
2. the method according to claim 1, wherein preset paging function tool in the calling ORM development kit
Body are as follows:
Call the preset paging function in ActiveRecord ORM development kit.
3. according to the method described in claim 2, it is characterized in that, being preset in the calling ActiveRecord ORM development kit
The paging function specifically:
The preset paging function in the ActiveRecord ORM development kit is called by way of executing Ruby script.
4. the method according to claim 1, wherein described execute the paging letter according to preset paging condition
Number carries out paging to control target database to local data, and obtaining each paging result set includes:
The paging function is executed according to the paging condition, generation includes the target SQL statement of paging parameter;
The target database is controlled by the target SQL statement, paging is carried out to the local data, obtain each described point
Page result set.
5. the method according to claim 1, wherein the content of the paging condition specifically includes target data
Table, number of pages and page size;
Correspondingly, the data in each paging result set belong to the target matrix, the quantity of the paging result set
It is identical as the number of pages, and in each paging result set data item number maximum value it is consistent with the page size.
6. according to claim 1 to method described in 5 any one, which is characterized in that the control target database is to local
Data carry out paging, obtain each paging result set specifically:
It controls the target database and paging is carried out to the local data, generate each paging result set of array type.
7. a kind of database inquiry device characterized by comprising
Function call module, for calling preset paging function in ORM development kit;
Pagination module, for executing the paging function according to preset paging condition, to control target database to local number
According to paging is carried out, each paging result set is obtained;
Enquiry module, for being retrieved in each paging result set according to preset querying condition and returning to target paging result
Collection.
8. device according to claim 7, which is characterized in that the pagination module includes:
Sentence generation module, for executing the paging function according to the paging condition, generation includes the mesh of paging parameter
Mark SQL statement;
Statement execution module carries out the local data for controlling the target database by the target SQL statement
Paging obtains each paging result set.
9. a kind of database inquiry facility characterized by comprising
Memory, for storing computer program;
Processor realizes such as data base querying side as claimed in any one of claims 1 to 6 when for executing the computer program
The step of method.
10. a kind of computer readable storage medium, which is characterized in that be stored with computer on the computer readable storage medium
Program realizes such as data base query method as claimed in any one of claims 1 to 6 when the computer program is executed by processor
The step of.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201811463886.8A CN109542933A (en) | 2018-12-03 | 2018-12-03 | A kind of data base query method, device, equipment and medium |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201811463886.8A CN109542933A (en) | 2018-12-03 | 2018-12-03 | A kind of data base query method, device, equipment and medium |
Publications (1)
Publication Number | Publication Date |
---|---|
CN109542933A true CN109542933A (en) | 2019-03-29 |
Family
ID=65852662
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201811463886.8A Withdrawn CN109542933A (en) | 2018-12-03 | 2018-12-03 | A kind of data base query method, device, equipment and medium |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN109542933A (en) |
Cited By (1)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN111125148A (en) * | 2019-12-12 | 2020-05-08 | 中化石化销售有限公司 | Paging query method and device for database |
-
2018
- 2018-12-03 CN CN201811463886.8A patent/CN109542933A/en not_active Withdrawn
Cited By (2)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN111125148A (en) * | 2019-12-12 | 2020-05-08 | 中化石化销售有限公司 | Paging query method and device for database |
CN111125148B (en) * | 2019-12-12 | 2023-07-07 | 中化石化销售有限公司 | Paging query method and device for database |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN107038207A (en) | A kind of data query method, data processing method and device | |
CN104281701B (en) | Multiscale Distributed Spatial data query method and system | |
CN111078702B (en) | SQL sentence classification management and unified query method and device | |
CN103020158A (en) | Report form creation method, device and system | |
CN108536692A (en) | A kind of generation method of executive plan, device and database server | |
CN103631596A (en) | Configuration device and configuration method of business object data entry and updating rule | |
CN102855332A (en) | Graphic configuration management database based on graphic database | |
CN104021198A (en) | Relational database information retrieval method and device based on ontology semantic index | |
CN107291471A (en) | A kind of Meta model framework system for supporting customizable data acquisition | |
CN109446252A (en) | A kind of unified access method and system for power grid regulation | |
CN103455335A (en) | Multilevel classification Web implementation method | |
CN106021583A (en) | Statistical method and system for page flow data | |
CN106649226A (en) | Report generation method and device | |
CN103390018A (en) | Web service data modeling and searching method based on SDD (service data description) | |
CN108776678A (en) | Index creation method and device based on mobile terminal NoSQL databases | |
CN102158533B (en) | Distributed web service selection method based on QoS (Quality of Service) | |
CN110706125A (en) | Water conservancy big data analysis information service system and platform service system | |
CN115840567A (en) | Application editing method and related equipment | |
CN107102995A (en) | A kind of determination method and device of SQL executive plans | |
CN112698819A (en) | Method, device and storage medium for designing tree-oriented object programming program | |
CN103226794A (en) | Data processing method of power transmission and distribution line | |
CN109542933A (en) | A kind of data base query method, device, equipment and medium | |
CN105138692B (en) | A kind of big data accesses and the middleware custom-built system and method for management | |
CN111858521A (en) | Distribution network engineering design data sharing cloud platform and application method | |
CN105653523A (en) | Energy consumption supervise network of things basis platform system building method |
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 | ||
WW01 | Invention patent application withdrawn after publication |
Application publication date: 20190329 |
|
WW01 | Invention patent application withdrawn after publication |