Data Model

Feature

Germain UX's Data Model is highly customizable, allowing users to define their own objects and structure within the system.

The Germain Data Model comprises various dimensions and facts that organize and represent the data stored in the system. While the specific structure of the data model will depend on the organization's requirements and configurations, below is a sample representation of what the Germain Data Model may look like:

Dimensions

• User: Represents information about users, such as user ID, name, role, or any other relevant user attributes.

• Application: Contains details about applications being monitored, including application ID, name, version, and other relevant information.

• Server: Represents server-related information, such as server ID, name, location, or any other server attributes.

• Transaction: Contains details about individual transactions, such as transaction ID, timestamp, duration, status, or any other transaction-specific information.

• Error: Represents error-related information, including error ID, error message, error type, severity, and any other relevant error attributes.

• Performance: Contains performance-related metrics, such as response time, latency, throughput, or any other performance indicators.

Facts

• User Activity: Captures user interactions within the application, such as clicks, page views, form submissions, or any other user activities.

• Application Performance: Represents performance metrics specific to applications, such as average response time, error rate, or any other application performance indicators.

• Server Performance: Contains server-related performance metrics, including CPU usage, memory usage, disk space, or any other server performance measurements.

• Transaction Performance: Captures performance metrics for individual transactions, such as transaction duration, execution time, or any other transaction-specific performance data.

• Error Logs: Stores information about errors, including error details, timestamps, severity, or any other error-related data.

The Germain Data Model provides a structured framework for organizing and analyzing data collected by Germain UX. Users can further customize the data model to align with their specific monitoring needs and business requirements.

To access the complete view of the data model in your Germain instance, you can use the provided URL: https://INSTANCE_NAME/query/metadata/types. This will provide a comprehensive overview of the data model, including all defined dimensions and facts within your Germain implementation.

Please note that the URL provided is a placeholder and should be replaced with the actual URL of your Germain instance.

Also note that when a value is “null”, GermainUX interpretes it as "false" and “not null” as "true" for boolean fields like "drop-off".

Configuration

Dimensions

TimeDimension

• time.year

• time.month

• time.day

• time.hour

• time.minute

SystemDimension

• system.name

• system.hostname

• system.type

• system.environment

• system.location.continent

• system.location.country

• system.location.region

• system.location.city

TargetDimension

• target.name

• target.hostname

• target.type

• target.environment

• target.location.continent

• target.location.country

• target.location.region

• target.location.city

UserDimension

• user.name

• user.department

• user.group

• user.role

• user.type

• user.location.continent

• user.location.country

• user.location.region

• user.location.city

UserAgentDimension

• userAgent.device

• userAgent.family

• userAgent.browser

• userAgent.os

PageDimension

• page.path

• page.query

• page.title

CampaignDimension

• campaign.name

• campaign.source

• campaign.medium

• campaign.term

• campaign.content

HierarchyDimension

• hierarchy.level1

• hierarchy.level2

• hierarchy.level3

• hierarchy.level4

HttpRequestDimension

• http.path

• http.query

• http.method

• http.status

• http.message

ApplicationDimension

• application.name

• application.component

DatabaseDimension

• database.name

• database.flavor

SiebelDimension

• siebel.screen

• siebel.view

• siebel.applet

• siebel.command

RefererDimension

• ref.url

• ref.type

• ref.subtype

MobileDeviceDimension

• device.manufacturer

• device.brand

• device.model

• device.os

• device.osName

• device.osVersion

• device.sdkVersion

• device.resolution

• device.location.continent

• device.location.country

• device.location.region

• device.location.city

NetworkDimension

• network.type

• network.connectionType

• network.fastConnection

• network.ip

Facts

GenericBusinessProcess (generic BPs)

• Time

• System

• User

• User Agent

• Application

• Hierarchy

• type

• name

• sessionId

• status

• currentStep

• anyStepOutside

• businessObject

• color

• progress

• metric1

• metric2

• metric3

• metric4

• metric5

GenericBusinessProcessStep (steps for generic BPs)

• Time

• System

• User

• User Agent

• Application

• Hierarchy

• type

• name

• bpId

• bpClass

• label

• prevStepLabel

• factId

• factClass

• sessionId

• status

• outsideStep

• businessObject

• color

LongLivedBusinessProcess

• same as GenericBusinessProcess

LongLivedBusinessProcessStep

