LDAP to SQL database proxy system and method
First Claim
1. A method of providing lightweight data access protocol (LDAP) directory services comprising:
- at an LDAP server comprising an LDAP to SQL (structured query language) proxy module, configuring the module to;
receive and responding to LDAP directory service requests with at least one LDAP client;
determine a reduced set of the LDAP directory services based on credentials of the LDAP client, wherein the LDAP directory service requests includes at least one of retrieving from, storing information to, and modifying information of an SQL database;
configure the proxy module in real time to implement in real-time the specific directory services to be provided to the LDAP client, based on the reduced set of the LDAP directory services;
map the received LDAP service requests to SQL queries according to the reduced set of the LDAP directory services; and
execute the SQL queries against the SQL database to obtain SQL query results and map the SQL query results to LDAP responses;
wherein the SQL database is defined by a database schema maintained externally to and separate from the LDAP server and the LDAP server is operable to use the schema.
4 Assignments
0 Petitions
Accused Products
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 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.
-
Citations
16 Claims
-
1. A method of providing lightweight data access protocol (LDAP) directory services comprising:
at an LDAP server comprising an LDAP to SQL (structured query language) proxy module, configuring the module to; receive and responding to LDAP directory service requests with at least one LDAP client; determine a reduced set of the LDAP directory services based on credentials of the LDAP client, wherein the LDAP directory service requests includes at least one of retrieving from, storing information to, and modifying information of an SQL database; configure the proxy module in real time to implement in real-time the specific directory services to be provided to the LDAP client, based on the reduced set of the LDAP directory services; map the received LDAP service requests to SQL queries according to the reduced set of the LDAP directory services; and execute the SQL queries against the SQL database to obtain SQL query results and map the SQL query results to LDAP responses; wherein the SQL database is defined by a database schema maintained externally to and separate from the LDAP server and the LDAP server is operable to use the schema. - View Dependent Claims (2, 3, 13, 14, 15)
-
4. A non-transitory computer readable medium comprising instructions, which, when executed by a computing device, adapt an LDAP server for providing directory services to connect an SQL database configured for SQL operation to at least one LDAP client configured for LDAP operation, said instructions comprising:
-
receive and responding to LDAP directory service requests with at least one LDAP client; determine a reduced set of the LDAP directory services based on credentials of the LDAP client, wherein the LDAP directory service requests includes at least one of retrieving from, storing information to, and modifying information of an SQL database; configure the proxy module in real time to implement in real-time the specific directory services to be provided to the LDAP client, based on the reduced set of the LDAP directory services; map the received LDAP service requests to SQL queries according to the reduced set of the LDAP directory services; and execute the SQL queries against the SQL database to obtain SQL query results and map the SQL query results to LDAP responses; wherein the SQL database is defined by a database schema-maintained externally to and separate from the LDAP server and the LDAP server is operable to use the schema. - View Dependent Claims (5, 6, 7)
-
-
8. A computer system comprising:
-
(a) at least one lightweight data access protocol LDAP server for providing directory services, the at least one server comprising; (b) an LDAP to Structured Query Language SQL proxy module configured for adapting the LDAP server to connect a database accessible by SQL to at least one LDAP client, the proxy module configured to; receive and responding to LDAP directory service requests with at least one LDAP client; determine a reduced set of the LDAP directory services based on credentials of the LDAP client, wherein the LDAP directory service requests includes at least one of retrieving from, storing information to, and modifying information of an SQL database; configure the proxy module in real time to implement in real-time the specific directory services to be provided to the LDAP client, based on the reduced set of the LDAP directory services; map the received LDAP service requests to SQL queries according to the reduced set of the LDAP directory services; and execute the SQL queries against the SQL database to obtain SQL query results and map the SQL query results to LDAP responses; wherein the SQL database is defined by a database schema-maintained externally to and separate from the LDAP server and the LDAP server is operable to use the schema. - View Dependent Claims (9, 10, 11, 12, 16)
-
Specification