Database Management Systems Index

Data Warehousing and Data Mining

Data Warehousing and Data Mining

1. Data warehousing   The data ware house is the modern concept of database management system. The term data warehouse is given by W.H. Inmon.     W.H. Inmon:”A subject oriented integrated, nonvolatile, time-variant collection of data in support of management decision is called data warehouse.” Ralph Kimball: Data warehouse is the conglomerate of all data marts within the enterprises. Information is always stored in the dimensional model. A collection of decision support technologies, aimed at enabling the knowledge...

read more

SQL Programming

SQL Programming

PL / SQL stands for Programming Language SQL. The PL / SQL is called extension of SQL and contains query statements and cursor control statements to enhance performance of SQL. SQL is the natural language of Oracle Engine. It creates and maintains data manipulation objects such as tables, views, sequences etc.   DDL: It stands for Data Description Language used to create objects. DML: It stands for Data Manipulation Language used to manipulate data within created objects. DCL: It is a Data Control Language for behavior control of...

read more

SQL in RDBMS

SQL in RDBMS

SQL (pronounced as “ess-queel”) is used to communicate with database. It is a standard language for RDBMS. So, it is used in Oracle, Sybase, Microsoft SQL Server, Ingress etc. It uses simple commands to work (with database). It is a declarative language which codes are interpreted by engine of DBMS. It’s one statement is enough to query a lot of information but in the case of procedural languages (BASIC, PASCAL, COBOL, C etc) many lines of codes are needed to control very simple tasks. Procedural languages are interpreted or compiled...

read more

Database Management System

Database Management System

The collection, configuration, relation and day by day action on data are called database. The logical relationship among different data is database. The concept of database is essential for every field of computer science. In general sense, text is also a type of database of characters, symbols and numbers. The animation is a database of frames, frames are database of colored pixels etc. The government and business organization, all are database based organization because every transactions are revolves around data.   Database: The...

read more