Data Manipulation Language Functions and How does it work :

 DATA DEFINITION LANGUAGE:


DATA DEFINITION LANGUAGE (DDL) is a subset of SQL (Structured Query Language) used for defining and managing the structure of a database. DDL provides a set of SQL commands that allow users to define, modify, and manage the various database objects such as tables, views, indexes, constraints, and schemas.

CREATE: Used to create new database objects such as tables, views, indexes, constraints, and schemas.

ALTER: Used to modify the structure of existing database objects such as tables, views, and schemas

DROP: Used to delete existing database objects such as tables, views, indexes, constraints, and schemas. 

TRUNCATE: Used to remove all data from a table while keeping the structure intact. For example:

RENAME: Used to rename existing database objects such as tables, views, indexes, constraints, and schemas. 

DDL commands are typically executed by users with appropriate privileges, such as database administrators or users with ownership rights on the objects being defined or modified. DDL is an important aspect of database management, as it allows users to define and maintain the structure of a database, ensuring data integrity and consistency.


 INTERACTIVE DATA MANIPULATION LANGUAGE:


INTERACTIVE DATA MANIPULATION LANGUAGE (IDML) is a subset of SQL (Structured Query Language) that allows users to interactively manipulate data stored in a relational database. IDML provides a set of SQL commands that enable users to perform operations such as querying, inserting, updating, and deleting data in a database.


SELECT: Used to retrieve data from one or more tables in a database based on specified conditions. SELECT allows users to query the database and retrieve data that meets certain criteria.

INSERT: Used to add new data into a table in a database. INSERT allows users to add new records to a table with specified values for each column.

UPDATE: Used to modify existing data in a table in a database. UPDATE allows users to change the values of one or more columns in existing records based on specified conditions. 

DELETE: Used to remove data from a table in a database. DELETE allows users to delete records from a table based on specified conditions.

IDML commands are typically executed by users with appropriate privileges, such as regular users with read and write access to the database. IDML is an essential part of interacting with a relational database, as it enables users to manipulate data stored in the database according to their requirements.


 EMBEDDED DATA MANIPULATION LANGUAGE:


EMBEDDED DATA MANIPULATION LANGUAGE (EDML) refers to the use of data manipulation commands within a programming language or application code to interact with a relational database. EDML allows for the integration of SQL (Structured Query Language) commands directly into the code of an application, which enables the application to interact with the underlying database for retrieving, inserting, updating, and deleting data.

EDML typically involves the use of special SQL statements that are embedded within the code of an application using placeholders or variables to dynamically substitute values. These statements are then processed by the database management system (DBMS) when the application is executed.


JDBC (Java Database Connectivity): This is a popular Java API that allows Java applications to interact with relational databases. JDBC includes SQL commands embedded within Java code using classes and methods provided by the JDBC API. 

PDO (PHP Data Objects): This is a database abstraction layer in PHP that allows PHP applications to interact with various databases using a unified API. PDO includes SQL commands embedded within PHP code using PDO classes and methods.

ActiveRecord (Ruby on Rails): This is an ORM (Object-Relational Mapping) framework in Ruby on Rails that allows Ruby applications to interact with databases using Ruby classes and objects. ActiveRecord includes SQL commands embedded within Ruby code using ActiveRecord methods.

EDML allows developers to leverage the power of SQL within their programming language of choice, making it easier to interact with relational databases and manipulate data as needed. It provides a more seamless and integrated approach to working with databases in applications, without the need for separate SQL scripts or files.

Comments

Post a Comment

Popular posts from this blog

DBMS: Function, Advantage and Disadvantage

Image
  Function of a DBMS allowing numerous people to view a single database at once. establishing and maintaining user access permissions and security guidelines.   frequent data backups and speedy data recovery in the event of a breach. establishing database policies and guidelines to safeguard data integrity.   ADVANTAGE OF DBMS A DBMS can streamline your data processes and boost the commercial value of your company's data assets while relieving users throughout the company of tedious and time-consuming data processing duties. The outcome? improved data regulation compliance, a more productive workforce, and better decision-making.   Disadvantages of DBMS Increased Cost. High cost is one of the main disadvantages of DBMS, the cost can be of many types like hardware or software costs, data storage costs, etc. ... Complexity. Database Failure. ... Performance. ... Frequent Updates/Upgrades. ... Huge Size.      
Read more

Mapping Interactions: The Use Case Model

Image
  Use case models are diagrammatic representations that describe how users (actors) interact with a system to achieve specific goals. They include use cases, which are scenarios that describe the steps taken by actors to accomplish a task. Use case models help in understanding the functional requirements of a system from the user's perspective. Key Components of Use Case Models: Actors: The individuals or entities that interact with the system. Use cases: Scenarios that describe the interactions between actors and the system. Relationships: The relationships between actors and use cases, such as association, generalization, and dependency. Benefits of Use Case Models: Defines system functionality: Clearly outlines the system's capabilities and how users will interact with it. Facilitates requirements gathering: Helps to identify and document user requirements. Supports system design: Provides a basis for designing the system's architecture and components. Aid...
Read more

Embracing Change: The Agile Methodology

Image
  Agile, a revolutionary approach to project management and software development, has gained significant popularity in recent years. By prioritizing flexibility, collaboration, and customer satisfaction, Agile empowers teams to deliver high-quality products efficiently and adapt to the ever-changing demands of the modern business landscape. Key Principles of Agile The Agile methodology is built on several fundamental principles: Individuals and Interactions over Processes and Tools: Emphasizes the importance of human relationships and collaboration over rigid processes and tools. Working Software over Comprehensive Documentation: Prioritizes the delivery of functional software over extensive documentation. Customer Collaboration over Contract Negotiation: Fosters open communication and collaboration with customers to ensure their needs are met. Responding to Change over Following a Plan: Embraces change as an opportunity for improvement and is adaptable to evolving requirem...
Read more