What is Operational Database
Operational Database Operational Database is the database-of-record, consisting of system-specific reference data and event data belonging to a transaction-update system. It may also contain system c...
Author Archives: Editorial Team
Evolution of database systems
The file management system also called as FMS in short is one in which all data is stored on a single large file. The main disadvantage in this system is searching a record or data takes a long time
What is the use of COUNT with DISTINCT option
COUNT is a group function returns result by summarizing multiple rows. All group by value function will have the usage of DISTINCT or ALL option and so is the COUNT which uses the DISTINCT option. DI...
What are the differences between stored procedures and triggers?
Stored procedures are compiled collection of programs or SQL statements that live in the database. A stored procedure can access and modify data present in many tables. Also a stored procedure is not...
Physical and Logical Data Model
The main important aspect is physical data model is created after logical data model. For designing a logical data model one need not have through knowledge in any specific RDBMS like oracle, Informi...
What is Oracle Net Service
Oracle Net Services provides enterprise-wide connectivity solutions in distributed, heterogeneous computing environments. Oracle Net Services eases the complexities of network configuration and manag...
What is Functional Data Warehouse
Today's business environment is very data driven and more companies are hoping to create competitive advantage over other business organization competitors by creating a system whereby they can asses...
What is Enterprise Data Warehouse
Enterprise Data Warehouse is a centralized warehouse which provides service for the entire enterprise. A data warehouse is by essence a large repository of historical and current transaction data of ...
What is Active Metadata Warehouse
Active Metadata Warehouse An Active Metadata Warehouse is a repository of Metadata to help speed up data reporting and analyses from an active data warehouse. In its most simple definition, a Metadat...
What is Active Data Warehouse
Active Data Warehouse is repository of any form of captured transactional data so that they can be used for the purpose of finding trends and patterns to be used for future decision making.