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, Google Cloud Storage, Swift, NAS and local files. A single query can join data from multiple datastores. For example, you can […]
Data Warehousing & BI
Business Intelligence such as OLAP, BI Beans, Discoverer, Data Mining and Data Warehousing such as OWB
When to use the Oracle Database In-Memory option?
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 performance. This post will answer the question: “what would be an optimal situation for using the Oracle Database In-Memory feature?” The […]
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 going on. The case: unexpectedly, within a week notice, the performance of an Oracle Warehoude Builder environment decreased drastically: logging in […]
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 and the roadmap for its close to 4000 thousand products. Concurrent with OOW is the JavaOne conference that – at a […]
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 in Nieuwegein, The Netherlands. You are welcome to attend this free session (from 16.30 on, food provided). Please register here: http://www.amis.nl/nl-NL/evenementen/technologie-evenementen/oow-review. […]
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 up, I know who I am going to meet, where I have to speak and where I need to go. Now […]
Het Oracle OpenWorld Preview Evenement (5 september 2013) – 15 sprekers & sessies
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 hele wereld ervaringen uitwisselen. Tegelijk met Oracle OpenWorld wordt ook de JavaOne conferentie georganiseerd, het trefpunt voor de wereldwijde Java gemeenschap. […]
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 every session I follow, I will write a brief summary as part of the preparation for the test. I will continue with the summary of […]
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 every session I follow, I will write a brief summary as part of the preparation for the test. I will continue with the summary of […]
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 van Oracle ADF 11g. De training bestaat basis uit presentatie, demonstratie en hands on, doorspekt met best practices en voorbeelden uit […]
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 AMIS was tijdens de conferentie in oktober nadrukkelijk aanwezig; als sponsor, deelnemer, netwerker en spreker – en als aandachtig luisteraar en […]
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 of news, trends, announcements, special finds and interesting rumors . This session was ‘sold out’ (even though it was free). For […]
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 ontwikkelen tot principal consultant? AMIS geeft je de kans om die stap te zetten. Bij ons krijg je de ruimte om […]
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 swing. What has become of last year’s plans, what are this year’s plans (for next year and beyond) and what has […]
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 managers, decision makers and others involved with Oracle products one way or another are gathering in and around San Francisco. AMIS […]
Uitnodiging: Kom kennismaken met AMIS
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 ontwikkelen tot principal consultant? AMIS geeft je de kans om die stap te zetten. Bij ons krijg je de ruimte om […]
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 daar gehouden, in vele tientallen zalen in hotels en het Moscone Conferentie Center in downtown San Francisco, waaronder pakweg 20 door […]
Report from Oracle Open World – op maandag 17 oktober, 17.00 uur bij AMIS in Nieuwegein
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, de roadmap voor tientallen productlijnen en ook een serie nieuwe aankondigingen. De meest opvallende lanceringen: de Oracle Public Cloud, de Oracle […]
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 of all changes and previous states of our records in our own dedicated tables is no longer required, was my statement […]
AMIS@OOW
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 employees were at Oracle Open World, and each one covered one area of interest. Before dinner Lucas gave an overview of […]
Oracle Open World 2010 presentation: Forms2Future: the ongoing journey into the future for Oracle based organizations
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 Web PL/SQL Toolkit. Many of these organizations have come to face new challenges: more agility or functionality, new user groups or […]
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 article: https://technology.amis.nl/blog/6104/oracle-rdbms-11gr2-goodbye-connect-by-or-the-end-of-hierarchical-querying-as-we-know-it. This article will show some additional examples of using this recursive subquery factoring syntax. The essence of this recursiveness: […]
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 least that is when they made their way into the Standard Edition). These values are used to find the first respectively […]
The "X" Product – An X(ML) Database Opportunity?
“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 Revolutionized”) while speaking about the new database machine. And indeed it was a revolution and it took the blogosphere by night. […]
Extreme performance introduced by patchset 11.1.0.7 smart scan
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. In principal the server works with 8 nodes running RAC on Oracle Enterprise Linux 5. For the storage management ASM is […]
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 need to use the username/password combination cboracle/oraclec6 to download presentations. At http://www.oracle.com/openworld/2007/keynotes.html are all the keynotes, of which the one by […]
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 way you like) had assembled to get some glimpses of what Oracle’s future has in store as well as some in […]
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 – are surprised at all this attention for Oracle Total Recall, as it seems little more than the Flashback technology that […]
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 operator, Table Functions and the Connect By Level < #number of records approach, apart from good old UNION ALL with multiple […]
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 feature in Excel. Before Oracle 11g, there were several approaches to pivoting, that were not work-arounds for the lack of the […]
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 on tables – and inform us on the differences in data. More specifically: the package can summarize if there any changes […]
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 you follow these instructions you can see it yourself. After you have installed the XML-Publisher 5.6 Desktop you open Microsoft Word […]
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 the general availability of Oracle Business Intelligence Standard Edition One. Oracle Business Intelligence Standard Edition One is based on the Siebel […]
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 Speedometer. Using nifty graphical tricks and the SQL*Plus 3D Pack, I managed to create a query that can render visually compelling, […]
Oracle BI Suite seminar Utrecht
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 strategy. Main strategic focus of Oracle BI is summarized below: Primary marketing tagline is: Pervasive BI, meaning BI for everybody. As an […]
My first steps with Oracle BI Publisher Enterprise Edition 10.1.3.2: create a report based on the OraBlogs rss-feed
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 known as XML Publisher). My colleague Marcos is our (AMIS’s) real expert in this area – you may have seen some […]
Myths on bitmap indexes
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. And believe it or not, every single myth mentioned here I heard many times in several projects.
Oracle BAM with a Bang – Business Activity Monitoring 10.1.3.1 available on OTN
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 start using it for some time. Today I went to a presentation on BAM by its product manager – Tal Broda […]
Testing Knowledge of Database Performance – Is this a good Execution Plan?
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 Statistics and events 10046 and 10053, on different strategies for table design and index design, on partitioning and clustering and many […]
Using an Oracle database link to connect to Excel
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 ODBC (at that stage I had not heard of Workbench ) but I was sure that there must be a way […]