SharePoint Mirror » Alle Tags » Oracle (RSS)

Nach Markierungen suchen

Blogs

SharePoint Mirror

Home

Syndication

RSS
Atom
Kommentar-RSS
E-Mail-Aktualisierungen empfangen
Abonnieren

Archives

Attribute Dimensions and Hierarchies in Oracle 12c

Oracle 12c Release 2 introduced Analytic Views, a new set of metadata objects that are very useful for Data Warehouses and Business Intelligence applications. In the first blog post about this new feature I will have a detailed look at two … Continue...

Veröffentlicht 31 Mai 2017 16:23 von triBLOG

Gespeichert unter: SQL, Oracle, Oracle 12c, Dimensional Modeling
Get Ready for Oracle 12.2

The Oracle 12.2 grammar is now supported in the most current versions of PL/SQL Cop, PL/SQL Cop for SQL Developer, PL/SQL Cop for SonarQube and PL/SQL Analyzer. […] ...read more...( read more ) Mehr…

Veröffentlicht 14 Mai 2017 18:26 von triBLOG

Gespeichert unter: Oracle, PL/SQL, PL/SQL Developer, PL/SQL Cop, SonarQube, PL/SQL Analyzer, Oracle 12cR2
Datenhistorisierung II

Im vorherigen Post habe ich die Möglichkeit gezeigt, wie man eine Kombination aus UNION ALL und GROUP BY nutzen kann, um die Daten als Slowly Changing Dimension Type 2 zu historisieren. Seitdem habe ich einige Performance-Tests durchgeführt, um diesen...

Veröffentlicht 30 Apr 2017 12:56 von triBLOG

Gespeichert unter: Oracle, Allgemein, Trivadis, OWB, Data Warehouse, SCD2, slowly changing dimensions, Deltaerkennung, Historisierung
Derived Measures and Virtual Columns

Virtual Columns in Oracle are a convenient feature to implement derived measures of a fact table. But in combination with Oracle Database In-Memory, it has an impact on performance – unless you use Oracle 12c Release 2. Derived measures in …...

Veröffentlicht 10 Apr 2017 14:49 von triBLOG

Gespeichert unter: SQL, Oracle, Performance, Oracle 12c, in-memory, Dimensional Modeling
plscope-utils – Utilities for PL/Scope in Oracle Database 12.2

PL/Scope was introduced with Oracle Database version 11.1 and covered PL/SQL only. SQL statements such as SELECT, INSERT, UPDATE, DELETE and MERGE were simply ignored. Analysing […] ...read more...( read more ) Mehr…

Veröffentlicht 17 Mrz 2017 21:14 von triBLOG

Gespeichert unter: Oracle, PL/SQL, Dependency Analysis, Oracle 12cR2, PL/Scope
Real-Time SQL Monitoring Report History in 12c

Subtitle: Performance Analysis with TaRTeSMon Hi there, In this blog post I want to write about Real-Time SQL monitoring enhancements of 12c and I do this almost simultaneously to my speeches about that topic. One is at the Trivadis internal Techevent...

Veröffentlicht 17 Mrz 2017 11:37 von triBLOG

Gespeichert unter: Oracle, Licensing, Real-Time SQL Monitoring, TaRTesMon
Partition Exchange in Oracle 12.2

There are many new extensions for Partitioning in Oracle 12c Release 2 (12.2). One of them is the CREATE TABLE FOR EXCHANGE statement. Some years ago, I wished to have this feature for a particular problem with hidden columns. Column … Continue...

Veröffentlicht 9 Feb 2017 16:13 von triBLOG

Gespeichert unter: SQL, Oracle, ETL, Partitioning, Oracle 12c
PL/SQL Cop for Trivadis PL/SQL & SQL Coding Guidelines Version 3.2

The PL/SQL Cop tool suite supports the new Trivadis PL/SQL & SQL Coding Guidelines 3.2. Download the new versions from the Download section. So, what’s new? Numbering and Categorisation Scheme The guidelines have been renumbered, extended, categorised…...

Veröffentlicht 6 Feb 2017 2:34 von triBLOG

