Jupyter Notebook for retrieving JSON data from REST APIs
If data is available from REST APIs, Jupyter Notebooks are a fine vehicle for retrieving that data and storing it in a meaningful, processable format. This article introduces an …
Category: Data Analytics
The Full Oracle OpenWorld and CodeOne 2018 Conference Session Catalog as JSON data set (for data science purposes)
Oracle OpenWorld and CodeOne 2018 are two co-located conferences that took place in October 2018. Some 2000 sessions presented by over 2500 presenters form the core of these conferences. …
What is Apache Drill and how to setup your Proof-of-Concept
March 11, 2019
Data Analytics, Big Data, Data Warehousing & BI, Database, Databases, Microsoft Azure, NoSQL
2 Comments
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, …
Running an enriched Jupyter Notebook runtime in a Docker Container – locally or cloud side
Data Wrangling is a crucial stage in the data science workflow. Or in any workflow that starts from raw data and hopes to achieve business insight – and perhaps …
Oracle Analytics Cloud – Data Flow to produce a Date Value and Timeline to Visualize the time related data
In two earlier articles on Oracle Analytics Cloud I have introduced the Oracle OpenWorld 2018 Session Catalog Data Set (First steps with Oracle Analytics Cloud – Gather, Explore, Wrangle, …
Creating a Data Flow in Oracle Analytics Cloud to enriching with Geo Encoding to Map visualization of data
In this article, I will show how I have created a Data Flow in Oracle Analytics Cloud to enrich a data set with geocoding data from a different data …
First steps with Oracle Analytics Cloud – Gather, Explore, Wrangle, Visualize
Data analytics is what turns data into business value. Oracle has a long history in Data Analytics – from Oracle Discoverer and its predecessors such as Data Browser through …
When to use the Oracle Database In-Memory option?
September 22, 2014
Architecture, Data Warehousing & BI, Databases, Digtial Innovation, Oracle 12
1 Comment
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 …
The Performance-button on Oracle Warehouse Builder Design Center
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 …
The AMIS Summary of Oracle OpenWorld 2013 is available for download – 60-page white paper
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 …
OOW13: summarizing one week and 2000 sessions in 3 hours and a bit – the yearly AMIS OOW Review session – 10th October
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 …
OOW13: What questions to get answered and plans to see evolved at this year at Oracle OpenWorld Conference
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 …
Het Oracle OpenWorld Preview Evenement (5 september 2013) – 15 sprekers & sessies
July 31, 2013
AMIS, Cloud, Data Warehousing & BI, Database, Mobile, Oracle, Oracle Application Development Framework, Oracle WebLogic Server, PL/SQL, SOA, WebCenter, XML
No Comments
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 …
AYTS: Summary of Oracle Business Intelligence Applications – Customizations
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 …
AYTS: Summary of the Introduction of Oracle Business Intelligence Applications
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 …
Training Oracle ADF 11g, 15 tot en met 19 april
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 …
AMIS vat Oracle OpenWorld samen in speciale whitepaper
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 …
OOW 2012: The yearly AMIS Review from Oracle Open World and JavaOne – slides available
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 …
Kom kennismaken met AMIS en doe mee met uitdagende projecten
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 …
OOW 2012 – The Big Stories
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 …
OOW 2012: Questions to get answered during this conference
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 …
Uitnodiging: Kom kennismaken met AMIS
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
No Comments
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 …
Dinsdag 18 september: Oracle Open World & JavaOne 2012 Preview mini-conferenties – 12 presentaties op 1 avond
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 …
Report from Oracle Open World – op maandag 17 oktober, 17.00 uur bij AMIS in Nieuwegein
October 11, 2011
AMIS, Data Warehousing & BI, Database, Java, Oracle, Oracle Application Development Framework, Oracle WebLogic Server, SOA, Web HTML5 CSS3
No Comments
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, …
Database Transaction Recorder – Adding Who to When and What to make Flashback take over from Journalling tables
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 …
AMIS@OOW
October 7, 2010
AMIS, Data Warehousing & BI, Database, Oracle, Oracle Application Development Framework, Oracle WebLogic Server, PL/SQL, SOA, XML
No Comments
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 …
Oracle Open World 2010 presentation: Forms2Future: the ongoing journey into the future for Oracle based organizations
September 21, 2010
Data Warehousing & BI, Database, Java, Oracle, Oracle Application Development Framework, Oracle WebLogic Server, PL/SQL, SOA, Web HTML5 CSS3
No Comments
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 RDBMS 11gR2 – new style hierarchical querying using Recursive Subquery Factoring
![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")
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 …
Oracle Database 11gR2 – New analytical function NTH_VALUE
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 …
The "X" Product – An X(ML) Database Opportunity?
October 1, 2008
Architecture, Data Warehousing & BI, Database, DBA Oracle, IT, Oracle, XML
2 Comments
“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 …
Extreme performance introduced by patchset 11.1.0.7 smart scan
September 25, 2008
AMIS, Architecture, Data Warehousing & BI, Database, DBA Oracle, Development Tools, Oracle
No Comments
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. …
OOW 2007: (most) presentations available for download
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 …
OOW 2007: Mark Townsend explains "Storage is not cheap"
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 …
Oracle 11g Total Recall – Flashback in the hands of Database Designers and Application Developers, at last. And: the end of Journalling Tables
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 …
Flexible Row Generator with Oracle 11g Unpivot Operator
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 Oracle 11g UNPIVOT operator – turning columns into rows
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 …
DBMS_COMPARISON – to compare and synchronize tables (new in Oracle 11g)
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 …
Building a report in XML Publisher
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 …
Oracle Business Intelligence Standard Edition One – now available.
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 …
Gauge charts in SQL or How to produce the world's ugliest speedometers
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 …