Header

Common misunderstanding with NoSQL

March 12th, 2012 | Posted by admin in Databases - (0 Comments)

I’ve been trolling the internet and kept running into articles where people are constantly miss-reading what NoSQL stands for:

  • NoSQL is NOT “Never SQL”
  • NoSQL is NOT “No To SQL”

NoSQL stand for “Not Only SQL“.

There are currently four (emerging) NoSQL Categories:

  • Key value stores
    • Based on Amazon’s Dynamo Paper
    • Data model: (global) collection of K-V pairs
    • Example: Riak, Voldemort, Tokyo*
  • Column Family or Big Table Clones
    • Based on Googles Big Table Paper
    • Data model: big table, column families
    • Example: HBase, Hypertable, Cassandra
  • Document Databases
    • Inspired by Lotus Notes
    • Data model: collection of K-V  collections
    • Example: CouchDB, MongoDB
  • Graph Databases
    • Inspired by Euler & graph theory
    • Data model: nodes, rels, K-V on both
    • Example: AllegroGraph, Sones, Neo4
VN:F [1.9.15_1155]
Rating: 10.0/10 (1 vote cast)
VN:F [1.9.15_1155]
Rating: +1 (from 1 vote)

noSQL Youtube Video

March 9th, 2012 | Posted by admin in Databases - (0 Comments)

I was looking around YouTube and found this interesting video on noSQL:

VN:F [1.9.15_1155]
Rating: 10.0/10 (1 vote cast)
VN:F [1.9.15_1155]
Rating: +1 (from 1 vote)

Non-SQL xBase Databases and Tools

February 4th, 2012 | Posted by admin in Databases - (0 Comments)

Okay i’m going to attempt to list most of the Free or Open Source databases available on Linux that do not fit cleanly into the SQL arena. This page will list xBase style databases systems

Various xBase implementations are available for Linux:

  • FlagShip — essentially a Clipper “clone”; it compiles dBase III+ (and higher) code, and reads and writes related file formats. Free Personal FlagShip is an unlimited 2-user version similar to the commercial Personal license, but intended strictly for personal use or for development of database applications distributed for free (whether Public Domain or Open Source).
  • The Harbour Project — building a Clipper “clone” for DOS and Unix that is freely redistributable.
  • PlugSys International
  • Recital
  • CodeBase
  • DBF to other formats conversion software
  • X2c — a portable xBase compiler.
  • Xbase — a collection of specifications, programs, utilities and a C++ class library for manipulating xBase type datafiles and indices.
  • XBSQL — a wrapper library providing an SQL-like interface to the Xbase DBMS.

A short Video xBase Database in use:

VN:F [1.9.15_1155]
Rating: 10.0/10 (1 vote cast)
VN:F [1.9.15_1155]
Rating: +1 (from 1 vote)

Taking Refuge In Simplicity.

January 1st, 2012 | Posted by admin in News - (0 Comments)

SQLFreeNYC is devoted to bringing together the people and technology to advance data storage solutions beyond legacy relational technology. This is the movement which encompasses NoSQL.

We strive for simplicity because life is too long to spend it writing SQL, dealing with object-relational mappings and constantly organizing your data around the needs of your database rather than vice-versa.

VN:F [1.9.15_1155]
Rating: 10.0/10 (2 votes cast)
VN:F [1.9.15_1155]
Rating: +1 (from 1 vote)