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
C:\Windows\System32\config\systemprofile\AppData\Local\Digital Watchdog\DW Spectrum Media Server\ecs.sqlite
- Ubuntu/Linux
/opt/dwspectrum/mediaserver/var/ecs.sqlite
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
C:\Windows\System32\config\systemprofile\AppData\Local\Digital Watchdog\DW Spectrum Media Server\mserver.sqlite
- Ubuntu/Linux
/opt/dwspectrum/mediaserver/var/mserver.sqlite
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
C:\Windows\System32\config\systemprofile\AppData\Local\Digital Watchdog\DW Spectrum Media Server\record_catalog\metadata
- Ubuntu/Linux
/opt/dwspectrum/mediaserver/var/record_catalog/metadata
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