Column-Oriented Database Management Systems

Import 04/11/2015Tato práce se zabývá ukládáním dat v sloupcově orientovaných databázových systémech, jejich srovnáním s řádkovými databázovými systémy. V textu je věnovaná pozornost technologiím ukládání dat, popisu implementace vlastního databázového systému a srovnávacím testům. Je zmíněna oblast, ve které je lepší použít vertikální ukládání dat; součástí práce je také vlastní databázový systém pro sloupcové ukládání dat. Následuje srovnání obou systémů, jejich vyhodnocení a doporučení nejlepšího řešení.This work is dealing with data storage in column-oriented databases, and their comparison with relational databases.The text concentrates on data storage technologies, description of implementation of its own database system and comparative tests. In the work, I’ve also included the area in which it is preferred to use vertical data storage; another part of the work is its own database for column-oriented data storage. It is followed by a comparison of the two systems, their evaluation and recommendation of the best solution.460 - Katedra informatikydobř

Scientific Data Bases at Scale and SciDB

Abstract: As a general rule, scientists have shunned relational data management systems (RDBMS), choosing instead to &ldquo;roll their own&rdquo; on top of file system technology.&nbsp; We first discuss why file systems are a poor choice for science data storage, especially as data volumes become large and scalability becomes important. &nbsp; Then, we continue with the reasons why RDBMSs work poorly on most science applications.&nbsp; These include a data model &ldquo;impedance mismatch&rdquo; and missing features. We discuss array DBMSs, and why they are a much better choice for science applications, and use SciDB as an exemplar of this new class of DBMSs. &nbsp; Most science applications require a mix of data management and complex analytics.&nbsp; In most cases, the analytics entail a sequence of linear algebra computations.&nbsp; We discuss the possible ways of integrating a DBMS with statistical calculations, and conclude with the mechanism being used by SciDB. &nbsp; Bio: Dr. Stonebraker has been a pioneer of data base research and technology for more than a quarter of a century.&nbsp; He was the main architect of the INGRES relational DBMS, and the object-relational DBMS, POSTGRES.&nbsp; These prototypes were developed at the University of California at Berkeley where Stonebraker was a Professor of Computer Science for twenty five years.&nbsp; More recently at M.I.T. he was a co-architect of the Aurora/Borealis stream processing engine, the C-Store column-oriented DBMS, and the H-Store transaction processing engine.&nbsp;&nbsp; Currently, he is working on science-oriented DBMSs, OLTP DBMSs, and scalable data curation.&nbsp; He is the founder of five venture-capital backed startups, which commercialized his prototypes.&nbsp; Presently he serves as Chief Technology Officer of VoltDB and Paradigm4, Inc. &nbsp; Professor Stonebraker is the author of scores of research papers on data base technology, operating systems and the architecture of system software services.&nbsp; He was awarded the ACM System Software Award in 1992, for his work on INGRES.&nbsp; Additionally, he was awarded the first annual Innovation award by the ACM SIGMOD special interest group in 1994, and was elected to the National Academy of Engineering in 1997.&nbsp; He was awarded the IEEE John Von Neumann award in 2005, and is presently an Adjunct Professor of Computer Science at M.I.T, where he is co-director of the new Intel Science and Technology Center focused on big data. &nbsp; &nbsp;</p