SQWareRepository:mongodb
Contents
Presentation
It is the repository module, and stores rdbms indicators for all RDBMS.
It is a MySQL database.
Objects prefix by tsqw_% or isqw_% are generic.
Objects prefix by tsqwmng_% or isqwmng_% are specific for MongoDB.
Installation guide for SQWareRepository for MongoDB
Naming convention
All specific objects for MongoDB are named with prefixes:
- tsqwmng_% : for tables
- isqwmng_% : for index
- isqwmng_%_u : for uniques
- isqwmng_%_pk : for primary key
Specific database content for MongoDB
tsqwmng_InstanceDetail
This table contains :
...
Desc of tsqwmng_InstanceDetail :
Field Type dbalias varchar(80) nodename varchar(80) gather_date datetime size_instance decimal(12,2) used decimal(12,2) free decimal(12,2) maj_version int(11) version varchar(30)
tsqwmng_Parameters
This table contains :
...
Desc of tsqwmng_Parameters :
Field Type dbalias varchar(80) nodename varchar(80) gather_date datetime name varchar(255) value varchar(255)
tsqwmng_VolDb
This table contains :
...
Desc of tsqwmng_VolDb :
Field Type dbalias varchar(80) nodename varchar(80) database_name varchar(255) gather_date datetime dataSize decimal(12,2) storageSize decimal(12,2) fileSize decimal(12,2) collections decimal(12,2) indexSize decimal(12,2) indexes decimal(12,2)
tsqwmng_VolTables
This table contains :
...
Desc of tsqwmng_VolTables :
Field Type dbalias varchar(80) nodename varchar(80) gather_date datetime database_name varchar(255) table_name varchar(255) table_count decimal(12,2) table_size decimal(12,2) storageSize decimal(12,2) nindexes decimal(12,2) totalIndexSize decimal(12,2)