Automatic migration of files into relational databases
Authors: 
Uwe Hohenstein and Andreas EbertAuthors Info & Claims
Uwe Hohenstein and Andreas EbertAuthors Info & ClaimsNovember 1999
Pages 17 - 21
Abstract
In order to provide database-like features for files, particularly for searching in Web data, one solution is to migrate file data into a relational database. Having stored the data, the capabilities of SQL can be used for querying, provided, the data has been given some structure. To this end, an adapter must be implemented that converts data from files into the database. This paper proposes a specification-based automation for this procedure: Given some descriptive specification of file contents, those file adapters are generated. An adequate specification language provides powerful concepts to describe the contents of files. In contrast to similar work, directory structures are taken into account because they often contain useful semantics.
References
[1]
S. Abiteboul: Querying Semi-Structured Data. In {12}]]
[2]
S. Abiteboul, S. Cluet, T. Milo: Querying and Updating the File. In Proc. Conf. on Very Large Databases (VLDB) 1993]]
[3]
S. Abiteboul, R. Goldman, J. McHugh, V. Vassalos, Y. Zhuge: Views for Semistructured Data. In: {4}]]
[4]
ACM SIGMOD: Workshop on Management of Semistructured Data. Tucson (Arizona) 1997. Superseded by ACM SIGMOD Record 26(4), Dec. 1997]]
[5]
N. Ashish, C. Knoblock: Wrapper Generation for Semi-structured Internet Sources. In {4}]]
[6]
P. Buneman, S. Davidson, G. Hillebrand, D. Suciu: A Query Language and Optimisation Techniques for Unstructured Data. ACM SIGMOD Conf. on Management of Data, Montreal 1996]]
[7]
P. Buneman, S. Davidson, M. Fernandez, D. $uciu: Adding Structure to Unstructured Data. In { 12}]]
[8]
R. Cattell (ed.): The Object Database Standard: ODMG2.0. 2nd edition, Morgan-Kaufmann Publishers, San Mateo (CA) 1997]]
[9]
J. Hammer, H. Garcia-Molina, J. Cho, R. Aranha, A. Crespo: Extracting Semistructured Information from the Web. In {4}]]
[10]
U. Hohenstein, C. K6rner: A Graphical Tool for Specifying Semantic Enrichment of Relational Databases. In: 6th IFIP Conf. on Data Semantics (DS-6) "Database Applications Semantics", Atlanta 1995]]
[11]
U. Hohenstein, V. Pleller: A Generative Approach to Database Federation. 16th Int. Conf. on Conceptual Modeling - ER'97, Los Angeles 1997, Springer LNCS 1331]]
[12]
ICDT97: Int. Conf. on Database Theory, Delphi 1997]]
[13]
IEEE95: Legacy Systems. Special Issue of IEEE Software 12(1), 1995]]
[14]
V. Kashyap, M. Rusinkiewicz: Modeling and Querying Textual Data using E-R models and SQL. In: {4}]]
[15]
T. Kirk, A. Levy, Y. Sagiv, D. Srivastava: The Information Manifold. In Proc. of the AAAI Spring $ymp. Series, March 1995]]
[16]
D. Konopnicki, O. Shmueli: W3QS: A Query System for the World Wide Web. In 2 Ist int. Conf. on Very Large Databases (VLDB95), Zurich 1995]]
[17]
N. Kushmerick, D. Weld, R. Doorenbos: Wrapper Induction for Information Extraction. In Int. Joint Conf. on Artificial Intelligence, Nagoya (Japan) 1997]]
[18]
L. Lakshamanan, F. Sadri, I. Subramanian: A Declarative Language for Querying and Restructuring the Web. 6th Int. Workshop on Research Issues in Data Engineering (RIDE96), New Orleans 1996]]
[19]
A. Levy, A. Rajaraman, J. Ordille: Heterogeneous Information Sources Using Source Descriptions. In 22nd Int. Conf. on Very Large Databases, 1996]]
[20]
A. Mendelzon, G. Mihaila, T. Milo: Querying the World Wide Web. in Symp. on Parallel and Distributed Information Systems, Miami 1996]]
[21]
S. Nestorov, S. Abiteboul, R. Motwani: Inferring Structure in Semistructured Data. In: {4}]]
[22]
Y. Papakonstantinou, H. Garcia-Molina, J. Widom: Object Exchange Across Heterogeneous Information Sources. IEEE Conf. on Data Engineering 1995]]
[23]
W. Premerlani, M. Blaha: An Approach for Reverse Engineering of Relational DBs. CACM 37(5), 1994]]
[24]
Y.-H. Wu, Y.-H. Chen, A.L.P. Chen: Querying and Browsing the Resources in Internet. In Proc. of Int. Conf. on Distributed Systems, Software Engineering, and Database Systems, 1996]]
Index Terms
- Automatic migration of files into relational databases
Recommendations
Relational Database Migration: A Perspective
DEXA '08: Proceedings of the 19th international conference on Database and Expert Systems ApplicationsThis paper presents an investigation into approaches and techniques used for database conversion. Constructing object views on top of a Relational DataBase (RDB), simple database integration and database migration are among these approaches. We present ...
Storing OWL ontologies in SQL3 object-relational databases
AIC'08: Proceedings of the 8th conference on Applied informatics and communicationsWhen a large amount of data is stored in OWL files, it is not efficient to maintain and query those data. The OWL syntax is based on XML, which is a meta-markup language. Thus, it is suitable for data description and data exchange, rather than for data ...
Migration of Relational Database to Document-Oriented Database: Structure Denormalization and Data Transformation
CICSYN '15: Proceedings of the 2015 7th International Conference on Computational Intelligence, Communication Systems and NetworksRelational databases remain the leading data storage technology. Nevertheless, many companies want to reduce operating expenses, to make scalable applications that use cloud computing technologies. Use of NoSQL database is one of the possible solutions, ...
Comments
Information & Contributors
Information
Published In
Copyright © 1999 ACM.
Permission to make digital or hard copies of all or part of this work for personal or classroom use is granted without fee provided that copies are not made or distributed for profit or commercial advantage and that copies bear this notice and the full citation on the first page. Copyrights for components of this work owned by others than ACM must be honored. Abstracting with credit is permitted. To copy otherwise, or republish, to post on servers or to redistribute to lists, requires prior specific permission and/or a fee. Request permissions from [email protected]
Sponsors
Publisher
Association for Computing Machinery
New York, NY, United States
Publication History
Published: 01 November 1999
Check for updates
Qualifiers
- Article
Conference
CIKM99: Conference on Information and Knowledge Management
November 2 - 6, 1999
Missouri, Kansas City, USA
Upcoming Conference
Contributors
Other Metrics
Bibliometrics & Citations
Bibliometrics
Article Metrics
- 0Total Citations
- 418Total Downloads
- Downloads (Last 12 months)14
- Downloads (Last 6 weeks)2
Other Metrics
Citations
View Options
Get Access
Login options
Check if you have access through your login credentials or your institution to get full access on this article.
Sign in