CN100550019C - OODB Object Oriented Data Base access method and system - Google Patents

OODB Object Oriented Data Base access method and system Download PDF

Info

Publication number
CN100550019C
CN100550019C CNB2007100872467A CN200710087246A CN100550019C CN 100550019 C CN100550019 C CN 100550019C CN B2007100872467 A CNB2007100872467 A CN B2007100872467A CN 200710087246 A CN200710087246 A CN 200710087246A CN 100550019 C CN100550019 C CN 100550019C
Authority
CN
China
Prior art keywords
sql statement
key assignments
visit
condition
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.)
Active
Application number
CNB2007100872467A
Other languages
Chinese (zh)
Other versions
CN101021875A (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

Abstract

The invention discloses OODB Object Oriented Data Base access method and system, relate to database access technology, when adopting OO mode process database to visit, solve the problem that SQL statement is brought inefficient operation that repeatedly compiles.Described method comprises: 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.Among the present invention, similarly object requests is used same parameterized SQL statement, reduces the time overhead that repeatedly compiling generates SQL statement to greatest extent, has greatly improved system performance.

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 analysis result, and described analysis result comprises database table name, at least one visit field, the condition field of at least one visit, the condition fiducial value of visit;
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 analysis result, and described analysis result comprises 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 indexing units is specially the one or more required parameters that are made as except that the key assignments ingredient in the described analysis result: 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, keep away for the high similar operation request of frequency of utilization
Exempt from repeatedly to recompilate, and, improved the performance of ORMapping system the expanded range of hitting of SQL statement.
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 analysis result, and described analysis result comprises database table name, at least one visit field, the condition field of at least one visit, the condition fiducial value of visit;
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 analysis result, and described analysis result comprises 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 11, it is characterized in that, described indexing units is with the one or more required parameters that are made as except that the key assignments ingredient in the described analysis result, be specially: 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 11 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 11 is characterized in that: described storage unit is preserved described parameterized SQL statement with the form of Hash table.
15, system according to claim 11 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 CN101021875A (en) 2007-08-22
CN100550019C true 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)

Families Citing this family (33)

* 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
AU2010263721A1 (en) * 2009-06-25 2012-02-16 Shuhei Nishiyama 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
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
CN103365881B (en) * 2012-03-30 2016-03-23 腾讯科技（深圳）有限公司 Based on data access method and the system of data characteristics
CN102750382B (en) * 2012-06-28 2016-08-03 上海寰创通信科技股份有限公司 A kind of relational data querying method for network management system
CN102945256B (en) * 2012-10-18 2016-02-03 福建省海峡信息技术有限公司 Magnanimity SQL statement merges the method and device sorted out
CN103544323B (en) * 2013-11-08 2017-01-04 中国农业银行股份有限公司 A kind of data-updating method and device
CN103744891B (en) * 2013-12-23 2017-10-10 大唐软件技术股份有限公司 A kind of data query method and system
CN103902677B (en) * 2014-03-21 2017-07-28 西安理工大学 A kind of cross-platform data bank 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
CN104408073B (en) * 2014-10-31 2017-10-20 广州华多网络科技有限公司 Data manipulation method and device
TWI526857B (en) * 2014-11-06 2016-03-21 The database acceleration method is used to calculate the index value and the hybrid layer cache
US10409835B2 (en) * 2014-11-28 2019-09-10 Microsoft Technology Licensing, Llc Efficient data manipulation support
CN104468833B (en) * 2014-12-26 2018-05-29 北京奇虎科技有限公司 The method and apparatus that solicited message is uniformly processed
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
CN106897322B (en) * 2015-12-21 2019-10-29 中国移动通信集团山西有限公司 A kind of access method and device of database and file system
CN107180048B (en) * 2016-03-10 2021-03-19 创新先进技术有限公司 Method and device for identifying idempotent states in database
CN106569929A (en) * 2016-10-26 2017-04-19 珠海许继芝电网自动化有限公司 Real-time data access method and system for monitoring system
CN107169055B (en) * 2017-04-27 2019-10-18 北京众享比特科技有限公司 A kind of operating method and operating system of database table
CN107145549B (en) * 2017-04-27 2020-01-14 深圳智高点知识产权运营有限公司 Database cache control method and system
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
CN109669951B (en) * 2018-11-09 2020-12-04 金蝶软件（中国）有限公司 Object query method and device, computer equipment and storage medium
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
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
CN112905687A (en) * 2021-03-26 2021-06-04 深圳壹账通智能科技有限公司 Data conversion method and device, electronic equipment and storage medium
CN113590699B (en) * 2021-07-14 2023-12-01 车智互联（北京）科技有限公司 Interface request processing method, system and computing device

Also Published As

Publication number Publication date
CN101021875A (en) 2007-08-22

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
CN107247808B (en) Distributed NewSQL database system and picture data query method
US7158996B2 (en) Method, system, and program for managing database operations with respect to a database table
Bereta et al. Representation and querying of valid time of triples in linked geospatial data
US7853603B2 (en) User-defined relevance ranking for search
US8924373B2 (en) Query plans with parameter markers in place of object identifiers
US9286393B2 (en) Performing a function on rows of data determined from transitive relationships between columns
US20040019587A1 (en) Method and device for processing a query in a database management system
US10949424B2 (en) Optimization technique for database application
Brodt et al. Deep integration of spatial query processing into native RDF triple stores
US7984036B2 (en) Processing a text search query in a collection of documents
US8812489B2 (en) Swapping expected and candidate affinities in a query plan cache
JP2005267612A (en) Improved query optimizer using implied predicates
CN105630881A (en) Data storage method and query method for RDF (Resource Description Framework)
CN107145549B (en) Database cache control method and system
Alamoudi et al. External data access and indexing in AsterixDB
Urbani et al. KOGNAC: efficient encoding of large knowledge graphs
US8396858B2 (en) Adding entries to an index based on use of the index
CN114116767A (en) Method and device for converting SQL (structured query language) query statement of database
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
CN115391424A (en) Database query processing method, storage medium and computer equipment
US20210034616A1 (en) Query optimization
Pirzadeh On the performance evaluation of big data systems

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