CN101141663A - Method and system for improving intelligent network access database efficiency - Google Patents
Method and system for improving intelligent network access database efficiency Download PDFInfo
- Publication number
- CN101141663A CN101141663A CNA2007101757659A CN200710175765A CN101141663A CN 101141663 A CN101141663 A CN 101141663A CN A2007101757659 A CNA2007101757659 A CN A2007101757659A CN 200710175765 A CN200710175765 A CN 200710175765A CN 101141663 A CN101141663 A CN 101141663A
- Authority
- CN
- China
- Prior art keywords
- database
- module
- intelligent network
- statement
- network application
- 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
Links
Images
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
- Information Transfer Between Computers (AREA)
Abstract
The present invention discloses a method and a system which are used to improve the data base visiting efficiency of the intelligent network. The application system of the intelligent network comprises an intelligent network application program module, a data base visiting module and a service terminal data base, the intelligent network application program module comprises a visiting statement sending module, and the data base visiting module comprises a visiting statement enclosure module; the visiting statement sending module sends a variable part information of a data base visiting statement to the data base visiting module when the intelligent network application program module needs to visit the service terminal data base; the visiting statement enclosure module encloses the statements which are used to operate SQL by the data base, and the enclosed statements are sends to the service terminal data base, according to an enclosing rule which is stored by the data base visiting module and the variable part information. The present invention has the advantages that the developing and the disposing flexibility of the intelligent network application are improved, the resources of the intelligent network are saved, the probability of error code is effectively reduced, and the reliability of the intelligent network is improved.
Description
Technical field
The present invention relates to the intelligent network field, particularly relate to a kind of method and system that are used to improve intelligent network access database efficiency.
Background technology
Intelligent network is used the serial business service that provides on the basis of intelligent network is provided.At present common intelligent network is used to be had: 800 service, MASS calling, advertisement telephone business and prepayment service etc.Along with the continuous development of intelligent network, the type that intelligent network is used is also more and more.These intelligent networks are used all needs to visit corresponding database.
Intelligent network is used and is generally adopted two kinds of method fulfillment database visits at present.
First method is two layer architectures that adopt intelligent network application program module and service client database to form, and is illustrated in figure 1 as intelligent network access database schematic flow sheet of the prior art.In intelligent network application system 10, when intelligent network application program module 11 need conduct interviews to service end database 12, intelligent network application program module 11 is constructed complete database manipulation SQL statement a---SQL statement 1, and send it to service end database 12, service end database 12 is received this SQL statement, carry out corresponding operation, and the execution result 1 that will operate generation is sent to intelligent network application program module 11.Intelligent network application program module 11 each initiations are all repeated above-mentioned steps to the visit of service end database 12, promptly, intelligent network application program module 11 sends SQL statement n to service end database 12, and service end database 12 is sent to intelligent network application program module 11 with the execution result n of SQL statement n.
Second method is set up a database access module on the basis of two layer architectures of intelligent network application program module and service client database composition, see also and Figure 2 shows that intelligent network access database schematic flow sheet of the prior art.The difference of second method and first method is, in intelligent network application system 20, intelligent network application program module 21 sends to database access module 23 with SQL statement n (n is a natural number), send SQL statement n by database access module 23 to service end database 22, the Coordination Treatment of process database access module 23 improves the operational efficiency of using to realize load balancing.
From Fig. 1 and Fig. 2 as can be seen, prior art has the following disadvantages:
(1) if produced a large amount of identical database accesss, the intelligent network application program module need repeat to generate the database manipulation SQL statement, has increased the resource pressure of intelligent network;
(2) generate data base manipulation statement by the intelligent network application program module in the prior art, occur efficiency bottle neck easily, increased database manipulation and postponed possibility;
When (3) the intelligent network application program module is visited a plurality of disparate databases simultaneously, need the different access interface of configuration, reduced the relative independentability that intelligent network is used.
Summary of the invention
The invention provides a kind of method and system that are used to improve intelligent network access database efficiency,, improve database access efficient to alleviate the resource pressure of intelligent network effectively.
To achieve these goals, the invention provides a kind of intelligent network application system that is used to improve database access efficient, comprise an intelligent network application program module, a database access module and a service end database comprise:
Described intelligent network application program module also comprises a visit statement sending module, and described database access module also comprises a visit statement package module;
Described visit statement sending module is used for when described intelligent network application program module need be visited described service end database, and the variable part information that sends a database access statement is to described database access module;
Described visit statement package module is used for a packing rule and described variable part information according to described database access module storage, encapsulates out the database manipulation SQL statement, is sent to described service end database.
Described intelligent network application program module comprises a visit statement administration module, is used for the database access statement that described intelligent network application program module generates is resolved, and determines the variable part information in this database access statement.
Also comprise a judge module in the described database access module, whether be used for the described database manipulation SQL statement that judgement encapsulates out in proper order identical, if, only send a described database manipulation SQL statement to described service end database, the described database manipulation SQL statement that will encapsulate out in proper order successively if not, is sent to described service end database.
Described judge module possesses a range of condition, and described range of condition is an a scheduled time or reservations database operation SQL statement bar number, described range of condition be used for determining described judge module at object.
A packing rule of storing in described variable part information and the described database access module is corresponding.
The invention also discloses a kind of method that is used to improve intelligent network access database efficiency, be used for an intelligent network application program module and visit a service end database, comprising by a database access module:
Step 1, when described intelligent network application program module need be visited described service end database, described intelligent network application program module sent the variable part information of a database access statement to described database access module;
Step 2, described database access module encapsulates out the database manipulation SQL statement according to the packing rule and the described variable part information of a storage;
Step 3 is sent to described service end database with described database manipulation SQL statement.
Before the described step 1, comprising:
Described intelligent network application program module is resolved the database access statement that generates in advance, determines the variable part information in this database access statement.
Comprise between the described step 2 step 3:
Whether the described database manipulation SQL statement that judgement encapsulates out in proper order is identical, if, only send a described database manipulation SQL statement to described service end database, if not, the described database manipulation SQL statement that will encapsulate out in proper order successively is sent to described service end database.
Described deterministic process at object determine that by a range of condition described range of condition is a scheduled time or reservations database operation SQL statement bar number.
A packing rule of storing in described variable part information and the described database access module is corresponding.
Effect of the present invention is:
1, in the time of owing to intelligent network application access database, only needs to send the variable part information in the database access statement, need not to be concerned about the type of database on backstage, so improved the develop and field flexibility that intelligent network is used.
2, intelligent network use carry out database access, especially when using a large amount of comparatively fixing database access statements to carry out database access, avoided intelligent network to use the operation that repeats to generate database access statement, also avoided repeating to receive identical database access result, saved the intelligent network resource.
3, reduce the data volume of the Network Transmission of intelligent network application access database, effectively reduced the probability that error code occurs, improved the reliability of intelligent net system.
Description of drawings
Figure 1 shows that intelligent network access database schematic flow sheet of the prior art;
Figure 2 shows that intelligent network access database schematic flow sheet of the prior art;
Fig. 3 A is depicted as the structural representation that is used to improve the intelligent network application system of database access efficient of the present invention;
Fig. 3 B is depicted as the structural representation that is used to improve the intelligent network application system of database access efficient of the present invention;
Figure 4 shows that the method flow diagram that is used to improve intelligent network access database efficiency of the present invention.
Embodiment
Below cooperate embodiment and accompanying drawing, describe technical characterictic of the present invention in detail.
See also Fig. 3 A and be depicted as the structural representation that is used to improve the intelligent network application system of database access efficient of the present invention.
Intelligent network application system 30 comprises intelligent network application program module 31, service end database 32, database access module 33.Intelligent network application program module 31 further comprises visit statement administration module 311, visit statement sending module 312, and database access module 33 further comprises visit statement package module 331.
Visit statement administration module 311 is used for each database access statement that described intelligent network application program module 31 generates is resolved, with variable part information, the non-variable part information in clear and definite this statement.This variable part information is the core operation information that a visit statement is different from an other visit statement.This variable part information for example is a variate-value.
Visit statement sending module 312 is used for when intelligent network one side initiation database access request, and the variable part information of database access statement that sends this time visit is to this database access module 33.
Visit statement package module 331 is used for according to described variable part information, and according in this database access module 33 in advance the storage or pre-loaded packing rule, encapsulate out a complete database manipulation SQL statement, and this database manipulation SQL statement is sent to this service end database 32.All packing rules are stored in this database access module 33 with the form or other the form of file, and different packing rules is distinguished by different ID values.Also comprise an ID value in the described variable part information that visit statement package module 331 is received, when visit statement package module 331 is carried out encapsulation, will in this packing rule file, search corresponding packing rule, finish corresponding encapsulation operation according to this ID value.
In the present embodiment, because after this visit statement package module 331 is received the variate-value of a variable part information, can discern the packing rule corresponding according to this variate-value automatically with it, and then according to this variate-value and this packing rule, encapsulate out a complete database manipulation SQL statement, so, the service end database 33 of these intelligent network application program module 31 addressable number of different types, need not the support of corresponding database access interface, improved the develop and field flexibility that intelligent network is used.
Be depicted as the structural representation of intelligent network application system that is used to improve database access efficient of another embodiment of the present invention as Fig. 3 B.
The difference of described embodiment of Fig. 3 B and the described embodiment of Fig. 3 A is, also comprises a judge module 332 that is connected with this visit statement package module 331 in the database access module 33.
Because intelligent network application program module 31 might occur continuing in a large number and send the situation of identical variate-value, promptly repeat to initiate identical database access, as the corresponding identical database manipulation SQL statement in a large number that encapsulate out, and receive a large amount of identical database manipulation results, then can cause the waste of intelligent network resource.
This judge module 332 is used for the SQL statement that this visit statement package module 331 encapsulates out is judged, specifically be to be used to judge whether to exist the SQL statement that continues and repeat, if there is no, then carry out the corresponding database operation successively according to the order of the SQL statement that encapsulates out, if exist, then only send wherein SQL statement, delete the statement of all the other repetitions to service end database 32.This judge module 332 also can be set at, and judges in a scheduled time or in the SQL statement of predetermined bar number whether have the SQL statement that continues and repeat, and has surpassed the scheduled time or predetermined bar number and has then restarted to calculate, to avoid the lost part access request.
Be illustrated in figure 4 as the method flow diagram that is used to improve intelligent network access database efficiency of the present invention.
Step 401, variable part information and non-variable part information in the structure of specified data storehouse visit statement;
Step 402, when the intelligent network application program module was initiated the database access request, by the message interface of intelligent network, the variable part information of the database access statement of transmission current accessed was to this database access module;
Step 403, this database access module is packaged into complete database manipulation SQL statement according to this variable part information and according to the packing rule of storage in advance that this variable part information finds;
Step 404, this database access module is sent to the service end database with this database manipulation SQL statement, finishes the corresponding database operation by the service end database according to this SQL statement, generates an execution result.
Step 405, this service end database is sent to this intelligent network application program module with this execution result by this database access module, and flow process finishes.
Be the operational efficiency of further raising system, reduce the error rate, save the intelligent network resource, also comprise the steps: between step 403 and the step 404
Step 4031, judgement encapsulates in the database manipulation SQL statement of finishing whether have the SQL statement that continues and repeat in proper order, if exist, only send wherein SQL statement to the service end database, delete the statement of all the other repetitions, if there is no, carry out the corresponding database operation successively according to the order of the SQL statement that encapsulates out.
Adopt the application's system and method, its beneficial effect is,
1, in the time of owing to intelligent network application access database, only needs to send database access statement In variate-value, need not to be concerned about the type of database on backstage, so improved exploitation and section that intelligent network is used Administration's flexibility.
2, intelligent network is used the database access of carrying out database access, especially comparatively fixing in a large number in use When statement carries out database access, avoided intelligent network to use the operation that repeats generating database access statement, Also avoided repeating to receive identical database access result, saved the intelligent network resource.
3, reduced the data volume of the Internet Transmission of intelligent network application access database, effectively error code appears in reduction Probability, improved the reliability of intelligent net system.
Claims (10)
1. an intelligent network application system that is used to improve database access efficient comprises an intelligent network application program module, and a database access module and a service end database is characterized in that, comprising:
Described intelligent network application program module also comprises a visit statement sending module, and described database access module also comprises a visit statement package module;
Described visit statement sending module is used for when described intelligent network application program module need be visited described service end database, and the variable part information that sends a database access statement is to described database access module;
Described visit statement package module is used for a packing rule and described variable part information according to described database access module storage, encapsulates out the database manipulation SQL statement, is sent to described service end database.
2. the system as claimed in claim 1, it is characterized in that, described intelligent network application program module comprises a visit statement administration module, is used for the database access statement that described intelligent network application program module generates is resolved, and determines the variable part information in this database access statement.
3. system as claimed in claim 1 or 2, it is characterized in that, also comprise a judge module in the described database access module, whether be used for the described database manipulation SQL statement that judgement encapsulates out in proper order identical, if, only send a described database manipulation SQL statement to described service end database, if not, the described database manipulation SQL statement that will encapsulate out in proper order successively is sent to described service end database.
4. system as claimed in claim 3 is characterized in that described judge module possesses a range of condition, and described range of condition is an a scheduled time or reservations database operation SQL statement bar number, described range of condition be used for determining described judge module at object.
5. as claim 1,2 or 4 described systems, it is characterized in that a packing rule of storing in described variable part information and the described database access module is corresponding.
6. a method that is used to improve intelligent network access database efficiency is used for an intelligent network application program module and visits a service end database by a database access module, it is characterized in that,
Step 1, when described intelligent network application program module need be visited described service end database, described intelligent network application program module sent the variable part information of a database access statement to described database access module;
Step 2, described database access module encapsulates out the database manipulation SQL statement according to the packing rule and the described variable part information of a storage;
Step 3 is sent to described service end database with described database manipulation SQL statement.
7. method as claimed in claim 6 is characterized in that, before the described step 1, comprising:
Described intelligent network application program module is resolved the database access statement that generates in advance, determines the variable part information in this database access statement.
8. as claim 6 or 7 described methods, it is characterized in that, comprise between the described step 2 step 3:
Whether the described database manipulation SQL statement that judgement encapsulates out in proper order is identical, if, only send a described database manipulation SQL statement to described service end database, if not, the described database manipulation SQL statement that will encapsulate out in proper order successively is sent to described service end database.
9. method as claimed in claim 8 is characterized in that, described deterministic process at object determine that by a range of condition described range of condition is a scheduled time or reservations database operation SQL statement bar number.
10. as claim 6,7 or 9 described methods, it is characterized in that a packing rule of storing in described variable part information and the described database access module is corresponding.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2007101757659A CN101141663B (en) | 2007-10-11 | 2007-10-11 | Method and system for improving intelligent network access database efficiency |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2007101757659A CN101141663B (en) | 2007-10-11 | 2007-10-11 | Method and system for improving intelligent network access database efficiency |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN101141663A true CN101141663A (en) | 2008-03-12 |
| CN101141663B CN101141663B (en) | 2010-06-09 |
Family
ID=39193354
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN2007101757659A Expired - Fee Related CN101141663B (en) | 2007-10-11 | 2007-10-11 | Method and system for improving intelligent network access database efficiency |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN101141663B (en) |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103514185A (en) * | 2012-06-20 | 2014-01-15 | 北京四维图新科技股份有限公司 | Method and device for managing access to database files in multiple updated areas of navigation map |
| CN103577408A (en) * | 2012-07-19 | 2014-02-12 | 中兴通讯股份有限公司 | Database access method and device |
| CN110502501A (en) * | 2019-08-14 | 2019-11-26 | 平安普惠企业管理有限公司 | Database operation method, device, equipment and storage medium |
Family Cites Families (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1264106C (en) * | 2002-03-30 | 2006-07-12 | 中兴通讯股份有限公司 | Method for accessing database system uniformly |
| CN100456237C (en) * | 2007-01-31 | 2009-01-28 | 华为技术有限公司 | Method and device for accessing database |
-
2007
- 2007-10-11 CN CN2007101757659A patent/CN101141663B/en not_active Expired - Fee Related
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103514185A (en) * | 2012-06-20 | 2014-01-15 | 北京四维图新科技股份有限公司 | Method and device for managing access to database files in multiple updated areas of navigation map |
| CN103514185B (en) * | 2012-06-20 | 2017-09-29 | 北京四维图新科技股份有限公司 | The database file access management method and device of the multiple update area of navigation map |
| CN103577408A (en) * | 2012-07-19 | 2014-02-12 | 中兴通讯股份有限公司 | Database access method and device |
| CN110502501A (en) * | 2019-08-14 | 2019-11-26 | 平安普惠企业管理有限公司 | Database operation method, device, equipment and storage medium |
| CN110502501B (en) * | 2019-08-14 | 2024-01-19 | 中德高路咨询(云南)有限公司 | Database operation method, device, equipment and storage medium |
Also Published As
| Publication number | Publication date |
|---|---|
| CN101141663B (en) | 2010-06-09 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN104699718B (en) | Method and apparatus for being rapidly introduced into business datum | |
| CN107992356A (en) | Block chain affairs block processes method, electronic device and readable storage medium storing program for executing | |
| CN107889069B (en) | Short message gateway selection method, device, server and readable storage medium | |
| CN109802941A (en) | A kind of login validation method, device, storage medium and server | |
| CN108108252B (en) | Global unique ID generation method, system and storage medium | |
| CN103490909B (en) | Charge processing method and device | |
| CN110555079B (en) | Data processing method, device, equipment and storage medium | |
| CN110535928A (en) | A kind of event method for pushing of the JAVA intelligence contract of block chain | |
| CN105471968A (en) | Data exchange method, data exchange system and data platform server | |
| CN101141663B (en) | Method and system for improving intelligent network access database efficiency | |
| CN113434293A (en) | Method and apparatus for processing repeat request, storage medium, and electronic apparatus | |
| CN116662376B (en) | Data query method, device, electronic equipment and storage medium | |
| CN109586970A (en) | Resource allocation methods, apparatus and system | |
| CN113409047A (en) | Data processing method, device and equipment based on block chain and readable storage medium | |
| CN111738853A (en) | Transaction optimization method and device based on block chain distributed system | |
| CN107181747A (en) | A kind of Handle resolution systems comprising top mode | |
| CN108124021A (en) | Internet protocol IP address obtains, the method, apparatus and system of website visiting | |
| CN107391630B (en) | Method and device for processing parallel network requests and terminal equipment | |
| CN115328457A (en) | Method and device for realizing form page based on parameter configuration | |
| CN115878860A (en) | Menu generation method, device, server equipment and medium | |
| CN116226178A (en) | Data query method and device, storage medium and electronic device | |
| CN109697072A (en) | Information processing method, device and equipment | |
| CN113626001A (en) | API dynamic editing method and device based on script | |
| CN113791766A (en) | Method for combining data interfaces, electronic device and readable storage medium | |
| CN110213267A (en) | White List service processing method, server and computer storage medium |
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 | ||
| CF01 | Termination of patent right due to non-payment of annual fee | ||
| CF01 | Termination of patent right due to non-payment of annual fee |
Granted publication date: 20100609 Termination date: 20171011 |