Joe Celko

Joe Celko is an expert in relational databases from Austin, Texas.

Life

Celko was a member of the ANSI X3H2 Database Standards Committee and helped to design the SQL -89 and SQL -92 standards. He is the author of six books and over 700 articles on SQL and other database topics.

He is credited to have coined the term lasagna code.

It also describes the first nested sets. This is a technique, such as tree structures in databases can be stored so that subtrees or the path to the root with linear effort instead can be determined by recursion.

Works (selection)

• SQL Puzzles and Answers.Morgan Kaufmann, San Francisco, 1997; 2 Incept: Elsevier Morgan Kaufmann, Amsterdam 2007, ISBN 978-0-12-373596-6
• Data and Databases. concepts in practice. Morgan Kaufmann, San Francisco, 1999, ISBN 1-55860-432-4.
• Trees and hierarchies in SQL for smarties. Morgan Kaufmann, Amsterdam 2004; 2nd edition 2012, ISBN 978-0-12-387733-8.
• SQL for Smarties. Morgan Kaufmann, San Francisco 2005; 4th Edition: Morgan Kaufmann, Burlington 2011, ISBN 978-0-12-382022-8.
• SQL Programming Style. Morgan Kaufmann, San Francisco, 2005, ISBN 0-12-088797-5.
• Analytics and OLAP in SQL. Morgan Kaufmann, San Francisco, 2006, ISBN 0-12-369512-0.