|
#REDIRECT [[Dataphor#Languages]]
'''D4''' is a snob used in [[Dataphor]], a truly [[Relational Database Management System]].
{{Redirect category shell|1=
==Syntax==
{{R from merge}}
[[Alphora]], the creators of D4, have given it a [[Pascal (programming language)|Pascal]] like syntax. Sample code in D4 made by Alphora is usually written in [[UpperCamelCase]], which is also widely used in Pascal and [[Delphi programming language|Delphi]] systems.
{{R to section}}
}}
Like most query languages, D4 has a [[Data Definition Language]] (DDL) and a [[Data Manipulation Language]] (DML). D4 also has an [[Imperative programming|Imperative]] Language for procedural code.
===Data Definition Language===
The DDL for Dataphor bears many similarities to other DBMSs, but with an obviously Pascal-like twist. Many of the allowed DDL operations, like constraints allow [[relational]] [[Declarative_programming|declarative]] statements to be used, which many believe is superior to the procedural style operations used in [[SQL]].
===Data Manipulation Language===
The DML syntax at first glance may appear to be similar to [[SQL]]s syntax, but because of D4's closer ties to [[relational algebra]], the syntax has a cleaner definition, and most users greatly prefer it over SQL.
===Imperative Language===
The Imperative Language in D4 is remarkably similar to Pascal in many respects. The largest distinction being that D4 also allows DDL and DML statements to be run in regular procedural code.
==History==
D4 was named after the similar sounding [[Dataphor]], the system that uses the language. It was some time after these names were decided that Alphora discovered [[Tutorial D]], and the coincidence it had with that name. Since discovering Tutorial D and [[The Third Manifesto]], Alphora has used The Third Manifesto as a guide in making Dataphor and D4.
In early 2008, the Alphora name and the Dataphor product were acquired by Database Consulting Group LLC, founded by the original developers of Dataphor, and was re-licensed as open source.
==References==
*[http://dataphor.org/index.php?title=About:Dataphor Dataphor Summary]
*[http://alphora.com/ Alphora website]
*[http://dataphor.org/ Dataphor website]
*[http://databaseconsultinggroup.com/ Database Consulting Group website]
==See also==
*[[Tutorial D]]
*[[The Third Manifesto]]
{{compu-lang-stub}}
| 