Technology

Evolution of Autonomous Data Warehouse from Oracle: No need for SQL anymore

Oracle on Wednesday unveiled the latest version of its Autonomous Data Warehouse, its data warehouse, which features drag-and-drop user interfaces and AutoML features that make it significantly easier to use. Without SQL, analysts and business users should be able to operate the tool without the help of the IT team or data scientists.

According to Oracle, these upgrades make data warehousing accessible to all industries. From then on, “the market is opening up massively,” Steven Zivanic, Oracle’s Global VP of Database and Autonomous Services, told . He compares this development to the introduction of PowerPoint in business.

The PowerPoint database

“Years ago, there were specialist teams within large companies that made your PowerPoints, or that made physical slides for projectors,” Zivanic said. “These teams no longer exist, do they? They have been replaced by PowerPoint or Apple Keynote software ….. (our software) is just another logical extension of this progression of simplicity . ”

The Autonomous Data Warehouse Cloud, introduced in 2018, was Oracle’s first autonomous database-based service. It got its start with machine learning to enable fast and easy data warehousing. The cloud platform competes with other SQL data warehousing offerings, such as Snowflake and AWS Redshift.

The latest version offers drag-and-drop interfaces for loading, transforming, and cleaning data.

adw-oracledatabaseactions-dataload.png

No more need to ask questions?

The tool also helps users to automatically create models, as well as automatically discover models to generate information.

“Traditionally, with information systems, you have to ask them a question,” Neil Mendelson, vice president of Big Data and Advanced Analytics at Oracle, told . “You must have known yourself: One, that you are looking for a needle, and Two, that it may be in a haystack.”

In contrast with this new product, he added, “we are looking for patterns and anomalies, that we can point them out to the user. And that maybe something that no one has ever thought of looking for. ”

For business users

The platform update also features self-service tools to help both data analysts and business managers easily prepare data sets, build AutoML-guided machine learning models, and deploy data sets. models.

With these tools, says Mendelson, the user does not need to know which algorithm to use with a dataset. He compares the capacity of the supply to a car: just because a driver knows how to drive does not mean he knows the algorithm that determines the air / fuel ratio of the car’s engine. “Does anyone care? Of course not,” he said. “You get in the car, put gas on, and drive off. So let’s see how we can do that for a data analyst.”

For developers who want to deploy their knowledge in applications, Oracle offers Oracle APEX (Application Express) Application Development, a low-code application development tool integrated directly into its database, as well as RESTful services.

“We’re opening up this area to a much larger audience that allows people to serve themselves… which makes the business a lot more nimble,” Mendelson said.

Source: “.com”

Back to top button