Joe Celko
Encyclopedia
Joe Celko is an American relational database
expert from Austin, Texas
. He has participated on the ANSI
X3H2 Database Standards Committee, and helped write the SQL-89 and SQL-92 standards. He is the author of a Morgan-Kaufmann series of books on SQL, and over 1000 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
for trees in SQL, state transition constraint
s in SQL, a taxonomy of data encoding schemes, and several other design patterns in SQL DDL and DML.
Relational database
A relational database is a database that conforms to relational model theory. The software used in a relational database is called a relational database management system . Colloquial use of the term "relational database" may refer to the RDBMS software, or the relational database itself...
expert from Austin, Texas
Austin, Texas
Austin is the capital city of the U.S. state of :Texas and the seat of Travis County. Located in Central Texas on the eastern edge of the American Southwest, it is the fourth-largest city in Texas and the 14th most populous city in the United States. It was the third-fastest-growing large city in...
. He has participated on the ANSI
Ansi
Ansi is a village in Kaarma Parish, Saare County, on the island of Saaremaa, Estonia....
X3H2 Database Standards Committee, and helped write the SQL-89 and SQL-92 standards. He is the author of a Morgan-Kaufmann series of books on SQL, and over 1000 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
Nested set model
The nested set model is a particular technique for representing nested sets in relational databases.The term was apparently introduced by Joe Celko; others describe the same technique without naming it or using different terms...
for trees in SQL, state transition constraint
Transition constraint
A transition constraint is a way of enforcing that the data doesn't enter an impossible state because of a previous state. For example, it shouldn't be possible for a person to change from being "married" to being "single, never married"...
s in SQL, a taxonomy of data encoding schemes, and several other design patterns in SQL DDL and DML.