Automatic Data Restructuring

Data restructuring is often an integral but non-trivial part of information processing, especially when the data structures are fairly complicated. This paper describes the underpinnings of a program, called the Restructurer, that relieves the user of the \thinking and coding" process normally associated with writing procedural programs for data restructuring. The process is accomplished by the Restructurer in two stages. In the rst, the di erences in the input and output data structures are recognized and the applicability of various transformation rules analyzed. The result is a plan for mapping the speci ed input to the desired output. In the second stage, the plan is executed using embedded knowledge about both the target language and run-time e ciency considerations. The emphasis of this paper is on the planning stage. The restructuring operations and the mapping strategies are informally described and explained with mathematical formalism. The notion of solution of a set of instantiated forms with respect to an output form is then introduced. Finally, it is shown that such a solution exists if and only if the Restructurer produces one.

[1]  Vincent Y. Lum,et al.  CONVERT: a high level translation definition language for data conversion , 1975, CACM.

[2]  Vincent Y. Lum,et al.  EXPRESS: a data EXtraction, Processing, and Restructuring System , 1977, TODS.

[3]  Nan C. Shu Formal: A Forms-Oriented, Visual-Directed Application Development System , 1985, Computer.

[4]  Richard Hull,et al.  A Survey of Theoretical Research on Typed Complex Database Objects , 1988, XP7.52 Workshop on Database Theory.

[5]  Serge Abiteboul,et al.  Restructuring Hierarchical Database Objects , 1988, Theor. Comput. Sci..

[6]  Nan C. Shu Automatic data transformation and restructuring , 1987, 1987 IEEE Third International Conference on Data Engineering.

[7]  S. B. Yao,et al.  Form operation by example: a language for office information processing , 1981, SIGMOD '81.

[8]  F KorthHenry,et al.  SQL/NF: a query language for 1NF relational databases , 1987 .

[9]  Peter Dadam,et al.  A DBMS prototype to support extended NF2 relations: an integrated view on flat tables and hierarchies , 1986, SIGMOD '86.

[10]  Henry F. Korth,et al.  The design of ¬ 1NF relational databases into nested normal form , 1987, SIGMOD '87.

[11]  Hiroyuki Kitagawa,et al.  Form document management system SPECDOQ its architecture and implementation , 1984, COCS '84.

[12]  Jeffrey D. Ullman,et al.  Principles of database and knowledge-base systems, Vol. I , 1988 .

[13]  Latha S. Colby A recursive algebra and query optimization for nested relations , 1989, SIGMOD '89.

[14]  Margaret M. Burnett,et al.  Visual Programming , 1995 .

[15]  Hiroyuki Kitagawa,et al.  Design and Implementation of a Form Management System APAD Using ADABAS/INQ DBMS , 1981 .

[16]  Peter Buneman,et al.  Types and persistence in database programming languages , 1987, CSUR.

[17]  James P. Fry,et al.  Operational software for restructuring network databases , 1977, AFIPS '77.

[18]  N.C. Shu A visual programming language designed for automatic programming , 1988, [1988] Proceedings of the Twenty-First Annual Hawaii International Conference on System Sciences. Volume II: Software track.

[19]  Peter Pistor,et al.  Designing A Generalized NF2 Model with an SQL-Type Language Interface , 1986, VLDB.

[20]  Hans-Jörg Schek,et al.  Remarks on the algebra of non first normal form relations , 1982, PODS.

[21]  Serge Abiteboul,et al.  Non first normal form relations to represent hierarchically organized data , 1984, PODS.

[22]  Jianwen Su,et al.  On the expressive power of database queries with intermediate types , 1988, PODS '88.

[23]  Shamkant B. Navathe,et al.  Restructuring for large databases: three levels of abstraction , 1975, TODS.

[24]  Serge Abiteboul,et al.  Non First Normal Form Relations: An Algebra Allowing Data Restructuring , 1986, J. Comput. Syst. Sci..

[25]  Abraham Silberschatz,et al.  Extended algebra and calculus for nested relational databases , 1988, TODS.

[26]  James C. Wetherbe,et al.  Approaches to End-User Computing: Service May Spell Success , 1986 .

[27]  Jeffrey D. Uuman Principles of database and knowledge- base systems , 1989 .

[28]  Rangasami L. Kashyap,et al.  A Visual Query Language for Graphical Interaction with Schema-Intensive Databases , 1993, IEEE Trans. Knowl. Data Eng..

[29]  Shi-Kuo Chang A Visual Language Compiler for Information Retrieval by Visual Reasoning , 1990, IEEE Trans. Software Eng..

[30]  Dirk Van Gucht,et al.  An Implementation for Nested Relational Databases , 1988, VLDB.