• Welcome to our Q&A forum
  • Welcome to our Q&A forum
  • Welcome to our Q&A forum
  • Welcome to our Q&A forum

1 | 2 | 3

Translate

What are the components of the DBMS environment?

More
3 days 7 hours ago #3324 by ekatsa
What are the components of the DBMS environment?

Please Log in to join the conversation.

More
3 days 7 hours ago #3325 by ekatsa
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

Please Log in to join the conversation.

Time to create page: 0.221 seconds