1 / 7

Some issues in databse-directory integration

Some issues in databse-directory integration. Shridhar Shukla LDAP-RDBMS integration product group, PSPL. An Example of where LDAP fits. LDAP Application. RDBMS Application. SQL to LDAP (PS EnList). LDAP to SQL (?). LDAP Server. RDBMS Server. Synchronization (PS EnSure).

sirius
Download Presentation

Some issues in databse-directory integration

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Some issues in databse-directory integration Shridhar Shukla LDAP-RDBMS integration product group, PSPL Persistent Systems Private Limited (http://www.pspl.co.in)

  2. An Example of where LDAP fits Persistent Systems Private Limited (http://www.pspl.co.in)

  3. LDAP Application RDBMS Application SQL to LDAP (PS EnList) LDAP to SQL (?) LDAP Server RDBMS Server Synchronization (PS EnSure) Database/LDAP integration Persistent Systems Private Limited (http://www.pspl.co.in)

  4. LDAP to SQL • (&(Objectclass=*)(cn =‘sha*’)) • Option 1: A schema that fits the hierarchy • Unique id, an entry table per objectclass, indexed thin tables (IBM) • Option 2: Represent the hierarchy using foreign relations • mismatch • Option 3: Expose existing schema as LDAP • What will it take? How will write performance get affected? Can there be a general model? Persistent Systems Private Limited (http://www.pspl.co.in)

  5. SQL to LDAP • A structured approach to splitting the query • between the LDAP server and PS EnList • Caching of query results • Consolidation of schema across servers • High-value operators and SQL extensions • Recognize LDAP usage and optimize Persistent Systems Private Limited (http://www.pspl.co.in)

  6. LDAP to DB synchronization DB application Directory application Join Engine 1 5 3 4 Dir Change log DB Source DB 2 Persistent Systems Private Limited (http://www.pspl.co.in)

  7. Synchronization issues • The source DB data model cannot change. • Changes from multiple tables for an entity need to be synchronized with the directory • Large volumes • Selective policies, e.g., password Persistent Systems Private Limited (http://www.pspl.co.in)

More Related