What are the components of the DBMS environment?

More
1 month 2 weeks ago #3324 by Elias
What are the components of the DBMS environment? was created by Elias
What are the components of the DBMS environment?

Please Log in to join the conversation.

More
1 month 2 weeks ago #3325 by Elias
Answered by Elias on question What are the components of the DBMS environment?
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.234 seconds
Joomla! Templates by RSJoomla!