2.4k questions

2.4k answers

97.7k users

3 Online Users
0 Member 3 Guest
Today Visits : 402
Yesterday Visits : 1399
Total Visits : 2417653

Categories

Notice

Dear All, These are my answers from Quora and primarily Google; please check the answer and from others sites; the answers are free and without any liability.To make a decision, write down all of the positives and negatives on a piece of paper.Thank you,

Elias Katsaniotis, MSc

Information

Viktoria Katsanioti,

Kaliningrad,

Russia,

matizegr@yahoo.com

0 votes
48 views

What are the components of the DBMS environment?
in General by (95.8k points)

1 Answer

0 votes

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)

  1. all code that manages the engnine
  2. database languages like SQL, PL/SQL (internal)
  3. database languages + code that communicate an external language like PRO*C
  4. tools to write reports, forms like rpt/rpf, Oracle Forms in oracle and more
  5. monitoring, tuning tools
  6. tools to import data like SQL*Loader
  7. backup utilities
  8. recovery utilities
  9. security utilities to not loose data (like simulation of Trash Bin)
  10. software of other companies as cluster Sun Cluster 3.1 (fault tolerant tech like spacecrafts)
  11. and many more
by (95.8k points)
...