• same as GenericBusinessProcessStep

SiebelBusinessProcess (Siebel related BPs)

• same as GenericBusinessProcess + additional attributes:

• Siebel

SiebelBusinessProcessStep (Siebel steps for generic BPs)

• same as GenericBusinessProcessStep+ additional attributes:

• Siebel

GenericEvent 

• Time

• System

• User

• Database

• Application

• type

• name

• pid

• tid

• sessionId

• businessObject

• color

GenericMetric (e.g.CPU Usage)

• Time

• System

• Database

• Application

• type

• name

• pid

• tid

• sessionId

• color

GenericTransaction

• Time

• System

• User

• Database

• Application

• type

• name

• pid

• tid

• sessionId

• status

• businessObject

• color

MobileEvent

• Time

• Device

• User

• Application

• Network

• name

• pid

• sessionId

• businessObject

• color

MobileMetric

• Time

• Device

• User

• Application

• Network

• name

• pid

• sessionId

• businessObject

• color

MobileTransaction

• Time

• Device

• User

• Application

• Network

• name

• pid

• sessionId

• businessObject

• color

MobileProcessMetric

• Time

• Device

• Application

• Network

• name

• pid

• state

• color

UxConsoleEvent

• Time

• System

• Target

• User

• User Agent

• Application

• Page

• Http

• Hierarchy

• type

• name

• level

• message

• sessionId

• businessObject

• details

• color

• success

UxEvent (e.g. Mouse click)

• Time

• System

• Target

• User

• User Agent

• Application

• Page

• Http

• Hierarchy

• type

• name

• domName

• domLabel

• displayedName

• sessionId

• businessObject

• color

• success

UxMetric (e.g. Response size)

• Time

• System

• Target

• User

• User Agent

• Application

• Page

• Http

• Hierarchy

• type

• name

• sessionId

• businessObject

• color

• value

UxTransaction

• Time

• System

• Target

• User

• User Agent

• Application

• Page

• Http

• Hierarchy

• type

• name

• sessionId

• businessObject

• color

• duration

UxChangeTransaction (user input change transaction)

• Time

• System

• Target

• User

• User Agent

• Application

• Page

• Hierarchy

• type

• name

• domName

• domLabel

• domValue

• sessionId

• businessObject

• duration

• success

• color

UserClick

• Time

• System

• Target

• User

• User Agent

• Application

• Page

• Hierarchy

• Campaign

• type

• name

• correlationId

• sessionId

• businessObject

• label

• duration

• networkDuration

• renderDuration

• scriptDuration

• idleDuration

• firstInputDuration

• largestPaintDuration

• longestTaskDuration

• domProcessDuration

• domLoadDuration

• fullPage

• memoryUsage

• success

• color

UxSession (UX session replay data point)

• Time

• System

• Target

• User

• User Agent

• Application

• LandingPage

• ExitPage

• Campaign

• Ref

• type

• name

• correlationId

• sessionId

• returningUser

• duration

• activeDuration

• errorCount

• positiveFeedbackCount

• negativeFeedbackCount

• feedbackCommentCount

• feedbackComments

• pageVisited

• status

• color

OutboundHttpRequest (HTTP request transaction)

• Time

• System

• Target

• User

• User Agent

• Application

• Http

• type

• name

• sessionId

• success

• businessObject

• color

• requestBody

• responseBody

• cached

• compressed

• aborted

• duration

• redirectDuration

• stalledDuration

• dnsDuration

• connectDuration

• sslDuration

• waitDuration

• downloadDuration

• responseSize

• activeDuration

OutboundDocumentRequest(HTTP request transaction)

• same as OutboundHttpRequest

• domProcessDuration

• domLoadDuration

SiebelOutboundHttpRequest (Siebel HTTP request transaction)

• same as OutboundHttpRequest + additional attributes:

• Siebel

InboundHttpRequest

• Time

• System

• Source

• User

• User Agent

• Application

• Http

• name

• sessionId

• success

• businessObject

• color

• duration

• requestSize

• responseSize

SiebelTransaction (base model for other Siebel related transactions)

• Time

• System

• User

• Database

• Application

• Siebel

• type

• name

• pid

• tid

• sessionId

• businessObject

• success

• taskId

• color

SiebelWorkflowTransaction

• same as SiebelTransaction

SiebelWorkflowStepTransaction

