article

Free access

A database design methodology and tool for information systems

Editor: Robert B. Allen Authors:

Roger King,

Dennis McLeodAuthors Info & Claims

ACM Transactions on Information Systems (TOIS), Volume 3, Issue 1

Pages 2 - 21

https://doi.org/10.1145/3864.3869

Published: 02 January 1985 Publication History

PDF eReader

Abstract

A model and methodology for describing the information objects in an office information system and how such objects flow among the components of such a system are presented. The model and methodology support the specification of information objects at multiple levels of abstraction. An interactive prototype design tool based on the methodology and model has been designed and experimentally implemented.

References

[1]

BELL, M. L., BIXLER, D. C., AND DYER, M. E. An extendible approach to computer-aided software requirements engineering. IEEE Trans. Softw. Eng. SE~3 (Jan. 1977), 40-60.

Google Scholar

[2]

BORGIDA, A., MYLOPOULOS, J., AND WONG, H. K.T. Generalization/specialization as a basis for software specification. In On Conceptual Modeling: Perspectives from Artificial Intelligence, Database, and Programming Languages, M. Brodie, J. Mylopoulos, and J. Schmidt, Eds. Springer- Verlag, New York, 1984.

Google Scholar

[3]

BRACCHI, G., AND PERNICI, B. SOS: A conceptual model for office information systems. In Proceedings of the ACM SIGMOD international Conference on the Management of Data (San Jose, Calif., May 23-26). ACM, New York, 1983, pp.

Crossref

Google Scholar

[4]

BRODI~, M.L. On modelling behavioural semantics of data. In Proceedings of the 7th International Conference on Very Large Databases (Cannes, France, Sept. 9-11). ACM, New York, 1981, pp. 32-44.

Google Scholar

[5]

BRODIE, M., AND RIDJANOVIC, D. On the design and specification of database transactions. In On Conceptual Modeling: Perspectives from Artificial Intelligence, Databases, and Programming Languages, M. Brodie, J. Mylopoulos, and J. Schmidt, Eds. Springer-Verlag, New York, 1984.

Google Scholar

[6]

BROWS, M. R., CATTELL, R. G. G., AND SUZUKI, N. The cedar DBMS: A preliminary report. In Proceedings of the ACM SIGMOD International Conference on the Management of Data (Ann Arbor, Mich., Apr. 29-May 1). ACM, New York, 1981, pp. 205-211.

Crossref

Google Scholar

[7]

BUNEMAN, P., AND FRANKEL, R.E. FQL--A functional query language. In Proceedings of the A CM SIGMOD Conference on the Management of Data (Boston, Mass., May 30-June 1). ACM, New York, 1979, pp. 52-58.

Crossref

Google Scholar

[8]

BUNEMAN P., AND NIKHIL, R. The functional data model and its use for interaction with databases. In On Conceptual Modeling: Perspectives from Artificial Intelligence, Databases, and Programming Languages, M. Brodie, J. Mylopoulos, and J. Schmidt, Eds. Springer-Verlag, New York, 1984.

Google Scholar

[9]

CATTELL, R. G. G. Design and implementation of a relationship-entity-datum data model. Tech. Rep. CSL-83-4, Xerox Parc, Palo Alto, Calif., 1983.

Google Scholar

[10]

CHEN, P. P. S. The entity-relationship model; Toward a unified view of data. ACM Trans. Database Syst. 1, 1 (Mar. 1976), 9-36.

Crossref

Google Scholar

[11]

CHEN, P.P.S. The entity-relationship approach to logical database design. Monograph number 6, QED Information Sciences, Wellesley, Mass., 1978.

Crossref

Google Scholar

[12]

CODD, E.F. Extending the database relational model. ACM Trans. Database Syst. 4, 4 (Dec. 1979), 397-434.

Crossref

Google Scholar

[13]

DAVlS, C. G., AND VICK, C.R. The software development system. IEEE Trans. Softw. Eng. SE- 3, 1 (Jan. 1977), 69-84.

Google Scholar

[14]

