Volume 1 of Open Journal of Databases(OJDB), ISSN 2199-3459 http://www.ronpub.com/index.php/journals/OJDB/issues?volume=1&issue=ALL All papers of this volume en-us Eric A. Mortensen and En Cheng: Using Business Intelligence to Improve DBA Productivity, Open Journal of Databases (OJDB), 1 (2), pages 1-16, URN: urn:nbn:de:101:1-201705194595, 2014 https://www.ronpub.com/ojdb/OJDB-v1i2n01_Mortensen.html http://nbn-resolving.de/urn:nbn:de:101:1-201705194595 The amount of data collected and used by companies has grown rapidly in size over the last decade. Business leaders are now using Business Intelligence (BI) systems to make effective business decisions against large amounts of data. The growth in the size of data has been a major challenge for Database Administrators (DBAs). The increase in the number and size of databases at the speed they have grown has made it difficult for DBA teams to provide the same level of service that the business requires they provide. The methods that DBAs have used in the last several decades can no longer be performed with the efficiency needed over all of the databases they administer. This paper presents the first BI system to improve DBA productivity and providing important data metrics for Information Technology (IT) managers. The BI system has been well received by Sherwin Williams Database Administrators. It has i) enabled the DBA team to quickly determine which databases needed work by a DBA without manually logging into the system; ii) helped the DBA team and its management to easily answer other business users' questions without using DBAs' time to research the issue; and iii) helped the DBA team to provide the business data for unanticipated audit request. Veronika Abramova, Jorge Bernardino and Pedro Furtado: Which NoSQL Database? A Performance Overview, Open Journal of Databases (OJDB), 1 (2), pages 17-24, URN: urn:nbn:de:101:1-201705194607, 2014 https://www.ronpub.com/ojdb/OJDB-v1i2n02_Abramova.html http://nbn-resolving.de/urn:nbn:de:101:1-201705194607 NoSQL data stores are widely used to store and retrieve possibly large amounts of data, typically in a key-value format. There are many NoSQL types with different performances, and thus it is important to compare them in terms of performance and verify how the performance is related to the database type. In this paper, we evaluate five most popular NoSQL databases: Cassandra, HBase, MongoDB, OrientDB and Redis. We compare those databases in terms of query performance, based on reads and updates, taking into consideration the typical workloads, as represented by the Yahoo! Cloud Serving Benchmark. This comparison allows users to choose the most appropriate database according to the specific mechanisms and application needs. Fabio Grandi: Introductory Editorial, Open Journal of Databases (OJDB), 1 (1), pages 1-2, URN: urn:nbn:de:101:1-201705194557, 2014 https://www.ronpub.com/ojdb/OJDB-v1i1n01_Grandi.html http://nbn-resolving.de/urn:nbn:de:101:1-201705194557 The Open Journal of Databases (OJDB) is a new open access journal covering all aspects of database research and technology. In this editorial, the first issue of the journal is presented. Fabien Duchateau and Zohra Bellahsene: Designing a Benchmark for the Assessment of Schema Matching Tools, Open Journal of Databases (OJDB), 1 (1), pages 3-25, URN: urn:nbn:de:101:1-201705194573, 2014 https://www.ronpub.com/ojdb/OJDB-v1i1n02_Duchateau.html http://nbn-resolving.de/urn:nbn:de:101:1-201705194573 Over the years, many schema matching approaches have been developed to discover correspondences between schemas. Although this task is crucial in data integration, its evaluation, both in terms of matching quality and time performance, is still manually performed. Indeed, there is no common platform which gathers a collection of schema matching datasets to fulfil this goal. Another problem deals with the measuring of the post-match effort, a human cost that schema matching approaches aim at reducing. Consequently, we propose XBenchMatch, a schema matching benchmark with available datasets and new measures to evaluate this manual post-match effort and the quality of integrated schemas. We finally report the results obtained by different approaches, namely COMA++, Similarity Flooding and YAM. We show that such a benchmark is required to understand the advantages and failures of schema matching approaches. Therefore, it could help an end-user to select a schema matching tool which covers his/her needs. Mawahib Musa Elbushra and Jan Lindström: Eventual Consistent Databases: State of the Art, Open Journal of Databases (OJDB), 1 (1), pages 26-41, URN: urn:nbn:de:101:1-201705194582, 2014 https://www.ronpub.com/ojdb/OJDB-v1i1n03_Elbushra.html http://nbn-resolving.de/urn:nbn:de:101:1-201705194582 One of the challenges of cloud programming is to achieve the right balance between the availability and consistency in a distributed database. Cloud computing environments, particularly cloud databases, are rapidly increasing in importance, acceptance and usage in major applications, which need the partition-tolerance and availability for scalability purposes, but sacrifice the consistency side (CAP theorem). In these environments, the data accessed by users is stored in a highly available storage system, thus the use of paradigms such as eventual consistency became more widespread. In this paper, we review the state-of-the-art database systems using eventual consistency from both industry and research. Based on this review, we discuss the advantages and disadvantages of eventual consistency, and identify the future research challenges on the databases using eventual consistency.