DBMS supports many languages out of which (SDL) is one of them. SDL stands for Storage Definition Language. SDL matter is almost anything that’s not specified by SQL standard. It is different in every DBMS which specifies anything to do with how or where data in relevant table is stored. It’s applications are as follows :
- Used to define internal schema.
- It defines physical structure of database.
- The order of fields.
- Bytes per field will be used.
- How records will be accesses etc.
- The mapping between two schema may also be defined.
Example : Let us take some examples to understand how Storage Definition Language (SDL) works.
CREATE TABLE geeksforgeeks (no_of_articles INT) ENGINE = INNODB;
In the above example, we specify storage engine to be used by adding ENGINE option. InnoDB is default storage engine for MySQL 8.0.
CREATE TABLE geeksforgeeks (article_titile varchar(65000) ENGINE = MEMORY;
This time, engine used is MEMORY. MEMORY storage engine (also known as HEAP) creates tables for particular purpose with contents that are stored in memory. Because the data is vulnerable to power outages, crashes or hardware issues, only use these tables as temporary work areas or read-only caches for data pulled from other tables.
CREATE TABLE f (x int, y varchar(25));
In the above statement, Storage Definition Language (SDL) defines storage of row int, varchar(25).
Indeed, In most relational database management systems (RDBMS) there is no specific language that performs the role of SDL. Instead, combination of functions, parameters, and specifications related to storage of files define internal schema.
Attention reader! Don’t stop learning now. Get hold of all the important CS Theory concepts for SDE interviews with the CS Theory Course at a student-friendly price and become industry ready.
- Difference between Cloud Storage and Traditional Storage
- Difference between Definition and Declaration
- Definition and Overview of ODBMS
- Golang Program to Use Field Tags in the Definition of Struct Type
- Storage Area Networks
- Network attached storage in DBMS
- Data Marts (storage component of HDFS)
- HTML | DOM Storage Event
- HTML | DOM Storage key() Method
- HTML | DOM Storage removeItem() Method
- HTML | DOM Storage getItem() Method
- HTML | DOM Storage setItem() Method
- HTML | DOM Local Storage clear() Method
- HTML | DOM Storage length Property
- Components of Storage Area Network (SAN)
- WOS and ROS storage in HP Vertica
- Benefits of Content-Addressed Storage
- What is Internal Storage Encoding of Characters(ISCII)?
- Storage Snapshot Technology
- Introduction to Scripting Languages
If you like GeeksforGeeks and would like to contribute, you can also write an article using contribute.geeksforgeeks.org or mail your article to firstname.lastname@example.org. See your article appearing on the GeeksforGeeks main page and help other Geeks.
Please Improve this article if you find anything incorrect by clicking on the "Improve Article" button below.