Bookmark Item #1: https://landing.athabascau.ca/pg/bookmarks/read/129204/problems-of-rdbms
Bookmark Item #2: https://landing.athabascau.ca/pg/bookmarks/read/129325/nosql-or-rdbms-are-we-asking-the-right-questions
Week 8 report: https://landing.athabascau.ca/pg/forum/topic/129347/week-8-research-report/
The purpose of this week is to explore the limits of RDBMS and the potential downfall of its application in the cloud environment. Prior to discovering the potential incompatibilities with RDBMS in a distributed environment such as internet cloud environment, I had thought RDBMS is the be all and end all solution to all general purpose data storage and management needs. RDBMS is very prevalence in enterprises (i.e. oracle 11g, SQL SERVER 2008 R2, DB2, etc.) and even mobile device (i.e. Sybase SQL Anywhere) that led me to presume the rational data model is the only way to model data. I do realize that there are other specialized database models but it wasn’t until this week that I came across NoSQL – it turns out it does not stand for “no sql” but it is “Not Only SQL” which is to say SQL alternatives.
The focus of this week is to see how RDBMS fits in the cloud computing paradigm. I had detailed these issues in my report but I would like to add that many top tier RDBMS such as Oracle and Microsoft do provide “workaround” for those problems. For example, partitioning and sharding options is available in SQL Server 2008 R2 (http://www.infoq.com/news/2011/02/SQL-Sharding) to compartmentalize data across multiple servers. Next week will look into more non rational data model and its management tools.
Dickson
The Landing is a social site for Athabasca University staff, students and invited guests. It is a space where they can share, communicate and connect with anyone or everyone.
Unless you are logged in, you will only be able to see the fraction of posts on the site that have been made public. Right now you are not logged in.
If you have an Athabasca University login ID, use your standard username and password to access this site.
We welcome comments on public posts from members of the public. Please note, however, that all comments made on public posts must be moderated by their owners before they become visible on the site. The owner of the post (and no one else) has to do that.
If you want the full range of features and you have a login ID, log in using the links at the top of the page or at https://landing.athabascau.ca/login (logins are secure and encrypted)
Posts made here are the responsibility of their owners and may not reflect the views of Athabasca University.