Gespeichert unter: Oracle
How to Build Hash Keys in Oracle

Hash keys can be used instead of sequence numbers to build surrogate keys in a Data Warehouse. This is often done in Data Vault environments, and there are some good reasons to do that. But there are also several issues … Continue reading →...

Veröffentlicht 24 Jan 2017 0:51 von triBLOG

Gespeichert unter: Oracle
ANSI Join Syntax and Query Rewrite

There are many good reasons to use ANSI join syntax instead of the old Oracle join syntax. With one exception: If you want to use your Materialized Views for Query Rewrite, avoid to write them with ANSI joins. I’m a … Continue reading →.....

Veröffentlicht 30 Nov 2016 11:11 von triBLOG

Gespeichert unter: SQL, Oracle, Performance, Materialized Views
Wie vereinfache ich die Historisierung der Daten?

Die Historisierung der Daten ist eine typische aber auch rechen- und zeitintensive Aufgabe im Data Warehouse Umfeld. Man hat damit beim Beladen von historisierter Core-Schicht (auch bekannt als Enterprise Data Warehouse or Foundation Layer), Data Vault...

Veröffentlicht 24 Nov 2016 17:39 von triBLOG

Gespeichert unter: SQL, Oracle, Allgemein, Trivadis, OWB, Data Warehouse, SCD2, slowly changing dimensions, Deltaerkennung, Historisierung
Delta Detection in Oracle SQL

Delta detection is a common task in every Data Warehouse. It compares new data from a source system with the last versions in the Data Warehouse to find out whether a new version has to be created. There are several … Continue reading →.....

Veröffentlicht 8 Okt 2016 23:05 von triBLOG

Gespeichert unter: SQL, Oracle, ETL
Bitemp Remodeler v0.1.0 Released

I’ve been working on a flexible table API generator for Oracle Databases since several months. A TAPI generator doesn’t sound like a real innovation. But this one contains some features you probably have not seen before in… ...read more...

Veröffentlicht 25 Sep 2016 23:21 von triBLOG

Gespeichert unter: Oracle
Last week in Stream Processing & Analytics 8/2/2016

This is the 25th installment of my blog series around Stream Processing and Analytics. As usual, find below the new blog articles, presentations, videos and software releases from last week: News and Blog Posts General IoT Spotlight: Sensor to Dashboard...

Veröffentlicht 2 Aug 2016 20:04 von triBLOG

Gespeichert unter: Oracle, Trivadis, fast data, EDA, nifi, spark-streaming, Stream Processing, kafka, streamsets, streaming-analytics, kafka-streams, azure-stream-analytics, oracle stream analytics
Partial Indexes Trilogy – Part 3: Queries on Partial Indexes

After creating local and global partial indexes, the last part of this blog post trilogy shows how partial indexes are used by the optimizer for SQL queries – especially for queries in Data Warehouse environments. As we have seen before, …...

Veröffentlicht 21 Jul 2016 10:13 von triBLOG

Gespeichert unter: Oracle

1 2 3 4 5 Weiter > ... Letzte »

CC BY-NC-ND - Michael Greth

Mit Community Server (Commercial Edition), von Telligent Systems

3DZL:andrewbelon.com

Datenschutzerklärung

Nach Markierungen suchen

Blogs

Sponsored by

Syndication

Recent Posts

Tags

Archives

Attribute Dimensions and Hierarchies in Oracle 12c

Get Ready for Oracle 12.2

Datenhistorisierung II

Derived Measures and Virtual Columns

plscope-utils – Utilities for PL/Scope in Oracle Database 12.2

Real-Time SQL Monitoring Report History in 12c

Partition Exchange in Oracle 12.2

PL/SQL Cop for Trivadis PL/SQL & SQL Coding Guidelines Version 3.2

How to Build Hash Keys in Oracle

ANSI Join Syntax and Query Rewrite

Wie vereinfache ich die Historisierung der Daten?

Delta Detection in Oracle SQL

Bitemp Remodeler v0.1.0 Released

Last week in Stream Processing & Analytics 8/2/2016

Partial Indexes Trilogy – Part 3: Queries on Partial Indexes