New standard test of Big Data bang per system buck rolls out. Big Security for Big Data There's a new big data benchmark in town: TPC-DS.
The Transaction Processing Performance Council still doesn't know how to do its own abbreviation after 24 years of existence, but it does know a thing or two about getting IT hardware and software vendors together and hammering out benchmark tests and pricing metrics to help server, storage, database, and middleware buyers try to figure out what they might want to buy and what kind of value they might expect from what they buy. The TPC was founded in 1988 following an uproar in the server racket after IBM ran its own RAMP-C COBOL benchmark test on its AS/400 and System/38 minicomputers, pitting them against a bunch of Hewlett-Packard HP 3000s and Digital Equipment VAXes and showing (of course) that the IBM machines won out. On the decision support/data warehousing front, TPC-D was the original benchmark, but fighting among the vendors in the TPC consortium caused it to be split into the TPC-H and TPC-R.
Got that? A Visual Explanation of SQL Joins. I love the concept, though, so let's see if we can make it work.
Assume we have the following two tables. Table A is on the left, and Table B is on the right.
ObjectDatabases. SQLite.