Category: SQL
-
Database transaction and ACID properties
Database Transaction A transaction is logical unit of work which has a complete status performed within a database management system. It should not be in an inconsistent status.Example :- Assume a user has a savings account having 4000 unit of currency. He withdraws 100 unit of currency from an ATM and this withdrawal is referred as a transaction.1. User/Card/Account authentication. 2. Withdrawal request for 100 unit […]
-
Difference between DBMS and RDBMS
RDBMS is a super set of DBMS plus some more features. Consolidated few differences here. DBMS RDBMS Organization, storage, management, and retrieval of data Yes Yes Flat file design Yes No Relational design No Yes Password protection Yes Yes Enforce referential integrity No Yes Null or blank data management Yes Yes Meta data support Yes […]
-
What is ANSI SQL
ANSI means American National Standards Institute (http://www.ansi.org) Evolution of ANSI SQL SQL is an integral part of many modern RDBMS like Oracle, DB2, Microsoft SQL Server, MySQL etc. Each vendor developed their own SQL syntax for their own products. All over the world many government, public and private agencies use different database products from different […]
-
Introduction – DBMS and RDBMS
What is DBMS ? A DBMS is a set of software programs that controls the system organization, storage, management, and retrieval of data in a database. The DBMS determines how data are stored and retrieved. Data is the back bone of any organization. So it is very essential to manage it in a efficient way. DBMS accepts […]
-
What is SQL
SQL (pronouncing as ‘sequel’) means Structured Query Language. It is a programming language to manage data which is stored in an organized manner. Why SQL ? How SQL originated ? Every body know that data is the back bone of any organization or company. So cost effective data management is vital. So there should be […]