ELLIS, C. A., AND NUTT, G.J. Office information systems and computer science. A CM Comput. Surv. 12, 1 (Mar. 1980), 27-60.

Crossref

Google Scholar

[15]

FALKENBERG, E.D. Conceptualization of data. Infotech State-of-the-Art Report on Data Design. Pergamon Infotech Ltd., London 1980.

Google Scholar

[16]

FARMER, D., KING, R., AND MYERS, D. A tool for the implementation of databases. In Proceedings of the International Conference on Data Engineering (Los Angeles, Calif., Apr. 24- 27). IEEE Computer Society, Los Angeles, 1984, pp. 386-393.

Crossref

Google Scholar

[17]

GANE, C.P. Data design in structured system analysis. In Tutorial on Software Design Techniques, P. Freeman and A. I. Wasserman, Eds. IEEE Computer Society, Los Angeles, 1980, pp. 126-143.

Google Scholar

[18]

GIBBS, S., AND TSICHRITZlS, D. A data modeling approach for office information systems. ACM Trans. Off. Inf. Syst. 1, 4 (Oct. 1984), 299-319.

Crossref

Google Scholar

[19]

HAMMER, M., HOWE, W. G., KRUSKAL, V. J., AND WLADAWSKY, I. A very high level programming language for data processing applications. Commun. ACM 20, 11 (Nov. 1977), 832-840.

Crossref

Google Scholar

[20]

HAMMER, M., AND MCLEOD, D. Database description with SDM: A semantic database model. ACM Trans. Database Syst. 6, 3 (Sept. 1981), 351-386.

Crossref

Google Scholar

[21]

HOUSEL, B. C., WADDLE, V., AND YAO, S.B. Functional dependency model for logical database design. In Proceedings of the 5th International Conference on Very Large Databases (Rio de Janeiro, Oct. 3-5). ACM, New York, 1979, pp. 194-208.

Google Scholar

[22]

KING, R. A semantics-based methodology for database design and evolution. Tech. Rep. TRl15, Computer Science Department, Univ. of Southern California, Los Angeles, Calif., 1982.

Google Scholar

[23]

KING, R., AND MCLEOD, D. The event database specification model. In Proceedings of the 2nd International Conference on Databases: Improving Usability and Responsiveness (Jerusalem, Israel, June). 1982, pp. 299-322.

Google Scholar

[24]

KING, R., AND MCLEOD, D. Semantic database models. In Database Design, S. B. Yao, Ed. Prentice-Hall, Englewood Cliffs, N.J., to appear.

Google Scholar

[25]

KING, R., AND MCLEOD, D. A unified model and methodology for conceptual database design. In On Conceptual Modeling: Perspectives from Artificial Intelligence, Databases, and Programming Languages, M. Brodie, J. Mylopoulos, and J. Schmidt, Eds. Springer-Verlag, New York, 1984.

Google Scholar

[26]

McLeod, D., Narayanaswamy, K., and Bapa Rao, K.V. An approach to Information management for CAD/VLSI applications. In Proceedings of the ACM SIGMOD International Conference on the Management of Data (San Jose, Calif., May ). ACM, New York, 1983, pp.

Google Scholar

[27]

MCLEOD, D. AND SMITH, J.M. Abstraction in databases. In Proceedings of the Workshop on Data Abstraction, Databases, and Conceptual Modeling (Pingree Park, Colo., June). 1980.

Crossref

Google Scholar

[28]

MYLOPOULOS, J., BERNSTEIN, P. A. AND WONG, H. K.T. A language facility for designing interactive database-intensive applications. ACM Trans. Database Syst. 5, 2 (June 1980), 185-207.

Crossref

Google Scholar

[29]

ROSS, D.T. Structured Analysis (SA): A language for communicating ideas. IEEE Trans. Softw. Eng. SE-3, 1 (Jan. 1977), 16-34.

Google Scholar

[30]

SHIPMAN, D. The functional data model and the data language DAPLEX. ACM Trans. Database Syst. 6, 1 (Mar. 1981), 140-173.

Crossref

Google Scholar

[31]

