Data Dictionary Data Model
Das Invantive UniversalSQL-Datenwörterbuch enthält die Metadaten Ihrer aktuellen Umgebung.
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.
Bei Textvergleichen auf dieser Plattform wird zwischen Groß- und Kleinschreibung unterschieden.
Plattform
- Verwendung über: Invantive Cloud und die Invantive-Produkte auf Ihrem eigenen Computer oder Server.
- Art: Eine Anwendung, auf die über ihre API zugegriffen wird.
- Die Daten sind partitioniert, beispielsweise nach Unternehmen oder Verwaltungsbereich.
- Mit einer Query können mehrere Unternehmen gleichzeitig abgerufen werden.
- Invantive Cloud plans: Free for public data, Free, Office for Entrepreneurs, Office for Accountants, Premium Finance.
Angaben
| Figure | Count |
|---|---|
| Tables | 94 |
| Columns | 2,195 |
| Tabellen mit Einfügung | 2 |
| Tabellen mit Aktualisierung | 1 |
| Tabellen mit Löschfunktion | 1 |
| Tabellen dokumentiert | 5 |
Poster zum Daten Muster
Auf einer Tabelle des Posters: Zoom-Vergrößerung und Zoom-Verkleinung, mit den Pfeiltasten bewegen, 0 passt.
Das Poster als Text: Tabellen nach Themen und deren Zusammenhänge
Invantive · SYSTEMDATACONTAINERS
SESSIONROWSCHANGED, SYSTEMDATACONTAINERATTRIBUTES, SYSTEMDATACONTAINERHTTPCACHECONTENTS, SYSTEMDATACONTAINERMESSAGES, SYSTEMDATACONTAINERPROPERTIES, SYSTEMDATACONTAINERRESERVEDWORDS, SYSTEMDATACONTAINERS, SYSTEMDATACONTAINERSLOTBASEDRATELIMITERS, SYSTEMDATACONTAINERSLOTBASEDRATELIMITERSLOTS, SYSTEMDOMAINCODES, SYSTEMDOMAINCODEVALUES, SYSTEMFILTERTOTABLEFUNCTIONPARAMETERS, SYSTEMLICENSES, SYSTEMOAUTHFLOWEVENTS, SYSTEMPARTITIONS, SYSTEMPARTITIONSTATISTICS, SYSTEMPARTITIONTAGS
Invantive · SYSTEMSQLAREA
JSONRECORDTYPECOLUMNS, JSONRECORDTYPES, SESSIONIOS, SYSTEMANONYMIZATIONMAPS, SYSTEMANONYMIZATIONMAPVALUES, SYSTEMCOUNTRIES, SYSTEMSQLAREA, SYSTEMSQLEXECUTIONS, SYSTEMSQLEXECUTIONSLEEPS, SYSTEMSQLEXECUTIONSTEPS, SYSTEMTIMEZONES
Invantive · SYSTEMPROVIDERS
SYSTEMPACKAGEFUNCTIONARGUMENTS, SYSTEMPACKAGEFUNCTIONS, SYSTEMPACKAGES, SYSTEMPROVIDERATTRIBUTES, SYSTEMPROVIDERS, SYSTEMPROVIDERSACTIVE, SYSTEMPROVIDERSAMPLEQUERIES
Invantive · SYSTEMTABLES
SYSTEMTABLECOLUMNS, SYSTEMTABLEFOREIGNKEYS, SYSTEMTABLEFUNCTIONPARAMETERS, SYSTEMTABLEKEYS, SYSTEMTABLES
Invantive · SYSTEMPREEMPTIVELOADCANDIDATES
SYSTEMPREEMPTIVELOADCANDIDATES, SYSTEMPREEMPTIVELOADHINTS, SYSTEMPREEMPTIVELOADINGPARTITIONS
Invantive · SYSTEMSCHEMAS
SYSTEMCATALOGS, SYSTEMSCHEMAS, SYSTEMVIEWS
Invantive (ohne Beziehungen)
AUDITEVENTS, CALENDAR, DOUBLE, DUAL, EMPTY, HTTPDOWNLOADCOOKIESHISTORY, HTTPDOWNLOADHISTORY, SYSTEMANONYMIZATIONPREDEFINEDMAPS, SYSTEMDATABASES, SYSTEMFUNCTIONS, SYSTEMGLOSSARIES, SYSTEMGLOSSARYTERMS, SYSTEMGLOSSARYTERMTRANSLATIONS, SYSTEMLANGUAGES, SYSTEMLICENSEMODULES, SYSTEMLOCKS, SYSTEMLOGGINGMESSAGECOUNTERSTATISTICS, SYSTEMMANAGEDFILEACTIONS, SYSTEMMANAGEDFILES, SYSTEMPROPERTIES, SYSTEMPSQLATOMICS, SYSTEMPSQLLOCKS, SYSTEMRECENTLOGGINGMESSAGES, SYSTEMRELATIONANALYSISRELATIONS, SYSTEMRELATIONANALYSISTABLES, SYSTEMSQLPRECOMPILEDEXPRESSIONS, SYSTEMTABLECOLUMNSLIVE, SYSTEMTABLEFUNCTIONPARAMETERSLIVE, SYSTEMTRANSLATIONS, SYSTEMUSERS, SYSTEMUTCOFFSETS, USERMESSAGES, USERSETTINGS, WEEKDAYS
Views (ohne Beziehungen)
Test0Rows10000Sec, Test0Rows1000Sec, Test0Rows100Sec, Test1000000Rows1000Mb10000Sec, Test1000000Rows1000Mb1000Sec, Test1000000Rows1000Mb1Sec, Test10000Rows100Mb100Sec, Test1000Rows1Mb1000Sec, Test100Rows1Mb100Sec, Test10Rows1000Mb1Sec
Beziehungen
- JSONRECORDTYPECOLUMNS → JSONRECORDTYPES (Schlüssel)
- SESSIONIOS → SYSTEMDATACONTAINERS (in Worten beschrieben): The data container of the call, while that data container is active; the history of calls outlives a data container that was closed.
- SESSIONIOS → SYSTEMSQLAREA (in Worten beschrieben): The statement in the SQL area, once its query plan has statistics. A call of the first execution of a statement is logged before the SQL area lists the statement.
- SESSIONIOS → SYSTEMSQLEXECUTIONS (in Worten beschrieben): The execution of the statement, once it has been registered. A call is logged while the statement still runs and an execution is listed only after the statement has ended; a statement that fails or is cancelled registers none.
- SESSIONIOS → SYSTEMSQLEXECUTIONSTEPS (in Worten beschrieben): The step of the execution, once the execution has been registered. The steps of a statement are listed only after it has ended; a call of a statement that fails or is cancelled names a step that is never listed.
- SESSIONROWSCHANGED → SYSTEMDATACONTAINERS (in Worten beschrieben): The data container of the change, while that data container is active; the history of changes outlives a data container that was closed.
- SYSTEMANONYMIZATIONMAPVALUES → SYSTEMANONYMIZATIONMAPS (Schlüssel)
- SYSTEMCATALOGS → SYSTEMDATACONTAINERS (Schlüssel)
- SYSTEMDATACONTAINERATTRIBUTES → SYSTEMDATACONTAINERS (Schlüssel)
- SYSTEMDATACONTAINERHTTPCACHECONTENTS → SYSTEMDATACONTAINERS (Schlüssel)
- SYSTEMDATACONTAINERMESSAGES → SYSTEMDATACONTAINERS (Schlüssel)
- SYSTEMDATACONTAINERPROPERTIES → SYSTEMDATACONTAINERS (Schlüssel)
- SYSTEMDATACONTAINERRESERVEDWORDS → SYSTEMDATACONTAINERS (Schlüssel)
- SYSTEMDATACONTAINERS → SYSTEMPROVIDERS (Schlüssel)
- SYSTEMDATACONTAINERSLOTBASEDRATELIMITERS → SYSTEMDATACONTAINERS (Schlüssel)
- SYSTEMDATACONTAINERSLOTBASEDRATELIMITERSLOTS → SYSTEMDATACONTAINERS (Schlüssel)
- SYSTEMDOMAINCODES → SYSTEMDATACONTAINERS (Schlüssel)
- SYSTEMDOMAINCODEVALUES → SYSTEMDATACONTAINERS (Schlüssel)
- SYSTEMDOMAINCODEVALUES → SYSTEMDOMAINCODES (Schlüssel)
- SYSTEMFILTERTOTABLEFUNCTIONPARAMETERS → SYSTEMDATACONTAINERS (Schlüssel)
- SYSTEMLICENSES → SYSTEMDATACONTAINERS (Schlüssel)
- SYSTEMOAUTHFLOWEVENTS → SYSTEMDATACONTAINERS (Schlüssel)
- SYSTEMPACKAGEFUNCTIONARGUMENTS → SYSTEMDATACONTAINERS (Schlüssel)
- SYSTEMPACKAGEFUNCTIONARGUMENTS → SYSTEMPACKAGEFUNCTIONS (Schlüssel)
- SYSTEMPACKAGEFUNCTIONS → SYSTEMDATACONTAINERS (Schlüssel)
- SYSTEMPACKAGEFUNCTIONS → SYSTEMPACKAGES (Schlüssel)
- SYSTEMPACKAGES → SYSTEMDATACONTAINERS (Schlüssel)
- SYSTEMPACKAGES → SYSTEMPROVIDERS (Schlüssel)
- SYSTEMPARTITIONS → SYSTEMDATACONTAINERS (Schlüssel)
- SYSTEMPARTITIONSTATISTICS → SYSTEMDATACONTAINERS (Schlüssel)
- SYSTEMPARTITIONTAGS → SYSTEMDATACONTAINERS (Schlüssel)
- SYSTEMPREEMPTIVELOADHINTS → SYSTEMPREEMPTIVELOADCANDIDATES (Schlüssel)
- SYSTEMPREEMPTIVELOADINGPARTITIONS → SYSTEMPREEMPTIVELOADCANDIDATES (Schlüssel)
- SYSTEMPROVIDERATTRIBUTES → SYSTEMPROVIDERS (Schlüssel)
- SYSTEMPROVIDERSACTIVE → SYSTEMDATACONTAINERS (Schlüssel)
- SYSTEMPROVIDERSACTIVE → SYSTEMPROVIDERS (Schlüssel)
- SYSTEMPROVIDERSAMPLEQUERIES → SYSTEMPROVIDERS (Schlüssel)
- SYSTEMSCHEMAS → SYSTEMCATALOGS (Schlüssel)
- SYSTEMSCHEMAS → SYSTEMDATACONTAINERS (Schlüssel)
- SYSTEMSQLEXECUTIONS → SYSTEMSQLAREA (Schlüssel)
- SYSTEMSQLEXECUTIONSLEEPS → SYSTEMSQLAREA (Schlüssel)
- SYSTEMSQLEXECUTIONSLEEPS → SYSTEMSQLEXECUTIONS (Schlüssel)
- SYSTEMSQLEXECUTIONSLEEPS → SYSTEMSQLEXECUTIONSTEPS (Schlüssel)
- SYSTEMSQLEXECUTIONSTEPS → SYSTEMSQLAREA (Schlüssel)
- SYSTEMSQLEXECUTIONSTEPS → SYSTEMSQLEXECUTIONS (Schlüssel)
- SYSTEMSQLEXECUTIONSTEPS → SYSTEMSQLEXECUTIONSTEPS (Schlüssel, 2 keys)
- SYSTEMTABLECOLUMNS → SYSTEMDATACONTAINERS (Schlüssel)
- SYSTEMTABLECOLUMNS → SYSTEMTABLES (Schlüssel)
- SYSTEMTABLEFOREIGNKEYS → SYSTEMDATACONTAINERS (Schlüssel)
- SYSTEMTABLEFOREIGNKEYS → SYSTEMTABLES (Schlüssel)
- SYSTEMTABLEFUNCTIONPARAMETERS → SYSTEMDATACONTAINERS (Schlüssel)
- SYSTEMTABLEFUNCTIONPARAMETERS → SYSTEMTABLES (Schlüssel)
- SYSTEMTABLEKEYS → SYSTEMDATACONTAINERS (Schlüssel)
- SYSTEMTABLEKEYS → SYSTEMTABLES (Schlüssel)
- SYSTEMTABLES → SYSTEMDATACONTAINERS (Schlüssel)
- SYSTEMTABLES → SYSTEMPROVIDERS (Schlüssel)
- SYSTEMTABLES → SYSTEMSCHEMAS (Schlüssel)
- SYSTEMTIMEZONES → SYSTEMCOUNTRIES (Schlüssel)
- SYSTEMVIEWS → SYSTEMDATACONTAINERS (Schlüssel)
- SYSTEMVIEWS → SYSTEMSCHEMAS (Schlüssel)
- SYSTEMVIEWS → SYSTEMTABLES (Schlüssel)
Tabellen
DataDictionary.Invantive
- AUDITEVENTS: Audit Events
- CALENDAR: Calendar
- DOUBLE: Single Row
- DUAL: Single Row
- EMPTY: Empty Table
- HTTPDOWNLOAD
- HTTPDOWNLOADCOOKIESHISTORY: Download Cookies History
- HTTPDOWNLOADHISTORY: HTTP Download History
- JSONRECORDTYPECOLUMNS: JSON Record Type Columns
- JSONRECORDTYPES: JSON Record Types
- PERFORMANCEMEASUREMENTSLIVE: Live Performance Measurements
- RANGE: Number Generator
- SESSIONIOS: Session I/Os
- SESSIONROWSCHANGED: Rows Changed in Session
- SYSTEMANONYMIZATIONMAPS: Anonymization Maps
- SYSTEMANONYMIZATIONMAPVALUES: Anonymization Map Values
- SYSTEMANONYMIZATIONPREDEFINEDMAPS: Anonymization Predefined Maps
- SYSTEMCATALOGS: Catalogs
- SYSTEMCOUNTRIES: Countries
- SYSTEMDATABASES: Databases
- SYSTEMDATACONTAINERATTRIBUTES: Data Container Attributes and Their Values
- SYSTEMDATACONTAINERHTTPCACHECONTENTS: System Data Container HTTP Cache Contents
- SYSTEMDATACONTAINERMESSAGES: Data Container Messages
- SYSTEMDATACONTAINERPROPERTIES: Data Container Properties
- SYSTEMDATACONTAINERRESERVEDWORDS: Provider Reserved Words
- SYSTEMDATACONTAINERS: Datacontainer
- SYSTEMDATACONTAINERSLOTBASEDRATELIMITERS: Provider Slot-based Rate Limiters
- SYSTEMDATACONTAINERSLOTBASEDRATELIMITERSLOTS: Provider Slot-based Rate Limiter Slots
- SYSTEMDOMAINCODES: Code/value Domains
- SYSTEMDOMAINCODEVALUES: Domain Values
- SYSTEMFILTERTOTABLEFUNCTIONPARAMETERS: Filter to Table Function Parameters
- SYSTEMFUNCTIONS: System Functions
- SYSTEMGLOSSARIES: Glossaries
- SYSTEMGLOSSARYTERMS: Glossary Terms
- SYSTEMGLOSSARYTERMTRANSLATIONS: Glossary Term Translations
- SYSTEMLANGUAGES: Languages
- SYSTEMLICENSEMODULES: Licence Modules
- SYSTEMLICENSES: Licenses
- SYSTEMLOCKS: Locks
- SYSTEMLOGGINGMESSAGECOUNTERSTATISTICS: Logging Message Counter Statistics
- SYSTEMMANAGEDFILEACTIONS: Managed File Actions
- SYSTEMMANAGEDFILES: Managed Files
- SYSTEMOAUTHFLOWEVENTS: OAuth Flow Events
- SYSTEMPACKAGEFUNCTIONARGUMENTS: Package Function Arguments
- SYSTEMPACKAGEFUNCTIONS: Package Functions
- SYSTEMPACKAGES: Packages
- SYSTEMPARTITIONS: Partitions
- SYSTEMPARTITIONSTATISTICS: System Partition Statistics
- SYSTEMPARTITIONTAGS: System Partition Tags
- SYSTEMPREEMPTIVELOADCANDIDATES: Pre-emptive Load Candidates
- SYSTEMPREEMPTIVELOADHINTS: Pre-emptive Load Hints
- SYSTEMPREEMPTIVELOADINGPARTITIONS: Pre-emptive Loading Partitions
- SYSTEMPROPERTIES: System Properties and Their Values
- SYSTEMPROVIDERATTRIBUTES: System Provider Attributes
- SYSTEMPROVIDERS: Providers
- SYSTEMPROVIDERSACTIVE: Active System Providers
- SYSTEMPROVIDERSAMPLEQUERIES: Provider Sample Queries
- SYSTEMPSQLATOMICS: PSQL Atomic Values
- SYSTEMPSQLLOCKS: PSQL Locks
- SYSTEMRECENTLOGGINGMESSAGES: Logging Messages
- SYSTEMRELATIONANALYSISRELATIONS: Relation Analysis Relations
- SYSTEMRELATIONANALYSISTABLES: Relation Analysis Tables
- SYSTEMSCHEMAS: Schemas
- SYSTEMSQLAREA: SQL Statements Executed
- SYSTEMSQLEXECUTIONS: SQL Executions
- SYSTEMSQLEXECUTIONSLEEPS: SQL Execution Sleeps
- SYSTEMSQLEXECUTIONSTEPS: SQL Execution Steps
- SYSTEMSQLPRECOMPILEDEXPRESSIONS: SQL Pre-compiled Expressions
- SYSTEMTABLECOLUMNS: Table Columns
- SYSTEMTABLECOLUMNSLIVE: Live Retrieved Table Columns
- SYSTEMTABLEFOREIGNKEYS: Foreign Keys
- SYSTEMTABLEFUNCTIONPARAMETERS: Table Function Parameters
- SYSTEMTABLEFUNCTIONPARAMETERSLIVE: Live Retrieve Table Function Parameters
- SYSTEMTABLEKEYS: Table Keys
- SYSTEMTABLES: Tables
- SYSTEMTIMEZONES: Time Zones
- SYSTEMTRANSLATIONS: Translations
- SYSTEMUSERS: System Users
- SYSTEMUTCOFFSETS: UTC Offsets
- SYSTEMVIEWS: Database Views
- TIPSBYTERM: Tips by Term
- USERMESSAGES: User Messages
- USERSETTINGS: System User Settings
- WEEKDAYS: Days of the Week
DataDictionary.Views
- Test0Rows10000Sec
- Test0Rows1000Sec
- Test0Rows100Sec
- Test1000000Rows1000Mb10000Sec
- Test1000000Rows1000Mb1000Sec
- Test1000000Rows1000Mb1Sec
- Test10000Rows100Mb100Sec
- Test1000Rows1Mb1000Sec
- Test100Rows1Mb100Sec
- Test10Rows1000Mb1Sec
Attribute
The attributes of this platform are on the page Attributes.
Anmerkungen zu dieser Version
Was hat sich in den Tabellen, Spalten, Attributen und Funktionen des Treibers mit jeder neuen Version geändert: