2.4k questions

2.4k answers

95.6k users

12 Online Users
0 Member 12 Guest
Today Visits : 877
Yesterday Visits : 2184
Total Visits : 2346366

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)
...