CN101021875A - Object-oriented data bank access method and system - Google Patents

Object-oriented data bank access method and system Download PDF

Info

Publication number
CN101021875A
CN101021875A CN 200710087246 CN200710087246A CN101021875A CN 101021875 A CN101021875 A CN 101021875A CN 200710087246 CN200710087246 CN 200710087246 CN 200710087246 A CN200710087246 A CN 200710087246A CN 101021875 A CN101021875 A CN 101021875A
Authority
CN
China
Prior art keywords
key assignments
sql statement
condition
visit
field
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Granted
Application number
CN 200710087246
Other languages
Chinese (zh)
Other versions
CN100550019C (en
Inventor
郭志波
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Kingdee Software China Co Ltd
Original Assignee
Kingdee Software China Co Ltd
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by Kingdee Software China Co Ltd filed Critical Kingdee Software China Co Ltd
Priority to CNB2007100872467A priority Critical patent/CN100550019C/en
Publication of CN101021875A publication Critical patent/CN101021875A/en
Application granted granted Critical
Publication of CN100550019C publication Critical patent/CN100550019C/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Images

Landscapes

  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

Abstract

This invention discloses an access method and a system for database facing objects, in which, said method includes: analyzing requests of objects to obtain accessed database list names, at least one access field, a condition field and a condition comparing value, generating key assignments based on the analyzed result including database list names, access fields and access condition fields, looking for parameterized SQL sentences corresponding to said key assignments and generating parameterized SQL sentences and storing them if they are not found out and setting the condition comparing value to a request parameter, if they are found out, then the request parameter is assigned to execute related access operation, in this invention, similar object requests use a same parameterized SQL sentence so as to reduce time cost for editing and generating SQL sentences many times.

Description

OODB Object Oriented Data Base access method and system
Technical field
The present invention relates to database access technology, particularly relate to OO data bank access method and system.
Background technology
Object Relationship Mapping (be called for short ORMapping) is mapped as class in the object-oriented system with database table, and each bar record in the table then corresponds to the technology of such concrete object.By this technology, can in the process of software development, adopt OO mode to handle the part relevant, such as the increase of writing down, modification, deletion etc. with database.
OODB Object Oriented Data Base becomes object to the data layout, and object can have attribute, and each attribute also is an object.In the ORMapping technology, can generate SQL (Structured Query Language according to request (generally being divided into operations such as increasing record, deletion record, query note) to data library access operation, Structured Query Language (SQL)) statement, described process according to the different SQL statement of different Object Operations generations is called compiling.Because duplicate Object Operations can produce same SQL statement, so some ORMapping product can carry out buffer memory to the SQL statement that duplicate object requests generates, avoid the compilation operations of repetition, thereby improve the performance of ORMapping.
Under certain scene,, then can utilize above-mentioned caching method to improve the compilation performance of ORMapping to a certain extent if there are a large amount of duplicate Object Operations in the system.But in most of the cases, request to each object in the system is not just the same, therefore the effect of said method performance is just very little, can't solve and repeatedly compile the problem that SQL statement is brought each inefficient operation among the ORMapping, thereby influence the performance of ORMapping.
Summary of the invention
Technical matters to be solved by this invention provides OODB Object Oriented Data Base access method and system, repeatedly compiles SQL statement to solve among the ORMapping, brings the problem of inefficient operation.
For solving the problems of the technologies described above, the invention provides the OODB Object Oriented Data Base access method, comprising:
The analytic target request obtains database table name, at least one visit field, the condition field of at least one visit, the condition fiducial value of visiting;
Generate key assignments according to analysis result, described key assignments comprises condition field, the combination of the part in the condition fiducial value of database table name, visit field, visit;
Search the parametrization SQL statement of answering with described key-value pair;
If do not find, then generate parameterized SQL statement and preservation, wherein with the one or more required parameters that are made as except that the key assignments ingredient in the described analysis result; If find, then to carrying out corresponding accessing operation after the described request parameter assignment.
Wherein, generate key assignments: each ingredient of key assignments according to rule of combination, is spliced into key assignments according to following steps.
Wherein, described object requests is based on structurized Object Query statement, directly therefrom obtains request content; Described object requests is based on formal Object Query statement, forms structurized Object Query statement by grammatical analysis, directly therefrom obtains request content then.
Preferably, preserve described parameterized SQL statement with the Hash table form.
Preferably, also comprise: in described parameterized SQL statement, delete least-recently-used SQL statement.
Based on described OODB Object Oriented Data Base access method, the present invention also provides preferred version, comprising:
The analytic target request obtains database table name, at least one visit field, the condition field of at least one visit, the condition fiducial value of visiting;
Generate key assignments according to analysis result, described key assignments comprises the condition field of database table name, visit field, visit;
Search the parametrization SQL statement of answering with described key-value pair;
If do not find, then generate parameterized SQL statement and preservation, wherein described condition fiducial value is made as required parameter; If find, then to carrying out corresponding accessing operation after the described request parameter assignment.
Wherein, generate key assignments: each ingredient of key assignments according to rule of combination, is spliced into key assignments according to following steps.
Preferably, preserve described parameterized SQL statement with the Hash table form.
Preferably, also comprise: in described parameterized SQL statement, delete least-recently-used SQL statement.
The invention provides the OODB Object Oriented Data Base access system, comprising:
The requirement analysis unit is used for the analytic target request, obtains database table name, at least one visit field, the condition field of at least one visit, the condition fiducial value of visit;
The key assignments generation unit is used for generating key assignments according to the analysis result of described request analytic unit, and described key assignments comprises condition field, the combination of the part in the condition fiducial value of database table name, visit field, visit;
Indexing units is used to search the parametrization SQL statement of answering with described key-value pair; If do not find, then generate parameterized SQL statement and be stored in storage unit, wherein with the one or more required parameters that are made as except that the key assignments ingredient in the described analysis result; If find, then to carrying out corresponding accessing operation after the described request parameter assignment;
Storage unit is used to preserve parameterized SQL statement.
Preferably, described key assignments comprises the condition field of database table name, visit field, visit, and described condition fiducial value is a required parameter.
Wherein, described key assignments generation unit according to rule of combination, is spliced into key assignments with each ingredient of key assignments.
Preferably, described storage unit is preserved described parameterized SQL statement with the form of Hash table.
Preferably, described storage unit is deleted least-recently-used SQL statement.
Compared with prior art, the present invention has the following advantages:
At first, the present invention is directed to many similar OO request of access in the operation system, as the condition field of the database table name of visit, visit field, visit, but the different object requests of condition fiducial value (one or more), compiling generates same parameterized SQL statement and storage, as the condition fiducial value is made as required parameter.Then for the request that meets the parameter condition, just can directly use the SQL statement of storage by the parameter assignment, therefore similarly object requests needn't all recompilate the generation SQL statement at every turn.Compare with original cache way, the present invention with the expanded range of hitting of SQL statement, has reduced the repeatedly time overhead of compiling generation SQL statement by parameterized method to greatest extent, has greatly improved the performance of ORMapping system.
Secondly, the present invention adopts least-recently-used strategy, and the SQL statement deletion that frequency of utilization in the buffer memory is low keeps within the specific limits the capacity of buffer memory, thereby avoids too much committed memory space.
Description of drawings
Fig. 1 is an OODB Object Oriented Data Base access method process flow diagram of the present invention;
Fig. 2 is an OODB Object Oriented Data Base access system structured flowchart of the present invention.
Embodiment
For above-mentioned purpose of the present invention, feature and advantage can be become apparent more, the present invention is further detailed explanation below in conjunction with the drawings and specific embodiments.
In the ORMapping operation system, though the operation major part to object is different, but much be similarly, for example have many of this sort query manipulations: the condition field of the database table name of inquiry, inquiry field, inquiry is the same, but the fiducial value difference of querying condition.Illustrate, as the query manipulation to the student achievement data table, the attribute information of described tables of data comprises: personal information such as student number, student name, scores of each subject such as English, mathematics, Chinese language, overall scores, average achievement.Wherein, described student achievement data table is the inquiry main body, is adopting OO mode to handle in the technology with the database relevant portion, and every student in the table writes down an object in the corresponding class.Every kind of accessing operation of database as inquiry, insertion, deletion, modification etc., all is the operation to the inquiry main body.
If the score of each subject field is inquired about, with the student score of each subject output of average achievement, then to inquire about field and be score of each subject more than or equal to 85 minutes, the condition field of inquiry is an average achievement, the condition fiducial value was more than or equal to 85 minutes.Wherein, the condition field of described inquiry may be included in the inquiry field, also may be different with the inquiry field.And the condition fiducial value can be changed arbitrarily, as inquiring about average achievement more than or equal to 90 minutes or less than 80 minutes student information.
At above-mentioned similar Object Operations situation, the present invention proposes a kind of OODB Object Oriented Data Base access method, SQL statement parametrization with similar operations, receive the object requests that meets the parameter condition at every turn, by the SQL statement that the direct use of parameter assignment has generated, save the time overhead that repeats to compile.Under the situation that the condition fiducial value of inquiry as mentioned above can be changed arbitrarily, just condition fiducial value (one or more) parametrization can be called same parameterized SQL statement with the assignment difference of condition fiducial value at every turn.
With reference to Fig. 1, be OODB Object Oriented Data Base access method process flow diagram of the present invention.Described method is applicable to common access type, comprises Object Operations such as inquiry, insertion, deletion, modification, and the action type difference, and pairing parametrization SQL statement is also inequality.Following content will be that embodiment describes with the query manipulation
Step 101, analysis request.Usually, the present invention is used to handle the external object request that receives by unified application interface, described object requests is based on the description (being metadata) of object, two kinds of forms of expression are arranged usually: a kind of is structurized Object Query statement, another kind is based on formal Object Query statement, as OQL statement (a kind of complete OO data base query language).For structurized Object Query statement, owing to request package is contained in certain data structure, so can from request, directly extract the element that is comprised.Comprise inquiry main body, inquiry field, the condition field of inquiry, the elements such as condition fiducial value of inquiry in the object requests.And for the OQL statement, then need to form structurized data structure by grammatical analysis to OQL, as first kind of request mode, just can from structurized request, extract inquiry main body, inquiry field, the condition field of inquiry, the elements such as condition fiducial value of inquiry.About how resolving OQL, promptly the parsing method of OQL in the description of the invention scope, does not describe at this.
Step 102 generates key assignments.According to above-mentioned analysis result, with the condition field combination generation key assignments of inquiry main body, inquiry field, inquiry, each key-value pair is answered a parameterized SQL statement, and described key assignments is used for carrying out index as index terms.In the key assignments forming process, the various piece that at first will form key assignments changes into character string, and this is because in tables of data, and the value that has attribute field is not the situation of character string, is digital form as the value of attributes such as time, the amount of money.Then,, each character string is stitched together, promptly forms key assignments according to certain rule of combination.In with the parameterized embodiment of condition fiducial value, key assignments mainly comprises three parts: the attribute list (being one or more inquiry fields) of object name (i.e. Cha Xun data table name), inquiry, the condition list (being the condition field of one or more inquiries) of inquiry.
About generating the rule of combination of key assignments, can adopt several different methods well-known to those skilled in the art, the simplest is exactly that still this method causes the oversize problem of key assignments length easily with the character string direct splicing of each component together.So preferred, according to the synthetic key assignments of certain rule sets, save storage space usually with certain-length.For various rules of combination, do not describe at this.
Step 103 is searched buffer memory.The present invention carries out buffer memory with the parametrization SQL statement that each key-value pair is answered, and is preferred, by Hash table SQL statement is stored in the internal memory, and is index by key assignments, searches in Hash table and calls the relevant parameters SQL statement.Adopting the data structure storage of Hash table, is to consider that from the aspect of performance of searching the seek rate of Hash table is fast.Certainly, also can adopt array or other data structure storage, but that performance is compared is relatively poor.For the key assignments that step 102 generates, in buffer memory, search whether there is the corresponding parameters SQL statement, if exist, then can directly call execution in step 105; Otherwise, execution in step 104.
Step 104 generates parameterized SQL statement, and puts into buffer memory, continues execution in step 105.For the situation of in buffer memory, not hitting, then the object requests compiling that receives is generated parameterized SQL statement and storage, so that follow-up similar request is used.The present invention is preferred, for making spatial cache remain on a constant volume, SQL statement in the buffer memory is used least-recently-used strategy, the parametrization SQL statement deletion that frequency of utilization is low, then constantly deposit circulation of SQL statement formation that new SQL statement and deletion are constantly seldom used in, avoid too much committed memory space.
Step 105, the binding parameter.If hit in buffer memory, then the object requests of Jie Shouing does not need to recompilate the generation SQL statement, directly calls key assignments corresponding parameters SQL statement from buffer memory, and the value and the parametrization SQL statement of corresponding parameter bound in will asking.In with the parameterized embodiment of condition fiducial value, condition fiducial value (one or more) assignment that is about in the request is given parameterized SQL statement, and the query manipulation that the condition fiducial value is different so key assignments is identical just can use same compiling statement.
Step 106 is carried out SQL statement, return results.According to request content to the parameter assignment in the SQL statement after, database is carried out corresponding operating, and, finishes OO database manipulation the transmitting terminal that the result returns to object requests.
Illustrate, as in the query manipulation of above-mentioned student achievement data table, object requests need be exported the English achievement more than or equal to student's personal information of 90 minutes, and another object requests need be with the student personal information output of English achievement less than 60 minutes.Then use method provided by the invention, the condition fiducial value (score value that is the English achievement is judged) of condition field (being the English achievement) is made as parameter, generate a parameterized SQL statement, and corresponding key assignments is made up of student achievement data table name, personal information field (comprising student number, student name etc.), English achievement field, then the key assignments of two object requests generations is identical, can use same SQL statement.
In the embodiment of above-mentioned query manipulation, if what carry out is operations such as increases, delete database record, then need to generate different parametrization SQL statement, i.e. action type difference, the corresponding parameters SQL statement is difference also.
With condition fiducial value parametrization is a kind of situation commonly used, but based on thought of the present invention, at different application, also can carry out parametrization to other elements in the request, and promptly the composition of key assignments also changes with the difference that is provided with of parameter.For example in the query manipulation of above-mentioned student achievement data table, supposing need be with the student personal information output of average achievement more than or equal to 85 minutes, perhaps with of the student personal information output of Chinese language achievement more than or equal to 85 minutes, promptly Cha Xun condition field (average achievement or Chinese language achievement) changes, and inquiry field (the student's personal information that needs output) and condition fiducial value (more than or equal to 85 minutes) are fixed, then the condition field with inquiry is made as required parameter, and corresponding key assignments composition is also changed into inquiry main body, inquiry field, condition fiducial value.
In a word,, can pass through the method for the invention, avoid repeatedly recompilating, and, improve the performance of ORMapping system the expanded range of hitting of SQL statement for the high similar operation request of frequency of utilization.
At said method, the present invention also provides the OODB Object Oriented Data Base access system, and with reference to shown in Figure 2, described system comprises storage unit 201, requirement analysis unit 202, key assignments generation unit 203, indexing units 204.
Storage unit 201 is used to preserve parameterized SQL statement, and according to different applicable cases, each element in the object requests can be made as parameter, and certainly in the ORMapping technology, commonly used is that the condition fiducial value is made as parameter at present.Preferably, SQL statement is stored in the internal memory, and is index, in Hash table, search and call the relevant parameters SQL statement by key assignments by Hash table.Adopt the data structure storage of Hash table, seek rate is very fast, has improved system performance.And, also least-recently-used SQL statement in the storage unit 201 is deleted, guarantee not increasing and take too much internal memory of storage unit 201 with SQL statement.
Requirement analysis unit 202 is used for the external object request that receives by unified application interface is analyzed.Comprise inquiry main body, inquiry field, the condition field of inquiry, the elements such as condition fiducial value of inquiry in the object requests, therefrom extract each element by analyzing.The form of expression of object requests is divided into based on structurized Object Query statement with based on formal Object Query statement (as the OQL statement), owing to structurized request package is contained in certain data structure, so can directly extract the element that is comprised; And based on the request of OQL, then need to form structurized data structure by the grammatical analysis to OQL, just can from structurized request, extract inquiry main body, inquiry field, the condition field of inquiry, the elements such as condition fiducial value of inquiry.About the parsing method of OQL, or not do not describe at this in the description of the invention scope.
Key assignments generation unit 203 is used for the analysis result according to requirement analysis unit 202, and the element combinations in the request is generated key assignments, search parameterized SQL statement as index terms in storage unit 201, and each key-value pair is answered a parameterized SQL statement.For example, for the situation that the condition fiducial value is made as parameter, key assignments is made up of the condition field of inquiry main body, inquiry field, inquiry, and promptly key assignments comprises the attribute list (being one or more inquiry fields) of object name (i.e. Cha Xun data table name), inquiry, the condition list (being the condition field of one or more inquiries) of inquiry.According to different application, also other elements can be made as parameter, corresponding key assignments is formed also change.
The formation of key assignments is exactly that each element of forming key assignments is changed into one section character string, then each character string combination is formed key assignments.Preferably, character string is being spliced in the process of key assignments, can adopting multiple rule of combination well-known to those skilled in the art, shortening key assignments length, saving storage space.
Indexing units 204 is used for searching the corresponding parameters SQL statement according to newly-generated key assignments in storage unit 201.If find, then explanation has had similar operation to finish the process of compiling generation SQL statement, for new object requests, just needn't recompilate, can be directly with parameter in the request and the binding of parameterized SQL statement, finish corresponding operating, and operating result is returned to the request transmit leg.If the parametrization SQL statement of not answering with described key-value pair in the storage unit 201 then needs to generate parameterized SQL statement through compilation process, and deposits storage unit 201 in, so that follow-up similar operations is called; Then with required parameter binding, executable operations.
In a word, the similar object requests compiling that the present invention will often use generates parameterized SQL statement, and storage, when receiving similar request, carry out index by the generation key assignments and reuse parameterized SQL statement, reduce to greatest extent and repeat compiling, greatly improved the performance of ORMapping system.
More than to OODB Object Oriented Data Base access method provided by the present invention and system, be described in detail, used specific case herein principle of the present invention and embodiment are set forth, the explanation of above embodiment just is used for helping to understand method of the present invention and core concept thereof; Simultaneously, for one of ordinary skill in the art, according to thought of the present invention, part in specific embodiments and applications all can change.In sum, this description should not be construed as limitation of the present invention.

Claims (15)

1, the OODB Object Oriented Data Base access method is characterized in that, comprising:
The analytic target request obtains database table name, at least one visit field, the condition field of at least one visit, the condition fiducial value of visiting;
Generate key assignments according to analysis result, described key assignments comprises condition field, the combination of the part in the condition fiducial value of database table name, visit field, visit;
Search the parametrization SQL statement of answering with described key-value pair;
If do not find, then generate parameterized SQL statement and preservation, wherein with the one or more required parameters that are made as except that the key assignments ingredient in the described analysis result; If find, then to carrying out corresponding accessing operation after the described request parameter assignment.
2, method according to claim 1 is characterized in that, generates key assignments according to following steps: each ingredient of key assignments according to rule of combination, is spliced into key assignments.
3, method according to claim 1 is characterized in that: described object requests is based on structurized Object Query statement, directly therefrom obtains request content.
4, method according to claim 1 is characterized in that: described object requests is based on formal Object Query statement, forms structurized Object Query statement by grammatical analysis, directly therefrom obtains request content then.
5, method according to claim 1 is characterized in that: preserve described parameterized SQL statement with the Hash table form.
6, method according to claim 1 is characterized in that, also comprises: in described parameterized SQL statement, delete least-recently-used SQL statement.
7, the OODB Object Oriented Data Base access method is characterized in that, comprising:
The analytic target request obtains database table name, at least one visit field, the condition field of at least one visit, the condition fiducial value of visiting;
Generate key assignments according to analysis result, described key assignments comprises the condition field of database table name, visit field, visit;
Search the parametrization SQL statement of answering with described key-value pair;
If do not find, then generate parameterized SQL statement and preservation, wherein described condition fiducial value is made as required parameter; If find, then to carrying out corresponding accessing operation after the described request parameter assignment.
8, method according to claim 7 is characterized in that, generates key assignments according to following steps: each ingredient of key assignments according to rule of combination, is spliced into key assignments.
9, method according to claim 7 is characterized in that: preserve described parameterized SQL statement with the Hash table form.
10, method according to claim 7 is characterized in that, also comprises: in described parameterized SQL statement, delete least-recently-used SQL statement.
11, the OODB Object Oriented Data Base access system is characterized in that, comprising:
The requirement analysis unit is used for the analytic target request, obtains database table name, at least one visit field, the condition field of at least one visit, the condition fiducial value of visit;
The key assignments generation unit is used for generating key assignments according to the analysis result of described request analytic unit, and described key assignments comprises condition field, the combination of the part in the condition fiducial value of database table name, visit field, visit;
Indexing units is used to search the parametrization SQL statement of answering with described key-value pair; If do not find, then generate parameterized SQL statement and be stored in storage unit, wherein with the one or more required parameters that are made as except that the key assignments ingredient in the described analysis result; If find, then to carrying out corresponding accessing operation after the described request parameter assignment;
Storage unit is used to preserve parameterized SQL statement.
12, system according to claim 1 is characterized in that: described key assignments comprises the condition field of database table name, visit field, visit, and described condition fiducial value is a required parameter.
13, system according to claim 1 is characterized in that: described key assignments generation unit according to rule of combination, is spliced into key assignments with each ingredient of key assignments.
14, system according to claim 1 is characterized in that: described storage unit is preserved described parameterized SQL statement with the form of Hash table.
15, system according to claim 1 is characterized in that: described storage unit is deleted least-recently-used SQL statement.
CNB2007100872467A 2007-03-22 2007-03-22 OODB Object Oriented Data Base access method and system Active CN100550019C (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CNB2007100872467A CN100550019C (en) 2007-03-22 2007-03-22 OODB Object Oriented Data Base access method and system

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CNB2007100872467A CN100550019C (en) 2007-03-22 2007-03-22 OODB Object Oriented Data Base access method and system

Publications (2)

Publication Number Publication Date
CN101021875A true CN101021875A (en) 2007-08-22
CN100550019C CN100550019C (en) 2009-10-14

Family

ID=38709637

Family Applications (1)

Application Number Title Priority Date Filing Date
CNB2007100872467A Active CN100550019C (en) 2007-03-22 2007-03-22 OODB Object Oriented Data Base access method and system

Country Status (1)

Country Link
CN (1) CN100550019C (en)

Cited By (34)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN102360385A (en) * 2011-10-14 2012-02-22 盛乐信息技术（上海）有限公司 File searching method and system
CN102426582A (en) * 2011-09-29 2012-04-25 用友软件股份有限公司 Data operation management device and data operation management method
CN102479244A (en) * 2010-11-30 2012-05-30 英业达股份有限公司 Searching system and method capable of temporarily storing target data and unsearched data by container
CN101741889B (en) * 2008-11-17 2012-07-11 北京易路联动技术有限公司 Method, system and service for centralized management of network services
CN102597969A (en) * 2009-06-25 2012-07-18 西山修平 Database management device using key-value store with attributes, and key-value-store structure caching-device therefor
CN102750382A (en) * 2012-06-28 2012-10-24 上海寰创通信科技股份有限公司 Relational data inquiring method for network management system
CN102945256A (en) * 2012-10-18 2013-02-27 福建省海峡信息技术有限公司 Method and device for merging and classifying massive SQL (Structured Query Language) sentences
CN103365881A (en) * 2012-03-30 2013-10-23 腾讯科技（深圳）有限公司 Data access method and system based on data features
CN103544323A (en) * 2013-11-08 2014-01-29 中国农业银行股份有限公司 Data updating method and device
CN103744891A (en) * 2013-12-23 2014-04-23 大唐软件技术股份有限公司 Method and system for data query
CN103902677A (en) * 2014-03-21 2014-07-02 西安理工大学 Cross-platform database access method
CN104166705A (en) * 2014-08-06 2014-11-26 广州华多网络科技有限公司 Access method and device of database
CN104216992A (en) * 2014-09-09 2014-12-17 百度在线网络技术（北京）有限公司 Information processing method and device
CN104408073A (en) * 2014-10-31 2015-03-11 广州华多网络科技有限公司 Data operation method and device
CN105512184A (en) * 2015-11-25 2016-04-20 国云科技股份有限公司 Method of improving space and time efficiency of application systems in relational databases
CN105589915A (en) * 2014-11-06 2016-05-18 郑毓融 Database acceleration method through operation index value and hybrid layer cache
WO2016101753A1 (en) * 2014-12-26 2016-06-30 北京奇虎科技有限公司 Method and device for uniformly processing request information
WO2016150181A1 (en) * 2015-03-21 2016-09-29 Huawei Technologies Co., Ltd. System, method, and device for index compilation to optimize index usage
CN106569929A (en) * 2016-10-26 2017-04-19 珠海许继芝电网自动化有限公司 Real-time data access method and system for monitoring system
CN106897322A (en) * 2015-12-21 2017-06-27 中国移动通信集团山西有限公司 The access method and device of a kind of database and file system
CN107004016A (en) * 2014-11-28 2017-08-01 微软技术许可有限责任公司 Effective data manipulation is supported
CN107145549A (en) * 2017-04-27 2017-09-08 深圳智高点知识产权运营有限公司 A kind of database caches control method and system
CN107169055A (en) * 2017-04-27 2017-09-15 北京众享比特科技有限公司 The operating method and operating system of a kind of database table
CN107180048A (en) * 2016-03-10 2017-09-19 阿里巴巴集团控股有限公司 The recognition methods of idempotent state and device in database
CN107451203A (en) * 2017-07-07 2017-12-08 阿里巴巴集团控股有限公司 Data bank access method and device
CN109299125A (en) * 2018-10-31 2019-02-01 中国银行股份有限公司 Database update method and device
CN109542907A (en) * 2018-11-21 2019-03-29 万兴科技股份有限公司 Database caches construction method, device, computer equipment and storage medium
CN109656942A (en) * 2018-11-13 2019-04-19 平安科技（深圳）有限公司 Store method, apparatus, computer equipment and the storage medium of SQL statement
CN109669951A (en) * 2018-11-09 2019-04-23 金蝶软件（中国）有限公司 Object Query method, apparatus, computer equipment and storage medium
CN111460241A (en) * 2020-04-26 2020-07-28 甬矽电子(宁波)股份有限公司 Data query method and device, electronic equipment and storage medium
CN111897813A (en) * 2020-07-08 2020-11-06 苏宁金融科技(南京)有限公司 Flow control method and device for database resources
CN112905687A (en) * 2021-03-26 2021-06-04 深圳壹账通智能科技有限公司 Data conversion method and device, electronic equipment and storage medium
CN113590699A (en) * 2021-07-14 2021-11-02 车智互联（北京）科技有限公司 Interface request processing method and system and computing equipment
WO2024093693A1 (en) * 2022-11-01 2024-05-10 北京奥星贝斯科技有限公司 Method and apparatus for optimized execution of sql statement, electronic device, and medium

Cited By (59)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN101741889B (en) * 2008-11-17 2012-07-11 北京易路联动技术有限公司 Method, system and service for centralized management of network services
CN102597969A (en) * 2009-06-25 2012-07-18 西山修平 Database management device using key-value store with attributes, and key-value-store structure caching-device therefor
CN102479244A (en) * 2010-11-30 2012-05-30 英业达股份有限公司 Searching system and method capable of temporarily storing target data and unsearched data by container
CN102426582A (en) * 2011-09-29 2012-04-25 用友软件股份有限公司 Data operation management device and data operation management method
CN102426582B (en) * 2011-09-29 2016-03-30 用友软件股份有限公司 Data manipulation management devices and data manipulation management method
CN102360385A (en) * 2011-10-14 2012-02-22 盛乐信息技术（上海）有限公司 File searching method and system
CN103365881A (en) * 2012-03-30 2013-10-23 腾讯科技（深圳）有限公司 Data access method and system based on data features
CN102750382A (en) * 2012-06-28 2012-10-24 上海寰创通信科技股份有限公司 Relational data inquiring method for network management system
CN102750382B (en) * 2012-06-28 2016-08-03 上海寰创通信科技股份有限公司 A kind of relational data querying method for network management system
CN102945256A (en) * 2012-10-18 2013-02-27 福建省海峡信息技术有限公司 Method and device for merging and classifying massive SQL (Structured Query Language) sentences
CN103544323B (en) * 2013-11-08 2017-01-04 中国农业银行股份有限公司 A kind of data-updating method and device
CN103544323A (en) * 2013-11-08 2014-01-29 中国农业银行股份有限公司 Data updating method and device
CN103744891B (en) * 2013-12-23 2017-10-10 大唐软件技术股份有限公司 A kind of data query method and system
CN103744891A (en) * 2013-12-23 2014-04-23 大唐软件技术股份有限公司 Method and system for data query
CN103902677B (en) * 2014-03-21 2017-07-28 西安理工大学 A kind of cross-platform data bank access method
CN103902677A (en) * 2014-03-21 2014-07-02 西安理工大学 Cross-platform database access method
CN104166705A (en) * 2014-08-06 2014-11-26 广州华多网络科技有限公司 Access method and device of database
CN104216992B (en) * 2014-09-09 2017-12-15 百度在线网络技术（北京）有限公司 A kind of information processing method and device
CN104216992A (en) * 2014-09-09 2014-12-17 百度在线网络技术（北京）有限公司 Information processing method and device
KR102348971B1 (en) * 2014-09-09 2022-01-10 바이두 온라인 네트웍 테크놀러지 (베이징) 캄파니 리미티드 Method and device for processing information
KR20160030351A (en) * 2014-09-09 2016-03-17 바이두 온라인 네트웍 테크놀러지 (베이징) 캄파니 리미티드 Method and device for processing information
US9898508B2 (en) 2014-09-09 2018-02-20 Baidu Online Network Technology (Beijing) Co., Ltd. Method and device for processing information
CN104408073B (en) * 2014-10-31 2017-10-20 广州华多网络科技有限公司 Data manipulation method and device
CN104408073A (en) * 2014-10-31 2015-03-11 广州华多网络科技有限公司 Data operation method and device
CN105589915A (en) * 2014-11-06 2016-05-18 郑毓融 Database acceleration method through operation index value and hybrid layer cache
CN107004016B (en) * 2014-11-28 2021-01-22 微软技术许可有限责任公司 Efficient data manipulation support
CN107004016A (en) * 2014-11-28 2017-08-01 微软技术许可有限责任公司 Effective data manipulation is supported
WO2016101753A1 (en) * 2014-12-26 2016-06-30 北京奇虎科技有限公司 Method and device for uniformly processing request information
CN107077496A (en) * 2015-03-21 2017-08-18 华为技术有限公司 For indexing system, the method and apparatus that compiling is used with optimum indexing
US10635666B2 (en) 2015-03-21 2020-04-28 Huawei Technologies Co., Ltd. System, method and device for index compilation to optimize index usage
CN107077496B (en) * 2015-03-21 2020-02-14 华为技术有限公司 Systems, methods, and apparatus for index compilation to optimize index usage
WO2016150181A1 (en) * 2015-03-21 2016-09-29 Huawei Technologies Co., Ltd. System, method, and device for index compilation to optimize index usage
CN105512184B (en) * 2015-11-25 2019-06-21 国云科技股份有限公司 A method of improving space and time efficiency of the application system in relational database
CN105512184A (en) * 2015-11-25 2016-04-20 国云科技股份有限公司 Method of improving space and time efficiency of application systems in relational databases
CN106897322B (en) * 2015-12-21 2019-10-29 中国移动通信集团山西有限公司 A kind of access method and device of database and file system
CN106897322A (en) * 2015-12-21 2017-06-27 中国移动通信集团山西有限公司 The access method and device of a kind of database and file system
CN107180048A (en) * 2016-03-10 2017-09-19 阿里巴巴集团控股有限公司 The recognition methods of idempotent state and device in database
CN106569929A (en) * 2016-10-26 2017-04-19 珠海许继芝电网自动化有限公司 Real-time data access method and system for monitoring system
CN107145549B (en) * 2017-04-27 2020-01-14 深圳智高点知识产权运营有限公司 Database cache control method and system
CN107145549A (en) * 2017-04-27 2017-09-08 深圳智高点知识产权运营有限公司 A kind of database caches control method and system
CN107169055B (en) * 2017-04-27 2019-10-18 北京众享比特科技有限公司 A kind of operating method and operating system of database table
CN107169055A (en) * 2017-04-27 2017-09-15 北京众享比特科技有限公司 The operating method and operating system of a kind of database table
CN107451203A (en) * 2017-07-07 2017-12-08 阿里巴巴集团控股有限公司 Data bank access method and device
CN107451203B (en) * 2017-07-07 2020-09-01 阿里巴巴集团控股有限公司 Database access method and device
CN109299125B (en) * 2018-10-31 2021-05-28 中国银行股份有限公司 Database updating method and device
CN109299125A (en) * 2018-10-31 2019-02-01 中国银行股份有限公司 Database update method and device
CN109669951A (en) * 2018-11-09 2019-04-23 金蝶软件（中国）有限公司 Object Query method, apparatus, computer equipment and storage medium
CN109656942A (en) * 2018-11-13 2019-04-19 平安科技（深圳）有限公司 Store method, apparatus, computer equipment and the storage medium of SQL statement
CN109656942B (en) * 2018-11-13 2023-06-27 平安科技（深圳）有限公司 Method, device, computer equipment and storage medium for storing SQL (structured query language) sentences
CN109542907B (en) * 2018-11-21 2021-09-03 万兴科技股份有限公司 Database cache construction method and device, computer equipment and storage medium
CN109542907A (en) * 2018-11-21 2019-03-29 万兴科技股份有限公司 Database caches construction method, device, computer equipment and storage medium
CN111460241A (en) * 2020-04-26 2020-07-28 甬矽电子(宁波)股份有限公司 Data query method and device, electronic equipment and storage medium
CN111460241B (en) * 2020-04-26 2024-01-23 甬矽电子(宁波)股份有限公司 Data query method and device, electronic equipment and storage medium
CN111897813B (en) * 2020-07-08 2022-09-23 苏宁金融科技(南京)有限公司 Flow control method and device for database resources
CN111897813A (en) * 2020-07-08 2020-11-06 苏宁金融科技(南京)有限公司 Flow control method and device for database resources
CN112905687A (en) * 2021-03-26 2021-06-04 深圳壹账通智能科技有限公司 Data conversion method and device, electronic equipment and storage medium
CN113590699A (en) * 2021-07-14 2021-11-02 车智互联（北京）科技有限公司 Interface request processing method and system and computing equipment
CN113590699B (en) * 2021-07-14 2023-12-01 车智互联（北京）科技有限公司 Interface request processing method, system and computing device
WO2024093693A1 (en) * 2022-11-01 2024-05-10 北京奥星贝斯科技有限公司 Method and apparatus for optimized execution of sql statement, electronic device, and medium

Also Published As

Publication number Publication date
CN100550019C (en) 2009-10-14

Similar Documents

Publication Publication Date Title
CN100550019C (en) OODB Object Oriented Data Base access method and system
US10659467B1 (en) Distributed storage and distributed processing query statement reconstruction in accordance with a policy
CN107463632B (en) Distributed NewSQL database system and data query method
US7158996B2 (en) Method, system, and program for managing database operations with respect to a database table
US7853603B2 (en) User-defined relevance ranking for search
US8924373B2 (en) Query plans with parameter markers in place of object identifiers
Bereta et al. Representation and querying of valid time of triples in linked geospatial data
US7984036B2 (en) Processing a text search query in a collection of documents
US10949424B2 (en) Optimization technique for database application
US8812489B2 (en) Swapping expected and candidate affinities in a query plan cache
CN105630881A (en) Data storage method and query method for RDF (Resource Description Framework)
CN107145549B (en) Database cache control method and system
US10585871B2 (en) Database engine for mobile devices
CN112579610A (en) Multi-data source structure analysis method, system, terminal device and storage medium
Alamoudi et al. External data access and indexing in AsterixDB
US8396858B2 (en) Adding entries to an index based on use of the index
CN109669951A (en) Object Query method, apparatus, computer equipment and storage medium
JPH05204983A (en) Relational data base processor and method therefor
CN112463814A (en) Data query method and device
US20050138024A1 (en) Method and infrastructure for processing queries in a database
Hrubaru et al. A basic testbed for json data processing in sql data servers
CN114428776A (en) Index partition management method and system for time sequence data
CN116821140B (en) Data storage method, device, equipment and computer readable storage medium
Pirzadeh On the performance evaluation of big data systems
Batra et al. Modeling sparse and evolving data

Legal Events

Date Code Title Description
C06 Publication
PB01 Publication
C10 Entry into substantive examination
SE01 Entry into force of request for substantive examination
C14 Grant of patent or utility model
GR01 Patent grant