Integration is one of the most important aspects of a Data Warehouse. When data passes from the sources of the application-oriented operational environment to the Data Warehouse, possible inconsistencies and redundancies should be resolved, so that the warehouse is able to provide an integrated and reconciled view of data of the organization. We describe a novel approach to data integration and...

The problem of evolution in the ETL process is investigated. There is no good solution in spite of numerous attempts to solve this problem. A new model to provide data warehouse and ETL scenario evolution is suggested. This model unite two different models of evolution to provide more flexible solution.

Most traditional database systems exploit a record-oriented model where the attributes of a record are placed contiguously in a hard disk to achieve high performance writes. However, for read-mostly data warehouse systems, the column-oriented database has become a proper model because of its superior read performance. Today, flash memory is largely recognized as the preferred storage media for ...

Data warehouses can be defined as ‘subject-oriented’, integrated, time-varying, non-volatile collections of data that is used primarily in organizational decision making. Nowadays, data warehousing became an important strategy to integrate heterogeneous information sources in organizations, and to enable On-Line Analytic Processing (OLAP). Unfortunately, neither the accumulation, nor the storag...

Word-final /t/-deletion refers to a common phenomenon in spoken English where words such as /wEst/ “west” are pronounced as [wEs] “wes” in certain contexts. Phonological variation like this is common in naturally occurring speech. Current computational models of unsupervised word segmentation usually assume idealized input that is devoid of these kinds of variation. We extend a non-parametric m...

In this paper, a multi-driven approach to data modeling in data warehousing will be presented, which integrates three existing approaches normally used separately: goal-driven, user-driven and data-driven; and two approaches usually not used in data warehousing field: process-driven and technology-driven. Goal-driven approach produces subjects and KPI’s (Key Performance Indicators) of main busi...

The New Zealand Department of Social Welfare (DSW) has a large, well-established and successful corporate data warehouse. This warehouse first went into production in 1996. It has been continually enhanced since that time, and now services more than one government department. The hardware has been upgraded, the data quantity and sources have increased, and more vital information is being provid...