Over a million developers have joined DZone.
{{announcement.body}}
{{announcement.title}}

JSON Modeling for RDBMS Users [Video]

DZone's Guide to

JSON Modeling for RDBMS Users [Video]

Watch data go from relational to CSV to a staging bucket and finally assembled with the new model.

· Database Zone ·
Free Resource

Download the Altoros NoSQL Performance Benchmark 2018. Compare top NoSQL solutions – Couchbase Server v5.5, MongoDB v3.6, and DataStax Enterprise v6 (Cassandra).

JSON modeling was covered in a previous blog post which was, in turn, based on a CSV import blog post that came before that. While writing the post on JSON modeling, it occurred to me that it might be useful to see all the data in motion: from relational to CSV to a staging bucket and finally assembled with the new model.

JSON Modeling Video

A tool that I neglected to mention in any of these earlier posts is csvkit and specifically csvsql. This tool can pull CSV data from SQL Server, MySQL, Oracle, PostgreSQL, SQLite, Sybase, and Firebird directly into CSV.

Thanks for watching!

As always, find me on Twitter @mgroves, leave a comment, or post your questions into the Couchbase forums.

Download the whitepaper, Moving From Relational to NoSQL: How to Get Started. We’ll take you step by step through your first NoSQL project.

Topics:
couchbase ,database ,json ,data modeling

Published at DZone with permission of

Opinions expressed by DZone contributors are their own.

{{ parent.title || parent.header.title}}

{{ parent.tldr }}

{{ parent.urlSource.name }}