<pedrocorreia.net ⁄>

<NoSQL: Breaking free of structured data ⁄ >

clicks: 2711 2711 2011-06-12 2011-06-12 goto programacao myNews programacao  Bookmark This Bookmark This

As companies use the Web to build new applications, and as the amount of data generated by them increases, they are reaching the limits of traditional relational databases. A set of alternatives, grouped under the umbrella label NoSQL (for not only SQL), has become more popular and a number of notable use cases, including social networking giants Facebook and Twitter, are leading the way in this arena.

Some of the datasets are enormous: for example, when Visa was looking to process two years' worth of credit card transactions -- some 70 billion of them, -- they turned to a NoSQL solution and were able to cut their processing time from a solid month using traditional relational solutions to just 13 minutes.

So what is NoSQL and why should you bother? SQL (for Structured Query Language) has been around for decades and has plenty of benefits. It's great for centrally managed database schemas, easy ad hoc queries, and data that can be indexed and normalized. There are lots of integrated SQL development environments, reporting tools, and ways to extract, import and transform SQL databases, and SQL has been taught to thousands of software engineers. Most SQL databases can easily run on common Intel hardware with RAM and disk storage in reasonable amounts (250 GB and 1 TB, respectively, are about right).

But SQL also has its limits, especially when you consider how modern Web apps are built. They have to perform and scale well, and handle large collections of documents and odd kinds of data -- and none of that plays to SQL's strengths. Think of your standard SQL database as a series of tables. Each row is a data record and the columns are fields for each record. This works well if the fields are all somewhat similar in terms of length and data types, such as the fields for a typical address record for a customer. But it falls apart when you have large blobs of data, such as a document that has to be attached to a particular record, or a comment field that can be open ended and contain hundreds or thousands of characters.

este é só um excerto do artigo, para aceder ao artigo completo, clique no link em baixo:
this is just a small excerpt from the article, to access the full article please click in the link below:


Subscribe News RSS  Subscribe News Updates by E-mail

myNews <myNews show="rand" cat="programacao" ⁄>

RouterJs: easy routing for your ajax Web applications new ...

RouterJs is a simple router for your ajax web apps. It's build upon History.js which means that Rout (...)

clicks: 14983 14983 2012-05-14 2012-05-14 goto url (new window) haithembelhaj.g... goto myNews programacao

Backbone computed properties new ...

This gist shows one way to implement read- and write-enabled computed properties on a Backbone Model (...)

clicks: 14728 14728 2012-05-13 2012-05-13 goto url (new window) https://gist.gi... goto myNews programacao

Android Query new ...

Android-Query (AQuery) is a light-weight library for doing asynchronous tasks and manipulating UI el (...)

clicks: 14986 14986 2012-05-12 2012-05-12 goto url (new window) code.google.com... goto myNews programacao

HTML5 jQuery Paint Plugin new ...

Websanova Paint is a HTML5 canvas based jQuery plugin. It allows you to free paint on a canvas area (...)

clicks: 25373 25373 2012-05-12 2012-05-12 goto url (new window) websanova.com/t... goto myNews programacao

Create Instagram Filters With PHP new ...

In this tutorial, I'll demonstrate how to create vintage (just like Instagram does) photos with PHP (...)

clicks: 14429 14429 2012-05-12 2012-05-12 goto url (new window) net.tutsplus.co... goto myNews programacao

Sass vs. LESS vs. Stylus: Preprocessor Shootout new ...

CSS3 preprocessors are languages written for the sole purpose of adding cool, inventive features to (...)

clicks: 14203 14203 2012-05-11 2012-05-11 goto url (new window) net.tutsplus.co... goto myNews programacao

Real-time Applications With Node.js and Socket.IO new ...

Hey everyone! Sorry about the long pause since the last blog post, life has been quite hectic for th (...)

clicks: 14902 14902 2012-05-11 2012-05-11 goto url (new window) codingcookies.c... goto myNews programacao

15 Handpicked jQuery Drop Down Menus Tutorials new ...

Here we are presenting another brilliant collection of 15 jQuery navigation menu that you can downlo (...)

clicks: 14001 14001 2012-05-10 2012-05-10 goto url (new window) smashingapps.co... goto myNews programacao