Joe Celko is an American

relational database A relational database (RDB) is a database based on the relational model of data, as proposed by E. F. Codd in 1970. A Relational Database Management System (RDBMS) is a type of database management system that stores data in a structured for ...

expert from

Austin, Texas Austin ( ) is the List of capitals in the United States, capital city of the U.S. state of Texas. It is the county seat and most populous city of Travis County, Texas, Travis County, with portions extending into Hays County, Texas, Hays and W ...

. He has participated on the

ANSI The American National Standards Institute (ANSI ) is a private nonprofit organization that oversees the development of voluntary consensus standards for products, services, processes, systems, and personnel in the United States. The organiz ...

X3H2 Database Standards Committee, and helped write the

SQL Structured Query Language (SQL) (pronounced ''S-Q-L''; or alternatively as "sequel") is a domain-specific language used to manage data, especially in a relational database management system (RDBMS). It is particularly useful in handling s ...

-89 and SQL-92 standards. He is the author of a Morgan-Kaufmann series of books on SQL, and over 1200 published articles on SQL and other database topics. He had been a full-time statistician for several years. He is credited with coining the term lasagna code and popularizing Michael J. Kamfonas'

nested set model The nested set model is a technique for representing nested set collections (also known as trees or hierarchies) in relational databases. It is based on Nested Intervals, that "are immune to hierarchy reorganization problem, and allow answering an ...

for trees in SQL, a taxonomy of data encoding schemes, and several other design patterns in SQL DDL and DML.

Early life and education

Celko achieved his undergraduate and first master's degrees in math at Georgia State University. He also has a second master's degree in computer science from

Georgia Tech The Georgia Institute of Technology (commonly referred to as Georgia Tech, GT, and simply Tech or the Institute) is a public research university and institute of technology in Atlanta, Georgia, United States. Established in 1885, it has the lar ...

Career

Celko has a very wide range of industries and applications starting in 1965 with a National Science Fair prize job at the Pittman-Dunn Research labs at the

Frankford Arsenal The Frankford Arsenal is a former United States Army ammunition plant located adjacent to the Bridesburg neighborhood of Northeast Philadelphia, Pennsylvania, north of the original course of Frankford Creek. History Opened in 1816 on of lan ...

. His public sector consulting work has been for prison systems, medical organizations, NASA and defense contractors. He helped set up programming and Software Engineering standards for the US Army at AIRMICS and wrote regular columns on it in the trade press on Software Engineering. His commercial consulting work has been varied—auto loans, entertainment, aerospace, education, shipping (freight lines and ocean shipping), petro-chemical, software companies, and odd start-ups. He has taught training classes in South Africa, Turkey, the UK, Norway, Sweden, Finland, The Netherlands, Brazil, Belgium and Switzerland. He has also created and taught on-line classes for

MySQL MySQL () is an Open-source software, open-source relational database management system (RDBMS). Its name is a combination of "My", the name of co-founder Michael Widenius's daughter My, and "SQL", the acronym for Structured Query Language. A rel ...

an
SQLUniversity.org
He was part of the founding faculty of Neumont University in Salt Lake City, a for-profit university for software developers.

Bibliography

* Joe Celko's Analytics and OLAP in SQL (Morgan-Kaufmann, 2006) * Joe Celko's Data and Databases (Morgan Kaufmann, 1999) * Joe Celko's SQL for Smarties (5th Edition, Morgan-Kaufmann, 2014) * Joe Celko's SQL Programming Style (Morgan-Kaufmann, 2005) * Joe Celko's SQL Puzzles and Answers (2nd edition, Morgan-Kaufmann 2006) * Joe Celko's Trees and Hierarchies in SQL for Smarties, 2nd Edition (Morgan-Kaufmann, 2012) * Joe Celko’s Thinking in Sets: Auxiliary, Temporal, and Virtual Tables in SQL. (Morgan-Kaufmann, 2008) * Joe Celko’s Data, Measurements and Standards in SQL (Morgan-Kaufmann, 2010) * Joe Celko's Complete Guide to NoSQL (Morgan-Kaufmann, 2014)

References

External links

{{DEFAULTSORT:Celko, Joe Technical writers American software engineers Living people Georgia State University alumni Georgia Tech alumni Year of birth missing (living people)