Code design - (Connection|Session)

Card Puncher Data Processing


During the use of a product, a session or connection is a execution context that

In other word, a session represents a sequence of action that an application can use to maintain authentication state of a user.



A session can last:

  • either long (e.g., Gmail account)
  • or short (e.g., banking) period of time.

Token / Identifier

To keep track of the action in a session, an application uses a session token, which is a unique string, generally a nonce.

It's physically stored in a record and known as the session id for session identifier

The session id can be then passed between request. See web


Data across request

The primary usage of a session is to hold the navigation context data.

  • You can then preserve data across request.
  • They are a simple way to store data for individual users against a unique session ID


It's also a mechanism to trace navigation against an application.

How are users/consumers tracked on the internet?


A session on a analytical level is a group of user interactions that take place within a given time frame. See User Analytics - Session (Visit)


A session has a validity mechanism. The most known is that after a period of time of inactivity, the session becomes invalid and is deleted by a garbage mechanism.


You will find this concept in all OSI layer

Network / IP

See Network - Connection



In the web, the session identifier is stored:

  • or passed via URL querys (e.g. PHPSESSID). Not secure at all because URL may leak the session token
    • by copying and pasting the URL link into an email
    • in the web request log.

When the server receives an HTTP request, the server will look up the session information (user, connection time) using the session identifier as a key.


When you are making a connection with a database, you are just creating a session.

The session/connection information are stored in a table.


Connection are shared resource and therefore can not be a component of a release.

See Code Design - Connection Pool

Discover More
Data System Architecture
Auto-Commit Mode

autocommit mode is an application mode that performs the commit automatically. The commit is triggered by some condition that is dependent of your application. Most of the time, the commit is executed...
Card Puncher Data Processing
Code Design - Connection Pool

Connection pools allow multiple concurrent requests (queries,...) to share a single connection, reducing the connection overhead because a connection takes time (a session must be created, memory allocated,...
Data System Architecture
Concurrency - Concurrency

Data concurrency means that many thread (that may represents users) can access and modify data at the same time. Data concurrency ensures that users can access data at the same time ...reubenbond/status/662061791497744384/photo/1Reuben...
Card Puncher Data Processing
Language - (Execution) Context (Connection=Session, Request, Scope, Namespace)

The context is an object that wraps an execution object in order to set metadata contextual information such: as the start time, the location, ... the scope (ie namespace). session information....
Map Of Internet 1973
Network - Connection

session in network are known as connection. A socket is the known network connection implementation. When referring to a network connection, most of the times, a text will refer to a TCP connection...
Card Puncher Data Processing
Oracle Apex - Session (or application context)

A Session is created after : the authentication of a user the first visit of a public user with the zero session feature Each session is assigned a unique identifier. The Application Express...
Card Puncher Data Processing
PHP - Session

in Php session
Data System Architecture
RDBMS - Cursor (Iterator)

A cursor represents data returned by a query. In computer science, a database cursor is a control structure that enables traversal over the records in a database. A cursor: contains tabular data ...
Card Puncher Data Processing
Sql Server - Session

in Sql Server
Card Puncher Data Processing
User Analytics - Session (Visit)

A session on a analytical level is a group of user interactions that take place within a given time frame. A single session can contain multiple: page views, events, social interactions, and...

Share this page:
Follow us:
Task Runner