Category: Technology
-
Unix Philosophy in the DB World
There’s a good article about the Unix philosophy in the DB world from the beginning of the year, remarking the importance of simple and standard protocols for the upcoming breed of NoSQL DBs. I thought this is a good follow-up to last week’s Open Source Databases, so here you go!
By
·
-
Realtime Scalable NoSQL with Yahoo! S4
There’s movement in the realtime NoSQL world. As GigaOm reports in Yahoo Open-Sources Real-Time MapReduce, Yahoo! is the first to release a large scale implementation of a more realtime oriented NoSQL system (don’t think it’s Hadoop or even MapReduce based), which will allow to query data pretty much as it’s added to the system. Or…
By
·
-
Open Source Databases Have Come of Age
Matt Benjamin writes about the OSS DB ecosystem in Open Source Databases Have Come of Age, including NoSQL. Good summary!
By
·
-
How Many DBAs Do You Need To Support Databases?
Forrester’s Noel Yuhanna makes a point in How Many DBAs Do You Need To Support Databases? that it may not be the number of DB instances per DBA that counts, but the total size of the DBs managed. His data suggests that a DBA manages DBs worth 5TB of data on average, and that companies…
By
·
-
Create Your Own Oracle TPC-H Playground on Linux
Husnu Sensoy lists in great detail how to Create Your Own Oracle TPC-H Playground on Linux. He doesn’t cover load generators or benchmark tools, just dbgen to generate test data. If you need more, look e.g. for Quest Benchmark Factory, which can create and benchmark all the relevant TPC-x benchmarks, also on DBs other than…
By
·
-
Loading data to SQL Azure the fast way
Here’s how to Load data to SQL Azure the fast way: use BCP or SSIS, and parallelize the loads. With some parallel optimization you’re able to achieve almost similar loading rates from outside Azure, i.e. over the Internet, as from Windows Azure, i.e. through the internal Azure network. Enough said!
By
·
-
NoSQL Basics, Benefits and Best-Fit Scenarios
NoSQL Basics, Benefits and Best-Fit Scenarios has Curt Monash look at NoSQL for the uninitiated, see also his blog for some more comments (him & others) on the topic. Quest appears to also have done some thinking on NoSQL, leading to product announcements as well as introductionary articles such as 10 things you should know…
By
·
-
The Big Data Era: How Data Strategy Will Change
Doug Henschen’s The Big Data Era: How Data Strategy Will Change is another good piece about the future of BI and Big Data (registration required, or ask Google for freely accessible copies of the article). He mentions lots of different companies, their challenges and how they solved them, so good to get an overview of…
By
·
-
Dual BI Architectures: The Time Has Come
In Dual BI Architectures: The Time Has Come, Wayne Eckerson suggests that: As an industry, it’s time we acknowledge the obvious: our traditional data warehousing architectures are excellent for managing reports and dashboards against standard corporate data, but they are suboptimal for managing ad hoc requests against heterogeneous data. We need dual BI architectures: one…
By
·
-
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
·