Blogs

"""
Apriori Algorithm in sql,pl/sql and spark sql
Written JP Vijaykumar
Date Sep 14 2021

********************************************************************************
This script is provided for educational purpose only.

The sql scripts were tested in 11g & 19c databases.
While testing the sql scripts, pls test it in a dev/test db only and exercise precaution.

As from this weekend, it is here:

https://www.oracle.com/database/technologies/oracle21c-linux-downloads.html

I'll certainly install it in the next few days, there are a few features I want to experiment with and I know our developers want to check out the new JSON features. Production use? I'm not sure. It being an "innovation" release only with no extended support makes me a bit dubious.

ORDS version 21 was released in May, I had it tested and rolled it out in June. But once live, a problem popped up: numerous executions of this statement,
SELECT COUNT(1) FROM SYS.ALL_SYNONYMS WHERE OWNER = 'PUBLIC' AND SYNONYM_NAME = 'APEX_RELEASE' AND TABLE_NAME = 'APEX_RELEASE';

"""
Time Series Analysis in Spark SQL
Written JP Vijaykumar
Date Mar 8 2021

This script is provided for educational purpose only.
Pls modify/change the script as may be required to suit your environment.

I presented a script to process data using Time Series Analysis algorithm in sql and pl/sql earlier.
In this article, I am using the same code(90%) from my previous article and 10% pyspark code.

If you know sql, coding in pyspark is not that difficult.

I want SQL queries for these two scenarios

Q. 1) Anagrams of a string i.e. let a name is RAMESH. So all combinations of letters of word RAMESH.
Probably a procedure needs to be written for this eg RAMESH, RHSEMA. There will be 6*5*4*3*2*1 combinations

Q.2 ) There is one table PERSON as follows:

"""
Decision Tree Algorithm in Spark SQL
Written JP Vijaykumar
Date Sep 14 2020

This script is provided for educational purpose only.
Pls modify/change the script as may be required to suit your environment.

I presented a script to process decision tree algorithm using pl/sql earlier.
I like spark sql for the following reasons:
01) It is open source.
02) It combines the rich functionality of python and sql
03) It has the datamining libraries.
04) can be installed on my desktop and play around.

What block size should you use? For what purpose? How about tablespaces in different block sizes? Any opinions?

Database release 19.7 (ie, 19c with the April 2020 RU) is at last certified for OL8, but there may be some hacking needed to get it installed.

This certification is long overdue: our security admin has been pushing for the 5.x kernel for some time, and OL7 still only supports kernel 4.x. I'm starting to move some production systems over now using the July RUR, which takes the release to 19.7.1.

Begin by installing the Oracle Validated rpm from the ol8_UEKR6 repository:

yum install oracle-database-preinstall-19c

Recently I've been working on tuning some distributed queries. This is not always straightforward.

Devart introduced the new version of its key tool, dbForge Studio for MySQL, v.9.0. Almost every feature of the IDE was examined and significantly improved.

Devart, a recognized vendor of professional database management software for developers and DBAs, released dbForge Studio for MySQL, v9.0. The updated version delivers completely new functionality, including Find Invalid MySQL Objects, provides new connectivity options, and contains massive improvements of existing features, including MySQL Data and Schema Compare, Data Import and Export, Code Completion, and much more.