Supporting real-world activities in database management systems

Mohamed Y. Eltabakh, Walid G. Aref, Ahmed Elmagarmid, Yasin N. Silva, Mourad Ouzzani

Research output: Chapter in Book/Report/Conference proceedingConference contribution

2 Citations (Scopus)

Abstract

The cycle of processing the data in many application domains is complex and may involve real-world activities that are external to the database, e.g., wet-lab experiments, instrument readings, and manual measurements. These real-world activities may take long time to prepare for and to perform, and hence introduce inherently long time delays between the updates in the database. The presence of these long delays between the updates, along with the need for the intermediate results to be instantly available, makes supporting real-world activities in the database engine a challenging task. In this paper, we address these challenges through a system that enables users to reflect their updates immediately into the database while keeping track of the dependent and potentially invalid data items until they are re-validated. The proposed system includes: (1) semantics and syntax for interfaces through which users can express the dependencies among data items, (2) new operators to alert users when the returned query results contain potentially invalid or out-of-date data, and to enable evaluating queries on either valid data only, or both valid and potentially invalid data, and (3) mechanisms for data invalidation and revalidation. The proposed system is being realized via extensions to PostgreSQL.

Original languageEnglish
Title of host publicationProceedings - International Conference on Data Engineering
Pages808-811
Number of pages4
DOIs
Publication statusPublished - 1 Jun 2010
Externally publishedYes
Event26th IEEE International Conference on Data Engineering, ICDE 2010 - Long Beach, CA, United States
Duration: 1 Mar 20106 Mar 2010

Other

Other26th IEEE International Conference on Data Engineering, ICDE 2010
CountryUnited States
CityLong Beach, CA
Period1/3/106/3/10

Fingerprint

Time delay
Semantics
Engines
Processing
Experiments

ASJC Scopus subject areas

  • Information Systems
  • Signal Processing
  • Software

Cite this

Eltabakh, M. Y., Aref, W. G., Elmagarmid, A., Silva, Y. N., & Ouzzani, M. (2010). Supporting real-world activities in database management systems. In Proceedings - International Conference on Data Engineering (pp. 808-811). [5447842] https://doi.org/10.1109/ICDE.2010.5447842

Supporting real-world activities in database management systems. / Eltabakh, Mohamed Y.; Aref, Walid G.; Elmagarmid, Ahmed; Silva, Yasin N.; Ouzzani, Mourad.

Proceedings - International Conference on Data Engineering. 2010. p. 808-811 5447842.

Research output: Chapter in Book/Report/Conference proceedingConference contribution

Eltabakh, MY, Aref, WG, Elmagarmid, A, Silva, YN & Ouzzani, M 2010, Supporting real-world activities in database management systems. in Proceedings - International Conference on Data Engineering., 5447842, pp. 808-811, 26th IEEE International Conference on Data Engineering, ICDE 2010, Long Beach, CA, United States, 1/3/10. https://doi.org/10.1109/ICDE.2010.5447842
Eltabakh MY, Aref WG, Elmagarmid A, Silva YN, Ouzzani M. Supporting real-world activities in database management systems. In Proceedings - International Conference on Data Engineering. 2010. p. 808-811. 5447842 https://doi.org/10.1109/ICDE.2010.5447842
Eltabakh, Mohamed Y. ; Aref, Walid G. ; Elmagarmid, Ahmed ; Silva, Yasin N. ; Ouzzani, Mourad. / Supporting real-world activities in database management systems. Proceedings - International Conference on Data Engineering. 2010. pp. 808-811
@inproceedings{25410e36cab14a459a1106241aa9830f,
title = "Supporting real-world activities in database management systems",
abstract = "The cycle of processing the data in many application domains is complex and may involve real-world activities that are external to the database, e.g., wet-lab experiments, instrument readings, and manual measurements. These real-world activities may take long time to prepare for and to perform, and hence introduce inherently long time delays between the updates in the database. The presence of these long delays between the updates, along with the need for the intermediate results to be instantly available, makes supporting real-world activities in the database engine a challenging task. In this paper, we address these challenges through a system that enables users to reflect their updates immediately into the database while keeping track of the dependent and potentially invalid data items until they are re-validated. The proposed system includes: (1) semantics and syntax for interfaces through which users can express the dependencies among data items, (2) new operators to alert users when the returned query results contain potentially invalid or out-of-date data, and to enable evaluating queries on either valid data only, or both valid and potentially invalid data, and (3) mechanisms for data invalidation and revalidation. The proposed system is being realized via extensions to PostgreSQL.",
author = "Eltabakh, {Mohamed Y.} and Aref, {Walid G.} and Ahmed Elmagarmid and Silva, {Yasin N.} and Mourad Ouzzani",
year = "2010",
month = "6",
day = "1",
doi = "10.1109/ICDE.2010.5447842",
language = "English",
isbn = "9781424454440",
pages = "808--811",
booktitle = "Proceedings - International Conference on Data Engineering",

}

TY - GEN

T1 - Supporting real-world activities in database management systems

AU - Eltabakh, Mohamed Y.

AU - Aref, Walid G.

AU - Elmagarmid, Ahmed

AU - Silva, Yasin N.

AU - Ouzzani, Mourad

PY - 2010/6/1

Y1 - 2010/6/1

N2 - The cycle of processing the data in many application domains is complex and may involve real-world activities that are external to the database, e.g., wet-lab experiments, instrument readings, and manual measurements. These real-world activities may take long time to prepare for and to perform, and hence introduce inherently long time delays between the updates in the database. The presence of these long delays between the updates, along with the need for the intermediate results to be instantly available, makes supporting real-world activities in the database engine a challenging task. In this paper, we address these challenges through a system that enables users to reflect their updates immediately into the database while keeping track of the dependent and potentially invalid data items until they are re-validated. The proposed system includes: (1) semantics and syntax for interfaces through which users can express the dependencies among data items, (2) new operators to alert users when the returned query results contain potentially invalid or out-of-date data, and to enable evaluating queries on either valid data only, or both valid and potentially invalid data, and (3) mechanisms for data invalidation and revalidation. The proposed system is being realized via extensions to PostgreSQL.

AB - The cycle of processing the data in many application domains is complex and may involve real-world activities that are external to the database, e.g., wet-lab experiments, instrument readings, and manual measurements. These real-world activities may take long time to prepare for and to perform, and hence introduce inherently long time delays between the updates in the database. The presence of these long delays between the updates, along with the need for the intermediate results to be instantly available, makes supporting real-world activities in the database engine a challenging task. In this paper, we address these challenges through a system that enables users to reflect their updates immediately into the database while keeping track of the dependent and potentially invalid data items until they are re-validated. The proposed system includes: (1) semantics and syntax for interfaces through which users can express the dependencies among data items, (2) new operators to alert users when the returned query results contain potentially invalid or out-of-date data, and to enable evaluating queries on either valid data only, or both valid and potentially invalid data, and (3) mechanisms for data invalidation and revalidation. The proposed system is being realized via extensions to PostgreSQL.

UR - http://www.scopus.com/inward/record.url?scp=77952749895&partnerID=8YFLogxK

UR - http://www.scopus.com/inward/citedby.url?scp=77952749895&partnerID=8YFLogxK

U2 - 10.1109/ICDE.2010.5447842

DO - 10.1109/ICDE.2010.5447842

M3 - Conference contribution

AN - SCOPUS:77952749895

SN - 9781424454440

SP - 808

EP - 811

BT - Proceedings - International Conference on Data Engineering

ER -