In this article, author Oleksii Tymchenko discusses a bio-informatic software as a service (SaaS) product called Chorus, which was built as a public data warehousing and analytical platform for mass spectrometry data. Other features of the product include real-time visualization of raw mass-spec data.
Columnar data storage can offer significant performance improvements over the way database tables are traditionally stored, but they aren’t always faster. Aleksandr Shavlyuga explores the power, and limitations of SQL Server’s ColumnStore Indexes.
The holy grail of database development is the ability to treat database objects (tables, views, stored procedures, etc.) as if they were just like any other form of source code. While SQL Server Data Tools doesn’t quite that level, it gets very close.
Sytze Harkema explains how to save and retrieve relational SQL data into a NoSQL key-value store as implemented by FoundationDB, an open source, scalable, fault tolerant and ACID database.
It’s unthinkable for modern application developers to work without source control, yet somehow, databases are often left out. But it doesn’t have to be that way.
Some users are interacting with databases through complex SQL queries, both in terms of performance as well as expressivity. If SQL and JPA are diverging, where will our data interaction patterns go? 4
Justin Weiler introduces FatDB, a NoSQL DB and a distributed platform built on Mission Oriented Architecture meant to abstract and generalize the essential characteristics of enterprise applications.
In Part 2 of this article the author takes a look at how the transaction system is implemented, the role of the administrative layer, how all components work together and what to expect in the future. 1
In Part 1 of this article the author introduces NuoDB and some of its main features: 3-tiered architecture, nodes are equal peers, Atoms, and versioning and concurrency system. 8
MetaModel - an Apache Incubator project – is a Java library used to browse, query and update various types of data stores, such as RDBMS, CSV, Excel, NoSQL, etc., in a uniform and programmatic way. 4
Stefan Edlich reviews NoSQL, considering its evolution, financial impact, standards or their lack of, current landscape, books, the leaders and some newcomers, concluding that NoSQL is here to stay. 3
This article contains an interview with Dipti Borkar, Director of Product Management at Couchbase, on the challenges, benefits and the process of migrating from RDBMS to NoSQL. 6