article

Free access

A form-based approach for database analysis and design

Authors:

Joobin Choobineh,

Michael V. Mannino,

Veronica P. TsengAuthors Info & Claims

Communications of the ACM, Volume 35, Issue 2

Pages 108 - 120

https://doi.org/10.1145/129630.129636

Published: 01 February 1992 Publication History

PDF eReader

References

[1]

Bouzeghoubi: M., Gardarin, G., and Metais, E. :The design of an expert system for:database design. In Proceedings :of the International :Conference on Very LargeData Bases (VLDB), Stockholm, Sweden, (Aug. 1985),

Google Scholar

[2]

Chen, P. The entity-relationship model: Toward a unified view of data. ACM Trans. Database Syst. 1, 1 (Mar. 1976).

Digital Library

Google Scholar

[3]

Choobineh, J. Form-driven conceptual .data modeling. Ph.D. dissertation, Dept. of Management Information Systems, University of Arizona, 1985.

Digital Library

Google Scholar

[4]

Choobineh, J. FORMFLEX: A user interface tool for forms definition and management. In Human Factors in Manage. Inf. Syst., J. Carey, Ed., Ablex, Norwood, NJ 1988, pp. 117- i33.

Digital Library

Google Scholar

[5]

Choobineh, J., Mannino, M~, Nunamaker, J., and Konsynski, B~ An expert database design system based on analysis of forms. IEEE Trans. Softw. Eng. 14, 2 (Feb. 1988), 242-253.

Digital Library

Google Scholar

[6]

Eick, C. and Lockeman, P. Acquisition of terminological knowledge using database design techniques. In Proceedings of ACM SIGMOD Conference (Austin, Tex., May 1985), pp. 84-94.

Digital Library

Google Scholar

[7]

Embley, D. NFQL: The natural forms query language. ACM Trans. Database Syst. I4, 2 (June 1989), 168-211.

Digital Library

Google Scholar

[8]

Flach, P. Inductive characterization of database relations. Methodolog. Intell. Syst. 5, Z.W. Ras, M. Zemankova, and M. Emrich, Eds., North-Holland, Amsterdam, 1990, pp. 371-378.

Digital Library

Google Scholar

[9]

Mannila, H. and Raiha, K. Design by example: An application of Armstrong relations. J. comput. Sysr s. 33, 2 (1986), 126-141.

Digital Library

Google Scholar

[10]

Mannino, M., Choobineh, J., and Hwang, J. Acquisition and use of contextual knowledge in a formdriven database design methodology. In Proceedings of the Fifth International ConfereTkee on Entity-Relationship Approach (Dijon, France, Nov. 1986).

Google Scholar

[11]

Shu, N. Formal: A forms-oriented. visual-directed application development system. IEEE Comput. (Aug. 1985), 38-49.

Digital Library

Google Scholar

[12]

Shu, N., Lure, V., Wong, H., and Chang, C. Specification of forms processing and business procedures for office automation. IEEE Trans. Softw. Eng. SE-8, 5 (Sept. 1982), 499-511.

Digital Library

Google Scholar

[13]

Storey, V. and Goldstein, R. A methodology for creating user views in database design. ACM Trans. Database Syst. 13, 3 (Sept. 1988), 305-388.

Digital Library

Google Scholar

[14]

Think Technologies. Lightspeed Pascal: User's Guide and Reference Manual, Version 1, First ed., 1986, Lexington, Mass.

Google Scholar

[15]

Tseng, V. Inferring database requirements from examples in forms. Ph.D. dissertation, Dept. of Management Science and Information Systems, The Univ. of Texas at Austin, May 1988.

Google Scholar

[16]

Tseng, V. and Mannino, M. Inferring database requirements from examples in forms. In Proceedings of the Seventh International Conference on Entity-Relationship Approach (Rome, Italy, Nov. 1988), pp. 25 i-265.

Digital Library

Google Scholar

[17]

Tseng, V. and Mannino, M. A method for database requirements definition. J. Manage. Inf. Syst~ (Winter 1989).

Digital Library

Google Scholar

[18]

Tsichritzis, D. Form Management. Commun. ACM 25. 7 (July 1982), 453-478.

Digital Library

Google Scholar

[19]

Yao, B., Hevner, A., Zhongzhi, S., and Luo, D. FORMANAGER: An office forms management system. ACM Trans. Off. Inf. Syst. 2, 3 (July 1984), 235-262.

Digital Library

Google Scholar

Cited By

View all

(2024)BibliographyInformation Modeling and Relational Databases10.1016/B978-0-443-23790-4.09995-3(1029-1040)Online publication date: 2024
https://doi.org/10.1016/B978-0-443-23790-4.09995-3
Halpin TMorgan T(2024)Conceptual Modeling: First StepsInformation Modeling and Relational Databases10.1016/B978-0-443-23790-4.00003-7(59-110)Online publication date: 2024
https://doi.org/10.1016/B978-0-443-23790-4.00003-7
Jagadish HQian LNandi A(2015)Organic databasesInternational Journal of Computational Science and Engineering10.1504/IJCSE.2015.07265111:3(270-283)Online publication date: 1-Oct-2015
https://dl.acm.org/doi/10.1504/IJCSE.2015.072651
Show More Cited By

Index Terms

Recommendations

UML for Database Design
Design patterns for database pedagogy: a proposal

Courses in Relational Databases largely use a domain-specific design approach different from that used in the rest of the curriculum. Use of the Unified Process, UML, and Design Patterns as a pedagogical approach for Databases can leverage previous ...
Extending UML for Object-Relational Database Design
«UML» '01: Proceedings of the 4th International Conference on The Unified Modeling Language, Modeling Languages, Concepts, and Tools

