Quality measures for ETL processes: from goals to implementation

Extraction transformation loading (ETL) processes play an increasingly important role for the support of modern business operations. These business processes are centred around artifacts with high variability and diverse lifecycles, which correspond to key business entities. The apparent complexity of these activities has been examined through the prism of business process management, mainly focusing on functional requirements and performance optimization. However, the quality dimension has not yet been thoroughly investigated, and there is a need for a more human-centric approach to bring them closer to business-users requirements. In this paper, we take a first step towards this direction by defining a sound model for ETL process quality characteristics and quantitative measures for each characteristic, based on existing literature. Our model shows dependencies among quality characteristics and can provide the basis for subsequent analysis using goal modeling techniques. We showcase the use of goal modeling for ETL process design through a use case, where we employ the use of a goal model that includes quantitative components (i.e., indicators) for evaluation and analysis of alternative design decisions.Peer ReviewedPostprint (author's final draft

Value-Driven Enterprise Architecture Evaluation for the Joint Force Protection Advanced Security System

The U.S. military has placed a strong focus on the importance of operating in a joint environment, where capabilities and missions are shared between service components. Protecting U.S. forces is a major consideration in the joint environment. The Joint Force Protection Advanced Security System (JFPASS) architecture has been created to fill a critical gap in Joint Force Protection guidance for systems acquisition. The systems engineering (SE) field has made wide use of system architectures to represent complex systems. As fundamental SE principles become more widespread, analysis tools provide an objective method for the evaluation of the resulting architectural products. This study used decision analysis to develop a standardized, yet adaptable and repeatable model to evaluate the capabilities of the JFPASS for any installation or facility belonging to the United States Department of Defense (DoD). Using the Value-Focused Thinking (VFT) methods, a value hierarchy was created by consulting with subject matter experts. The resulting model, named Value-Driven Enterprise Architecture (VDEA) score, provides an analysis tool, which enables DoD decision-makers to use JFPASS architecture products to quickly and easily evaluate the value provided by the system; VDEA provides insight into the overall quality and capability of the system. Through the scoring and sensitivity analysis functions, capability gaps and potential improvements can be identified. Future studies in this area will provide a vehicle for rating not only operational level systems, but also individual functional projects against other alternatives

Resilience, Reliability, and Recoverability (3Rs)

Recent natural and human-made disasters, mortgage derivatives crises, and the need for stable systems in different areas have renewed interest in the concept of resilience, especially as it relates to complex industrial systems with mechanical failures. This concept in the engineering systems (infrastructure) domain could be interpreted as the probability that system conditions exceed an irrevocable tipping point. But the probability in this subject covers the different areas that different approaches and indicators can evaluate. In this context, reliability engineering is used the reliability (uptime) and recoverability (downtime) indicators (or performance indicators) as the most useful probabilistic tools for performance measurement. Therefore, our research penalty area is the resilience concept in combination with reliability and recoverability. It must be said that the resilience evaluators must be considering a diversity of knowledge sources. In this thesis, the literature review points to several important implications for understanding and applying resilience in the engineering area and The Arctic condition. Indeed, we try to understand the application and interaction of different performance-based resilience concepts. In this way, a collection of the most popular performance-based resilience analysis methods with an engineering perspective is added as a state-of-the-art review. The performance indicators studies reveal that operational conditions significantly affect the components, industry activities, and infrastructures performance in various ways. These influential factors (or heterogeneity) can broadly be studied into two groups: observable and unobservable risk factors in probability analysis of system performance. The covariate-based models (regression), such as proportional hazard models (PHM), and their extent are the most popular methods for quantifying observable and unobservable risk factors. The report is organized as follows: After a brief introduction of resilience, chapters 2,3 priorly provide a comprehensive statistical overview of the reliability and recoverability domain research by using large scientific databases such as Scopus and Web of Science. As the first subsection, a detailed review of publications in the reliability and recoverability assessment of the engineering systems in recent years (since 2015) is provided. The second subsection of these chapters focuses on research done in the Arctic region. The last subsection presents covariate-based reliability and recoverability models. Finally, in chapter 4, the first part presents the concept and definitions of resilience. The literature reviews four main perspectives: resilience in engineering systems, resilience in the Arctic area, the integration of “Resilience, Reliability, and Recoverability (3Rs)”, and performance-based resilience models

Integration of resource efficiency and waste management criteria in European product policies – Second phase Report n° 3 - Refined methods and Guidance documents for the calculation of indices concerning Reusability / Recyclability / Recoverability, Recycled content, Use of Priority Resources, Use of Hazardous substances, Durability (final)

the report illustrates the refined methodologies for the assessment of: reusability/recyclability/recoverability-RRR, use of relevant resources, recycled content, use of hazardous substances, durability. Based on results of the previous project Phase 1, the methodologies have been revised according to the outcomes of their application to some exemplary case-studies .JRC.H.8-Sustainability Assessmen

Analyzing the Effectiveness of Legal Regulations and Social Consequences for Securing Data

There is a wide range of concerns and challenges related to stored data security – which range from privacy and management to operations readiness, These challenges span from financial to personal and public impact. With an abundance of regulations for the enforcement of data security and emerging requirements proposed every year, organizations cannot avoid the legal or social implications of inadequate data protection. Today, public spotlight and awareness are challenging organizations to enhance how data is protected more than at any other time. For this reason, organizations have made significant efforts to improve security. When looking at precautions or changes, the factors considered are costs associated with such action, a potential consequence of not acting, impact on users, the effort required, and the scope. For this reason, leaders need to make the hard decisions of which risks they can live with and which need to be reduced because it is unrealistic to think that data security can be guaranteed. However, it is essential to have physical, administrative, and technical controls to mitigate data risks. Data protection regulations define requirements, create procedures to identify the associated risks, determine the extent of the impact, and identify what precautions should be taken. This dissertation defined seven areas for consideration related to stored data security. The research facilitated developing a measurement tool to gather and analyze the knowledge and opinions of working professionals within the United States. The study was performed from July to October 2020, which resulted in a quantitative data sample used to analyze the effectiveness of legal regulations and social consequences for securing data

Scenario-based design and evaluation for capability

Scenarios are frequently used within techniques for planning and designing systems. They are an especially helpful means of visualizing and understanding the incorporation of new systems within systems of systems. If used as the basis for decisions about candidate designs, then it is important that such decisions can be rationalized and quantitative assessment is particularly important. In this paper, an approach for developing complex scenarios, which incorporates the phases of systems development and deployment, is presented and a quantitative method of comparison is described. This approach is based on the development of measures of merit and measures of performance. The techniques are illustrated using cases that are relevant to Network Enabled Capability

Quantitative Analysis of Marine Transportation Systems Resiliency

The United States Marine Transportation System (MTS) makes large contributions to the nation’s economy, security, safety, and quality of life. Strategic investment, planning, administrative and operational decisions by government at all levels are necessary to maintain the marine transportation system performance at all times, which in turn requires a technical approach and professional leadership based on research. This study describes the approach and results of an ongoing research effort to assess the resiliency of port operations following major disasters and other disruptive events. The work presented in this research uses a set of archival data from the United States Coast Guard’s Nationwide Automatic Identification System (NAIS) to quantify the state of resiliency by investigating the operation of coastal navigation systems before, during and after disruptive events. To illustrate the ability of proposed methodology to assess the resiliency of a marine transportation system, two case studies representing two different types of infrastructure disruption are presented. The first case study involves the disruption that resulted from a collision in March 2014 in Texas in the Houston Ship Channel as a no-notice event. The second was a disruption caused by Superstorm Sandy in 2012 on the greater Port of New York/New Jersey as a pre-notice event. The results of this study revealed the importance of AIS data as a source of quantitative data when seeking post-disaster measures of resiliency. From an application viewpoint, the methods and results presented herein can be adapted and implemented to quantitatively evaluate the amount of port specific service loss and the levels of port activity following disruptive events

LOAN LOSSES PROVISIONING PROCESSES IN ROMANIAN BANKS DURING JANUARY 2007 – FEBRUARY 2011

The paper presents the loan loss provisioning phenomenon at the level of Romanianbanks, based on a very detailed set of rules in the area. Using data collected by National Bank ofRomania, we find evidence of the significantly increase in the banking loan loss provisions in the lastanalyzed years. We investigate the dynamics of the loan losses provisioning processes and present thenational regulatory framework. The paper concludes that the actual situation in the field forceRomanian banks to react and improve their risk management.Loan Loss Provisions, Loan Classification in Romanian Banking System, Provision Coefficient

An Approach for the Assessment of System Upset Resilience

This report describes an approach for the assessment of upset resilience that is applicable to systems in general, including safety-critical, real-time systems. For this work, resilience is defined as the ability to preserve and restore service availability and integrity under stated conditions of configuration, functional inputs and environmental conditions. To enable a quantitative approach, we define novel system service degradation metrics and propose a new mathematical definition of resilience. These behavioral-level metrics are based on the fundamental service classification criteria of correctness, detectability, symmetry and persistence. This approach consists of a Monte-Carlo-based stimulus injection experiment, on a physical implementation or an error-propagation model of a system, to generate a system response set that can be characterized in terms of dimensional error metrics and integrated to form an overall measure of resilience. We expect this approach to be helpful in gaining insight into the error containment and repair capabilities of systems for a wide range of conditions