Forum

Notifications

Clear all

What are the components of the DBMS environment?

(@elias)

Illustrious Member

Joined: 5 months ago

Posts: 4277

Topic starter 18/10/2024 7:04 pm

What are the components of the DBMS environment?

Quote

(@elias)

Illustrious Member

Joined: 5 months ago

Posts: 4277

Topic starter 18/10/2024 7:04 pm

Components of a database management system (from google)

Storage engine.
Query language.
Query processor.
Optimization engine.
Metadata catalog.
Log manager.
Reporting and monitoring tools.
Data utilities.

I’d like to say few thinks, and to arrange them (at Oracle)
[list=1]

all code that manages the engnine

database languages like SQL, PL/SQL (internal)

database languages + code that communicate an external language like PRO*C

tools to write reports, forms like rpt/rpf, Oracle Forms in oracle and more

monitoring, tuning tools

tools to import data like SQL*Loader

backup utilities

recovery utilities

security utilities to not loose data (like simulation of Trash Bin)

software of other companies as cluster Sun Cluster 3.1 (fault tolerant tech like spacecrafts)

and many more

ReplyQuote

Share: