DBMS - Week 12 (Active DB & Stored Procedures)

There are 3 Information about the Day in Interval Information, such as

• Day_Hour,

  Day_Minute,

  Day_MillsSecond.

• Day_Hour,

  Day_Month,

  Day_Second.

• Day_Hour,

  Day_Minute,

  Day_Second.

• Day_Date,

  Day_Minute,

  Day_Second.

One of Data Types to know about the Date/Time for Current Activities such as Successfully Completed and or Published

For Automating Routine or Complex Database Operations & Data Processing Tasks

• Robotic Task

• Process Automation

• Automate Task

• Automotive Task

You can write multiple [ ... ] statements, each of which deletes data from a specific table

As Part of Data Sources in Stored Procedures

• Applications, Databases & Logs

• Files, Databases & Applications

• Events, Vertex.ai, Looker Studio

• Tableau, Logs & Applications

Workload Queue > Distributed, Serialized [....]

CREATE TRIGGER Validasi_Stok

BEFORE UPDATE ON Produk

FOR EACH ROW

[...]

    IF NEW.Stok < 0 THEN

        SET NEW.Stok = 0; -- Mengatur stok menjadi 0 jika kurang dari 0

    END IF;

END;

Acronym of ECA

• Event Condition and Accruals

• Event Condition & Action

• Event Coordination Actors

• Event Controlling and Action

• DBMS initially verifies whether the [ .... ] specified in the statement that modifies the database is activated. 

End User Computing (EUC) & System Administrator, is a part of

• PIC Responsible for Passive Database

• PIC Responsible for Massive Database

• PIC Responsible for Possessives Database

• PIC Responsible for Active Database