Wednesday, August 23, 2017

From Excel Hell to Cloud Database Heaven

DZone Database Zone
From Excel Hell to Cloud Database Heaven

Most well-known database technologies have some or all of the following features:

Data quality and consistency: A data schema with a detailed description of all data resources and properties. Automatic data validation according to the data schema. Row/document locking to prevent data collision. Access control: Define access roles to allow/prevent read, write, or delete on resources. Allow users to have private data views of shared resources. Data relations Query language API: A REST API for platform-agnostic data access and integration. A platform-specific SDK.

The rest of this blog post is a step-by-step tutorial on how you can migrate from spreadsheets to a fast and consistent NoSQL cloud database using RestDB.io.

No comments:

Fun With SQL: Functions in Postgres

DZone Database Zone Fun With SQL: Functions in Postgres In our previous  Fun with SQL  post on the  Citus Data  blog, we covered w...