Domain Specific Language Sql

Sql used for database queries and data manipulation.

Domain specific language sql. A domain specific language is a language that s written to deal with a specific domain or set of concerns. Structured query language is a domain specific language used in programming and designed for managing data held in a relational database management system rdbms or for stream processing in a relational data stream management system rdsms. Dsls are very common in computing. A computer language like sql presents an interesting case.

Well known dsls include regular expressions and sql. It can be deemed a domain specific language because it is specific to a specific domain in sql s case accessing and managing relational databases and is often called from another application but sql has more keywords and functions than many scripting languages and is often thought of as a language in its own right perhaps. The best domain specific language for manipulating data is structured query language. Structured query language sql is a domain specific language dsl used to query or interact with a relational database.

It is particularly useful in handling structured data i e. Examples include css regular expressions make rake ant sql hql many bits of rails expectations in jmock graphviz s dot language fit strut s configuration file. Dsl is a domain specific programming language used in specific domain applications. While being an effective and powerful tool for data management and access sql has limited usage compared to general purpose programming languages.

From wikipedia a domain specific language dsl is a computer language specialized to a particular application domain the dsl has several books and the most famous one from martin fowler says. Domain specific languages have been talked about and used for almost as long as computing has been done. This means that it is not a corss platform or general purpose language gpl type of language. Similarly sql with its specific application domain can be defined as a domain specific language.

I ll show you my preferred orm technique for mapping data from a relational database to a c object model. Structured query language is a highly targeted language for talking to databases. A domain specific language dsl is a specialized programming language that is used for a single purpose. Structured query language sql or cascading style sheets css you ve used a dsl.

Sql ˌ ɛ s ˌ k juː ˈ ɛ l s q l ˈ s iː k w əl sequel.