LDAP to SQL database proxy system and method

A database, master database technology, applied in the field of database activities, which can solve problems such as inappropriate performance characteristics

Active Publication Date: 2007-04-04
RES IN MOTION LTD
View PDF1 Cites 10 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0006] However, because the back-sql proxy is suitable for multi-purpose SQL databases, and pre-defines the schema according to OpenLDAP's needs, it performs more work than may be necessary, and incurs more overhead than expected (storage and other resources), making its performance characteristics unsuitable for

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
  • LDAP to SQL database proxy system and method
  • LDAP to SQL database proxy system and method
  • LDAP to SQL database proxy system and method

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0020] FIG. 1 illustrates a representative computer system 100 in which a first component 102 includes an LDAP client for accessing directory services provided by an LDAP server 104 over a communication connection 106 . However, the backend data store (second component) is the RDBMS 118 accessible via SQL. In this embodiment, the LDAP server is configured as an OpenLDAP server (slapd daemon) for a LINUX operating system environment with support for different backends such as but not limited to bdb 108, sql 112, and monitor 114 Multiple standard modules. The LDAP server 104 has a backend proxy module 110 for passing SQL queries via a communication connection 116 to a database 118, which in this embodiment is based on a database maintained externally to the LDAP server 104 A typical PostgreSQL database defined by schema. Connections 106 and 116 may be public or private networks, local or wide area networks, or other communication channels, or the like. Other SQL-based databas...

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

An LDAP to SQL proxy to adapt a relational database as a directory service for an LDAP client is provided. The database may be defined in accordance with a database schema which is external to an LDAP server serving the LDAP client. The proxy comprises LDAP to SQL query and response mappings preferably for a reduced set of LDAP operations. The proxy may comprise a mechanism to maintain a plurality of persistent database connections to reduce query processing overhead. The proxy may further be adapted to maintain a plurality of persistent connections to each of at least two alternative databases for executing queries to provide enhanced failsafe operations. A plurality of LDAP to SQL proxied databases may be configured for sharing query loads to enhance scalability and performance.

Description

technical field [0001] The present invention relates generally to computer system integration and, in particular, to facilitating database activity between otherwise incompatible computer system components. Background technique [0002] Configuring a computer system to perform a particular function (eg, electronic commerce, web services, business transaction processing, electronic data communication, etc.) often involves the integration of disparate hardware and software from disparate sources. Certain components for such systems may be configured to operate with one or more other components according to a first protocol. However, system integration may wish to have that particular component operate with certain other components that do not support the first protocol. [0003] For example, it is often desirable to integrate a datastore component, including a catalog or other database, with another component of the system. Typically, data repositories are defined according ...

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/30H04L29/06
CPCG06F17/30427G06F17/30607G06F16/2452G06F16/289
Inventor 奎因·斯潘塞
Owner RES IN MOTION LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

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

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap