How Does SQL Work? {2}

by Hongde H
The article is choose to read this week is ” How Does SQL Work?” by Josienita Borlongan. The article is very straight forward and the author started the article right away by explaining it into four parts such as definition, uses, Features and components and scalability.

According to author, The Structured Query Language (SQL) is the language of databases, a computer language that one can use to interact with a relational database. It is a comprehensive language for controlling and interacting with database management systems. By learning SQL, we will be able to use SQL to search existing  database, modify databases and create new databases and database elements. read more...

Alpha Flight for FoundationDB {1}

by Rudy P
The article I chose to blog about this week is, “FoundationDB — Not Your Standard NoSQL Database” by Mr. Alex Williams of TechCrunch. This article discusses the new database management system known as FoundationDB which is currently in alpha and will be in beta by the end of this year. FoundationDB takes many of its strengths from NoSQL, however executives state they  ” have a database that is industrial strength, scalable, and fault tolerant”(Williams, 2012). They believe that over the years NoSQL databases become a bit difficult to scale to large levels, and can be difficult to build on top of the databases. FoundationDB distinguishes  itself from other database management systems by how, “serves as a foundation for different data models that can be layered on top of FoundationDB” (Williams, 2012). Its main purpose is to become the foundation for database environments by being able to manage both scalability and transactions. This looks to be very promising and will hope to enter a tough market later this year. read more...

mySQL, NoSQL, and now NewSQL? {4}

by Eric C
In today’s fast paced world with data growing at an exponential rate, a database must be scalable and perform well with today’s demands in storing data. SQL databases have been around for decades and the basic architecture wasn’t created with scalability in mind. Apparently there have been new advances in database technology and it includes instances of NoSQL and NewSQL. Michael Stonebraker is a seasoned database creator who is now a chief technology officer for VoltDB, explained the benefits of using “NewSQL” to better benefit today’s demands for database performance. Stonebraker stated that traditional SQL systems have many limitations and that includes performance. SQL databases are also not scalable onto more than one server. If one were to make an SQL database scale onto more servers for better performance, it would be very complicated to manage. NoSQL was indeed created to improve on scalability and is increasing in popularity; it also has its own limitations as well. The main problem with NoSQL is that it cannot perform complicated mathematical queries. However with NewSQL, it improves on all of the issues with SQL and NewSQL, making it a more efficient database system that can process requests faster and can scale to more than one server. According to Joab Jackson, the author of the article entitled “’NewSQL’ Could Combine the Best of SQL and NoSQL” from PCWorld, using NewSQL “can execute transactions 45 times faster than a typical relational database system” and “can scale across 39 servers, and handle up to 1.6 million transactions per second across 300 CPU cores” (Jackson). read more...

Scalability with Parallelism {1}

by David A
Embarrassingly Scalable Database Systems talks about how scalability will be achieved through parallelism as technology progresses over time. It mentions Moore’s Law and how it translates to single-processor performance gains. Moore’s Law states that the number of processors per chip roughly doubles every two years. The challenge for conventional database servers running business intelligence and transaction processing workloads is parallelism. As the cost of microprocessors decrease, parallelism is going to be used on a larger scale to increase scalability. It mentions that there is a tradeoff when it comes to performance and scalability. It also mentions that in order to transform a database storage manager from a single to a multi-threaded processing, many fundamental changes need to be made. To achieve parallelism on a larger scale many changes need to be made, for example, decoupling transaction data access is used to ensure consistency in centralized operations and other technical changes. It mentions the areas where parallelism can be utilized such as the query processing level. read more...

Scalable Database Service {1}

by Mike Y
Amazon Web Service (AWS) launched a NoSQL database that scales up or down depending on the customers needs. Traditional databases were not as flexible with scalability. The AWS allows the managing and scaling of databases for web apps where normally it would be difficult and costly to do so. DynamoDB is a new database service which stores data on Solid State Drives and is used internally at read more...