0 Some impressions from Oracle Analytics Cloud–taken from keynote at Oracle OpenWorld 2017
In his keynote on October 3rd during Oracle OpenWorld 2017, Thomas Kurian stated that the vision at Oracle around analytics…
Browsing: Database
Oracle database
0 Oracle Open World; day 2 – highlights
At Monday Oracle Open World really starts. A whole lot of general sessions with announcements and strategic directions on…
0 Oracle Open World 2017; day 1 observations
Just a quick note about day 1 at Oracle Open World. This Sunday traditionally is filled with presentations of usergroups,…
0 The day before OOW17; infra expectations
Oracle Open World 2017 is starting tomorrow, and as a platinum partner of Oracle, we – AMIS Services – are…
0 R and the Oracle database: Using dplyr / dbplyr with ROracle on Windows 10
R uses data extensively. Data often resides in a database. In this blog I will describe installing and using dplyr,…
0 ODA X6-2M – How to create your own ACFS file system
In this post I will explain how to create your own ACFS file system (on the command line) that you…
0 Machine Learning in Oracle Database – Classification of Conference Abstracts based on Text Analysis
Machine Learning is hot. The ability to have an automated system predict, classify, recommend and even decide based on models…
1 AWS – Build your own Oracle Linux 7 AMI in the Cloud
I always like to know what is installed in the servers that I need to use for databases or Weblogic…
0 Create a 12c physical standby database on ODA X5-2
ODA X5-2 simplifies and speeds up the creation of a 12c database quite considerably with oakcli. You can take advantage…
1 after 27+ years in Oracle land I am forced to patch sqlplus
When starting to use sqlplus 12.2 I noticed that my SQL prompt was not changing to what login.sql told it…
0 ETL using Oracle DBMS_HS_PASSTHROUGH and SQL Server
While I prefer a “loosely coupled architecture” for replication between Oracle and SQL Server, sometimes a direct (database) link cannot…
0 Oracle Database standard Geo Location Support using Locator (included in every edition!)
Many databases have native support for locations en geodata – and determining distance and closest locations (within a certain perimeter).…
0 Quickest way to get going with Node.js and MongoDB – using the mongodb Node driver and a free MongoDB instance in the cloud with mLab
While preparing for a workshop on Node.js, I ran into the by far quickest way to get some a simple…
0 The Hello World of Machine Learning – with Python, Pandas, Jupyter doing Iris classification based on quintessential set of flower data
Plenty of articles describe this hello world of Machine Learning. I will merely list some references and personal notes -…
0 Golden Gate 12c and DIY Sequence Replication with PL/SQL
Recently, while migrating AIX 11gR2 Databases to Oracle Linux 12cR1 on an ODA X5-2, our setup of Sequence Replication by…
1 Better track the Usage of Database Options and Management Packs, or it will cost you
So here it is Oracle announces a license audit, some urgency kicks in and this familiar but also really serious…
0 How I learned to appreciate MongoDB
Last week at our company we organized a session about NoSQL in general and MongoDB in particular, as you can…
0 Introducing NoSQL and MongoDB to Relational Database professionals
Most enterprises have a lot of variety in the data they deal with. Some data is highly structured and other…
0 Change UUIDs in VirtualBox
If you are anything like me you will have multiple virtualboxes running on your system. Sometimes you might want to…
1 Dump Oracle data into a delimited ascii file with PL/SQL
This is how I dump data from an Oracle Database (tested on 8i,9i,10g,11g,12c) to a delimited ascii file: Next to…