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…
Browsing: Database
Oracle database
0 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…
3 DIY Parallelization with Oracle DBMS_DATAPUMP
Oracle dbms_datapump provides a parallel option for exports and imports, but some objects cannot be processed in this mode. In…
0 How About Oracle Database 12c Threaded_Execution
THREADED_EXECUTION Threaded_Execution is an Oracle Database 12c feature aiming to reduce the number of Oracle processes on LINUX. After setting…
0 Oracle 12c STIG Password Generator in PL/SQL
Creating or modifying an Oracle Database user password can be done by using any standard password generator you can find…
0 Serial database backups using Oracle Enterprise Manager
For several years now, I’ve been a fan of backups controlled by Enterprise Manager (of Grid Control, or Cloud Control,…
0 Oracle Service Bus: A quickstart for the Kafka transport
As mentioned on the following blog post by Lucas Jellema, Kafka is going to play a part in several Oracle…
0 The normalization of Big Data – reporting from Oracle OpenWorld 2016 on Big Data and Data Integration
The importance of data has never been in doubt in the world of Oracle. Through machine learning and predictive analytics…