cursor in sql

cursor in sql-: Cursor are used to process a collection of row computed by an embedded sql statement in host language programme.It can be thought of as a pointer that point to a single row from the result of a query that retrieves multiple rows. In other words we can say that A cursor is a … Read more cursor in sql

triggers in sql

Triggers In SQL-:  Triggers are the part of sql. Active database is a database which provide facility for specifying for active rules.These rules can be automatically triggered by events that occur on database and initiate certain actions that have been specified in the rule declaration. Commercial database provide functionality of active database in the form … Read more triggers in sql

open database connectivity

Open Database Connectivity-: Open Database Connectivity (ODBC)is a widely accepted application programming interface for database access. ODBC is designed for maximum interoperability as like the ability of a single application to access different database management system with the same source code. DBMS application call functions in the ODBC interface which are implemented in database specific … Read more open database connectivity

object oriented database management system

Object Oriented Database Management System(OODBMS)-: In recent years, several database applications have emerged whose complexities is not well handled by the relational database system as relational database system supports a fixed set of data type which is inadequate for such complex applications. These complex applications typically involve data that are highly interrelated such as product … Read more object oriented database management system

limitation of rdbms

limitation of rdbms-:We can easily see that in the changing scenario of web, advance and complex applications requirements are not easily satisfied by traditional RDBMS.  Following are the limitations of RDBMS due to which it is required to enhance it and equip it with new features : 1. Model Value Based Rather than Entity Based -: … Read more limitation of rdbms

Structured Data Types in dbms

Structured Data Types -: A structured data type is a user defined data type with elements that are not atomic rather they are divisible and can be used either separately or as a single unit as per requirements. It is a form of user defined object that contains a sequence of attributes, each of which … Read more Structured Data Types in dbms

Object database system

Introduction -:In recent years, several database applications have emerged whose complexities is not well handled by the relational database system as relational database system supports a fixed set of data type which is inadequate for such complex applications. These complex applications typically involve data that are highly interrelated such as product definitions, multimedia content, or … Read more Object database system

 Evolution Towards Object Oriented Paradigm

                      Evolution Towards Object Oriented Paradigm Relational Database System proves to be a powerful tool for maintaining and storing data. But there are certain complex applications which involve highly interrelated and complex data such as audio, video, digital signatures, product specifications,bills, excel sheets etc. OODBMS … Read more  Evolution Towards Object Oriented Paradigm

transaction control language in sql

Transaction Control Language (TCL)-: TCL is the part of structure query language.It managed transaction in database.Understanding TCL we Divided TCL in some like A. Database Transaction:-The server ensures data consistency based on transactions. Transactions give we more flexibility and control when changing data, and they ensure data consistency in the event of user process failure … Read more transaction control language in sql

Data Manipulation Language in sql

Data Manipulation Language (DML)-:Data Manipulation Language (DML) is a core part of SQL. When we want to add, update or delete data in the database, we execute a DML statement. A collection of DML statements that form a logical unit of work is called transaction. DML Statements : Statement Purpose Insert Add rows to table … Read more Data Manipulation Language in sql