Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

OCI 9-based database access middleware

A database and middleware technology, applied in the direction of electrical digital data processing, special data processing applications, instruments, etc., can solve problems such as client blocking and loss

Active Publication Date: 2010-08-25
WISESOFT CO LTD
View PDF0 Cites 17 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] The purpose of the present invention is to provide a kind of database access middleware based on OCI 9, in order to overcome abnormality when visiting ORACLE database, the client end is blocked for a long time and data is lost or solves the problem that the operating system platform that does not have OCI realization visits database

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • OCI 9-based database access middleware
  • OCI 9-based database access middleware
  • OCI 9-based database access middleware

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0026] pass figure 1 It can be seen that the middleware is run in the UNIX system of the air traffic control system (ATC), and is composed of a middleware operation end (MDB), a client (DBC) and a remaining record collection end (DUMP) using the client. The running terminal (MDB) is deployed on the database server, the client (DBC) is provided in the form of a dynamic library or a static library for the process that needs to access the database, and the remaining record collection terminal (DUMP) runs in the form of a process for each database that needs to be accessed. database host. The middleware running terminal (MDB) runs on the database server and uses OCI 9 to access the database. The listening port at runtime is passed in as a command line parameter. Depending on the listening port, it can run as several different instances. From 2, image 3It can be seen that the running end is designed to create a thread for each client connection. This thread is created when a new...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

Abstract

The invention discloses OCI 9-based database access middleware, which belongs to the field of computer application and can be particularly applied in distributed systems for database access. The middleware operating on a database server is developed based on the OCI technology with combination of the network technology and the multi-threading technology, and comprises a middleware operating side, a client side and a remaining record collecting side adopting the client side; wherein the operating side is deployed on a database server, the client side provides a dynamic library or a static library to a progress needing access to a database, and the remaining record collecting side operates in each host needing access to the database in a progress form. The invention can make hosts in the system except the server access the database without the basis of the OCI interface, thereby preventing the uncontrollable long-term blockage, and also solves the problems of the long-term blockage of the client side and the data loss caused by abnormal access to the ORACLE database, or the access of the operating system platform to the database without OCI.

Description

technical field [0001] The invention belongs to the field of computer applications, in particular to a distributed system, and a database access middleware based on OCI 9 which can be used in the distributed system to access databases. Background technique [0002] In a large-scale distributed system, a database server is usually equipped, and the host other than the server can access the database after installing the Oracle client. Taking the host as an example of a UNIX system, the OCI (Oracle Call Interface) provided by Oracle is usually used. ) as a programming interface for access. The latest version of OCI is developed on the basis of OCI 9. OCI interface functions have two working modes: blocking (blocking) and non-blocking (non-blocking). In non-blocking mode, By cyclically calling the same interface function until the final running result is obtained, such a function such as OCIStmtFetch, if a function can be run once to obtain the result, such as the OCIServerDetac...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
IPC IPC(8): G06F17/30
Inventor 胡术刘建波吴志红季玉龙刘舒
Owner WISESOFT CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com