Want to read Slashdot from your mobile device? Point it at m.slashdot.org and keep reading!

 



Forgot your password?
typodupeerror
×
Databases Oracle Open Source

Oracle Outperformed? TPC Benchmarks Show Alibaba's OceanBase Performs Twice As Well (tpc.org) 46

The Transaction Processing Performance Council is a many-decades-old nonprofit that defines transaction processing and database benchmarks and shares its performance results with the industry.

Long-time Slashdot reader hackingbear says they've just released some surprising news: The TPC organization reported on October 5 that OceanBase, an open-source relational database from Ant Financial, a business unit of Chinese e-commerce giant Alibaba Group, has topped the TPC-C benchmark, more than doubling the score achieved by Oracle Corp. which had held the world record for the past 9 years.

OceanBase v2.2 Enterprise Edition with Partitioning scored at 60,880,800, while Oracle Database 11g R2 Enterprise Edition w/RAC and Partitioning achieved 30,249,688.

TPC Benchmark C is industrial standard OLTP benchmark, measuring on-line transactions per minute (tpmC).

This discussion has been archived. No new comments can be posted.

Oracle Outperformed? TPC Benchmarks Show Alibaba's OceanBase Performs Twice As Well

Comments Filter:
  • by bmimatt ( 1021295 ) on Sunday October 06, 2019 @02:46PM (#59276296)
    The repo linked in the TFA has last been pushed to 3 years ago. What kind of 'news' is this?
  • by bogaboga ( 793279 ) on Sunday October 06, 2019 @02:51PM (#59276310)

    The TPC organization reported on October 5 that OceanBase, an open-source relational database from Ant Financial, a business unit of Chinese e-commerce giant Alibaba Group, has topped the TPC-C benchmark, more than doubling the score achieved by Oracle Corp. which had held the world record for the past 9 years.

    Isn't it "common knowledge" that China simple copies?

    If so, why are those Chinese kinda doing so well - in so many fields?

    I think we should be concerned that our government simply finds time and effort to foment chaos in distant lands instead of doing what will surely develop the ordinary folk.

    • Surely develop the ordinary folk? Yeah, you sound like an American. No agitprop here.
    • Isn't it "common knowledge" that China simple copies?

      No - the “common knowledge” generally talks about stealing rather than copying.

      Deciding whether or not that’s a fair assessment is left as an exercise for the reader.

    • by xlsior ( 524145 ) on Sunday October 06, 2019 @05:23PM (#59276670)
      Isn't it "common knowledge" that China simple copies?

      So did Japan.

      Until they didn't, and then they ate the US car and electronics industry for lunch.
      • How you do you think that happened?

        Total Quality Management (TQM) [inc.com]

        W. Edwards Deming, trained as a mathematician and statistician, went to Japan at the behest of the U.S. State Department to help Japan in the preparation of the 1951 Japanese Census. . . . A series of lectures took place in 1950 under the auspices of the Japanese Union of Scientists and Engineers (JUSE). Deming had developed a critical view of production methods in the U.S. during the war, particularly methods of quality control. . . . He found Japanese executive receptive to his ideas. Japan began a process of implementing what came to be known as TQM. They also invited Joseph Juran to lecture in 1954; Juran was also enthusiastically received.

        Japanese application of the method had significant and undeniable results manifesting as dramatic increases in Japanese product quality—and Japanese success in exports. This led to the spread of the quality movement across the world. In the late 1970s and 1980s, U.S. producers scrambled to adopt quality and productivity techniques that might restore their competitiveness. Deming's approach to quality control came to be recognized in the United States, and Deming himself became a sought-after lecturer and author.

      • I'd rather have the US than Japanese economy for the last 20 years.
    • by AmiMoJo ( 196126 )

      Education is cheaper and there are well over a billion people in China. It was only a matter of time until they got competitive.

  • Old data (Score:5, Informative)

    by fleabay ( 876971 ) on Sunday October 06, 2019 @02:53PM (#59276314)
    The table linked in the article has some very old data/systems (listed as historical data). #2 is from a 2011 system.
  • Oracle hasn't submitted a new run in almost a decade. Of course you can build a new huge system today and make it run more TPC. I think Oracle is shit, but this... this is just odd. Plus the 'open source' database hasn't been updated/open in 6 years either.
  • Cool... (Score:4, Funny)

    by QuietLagoon ( 813062 ) on Sunday October 06, 2019 @03:04PM (#59276344)
    ... maybe I should look at moving my album and compact disc database out of dBase II and into OceanBase.
  • I'd be de last to not despise Oracle,

    but I remember when MySQL came out and was preferred "because it is fast", even though it had unacceptable shortcomings and really was not in the same league.

    Since I never heard of OceanBase ... anyone here who used it in a production environment?

    • No. And it won't be an alternative even if someone does. Running a high score on a TP-C benchmark has never actually been on any requirements list I've been involved in.

    • Have you ever tried setting up oracle? Especially on Linux? Mysql being fast isn't just that it used to not have things like ACID. It's also relatively quick setup and low maintenance.
      • [MySQL has] also relatively quick setup and low maintenance.

        PostgreSQL also has very easy setup, very low maintenance, and excellent performance. For example, one of the primary tables in my database has 146.3 million records. Cold, uncached, lookups for a record group (a record group typically has somewhere between 13-19 tuples) on that table are about 1.9 milliseconds. Warm, cached, lookups are approximately 0.7 milliseconds.

        We used to have Oracle everywhere, but the company and the product were such horrendous messes that we ripped it out and replaced it with

    • Besides some outside bank customers, OceanBase is primarily used to support the core trading system of Alipay, one of the most popular e-payment services in China provided by Alibaba. On 2017 Nov 11(Alibaba shopping festival), the system's throughput reached 42,000,000 queries per second or 276,000 user transactions per second.
  • Power consumption is hidden literally for all but HP entries.

    Their solution costs $0.87/tpmC, by far the leader in initial cost is a single Dell PowerEdge T620 running SQL Anywhere 16 at $0.19/tpmC. So what's the power consumption? The information is useless without Watts/KtpmC [tpc.org].

    Everyone but HP is providing worthless information. How backwards.

  • by dbase4 ( 1074555 ) on Sunday October 06, 2019 @07:25PM (#59276850)
    Check the hardware specs on the TPC results page, the comparison is definitely not apples for apples. The oracle result is from a 2010 benchmark. Oracle: 1728 cores (SPARC T3 @ 1.65 GHz ) Cloudbase: 6720 cores (Intel Xeon Platinum 8163 @ 2.50GHz )
    • The performance is the 1st, then effectiveness. If you cannot reach the consumer's performance requirement, you are out no matter how effective you are.
  • Rumor was that, after Oracle bought up the rights to DEC's Rdb database from Compaq (or was it from HP... ahh, who cares at this point), their engineers had it running in their lab and were surprised at just how badly it was kicking Oracle's flagship product's ass. Now I wonder... did a copy of Rdb make its way to Alibaba?

  • by sad_ ( 7868 ) on Monday October 07, 2019 @06:18AM (#59277868) Homepage

    benchmarks are mostly bragging right.
    at this point i think the most interesting feature of any db is that it isn't from oracle.

  • It says OceanBase is open source; but the copy on github is ancient.
    Does anyone know if they went closed-source or where the actual current repository is?

    • Using google translate on https://oceanbase.alipay.com/ [alipay.com] support and docs sections gives the current version as 1.3 and there is an rpm for avaiable for RHEL, described as a 'trial version' so the clear implication is that current versions are not FOSS.
      It *appears* on the surface to be both currently live and a professional product but that's just my impression from the website. I'm thinking that people outside China have not heard of it because as far as I can see support, docs etc. only seem to be availabl

      • by BuGless ( 31232 )

        Googling around I find OceanBase 2.2 to be the latest, perhaps. It is supposed to support Oracle/PostgreSQL dialects now too. But if it's not open source (anymore), there is no point in looking into it.

    • The Github repo is no longer maintained since version 0.4, which is a very very old version with an old architecture. The latest version is OceanBase 2.2, which is not open-sourced yet.
      • by BuGless ( 31232 )

        The latest version is OceanBase 2.2, which is not open-sourced yet.

        You mention "yet" as in "I know that it is scheduled to be open sourced" ?

Our policy is, when in doubt, do the right thing. -- Roy L. Ash, ex-president, Litton Industries

Working...