available = true
allChanges = true
If any source is not periodical
available = CheckAvailabilityW(Log)
available = CheckAvailabilityW & available
If Now – LastTimeRefreshed < ST
allChanges = false
If availabile = true & allChanges = true
Repeat
v1 = firstChangeAfter(updatedTo, Log1)
v2 = firstChangeAfter(updatedTo, Log2)
If TT(v1) > M
i-1
|| TT(v2) > M
i-1
result = integrate(v1, v2)
updatedTo = min(TT(v1), TT(v2))
while v1 <> null && v2 <> null
6 CONCLUSIONS
In this paper we have presented our work related to
algorithms for processing information integration
requirements using temporal properties of data
sources. Data from different data sources are
integrated according to the requirements of the DW
Administrator. It is very useful to have algorithms
which stated whether it is possible to integrate data
from two data sources (with their respective data
extraction methods associated), being based on the
temporal properties of the data in the data sources
and their extraction methods. How two or more data
from different sources (for example, changing the
formats of the data to adapt them to the DW data
model) may be integrated is a later stage. What it is
decided whether it is possible to integrate data from
different sources with different temporal properties.
The next step in our research will be to apply it not
only to the data temporal properties, but also to
include spatial properties. In sum, to integrate
spatio-temporal properties of data in DW.
This work has been supported by the Spanish
Research Program PRONTIN under project
TIN2005-09098-C05-03.
REFERENCES
Araque, F. & Samos, J. (2003). Data warehouse
refreshment maintaining temporal consistency. 5th
Intern. Conference on Enterprise Information Systems,
ICEIS´03.Angers. France.
Araque, F. (2002). Data Warehousing with regard to
temporal characteristics of the data source. IADIS
WWW/Internet Conference. Lisbon, Portugal.
Araque, F. (2003a). Real-time Data Warehousing with
Temporal Requirements. Decision Systems
Engineering, DSE'03 (in conjunction with the
CAISE'03 conference). Klagenfurt/Velden, Austria.
Araque, F. (2003b). Integrating heterogeneous data
sources with temporal constraints using wrappers. The
15th Conference On Advanced Information Systems
Engineering. Caise Forum. Klagenfurt, Austria.
Araque, F., Salguero, A., and Abad, M.M. 2006.
Application of data warehouse and Decision Support
System in Soaring site recommendation. Proc.
Information and Communication Technologies in
Tourism, ENTER 2006. Springer Verlag, 18-20
January. Lausanne, Switzerland.
Bruckner, Robert M. and Tjoa, A M. Capturing Delays
and Valid Times in Data Warehouses - Towards
Timely Consistent Analyses. Journal of Intelligent
Information Systems (JIIS), Vol. 19(2), pp. 169-190,
Kluwer Academic Publishers, September 2002.
Castellanos, M. Semiautomatic Semantic Enrichment for
the Integrated Access in Interoperable Databases. PhD
thesis, Dept. Lenguajes y Sistemas Informáticos,
Universidad Politécnica de Cataluña, Barcelona
(SPAIN), June 1993.
Chaudhuri, S., & Dayal, U. (1997). OLAP technology and
data warehousing, ACM SIGMOD Records, Hewlett-
Packard .
Devlin, Barry. (1997). Data warehouse: from architecture
to implementation. Addison Wesley , c1997.
Haller, M., Pröll, B. , Retschitzegger, W., Tjoa, A. M., &
Wagner, R. R. (2000). Integrating Heterogeneous
Tourism Information in TIScover - The MIRO-Web
Approach. Proceedings Information and
Communication Technologies in Tourism, Springer
Verlag, ENTER 2000. Barcelona.
Hammer, J., García-Molina, H., Widom, J., Labio, W., &
Zhuge, Y. (1995). The Stanford Data Warehousing
Project. IEEE Data Engineering Bulletin.
Harinarayan, V., Rajaraman, A., & Ullman, J. (1996).
Implementing Data Cubes Efficiently. Proc. of ACM
SIGMOD Conference. Montreal.
Haas L., Kossman D., Wimmers E., Yang J.: "Optimizing
Queries across Diverse Data Sources", 23rd Very
Large Data Bases, August 1998, Athens, Greece.
Inmon W.H. (2002). Building the Data Warehouse. John
Wiley.
Oliva, M., and Saltor, F. Integrating Multilevel Security
Policies in Multilevel Federated Database Systems. In
B. Thuraisingham, R. van de Riet, K.R. Dittrich, and
Z. Tari, editors, Data and Applications Security:
Developments and Directions, pages 135–147. Kluwer
Academic Publishers, Boston, 2001.
Moura Pires, J., Pantoquilho, M., & Viana, N. (2004).
Real-Time Decision Support System for Space
Missions Control. Int. Conference on Information and
Knowledge Engineering, Las Vegas, USA.
ALGORITHMS FOR INTEGRATING TEMPORAL PROPERTIES OF DATA IN DATA WAREHOUSING
199