C. J. Date

C. J. Date is a Canadian computer scientist and author noted for his work on relational models, query language design, and database theory. He has written influential textbooks and papers that have shaped the development of SQL, relational algebra, and relational calculus. His career spans academia, industry, and standards discussion, engaging with organizations, vendors, and researchers worldwide.

Early life and education

Born in Toronto, Ontario, Date studied at the University of Toronto where he pursued studies related to computer science and mathematics; he later undertook postgraduate work that connected him to research communities at institutions such as the University of Cambridge, the University of Oxford, and the Massachusetts Institute of Technology. During formative years he encountered seminal works by researchers associated with IBM Research, Bell Labs, Stanford University, and Princeton University, and was influenced by publications tied to the Association for Computing Machinery and the Institute of Electrical and Electronics Engineers.

Academic and professional career

Date held positions spanning academia and industry, including engagements with companies like Relational Technology, Inc., Ingres Corporation, Oracle Corporation, IBM, Microsoft and consultancies advising bodies such as the International Organization for Standardization and the American National Standards Institute. He taught and lectured at universities including the University of California, Berkeley, the University of Waterloo, the University of Toronto and the University of British Columbia, and presented at conferences organized by SIGMOD, VLDB, ICDE and EDBT. Date collaborated with peers from organizations including Teradata, Sybase, SAP SE, PostgreSQL Global Development Group and research groups at Google, Amazon Web Services, Facebook, and Apple Inc..

Contributions to relational database theory

Date contributed to formalizations and clarifications of the relational model originally proposed by E. F. Codd, explicating relationships among relational algebra, relational calculus, normalization (database) concepts such as Third normal form, Boyce–Codd normal form, and integrity constraints like foreign key, primary key, and functional dependency. He critiqued and interpreted the SQL language standards developed by ISO/IEC JTC 1/SC 32, discussing issues with NULL handling, three-valued logic debates linked to work by Bertrand Russell and Ludwig Wittgenstein-style logic foundations, and semantic mismatches between relational model theory and SQL implementations by vendors such as Oracle Corporation, Microsoft SQL Server, IBM Db2, and MySQL. Date worked conceptually with notions akin to tuple relational calculus and domain relational calculus, engaging with theoretical results from researchers at University of California, Santa Cruz, Cornell University, University of Pennsylvania, and Massachusetts Institute of Technology.

He proposed stricter adherence to algebraic principles found in relational algebra and examined implications for query optimization practiced by systems from Ingres Corporation, PostgreSQL, Teradata, and Vertica. Date evaluated transaction processing topics related to ACID properties originally analyzed by researchers at Sequent Computer Systems and later formalized in industry, and he interacted with concurrency control research linked to Edsger W. Dijkstra and Leslie Lamport-style formal methods.

Major publications and textbooks

Date authored textbooks and monographs that became staples in curricula and professional libraries, including widely circulated works used alongside texts from authors at Addison-Wesley, O'Reilly Media, Pearson PLC, and papers presented at SIGMOD Conference and VLDB Endowment events. His writings addressed comparisons between relational model theory and practical languages like SQL, explained relational algebra operations, and influenced materials used in courses at Carnegie Mellon University, Massachusetts Institute of Technology, Stanford University, University of California, Berkeley and Imperial College London. He engaged in scholarly dialogue with contemporaries and critics from Peter Buneman's group, Michael Stonebraker's projects, researchers at IBM Research, Bell Labs, and authors such as Raghu Ramakrishnan, Jeffrey Ullman, Hector Garcia-Molina, Gerald Jay Sussman, Alfred Aho, and D. Maier.

Awards, honors, and recognition

Date received recognition from professional organizations including citations and mentions in forums sponsored by Association for Computing Machinery, IEEE Computer Society, British Computer Society, and standards bodies like ISO. His influence is acknowledged in curricula at institutions such as the University of Toronto, University of Waterloo and in practitioner communities at companies like Oracle Corporation, Microsoft, IBM and open source projects including PostgreSQL Global Development Group and MySQL AB. Academic courses referencing his work have been offered at Columbia University, New York University, University College London, and ETH Zurich, and his critiques have been discussed in panels at SIGMOD, VLDB, ICDE and CAiSE.

Category:Canadian computer scientists Category:Database theory