Extract, transform and load (ETL) is a process that makes it possible to extract data from operational data sources, to transform data in the way needed for data warehousing purposes and to load data into a data warehouse (DW). ETL process is the most important part when building the data warehouse. Because the ETL process is a very complex and time consuming, this paper presents a prototype of...

This paper focuses on the challenges faced when building a data warehouse dealing primarily with scientific or engineering data. Successfully applying data warehousing concepts to an engineering-specific database poses some challenges which vary from the usual textbook examples. This, coupled with the introduction of a new database technology (data warehouse), into a large organization with a m...

Data warehouse refreshment is often viewed as a problem of maintaining materialized views over operational sources. In this paper, we show that the data warehouse refreshment process is a complex process comprising several tasks, e.g., monitoring, extracting, transforming, integrating and cleaning operational data, deriving new data, building histories and loading the data warehouse. We propose...

becoming the standard in the life sciences industry rather than the exception. Most facilities are designed to serve more than one purpose. While housing a manufacturing area may be a building’s most important function, it may include a group of labs or warehousing space. These multi-purpose facilities create an interesting challenge. This article examines these challenges and potential solutio...

Building warehouses from existing data sources is one of the main challenges of future information systems. Over the last three years, we defined and experienced an infrastructure called Jaguar (model, language, architecture, and prototype SMIL/JMF) to configure presentations warehouse(s) managers. Such managers provide means to play and query multimedia presentations stored in a warehouse. Thi...

Data warehousing has drawn attention as a useful approach to integrate heterogeneous data sources. Since most of data warehouses have been developed based on the relational database technology, however, difficulties are encountered, when we integrate multimedia data sources, which need a flexible data model and a content-based query language. In this paper, we study a framework for multimedia d...

introduction: cleaner productions in textile industry is achieved by reducing water and chemicals’ consumption, saving energy, reducing production of air pollution and solid wastes, reducing toxicity and noise pollution through many solutions. the purpose of the present research was to apply strengths, weaknesses, opportunities, threats (swot) and quality systems planning matrix (qspm) techniqu...

Traditional enterprise data warehouse, an integral part of decision support systems (DSS), provides a variety of granularity data to satisfy requirements of different users. It is estimated that about 80% of the information stored in data warehouse is geo-spatial related. However, traditional data warehouse cannot efficiently process spatial data. With the increasing amount of spatial data stor...