Library Information Processing System: ODS Data Model
Subscribe/Renew Journal
A library system contains books, authors and users and many types of other material. For books, the location is identified by a Class Number, for author by an author's name and for users by a users' name. Author and book is a one-to-many relationship whereas library and book is a many-to-many relationship. A library can hold many copies of a book, and a book can appear in many libraries. A book and a library enter into a relationship grouping by sharing a copy. This relationship instance has a cost attribute, which states how much the library paid for the book. Patron-library and user- to- book are many-to-many relationships. When a user borrows a book, the transaction creates an instance of the patron and book relationship and attaches a due date attribute to it.
The intention of this article is to highlight the findings during our study on LIPS (Library Information Processing System) regarding the advancement of a conceptual framework for considering a fully integrated library automation system. Although due to the space we would limit the discussion to E-R model and Object Originated model, it is not asserted that what follows constitutes a complete framework, but rather an attempt to take a step towards the development of a framework. The motivation is both intellectual and pragmatic. At an intellectual level, there is curiosity about the nature of things and about how and why they work. At a pragmatic level, there is the incentive that a clearer theoretical understanding might bring about greater effectiveness in practice.
Keywords
- Alter (Steven). Information Systems: A Management Perspective. Menlo Park, CA: The Benjamin/Cummings Publishing Company, 1996, p677-681.
- Liu (Qimao); Cai, (Hongmei). Library Automation and HP3000 System. Computer Application Study. Vol. 9 (2); 1992.
- Liu (Qimao); Cai (Hongmei). The Preliminary Development and Application of HP3000 System in Our Library. HP No. 1. 1992.
- Canada, IDRC. MINISIS G.: Database Managers Guide. July 29, 1988.
- Cyril (H P Brookes); Philip (J Grouse). Information systems Design. Prentice Hall of Australia, 1984.
- Abraham. (Silberschatz); Korth (Henry F); Sudarshan (S). Database System Concepts. The McGraw Hill, New York.
- Chen (P). The entity-relationship model: Towards a unified view or data. ACM Transactions on Database Systems. Vol. 1(1); March 1976; p9-36.
- Abiteboul (S); Grumbnachi (S). COL - a logical approach to the manipulation of complex objects. In Proceedings of EDTP (LNCS). Springer Verlag, March 1985.
- Abitebourl (S); Kabellakis (P C). Object identity as a query language primitive. Research Report 1022, INRIA, France, April 1989.
- Alagic (S). Object-oriented Database Programming. Springer Verlag, 1989.
- Bancilhon (F); Khoshafian (S). A calculus for complex objects. In Proceedings of ACM PODS. 1986, p53-60.
- Hull (R); Su (J). On accessing object-oriented databases: Expresive power, complexity, and restrictions (extended abstract). In ACM SIGMOD International Conference on Management of Data. June 1989.
- Kim (W); Garza (J); Ballou (N); Woelk (D). Architecture of the ORION next-generation database system. IEEE Transactions on Knowledge a11:d Data Engineeringe. Vol. 1; March 1990; p109-124.
- Heselink. (M). A mathematical model of non-determinism in abstract data types. ACM Transactions on Programming Languages and Systems. Vol. 10(1); January 1988; p87-117.
- Majumdar (Kamalendu); Singh (U N). Integrated Library Management System: Circulation Module. SRELS Journal of Information Management. Vol. 41(1); March 2004; p91-106.
Abstract Views: 340
PDF Views: 5