Browsed by
Monat: Dezember 2017

Blog Post: How Well a Query Optimizer Handles Subqueries?

Blog Post: How Well a Query Optimizer Handles Subqueries?

At the beginning of December, at the UKOUG Tech17 conference in Birmingham (GB), I presented a comparison of the query optimizers of MySQL 8.0.3 and PostgreSQL 10.1. One of the things I talked about is their ability to handle subqueries. I summarized my findings with the following sentence: Simple sub-queries that are not correctly optimized […]

Blog Post: Roleplaying Dimensions and SSAS Multidimensional

Blog Post: Roleplaying Dimensions and SSAS Multidimensional

Yes, I can hear you, SSAS Multidimensional is so old and unsexy. Still, a lot of the data warehouse projects I work on still use this techonology. So what is a roleplaying dimension? It’s quite simply a dimension, that plays different roles in regard to a certain fact. Or put a bit differently: one dimension…

Blog Post: Last Week in Stream Processing & Analytics – 25.12.2017

Blog Post: Last Week in Stream Processing & Analytics – 25.12.2017

Happy Holidays !! This is the 95th and Christmas edition of my blog series blog series around Stream Processing and Analytics! As every week I was also updating the following two lists with the presentations/videos of the current week: Presentations from SlideShare Videos from YouTube As usual, find below the new blog articles, presentations, videos […]

User: lesathomas

User: lesathomas

Hi People, My name is Lesa Thomas and I am living in New York. I am currently working for Assertmeds which allows its client buy Viagra online. Assertmeds.com is an honest online drugstore that serves efficient medication to people across the world. You can buy healthcare medication on men’s and women’s health diseases at reasonable costs. This online pharmacy buys medicines from well known manufacturers in large quantities; thereby, guaranteeing the availability and affordability. Assertmeds.com might be an approach that’s…

Weiterlesen Weiterlesen

Blog Post: Object type „nested“ implicit grants

Blog Post: Object type „nested“ implicit grants

A colleague got an „ORA-01720: grant option does not exist“ error and couldn’t understand why. So together we researched a bit and learned some things about how object type grants across schemas works – including a small surprise that was the reason for our puzzlement. To demonstrate, I create three users with just the necessary privileges: SQL> connect system@orclEnter password:Connected.SQL> grant connect, create type to user1 identified by user1;Grant succeeded.SQL> grant connect, create type to user2 identified by user2;Grant succeeded.SQL>…

Weiterlesen Weiterlesen

Blog Post: Last Week in Stream Processing & Analytics – 18.12.2017

Blog Post: Last Week in Stream Processing & Analytics – 18.12.2017

This is the 94th edition of my blog series blog series around Stream Processing and Analytics! As every week I was also updating the following two lists with the presentations/videos of the current week: Presentations from SlideShare Videos from YouTube As usual, find below the new blog articles, presentations, videos and software releases from last […]

Blog Post: Purging Unused Triples Is a Never-ending Operation

Blog Post: Purging Unused Triples Is a Never-ending Operation

This is a short post to point out a problem I recently discovered and for which I couldn’t find information online. Hence, in case you hit it, thanks to this short post I hope that you’ll save some time. The documentation describes a procedure you can use to get rid of dangling triples stored in […]

Blog Post: Polymorphe Tabellenfunktionen

Blog Post: Polymorphe Tabellenfunktionen

Letzten Monat konnte ich an der DOAG-Jahreskonferenz in Nürnberg teilnehmen. Wie immer ein tolles Event, großartige Community und exzellente Vorträge. Und es scheint so zu sein, als hätte ich mein Lieblings-Feature der neuen Datenbank 18c gefunden. Keith Laker (@ASQLBarista), Oracle’s Produkt Manager für Analytisches SQL, sparch über „Building Agile Self-Describing SQL Functions For Big Data“. […]