Oracle manufactures some of the fastest and most robust industrial-grade databases, servers, and storage devices in the industry, but they don’t necessarily perform all the functions that users are looking for today.

Enter Rockset, a six-year-old startup, which has developed a real-time analytics platform for cloud applications, including those from Oracle. The San Mateo, Calif.-based startup announced a new integration with the giant database company on June 1, which it says allows developers to run searches, aggregations and “joins” in time. real on data from Oracle databases.

A growing number of businesses are investing in real-time analytics as the basis for their digital upgrades, particularly in areas such as e-commerce, logistics and delivery tracking, fraud detection systems, health and fitness trackers and recommendation engines.

Oracle databases, although they have become more user-friendly in recent years as the company has moved its base of operations to the cloud, have never been easy to operate and maintain. Using analytics on databases has long been a particularly challenging set of tasks.

“Companies looking to use data from their Oracle databases to power user-facing analytics have traditionally relied on too expensive read replicas or loaded them into slow warehouses,” said Shruti Bhat, Director Rockset product, in a media advisory. “Rockset now ingests real-time change data capture (CDC) streams from Oracle and indexes each field to enable low-latency, high-concurrency analysis without the complexity of traditional approaches. »

As the IT world moves from batch to real-time scanning, Bhat said this release allows developers using Oracle to:

• Run analytical queries in less than a secondincluding joins with other databases, lakes or event streams;
• Get better database performance isolating analytical queries to Rockset, which in turn scales horizontally in the cloud; and
• Power fast microservices using developer SDKs or providing real-time reporting using any of Rockset’s integrations with visualization tools including Tableau, Retool, Redash, and Superset.

Rockset CEO Venkat Venkataramani told VentureBeat that these connections are not provided by APIs, but are fully managed cloud service entities.

“So, let’s say you’re managing your registry database system, which happens to be MySQL, Postgres, MongoDB, or whatever,” Venkataramani said. “You create an account with Rockset. You point us to your MongoDB database, and we have built-in connectors that will ensure we replicate your model data to Rockset in real time. You don’t have to lift a finger; you don’t have to write any piece of code. And that data will be one to two seconds behind the source of truth. This will be true for all your operational databases. This is also true for Kafka and Kinesis and all the data streams you process and accumulate.

“And that’s also true if you happen to accumulate data in your lake, whether it’s S3 or GCS or what have you. And so from all of those sources, we have built-in connectors at the push of a button. When you import the data into Rockset, what it does automatically is index the data into fast SQL tables. And we have a full SQL engine on top of that.

Rockset was founded and built by the team behind the online data infrastructure that powers Facebook (Meta) Newsfeed and Search. Rockset is inspired by the same indexing systems that power cloud-scale real-time analytics, Venkataramani said.

Because new data is ingested in real time, Rockset enables continuous transformations and rollups without the need for batch ETL jobs. Data is automatically indexed in a converged index, providing fast search, aggregations and joins on real-time data, with cloud-native speed and scale, Venkataramani said.

Gartner Research has Rockset competing in the same market as:

• Redis Enterprise Cloud
• Cloudera Enterprise Data Hub
• Databricks Lakehouse Platform
• Vertica Analytics Platform
• Neo4j
• CockroachDB
• YugabyteDB