#OOW2019 and UKOUG Analytics Modernisation Summit

Posted on By Adrian Ward

I think my neighbour is stalking me as she’s been googling my name on her computer. I saw it through my telescope last night.

#OOW2019 has been and gone.  But UKOUG Analytics Modernisation Summit will be upon us soon. See the agenda here.

Are you going to the Analytics Modernisation Summit???

Join us the night before (Tuesday 7th October) at 6pm for a few drinks and networking.

We’ll be here.

Look forward to seeing you there if you’re going.

Here are a few blogs, posts and videos in the meantime.

Blogs of the week

  1. Using Web Worker for Long Tasks in Oracle JET 

Andrej Baranovskij starts by writing, ” JavaScript app runs in a single thread. This means if there is a long-running resource-intensive operation – the thread will be blocked and the page will stay frozen until operation completes. Obviously, this is not user-friendly and such behavior should be avoided. We can use Web Workers, through Web Workers we could run long-running operations in separate threads, without blocking the main thread. Code running in Web Worker doesn’t have access to UI DOM, this means logic coded in Web Worker should operate with logic which is not directly related to UI.”

2. Free Oracle Cloud: 4. Connecting with SQL Developer Web to ATP

Dimitri Gielis says, “This post is part of a series of blog posts on the Best and Cheapest Oracle APEX hosting: Free Oracle Cloud.”

3. OOW19: WebLogic News

Dirk Nachbar says, “During the Oracle Open World 2019 were some announcements regarding Oracle WebLogic Server.
The last year announced WebLogic Server 19c for Q1/2019 disappeared …
There will be no WebLogic Server 13 Release …
But there will be:

  • WebLogic Server 12.2.1.4, which should come up shortly, as usual what shortly means in Oracle terms is not clearly defined 🙂
  • The WebLogic Server 12.2.1.4 Release will be the Final Maintenance Release for 12.2.1.x, so don’t expect too many new features
  • BETA Program for WebLogic Server 14.1.1 is announced and to be started shortly.
  • Oracle WebLogic Server on Microsoft Azure IaaS
    • Microsoft will offer from end of October 2019 going Oracle WebLogic Server 12.2.1.3.0 on Oracle Linux 7.6 in the Azure Cloud. “

4. Extending in-lists

Connor McDonald opens his blog with, “A well known “limitation” of Oracle is that you can only have 1000 elements within an IN-LIST style expression in your SQL predicates. I use the quotes because I’ve always found that if you are heading into the territory where you need more than 1000 items in an IN-LIST, then it is often indicative of something else being wrong. For example, if the code is backing a user interface, then where in the design phase did someone not go “Whoa…we are going to have 1000 select-able elements on the screen?”

5. Oracle’s ‘Pragmatic’ Approach to AI in Business Transactions

John Soat writes, “Guiding Oracle’s development of its latest generation of cloud applications are three main business imperatives: help customers innovate rapidly, create nimble processes, and make the most of their mobile, social, and other communications channels.

Speaking at Oracle OpenWorld, Steve Miranda, executive vice president of applications development, emphasised the considerable work the company has done incorporating machine learning algorithms into its comprehensive, tightly integrated suites of cloud applications. “We’re ready to run your business in the cloud,” Miranda said.”

6. APEX 19.2 Dark Mode CSS Extension

Scott Wesley writes, “There have already been some insightful posts about APEX 19.2 Early Adopter, plus an interesting feed of features on Twitter, as they’re discovered.
Sven has a great summary.
Adrian comments on markdown.
Mike is really plugging faceted search on twitter. I particularly look forward to playing with that one.

I couldn’t resist giving the dark mode a test spin…”

7. Bye Bye Flash!

Alfredo Krieg Villa opens with, “Formerly named Macromedia Flash (now Adobe Flash) player was really popular in the 2000’s. I remember learning it to add animation to Web Sites I was developing during my college years. Flash has also been the target of hackers to insert viruses, hence posing several security concerns to enterprises and home users. In the IT world, change is the only constant. So, is time to move on to the next thing…”

8. Oracle OpenWorld 2019, live blog, part two

Cameron Lackpour live blogs from Oracle OpenWorld.

9. A case for OPTIMIZER_INDEX_COST_ADJ in the cloud or not

Ric Van Dyke says, “I’ve been doing a lot of query optimization on Exadata this year and it’s been quite an experience.  As I mentioned in my last post the use of indexes on Exadata is tricky.  For the most part NOT using an index is a good idea, but not always.  There are still times the use of an index is good on Exadata.”

10. Amazon QLDB and the Missing Command Line Client

Gokhan Atil opens with, “Amazon Quantum Ledger Database is is a fully managed ledger database which tracks all changes of user data and maintains a verifiable history of changes over time. It was announced at AWS re:Invent 2018 and now available in five AWS regions: US East (N. Virginia), US East (Ohio), US West (Oregon), Europe (Ireland), and Asia Pacific (Tokyo).

You may ask why you would like to use QLDB (a ledger database) instead of using your traditional database solution. We all know that it’s possible to create history tables for our fact tables, and keep them up to date using triggers, stored procedures, or even with our application code (by writing changes of the main table to its history table). You can also say that your database have write-ahead/redo logs, so it’s possible to track and verify the changes of all your data as long as you keep them in your archive. On the other hand, It’s clear that this will create an extra workload and complexity for the database administrator and the application developer while it does not guarantee that the data was intact and reliable. What if your DBA directly modifies the data and history table after disabling the triggers and even alter the archived logs? You may say it’s too hard, but you know that it’s technically possible. In a legal dispute, or a security compliance investigation, this might be enough to question to the integrity of the data.”

This week on Twitter

Oracle Database posted Oracle Data Safe: Five Ways to Help Protect Your Digital Assets

Benjamin Arnulf tweeted the first quick video preview of Oracle Analytics for Cloud ERP!

Paper.li

Blogs from www.thatjeffsmith.com, www.odtug.com and https://richardfoote.wordpress.com

Videos such as:

Accelerate Your DevOps Processes with Oracle VM VirtualBox

Oracle APEX Tip Jam | Peter Raganitsch

Uncategorized