This chapter documents the available schemas in the standard Lire suite. For each superservice, the base schema is explained, followed by any extended and derived schemas.
Schema ID: database
Timestamp Field: time
A record in the database DLF schema represents one event in the database. This may be a connection from a client, a SQL query, etc.
Fields in the Schema
The time at which the event occured.
The name of the user who executed the command.
The host from which the user executed the command.
The command that was executed. Commands you are likely to encounter are connect, disconnect, shutdown and query.
The database name on which the command was executed.
When the command field is a query, this field contains the actual SQL query that was executed.
Did the command succeeded?
When the success field is false, i.e. when the command failed, this field should contains the logged error message.
An "appropriate" "connection label" for the backend that can be used for session analysis in conjunction with the timestamp, username and database fields. This can be a connection identifier, a PID, a real session ID or whatever makes sense in the particular backend.
Schema ID: database-querytype
Base Schema: database
Required Fields: query
An extended schema for the database superservice which extracts the query type from the query that was made.