System Objects
Description
System objects are specific to the database vendor. Sometimes they are stored in a specific database(s), otherwise in specific schema(s). Starting with the version 3.5.8-funcrel we exclude System Objects from metric calculations, and consider them as external. The names of the system database / schema can be changed directly in the configuration files, located in the system_objects subdirectory. Starting with the version 3.7.4-funcrel till 3.8.0-funcrel, system objects have a new property named “System object”. Starting with the version 3.8.0-funcrel we create a System object. E.g. : System Table / System Procedure, etc.
System objects by vendor
Some vendors store system objects in specific databases, this is the case for Microsoft SQL Server and ASE Sybase, which are identified as “SQL Server”. Other vendors store system objects in specific schemas, and this is the case for almost all other vendors. In the table below we list the names of System Database / Schema by vendor. They are now considered as external and we systematically exclude them from metric calculations.
| Vendor | System Database : system_databases.config | System Databases that begin with a prefix : prefixes_system_databases.config | System Schema : system_schemas.config | System Schemas that begin with a prefix : prefixes_system_schemas.config | System Objects that begin with a prefix : prefixes_system_objects.config |
|---|---|---|---|---|---|
| Db2 | information_schema syscat systat sysfun sysibm sysibmadm sysproc syspublic sysadm systools qsys qsys2 sysstat system sysibminternal sysibmts | ||||
| Db2 for i | information_schema syscat systat sysfun sysibm sysibmadm sysproc syspublic sysadm systools qsys qsys2 sysstat system sysibminternal sysibmts | ||||
| Informix | sysams | ||||
| Ingres / Actian | ii | ii | ii | ||
| MySQL *) | mysql information_schema performance_schema sysmysql sys | ||||
| Oracle | anonymous appqossys ctxsys dbsnmp dip exfsys ix mddata mdsys mgmt_view oe olapsys oracle_ocm orddata ordplugins ordsys outln owbsys owbsys_audit si_informtn_schema spatial_csw_admin_usr spatial_wfs_admin_usr sys sysman system wmsys xdb xs$null | ||||
| PostgreSQL | |||||
| Sqlserver **) | master model msdb resource tempdb sybsystemprocs sybsystemdb sybsecurity pub2 pubs3 dbccdb sybmgmtdb | sys | |||
| Teradata | |||||
| CockroachDB | system | information_schema crdb_internal pg_catalog pg_extension | |||
| NonStop SQL | nonstop_sqlmx_ | definition_schema_version_ |
- *) MySQL and MariaDb
- **) Microsoft SQL Server and ASE Sybase