Design Life-Cycle-Driven Approach for Data Warehouse Systems Configurability

2017 ◽  
Vol 6 (2) ◽  
pp. 83-111 ◽  
Author(s):  
Selma Khouri ◽  
Ladjel Bellatreche
Keyword(s):  
Life Cycle ◽  
Data Warehouse ◽  
Design Life

Data Warehouse Testing

2013 ◽  
pp. 91-108
Author(s):  
Matteo Golfarelli ◽  
Stefano Rizzi
Keyword(s):  
Life Cycle ◽  
Data Warehouse ◽  
Design Method ◽  
Real Case ◽  
Data Mart ◽  
Design Life ◽  
Software Product ◽  
Reference Design ◽  
Warehouse Design

Testing is an essential part of the design life-cycle of a software product. Although most phases of data warehouse design have received considerable attention in the literature, not much research has been conducted concerning data warehouse testing. In this paper, the authors introduce a number of data mart-specific testing activities, classify them in terms of what is tested and how it is tested, and show how they can be framed within a reference design method to devise a comprehensive and scalable approach. Finally, the authors discuss some practical evidences emerging from a real case study.

scholarly journals CLASSIFICATION OF DATA WAREHOUSE TESTING APPROACHES

2012 ◽  
Vol 3 (3) ◽  
pp. 381-386 ◽  
Author(s):  
Dr. S. L. Gupta ◽  
Dr. Payal Pahwa ◽  
Ms. Sonali Mathur
Keyword(s):  
Life Cycle ◽  
Data Warehouse ◽  
Iterative Process ◽  
Strategic Decisions ◽  
Design Life ◽  
Warehouse Design ◽  
Different Levels

Data Warehouse is a collection of large amount of data which is used by the management for making strategic decisions. The data in a data warehouse is gathered from heterogeneous sources and then populated and queried for carrying out the analysis. The data warehouse design must support the queries for which it is being used for. The design is often an iterative process and must be modified a number of times before any model can be stabilized. The design life cycle of any product includes various stages wherein, testing being the most important one. Data warehouse design has received considerable attention whereas data warehouse testing is being explored now by various researchers. This paper discusses about various categories of testing activities being carried out in a data warehouse at different levels

Data Warehouse Testing

2011 ◽  
Vol 7 (2) ◽  
pp. 26-43 ◽  
Author(s):  
Matteo Golfarelli ◽  
Stefano Rizzi
Keyword(s):  
Life Cycle ◽  
Data Warehouse ◽  
Design Method ◽  
Real Case ◽  
Data Mart ◽  
Design Life ◽  
Software Product ◽  
Reference Design ◽  
Warehouse Design

Testing is an essential part of the design life-cycle of a software product. Although most phases of data warehouse design have received considerable attention in the literature, not much research has been conducted concerning data warehouse testing. In this paper, the authors introduce a number of data mart-specific testing activities, classify them in terms of what is tested and how it is tested, and show how they can be framed within a reference design method to devise a comprehensive and scalable approach. Finally, the authors discuss some practical evidences emerging from a real case study.

A Simulation Model for Application Development in Data Warehouses

2022 ◽  
pp. 819-834
Author(s):  
Nayem Rahman
Keyword(s):  
Life Cycle ◽  
Software Development ◽  
Simulation Model ◽  
Data Warehouse ◽  
Development Process ◽  
Application Development ◽  
Cost Overruns ◽  
Development Lifecycle ◽  
Development Life Cycle ◽  
Software Development Lifecycle

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.

scholarly journals Steel-Concrete Composite Bridges: Design, Life Cycle Assessment, Maintenance, and Decision-Making

2020 ◽  
Vol 2020 ◽  
pp. 1-13 ◽  
Author(s):  
D. Martínez-Muñoz ◽  
J. V. Martí ◽  
V. Yepes
Keyword(s):  
Decision Making ◽  
Life Cycle ◽  
Impact Assessment ◽  
Concrete Bridges ◽  
Future Research ◽  
Preliminary Design ◽  
Design Constraints ◽  
Sustainable Solutions ◽  
Design Life ◽  
Composite Bridges

Steel-concrete composite bridges are used as an alternative to concrete bridges because of their ability to adapt their geometry to design constraints and the possibility of reusing some of the materials in the structure. In this review, we report the research carried out on the design, behavior, optimization, construction processes, maintenance, impact assessment, and decision-making techniques of composite bridges in order to arrive at a complete design approach. In addition to a qualitative analysis, a multivariate analysis is used to identify knowledge gaps related to bridge design and to detect trends in research. An additional objective is to make visible the gaps in the sustainable design of composite steel-concrete bridges, which allows us to focus on future research studies. The results of this work show how researchers have concentrated their studies on the preliminary design of bridges with a mainly economic approach, while at a global level, concern is directed towards the search for sustainable solutions. It is found that life cycle impact assessment and decision-making strategies allow bridge managers to improve decision-making, particularly at the end of the life cycle of composite bridges.

Effect of Annular Plate Projection Length on the Stresses in the Above Ground Steel Storage Tanks on Rigid Ring Wall Foundations

2011 ◽  
Author(s):  
Sridhar Sathyanarayanan ◽  
Seshu M. R. Adluri
Keyword(s):  
Life Cycle ◽  
Elevated Temperature ◽  
Theoretical Model ◽  
Annular Plate ◽  
Bottom Plate ◽  
Storage Tanks ◽  
Plastic Hinges ◽  
Rigid Ring ◽  
Design Life ◽  
Projection Length

The paper examines the effect of increased bottom plate projection for tanks with rigid ring wall foundations. A theoretical model, based on the existing model from Denham is proposed to determine the maximum projection length. The behavior of the tank, specifically near the bottom is studied till failure using FEA. The formation of plastic hinges in the bottom plate on the inside and outside of this joint is discussed in detail. The validity of the assumptions made by Karcher with regard to plastic hinges for obtaining the expression for the design life cycle in elevated temperature tanks is briefly analyzed.

The Design of Family Cars’ Life Cycle Cost Data Warehouse Based on Web

2012 ◽  
Vol 433-440 ◽  
pp. 3425-3432
Author(s):  
Xiao Chuan Chen ◽  
Jin Fang Liu ◽  
Qing Li
Keyword(s):  
Life Cycle ◽  
Data Warehouse ◽  
Life Cycle Cost ◽  
Product Life Cycle ◽  
Cost Data ◽  
Web Pages ◽  
Programming Technique ◽  
Set Up ◽  
Meet Data ◽  
Business Requirements

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.

Sign in / Sign up

Export Citation Format

Share Document