DW Spectrum Server Database Files

-----------------------------------

Affected Roles:  Owner, Administrator

Related Digital Watchdog VMS Apps:  DW Spectrum IPVMS

Last Edit:  February 29, 2024

-----------------------------------

 

DW Spectrum Databases

The DW Spectrum Server program uses a combination of database technologies for system storage, regular operation, etc.

This article will outline the file locations and provide a brief overview of the databases that are used to keep your DW Spectrum System running.

 

**IMPORTANT:  NEVER modify database files in a System without expressed direction from the DW Support team.

 

Database Overview

System Database (SQLite, synchronized)

The System Database is the main database that keeps a DW Spectrum System running. When a database backup is created in Spectrum, this is what is backed up. It is system-wide and is synchronized across every Server within a merged system.

Database Technology: SQLite

Synchronized (?): Yes

Contents:

• User Rights & Settings
• System Settings
• Device Configuration

Database Location

• Windows

 

• Ubuntu/Linux

 

Server Database (SQLite, not synchronized)

The Server Database is a local database that keeps track of all events, bookmarks, and operator actions. It is kept locally for every Server and is not synchronized across every Server in a merged system.

Database Technology: SQLite

Synchronized (?): No

Contents:

• Event Log
• Bookmarks
• Operator Actions Log

Database Location

• Windows

 

• Ubuntu/Linux

 

Archive Index (NXDB, not synchronized)

The Archive Index is a local database where recorded video for each camera is stored. It is kept locally for every Server and is not synchronized across every Server in a merged system.

Database Technology: .NXDB (proprietary)

Synchronized (?): No

Contents:

• Storage index for recorded video (used for recall and timeline)

Database Location:

The Archive Index file is located next to the recorded archives (on the same drive as the archive).

For more information on archive media storage locations, you can refer to the article, “DW Spectrum – Storage Adjustments for Version 5.0 and Newer”.

 

Smart Motion Index (binary, not synchronized)

DW Spectrum Server keeps Smart Search index files for all recorded video in a binary format. They are kept locally and are not synchronized across every Server in a merged system. The Server program reports this information to the rest of the system while online, which are used for Smart Motion Searches while using the DW Spectrum Client desktop application.

Database Technology: Binary Format

Synchronized (?): No

Contents:

• Motion index for recorded video (binary format)

Database Location

Use the camera physical ID to find the corresponding folders for each camera.

• Windows

 

• Ubuntu/Linux

 

Object Metadata (not synchronized)

Object Metadata is essentially a set of different files that are used to store information about the objects that are generated by analytics plugins. These files are required to visualize object detection on the Timeline and to form a response to search queries.

Synchronized (?): No

Contents:

• Objects index
• Various objects metadata

Database Location:

• User-defined archive directory
  • “archive” – subdirectory with a particular structure.
  • “object_detection.sqlite*” – set of files with metadata inside.

 

 

 

For More Information or Technical Support

DW Technical Support:  866.446.3595 (option 4)

https://www.digital-watchdog.com/contact-tech-support/

______________________________________________________________________________

DW Sales:  866.446.3595                   [email protected]        www.digital-watchdog.com