76 research outputs found

    RIDL*:A tool for the computer-assisted engineering of large databases in the presence of integrity constraints

    Get PDF

    Data Management Standards in Computer-aided Acquisition and Logistic Support (CALS)

    Get PDF
    Viewgraphs and discussion on data management standards in computer-aided acquisition and logistic support (CALS) are presented. CALS is intended to reduce cost, increase quality, and improve timeliness of weapon system acquisition and support by greatly improving the flow of technical information. The phase 2 standards, industrial environment, are discussed. The information resource dictionary system (IRDS) is described

    TRADE-OFF ANALYSIS OF RELATIONAL DATABASE STORAGE FOR PRIVACY PURPOSES

    Get PDF
    In business organizations, person-specific data are collected as part of service re­ quirements from customers or data providers. To maintain the privacy of these per­ sonal data from intra-organizational or external unauthorized access, an Role-based access control (RBAC) extension with privacy purposes has been introduced. Re­ search on role-based access control and privacy has been conducted. Despite all this research, not much investigation into efficient ways to store person-specific data with privacy labels has been conducted. To the best of our knowledge, there is no such re­ search to analyze the characteristics and impact of different storage patterns on RBAC with privacy purposes. In this thesis, we propose some storage schemes for extended RBAC with privacy purpose in a relational database environment. Moreover, we ana­ lyze the performance characteristics and impact of different SQL operations according to different storage schemes for the extension of RBAC with privacy purposes

    Object-oriented querying of existing relational databases

    Get PDF
    In this paper, we present algorithms which allow an object-oriented querying of existing relational databases. Our goal is to provide an improved query interface for relational systems with better query facilities than SQL. This seems to be very important since, in real world applications, relational systems are most commonly used and their dominance will remain in the near future. To overcome the drawbacks of relational systems, especially the poor query facilities of SQL, we propose a schema transformation and a query translation algorithm. The schema transformation algorithm uses additional semantic information to enhance the relational schema and transform it into a corresponding object-oriented schema. If the additional semantic information can be deducted from an underlying entity-relationship design schema, the schema transformation may be done fully automatically. To query the created object-oriented schema, we use the Structured Object Query Language (SOQL) which provides declarative query facilities on objects. SOQL queries using the created object-oriented schema are much shorter, easier to write and understand and more intuitive than corresponding S Q L queries leading to an enhanced usability and an improved querying of the database. The query translation algorithm automatically translates SOQL queries into equivalent SQL queries for the original relational schema

    YYY : a database design tool

    Get PDF

    Total Integrated Clinic Information System (TICIS)

    Get PDF
    Information technology is proving to be a vital element in the administration of healthcare. Specifically, most healthcare institutions in this country are adopting information systems that provide more accurate and timely information regarding patient care. Appropriate patient care requires the use of clinical procedures aswell as applied research protocols. Information must beaccurate and immediately available to individuals involved in the care of patients. "Total Integrated Clinic Information System" was introduced as a way to facilitate a centralized patient information repository. Benefits realized by this system included improvements in patient care, clinical research, and patient service and satisfaction. The ultimate goal ofthis project was to provide a paperless patient medical record that linked research and clinical data (Keywords: project, Administration of Healthcare, centralize patient information system, clinical research, paperless patient medical record, research, clinical data, individuals, patient care.

    Providing in RDBMSs the Flexibility to Work with Various Non-Relational Data Models

    Get PDF
    The inability of pure relational DBMSs to meet the new requirements of the applications which have emerged on the web has led to the advent of NoSQL DBMSs In recent years significant progress has been made in integrating into relational DBMSs the features essentials for taking into consideration these new requirements which mainly concern flexibility performances horizontal scaling and very high availability This paper focuses on the features which can enable the relational DBMSs to provide applications with the flexibility to work with various non-relational data models while providing the guarantees of independence integrity and performance of query evaluatio
    corecore