rajesh hamal

Data warehouse is a relational or multidimensional database management system (DBMS) designed to support the management in decision making process. • Data warehouse is a repository of an organization’s electronically stored data and are designed to facilitate reporting and analysis • It also emphasizes on the means to retrieve and analyze data, to extract, transform and load data, and to manage the data dictionary. • An expanded definition for Data warehousing includes business intelligence tools, tools to extract, transform, and load data into the repository, and tools to manage and retrieve metadata (data about data). • In contrast to data, warehouses are operational systems that perform day-to-day transaction processing. • A data warehouse is a collection of computer-based information that is critical to successful execution of enterprise initiatives • It provides a tool to satisfy the information needs of the employees at all organizational levels-not just for complex data ...

Database And Database Management System In Brief A computer system organizes data in a hierarchy that begins with bits, and proceeds to bytes, fields, records, files and databases. Bit is the smallest unit of data that a computer can process. It's valid values are 0s and 1s. Similarly Byte is a group of 8 bits.  Fields are the  logical grouping of characters into a word, a small group of words, or a complete number is called Field. Records are the logical grouping of related fields whereas Files are the grouping of related records.  Database:  A database is a collection of information that is organized so that it can easily be accessed, managed, and updated. Advantages of Database: A. Database reduce  the problem of Data Redundancy. B. It help in avoiding the  Inconsistency. C. Data sharing D. Standards can be enforced. E. Security restrictions can be applied. F. Integrity or Accuracy can be maintained. Characteristics of Datab...