![]() It specifies source, values, usage and features of DWH data and defines how data can be changed and processed at every architecture layer. 1.2 Metadata Meta data is “data about data” or Meta data is “the data used to define other data”. Figure 1: The above diagram shows in the integration system we are use different tools but also database management systems need the basic requirements depends of Data warehouse, meta data, OLTP and OLAP. ![]() Allow Meta data to be imported / exported into from other standard and formats. Allow end users to navigate and query Meta data. According to Kelly, a tool for Meta data management should: Allow administrator to perform system administration operations, and manage security. information directory that includes several enhancing functions. Decision support places some different requirements on database technology compared to traditional on – line transaction processing applications. ![]() Many commercial products and services are now available, and all of principal database management system providers now offerings in these areas. ong>Introductionong> OLTP, OLAP, Meta data and Data warehouse are essential elements of supports system, which has increasingly become a focus of the database industry. Keywords: Meta data, online transaction processing system, on – line analytical processing, Data Warehouse 1. The main here consider that Data warehouse usage, process, Data warehouse with Meta data, online transaction processing system (OLTP), on-line analytical processing (OLAP) and also OLTP vs. This paper is research about the data warehousing with OLAP and OLTP with the basic need and main parts of the business database management. Nowadays many services, products and new techniques are available and offering many ideas in the DBMS. 2569-2573 ong>Introductionong> on Data Warehouse with OLTP and OLAP Arpit Parekh Maharaja Krishnakumar Sinhji Bhavnagar University, Department of Computer Application, Shree Swaminaranyan Naimisharanaya College of Management and IT, Bhavnagar, India Abstract: Data warehouse, online transaction processing system (OLTP) and on-line analytical processing (OLAP) are basically main need of the database collection in business, corporate fields and many areas. 10.International Journal Of Engineering And Computer Science ISSN:2319-7242 Volume2 Issue 8 August, 2013 Page No. ![]() Data Warehousing in the Real World provides comprehensive guidelines and techniques for the delivery of decision support solutions using open-systems data warehouses. ![]() Data warehouses are the primary means by which businesses can gain competitive advantage through analyzing and using the information stored in their computerized systems. Data Mining Pieter Adriaans & Dolf Zantinge 1997, Pearson. Data Warehousing In the Real World Sam Anahory & Dennis Murray 1997, Pearson. ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |