DATA DEFINITION LANGUAGE

       Data Definition Language (DDL) is a subset of SQL (Structured Query Language) that is used to define and manage the structure of a relational database. DDL allows database administrators and developers to create, modify, and delete database objects such as tables, views, indexes, and schemas. In the blog, we will explore the concepts of DDL, its key commands, and how it is used database management.


INTERACTIVE DATA MANIPULATION LANGUAGE



        Interactive Data Manipulation Language (IDML) is a type of programming language used for performing data manipulation task interactively. IDML typically provides a set of commands or operations that can be used to manipulate data in a database, spreadsheet, or other data storage system.

        IDML is designed to be user-friendly and interactive, allowing users to issue commands or statements and see the results immediately. It often provides a prompt-based interface where user can enter commands or statements, and the system responds with the results or feedback.

 EMBEDDED DATA MANIPULATION LANGUAGE


        An embedded data manipulation language (EDML) is a type of programming language that is designed to manipulate data within a larger host programming language or environment. EDMLs provides a set of commands, functions, or syntax for performing common data manipulation operations, such as querying, filtering, sorting, aggregating, and transforming data. These commands or functions are integrated into the host programming language allowing developers to perform data manipulation operations directly within their codes.

Comments

Post a Comment

Popular posts from this blog

Blog Post #1 (LAB)

Image
      Greetings, I'm Xydrin Fritz M.Mose. I am twenty years old. My entire life has been spent in Olongapo City, Zambales, where i was born. I'm a fun-loving, sociable individual who enjoys having a good time. Im open to new ideas and I'm Constantly seeking out fresh information. I'd want to meet new people who are like-minded and share my ideas. Learning in Information management at Gordon College was a wonderful experience for me. This experience was greatly enhanced by my instructor, Ms.Mayer sanchez. She was able to give me the information I required to comprehend this topic and develop a deeper appreciation for it. I now have a better knowledge of the significance of data in the digital era thanks to my study in information management. I have learned important lesson on how to manage data efficiently and securely to preserve the integrity and protection of personal information..
Read more
 What is Sql?      Structured Query Language is known as SQL. It is a computer language created especially for controlling and working with relational databases. It is possible to insert, update, and delete data with SQL, as well as interface with databases and retrieve data from them. With SQL, you may define tables and their associations, alter the data included in the tables, and create and modify database schemas (structures). Regardless of the particular database management system (DBMS) being used, it offers a standardized means to communicate with relational databases.   Because SQL is a declarative language, the database management system determines how to carry out the operation once you define the data you want to obtain or alter. Commonly used in SQL statements are keywords, phrases, and clauses that  
Read more