Search results

The five principal management objectives of database management systems are discussed, as are the four basic criteria for comparing systems. Database management systems organized along hierarchies and networks are illustrated and compared to relational database systems, which are also illustrated. Backend processors, emphasizing database machines, are described as important means of improving database management system performance and of exploiting the potential of relational databases in particular.

Database management systems for microcomputers are described, including the basic features of database management systems and factors which should be considered in selecting a microcomputer system. A method for ranking database management systems is explained and applied to a defined need, i.e., software support for indexing a weekly newspaper.

Relatively little microcomputer software has been designed specifically for the storage and retrieval of bibliographic data. Information retrieval packages for mainframes and minicomputers have been scaled down to run on microcomputers, however, these programs are expensive, unwieldy, and inflexible. For this reason, microcomputer database management systems (DBMS) are often used as an alternative. In this article, criteria for evaluating DBMS used for the storage and retrieval of bibliographic data are discussed. Two popular types of microcomputer DBMS, file management systems and relational database management systems, are evaluated with respect to these criteria. File management systems are appropriate when a relatively small number of simple records are to be stored, and retrieval time for multi‐valued data items is not a critical factor. Relational database management systems are indicated when large numbers of complex records are to be stored, and retrieval time for multi‐valued data items is critical. However, successful use of relational database management systems often requires programming skills.

There is a huge amount of information and data stored in publicly available online databases that consist of large text files accessed by Boolean search techniques. It is widely held that less use is made of these databases than could or should be the case, and that one reason for this is that potential users find it difficult to identify which databases to search, to use the various command languages of the hosts and to construct the Boolean search statements required. This reasoning has stimulated a considerable amount of exploration and development work on the construction of search interfaces, to aid the inexperienced user to gain effective access to these databases. The aim of our paper is to review aspects of the design of such interfaces: to indicate the requirements that must be met if maximum aid is to be offered to the inexperienced searcher; to spell out the knowledge that must be incorporated in an interface if such aid is to be given; to describe some of the solutions that have been implemented in experimental and operational interfaces; and to discuss some of the problems encountered. The paper closes with an extensive bibliography of references relevant to online search aids, going well beyond the items explicitly mentioned in the text. An index to software appears after the bibliography at the end of the paper.

Changes in market and production profiles require a more flexible concept in manufacturing. Computer integrated manufacturing (CIM) describes an integrative concept for joining business and manufacturing islands. In this context, database technology is the key technology for implementing the CIM philosophy. However, CIM applications are more complex and thus more demanding than traditional database applications such as business and administrative applications. Systematically analyses the database requirements for CIM applications including business and manufacturing tasks. Special emphasis is given on integration requirements due to the distributed, partly isolated nature of CIM applications developed over the years. An illustrative sampling of current efforts in the database community to meet the challenge of non‐standard applications such as CIM is presented.

A survey of current work on database systems is presented. The area is divided into three main sectors: data models, data languages and support for database operations. Data models are presented as the link between the database and the real world. Languages range from formal algebraic languages to attempts to use a dialogue in English to formulate queries. The support includes hardware for content addressing, database machines and software techniques for optimizing and evaluating group expressions. Mathematical models are used to organize this support. Throughout there is a tutorial component and evaluation, which in both cases is related to the application of database ideas to documentation.

To describe the evolution of a content management system at the University of Maine Library that would function as a universal, extensible metadata repository, thereby eliminating the need to build separate databases for new digital collections, and facilitating both end‐user access and the management of electronic resources in an integrated technology environment.

Beginning with the development of a prototype system that mapped EAD encoded finding aids to a relational database, this paper discusses the evolution of this prototype into the design and implementation of a RDBMS (and continuing development of an object‐oriented database management systems (OODBMS) system) to actively manage digital objects and associated metadata. The key to the system design is metadata: extracting and mapping, transforming, and managing the processing of MARC‐based metadata into non‐MARC schemes to build digital collections. Other relevant CMS architecture issues discussed are the design of a functional bibliographic structure and utilities for metadata harvesting and indexing.

Provides information on the use of the Dublin Core Abstract Model and a flexible and adaptable collection‐centric approach in the overall CMS architecture as implemented on a non‐MARC RDBMS, and provides an explanation of the advantages of an object oriented database system over the complexity of evolving relational database tables.

A useful source for the development of an in‐house CMS, and a contribution to the growing body of literature about the transformation of MARC‐based metadata for database design.

This paper is a case study of actual work conducted at the University of Maine Library. The RDBMS manages digital collections; the OODBMS manages digital video and other multimedia resources.

A comparison was made between CDS/ISIS, its Windows version WINISIS, and InMagic’s INMAGIC and DB/TextWorks software. Packages were evaluated for their database creation, information retrieval and report production capabilities. Windows versions were found to provide significant enhancements over DOS versions of software. The evaluation aimed to determine the advantages to a developing country of creating bibliographic databases using commercial software.

The current maintenance management method has affected the efficiency of the building facility management at Polytechnics. Many issues such as poor service delivery, inadequate finance, poor maintenance planning and maintenance backlogs have emerged due to the usage of conventional method application (paper-based form and unsystematic database. The purpose of this paper is to review existing literature and case studies project of the technologies in maintenance management at Polytechnic, and subsequently to identify the challenge in improving the current maintenance management technologies.

The purpose of this paper is to review existing literature and case studies project of the technologies in maintenance management at Polytechnic, and subsequently to identify the challenges of information and communication technology (ICT) implementation for strategic defect diagnosis and decision-making in improving the current maintenance management technologies. Eight Polytechnics are selected on the basis of the major problems of using the conventional method in the comparison to investigate the maintenance management practices in each Polytechnic. There are around 32 Polytechnics in Malaysia and most are using conventional methods.

The findings reveal the need for a more sophisticated maintenance management system that provides guidelines for decision-making processes with the implementation of ICT. The interview results also reveal irregularities within the Malaysian Polytechnics’ maintenance management database. The system architecture and the information system prototype are presented to integrate the information database and maintenance management processes in improving the building diagnosis approach and decision-making process for managing building maintenance.

This new system is expected to become the successful technology in assisting the maintenance contractors, clients and developer for effective management of maintenance defects at Polytechnic.