SQL now a dirty word for Oracle, at least in cloudy data warehouses
- Reference: 1616043493
- News link: https://www.theregister.co.uk/2021/03/18/oracle_cloud_data_warehouse/
- Source link:
If that sounds like a bizzarro move for a software giant literally built on SQL, and which has for years courted DBAs, know that Oracle’s justification for its stance is that low-code development is taking off, and users of data warehouses are apt to be line-of-business people for whom coding, or database administration, are not core activities.
[1]
Hence the moniker [2]Next Generation Autonomous Data Warehouse Available , reflecting the presence of Oracle’s Autonomous Database and Big Red’s belief that it has automated many tasks that would require end-users to call upon the services of a DBA when seeking insights from data, and done away with tasks that DBAs find tedious.
Users therefore need not know SQL and DBAs will hopefully find themselves called upon less often.
[3]
Big Red has also added self-service data loading and transformation tools, automated some steps of the machine learning model creation process, and packed in plenty of ready-to-use ML algorithms.
Graph analytics have been re-designed to make them more accessible to beginners.
You wouldn’t know my new database, she goes to another school: Oracle boasts of earthshattering tech the outside world cannot see [4]READ MORE
Oracle reckons this all stacks up well against pure-play data warehouse rivals and asserts that trying to do any of this in a rival cloud would lead to unimaginable complexity, frustration, and cost.
But Big Red also sees a role for its new creation working alongside rival business intelligence tools like Salesforce’s Tableau or Microsoft’s Power BI.
However, Oracle classifies those tools as mere visualisation tools, and believes the heavy lifting of data warehousing – especially data transformation – needs the kind of platforms it provides.
[5]
Just don’t ask a DBA to help drive that platform, ok? And if you are a DBA feel free to let us know if Oracle’s approach is welcome or leaving you with a worrying amount of free time. ®
Get our [6]Tech Resources
[1] https://pubads.g.doubleclick.net/gampad/jump?co=1&iu=/6978/reg_offprem/saas&sz=300x50%7C300x100%7C300x250%7C300x251%7C300x252%7C300x600%7C300x601&tile=2&c=2YFMyzBqSMam9nVY53lL32wAAAIo&t=ct%3Dns%26unitnum%3D2%26raptor%3Dcondor%26pos%3Dtop%26test%3D0
[2] https://www.oracle.com/news/announcement/oracle-adds-innovations-to-cloud-data-warehouse-031721.html
[3] https://pubads.g.doubleclick.net/gampad/jump?co=1&iu=/6978/reg_offprem/saas&sz=300x50%7C300x100%7C300x250%7C300x251%7C300x252%7C300x600%7C300x601&tile=3&c=33YFMyzBqSMam9nVY53lL32wAAAIo&t=ct%3Dns%26unitnum%3D3%26raptor%3Deagle%26pos%3Dmid%26test%3D0
[4] https://www.theregister.com/2021/03/11/oracle_q3_2021/
[5] https://pubads.g.doubleclick.net/gampad/jump?co=1&iu=/6978/reg_offprem/saas&sz=300x50%7C300x100%7C300x250%7C300x251%7C300x252%7C300x600%7C300x601&tile=4&c=44YFMyzBqSMam9nVY53lL32wAAAIo&t=ct%3Dns%26unitnum%3D4%26raptor%3Dfalcon%26pos%3Dmid%26test%3D0
[6] https://whitepapers.theregister.com/
Re: Can you imagine...
Was nothing learned from letting users loose on data in spreadsheets without understanding what they were doing?
Re: Can you imagine...
Look at the mess that is PowerBI. Data "analysis" without understanding the processes that create the data, statistics, statistical relationships, basic data visualisation concepts...
This oracle product sounds very similar, and is not really welcome. Instead of us finding meaningful relationships and changes in the data, we now have to tell mgmt that they have no clue and their analysis is plain wrong. Thank you oh so bloody much!
Not that anybody will listen to people who have a clue. Oh no, their results are so convincing (and the statistics are... not supporting their message, and neither is there a process that can cause any causality they think they discovered)
I need a drink...
Re: Can you imagine...
Was nothing learned from letting users loose on data in spreadsheets without understanding what they were doing?
Fantastic analogy. And no, evidently.
More work not less for DBA's - well for a while
I'm a Project Manager and I hate these products as much as most DBA's.
The naive DBA's who relish receiving fewer calls from marketing will get a brief respite before everything blows up in their faces.
What will come out of this will be sets of dashboards and reports that the business rely on to make strategic and tactical decisions/
As these become more complex they'll take up more and more CPU cycles and take longer and longer to run until a DBA is asked to 'just tune them'.
Once the DBA looks at the half dozen queries generated under the covers by the BI product and optimized them what will come out will be a completely different set of results which will then need to be explained. Of course the person using the BI product will swear that their results are corrupt and the 20 year experienced DBA has got it wrong.
This will be followed by 3 months of strife with meeting after meeting being called to try and find a way to provide the original results before finally someone is fired/ moved / demoted
The victim will vary depending of the size of the organisation / seniority of both partners and the impact on the share price of publicizing the fact that the sales forecasts for next year are accidentally inflated by 130%
Re: More work not less for DBA's - well for a while
This sounds so familiar. At one employer I fixed several reporting systems that had been producing incorrect statistics, and explained to the sales and management why the data had been incorrect. But the incorrect data had suggested much healthier figures that were reported to existing and potential clients. Management bonuses were also based on the false figures. So I was ordered to break the system so sales could continue lying to the clients and managers could get their undeserved bonuses. Suffice to say that was a reflection of company culture in general, so I no longer work there.
How long before...
SQL access to an Oracle Instance becomes a £100,000 per year option?
Larry needs a new planet so anything to give him the finds. May I suggest Uranus? coz he can shove this up his you know where.
Lol - state if art, after period of phenomenal fragmentation, is now consolidating aroud, yes you guessed it, SQL!
Not the only dirty word
Oracle has been a dirty word for MySQL users (and Java devs) for quite some time.
Re: Not the only dirty word
Oracle has been a dirty word for MySQL users (and Java devs) users for quite some time. FTFY
another instance of FAIL
From "easy to read,write and understand" code in COBOL to SQL itself, history has shown the manglement and PHB classes are completely incapable of writing useful anything and worse, regard such mundane simple things are for the peasants, not important process drones like themselves.
Can you imagine...
Wide Area No Knowledge Access (W. A. N. K. A.) where massed middle managers play with data all day to try and improve their carrer prospects. I would imagine that DBAs will be fully employed tydying up assorted tangled messes whilst crazy "non query" queries drag everything into the gutter.