jp_vijaykumar's blog
Submitted by jp_vijaykumar on Tue, 2021-09-14 11:43
"""
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.
Submitted by jp_vijaykumar on Mon, 2021-03-08 15:10
"""
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.
Submitted by jp_vijaykumar on Mon, 2020-09-14 08:21
"""
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.
Submitted by jp_vijaykumar on Sun, 2020-03-08 11:02
TIME SERIES ANALYSIS IN SQL AND PL/SQL
Written JP Vijaykumar
Date Mar 8th 2020
Submitted by jp_vijaykumar on Fri, 2020-01-10 17:20
DISKSPACE MONITORING
Written JP Vijaykumar
Date Jan 4th 2020
Modified Jan 5th 2020
**************************************************************
This article/script is provided for educational purpose ONLY.
The readers are advised to make necessary changes to the script as may be required for their use in their respective environments.
Pls test these scripts thoroughly in a lower environment, ONLY if you are satisfied with the tests' results, then ONLY use in any
Submitted by jp_vijaykumar on Sun, 2019-09-22 16:16
Decision Tree Algorithm in pl/sql
Author JP Vijaykumar
Date Sept 14th 2019
Submitted by jp_vijaykumar on Fri, 2019-03-08 20:13
Tablespace Capacity Planning Report
Author JP Vijaykumar
Written Sep 14 2017
Modified Mar 08 2019
***************************************************************************************************************
This script is provided for enducational purpose only.
The readers are advised to make necessary changes to the script as may be required for their use in their repective environments.
Pls test this script thoroughly in a lower environment, before using in any production db.
Submitted by jp_vijaykumar on Fri, 2019-03-08 20:11
********************************************************************************
APRIORI ALGORITHM
********************************************************************************
Modified March 08 2019
Submitted by jp_vijaykumar on Fri, 2019-03-08 20:09
********************************************************************************
--LINEAR REGRESSION ALGORITHM IN PL/SQL
--------------------------------------------------------------------------------
Modified Mar 8th 2019
Using Linear Regression algorithm, find the weight of a studen, whose is 71 inches tall.
Given the height and weight of 8 students.
Submitted by jp_vijaykumar on Sat, 2019-01-05 18:03
--NAIVE BAYES ALGORITHM WITH SQL & PL/SQL
---------------------------------------------------------------------------------
--Written JP Vijaykumar
--Date Jan 4th 2019
--This script is provided for educational purpose only.
--The readers are advised to make necessary changes as may be required for their use.
--I love data mining algorithms for their complexity and number crunching toughest logic.
--Academically, I want to generate Naive Bayes algorythm in pl/sql to predict the outcome.
Pages
|
