Data Warehouse Life Cycle and Design

2018 ◽  
pp. 878-884 ◽  
Author(s):  
Matteo Golfarelli
Keyword(s):  
2022 ◽  
pp. 819-834
Author(s):  
Nayem Rahman

Software development projects have been blamed for being behind schedule, cost overruns, and the delivery of poor quality product. This paper presents a simulation model of a data warehouse to evaluate the feasibility of different software development controls and measures to better manage a software development lifecycle, and improve the performance of the launched software. This paper attempts to address the practical issue of code defects in each stage of data warehouse application development. The author has compared the defect removal rate of their previous project to the newly proposed enhanced project development life cycle that uses code inspection and code scorecard along with other phases of software development life cycle. Simulation results show that the code inspection and code score-carding have achieved a significant code defect reduction. This has also significantly improved the software development process and allowed for a flawless production execution. The author proposes this simulation model to a data warehouse application development process to enable developers to improve their current process.


2017 ◽  
Vol 6 (2) ◽  
pp. 83-111 ◽  
Author(s):  
Selma Khouri ◽  
Ladjel Bellatreche

2012 ◽  
Vol 433-440 ◽  
pp. 3425-3432
Author(s):  
Xiao Chuan Chen ◽  
Jin Fang Liu ◽  
Qing Li

This paper mainly focused on the life cycle cost collection of manufacturing product based on web and data organization methodology according to business requirements. The general features of manufacturing product life cycle cost were analyzed at first while cost collection objects and cost-related product features were chosen. After that, the software system was developed using .NET and C# web programming technique picking up cost data from credible websites on Internet. Then, life cycle cost data warehouse model was designed via features of cost collection object ending up with the establishment of data warehouse system acquiring cost data as data source. Basic data cleaning and data validation function was developed to meet data quality demand referring to data integrality, data authenticity and data time effectiveness. Finally, an exemplification system of family cars was set up successfully assembling 300 thousand plus records about 3500 car models in last 26 months. This system was proved to work without human manipulation over hours visiting 10 thousand web pages and collecting cost data. This proved the software was valid.


CCIT Journal ◽  
2011 ◽  
Vol 4 (2) ◽  
pp. 172-184
Author(s):  
Henderi Henderi ◽  
Untung Rahardja ◽  
Muhammad Yusup

Sistem informasi pada organisasi sebagian besar digunakan untuk membantu pelaksanaan business process enterprise. Sistem tersebut pada umumnya belum dapat menyediakan informasi strategis dan membantu manajemen dalam melakukan evaluasi kinerja enterprise. Hal ini terjadi karena sistem informasi sebagian besar dibangun menggunakan konsep database OLTP (online transaction processing) dan bersifat ad hoc. Permasalahan ini terjadi pula pada sistem informasi di sebagian besar Perguruan Tinggi di Kota Tangerang sebagai sampel penelitian. Alternatif pemecahan masalah tersebut adalah membangun sistem informasi yang menerapkan konsep dan cara kerja data warehouse dan data mining yang dapat dijasikan sebagai tools pengukur kinerja enterprise. Metodologi pengembangan sistemnya menggunakan metode system developmnet life cycle (SDLC). Metode SDLC terdiri dari tahapan: system study, analysis design, system development, dan implementation. Melalui pendekatan ini diciptakan sebuah sistem informasi dengan konsep data warehouse dan data mining yang dapat menghasilkan informasi yang bersifat strategis, sesuai kebutuhan, dan sebagai tools melaksanakan pengukuran kinerja enterprise. Hasil akhir penelitian adalah sebuah sistem data warehouse dan data mining sebagai tools pengukur kinerja enterprise pada Perguruan Tinggi Raharja sebagai prototipe penerapannya.


Author(s):  
Nayem Rahman

Software development projects have been blamed for being behind schedule, cost overruns, and the delivery of poor quality product. This paper presents a simulation model of a data warehouse to evaluate the feasibility of different software development controls and measures to better manage a software development lifecycle, and improve the performance of the launched software. This paper attempts to address the practical issue of code defects in each stage of data warehouse application development. The author has compared the defect removal rate of their previous project to the newly proposed enhanced project development life cycle that uses code inspection and code scorecard along with other phases of software development life cycle. Simulation results show that the code inspection and code score-carding have achieved a significant code defect reduction. This has also significantly improved the software development process and allowed for a flawless production execution. The author proposes this simulation model to a data warehouse application development process to enable developers to improve their current process.


Sign in / Sign up

Export Citation Format

Share Document