SMITH, J. M., AND SMITH, D. C. P. Database abstractions: Aggregation and generalization. ACM Trans. Database Syst. 2, 2 {June 1977), 105-133.

Crossref

Google Scholar

[32]

SMITH, J. M., AND SMITH, D. C.P. Principles of conceptual database design. In Proceedings of the NYU Symposium on Database Design (New York, May). New York University, New York, 1978.

Crossref

Google Scholar

[33]

Su, S. Y. W., AND LO, D.H. A semantic association model for conceptual database design. In Proceedings of the International Conference on the Entity-Relationship Approach to Systems Analysis and Design (Los Angeles Calif., Dec. 10-12). ACM, New York, 1979, pp. 147-171.

Crossref

Google Scholar

[34]

TEICHROEW, D., AND HERSHEY, E.A. PSA/PSL: A computer-aided technique for structured documentation and analysis of information processing systems. IEEE Trans. Softw. Eng. SE-3, 1 (Jan. 1977), 41-48.

Google Scholar

[35]

TEOREY, T. J. AND FRY, J.P. The logical record access approach to database design. ACM Comput. Surv. 12, 2 (June 1980), 179-212.

Crossref

Google Scholar

Cited By

View all

Berman SSemwayo T(2007)A conceptual modeling methodology based on niches and granularityProceedings of the 26th international conference on Conceptual modeling10.5555/1784489.1784521(338-358)Online publication date: 5-Nov-2007
https://dl.acm.org/doi/10.5555/1784489.1784521
Gerede CBhattacharya KSu J(2007)Static Analysis of Business Artifact-centric Operational ModelsProceedings of the IEEE International Conference on Service-Oriented Computing and Applications10.1109/SOCA.2007.42(133-140)Online publication date: 19-Jun-2007
https://dl.acm.org/doi/10.1109/SOCA.2007.42
Chiu RLenny Koh SChang C(2007)The aggregation for enterprise distributed databasesJournal of Manufacturing Technology Management10.1108/1741038071081731818:7(889-903)Online publication date: 11-Sep-2007
https://doi.org/10.1108/17410380710817318
Show More Cited By

Index Terms

A database design methodology and tool for information systems

Recommendations

Design of partially replicated distributed database systems: an integrated methodology
SIGMETRICS '88: Proceedings of the 1988 ACM SIGMETRICS conference on Measurement and modeling of computer systems

The objective of this research is to develop and integrate tools for the design of partially replicated distributed database systems. Many existing tools are inappropriate for designing large-scale distributed databases due to their large computational ...
A database design methodology for an integrated database environment

The database design methodology used by a major US. commercial bank is described. The methodology is used for designing databases that support a large integrated real-time application. The methodology consists of four phases:• Conceptual Design• ...
A methodology for the design of courses in information systems
ACE '03: Proceedings of the fifth Australasian conference on Computing education - Volume 20

A wealth of literature exists on the use of Internet technologies for Information Systems education; however, there is little research on course design methodologies that are particularly suited to Information Systems courses. This paper reviews several ...

Reviews

Reviewer: Michael C. Harris

The paper describes INSYDE (Information Systems Designer) as a “model and methodology for constructing office information systems.” Its purpose is to translate user requirements into data and process specifications. It is based on recent developments from semantic database design, augmented with the ability to describe and specify procedures. It is “. . . oriented toward applications where the processes that manipulate information are at least partially known in advance, and not toward applications where arbitrary data manipulations may dominate predictable manipulations.” The authors go on to state: “The goal of the present paper is to provide a detailed description of the INSYDE model and the office information life cycle design tool based upon it.” They only partially succeed. The only possible reference to “life cycle” is a statement to the effect that models may be changed. The description of the model is well done and, semantically, fairly exhaustive. However, since the system is operational, actual examples might have clarified much that was simply alluded to here. A follow-up paper on “INSYDE USE” would be warranted.

Access critical reviews of Computing literature here

Become a reviewer for Computing Reviews.

Comments

Information & Contributors

Information

Published In

Publisher

Association for Computing Machinery

New York, NY, United States

Publication History

Published: 02 January 1985

