Splice Machine revs up Derby for SQL-on-Hadoop system

Are you sitting down? What if you could replace Oracle for Hadoop. WHAT THEN?


Startup Splice Machine has revealed its plan to take on database incumbents by letting people run a relational database management system on top of Hadoop's resilient free file system.

The company believes that where other SQL-on-Hadoop companies, like DrawnToScale, have failed, it will succeed. With its launch this week of a free and a paid-for version of its tech it hopes to convince people that by pairing the Hadoop File System (HDFS) with the Apache Derby Java-based database and the HBase Hadoop database and some other tech it can show a convincing speed-up over typical databases while costing less than typical providers.

But, given the large sums of money that have been poured into traditional paid-for databases like DB2, Oracle's suite, and SQL Server, along with powerful open source systems like MySQL and PostgreSQL, we find ourselves wondering what Hadoop can add.

"With the massive growth in data across all companies, traditional RDBMSs like MySQL and Oracle are either hitting the wall and having to prune data or becoming prohibitive to scale up on servers that can cost millions of dollar each," explained Splice Machine's chief executive Monte Zweben in an email with El Reg.

"Companies need to replace these struggling databases with a scale-out RDBMS. Scale-out based on Hadoop technology is very attractive because it has been proven to scale out to petabytes, has an extremely active developer community, has become the de facto standard for a distributed file system, and has an extensive ecosystem of analytical and data management tools."

The company is running Apache Derby on top, which is a "mature and stable" relational database management system with ANSI-99 SQL support. The tech was first developed by a company named Cloudscape which was bought by Informix in 1999, which was then bought by IBM in 2001, and IBM released Derby as open source in 2004.

"We do not see it as a fringe Apache project at risk of losing community support," Zweben explains. "In any case, Splice Machine's dependence on the Apache Derby community is minimal. As mentioned above, we have significantly modified the planner, optimizer, and excecutor to take advantage of the distributed infrastructure of HBase."

The Splice Machine system has a bevy of desirable characteristics, such as ACID transactions. It is designed to deal with both Online Analysis Processing (OLAP) and Online Transaction Processing (OLTP) tasks.

As for performance, Zweben says "on simple reads and writes, we provide performance in the low 10s of milliseconds, which is more than fast enough to power real-time applications and websites. We have seen over 10x price/performance improvement over existing RDBMSs such Oracle and MySQL."

"We can't reveal the name of the database, but we recently increased query performance against a clustered 20TB RDBMS (e.g., Oracle RAC, IBM DB2) by 3x-7x. For instance, one query that used a where clause of insert over 3M rows took 180 sec on the RDBMS, but it took only 26 sec or 7x faster on Splice Machine. These results were achieved on hardware that cost 75% less than the RDBMS cluster," he said

The free version of Splice Machine gives companies all the tech features but no support other than access to forums and upgrades. To try it out, companies must be less than five years old and have less than $10m in revenues.

The paid version, the "Enterprise Edition" comes with broad, round-the-clock support options and a guarantee to respond to problems in as little as one hour from when they are reported. It costs $5,000 per node, per year. ®


