Data Warehouse Refreshment

2011 ◽  
pp. 111-135 ◽  
Author(s):  
Alkis Simitsis ◽  
Panos Vassiliadis ◽  
Spiros Skiadopoulos ◽  
Timos Sellis

In the early stages of a data warehouse project, the designers/administrators have to come up with a decision concerning the design and deployment of the back-stage architecture. The possible options are (a) the usage of a commercial ETL tool, or (b) the development of an in-house ETL prototype. Both cases have advantages and disadvantages. However, in both cases the design and modeling of the ETL workflows have the same characteristics. The scope of this chapter is to indicate the main challenges, issues, and problems concerning the manufacturing of ETL workflows, in order to assist the designers/administrators to decide which solution suits better to their data warehouse project and to help them construct an efficient, robust and evolvable ETL workflow that implements the refreshment of their warehouse.

2008 ◽  
pp. 3049-3066 ◽  
Author(s):  
Alkis Simitsis ◽  
Panos Vassiliadis ◽  
Spiros Skiadopoulos ◽  
Timos Sellis

In the early stages of a data warehouse project, the designers/administrators have to come up with a decision concerning the design and deployment of the back-stage architecture. The possible options are (a) the usage of a commercial ETL tool, or (b) the development of an in-house ETL prototype. Both cases have advantages and disadvantages. However, in both cases the design and modeling of the ETL workflows have the same characteristics. The scope of this chapter is to indicate the main challenges, issues, and problems concerning the manufacturing of ETL workflows, in order to assist the designers/administrators to decide which solution suits better to their data warehouse project and to help them construct an efficient, robust and evolvable ETL workflow that implements the refreshment of their warehouse.


Proceedings ◽  
2018 ◽  
Vol 2 (24) ◽  
pp. 1422 ◽  
Author(s):  
Hamza El Guili ◽  
Driss Ferhane

Business growth is considered as one of the main topics of entrepreneurship research. Due to the increased interest on entrepreneurship, new theoretical perspectives have emerged to explain entrepreneurial behavior. One of these emergent theories is effectuation. It is widely known that entrepreneurs and owner-managers count on different decision-making logics during the internationalization of their ventures, including causal and effectual reasoning. Despite that the use of effectual reasoning has been generally linked to the early stages of the creation of a venture; it has recently been introduced to on the internationalization of SMEs research. Introduced by Sarasvathy (2001), effectuation logic is stated to grow in an unstable operating context where it is complicated to predict and in contrast, it is likely to unexpectedly respond to changes in the environment. Furthermore, it represents a typical shift in approaching entrepreneurship. In this theoretical paper, we first aim to highlight the evolution of the concept and the development of the effectuation theory within the literature. Furthermore, we explain the similarities and differences existing between causation and effectuation reasoning. Finally, we use the lens of effectuation to come up with an understanding of the internationalization of SMEs.


2021 ◽  
Vol 28 (1) ◽  
pp. 15-25
Author(s):  
Damaji Ratmono

Preservation of library materials or library collections is an effort made so that library materials can be used by future generations. This paper describes the "Malaysian" binding method used by the Sub Division of Technical Binding Materials of the National Library of Indonesia in preserving the collection of periodicals such as tabloids and newspapers. Apart from that, this paper also describes some of the advantages and disadvantages seen in the use of the "Malaysian" method as well as the early history of using this method in preserving the collection of periodicals in the National Library of Indonesia. This writing aims to make readers, especially library managers, know and gain insight into the "Malaysian" binding method. This writing method is through descriptive research with a qualitative approach. Methods of data collection are carried out through the field research, interviews, and literature study. The results show that the National Library of Indonesia uses this method after studying it from Malaysia in May 1990. From observations it is also known that this method has several advantages, namely the binding result is stronger, the collection is more preserved, the binding can be assembled and has an aesthetic side. Meanwhile, the disadvantages of this binding method are that the process tends to be longer, more expensive, cannot be put on too many shelves because the collection will shift backwards, the pages tend to come off easily if the stitches are not strong enough, and can only be used in binding periodical collections.


