Database Concepts

What is Index Organized Table (IOT)

Index-Organized Tables – Tables stored in an index structure are called as “Index-Organized Tables” (IOT). Unlike heap-organized tables, where data (rows) gets stored randomly at any available free space, the index-organized tables store the data sorted on the primary key. This organization does not make any change in the SQL though. Organization of a table […]

What is a DataBase Management System (DBMS)

What is DataBase Management Systems (DBMS) – A DataBase Management System is a most important part of any commercial data based application development. At very minimum it is know as a computer system application facilitating capturing, storing and manipulating the data. However for working professionals a comprehensive and scientific approach is required towards defining this […]