ACTIVE DATABASE IN DATABASE MANAGEMENT SYSTEM

DBMS

1. ACTIVE DATABASE
SUBMITTEDBY
THIVYASHRIS
MADHUMITHA K
MCA(DS)
SUBMITTEDTO
SARANYAR
MCA,M.PHIL.,B.Ed.
ASSISTANTPROFESSOR

2. INTRODUCTION
01 02 03
04 05 06
Table of contents
DIAGRAM FEATURES
COMPONENTS EXAMPLE ADVANTAGE &
DISADVANTAGE

3. INTRODUCTION
AnActiveDatabaseinDBMSisadatabasethat
automaticallyrespondstocertaineventsorchangesindata
withoutneedingmanualintervention.
Itusestriggersorrulestodefinehowthedatabaseshould
reactwhenspecificactionsoccur,likeinserting,updating,
ordeletingdata.

4. DIAGRAM OF ACTIVE DATABASE

5. FEATURES
❖Itpossessalltheconceptsofaconventionaldatabasei.e.data
modellingfacilities,querylanguageetc.
❖Itsupportsallthefunctionsofatraditionaldatabaselikedata
definition,datamanipulation,storagemanagementetc.
❖ItsupportsdefinitionandmanagementofECArules.
❖Itdetectseventoccurrence.
❖Itmustbeabletoevaluateconditionsandtoexecuteactions.
❖Itmeansthatithastoimplementruleexecution.

6. 1.Triggers
❖Specialrulesthatautomaticallyrunwhenspecificchanges
(events)happeninthedatabase.
❖Example:Ifaneworderisadded,updatetheinventory.
2.Events
❖Theactionsthatactivatetriggers
❖Thinkofeventsas"whensomethinghappens,"likeadding
datatoatable.
❖Example:insert,update,delete

7. 3.Conditions
❖Checks or tests to decide if a trigger should be executed.
❖Example: Only update stock if the product quantity is above
zero.
4.Actions
❖The tasks performed when the event and condition are met.
❖Example: If stock is low, send a notification to reorder.

8. EXAMPLES
1.1. Real-time Databases
•
•Oracle TimesTen:A relational database that runs in memory and is
intended for real-time applications that need response times of less
than one millisecond.
2.2. In-Memory Databases
SAPHANA:Acolumn-oriented,in-memoryrelationaldatabase
managementsystemforprocessinglargeamountsofdataandreal-
timeanalytics.

9. ADVANTAGES
Real-timeDataManagement
Immediateupdatesandresponsestochangesindata.Enhanced
Automation
Automatesroutinetasksthroughtriggersandrules,reducing
manualeffort.
ImprovedDataIntegrity
Consistentenforcementofbusinessrulesensuresaccurateand
reliabledata.
Event-drivenArchitecture
Reactstospecificevents,makingitidealfordynamicapplications.
Scalability
Efficientlyhandlesincreasedloads,suitableforlarge-scale
environment.

10. DISADVANTAGES
Complexity
Implementationcanbeintricate,requiringspecializedknowledge.
PerformanceOverhead
Additionalprocessingfortriggersandrulesmayslowdownoperations.
MaintenanceChallenges
Morecomponentstomanage,increasingmaintenanceeffortsandcosts.
DebuggingDifficulties
Tracingerrorscanbecomplexduetoautomatedresponsesandevent
handling.
PotentialforOver-automation
Excessiveautomationcanleadtounintendedactionsanddataintegrity
issues.

11. THANK YOU