Category: Data Warehousing & BI
Apache Drill is a schema-free SQL query engine. Drill supports a variety of NoSQL databases and file systems, including HBase, MongoDB, MapR-DB, HDFS, MapR-FS, Amazon S3, Azure Blob Storage, …
The application and usage of the Oracle Database In-Memory has been described by Pom Bleeksma in this post. Oracle Database In-Memory can result in huge improvement in application query …
Hereby a somewhat embarrasing story about a performance problem with an Oracle Warehouse Builder – database (11.2.0.3). Embarrasing, while it took too much time to figure out what was …
Lucas Jellema
November 15, 2013
AMIS, APEX, Architecture, Business Process Management (BPM), Cloud, Data Warehousing & BI, Database, DBA Oracle, Development Tools, Java, Oracle, Oracle 12, Oracle Application Development Framework, Oracle WebLogic Server, PL/SQL, SOA, WebCenter
Oracle OpenWorld is a monster event – 10Ks of attendees, thousands of sessions and 100Ks of private conversations that all help convey and define the message about Oracle’s strategy …
Lucas Jellema
October 2, 2013
APEX, Business Process Management (BPM), Cloud, Data Warehousing & BI, Database, Java, Oracle, Oracle 12, Oracle Application Development Framework, Oracle WebLogic Server, PL/SQL, SOA, WebCenter
On Thursday 10th of October, the 12 man strong AMIS delegation at Oracle OpenWorld and JavaOne 2013 will present its findings in a 3 hour session at AMIS HQ …
Lucas Jellema
September 19, 2013
APEX, Business Process Management (BPM), Cloud, Data Warehousing & BI, Microsoft Azure, Oracle 12, Oracle Application Development Framework, Oracle E-Business Suite, Oracle WebLogic Server, SOA, WebCenter
As I am about to start my ninth Oracle OpenWorld Conference, I am wondering what this year’s conference will have in store for me. My schedule is largely filled …
Saskia van der Maat
July 31, 2013
AMIS, Cloud, Data Warehousing & BI, Database, Mobile, Oracle, Oracle Application Development Framework, Oracle WebLogic Server, PL/SQL, SOA, WebCenter, XML
Vanaf 22 september vindt in San Francisco de Oracle OpenWorld conferentie plaats: hét evenement waar Oracle haar productstrategie uit de doeken doet en waar Oracle specialisten van over de …
Three months ago started the Oracle program: Are You The Smartest. For me it is an opportunity to test my current knowledge level and to extend my knowledge. After …
Three months ago started the Oracle program: Are You The Smartest. For me it is an opportunity to test my current knowledge level and to extend my knowledge. After …
Robbrecht van Amerongen
March 13, 2013
AMIS, Announce / Events, Architecture, Big Data, Book reviews and Publications, Data Warehousing & BI, Development Tools, Java, Mobile, Oracle Application Development Framework, Oracle E-Business Suite, Project Management, Software Development, Testing, Tools, XML
Van 15 tot en met 19 april geeft Luc Bors de 5-daagse ADF 11g training op het kantoor van AMIS in Nieuwegein. In 5 dagen leer je de basis …
Saskia van der Maat
December 4, 2012
AMIS, APEX, Architecture, Business Process Management (BPM), Cloud, Data Warehousing & BI, DBA Oracle, Development Tools, Java, Mobile, Oracle, Oracle Application Development Framework, PL/SQL, SOA, Web/Java, WebCenter, XML
Als sluitstuk van de jaarlijkse Oracle OpenWorld conferentie brengt AMIS een whitepaper uit. Een handzaam document waarin het volledige verhaal van Oracle OpenWorld 2012 is gebundeld. Een team van …
Yesterday (16th October), 10 days of the end of the yearly Oracle show in San Francisco, AMIS organized its ‘Review from Oracle Open World 2012’ session with an overview …
Robbrecht van Amerongen
October 9, 2012
AMIS, Announce / Events, Architecture, Data Warehousing & BI, Databases, Development Tools, Java, Mobile, Oracle Application Development Framework, Oracle WebLogic Server, PL/SQL, SOA, Software Development, Software Engineering, Tools, Web HTML5 CSS3, Web/Java, WebCenter
Hierbij nodigen we je uit om met ons kennis te komen maken. Ben jij een (junior) Oracle consultant die een stap verder wil maken? Wil je verder groeien en …
The show is over, the visitors are on their way home. The process of digesting the announcements, roadmaps and rumors – confirmed or not – can proceed in full …
Lucas Jellema
September 27, 2012
Business Process Management (BPM), Cloud, Data Warehousing & BI, Database, Java, Mobile, Oracle, Oracle Application Development Framework, Oracle WebLogic Server, PL/SQL, SOA, WebCenter
The show of the year is around the corner: on Sunday it will all start again, the Oracle Open World conference. Tens of thousands of developers, architects, administrators, project …
Robbrecht van Amerongen
September 13, 2012
AMIS, Architecture, Business Process Management (BPM), Cloud, Data Warehousing & BI, Database, DBA Oracle, Development Tools, IT, Java, Mobile, Oracle, Oracle Application Development Framework, Oracle WebLogic Server, PL/SQL, Project Management, Software Development, Software Engineering, Web HTML5 CSS3, Web/Java
Hierbij nodigen we je uit om met ons kennis te komen maken. Ben jij een (junior) Oracle consultant die een stap verder wil maken? Wil je verder groeien en …
Lucas Jellema
August 31, 2012
AMIS, Business Process Management (BPM), Cloud, Data Warehousing & BI, Database, DBA Oracle, Java, Mobile, Oracle, Oracle Application Development Framework, Oracle WebLogic Server, PL/SQL, Web HTML5 CSS3
Van 30 september tot 5 oktober is San Francisco weer het domein van tegen de 45.000 deelnemers aan de Oracle Open World en JavaOne conferenties. Ruim 2000 presentaties worden …
Het zal je niet zijn ontgaan dat vorige week in San Francisco Oracle Open World woedde. In een krappe week legde Oracle voor zo’n 45.000 bezoekers de strategie neer, …
In previous articles, I have suggested that the arrival of the Flashback Data Archive in Oracle RDBMS 11g allowed us to finally say goodbye to journalling tables. Keeping track …
Yesterday evening we had our annual Oracle Open World review at our office in Nieuwegein. Around eighty people attended and all were very involved with the session. Five AMIS …
Many organizations around the world have adopted Oracle technology for developing custom applications. Over the past two decades, they may have used PL/SQL, Reports, Forms, Designer, Portal or the …
Oracle Database 11g Release 2 introduces the successor to the good old Connect By based hierarchical querying, called Recursive Subquery Factoring. The basics are described in a previous …
You are probably familiar with the FIRST_VALUE and LAST_VALUE analytical functions that were introduced some time ago into the Oracle RDBMS, in the 9iR2 release I believe (or at …
“Exadata – Extreme Performance Warehousing“, that’s how the presentation on the last Friday morning from Oracle Open World started (Orig. Presentation Title was “Oracle’s New Database Accelerator: Query Processing …
Larry yesterday did his keynote here at Oracle Open World introducing the “Oracle(R) Exadata Storage Server”. This morning I attended a session about the technical details behind the server. …
Most of the presentations for the sessions presented at Oracle Open World 2007, last week in San Francisco, can be downloaded from the Content Catalog at: http://www28.cplan.com/cc176/catalog.jsp. You will …
My first formal activity at Oracle Open World 2007 was the Oracle Ace Director Product Briefing. A closed session where 30 odd ACE Directors (and you read that any …
One of the new features in the Oracle 11g database is called Oracle Total Recall. This is called marketing! I have read some weblogs where people – mostly DBAs …
Row generation is a very useful technique for many (semi-)advanced SQL Queries. We have discussed various methods for row-generation in previous articles on our weblog. Examples are the CUBE …
The PIVOT operation is one frequently discussed when talking about more advanced SQL Queries. Pivoting is the process of switching rows and columns, and is for example an advanced …
One of the interesting new pieces of functionality in Oracle 11g is offered by the DBMS_COMPARISON package. This package allows us to compare two tables – or two views …
Last week I made my first steps with XML-Publisher 5.6 Desktop and I am very pleased with the simplicity you can create a report in such a short time. When …
Last week I noticed that the long awaited Oracle Business Intelligence Standard Edition One was available on e-delivery download site and on Monday (25 June 2007) Oracle officially announced …
I may be at JavaOne 2007, the important work still has to go on. Hence the latest in a series of SQL powered charts and graphs: the Gauge or …
Last Wednesday I visited the Oracle BI seminar in Utrecht. Underneath you find a brief description of the highlights. First of all Wouter van der Brugghen presented the Oracle BI …
After receiving a new, pretty powerful laptop, on Thursday and installing the Oracle BI Enterprise Edition on Friday, this weekend sees my first steps with the BI Publisher (previously …
Although bitmap indexes are already available in Oracle 8i or even before (some sources even say 7.3!!!), they are still surrounded by many myths. Time for some clearing up. …
One of the intriguing products in the Oracle Portfolio is Oracle BAM (Business Activity Monitoring). I have been trying to see it in action, learn more about and actually …
Database Performance Analysis and Tuning of queries and Database Design have never been my specialty. As of late, I have been reading a lot in this area, on Wait …
Recently I had to extract data from 5 Access databases and 4 Excel files and merge the data into an Oracle table. One method was to export the data from Access to Oracle via …
![Oracle RDBMS 11gR2 – new style hierarchical querying using Recursive Subquery Factoring]({"aperture":"0","credit":"","camera":"","caption":"","created_timestamp":"0","copyright":"http:\/\/seattletimes.nwsource.com\/ABPub\/2012\/08\/02\/2018836700.jpg","focal_length":"0","iso":"0","shutter_speed":"0","title":"","orientation":"0"} "Oracle RDBMS 11gR2 – new style hierarchical querying using Recursive Subquery Factoring")