The most common way of designing databases is using de E/R model without taking into account other views of the system. However, new object-oriented design languages, such as UML (Unified Modelling Language), permit modelling the full system, including ...

Reviews

Reviewer: Rajeev Kaula

An approach to systematically using electronic forms in the database requirements and design process is described. The research uses a model of hierarchically structured forms with event-driven routing to develop two systems, called the form definition system and the expert database design system. The form definition system assists users in specifying form and view definitions. The system has many components. For instance, the inference component for novice users has rules and heuristics to allow beginners to develop forms. The system has an inference component to assist end users with view definitions for their forms; a view definition consists of a form hierarchy with functional dependencies among form fields. The system also has an explanation facility. The expert database design system assists in the view integration process. The expert system contains rules for incrementally integrating the form views, and heuristics for mapping the form fields into entity types and relationships. The expert database design system uses the view definitions to incrementally build an entity relationship diag ram.

Access critical reviews of Computing literature here

Become a reviewer for Computing Reviews.

Comments

Please enable JavaScript to view thecomments powered by Disqus.

Information & Contributors

Information

Published In

Communications of the ACM Volume 35, Issue 2

Feb. 1992

124 pages

ISSN:0001-0782

EISSN:1557-7317

DOI:10.1145/129630

Editor:
Peter Denning

Issue’s Table of Contents

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]

Publisher

Association for Computing Machinery

New York, NY, United States

Publication History

Published: 01 February 1992

Published in CACM Volume 35, Issue 2

Permissions

Request permissions for this article.

Request Permissions

Check for updates

Author Tags

Qualifiers

Article

Contributors

Other Metrics

View Article Metrics

Bibliometrics & Citations

Bibliometrics

Article Metrics

44
Total Citations
View Citations
1,591
Total Downloads

Downloads (Last 12 months)250
Downloads (Last 6 weeks)42

Reflects downloads up to 21 Jan 2025

Other Metrics

View Author Metrics

Citations

Cited By

View all

(2024)BibliographyInformation Modeling and Relational Databases10.1016/B978-0-443-23790-4.09995-3(1029-1040)Online publication date: 2024
https://doi.org/10.1016/B978-0-443-23790-4.09995-3
Halpin TMorgan T(2024)Conceptual Modeling: First StepsInformation Modeling and Relational Databases10.1016/B978-0-443-23790-4.00003-7(59-110)Online publication date: 2024
https://doi.org/10.1016/B978-0-443-23790-4.00003-7
Jagadish HQian LNandi A(2015)Organic databasesInternational Journal of Computational Science and Engineering10.1504/IJCSE.2015.07265111:3(270-283)Online publication date: 1-Oct-2015
https://dl.acm.org/doi/10.1504/IJCSE.2015.072651
Cleve ANoughi NHainaut J(2013)Dynamic Program Analysis for Database Reverse EngineeringGenerative and Transformational Techniques in Software Engineering IV10.1007/978-3-642-35992-7_8(297-321)Online publication date: 2013
https://doi.org/10.1007/978-3-642-35992-7_8
Ristic SAleksic SLukovic IBanovic J(2012)Form-Driven Application DevelopmentActa Electrotechnica et Informatica10.2478/v10198-012-0002-x12:1Online publication date: 1-Jan-2012
https://doi.org/10.2478/v10198-012-0002-x
Yasir AKumara Swamy MKrishna Reddy PBhalla S(2012)Enhanced Query-By-Object Approach for Information Requirement Elicitation in Large DatabasesBig Data Analytics10.1007/978-3-642-35542-4_4(26-41)Online publication date: 2012
https://doi.org/10.1007/978-3-642-35542-4_4
An YKhare RSong IHu X(2011)Automatically mapping and integrating multiple data entry forms into a databaseProceedings of the 30th international conference on Conceptual modeling10.5555/2075144.2075171(261-274)Online publication date: 31-Oct-2011
https://dl.acm.org/doi/10.5555/2075144.2075171
Ramdoyal RCleve A(2011)From pattern-based user interfaces to conceptual schemas and backProceedings of the 30th international conference on Conceptual modeling10.5555/2075144.2075170(247-260)Online publication date: 31-Oct-2011
https://dl.acm.org/doi/10.5555/2075144.2075170
Cleve AMeurisse JHainaut J(2011)Database semantics recovery through analysis of dynamic SQL statementsJournal on data semantics XV10.5555/2028156.2028162(130-157)Online publication date: 1-Jan-2011
https://dl.acm.org/doi/10.5555/2028156.2028162
Kop CMayr H(2011)Templates in domain modeling - a surveyThe evolution of conceptual modeling10.5555/1985703.1985706(21-41)Online publication date: 1-Jan-2011
https://dl.acm.org/doi/10.5555/1985703.1985706
Show More Cited By

View Options

View options

PDF

View or Download as a PDF file.

PDF

eReader

View online with eReader.

eReader

Login options

Check if you have access through your login credentials or your institution to get full access on this article.

References

Cited By

Index Terms

Recommendations

UML for Database Design

Design patterns for database pedagogy: a proposal

Extending UML for Object-Relational Database Design

Reviews

Access critical reviews of Computing literature here

Comments

Information

Published In

Publisher

Publication History

Permissions

Check for updates

Author Tags

Qualifiers

Contributors

Other Metrics

Bibliometrics

Article Metrics

Other Metrics

Citations

Cited By

View options

PDF

eReader

Login options

Full Access

Figures

Other

Share

Share this Publication link

Share on social media

Affiliations