EDB tries to crowbar graph, JSON, and time-series data models into PostgreSQL – but can they pull it off?

Specialist databases will still be necessary, analyst says

EDB, a prominant backer of the PostgreSQL open-source database, expects to focus on graph, JSON, and time-series data in the upcoming autumn release. Analysts, however, are sceptical about its ability to optimise for different data models ahead of built for purpose databases.

Last week, EDB announced a 59 per cent increase in annual recurring revenue, although being privately held it can pick and choose which financial metrics to release. Its team has grown by nearly half, to 300, however that is dwarfed by comparable open-source-supporting firms like Red Hat, with 13,000 employees.

Still, EDB said it sees the database market as up for open-source takeover in the same way Red Hat helped unsettle the status quo in the enterprise Unix market over the last two decades.

Speaking to The Register, EDB CEO Ed Boyajian, former Red Hat veep and general manager of North America, said the company is pushing the community's efforts to strengthen the features supporting JSON and JSON-B, including the alignment of PostgreSQL's JSON capabilities with the SQL standard. Similar work would support network-like graph data in a single database.

He said EDB wanted to help users support these data models without the need to reach for specialist databases like Couchbase or Neo4j, for example.

"The idea is that they can use a common SQL standard, and in a single database we see an increasing appetite among users," he said.

Postgres was first proposed in 1986 [PDF] as a successor to Ingres. PostgreSQL is released under the OSI-approved PostgreSQL Licence. As a relational database with an object-relational data model, it is easy to extend Postgres to work on new data types such as graph and JSON, Boyajian said.

In fact, Postgres has supported JSON documents, for example, since at least 2013, in the 9.3 release.

EDB is promising to help build on these features into PostgreSQL 14, expected in the third calendar quarter, to make multiple data models addressable in SQL. The same would apply to graph and time-series data, which is supported by its own family of specialist databases, Boyajian said.

"The multimodal nature of Postgres is really changing the landscape," h told us. "There are time-series, graph, and document database companies, but these are all extensions inside of Postgres and I think that's one of its inherent superpowers."

EDB is not alone in trying to build new data models into a relational database. Last year, Oracle released its 21c database, which Big Red said would offer JSON as a native data type. MariaDB, another open-source relational database, also supports JSON.

Carl Olofson, IDC research vice president for data management software, doubted either approach would provide the whole answer for those wanting to make use of unstructured or graph data part or their enterprise stack.

"Optimising for relational data management is fundamentally different from optimising for other models, such as document or graph, so handling these other models very well requires an alternative parallel data access and management approach, not just supporting non-relational structures in what is basically a tabular scheme," he said.

Although EDB and other PostgreSQL contributors may be addressing these issues in the coming release, admins may still want to look at specialist tools for different data types.

"For very demanding edge-data-handling databases, an application that uses a pure-play JSON database, such as MongoDB or Couchbase, may still be the way to go," Olofson said. "For deep and complex graph analytics, using a native system such as Neo4j or TigerGraph may be called for. If one wishes to retain JSON document and graphs, and use them in combination with relational tables, then a multi-model approach makes sense, and the PostgreSQL option could work out quite well."

bill shock

Banking software firm tiptoes off to the cloud with MariaDB after $2m Oracle licence shocker


The IDC analyst noted PostgreSQL's recent popularity among both open-source users wanting to avoid dependence on MySQL and those migrating away from proprietary databases.

Last year, German insurance services firm BG-Phoenics moved from IBM Db2 databases to the EDB iteration of Postgres, while Indian credit reference agency TransUnion CIBIL moved from Oracle in the same direction.

But PostgreSQL is not the only open-source database appealing to proprietary users. Financial services software specialist FNI moved to MariaDB to avoid $2m Oracle licensing fees, for example.

Hence EDB's play to be more than just an Oracle or Db2 replacement. Whether or not promises to offer enhancements to tackle multi-model data in a single SQL database come to fruition, users will need to see what EDB and the developer community come up with later this year. ®

Other stories you might like

  • North Korea pulled in $400m in cryptocurrency heists last year – report

    Plus: FIFA 22 players lose their identity and Texas gets phony QR codes

    In brief Thieves operating for the North Korean government made off with almost $400m in digicash last year in a concerted attack to steal and launder as much currency as they could.

    A report from blockchain biz Chainalysis found that attackers were going after investment houses and currency exchanges in a bid to purloin funds and send them back to the Glorious Leader's coffers. They then use mixing software to make masses of micropayments to new wallets, before consolidating them all again into a new account and moving the funds.

    Bitcoin used to be a top target but Ether is now the most stolen currency, say the researchers, accounting for 58 per cent of the funds filched. Bitcoin accounted for just 20 per cent, a fall of more than 50 per cent since 2019 - although part of the reason might be that they are now so valuable people are taking more care with them.

    Continue reading
  • Tesla Full Self-Driving videos prompt California's DMV to rethink policy on accidents

    Plus: AI systems can identify different chess players by their moves and more

    In brief California’s Department of Motor Vehicles said it’s “revisiting” its opinion of whether Tesla’s so-called Full Self-Driving feature needs more oversight after a series of videos demonstrate how the technology can be dangerous.

    “Recent software updates, videos showing dangerous use of that technology, open investigations by the National Highway Traffic Safety Administration, and the opinions of other experts in this space,” have made the DMV think twice about Tesla, according to a letter sent to California’s Senator Lena Gonzalez (D-Long Beach), chair of the Senate’s transportation committee, and first reported by the LA Times.

    Tesla isn’t required to report the number of crashes to California’s DMV unlike other self-driving car companies like Waymo or Cruise because it operates at lower levels of autonomy and requires human supervision. But that may change after videos like drivers having to take over to avoid accidentally swerving into pedestrians crossing the road or failing to detect a truck in the middle of the road continue circulating.

    Continue reading
  • Alien life on Super-Earth can survive longer than us due to long-lasting protection from cosmic rays

    Laser experiments show their magnetic fields shielding their surfaces from radiation last longer

    Life on Super-Earths may have more time to develop and evolve, thanks to their long-lasting magnetic fields protecting them against harmful cosmic rays, according to new research published in Science.

    Space is a hazardous environment. Streams of charged particles traveling at the speed of light, ejected from stars and distant galaxies, bombard planets. The intense radiation can strip atmospheres and cause oceans on planetary surfaces to dry up over time, leaving them arid and incapable of supporting habitable life. Cosmic rays, however, are deflected away from Earth, however, since it’s shielded by its magnetic field.

    Now, a team of researchers led by the Lawrence Livermore National Laboratory (LLNL) believe that Super-Earths - planets that are more massive than Earth but less than Neptune - may have magnetic fields too. Their defensive bubbles, in fact, are estimated to stay intact for longer than the one around Earth, meaning life on their surfaces will have more time to develop and survive.

    Continue reading

Biting the hand that feeds IT © 1998–2022