Plugging Files in Database Federations

Uwe Hohenstein, Andreas Ebert

Abstract


In order to use files in database federations, we propose to migrate file data into a relational database. Integrating the database in a federation is then well-understood. This procedure has the advantage that a "real" database is handled supporting transactions and SQL; files obtain a high-level interface for free. This paper presents a specification-based approach to support the process of migrating file data into a relational database, and vice versa. A specification language provides powerful concepts to describe the contents of files and directories. In contrast to similar work, directory structures are taken into account, because they contain useful semantics. Given some descriptive specification of file contents, an adapter is generated moving data from several files into the database, and the other way round.

Keywords


database; federation; SQL; HCI

Full Text:

PDF


DOI: http://dx.doi.org/10.3127/ajis.v8i1.261

Creative Commons License
This work is licensed under a Creative Commons Attribution-NonCommercial 4.0 International License.

Creative Commons License
ISSN: Online: 1326-2238 Hard copy: 1449-8618
This work is licensed under a Creative Commons Attribution-NonCommercial Licence. Uses the Open Journal Systems. Web design by TomW.