CN105512137A - Method for operating database handle, and database handle management system - Google Patents
Method for operating database handle, and database handle management system Download PDFInfo
- Publication number
- CN105512137A CN105512137A CN201410500046.XA CN201410500046A CN105512137A CN 105512137 A CN105512137 A CN 105512137A CN 201410500046 A CN201410500046 A CN 201410500046A CN 105512137 A CN105512137 A CN 105512137A
- Authority
- CN
- China
- Prior art keywords
- handle
- derivative
- execution result
- user
- data area
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Abstract
The invention discloses a method for operating database handles. The method for operating database handles comprises the following steps: initializing a database, generating basic handles and derived handles related to the basic handles; executing operation, searching corresponding derived handles according to user input, and executing the derived handles; and performing feedback operation, feeding back execution result information to the user. The method also comprises cleaning operation used to release the basic handle data and/or derived handle data resources.
Description
Technical field
The present invention relates to a kind of method of operating database handle and database handles management system operating database handle.
Background technology
The operation of online transaction processing system to database is generally realized by database handles, but database manipulation of the prior art and Database Systems can not shield the difference between disparate databases product.Particularly different database product users is needed to use corresponding database API, this restriction that the efficiency of the usability of whole Database Systems and development data storehouse system can be caused all to be subject in various degree.On the other hand, the versatility of the handle of existing database system is not enough, and the lower workload that also can increase system developer of the efficiency of the handle of maintenance and management.
Summary of the invention
The present invention discloses a kind of method of operating database handle.
The method of operating database handle comprises the following steps: initialization data storehouse: formation base handle and the derivative handle associated with basic handle; Executable operations: search corresponding derivative handle according to user's input and perform this derivative handle; Feedback operation: to user feedback execution result information.
Preferably, initialization data storehouse stores the basic handle and derivative handle that generate at static data area, and executable operations stores executing state and the execution result of derivative handle at dynamic data area.
Preferably, also comprise abnormality processing operation, when the executing state of the derivative handle judging dynamic data area occurs abnormal, remove executing state and the execution result of this derivative handle wherein.
Preferably, when feedback operation, show described execution result information with user-defined format.
A kind of database handles management system, comprise: initialization module, for formation base handle and the derivative handle that associates with basic handle, execution module, for searching corresponding derivative handle according to user's input and perform this derivative handle, feedback module, for user feedback execution result information.
Preferably, initialization module stores the basic handle and derivative handle that generate at static data area, and execution module stores executing state and the execution result of derivative handle at dynamic data area.
Preferably, also comprise abnormality processing module, for when the executing state of the derivative handle judging dynamic data area occurs abnormal, remove executing state and the execution result of this derivative handle.
Preferably, feedback module is configured to show described execution result information with user-defined format.
A kind of method of operating database handle, this database relates to two or more different database product, the method comprises: receive user's input by self defined interface, this user input comprises operation ID and operating parameter, corresponding derivative handle is searched according to this user input, (this user input being associated with the specific derivative handle of certain database product), performs this derivative handle, to user feedback execution result information.
A kind of method of operating database handle, the method comprises: receive user's input by self defined interface, this user input comprises operation ID and operating parameter, corresponding derivative handle is searched according to this user input, perform this derivative handle, perform associate with this derivative handle other operate, to user feedback execution result information.Advantageously, can simplify the calling of API of user for Database Systems by performing other operation of associating with this derivative handle, execution result information is stored into this locality by other operational example in this way.
Accompanying drawing explanation
After having read the specific embodiment of the present invention with reference to accompanying drawing, those skilled in the art will become apparent the present invention.One skilled in the art will appreciate that accompanying drawing only for coordinating embodiment that technical scheme of the present invention is described, and and be not intended to be construed as limiting protection scope of the present invention.
Fig. 1 is the step schematic diagram of the operating database handle according to the embodiment of the present invention.
Fig. 2 shows the configuration schematic diagram of static data area according to an embodiment of the invention.
Fig. 3 shows the configuration schematic diagram of dynamic data area according to an embodiment of the invention.
Embodiment
With reference to the accompanying drawings, the specific embodiment of the present invention is described in further detail.Should be understood that, amendment that is that structure can be carried out to described embodiment and function.In addition, can for any given or specific application is desired and favourable, one or more features of an embodiment can be combined with one or more features of another embodiment.
Fig. 1 is the step schematic diagram of the operating database handle according to the embodiment of the present invention.As shown in Figure 1, the method for operating database handle comprises the following steps: initialization data storehouse, formation base handle and the derivative handle associated with basic handle; Executable operations, searches corresponding derivative handle according to user's input and performs this derivative handle; Feedback operation, to user feedback execution result information.
Can initialization data storehouse in the following manner.According to the basic handle of this database of database product type initialization, and derive the statement handles that associates with it according to basic handle as derivative handle, and the parameter of this database is optionally set.Basis handle can comprise and connect handle and/or Environment handle.Basis handle can derive one or more statement handles.
In one example, user's input is carried out via unified API.This api interface can be inputted to receive the user comprising operation ID and operating parameter by self-defined, and inputs the corresponding derivative handle of identification according to this user.This derivative handle can correspond to the specific SQL operation of certain database.This when relating to multiple database product advantageously, user does not need the original API knowing certain database can carry out indiscriminate database manipulation among a plurality of databases.
In one example, initialization data storehouse stores the basic handle and derivative handle that generate at static data area, and executable operations stores executing state and the execution result of derivative handle at dynamic data area.The information that static data area stores can be used to search corresponding derivative handle and be loaded on dynamic data area to perform this handle.The information that static data area stores can also be used for abnormal restoring process as mentioned below, and such as database reconnects.
In one example, static data area can be stored as the basic handle ID of basic handle information, the connection status of basic handle (with associated databases), the quantity of derivative handle that associates with basic handle.Static data area can also be stored as the derivative handle ID of derivative handle information, the derivative self-defined title of handle, the action type of derivative handle, the SQL statement of binding with derivative handle, the input variable/output variable associated with derivative handle, the definition of input variable/output variable associated with derivative handle, handle state.Fig. 2 shows the configuration schematic diagram of static data area according to an embodiment of the invention.
In one example, static data area can also be used for storing submission mark automatically and/or reconnecting spacing parameter.Thus, method of the present invention can also comprise automatic submit operation, and based on reconnecting the reconnection operation of spacing parameter.
In one example, the dynamic data area current derivative handle ID that performing that can be stored as executing state and corresponding action type, database answer back code, execution result error code, execution result status code, result set mark.Dynamic data area can also be stored as the external answer back code associated with the current derivative handle performed of execution result information, database manipulation affects and records number, current cursor location.Preferably, external answer back code, database manipulation impact record number, current cursor location are converted to unified self-defined standard and externally export, feeds back to user.Fig. 3 shows the configuration schematic diagram of dynamic data area according to an embodiment of the invention.
In one example, vernier can be comprised according to method of the present invention and obtain operation, in this operation, the derivative handle ID/ according to user's input derives the slider position that the self-defined title of handle driven state region obtains this derivative handle, and to this slider position of user feedback.
In one example, can cleaning operation be comprised according to method of the present invention, this operation according to dynamic data area information judge whether to need to clear up the corresponding basic handle data of static data area and/or dynamic data area and/or derivative handle data.Cleaning operation is for discharging basic handle data and/or derivative handle data resource.After cleaning operation completes, can also connect in turn-off data storehouse.Cleaning operation can performed to user feedback execution result information.
In one example, also comprise abnormality processing operation according to method of the present invention, when the executing state of the derivative handle judging dynamic data area occurs abnormal, remove executing state and the execution result of this derivative handle wherein.
In one example, method according to the present invention, when feedback operation, shows described execution result information with user-defined format.
According to other embodiments of the invention, a kind of method of operating database handle is disclosed, this database relates to two or more different database product, the method comprises: receive user's input by self defined interface, this user input comprises operation ID and operating parameter, searches corresponding derivative handle according to this user input, (this user input being associated with the specific derivative handle of certain database product), perform this derivative handle, to user feedback execution result information.
According to other embodiments of the invention, a kind of method of operating database handle is disclosed, the method comprises: receive user's input by self defined interface, this user input comprises operation ID and operating parameter, corresponding derivative handle is searched according to this user input, perform this derivative handle, perform associate with this derivative handle other operate, to user feedback execution result information.Advantageously, can simplify the calling of API of user for Database Systems by performing other operation of associating with this derivative handle, execution result information is stored into this locality by other operational example in this way.Advantageously, Database system development efficiency can be improved by the API of association is carried out encapsulation.
According to other embodiments of the invention, a kind of database handles management system is disclosed, initialization module, for formation base handle and the derivative handle that associates with basic handle, execution module, for searching corresponding derivative handle according to user's input and perform this derivative handle, feedback module, for user feedback execution result information.Initialization module stores the basic handle and derivative handle that generate at static data area, and execution module stores executing state and the execution result of derivative handle at dynamic data area.In one example, also comprise abnormality processing module, for when the executing state of the derivative handle judging dynamic data area occurs abnormal, remove executing state and the execution result of this derivative handle.Feedback module is configured to show described execution result information with user-defined format.Be understandable that, described module can also be used to perform about other steps one or more in the method for operating described in Fig. 1.
By the description of above embodiment, those skilled in the art can understand, and when without departing from the spirit and scope of the present invention, can also do various change and replacement to the specific embodiment of the present invention.These change and replace and all drop in claims of the present invention limited range.
Claims (9)
1. a method for operating database handle, is characterized in that, comprises the following steps:
Initialization data storehouse, with formation base handle and the derivative handle that associates with basic handle;
Executable operations, searches corresponding derivative handle according to user's input and performs this derivative handle;
Feedback operation, to user feedback execution result information.
2. the method for claim 1, is characterized in that,
Initialization data storehouse stores the basic handle and derivative handle that generate at static data area, and
Executable operations stores executing state and the execution result of derivative handle at dynamic data area.
3. method as claimed in claim 2, is characterized in that, also comprises abnormality processing operation, when the executing state of the derivative handle judging dynamic data area occurs abnormal, removes executing state and the execution result of this derivative handle wherein.
4. the method for claim 1, is characterized in that, when feedback operation, shows described execution result information with user-defined format.
5. the method for claim 1, is characterized in that, also comprises cleaning operation, for discharging basic handle data and/or derivative handle data resource.
6. a database handles management system, is characterized in that, comprising:
Initialization module, for formation base handle and the derivative handle that associates with basic handle,
Execution module, for searching corresponding derivative handle according to user's input and perform this derivative handle,
Feedback module, for user feedback execution result information.
7. system as claimed in claim 6, is characterized in that,
Initialization module stores the basic handle and derivative handle that generate at static data area, and
Execution module stores executing state and the execution result of derivative handle at dynamic data area.
8. system as claimed in claim 7, is characterized in that, also comprise abnormality processing module, for when the executing state of the derivative handle judging dynamic data area occurs abnormal, removes executing state and the execution result of this derivative handle.
9. system as claimed in claim 6, it is characterized in that, feedback module is configured to show described execution result information with user-defined format.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410500046.XA CN105512137A (en) | 2014-09-26 | 2014-09-26 | Method for operating database handle, and database handle management system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410500046.XA CN105512137A (en) | 2014-09-26 | 2014-09-26 | Method for operating database handle, and database handle management system |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN105512137A true CN105512137A (en) | 2016-04-20 |
Family
ID=55720124
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201410500046.XA Pending CN105512137A (en) | 2014-09-26 | 2014-09-26 | Method for operating database handle, and database handle management system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN105512137A (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113703947A (en) * | 2021-09-01 | 2021-11-26 | 上海漫酷网络技术有限公司 | Distributed task processing system, method, computer equipment and storage medium |
| CN114510495A (en) * | 2022-04-21 | 2022-05-17 | 北京安华金和科技有限公司 | Database service data consistency processing method and system |
Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1351793A (en) * | 1999-05-24 | 2002-05-29 | 诺基亚有限公司 | Connection handle |
| US20060074877A1 (en) * | 2004-10-01 | 2006-04-06 | Ralf Kuersch | System and method for optimizing transaction termination |
-
2014
- 2014-09-26 CN CN201410500046.XA patent/CN105512137A/en active Pending
Patent Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1351793A (en) * | 1999-05-24 | 2002-05-29 | 诺基亚有限公司 | Connection handle |
| US20060074877A1 (en) * | 2004-10-01 | 2006-04-06 | Ralf Kuersch | System and method for optimizing transaction termination |
Non-Patent Citations (1)
| Title |
|---|
| 飞龙40031: "第7章 数据库系统的访问", 《HTTP://WENKU.BAIDU.COM/VIEW/6567C63067EC102DE2BD8944.HTML》 * |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113703947A (en) * | 2021-09-01 | 2021-11-26 | 上海漫酷网络技术有限公司 | Distributed task processing system, method, computer equipment and storage medium |
| CN114510495A (en) * | 2022-04-21 | 2022-05-17 | 北京安华金和科技有限公司 | Database service data consistency processing method and system |
| CN114510495B (en) * | 2022-04-21 | 2022-07-08 | 北京安华金和科技有限公司 | Database service data consistency processing method and system |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US8990675B2 (en) | Automatic relationship detection for spreadsheet data items | |
| CN101651576B (en) | Alarm information processing method and system | |
| CN104461747B (en) | A kind of distributed task dispatching system | |
| US20170132638A1 (en) | Relevant information acquisition method and apparatus, and storage medium | |
| CN104133772A (en) | Automatic test data generation method | |
| CN105094707A (en) | Method and device for storing and reading data | |
| CN104346479A (en) | Database synchronization method and database synchronization device | |
| US10642805B1 (en) | System for determining queries to locate data objects | |
| CN105446807A (en) | Batch processing method and apparatus | |
| US8413109B2 (en) | Systems and methods for metamodel transformation | |
| CN105653716A (en) | Database construction method and system based on classification-attribute-value | |
| CN105389184A (en) | Configuration method and apparatus for product interface information | |
| CN105760418B (en) | Method and system for performing cross-column search on relational database table | |
| CN101217315A (en) | A collocation method and system of alarming shielding | |
| CN105512137A (en) | Method for operating database handle, and database handle management system | |
| CN104899013A (en) | Calling method and calling device of customized service assembly | |
| CN110753090A (en) | Task execution method and device of server cluster, computer equipment and storage medium | |
| CN106372121B (en) | Server and data processing method | |
| JP7381290B2 (en) | Computer system and data management method | |
| US7877422B2 (en) | Method and system for processing 1:N relationships between data object nodes | |
| CN114860346A (en) | Management method of modeling task and operation method of modeling task | |
| CN103164765A (en) | Patent management method and management system | |
| US11061859B2 (en) | Object creation from hierarchical metadata stored on a storage device | |
| CN102521133A (en) | TCL (tool command language)-based white-box testing automation method and TCL-based white-box testing automation system | |
| JP6310532B1 (en) | Generating device, generating method, and generating program |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20160420 |
|
| RJ01 | Rejection of invention patent application after publication |