Data warehouse

Data warehousing emphasizes capturing data from various sources for useful analysis and access, but not generally emanate from the point of view of the end user who may have access to specialized and sometimes require local databases. This last idea is known as the data mart.

There are two ways of data warehousing, top-down and bottom-up. The top-down approach spins off data marts for specific groups of users after the entire data warehouse was created. The bottom-up approach to building data marts and then combines them into a single, comprehensive data warehouse.

Typically, a data warehouse housed on a mainframe enterprise server or increasingly, in the cloud. Data from various online transaction processing (OLTP) applications and other sources is selectively extracted for use by analytical applications and the user queries.

The data warehouse term was coined by William H. Inmon, known as the Father of Data Warehousing. Inmon described a data warehouse as a subject-oriented, integrated, time-variant and non-volatile collection of data that supports the decision-making of management.

Online References

http://www.tutorialspoint.com/dwh

https://docs.oracle.com/cd/B10500_01/server.920/a96520/concept.htm

E Books

Data Warehousing Fundamentals: A Comprehensive Guide for IT Professionals

DATA WAREHOUSING: Concepts, Techniques, Products and Applications

Data Warehouses and OLAP: Concepts, Architectures, and Solutions

Office Automation Systems(OAS)

Office automation systems (OAS) are configurations of networked computer hardware and software. A variety of office automation systems are now applied to business and communication functions that used to be performed manually or in multiple locations of a company, such as preparing written communications and strategic planning. In addition, functions that once required coordinating the expertise of outside specialists in typesetting, printing, or electronic recording can now be integrated into the everyday work of an organization, saving both time and money.

Types of functions integrated by office automation systems include (1) electronic publishing; (2) electronic communication; (3) electronic collaboration; (4) image processing; and (5) office management. At the heart of these systems is often a local area network (LAN) . The LAN allows users to transmit data, voice, mail, and images across the network to any destination, whether that destination is in the local office on the LAN, or in another country or continent, through a connecting network. An OAS makes office work more efficient and increases productivity.

Source from:-www.encyclopedia.com

Learn more...