Published in TOIS Volume 3, Issue 1

Permissions

Request permissions for this article.

Request Permissions

Check for updates

Qualifiers

Article

Contributors

Other Metrics

View Article Metrics

Bibliometrics & Citations

Bibliometrics

Article Metrics

29
Total Citations
View Citations
1,448
Total Downloads

Downloads (Last 12 months)67
Downloads (Last 6 weeks)14

Reflects downloads up to 21 Sep 2024

Other Metrics

View Author Metrics

Citations

Cited By

View all

Berman SSemwayo T(2007)A conceptual modeling methodology based on niches and granularityProceedings of the 26th international conference on Conceptual modeling10.5555/1784489.1784521(338-358)Online publication date: 5-Nov-2007
https://dl.acm.org/doi/10.5555/1784489.1784521
Gerede CBhattacharya KSu J(2007)Static Analysis of Business Artifact-centric Operational ModelsProceedings of the IEEE International Conference on Service-Oriented Computing and Applications10.1109/SOCA.2007.42(133-140)Online publication date: 19-Jun-2007
https://dl.acm.org/doi/10.1109/SOCA.2007.42
Chiu RLenny Koh SChang C(2007)The aggregation for enterprise distributed databasesJournal of Manufacturing Technology Management10.1108/1741038071081731818:7(889-903)Online publication date: 11-Sep-2007
https://doi.org/10.1108/17410380710817318
Berman SSemwayo T(2007)A Conceptual Modeling Methodology Based on Niches and GranularityConceptual Modeling - ER 200710.1007/978-3-540-75563-0_24(338-358)Online publication date: 2007
https://doi.org/10.1007/978-3-540-75563-0_24
Duží M(2005)Semantic information connected with dataDatabase Theory — ICDT '9210.1007/3-540-56039-4_54(376-390)Online publication date: 8-Jun-2005
https://doi.org/10.1007/3-540-56039-4_54
Tari Z(2005)On the design of object-oriented databasesEntity-Relationship Approach — ER '9210.1007/3-540-56023-8_24(389-405)Online publication date: 28-May-2005
https://doi.org/10.1007/3-540-56023-8_24
Garcia HSheng O(2005)An entity-relationship-based methodology for distributed database design: An integrated approach towards combined logical and distribution designsEntity-Relationship Approach — ER '9210.1007/3-540-56023-8_12(178-193)Online publication date: 28-May-2005
https://doi.org/10.1007/3-540-56023-8_12
Hull R(2005)Four views of complex objects: A sophisticate's introductionNested Relations and Complex Objects in Databases10.1007/3-540-51171-7_22(85-116)Online publication date: 2-Jun-2005
https://doi.org/10.1007/3-540-51171-7_22
Ngu A(1999)Specification of cooperative constraints in virtual enterprise workflowProceedings Ninth International Workshop on Research Issues on Data Engineering: Information Technology for Virtual Enterprises. RIDE-VE'9910.1109/RIDE.1999.758649(140-147)Online publication date: 1999
https://doi.org/10.1109/RIDE.1999.758649
Weigand HNgu A(1998)Flexible specification of interoperable transactionsData & Knowledge Engineering10.1016/S0169-023X(97)00021-925:3(327-345)Online publication date: 1-Apr-1998
https://dl.acm.org/doi/10.1016/S0169-023X%2897%2900021-9
Show More Cited By

View Options

View options

PDF

View or Download as a PDF file.

PDF

eReader

View online with eReader.

eReader

Get Access

Login options

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

Abstract

References

Cited By

Index Terms

Recommendations

Design of partially replicated distributed database systems: an integrated methodology

A database design methodology for an integrated database environment

A methodology for the design of courses in information systems

Reviews

Access critical reviews of Computing literature here

Comments

Information

Published In

Publisher

Publication History

Permissions

Check for updates

Qualifiers

Contributors

Other Metrics

Bibliometrics

Article Metrics

Other Metrics

Citations

Cited By

View options

PDF

eReader

Get Access

Login options

Full Access

Figures

Other

Share

Share this Publication link

Share on social media

Affiliations