Gravity data management relies on standard Structured Query Language (SQL) relational database technology to store and retrieve metadata. It includes user specific metadata as well as media metadata such as file name, size, location, CODECS, track types, aspect ratio and frame rate. Internally, all Gravity components use XML as a data transport wherever possible. When making direct SQL requests, they are done in a generic way, enabling them to be vendor-independent.
The Data Server can be configured in high-availability mode using continuous, real-time transaction forwarding to a secondary (backup) SQL Server. Its granular authentication, authorization, and permissions enable permission levels assignable to every SQL object, including databases, tables, columns, views, and procedures. It employs certificate, asymmetric and symmetric key encryption supported for password and other secure item storage. This provides great flexibility to meet a range of operational requirements for multi-user and/or multi-site systems. There are customizable schemas for tables, fields, views, and indices. Third party integration is supported through the capability to allow read-only access to third party vendors and products and to create protected, shared database objects for vendor integration.
There are extensive searching and filtering tools which allow full and partial filtered queries on all relational data. XML queries are via XPATH and XQUERY and XML is used for import and export of metadata. Search transaction histories are retained for a pre-determined period of time.
The data server includes the following databases: