Object Oriented Databases and their Application to Historical Data

1994 ◽  
Vol 6 (1) ◽  
pp. 44-51 ◽  
Author(s):  
Gwyn Price ◽  
Alec Gray
Keyword(s):  
Database Management ◽  
Historical Data ◽  
Historical Context ◽  
Object Oriented ◽  
Database Systems ◽  
Historical Research ◽  
Management Systems ◽  
Relational Database Systems ◽  
Analytical Power ◽  
Object Oriented Databases

Relational Database Systems currently dominate the marketplace and thus the use of Database Management Systems by historians. This technology can constrain the thinking ofits users and limit the representational and analytical power of the applications built using it. This has led to research into other models of Database Management which are less restricting. An introduction toone ofthese approaches, Object OrientedDatabase Systems, ispresentedhere in a historical context with the purpose ofillustrating its power for historical research. An example of this power is given with a description of the authors research into the development of a workbench system utilising Object Orientedprinciples for Nominal Record Linkage.

A Framework for Cost-Based Query Optimization in Native XML Database Management Systems

2010 ◽  
pp. 160-183 ◽  
Author(s):  
Andreas M. Weiner ◽  
Theo Härder
Keyword(s):  
Query Optimization ◽  
Database Management ◽  
Cost Model ◽  
Database Systems ◽  
Database Management Systems ◽  
Management Systems ◽  
Xml Database ◽  
Xml Documents ◽  
Native Xml Database ◽  
Query Optimizers

Since the very beginning of query processing in database systems, cost-based query optimization has been the essential strategy for effectively answering complex queries on large documents. XML documents can be efficiently stored and processed using native XML database management systems. Even though such systems can choose from a huge repertoire of join operators (e. g., Structural Joins and Holistic Twig Joins) and various index access operators to efficiently evaluate queries on XML documents, the development of full-fledged XML query optimizers is still in its infancy. Especially the evaluation of complex XQuery expressions using these operators is not well understood and needs further research. The extensible, rule-based, and cost-based XML query optimization framework proposed in this chapter, serves as a testbed for exploring how and whether well-known concepts from relational query optimization (e. g., join reordering) can be reused and which new techniques can make a significant contribution to speed-up query execution. Using the best practices and an appropriate cost model that will be developed using this framework, it can be turned into a robust cost-based XML query optimizer in the future.

A Review of Database Management Systems Suitable for Neuroimaging

1999 ◽  
Vol 38 (02) ◽  
pp. 132-139 ◽  
Author(s):  
B. Diallo ◽  
J.-M. Travere ◽  
B. Mazoyer
Keyword(s):  
Brain Mapping ◽  
Database Management ◽  
Object Oriented ◽  
Database Management Systems ◽  
Management Systems ◽  
Software Products ◽  
Large Expansion ◽  
Potential Applications ◽  
Technical Assessment ◽  
Technical Terms

AbstractThis study comprises a technical assessment of Database Management Systems (DBMS), which may be of use in the analysis of data obtained from human brain mapping procedures. Due to the large expansion of the neuroimaging field, the use of specialized database software to store and process neuroimages and their attached components is inevitable. The advent of multiple software products, a wealth of technical terms and a wide variety of other applications make the choice of a suitable program sometimes difficult. Through the inclusion of some basic and pertinent criteria (e.g., performance, ease of opening, standardization and portability), we present a descriptive comparison of 12 DBMSs currently available in the commercial and public domain. We have compared and tested three main architecture models which are currently available and assessed their potential applications for imaging purposes: relational, object-oriented, and hybrid. The findings of our study demonstrated that the Illustra™ software was the best suited for a neuroimaging environment because of its intrinsic ability to handle complex and large objects, such as 3D volumes or geometric structures.

scholarly journals Analysis of the possibilities of optimizing SQL queries

2021 ◽  
Vol 19 ◽  
pp. 151-158
Author(s):  
Piotr Rymarski ◽  
Grzegorz Kozieł
Keyword(s):  
Relational Database ◽  
Web Applications ◽  
Query Language ◽  
Database Systems ◽  
Sql Server ◽  
Management Systems ◽  
Relational Database Systems ◽  
The Impact ◽  
Relational Database Management ◽  
Test Scenarios

Most of today's web applications run on relational database systems. Communication with them is possible through statements written in Structured Query Language (SQL). This paper presents the most popular relational database management systems and describes common ways to optimize SQL queries. Using the research environment based on fragment of the imdb.com database, implementing OracleDb, MySQL, Microsoft SQL Server and PostgreSQL engines, a number of test scenarios were performed. The aim was to check the performance changes of SQL queries resulting from syntax modication while maintaining the result, the impact of database organization, indexing and advanced mechanisms aimed at increasing the eciency of operations performed, delivered in the systems used. The tests were carried out using a proprietary application written in Java using the Hibernate framework.

scholarly journals Oracle 19c, SQL Server 2019, Postgresql 12 and MySQL 8 database systems comparison

2020 ◽  
Vol 17 ◽  
pp. 373-378
Author(s):  
Arkadiusz Solarz ◽  
Tomasz Szymczyk
Keyword(s):  
Comparative Analysis ◽  
Open Source ◽  
Database Management ◽  
Database Systems ◽  
Sql Server ◽  
Management Systems ◽  
Database Schema ◽  
Oracle Database ◽  
Server Systems ◽  
Test Scenarios

This article presents a comparative analysis of four popular database technologies. Commercial Oracle Database and SQL Server systems are compared with open source database management systems: PostgreSQL and MySQL. These systems have been available on the market for over a dozen years. Versions released in 2019 were selected for testing and comparasion. For the purposes of the comparative analysis, a database schema was developed and instantiated. Then, test scenarios were developed. They were prepared on the basis of the most popular operations performed with the use of database systems.

Sign in / Sign up

Export Citation Format

Share Document