xdm.database

Cortex Data Model Schema Guide

Last date published
2024-04-14

A database action such as query/update/alter.

xdm.database.connection_id

Description

The ID of the connection to the database server.

Datatype

String

Dataclass

Scalar

xdm.database.connection_flags

Description

The flags regarding the client connection to the database server.

Datatype

String

Dataclass

Scalar

xdm.database.operation

Description

The database operation name.

Datatype

XDM_CONST.DB_OPERATION

Dataclass

Scalar

Examples

XDM_CONST.DB_OPERATION_QUERY, XDM_CONST.DB_OPERATION_UPDATE, XDM_CONST.DB_OPERATION_CREATE, XDM_CONST.DB_OPERATION_DELETE, XDM_CONST.DB_OPERATION_ALTER

xdm.database.name

Description

The database name.

Datatype

String

Dataclass

Scalar

xdm.database.schema

Description

The schema context in which the action occurred.

Datatype

String

Dataclass

Scalar

xdm.database.tables

Description

The names of the tables used in the query.

Datatype

String

Dataclass

Array

xdm.database.statement

Description

The actual query.

Datatype

String

Dataclass

Scalar

xdm.database.affected_rows

Description

The number of rows affected by the query.

Datatype

Number

Dataclass

Scalar

xdm.database.response_time

Description

The operation runtime in seconds.

Datatype

Number

Dataclass

Scalar