Database Management Systems Index
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 moreSQL 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 moreSQL 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 moreDatabase 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