Search

Top 60 Oracle Blogs

Recent comments

July 2020

How to speed up Data Vault Query Performance

Data Vault is just too slow?

You think Data Vault is a great model but you struggle with query performance?

Use Exasol as a Platform!

We have the remedy: Use our analytical database Exasol as a platform and query performance problems with Data Vault disappear.

What’s the problem with Data Vault?

The Data Vault model comes with an increased number of tables and joins. Other data warehouse platforms likely have a problem to deliver acceptable query performance with that.

Exasol solves that problem!

Exasol on the other hand is very good with joins even on many tables. We use columnar storage and we always compress data. And our database is designed to do MPP with commodity hardware.

With these attributes, combining Data Vault with Exasol delivered the best query performance for that model already using earlier versions of Exasol. And for a very reasonable price, if I may add that.

JSON can be such a TREAT

What better way to start a new week than with a cheesy title to my blog post! Smile

But there is method to my unstructured madness today as we talk about the TREAT function, available from 18C for JSON data. As many of us will already know it is possible to dive into JSON data and extract information from its components as if they were relational columns using the very cool dot notation

In order to do so, we need to be a little generous to the database by letting it know that the contents of a unstructured column such as a CLOB is truly correct JSON data.

I will start with a table with a simple CLOB which does indeed contain valid JSON but I have not let the database know about that fact:

Industry Experts and Pro Bloggers Come Together to Inspire, Teach, and Help You (and Your Site) Succeed

At the Official WordPress.com Growth Summit, the two-day virtual conference running twice from August 11-13, you’ll have access to about 50 speakers and presenters across 90+ breakout sessions and keynote conversations. The varied lineup will appeal to new and established bloggers; professionals in tech, media, and marketing; and anyone ready to build or expand their presence on the web.

Video : APEXExport : Export APEX Applications and Workspaces From the Command Line

In today’s video we’ll give a quick demonstration of using the APEX command-line export utility.

The video is based on this article, which includes more examples, and Windows-based examples also.

The star of today’s video is my daughter Heli “Hell-Squirel” Helskyaho. Make sure you check out the cloud forming a Pikachu tail above her head! </p />
</p></div>

    	  	<div class=

SQL tuning with Hashing and Sorting

Aggregation

SQL is not all just primary key lookups, although some applications sadly see SQL as only useful in that way. As soon as you have data, you will always have the need to aggregate it, and SQL is the perfect vehicle for that. I did a video recently which I will embed below that was discussing the new 19c COUNT DISTINCT facilities which can dramatically speed up query processing that have requirements including the DISTINCT clause. One of the things I covered was the difference between our traditional aggregation facilities of sorting the data versus our new improved hashing facilities.

Does Your Project Need a Great Name? Try Our New Business Name Generator

Are you starting a new online store? A brick-and-mortar salon? A freelance consultation service? The new business name generator by WordPress.com is a one-stop tool to get you started with your next big idea.

Choosing a compelling, catchy name is a crucial step in any new project. That’s why we’ve launched a powerful tool that generates dozens of creative options for your business, store, or any other venture.

The business name generator is free and easy to use. Just enter one or more keywords, and it will generate dozens of potential names for you. 

DDL gets my goat

First things first. If you are not familiar with the term “gets my goat” then you can find a definition here Smile. But put simply, it means things that you find frustrating or bothersome.

What is getting my goat today is the time it takes to get the DDL for a database object using the DBMS_METADATA package. It always seem slow to me. Now I must admit, this is very much me exhibiting “never happy” syndrome, because before DBMS_METADATA came along, generating DDL from the database was an absolute pain in the proverbial. Your choices were either:

The First-Ever WordPress.com Growth Summit Is Coming, and You Won’t Want to Miss It

Join us for The Official WordPress.com Growth Summit on August 11-13! At our first-ever virtual conference you will learn how to build and grow your site, from start to scale. Are you a blogger looking for ways to drive traffic and get more visitors? Are you a small business that would like to start selling more products and services on your site? Are you an artist or creator who would like to learn how to share your work? The WordPress.com Growth Summit will cover these topics (and many more) and provide indispensable advice to help you succeed.

The goal of this event is to inspire, connect you with the tools you need, and help you build your community. Sessions will take place across three tracks: blogging, business, and creative. You can take sessions on any or all tracks, and they’ll focus on four main topic areas: 

A guided path to database expertise

At college/university, the learning path for a computing-related course often includes several coding languages, and occasionally some treatment of database technology as well. But often, it is only once you enter the business world as you embark upon your IT career that you truly start to face the demands of enterprise-level data requirements. The small amount of education on databases, or the small databases themselves sometimes do not prepare you for the realisation that data drives everything in the business world.

And where does one start? The amount of content out there about databases is overwhelming, and often assumes a base level of knowledge or is targeted at solving specific business problems.

If you have faced this obstacle, then I’m pleased to offer a new resource for you. One simple, consolidated, FREE training guide to kick start your database knowledge on developing applications on the Oracle Database.

Enjoy!