Linux Today: Linux News On Internet Time.

More on LinuxToday

Business Intelligence - SQL or NoSQL - Which is better

Jan 11, 2011, 19:02 (0 Talkback[s])
(Other stories by Peter Evans)


Desktop-as-a-Service Designed for Any Cloud ? Nutanix Frame


"In computing, NoSQL is a term used to designate database management systems that differ from classic relational database management systems in some way. These data stores may not require fixed table schemas, and usually avoid join operations and typically scale horizontally. Academics and papers typically refer to these databases as structured storage, a term that would include classic relational databases as a subset. Notable production implementations include Google's Big Table, Amazon's Dynamo and Apache Cassandra.

"NoSQL implementations like Cassandra and Dynamo can scale out past the terabyte and on to the petabyte size by utilizing horizontal scaling and multiple nodes and in particular, the costs differences associated between SQL and NoSQL implementations are significant. However, each type of NoSQL system uses its own proprietary code for its connections and the system is usually set up for a particular model, which enables super fast performance but does hinder the ability to run any adhoc queries on the data.

"Implementing NoSQL in Business Intelligence Applications

"I have found recently that many of my clients are looking to connect to social networking data to enable them to trend sales and customer selections. This data is very unstructured and most is in the form of NoSQL (Twitter, Facebook, etc). In a normal business environment the scalability and ACID (atomicity, consistency, isolation, and durability) properties of a traditional RDBMS system is perfect for supporting an online EPOS system or transactional data which is updated once a day. Even if this type of data starts to scale up to the terabyte size the data can be denormalized via ETL processes and flattened into a star schema, which can then be accessed quickly."

Complete Story

Related Stories: