---
title: "Data Dictionary Data Model"
description: "The Invantive UniversalSQL data dictionary contains the metadata of your current environment."
language: it
source_language: en
translation_state: pending
canonical: https://documentation.invantive.eu/it/datamodels/datadictionary
original: https://documentation.invantive.eu/en/datamodels/datadictionary
updated: 2026-11-16T20:45:59Z
license: https://documentation.invantive.eu/it/
---

# Data Dictionary Data Model

Il dizionario dati Invantive UniversalSQL contiene i metadati dell'ambiente corrente.

For example, the view SystemTables@DataDictionary contains every available table and view in the current database. Besides object definitions also actual execution information is available in views. For example, the view SystemSqlArea@DataDictionary contains all executed and cached Invantive SQL statements. The data in the data dictionary views is generated dynamically by Invantive SQL from the runtime environment. Changing data in the data dictionary views is not possible.

I confronti tra testi su questa piattaforma tengono conto delle maiuscole e delle minuscole.

## Piattaforma

- Utilizzabile da: Invantive Cloud e dai prodotti Invantive installati sul proprio computer o server.
- Tipo: un'applicazione accessibile tramite la propria API.
- I dati sono suddivisi, ad esempio per azienda o per amministrazione.
- Una query può leggere i dati di più aziende contemporaneamente.
- Invantive Cloud plans: Free for public data, Free, Office for Entrepreneurs, Office for Accountants, Premium Finance.

## Figure

| Figure | Count |
|---|---:|
| Tables | 94 |
| Columns | 2,195 |
| Tabella con inserti | 2 |
| Tabella con aggiornamento | 1 |
| Tabella con la clausola DELETE | 1 |
| Tabella documentata | 5 |

## Tabelle

### DataDictionary.Invantive

- [AUDITEVENTS](DataDictionary.Invantive.AUDITEVENTS): Audit Events
- [CALENDAR](DataDictionary.Invantive.CALENDAR): Calendar
- [DOUBLE](DataDictionary.Invantive.DOUBLE): Single Row
- [DUAL](DataDictionary.Invantive.DUAL): Single Row
- [EMPTY](DataDictionary.Invantive.EMPTY): Empty Table
- [HTTPDOWNLOAD](DataDictionary.Invantive.HTTPDOWNLOAD)
- [HTTPDOWNLOADCOOKIESHISTORY](DataDictionary.Invantive.HTTPDOWNLOADCOOKIESHISTORY): Download Cookies History
- [HTTPDOWNLOADHISTORY](DataDictionary.Invantive.HTTPDOWNLOADHISTORY): HTTP Download History
- [JSONRECORDTYPECOLUMNS](DataDictionary.Invantive.JSONRECORDTYPECOLUMNS): JSON Record Type Columns
- [JSONRECORDTYPES](DataDictionary.Invantive.JSONRECORDTYPES): JSON Record Types
- [PERFORMANCEMEASUREMENTSLIVE](DataDictionary.Invantive.PERFORMANCEMEASUREMENTSLIVE): Live Performance Measurements
- [RANGE](DataDictionary.Invantive.RANGE): Number Generator
- [SESSIONIOS](DataDictionary.Invantive.SESSIONIOS): Session I/Os
- [SESSIONROWSCHANGED](DataDictionary.Invantive.SESSIONROWSCHANGED): Rows Changed in Session
- [SYSTEMANONYMIZATIONMAPS](DataDictionary.Invantive.SYSTEMANONYMIZATIONMAPS): Anonymization Maps
- [SYSTEMANONYMIZATIONMAPVALUES](DataDictionary.Invantive.SYSTEMANONYMIZATIONMAPVALUES): Anonymization Map Values
- [SYSTEMANONYMIZATIONPREDEFINEDMAPS](DataDictionary.Invantive.SYSTEMANONYMIZATIONPREDEFINEDMAPS): Anonymization Predefined Maps
- [SYSTEMCATALOGS](DataDictionary.Invantive.SYSTEMCATALOGS): Catalogs
- [SYSTEMCOUNTRIES](DataDictionary.Invantive.SYSTEMCOUNTRIES): Countries
- [SYSTEMDATABASES](DataDictionary.Invantive.SYSTEMDATABASES): Databases
- [SYSTEMDATACONTAINERATTRIBUTES](DataDictionary.Invantive.SYSTEMDATACONTAINERATTRIBUTES): Data Container Attributes and Their Values
- [SYSTEMDATACONTAINERHTTPCACHECONTENTS](DataDictionary.Invantive.SYSTEMDATACONTAINERHTTPCACHECONTENTS): System Data Container HTTP Cache Contents
- [SYSTEMDATACONTAINERMESSAGES](DataDictionary.Invantive.SYSTEMDATACONTAINERMESSAGES): Data Container Messages
- [SYSTEMDATACONTAINERPROPERTIES](DataDictionary.Invantive.SYSTEMDATACONTAINERPROPERTIES): Data Container Properties
- [SYSTEMDATACONTAINERRESERVEDWORDS](DataDictionary.Invantive.SYSTEMDATACONTAINERRESERVEDWORDS): Provider Reserved Words
- [SYSTEMDATACONTAINERS](DataDictionary.Invantive.SYSTEMDATACONTAINERS): Datacontainer
- [SYSTEMDATACONTAINERSLOTBASEDRATELIMITERS](DataDictionary.Invantive.SYSTEMDATACONTAINERSLOTBASEDRATELIMITERS): Provider Slot-based Rate Limiters
- [SYSTEMDATACONTAINERSLOTBASEDRATELIMITERSLOTS](DataDictionary.Invantive.SYSTEMDATACONTAINERSLOTBASEDRATELIMITERSLOTS): Provider Slot-based Rate Limiter Slots
- [SYSTEMDOMAINCODES](DataDictionary.Invantive.SYSTEMDOMAINCODES): Code/value Domains
- [SYSTEMDOMAINCODEVALUES](DataDictionary.Invantive.SYSTEMDOMAINCODEVALUES): Domain Values
- [SYSTEMFILTERTOTABLEFUNCTIONPARAMETERS](DataDictionary.Invantive.SYSTEMFILTERTOTABLEFUNCTIONPARAMETERS): Filter to Table Function Parameters
- [SYSTEMFUNCTIONS](DataDictionary.Invantive.SYSTEMFUNCTIONS): System Functions
- [SYSTEMGLOSSARIES](DataDictionary.Invantive.SYSTEMGLOSSARIES): Glossaries
- [SYSTEMGLOSSARYTERMS](DataDictionary.Invantive.SYSTEMGLOSSARYTERMS): Glossary Terms
- [SYSTEMGLOSSARYTERMTRANSLATIONS](DataDictionary.Invantive.SYSTEMGLOSSARYTERMTRANSLATIONS): Glossary Term Translations
- [SYSTEMLANGUAGES](DataDictionary.Invantive.SYSTEMLANGUAGES): Languages
- [SYSTEMLICENSEMODULES](DataDictionary.Invantive.SYSTEMLICENSEMODULES): Licence Modules
- [SYSTEMLICENSES](DataDictionary.Invantive.SYSTEMLICENSES): Licenses
- [SYSTEMLOCKS](DataDictionary.Invantive.SYSTEMLOCKS): Locks
- [SYSTEMLOGGINGMESSAGECOUNTERSTATISTICS](DataDictionary.Invantive.SYSTEMLOGGINGMESSAGECOUNTERSTATISTICS): Logging Message Counter Statistics
- [SYSTEMMANAGEDFILEACTIONS](DataDictionary.Invantive.SYSTEMMANAGEDFILEACTIONS): Managed File Actions
- [SYSTEMMANAGEDFILES](DataDictionary.Invantive.SYSTEMMANAGEDFILES): Managed Files
- [SYSTEMOAUTHFLOWEVENTS](DataDictionary.Invantive.SYSTEMOAUTHFLOWEVENTS): OAuth Flow Events
- [SYSTEMPACKAGEFUNCTIONARGUMENTS](DataDictionary.Invantive.SYSTEMPACKAGEFUNCTIONARGUMENTS): Package Function Arguments
- [SYSTEMPACKAGEFUNCTIONS](DataDictionary.Invantive.SYSTEMPACKAGEFUNCTIONS): Package Functions
- [SYSTEMPACKAGES](DataDictionary.Invantive.SYSTEMPACKAGES): Packages
- [SYSTEMPARTITIONS](DataDictionary.Invantive.SYSTEMPARTITIONS): Partitions
- [SYSTEMPARTITIONSTATISTICS](DataDictionary.Invantive.SYSTEMPARTITIONSTATISTICS): System Partition Statistics
- [SYSTEMPARTITIONTAGS](DataDictionary.Invantive.SYSTEMPARTITIONTAGS): System Partition Tags
- [SYSTEMPREEMPTIVELOADCANDIDATES](DataDictionary.Invantive.SYSTEMPREEMPTIVELOADCANDIDATES): Pre-emptive Load Candidates
- [SYSTEMPREEMPTIVELOADHINTS](DataDictionary.Invantive.SYSTEMPREEMPTIVELOADHINTS): Pre-emptive Load Hints
- [SYSTEMPREEMPTIVELOADINGPARTITIONS](DataDictionary.Invantive.SYSTEMPREEMPTIVELOADINGPARTITIONS): Pre-emptive Loading Partitions
- [SYSTEMPROPERTIES](DataDictionary.Invantive.SYSTEMPROPERTIES): System Properties and Their Values
- [SYSTEMPROVIDERATTRIBUTES](DataDictionary.Invantive.SYSTEMPROVIDERATTRIBUTES): System Provider Attributes
- [SYSTEMPROVIDERS](DataDictionary.Invantive.SYSTEMPROVIDERS): Providers
- [SYSTEMPROVIDERSACTIVE](DataDictionary.Invantive.SYSTEMPROVIDERSACTIVE): Active System Providers
- [SYSTEMPROVIDERSAMPLEQUERIES](DataDictionary.Invantive.SYSTEMPROVIDERSAMPLEQUERIES): Provider Sample Queries
- [SYSTEMPSQLATOMICS](DataDictionary.Invantive.SYSTEMPSQLATOMICS): PSQL Atomic Values
- [SYSTEMPSQLLOCKS](DataDictionary.Invantive.SYSTEMPSQLLOCKS): PSQL Locks
- [SYSTEMRECENTLOGGINGMESSAGES](DataDictionary.Invantive.SYSTEMRECENTLOGGINGMESSAGES): Logging Messages
- [SYSTEMRELATIONANALYSISRELATIONS](DataDictionary.Invantive.SYSTEMRELATIONANALYSISRELATIONS): Relation Analysis Relations
- [SYSTEMRELATIONANALYSISTABLES](DataDictionary.Invantive.SYSTEMRELATIONANALYSISTABLES): Relation Analysis Tables
- [SYSTEMSCHEMAS](DataDictionary.Invantive.SYSTEMSCHEMAS): Schemas
- [SYSTEMSQLAREA](DataDictionary.Invantive.SYSTEMSQLAREA): SQL Statements Executed
- [SYSTEMSQLEXECUTIONS](DataDictionary.Invantive.SYSTEMSQLEXECUTIONS): SQL Executions
- [SYSTEMSQLEXECUTIONSLEEPS](DataDictionary.Invantive.SYSTEMSQLEXECUTIONSLEEPS): SQL Execution Sleeps
- [SYSTEMSQLEXECUTIONSTEPS](DataDictionary.Invantive.SYSTEMSQLEXECUTIONSTEPS): SQL Execution Steps
- [SYSTEMSQLPRECOMPILEDEXPRESSIONS](DataDictionary.Invantive.SYSTEMSQLPRECOMPILEDEXPRESSIONS): SQL Pre-compiled Expressions
- [SYSTEMTABLECOLUMNS](DataDictionary.Invantive.SYSTEMTABLECOLUMNS): Table Columns
- [SYSTEMTABLECOLUMNSLIVE](DataDictionary.Invantive.SYSTEMTABLECOLUMNSLIVE): Live Retrieved Table Columns
- [SYSTEMTABLEFOREIGNKEYS](DataDictionary.Invantive.SYSTEMTABLEFOREIGNKEYS): Foreign Keys
- [SYSTEMTABLEFUNCTIONPARAMETERS](DataDictionary.Invantive.SYSTEMTABLEFUNCTIONPARAMETERS): Table Function Parameters
- [SYSTEMTABLEFUNCTIONPARAMETERSLIVE](DataDictionary.Invantive.SYSTEMTABLEFUNCTIONPARAMETERSLIVE): Live Retrieve Table Function Parameters
- [SYSTEMTABLEKEYS](DataDictionary.Invantive.SYSTEMTABLEKEYS): Table Keys
- [SYSTEMTABLES](DataDictionary.Invantive.SYSTEMTABLES): Tables
- [SYSTEMTIMEZONES](DataDictionary.Invantive.SYSTEMTIMEZONES): Time Zones
- [SYSTEMTRANSLATIONS](DataDictionary.Invantive.SYSTEMTRANSLATIONS): Translations
- [SYSTEMUSERS](DataDictionary.Invantive.SYSTEMUSERS): System Users
- [SYSTEMUTCOFFSETS](DataDictionary.Invantive.SYSTEMUTCOFFSETS): UTC Offsets
- [SYSTEMVIEWS](DataDictionary.Invantive.SYSTEMVIEWS): Database Views
- [TIPSBYTERM](DataDictionary.Invantive.TIPSBYTERM): Tips by Term
- [USERMESSAGES](DataDictionary.Invantive.USERMESSAGES): User Messages
- [USERSETTINGS](DataDictionary.Invantive.USERSETTINGS): System User Settings
- [WEEKDAYS](DataDictionary.Invantive.WEEKDAYS): Days of the Week

### DataDictionary.Views

- [Test0Rows10000Sec](DataDictionary.Views.Test0Rows10000Sec)
- [Test0Rows1000Sec](DataDictionary.Views.Test0Rows1000Sec)
- [Test0Rows100Sec](DataDictionary.Views.Test0Rows100Sec)
- [Test1000000Rows1000Mb10000Sec](DataDictionary.Views.Test1000000Rows1000Mb10000Sec)
- [Test1000000Rows1000Mb1000Sec](DataDictionary.Views.Test1000000Rows1000Mb1000Sec)
- [Test1000000Rows1000Mb1Sec](DataDictionary.Views.Test1000000Rows1000Mb1Sec)
- [Test10000Rows100Mb100Sec](DataDictionary.Views.Test10000Rows100Mb100Sec)
- [Test1000Rows1Mb1000Sec](DataDictionary.Views.Test1000Rows1Mb1000Sec)
- [Test100Rows1Mb100Sec](DataDictionary.Views.Test100Rows1Mb100Sec)
- [Test10Rows1000Mb1Sec](DataDictionary.Views.Test10Rows1000Mb1Sec)

## Attributi

The attributes of this platform are on the page [Attributes](attributes).


## Note di rilascio

Cosa è cambiato, versione per versione, nelle tabelle, nelle colonne, negli attributi e nelle funzionalità del driver:

- [Data Dictionary](/it/release-notes/drivers?driver=data-dictionary)
