Tag: NoSQL
-
Using MySQL as NoSQL
Using MySQL as a NoSQL – A story for exceeding 750,000 qps on a commodity server – how to almost achieve double the Memcached performance using a MySQL UDF that bypasses the SQL layer, talks directly to the InnoDB layer. Wonder if the SQL overhead is similar in Oracle or MS SQL Server, and how…
By
·
-
Scalability and Databases
Following up on yesterday’s scalability post, here are some more pointers to interesting articles about scalability and databases: The Complexities of Scale tries to explore the meaning of the term “scale,” specifically in the context of cloud computing. Scale-out vs Scale-up explains, the difference between multi-core concurrency that is often referred to as Scale-Up and…
By
·
-
When do you need ACID?
The recent JPMorgan Chase outage caused by an Oracle RAC block corruption places an old question back on the agenda that gets ignored way too often: How to tell whether you need ACID-compliant transaction integrity. The cost of ACID in large database systems is so high that you should consider moving those parts to simpler,…
By
·
-
NoSQL Primer for RDBMS folks
Chen Shapira apparently went through a similar information gathering and facts finding exercise as I did with NoSQL, but she’s much better at writing it up all in this concise and complete article NoSQL Deep Dive – The Missing White Paper. Highly recommended for all folks who understand SQL RDBMS, and need a quick way…
By
·
-
Teradata, Cloudera team up on Hadoop data warehousing
Does anybody remember as far back as two months ago? That’s when I asked All these connectors being announced makes me think there’s somebody out there with a matrix of RDBMS and NoSQL systems, looking at which combinations don’t have a marketable connector yet so he can be first to market. Now we have another…
By
·
-
The problems with ACID
Danial Abadi throws a lengthy post at the DB world: The problems with ACID, and how to fix them without going NoSQL, introducing an even longer paper that they’re going to present at this months VLDB2010 in Singapore: The Case for Determinism in Database Systems. This is good stuff, basically argueing that the reason people…
By
·
-
Just say No to NoSQL
If today’s title sounds familiar to you, then that’s because yesterday’s title was Just say NoSQL. Here’s a little report on Why NoSQL is bad for startups from a person who has actually tried it, instead of the usual SQL fanboys who tout traditional RDBMS’ because that’s all they know.
By
·
-
Just say NoSQL
Following up on Friday’s post about NoSQL basics, here are two posts getting started with NoSQL. Getting Started with NoSQL focuses on how would someone start learning and using NoSQL databases and the path to follow in this new ecosystem. And Just say NoSQL is a series of quotes from analysts, Web 2.0 developers and…
By
·
-
NoSQL Ecosystem
Jonathan Ellis from the Cassandra project published a fantastic overview of the current NoSQL ecosystem in late 2009. He analyzed 10 popular NoSQL databases along three axes: horizontal scalability, data model and internal persistence design. It’s a great read, and still pretty much valid as of today. I stumbled upon it via Emil Eifrem from…
By
·
-
The End of an Architectural Era
Chen Shapira takes a look at Mike Stonebraker’s 2007 paper The End of an Architectural Era about HStore, his modern implementation of an OLTP database system. Her article It’s the End of the World As We Know It (NoSQL Edition) is a good write-up and analysis for those (such as me) who don’t have time…
By
·