Joe Celko
Joe Celko (born before 1965) is an American computer scientist. He is a relational database expert based in Austin , Texas.
Life
Celko was a member of the ANSI X3H2 Database Standards Committee and helped draft 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 with coining the phrase lasagna code .
He is also the first to describe nested sets . This is a technique of how tree structures can be stored in databases in such a way that subtrees or the path to the root can be determined with linear effort instead of recursion.
Works (selection)
- SQL Puzzles and Answers. Morgan Kaufmann, San Francisco 1997; 2nd edition: 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 .
Web links
- Joe Celko on simple-talk.com
personal data | |
---|---|
SURNAME | Celko, Joe |
BRIEF DESCRIPTION | American computer scientist |
DATE OF BIRTH | before 1965 |