Ta'a, Azman; Abdullah, Mohd. Syazwan; Md. Norwawi, Norita
January 2011
Journal of Information & Communication Technology;2011, Vol. 10, p15
Academic Journal
The design-related problems for extract, transform, load (ETL) processes are far away from being resolved due to the ambiguity of user requirements and the complexity of operations. Current approaches are based on existing software requirement methods that have limitations on reconciliation of the requirement semantics toward generating the ETL processes specification. The solution is to apply the RAMEPs (Requirement Analysis Method for ETL Processes) that was developed to facilitate the design of the ETL processes in the perspectives of organization, decision-maker, and developer. The results are the ETL processes specification, which was validated on the correctness of the goal-ontology model and evaluated in the case study of Gas Malaysia Data Warehouse (DW) system. The case study illustrated how the goal-ontology approach was successfully implemented in designing and generating the ETL processes specification.


Related Articles

  • Resist the Urge to Start Coding. Kimball, Ralph // DM Review;Nov2007, Vol. 17 Issue 11, p36 

    The author offers pieces of advice on designing a data warehouse (DW)/business intelligence (BI) system. He suggests stopping the design work for a week and making sure that one has a sufficiently broad perspective on all the requirements that surround the project. Some questions must first be...

  • MIDF raises Gas Malaysia price target.  // Malay Mail;11/9/2012, p19 

    The article reports on the increased target price set by MIDF Research on Gas Malaysia Bhd, from 2.84 to 3.11 Malaysian ringgit, after the nine-month earnings of the gas provider in 2012 surpassed market expectations.

  • Architecture Standards. Sherman, Rick // DM Review;May2004, Vol. 14 Issue 5, p63 

    The article discusses architecture standards for a data warehouse project. Just as you need a blueprint in building a house, you need a blueprint in building data warehousing and business intelligence (BI) solutions. This framework needs sub-architectures for data, information, technology and...

  • From the Editor. Powell, James E. // Business Intelligence Journal;2010, Vol. 15 Issue 4, p3 

    The article discusses various reports published within the issue including competitive intelligence, best practices for the application of agile techniques to data warehouses, and generation of personalized cost comparisons.

  • From the Editor. Powell, James E. // Business Intelligence Journal;2009, Vol. 14 Issue 2, p3 

    The article discusses various articles published within the issue, including one by Todd Saunders on the components of data warehousing and their impact on one another, one by Maria Villar on the roles and responsibilities of data stewards, and one by Hugh J. Watson on how to find the talent for...

  • From the Editor.  // Business Intelligence Journal;2014, Vol. 19 Issue 3, p3 

    An introduction to the journal is presented in which the editor discusses the topics related to business intelligence tackled within the issue including resources, system development and the challenges associated with data warehouse projects.

  • Getting business smarts. Lattig, Michael // InfoWorld;08/02/99, Vol. 21 Issue 31, p32 

    Discusses the data warehousing of customer information by companies. Effect of the Internet on business intelligence; Problems with data warehousing projects; Alignment of business intelligence with business practices; Packaged software applications for data warehousing; Change in the time...

  • Editorial Management Changes at DM Review. Cronin, Brian // DM Review;Oct2005, Vol. 15 Issue 10, p4 

    The article discusses reports published within the issue, including about the winners of the World Class Solutions Award in the business intelligence and data warehousing community and another by Henry Morris about business performance management.

  • From the Editor. Powell, James E. // Business Intelligence Journal;2010, Vol. 15 Issue 2, p3 

    The article discusses various reports published within the issue, including the cover story by William Sunna and Pankaj Agrawal on the importance of rapid result in active data warehousing, one by Sule Balkan and Michael Goul explaining how in-database analytics boost predictive modeling...


Read the Article


Sorry, but this item is not currently available from your library.

Try another library?
Sign out of this library

Other Topics