2019 ◽  
Vol 14 (4) ◽  
pp. 749-763
Author(s):  
B. Longwe ◽  
M. Mganga ◽  
N. Sinyiza

Abstract Water Mission's extensive experience in designing, constructing and supporting solar-powered pumping solutions demonstrates the technological viability and cost effectiveness for delivering safe water to people, particularly in rural areas. Water Mission follows a unique design approach that uses conventional but relatively unique engineering specifications in terms of hydraulics, power requirement, water treatment and distribution, having tested them in different geographical environments. Water Mission incorporates a community-managed sustainability model into the design to ensure a longer life span for the project by promoting a well-defined maintenance and sustainability plan. This approach was applied to ten projects in 2015 in Kasungu, Lilongwe and Blantyre districts where installation, monitoring and evaluation were done and subjected to Water Mission's standards for qualification to hand them over to the beneficiary communities at the end of one year post installation. The paper is a review and discussion of the steps that Water Mission follows in its design process to come up with a sustainable project with solar energy. The paper also illustrates the non-compromise stand by Water Mission when it comes to the hand-over criteria for its projects by following and respecting the results of the prescribed evaluation test. It highlights detailed advantages and disadvantages of the design approach and presents recommendations. It is concluded that the approach can be replicated elsewhere in Malawi as a solution to water supply.


Author(s):  
Asad Azemi ◽  
Ivan Esparragoza

This paper presents a new approach for teaching engineering design methodology that consists of covering different steps of the design process in four semesters focusing on a specific problem. During the first semester students are introduced to the overall design methodology and are asked to identify the needs, tasks and outputs, based on a given problem statement. During the second semester students are asked to come up with a conceptual design and modify the inputs, tasks and outputs. During the third semester students are asked to come up with a working preliminary design solution and obtain some output data. And during the fourth semester students are asked to modify their design, based on their results from the previous semesters and the problem requirements, and come up with the final detailed design. Each part requires a separate report, with the results from the first three being referenced in the final report. At this time due to several considerations, including limited resources, we are only targeting engineering honors students and using robotics related problems for the multi-year design projects. The four-semester long project will be the "honors option" for the courses that engineering honor students must take during the first two years at our campus. A detailed description of this approach, including advantages and disadvantages, future directions and recommendations, are included.


2008 ◽  
Vol 1 (3) ◽  
pp. 325-336 ◽  
Author(s):  
Yixin Zhong

PurposeResearch of artificial intelligence (AI), has aimed at making machines intelligent via the simulation of natural intelligence, particularly human intelligence. During the past decades, there have been three major approaches aimed at achieving this goal, namely structuralism, functionalism and behaviorism. Unfortunately, they work separately and contradictorily to a large extent. The purpose of this paper is to present a better and more unified approach.Design/methodology/approachThe paper analyses each of the three major approaches to AI, describing their advantages and disadvantages. There then follows an attempt to explore a new and more reasonable approach to AI. The new approach should be able to solve all the problems that the existing approaches can solve on one hand and can solve the problems that the existing approaches cannot solve on the other hand.FindingsIt was found that the more reasonable and more powerful approach is the one that directly touches the common and core mechanism of intelligence formation. This is due to the fact that the mechanism of intelligence formation is much more essential than other windows of an intelligent system, such as structure, function, or behavior. It was also found that the common and core mechanism of intelligence formation can be implemented through the information‐knowledge‐intelligence transformation. The third finding is that the three existing approaches are special cases of the mechanism approach under different conditions and can thus be harmoniously unified within the frame of the mechanism approach.Originality/valueThe three findings in the paper: the mechanism approach, the implementation of the mechanism approach, and the unification of the existed three major approaches, are important laws never found before in the literature. The breakthrough of the mechanism approach to AI will be of great significance to both theoretical and practical research in AI in the years to come.


2021 ◽  
Author(s):  
Jayesh Parmar

