How does the process of accessing a database work?

2

I started to study database and to access a certain database with JDBC you need a driver for each DBMS (MySQL, SQL Server, Oracle), and access is done on disk, but since this process is done? Does DBMS work constantly or only activated when a query is made?

Thank you in advance.

    
asked by anonymous 09.08.2017 / 00:57

1 answer

2

Your question is a bit confusing. But I'll try to answer.

  • When you install a database (mysql, postgres and etc) the service must be active, otherwise you will not be able to connect to it. That is, if the service is enabled, DBMS will work constantly!
  • The computer will only use processing with the active service.
  • The process of querying data is done in two steps: 1 - You connect to the bank (inform the login and password); 2 - Performs the required query
09.08.2017 / 15:07