Leveraging Memory in PL/SQL for Big Data Applications

When writing PL/SQL code for Big Data applications it’s always a good idea to leverage the database as much as possible.  This is particularly true for ETL or warehousing processing. In my experience, I’ve tried to quantify objects in Oracle programming that work best to temporarily  store data.  As part of your Big Data application,… Read More

Deep Learning, Oracle Database Performance and the Future of Autonomous Databases

“The goal is to have databases in the Cloud run autonomously. The Cloud should be about scale, elasticity, statelessness and ease of operation and interoperability. Cloud infrastructures are about moving processes into microservices and the agile deployment of business services. Deep Learning has the potential to give databases innovative and powerful level autonomy in a multitenant environment, allowing DBAs the freedom to offer expertise in system architecture and design…”.

Read More

My Favorite Publicly Available Datasets

I’ve been working with data for decades, searching for insights, converting it, managing it, and now performing data analytics. We have access to unbelievable treasure troves of public data to analyze.  Many of the blogs I write are based on these datasets, as I don’t have access to large computing systems.  Here is a list… Read More

Using Machine Learning and Data Science for Performance Tuning in Oracle

Like many DBAs, I have experienced the ups and downs of database performance tuning. Many battles have been fought to tune and maintain an Oracle database yielding mostly victories, but also a few hard-fought lessons learned.  Performance tuning is a constant in my job and I’ve learned a lot; but for every early morning phone call… Read More

Campaign Management using Advanced Analytics

Campaign management is a strategy to use marketing campaigns to create sales and leads.  The Internet has been a treasure trove of consumer behavior for decades, it is only recently that web analytics has become a tool to create powerful business insight.  Two popular strategies deal specifically with pattern recognition.  Two pattern recognition strategies include… Read More

Example of an Entry-Level Data Scientist Job Post

The following is from a posting from a Data Science Intern for Lenovo.  A good example of what to expect with a typical Data Science position. The Data Scientist Intern will be expected to perform data mining, statistical learning, predictive modeling, mathematical and simulation modeling, forecasting, data visualization in support of key strategic projects.This position… Read More

Comparing Statistical Control and Machine Learning Models in Evaluating Performance in IoT Systems

Excerpt of submission to the Southern Data Science Conference that will be held in Atlanta GA.  This proposal is a first in a series of proposals in IoT and Analytics research that will posted on Data Flux.  For more info go to https://www.southerndatascience.com/submission-guidline SUMMARY Internet-enabled devices and the Internet of Things (IoT) will continue to become… Read More