Other stories you might like

  • NASA's InSight doomed as Mars dust coats solar panels
    The little lander that couldn't (any longer)

    The Martian InSight lander will no longer be able to function within months as dust continues to pile up on its solar panels, starving it of energy, NASA reported on Tuesday.

    Launched from Earth in 2018, the six-metre-wide machine's mission was sent to study the Red Planet below its surface. InSight is armed with a range of instruments, including a robotic arm, seismometer, and a soil temperature sensor. Astronomers figured the data would help them understand how the rocky cores of planets in the Solar System formed and evolved over time.

    "InSight has transformed our understanding of the interiors of rocky planets and set the stage for future missions," Lori Glaze, director of NASA's Planetary Science Division, said in a statement. "We can apply what we've learned about Mars' inner structure to Earth, the Moon, Venus, and even rocky planets in other solar systems."

    Continue reading
  • The ‘substantial contributions’ Intel has promised to boost RISC-V adoption
    With the benefit of maybe revitalizing the x86 giant’s foundry business

    Analysis Here's something that would have seemed outlandish only a few years ago: to help fuel Intel's future growth, the x86 giant has vowed to do what it can to make the open-source RISC-V ISA worthy of widespread adoption.

    In a presentation, an Intel representative shared some details of how the chipmaker plans to contribute to RISC-V as part of its bet that the instruction set architecture will fuel growth for its revitalized contract chip manufacturing business.

    While Intel invested in RISC-V chip designer SiFive in 2018, the semiconductor titan's intentions with RISC-V evolved last year when it revealed that the contract manufacturing business key to its comeback, Intel Foundry Services, would be willing to make chips compatible with x86, Arm, and RISC-V ISAs. The chipmaker then announced in February it joined RISC-V International, the ISA's governing body, and launched a $1 billion innovation fund that will support chip designers, including those making RISC-V components.

    Continue reading
  • FBI warns of North Korean cyberspies posing as foreign IT workers
    Looking for tech talent? Kim Jong-un's friendly freelancers, at your service

    Pay close attention to that resume before offering that work contract.

    The FBI, in a joint advisory with the US government Departments of State and Treasury, has warned that North Korea's cyberspies are posing as non-North-Korean IT workers to bag Western jobs to advance Kim Jong-un's nefarious pursuits.

    In guidance [PDF] issued this week, the Feds warned that these techies often use fake IDs and other documents to pose as non-North-Korean nationals to gain freelance employment in North America, Europe, and east Asia. Additionally, North Korean IT workers may accept foreign contracts and then outsource those projects to non-North-Korean folks.

    Continue reading
  • Google opens the pod doors on Bay View campus
    A futuristic design won't make people want to come back – just ask Apple

    After nearly a decade of planning and five years of construction, Google is cutting the ribbon on its Bay View campus, the first that Google itself designed.

    The Bay View campus in Mountain View – slated to open this week – consists of two office buildings (one of which, Charleston East, is still under construction), 20 acres of open space, a 1,000-person event center and 240 short-term accommodations for Google employees. The search giant said the buildings at Bay View total 1.1 million square feet. For reference, that's less than half the size of Apple's spaceship. 

    The roofs on the two main buildings, which look like pavilions roofed in sails, were designed that way for a purpose: They're a network of 90,000 scale-like solar panels nicknamed "dragonscales" for their layout and shimmer. By scaling the tiles, Google said the design minimises damage from wind, rain and snow, and the sloped pavilion-like roof improves solar capture by adding additional curves in the roof. 

    Continue reading
  • Pentester pops open Tesla Model 3 using low-cost Bluetooth module
    Anything that uses proximity-based BLE is vulnerable, claim researchers

    Tesla Model 3 and Y owners, beware: the passive entry feature on your vehicle could potentially be hoodwinked by a relay attack, leading to the theft of the flash motor.

    Discovered and demonstrated by researchers at NCC Group, the technique involves relaying the Bluetooth Low Energy (BLE) signals from a smartphone that has been paired with a Tesla back to the vehicle. Far from simply unlocking the door, this hack lets a miscreant start the car and drive away, too.

    Essentially, what happens is this: the paired smartphone should be physically close by the Tesla to unlock it. NCC's technique involves one gadget near the paired phone, and another gadget near the car. The phone-side gadget relays signals from the phone to the car-side gadget, which forwards them to the vehicle to unlock and start it. This shouldn't normally happen because the phone and car are so far apart. The car has a defense mechanism – based on measuring transmission latency to detect that a paired device is too far away – that ideally prevents relayed signals from working, though this can be defeated by simply cutting the latency of the relay process.

    Continue reading
  • Google assuring open-source code to secure software supply chains
    Java and Python packages are the first on the list

    Google has a plan — and a new product plus a partnership with developer-focused security shop Snyk — that attempts to make it easier for enterprises to secure their open source software dependencies.

    The new service, announced today at the Google Cloud Security Summit, is called Assured Open Source Software. We're told it will initially focus on some Java and Python packages that Google's own developers prioritize in their workflows. 

    These two programming languages have "particularly high-risk profiles," Google Cloud Cloud VP and GM Sunil Potti said in response to The Register's questions. "Remember Log4j?" Yes, quite vividly.

    Continue reading
  • Rocket Lab is taking NASA's CAPSTONE to the Moon
    Mission to lunar orbit is further than any Photon satellite bus has gone before

    Rocket Lab has taken delivery of NASA's CAPSTONE spacecraft at its New Zealand launch pad ahead of a mission to the Moon.

    It's been quite a journey for CAPSTONE [Cislunar Autonomous Positioning System Technology Operations and Navigation Experiment], which was originally supposed to launch from Rocket Lab's US launchpad at Wallops Island in Virginia.

    The pad, Launch Complex 2, has been completed for a while now. However, delays in certifying Rocket Lab's Autonomous Flight Termination System (AFTS) pushed the move to Launch Complex 1 in Mahia, New Zealand.

    Continue reading
  • Alibaba Cloud adds third datacenter in Germany
    More Euro-presence than any other Chinese company, but still nowhere near Google or AWS

    Alibaba has pulled ahead of its Chinese rivals in Europe with the opening of a third datacenter in Germany.

    The company said the Frankfurt datacenter serves cloud computing products to Europe and "adheres to the highest security standards and the strict compliance regulations set out in the Cloud Computing Compliance Controls Catalog (C5) in Germany."

    The addition brings Alibaba Cloud to a network of 84 availability zones in 27 regions worldwide. The company's first European cloud center arrived in Frankfurt in 2016.

    Continue reading

Biting the hand that feeds IT © 1998–2022