TutorialsData Mining
Core CS

Introduction

Every day, organisations collect huge amounts of data. A supermarket records millions of bills, a bank stores every transaction, a hospital keeps records of every patient, and a website logs every click of every visitor. This data keeps growing day by day. But raw data, by itself, is not very useful. Hidden inside this mountain of data are valuable patterns — for example, which products are usually bought together, which customers are likely to leave, or which transactions might be fraudulent. Data mining is the science of digging out these hidden, useful patterns from large amounts of data.

<h2>Introduction</h2><p style="background-color: transparent;"><span><strong>Data Mining: </strong></span>Data mining is the process of discovering interesting, useful, and previously unknown patterns and knowledge from large amounts of data. Data Mining: Data mining is the process of discovering interesting, useful, and previously unknown patterns and knowledge from large amounts of data.</p><h2>Key Points</h2><div><ul><li>&nbsp;Data

mining works on very large data sets, not small tables.&nbsp;</li><li style="background-color: transparent;">&nbsp;It

finds patterns that are hidden and not obvious to humans.&nbsp;</li><li>&nbsp;The

patterns must be useful and meaningful for taking decisions.&nbsp;</li><li>&nbsp;It

combines ideas from statistics, machine learning, and database technology.&nbsp;</li></ul><span style="color: rgb(0, 0, 0);">&nbsp;Common

uses: market analysis, fraud detection, customer retention, and risk

management.</span><br style="color: rgb(0, 0, 0);"><span style="text-align: justify; color: rgb(46, 117, 182);"><strong><br></strong></span></div><div><span style="text-align: justify; color: rgb(46, 117, 182);"><strong>Everyday Example</strong></span><span style="text-align: justify; color: rgb(46, 117, 182);"><strong>: </strong></span><span style="text-align: justify; color: black;">A supermarket discovers from its

billing data that customers who buy bread and butter often also buy jam. This

hidden pattern was never written down anywhere — it was 'mined' from the data.

The store can now place jam near bread to increase sales. That is data mining

helping a business decision.</span></div><div><p style="text-align:justify"><span style="color:black"><br></span><span style="color: black;"><strong>Database

&amp; Data Mining</strong></span></p><p style="text-align:justify"><!--StartFragment-->

<!--EndFragment--></p><!--StartFragment-->

<p style="text-align:justify"><span style="color: black;"><strong>Databases (DBMS)</strong></span><span style="color:black">

and </span><span style="color: black;"><strong>Data

Mining</strong></span><span style="color:black"> are

both fundamental pillars of data management and data science, but they serve

for different purposes.</span></p>

<!--EndFragment--><p style="background-color: transparent;">&nbsp; &nbsp;&nbsp;</p><!--StartFragment-->

<table>

<tbody><tr>

<td>

<p><span style="color: black;"><strong>Feature</strong></span></p>

</td>

<td>

<p><span style="color: black;"><strong>Databases

(DBMS)</strong></span></p>

</td>

<td>

<p><span style="color: black;"><strong>Data

Mining</strong></span></p>

</td>

</tr>

<tr>

<td>

<p><span style="color:black">Core Purpose</span></p>

</td>

<td>

<p><span style="color:black">To efficiently store, retrieve,

and manage data.</span></p>

</td>

<td>

<p><span style="color:black">To discover hidden patterns,

trends, and knowledge from data.</span></p>

</td>

</tr>

<tr>

<td>

<p><span style="color:black">Operation Type</span></p>

</td>

<td style="background-color: transparent;">

<p><span style="color:black">Operational and Transactional

(OLTP).</span></p>

</td>

<td>

<p><span style="color:black">Analytical and Exploratory (OLAP

/ Data Science).</span></p>

</td>

</tr>

<tr>

<td>

<p><span style="color:black">Query Nature</span></p>

</td>

<td>

<p><span style="color:black">Well-defined, explicit queries

(e.g., "What were the sales total for June 2026?").</span></p>

</td>

<td>

<p><span style="color:black">Fuzzy, exploratory queries (e.g.,

"Which products are frequently bought together by young adults?").</span></p>

</td>

</tr>

<tr>

<td>

<p><span style="color:black">Techniques Used</span></p>

</td>

<td>

<p><span style="color:black">Indexing, SQL, Transactions (ACID

properties), Concurrency control.</span></p>

</td>

<td>

<p><span style="color:black">Machine learning, Statistics,

Clustering, Classification, Association rule mining.</span></p>

</td>

</tr>

<tr>

<td>

<p><span style="color:black">Output</span></p>

</td>

<td>

<p><span style="color:black">Exact data points or records

directly matching the criteria.</span></p>

</td>

<td>

<p><span style="color:black">Insights, predictions, patterns,

and probabilistic models.</span></p>

</td>

</tr>

</tbody></table>

<!--EndFragment--><p><span style="color: rgb(0, 0, 0);"><span><strong>Data

mining</strong></span> cannot exist without a database to pull from, and a database remains a

passive storage unit without data mining to extract its true value.&nbsp;</span><span style="color: black; text-align: justify;">Data

mining cannot exist without a database to pull from, and a database remains a

passive storage unit without data mining to extract its true value.<br></span><!--StartFragment-->

<!--EndFragment--><!--StartFragment-->

<!--EndFragment--></p><p style="text-align:justify"><span style="color:black">Historically,

organizations used databases purely to keep track of daily operations (like

bank transactions or inventory). As these databases grew massive, companies

realized they were "data rich but information poor." Data mining

emerged as the solution to analyze these massive datasets.</span></p><p><span style="color: black; text-align: justify;"><strong>Example:</strong></span></p>

<p style="text-align:justify"><span style="color: black;"><strong>The Database's Job: </strong></span><span style="color:black">When

you buy a book, the database updates the inventory count, charges your credit

card, stores your shipping address, and logs the exact timestamp of the

purchase. It ensures the transaction is 100% accurate and secure.</span></p>

<p style="text-align:justify"><span style="color: black;"><strong>The Data Mining's Job: </strong></span><span style="color:black">The

data mining algorithm looks at your purchase history along with millions of

other users' histories. It notices a pattern: People who buy this specific book

also have an 80% likelihood of buying a specific bookmark. It uses this pattern

to generate the "Frequently bought together" recommendation for the

next customer.</span></p>

<!--EndFragment--><p>The Data Mining's Job: The

data mining algorithm looks at your purchase history along with millions of

other users' histories. It notices a pattern: People who buy this specific book

also have an 80% likelihood of buying a specific bookmark. It uses this pattern

to generate the "Frequently bought together" recommendation for the

next customer.</p><!--StartFragment-->

<!--EndFragment--><!--StartFragment-->

<!--EndFragment--></div>