SQL vs. NoSQL
What Does Relational Mean in a Relational Database?
In common usage, the relational part of Relational Database refers to (or is often assumed to refer to) the way tables are related to each other via keys. For the truly pedantic though, this is in in fact incorrect. Relational here does not refer to relationships between tables, rather it refers to the mathematical concept of a relation, which is in essence what relational databases call tables. A relational database is a database based on the relational model.
Resources
SQL Databases:
MariaDB: askmonty.org
PostgreSQL: www.postgresql.org
NoSQL Databases:
Cassandra: cassandra.apache.org
CouchDB: couchdb.apache.org
HBase: hadoop.apache.org/hbase
Redis: code.google.com/p/redis
Voldemort: project-voldemort.com
MongoDB: www.mongodb.org
Hypertable: hypertable.org
Dynomite: wiki.github.com/cliffmoon/dynomite/dynomite-framework
BigTable: labs.google.com/papers/bigtable.html
Brewer's CAP Theorem:
Brewer's CAP Theorem by Julian Browne: www.julianbrowne.com/article/viewer/brewers-cap-theorem
CAP Theorem: devblog.streamy.com/2009/08/24/cap-theorem
Towards Robust Distributed Systems by Dr Eric A. Brewer: www.cs.berkeley.edu/~brewer/cs262b-2004/PODC-keynote.pdf
Brewer's Conjecture and the Feasibility of Consistent Available Partition-Tolerant Web Services (2002) by Seth Gilbert and Nancy Lynch: citeseer.ist.psu.edu/544596.html
E. F. Codd's “A Relational Model of Data for Large Shared Data Banks”: www.seas.upenn.edu/~zives/03f/cis550/codd.pdf
Other Links:
Dennis Forbes on Software and Technology: www.yafla.com/dforbes
Looking to the future with Cassandra by Ian Eure: about.digg.com/blog/looking-future-cassandra
NOSQL debrief by Johan Oskarsson: blog.oskarsson.nu/2009/06/nosql-debrief.html
BASE: An Acid Alternative by Dan Pritchett: queue.acm.org/detail.cfm?id=1394128
Should you go Beyond Relational Databases? by Martin Kleppmann: carsonified.com/blog/dev/should-you-go-beyond-relational-databases
NoSQL Q and A: www.dbms2.com/2009/12/11/nosql-q-and-a
NoSQL Video by Brian Aker: www.youtube.com/watch?v=LhnGarRsKnA
Daniel Bartholomew works for Monty Program as a technical writer and system administrator. He lives with his wife and children in North Carolina and often can be found hanging out on both #linuxjournal and #maria on Freenode IRC.
- « first
- ‹ previous
- 1
- 2
- 3
- 4
Realizing the promise of Apache® Hadoop® requires the effective deployment of compute, memory, storage and networking to achieve optimal results. With its flexibility and multitude of options, it is easy to over or under provision the server infrastructure, resulting in poor performance and high TCO. Join us for an in depth, technical discussion with industry experts from leading Hadoop and server companies who will provide insights into the key considerations for designing and deploying an optimal Hadoop cluster.
Sponsored by AMD
Built-in forensics, incident response, and security with Red Hat Enterprise Linux 6
Every security policy provides guidance and requirements for ensuring adequate protection of information and data, as well as high-level technical and administrative security requirements for a system in a given environment. Traditionally, providing security for a system focuses on the confidentiality of the information on it. However, protecting the data integrity and system and data availability is just as important. For example, when processing United States intelligence information, there are three attributes that require protection: confidentiality, integrity, and availability.
Learn more about catching the bad guy in this free white paper.
Sponsored by DLT Solutions
Free Webinar: Hadoop
How to Build an Optimal Hadoop Cluster to Store and Maintain Unlimited Amounts of Data Using Microservers
Realizing the promise of Apache® Hadoop® requires the effective deployment of compute, memory, storage and networking to achieve optimal results. With its flexibility and multitude of options, it is easy to over or under provision the server infrastructure, resulting in poor performance and high TCO. Join us for an in depth, technical discussion with industry experts from leading Hadoop and server companies who will provide insights into the key considerations for designing and deploying an optimal Hadoop cluster.
Some of key questions to be discussed are:
- What is the “typical” Hadoop cluster and what should be installed on the different machine types?
- Why should you consider the typical workload patterns when making your hardware decisions?
- Are all microservers created equal for Hadoop deployments?
- How do I plan for expansion if I require more compute, memory, storage or networking?
| Dynamic DNS—an Object Lesson in Problem Solving | May 21, 2013 |
| Using Salt Stack and Vagrant for Drupal Development | May 20, 2013 |
| Making Linux and Android Get Along (It's Not as Hard as It Sounds) | May 16, 2013 |
| Drupal Is a Framework: Why Everyone Needs to Understand This | May 15, 2013 |
| Home, My Backup Data Center | May 13, 2013 |
| Non-Linux FOSS: Seashore | May 10, 2013 |
- RSS Feeds
- Making Linux and Android Get Along (It's Not as Hard as It Sounds)
- Using Salt Stack and Vagrant for Drupal Development
- New Products
- Validate an E-Mail Address with PHP, the Right Way
- Drupal Is a Framework: Why Everyone Needs to Understand This
- Download the Free Red Hat White Paper "Using an Open Source Framework to Catch the Bad Guy"
- A Topic for Discussion - Open Source Feature-Richness?
- Dynamic DNS—an Object Lesson in Problem Solving
- Tech Tip: Really Simple HTTP Server with Python
- Please correct the URL for Salt Stack's web site
1 hour 58 min ago - Android is Linux -- why no better inter-operation
4 hours 14 min ago - Connecting Android device to desktop Linux via USB
4 hours 42 min ago - Find new cell phone and tablet pc
5 hours 40 min ago - Epistle
7 hours 9 min ago - Automatically updating Guest Additions
8 hours 18 min ago - I like your topic on android
9 hours 4 min ago - This is the easiest tutorial
15 hours 40 min ago - Ahh, the Koolaid.
21 hours 18 min ago - git-annex assistant
1 day 3 hours ago




Comments
Yap what more can you say
Yes this article exactly matches the situation today with SQL/NoSQL movements.
Very good analysis.