![]() ![]() Data Warehouse Architecture (with a Staging Area) 3. spreadsheet, word processing or other favorite applications) A simple, intuitive interface that requires minimal training to effectively utilize Pre-formatted query templates for novice users Capability to save commonly used queries for quick retrieval and execution Multi-level security for restricted data access To use data models and/or server technologies that speed up querying and reporting and that are not appropriate for transaction processing To provide an environment where a relatively small amount of knowledge of the technical aspects of database technology is required to write and maintain queries and reports and/or to provide a means to speed up the writing and maintaining of queries and reports by technical personnel To provide a repository of "cleaned up" transaction processing systems data that can be reported against and that does not necessarily require fixing the transaction processing systems To make it easier, on a regular basis, to query and report data from multiple transaction processing systems and/or from external data sources and/or from data that must be stored for query/report purposes only To provide a repository of transaction processing system data that contains data from a longer span of time than can efficiently be held in a transaction processing system and/or to be able to generate reports "as was" as of a previous point in time Data warehouses and their architectures vary depending upon the specifics of an organization's situation. Features Built-in drill-down / drill-around capability that allows detailed examination of data that comprise a summary value in a query result Built-in graphic capability that allows results to be viewed with bar, pie or line graphs Built-in export feature that allows data exports to other packages of your choice (e.g. This enables management to gain a consistent picture of the business. More data is added but data is never removed. Non-volatile Data is stable in a data warehouse. Time-variant: All data in the data warehouse is identified with a particular time period. ![]() Integrated: Data that is gathered into the data warehouse from a variety of sources and merged into a coherent whole. Abinitio Session 1- 11, UNIX Data ware housing Inmon Definition : A warehouse is a subject-oriented, integrated, timevariant and non-volatile collection of data in support of management's decision making process Ab-Initio is a data processing tool that helps in developing Business Applications from simple to most complex Data warehousing Batch processing Data movement Data transformation Subject Oriented: Data that gives information about a particular subject instead of about a company's ongoing operations. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |