A logical view of structured files

Serge Abiteboul, Sophie Cluet, Tova Milo

Research output: Contribution to journalArticlepeer-review

14 Scopus citations

Abstract

Structured data stored in files can benefit from standard database technology. In particular, we show here how such data can be queried and updated using declarative database languages. We introduce the notion of structuring schema, which consists of a grammar annotated with database programs. Based on a structuring schema, a file can be viewed as a database structure, queried and updated as such. For queries, we show that almost standard database optimization techniques can be used to answer queries without having to construct the entire database. For updates, we study in depth the propagation to the file of an update specified on the database view of this file. The problem is not feasible in general and we present a number of negative results. The positive results consist of techniques that allow to propagate updates efficiently under some reasonable locality conditions on the structuring schemas.

Original languageEnglish
Pages (from-to)96-114
Number of pages19
JournalVLDB Journal
Volume7
Issue number2
DOIs
StatePublished - May 1998

Keywords

  • Database
  • File system
  • Query
  • Query and update optimization
  • Textual data
  • Update

Fingerprint

Dive into the research topics of 'A logical view of structured files'. Together they form a unique fingerprint.

Cite this