InfoQ Homepage Relational Databases Content on InfoQ

Articles

RSS Feed

Newer Older

How to Effectively Map SQL Data to a NoSQL Store

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.

Sytze Harkema
on Oct 23, 2014
Introduction to Red Gate’s SQL Source Control

It’s unthinkable for modern application developers to work without source control. The benefits it brings to software development are so well and so long understood that even lone hobbyist developers will tend to employ a source control system. Yet somehow, databases are often left out. David Atkinson shows how this doesn’t have to be the case with Red Gate’s SQL Source Control.

David Atkinson
on Oct 01, 2014
Don’t jump the SQL ship just yet

The SQL language has been evolving steadily over the last two decades. At the same time, the verbosity caused by the JDBC API in Java client code and the lack of first class SQL support within the Java language have led to the introduction of ORMs such as Hibernate, which was later standardised into JPA and the Criteria API.If SQL and JPA are diverging, where will our data interaction patterns go?

Lukas Eder
on Dec 18, 2013
Building Scalable Applications in .NET: Introducing the FatDB Distributed Computing Platform

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.

Justin Weiler
on Jul 22, 2013
Exploring the Architecture of the NuoDB Database, Part 2

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.

Seth Proctor
on Jul 17, 2013
Exploring the Architecture of the NuoDB Database, Part 1

In Part 1 of this article the author introduces NuoDB and covers some of its main features: 3-tiered architecture, nodes are equal peers, Atoms - the fundamental data unit, and the versioning and concurrency system used to handle data update conflicts and implement consistency.

Seth Proctor
on Jul 12, 2013
Apache MetaModel – Providing Uniform Data Access Across Various Data Stores

MetaModel - an Apache Incubator project – is a Java library used to browse, query and update various types of data stores including traditional SQL databases, unusual stores such as CSV or Excel, or the more modern NoSQL stores in a uniform and programmatic way.

Kasper Sørensen
on Jul 03, 2013
The State of NoSQL

Stefan Edlich, Senior Lecturer at Beuth HS of Technology Berlin, Germany, reviews NoSQL, considering its evolution, financial impact, the standards or their lack of, the current landscape, books, the leaders and some newcomers, concluding that NoSQL is here to stay.

Stefan Edlich
on Nov 21, 2012
Transitioning from RDBMS to NoSQL. Interview with Couchbase’s Dipti Borkar

While relational databases have been used for decades to store data, and they still represent a viable solution for many use cases, NoSQL is being chosen today especially for scalability and performance reasons. 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.

Abel Avram
on Sep 08, 2012
Testing SQL Server Code with TST

Automated Testing (unit/integration) is an integral part of any agile development process. However a project with significant logic housed in database code creates severe constraints to writing unit level tests, especially if it is large, complex and depend on data. We will explore the TST framework and a few ideas for writing and maintaining good tests for database code.

Roopesh Shenoy
on Jun 18, 2012
CAP Twelve Years Later: How the "Rules" Have Changed

The CAP theorem asserts that any networked shared-data system can have only two of three desirable properties (Consistency, Availability and Partition Tolerance). In this IEEE article, author Eric Brewer discusses how designers can optimize consistency and availability by explicitly handling partitions, thereby achieving some trade-off of all three.

Eric Brewer
on May 30, 2012
AI, ML & Data Engineering

Using Entity Framework to Successfully Target Multiple Databases

Yevhen Shchyholyev discusses some of the problems that the user may face in the process of developing an application with Entity Framework that interacts with Oracle, MySQL, PostgreSQL or SQLite as well as SQL Server. It is intended to be useful to both developers using one of these databases for the first time as well as for those who regularly interaction with multiple databases.

Yevhen Shchyholyev
on Jul 25, 2011