Connections and Sessions

Tianzhou Chen -
  • Connection: A connection is a “physical circuit”, a pathway to a database server.
  • Session: The SQL operations that are performed while a connection is active form a session. The session is associated with CATALOG(database) and SCHEMA.

A connection can contain 0, 1 or more sessions