Oracle rewrites 'the brain' of its database to take on SAP

DRAM guzzling add-on brings Oracle's crown jewel up to date


Oracle's future is its rival's past, but the database giant isn't worried because the changes it has made to let its database store data in speedy consumer memory afford far more backwards compatibility than does SAP HANA.

With the launch of the Oracle Database In-Memory tech on Tuesday, the world's most influential data-management company has closed a gap with rival SAP and thrown further doubt on some of the value claimed by newer, younger startups.

The new software lets admins of Oracle's "12c" database easily shift data into the DRAM memory of computer servers, which is a much more responsive storage medium than traditional spinning disk or pricey solid-state drives.

With the upgrade, Oracle has tightened competition with IBM, Microsoft, and – most significantly – its arch-rival SAP, which introduced an "in-memory" processing system named HANA back in late 2010.

The difference between HANA and Oracle's new software is that Ellison & Co.'s "in-memory" option is compatible with all existing Oracle apps built via 12c, letting admins get the advantages of memory without having to drastically rewrite entire apps.

"We've implemented this so that you have to do nothing to your applications to test it out," said Oracle VP of product management Tim Shetler in a call with El Reg. "That was purely so people could adopt it easily, and not have to open up the app and be forced to make changes. Everything they could have done previously is still accessible when running with the in-memory option."

Oracle has also let the system tier across different memory mediums within the same cluster. "Even though this is memory-optimized database tech, there's no requirement entire database or dataset be in memory to use it," said Shetler. "We also have the ability to spread a large dataset across different tiers of storage. If you run a query against that data it will all transparently come back."

So, what's different?

"A lot of the transparency comes through enhancements we've had to make to the optimizer in the database," he said. "The optimizer is always the one – the brain – that sees a SQL statement and figures out what is the fastest way to analyze this request. The optimizer will decide based on the request which direction to route the request."

As the optimizer is a fundamental part of the database, Oracle has spent several years working on adding this capability without breaking anything. Subtle things like making sure "that if one app had made a modification to the row store and that data that's been modified or is in the in-memory columnar store, we have to synchronizer those two," are why it's taken Oracle several years to catch up to SAP HANA.

Overall, introducing the tech meant "the disruption was fairly minimal," Shetler said. "It was like grafting an in-memory store onto an existing set of plumbing and foundation and infrastructure."

Pricing was not disclosed. ®

Broader topics


Other stories you might like

  • China’s COVID lockdowns bite e-commerce players
    CEO of e-tail market leader JD perhaps boldly points out wider economic impact of zero-virus stance

    The CEO of China’s top e-commerce company, JD, has pointed out the economic impact of China’s current COVID-19 lockdowns - and the news is not good.

    Speaking on the company’s Q1 2022 earnings call, JD Retail CEO Lei Xu said that the first two years of the COVID-19 pandemic had brought positive effects for many Chinese e-tailers as buyer behaviour shifted to online purchases.

    But Lei said the current lengthy and strict lockdowns in Shanghai and Beijing, plus shorter restrictions in other large cities, have started to bite all online businesses as well as their real-world counterparts.

    Continue reading
  • Foxconn forms JV to build chip fab in Malaysia
    Can't say when, where, nor price tag. Has promised 40k wafers a month at between 28nm and 40nm

    Taiwanese contract manufacturer to the stars Foxconn is to build a chip fabrication plant in Malaysia.

    The planned factory will emit 12-inch wafers, with process nodes ranging from 28 to 40nm, and will have a capacity of 40,000 wafers a month. By way of comparison, semiconductor-centric analyst house IC Insights rates global wafer capacity at 21 million a month, and Taiwanese TSMC’s four “gigafabs” can each crank out 250,000 wafers a month.

    In terms of production volume and technology, this Malaysian facility will not therefore catapult Foxconn into the ranks of leading chipmakers.

    Continue reading
  • 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
  • Elon Musk says Twitter buy 'cannot move forward' until spam stats spat settled
    A stunning surprise to no one in this Solar System

    Elon Musk said his bid to acquire and privatize Twitter "cannot move forward" until the social network proves its claim that fake bot accounts make up less than five per cent of all users.

    The world's richest meme lord formally launched efforts to take over Twitter last month after buying a 9.2 per cent stake in the biz. He declined an offer to join the board of directors, only to return asking if he could buy the social media platform outright at $54.20 per share. Twitter's board resisted Musk's plans at first, installing a "poison pill" to hamper a hostile takeover before accepting the deal, worth over $44 billion.

    But then it appears Musk spotted something in Twitter's latest filing to America's financial watchdog, the SEC. The paperwork asserted that "fewer than five percent" of Twitter's monetizable daily active users (mDAUs) in the first quarter of 2022 were fake or spammer accounts, which Musk objected to: he felt that figure should be a lot higher. He had earlier proclaimed that ridding Twitter of spam bots was a priority for him, post-takeover.

    Continue reading

Biting the hand that feeds IT © 1998–2022