• same as SiebelTransaction

SiebelWorkflowServiceTransaction

• same as SiebelTransaction + additional attributes:

• method

SiebelWebServiceTransaction

• same as SiebelTransaction + additional attributes:

• method

SiebelWebEngineTransaction

• same as SiebelTransaction + additional attributes:

• method

SiebelUserTransaction

• same as SiebelTransaction + additional attributes:

• target

SiebelToolkitServiceTransaction

• same as SiebelTransaction + additional attributes:

• method

SiebelTaskServiceTransaction

• same as SiebelTransaction + additional attributes:

• method

SiebelStateServiceTransaction

• same as SiebelTransaction + additional attributes:

• method

SiebelDatabaseTransaction

• same as SiebelTransaction + additional attributes:

• queryId

SiebelServiceTransaction

• same as SiebelTransaction + additional attributes:

• method

SiebelErrorEvent

• same as GenericEvent + additional attributes:

• Siebel

• taskId

ProfilerSnapshot (CPU snapshot for Java and .net)

• Time

• System

• Application

• type

• name

• pid

• color

ProcessMetric (OS process metric)

• Time

• System

• type

• name

• pid

• color

NetworkMetric (network latency metric)

• Time

• Source (attribute starts with source. but has same attributes as System)

• Target (attribute starts with target. but has same attributes as System)

• type

• name

• pid

• color

ThreadMetric (OS thread metric)

• Time

• System

• type

• name

• pid

• tid

• state

• color

JavaTransaction

• Time

• System

• User

• Application

• className

• name

• pid

• tid

• sessionId

• businessObject

• success

• color

JavaHttpRequestTransaction

• same as JavaTransaction + additional attributes:

• User Agent

• method

• status

• path

• query

• ip

• headers

JavaDatabaseTransaction

• same as JavaTransaction + additional attributes:

• Database

• queryId

• queryText

JavaEvent

• Time

• System

• User

• Application

• className

• name

• pid

• tid

• sessionId

• businessObject

• success

• color

SalesforceTransaction

• Time

• System

• Target

• User

• User Agent

• Application

• type

• name

• sessionId

• success

• color

• duration

• cpuTime

• databaseDuration

• requestType

• eventSource

• requestId

• userId

• requestStatus

• entityName

• details

SalesforceApexTransaction

• same as SalesforceTransaction + additional attributes:

• entryPoint

• uri

• triggerName

• triggerType

• quiddity

• longRunningProcess

• networkDuration

• soqlQueryCount

• rowsProcessed

• fieldCount

SalesforceAuditLog

• recordId

• parentId

• dataType

• fieldName

• details

• aggLevel1

• aggLevel2

• aggLevel3

• aggLevel4

• aggLevel5

• aggLevel6

• aggLevel7

• aggLevel8

• aggLevel9

• aggLevel10

• rawLevel1

• rawLevel2

• rawLevel3

• rawLevel4

• rawLevel5

• rawLevel6

• rawLevel7

• rawLevel8

• rawLevel9

• rawLevel10

• oldValue

• newValue

• oldNumericValue

• newNumericValue

SalesforceDatabaseTransaction

• same as SalesforceTransaction + additional attributes:

• action

• query

• search

• filter

• orderBy

• parentCallout

• queryOffset

• executionDuration

• fetchDuration

• rowCount

• rowsFetchedCount

• byteCount

SalesforceEvent

• Time

• System

• Target

• User

• User Agent

• Application

• Http

• name

• queriedEntities

• query

• sessionId

• businessObject

• details

• metric1

• metric2

• metric3

SalesforceHttpRequest

• same as SalesforceTransaction + additional attributes:

• Http

• Ref

• mimeType

• firstRequest

• requestSize

• responseSize

• databaseCpuTime

• databaseBlockCount

• rowsProcessed

• fieldCount

SalesforceUiEvent

• Time

• System

• Target

• User

• User Agent

• Application

• componentName

• connectionType

• pageAppName

• pageContext

• entityName

• uri

• userId

• requestId

• sessionId

• uiEventId

• uiEventSource

• uiEventType

• targetUiElement

• parentUiElement

• grandparentUiElement

• userType

• name

• details

• duration

SalesforceUserTransaction

• same as SalesforceTransaction + additional attributes:

• apiType

• uri

Feature Availability: 2022.1 or later