Visualization of Query Processing on Data Warehouse with UML
Ugale Shrikant1, Godse Gaurav2, Kale Onkar3
1Ugale Shrikant, B.E. student of Vishwabharti Academy’s College of Engg., Department of Computer Engg Ahmednagar. State-Maharashtra, India.
2Godse Gaurav, B.E.student of Vishwabharti Academy’s College of Engg., Department of Computer Engg Ahmednagar. State-Maharashtra, India.
3Kale Onkar , B.E. student of Vishwabharti Academy’s College of Engg., Department of Computer Engg Ahmednagar. State-Maharashtra, India.
Manuscript received on September 05, 2013. | Revised Manuscript received on September 11, 2013. | Manuscript published on September 15, 2013. | PP: 12-14 | Volume-1, Issue-10, September 2013. | Retrieval Number: J04570911013/2013©BEIESP
Open Access | Ethics and Policies | Cite | Mendeley
© The Authors. Published By: Blue Eyes Intelligence Engineering and Sciences Publication (BEIESP). This is an open access article under the CC BY-NC-ND license (http://creativecommons.org/licenses/by-nc-nd/4.0/)
Abstract: Data transformations are the main subject of visual modeling concerning data warehousing dynamics. A data warehouse integrates several data sources and delivers the processed data to many analytical tools to be used by decision makers. Therefore, these data transformations are everywhere: from data sources to the corporate data warehouse by means of the ETL processes, from the corporate repository to the departmental data marts, and finally from data marts to the analytical applications Data warehousing involves complex processes that transform source data through several stages to deliver suitable information ready to be analyzed. Usually Database designer process and extract the data for their use or according to the business needs. Anyone from the organization can specify the query and get the data related to it from the data warehouse. There may be the case when the database designers or business analysts need to view query flow. In other words, if they want to analyze the flow of query in data warehouse that is how query actually flows from one table to another, they cannot easily visualize it. Though many techniques for visual modeling of data warehouses from the static point of view have been devised, only few attempts have been made to model the data flows involved in a data warehousing process. Besides, each attempt was mainly aimed at a specific application, such as ETL, OLAP, what-if analysis, data mining. Data flows are typically very complex in this domain; for this reason, designers would greatly benefit from a technique for uniformly modeling data warehousing flows for all applications. The visualization of query flow is interactive to the designer and analyst. If the designer have the model to view the internal flow then it will be easy for them to visualize the important data and attribute. UML has an activity diagram which shows the complete and accurate flow actions. So if we have activity diagram to specify the flow. It will be easy to the designers to understand the query.
Keywords: OLTP, OLAP, ETL, data warehouse, data mining.