Practical Linux Forum (Do, 04.05.2006)

SQL vs. LDAP - The right tool for the right task

von Kai Voigt (MySQL AB)

Donnerstag, 04.05.2006, Saal 11A, 13:00-14:00 Uhr

Both SQL and LDAP are infrastructures to store, retrieve and modify data. Various implementations are available, either free or commercial software.

This talk will introduce SQL and LDAP, explain what they have in common, where they are different and how they should be used. The most popular implementations will be listed, and which of them make most sense in different environments.

SQL and LDAP are based on different data structures. SQL is a relational data model, while LDAP is a hierarchical model. Both will be looked at in detail.

Examples from the real world illustrate when SQL or LDAP should be used. Sometimes it's best to just use one system, in some cases a mixture of both makes sense.

Also, common mistakes will be demonstrated when people use the wrong system, either by lack of knowlegde or by following some hype.

Speaker:

Kai Voigt works as an Instructor and Consultant for MySQL and used to implement LDAP based systems and applications in former engagements. He was invited as a speaker at various conferences, including Roxen User Conference and Open Source Database Conference.

Über den Autor Kai Voigt:

MySQL AB, Sweden/Germany, since July 2005
Senior Instructor for MySQL classes

NetUSE AG, Kiel, Germany, January 1999 - June 2005
Deputy chief of software development department
Main focus: Apache/MySQL/PHP projects
UNIX Consulting
Main focus: Mail systems, LDAP infrastructure, privacy projects
In charge of trainee education

SH Online Dienst GmbH, Kiel, Germany, December 1997 - December 1998
Main focus: Developing Apache/MySQL/php applications