Blogs

Apriori Algorithm in sql,pl/sql and spark sql

articles: 

"""
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.

DB 21c available for download

articles: 

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 21.x make sure you have the latest

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

articles: 

"""
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.

oracle queries needed

articles: 

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

articles: 

"""
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.

database block size - does it really matter?

articles: 

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

Installing database 19c on Oracle Linux 8

articles: 

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

Controlling distributed queries with hints

articles: 

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

Devart Presents Dramatically Improved dbForge Studio for MySQL v.9.0

articles: 

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.

Pages

Subscribe to RSS - blogs