Prediction of Data Ware House Model using Dynamic Function Point Analysis

Abstract

Approach for estimation of Data Ware House(DWH) Projects/Data Marts using Function Point Analysis is an ETL Development, Enterprise. The Objectives are the burden of maintaining the composite and enterprise data model by the data warehouse is not directly recognized. Often a development team’s “hidden” efforts in delivering the support architecture of a data warehouse are compared unfavorably with more traditional, and highly visible, user functionality. Unlike other traditional data base systems, a Data Warehouse uses other software systems as data sources and does not create new information, which generally would be more static in nature. So, applying Function Point Analysis to Data warehouse applications became more tedious as Data warehousing itself has some peculiarities of its own compared to traditional OLTP(Online Transactional Processing) applications. Data Warehouse/Data Mart are a special type of applications, with particular characteristics such as the fact that the users only use the software system for queries and report generation and not for data update, the fact that development is based on existing data of other systems without generating new information, and the fact that it follows a different development process than the traditional OLTP software systems. It is necessary, therefore, to adapt (rather than to exactly follow) the size measurement approach defined for the traditional OLTP systems so that they consider the specific characteristics of Data warehouse/Data Mart and generate more accurate estimations. The proposed approach helps in estimating Data warehouse/Data Mart Projects using Function Point Analysis especially for ETL operations, in a more traditional and systemati c way