Object reational data base management systems and applications in document retrieval

http://deepblue.lib.umich.edu/bitstream/2027.42/96902/1/MBA_JayaramanaF_1996Final.pd

A generalized strategy for building resident database interfaces

A strategy for building resident interfaces to host heterogeneous distributed data base management systems is developed. The strategy is used to construct several interfaces. A set of guidelines is developed for users to construct their own interfaces

Handling Unstructured Data Type in DB2 and Oracle

The objective of our work is to determine which mainstream object-relational database management systems (ORDMS) provide convenient facilities for the storage and manipulation of unstructured data objects. These objects, which consist of video, audio, photographs, and even executable code such as Java applets, are becoming readily employed by desktop, network, and Internet applications. Typically, these ORDMSs must store the objects in a manner by which they can be easily accessed, but more importantly, easily processed during either storage or retrieval. Our focus is on two of the ORDMS market leaders: IBM’s DB2 and Oracle. The salient facilities of DB2 and Oracle in handling object types are analyzed, considering their advantages and disadvantages

Database management system performance comparisons: A systematic literature review

Efficiency has been a pivotal aspect of the software industry since its inception, as a system that serves the end-user fast, and the service provider cost-efficiently benefits all parties. A database management system (DBMS) is an integral part of effectively all software systems, and therefore it is logical that different studies have compared the performance of different DBMSs in hopes of finding the most efficient one. This study systematically synthesizes the results and approaches of studies that compare DBMS performance and provides recommendations for industry and research. The results show that performance is usually tested in a way that does not reflect real-world use cases, and that tests are typically reported in insufficient detail for replication or for drawing conclusions from the stated results.Comment: 36 page

Growth of relational model: Interdependence and complementary to big data

A database management system is a constant application of science that provides a platform for the creation, movement, and use of voluminous data. The area has witnessed a series of developments and technological advancements from its conventional structured database to the recent buzzword, bigdata. This paper aims to provide a complete model of a relational database that is still being widely used because of its well known ACID properties namely, atomicity, consistency, integrity and durability. Specifically, the objective of this paper is to highlight the adoption of relational model approaches by bigdata techniques. Towards addressing the reason for this in corporation, this paper qualitatively studied the advancements done over a while on the relational data model. First, the variations in the data storage layout are illustrated based on the needs of the application. Second, quick data retrieval techniques like indexing, query processing and concurrency control methods are revealed. The paper provides vital insights to appraise the efficiency of the structured database in the unstructured environment, particularly when both consistency and scalability become an issue in the working of the hybrid transactional and analytical database management system

Gestión eficiente de reconocimiento del iris en bases de datos objetos-relacionales

Biometric applications have grown significantly in recent years, particularly iris-based systems. In the present work, an extension of an Object Relational Database Management System for the integral management of a biometric system based on the human iris was presented. Although at present, there are many database extensions for different domains, in no case for biometric applications. The proposed extension includes both the extension of the type system and the definition of domain indexes for performance improvement. The aim of this work is to provide a tool that facilitates the development of biometric applications based on the iris feature. Its development is based on a reference architecture that includes both the management of images of the iris trait, its associated metadata and the necessary methods for both manipulation and queries. An implementation of the extension is performed for PostgreSQL DBMS, and SP-GiST framework is used in the implementation of a domain index. Experiments were carried out to evaluate the performance of the proposed index, which shows improvements in query execution times.Las aplicaciones biométricas han crecido significativamente en los últimos años, en particular los sistemas basados en el iris. En el presente trabajo se presenta una ampliación de un Sistema de Gestión de Base de Datos Objeto-Relacional para la gestión integral de un sistema biométrico basado en el iris humano. Aunque en la actualidad existen muchas extensiones de bases de datos para diferentes dominios, en ningún caso existen para aplicaciones biométricas. La extensión propuesta incluye tanto la extensión del sistema de tipos como la definición de índices de dominio para la mejora del rendimiento. El objetivo de este trabajo es proporcionar una herramienta que facilite el desarrollo de aplicaciones biométricas basadas en el iris. Su desarrollo se basa en una arquitectura de referencia que incluye tanto la gestión de las imágenes del rasgo del iris, sus metadatos asociados y los métodos necesarios, tanto para la manipulación como para las consultas. Se realiza una implementación de la extensión para PostgreSQL DBMS, y se utiliza el framework SPGiST en la implementación de un índice de dominio. Se realizaron experimentos para evaluar el desempeño del índice propuesto, que muestra mejoras en los tiempos de ejecución de las consultas.Facultad de Informátic

Gestión eficiente de reconocimiento del iris en bases de datos objetos-relacionales

Biometric applications have grown significantly in recent years, particularly iris-based systems. In the present work, an extension of an Object Relational Database Management System for the integral management of a biometric system based on the human iris was presented. Although at present, there are many database extensions for different domains, in no case for biometric applications. The proposed extension includes both the extension of the type system and the definition of domain indexes for performance improvement. The aim of this work is to provide a tool that facilitates the development of biometric applications based on the iris feature. Its development is based on a reference architecture that includes both the management of images of the iris trait, its associated metadata and the necessary methods for both manipulation and queries. An implementation of the extension is performed for PostgreSQL DBMS, and SP-GiST framework is used in the implementation of a domain index. Experiments were carried out to evaluate the performance of the proposed index, which shows improvements in query execution times.Las aplicaciones biométricas han crecido significativamente en los últimos años, en particular los sistemas basados en el iris. En el presente trabajo se presenta una ampliación de un Sistema de Gestión de Base de Datos Objeto-Relacional para la gestión integral de un sistema biométrico basado en el iris humano. Aunque en la actualidad existen muchas extensiones de bases de datos para diferentes dominios, en ningún caso existen para aplicaciones biométricas. La extensión propuesta incluye tanto la extensión del sistema de tipos como la definición de índices de dominio para la mejora del rendimiento. El objetivo de este trabajo es proporcionar una herramienta que facilite el desarrollo de aplicaciones biométricas basadas en el iris. Su desarrollo se basa en una arquitectura de referencia que incluye tanto la gestión de las imágenes del rasgo del iris, sus metadatos asociados y los métodos necesarios, tanto para la manipulación como para las consultas. Se realiza una implementación de la extensión para PostgreSQL DBMS, y se utiliza el framework SPGiST en la implementación de un índice de dominio. Se realizaron experimentos para evaluar el desempeño del índice propuesto, que muestra mejoras en los tiempos de ejecución de las consultas.Facultad de Informátic