Diagramming languages are heavily used in design and system analysis. Different languages have varying impacts on the effectiveness of designers. The author believes that there is no appropriate diagramming tool that is of substantial benefit to designers, especially in the early, pre-geometry stages of product development. A new tool, design schematics (DS), is introduced to fulfill this need. The general benefits of diagramming are outlined and the potential of diagramming tools is explored. Advantages and disadvantages of some existing diagramming methods are discussed. Analysis of diagramming methods motivates the development of DS. DS is consistent with the generic design process developed by Salustri. Several interrelated examples demonstrate how DS can capture important information during design stages. A detailed example of a coffee maker is carried out. It is executed as if the author were actually designing a coffee maker. Interrelated diagrams of the design highlight how DS helps in designing during the early stages. Computer support for development and full exploitation of DS is needed. The author believes that DS can be of great benefit to practising engineers. While there is not yet any quantitative data by which DS can be evaluated, there is anecdotal evidence suggesting that the tool has potential to be of benefit in design areas.


2021 ◽  
Author(s):  
Jayesh Parmar

Diagramming languages are heavily used in design and system analysis. Different languages have varying impacts on the effectiveness of designers. The author believes that there is no appropriate diagramming tool that is of substantial benefit to designers, especially in the early, pre-geometry stages of product development. A new tool, design schematics (DS), is introduced to fulfill this need. The general benefits of diagramming are outlined and the potential of diagramming tools is explored. Advantages and disadvantages of some existing diagramming methods are discussed. Analysis of diagramming methods motivates the development of DS. DS is consistent with the generic design process developed by Salustri. Several interrelated examples demonstrate how DS can capture important information during design stages. A detailed example of a coffee maker is carried out. It is executed as if the author were actually designing a coffee maker. Interrelated diagrams of the design highlight how DS helps in designing during the early stages. Computer support for development and full exploitation of DS is needed. The author believes that DS can be of great benefit to practising engineers. While there is not yet any quantitative data by which DS can be evaluated, there is anecdotal evidence suggesting that the tool has potential to be of benefit in design areas.


1984 ◽  
Vol 36 (1) ◽  
pp. 157-165 ◽  
Author(s):  
M. J. Morgan

This exciting and original book describes the work of David Marr and his colleagues at MIT on the computational theory of vision, particularly the early stages of shape analysis. Although much of the theorising is frankly speculative and not certain to survive without major modification, it sets new standards of rigour in its formal approach and is certain to have a stimulating effect upon the field. Sadly, Marr's death from leukaemia at the age of 35 means that he will not himself be able to take part in the further development of his ideas, but the book itself will exert an important influence for some time to come. The first point to make, for those who may already have attempted Marr's lengthy and difficult research papers, is that the book is clearly and entertainingly written: It can be tackled by the non-specialist who wishes to see why Marr's work has caused such interest in the vision community. Despite the very difficult circumstances in which the book must have been written, it is carefully put together and gives a fascinating insight into the way in which the author's ideas developed.


Author(s):  
Anthony Scime

Data warehouses are constructed to provide valuable and current information for decision-making. Typically this information is derived from the organization’s functional databases. The data warehouse is then providing a consolidated, convenient source of data for the decision-maker. However, the available organizational information may not be sufficient to come to a decision. Information external to the organization is also often necessary for management to arrive at strategic decisions. Such external information may be available on the World Wide Web; and when added to the data warehouse extends decision-making power. The Web can be considered as a large repository of data. This data is on the whole unstructured and must be gathered and extracted to be made into something valuable for the organizational decision maker. To gather this data and place it into the organization’s data warehouse requires an understanding of the data warehouse metadata and the use of Web mining techniques (Laware, 2005). Typically when conducting a search on the Web, a user initiates the search by using a search engine to find documents that refer to the desired subject. This requires the user to define the domain of interest as a keyword or a collection of keywords that can be processed by the search engine. The searcher may not know how to break the domain down, thus limiting the search to the domain name. However, even given the ability to break down the domain and conduct a search, the search results have two significant problems. One, Web searches return information about a very large number of documents. Two, much of the returned information may be marginally relevant or completely irrelevant to the domain. The decision maker may not have time to sift through results to find the meaningful information. A data warehouse that has already found domain relevant Web pages can relieve the decision maker from having to decide on search keywords and having to determine the relevant documents from those found in a search. Such a data warehouse requires previously conducted searches to add Web information.


Sign in / Sign up

Export Citation Format

Share Document