The Nx Witness Mediaserver application uses a combination of databases to accomplish its amazing features. Below, we outline the details of each database required in order to keep your Nx Witness System up and running.

NOTE: Never modify database files in a System without an explicit request from the Nx Support Team.  

Site Database (SQLite, synchronized)

The Site Database is the main database that keeps a Site up and running. When you create a backup of your Site's database - this is what gets backed up.

Database Technology: SQLite

Synchronized: Yes

Contents:

• User Rights & Settings
• System Settings
• Device Configuration

Database Location: 

• Windows

  C:\Windows\System32\config\systemprofile\AppData\Local\Network Optix\Network Optix Media Server\ecs.sqlite

• Ubuntu

  /opt/networkoptix/mediaserver/var/ecs.sqlite

Server Database

The Server Database is a local database that keeps track of all events, bookmarks and operator actions. It's local for every Server and is not synchronized.

Database Technology: SQLite

Synchronized: No

Database Location: 

• Windows

  C:\Windows\System32\config\systemprofile\AppData\Local\Network Optix\Network Optix Media Server\mserver.sqlite

• Ubuntu

  /opt/networkoptix/mediaserver/var/mserver.sqlite

Archive Index

Database Technology: .nxdb (proprietary)

Synchronized: No

Contents: Storage index for recorded video (used for recall and timeline)

Database Location: 

• Windows

  C:\<mediaFolder>\<storageId>\<storageId>.nxdb

• Ubuntu

  /<mount>/<user>/data/HD Witness Media/<storageId>/<storageId>.nxdb

Smart Motion Index 

The Media Server keeps the Smart Search index files for all recorded video in a binary format. They're also not synced across the Site and are local to the Server. The Media Server reports this information to the rest of the System while it's online. 

Database Technology: Index Files in Binary Format

Synchronized: No

Contents: Motion index for recorded video (binary format)

Database Location: 

• Windows

  C:\<mediaFolder>\<storageId>\motion_data\metadata\<deviceMacAddress>\<year>\<month>\motion_detailed_data.bin

• Ubuntu

  /<mount>/<user>/data/HD Witness Media/<storageId>/<storageId>.nxdb

Object Metadata

A set of different files that are used to store information about the objects generated by the analytics plugins. These files are required to visualize the detection on the timeline and to form a response to the search queries (in the search bar or over the API).

Database Technology: .nxdb (proprietary) and Index Files in Binary Format

Synchronized: No

Contents:

• Objects index
• Various objects metadata

Database Location: 

• Windows

  C:\<mediaFolder>\<storageId>\object_detection.nxdb
  C:\<mediaFolder\<storageId>\archive\metadata\<deviceId>\<year>\<month>\analytics_*_*.bin

• Ubuntu

  /<mediaFolder>/<storageId>/object_detection.nxdb
  /<mediaFolder>/<storageId>/archive/metadata/<deviceId>/<year>/<month>/analytics_*_*.bin

Please note that the paths for the Object Metadata are just a sample, as you can set/change the storage path for the analytics database. The location can be easily found in the Server Settings menu, tab Storage Management and append the path with the storage ID, etc. as shown in the sample paths.