Database Administrator Guide > Database Administrator Guide > A. System Catalogs > Extended System Catalogs > Organization of Extended System Catalogs
Was this helpful?
Organization of Extended System Catalogs
For the purpose of installing and upgrading products, extended system catalogs are grouped into modules. Each product requires one or more of these modules. The contents of a module are subject to change with a new release, as catalogs are added or changed.
By default, when you create a database (using the createdb command) or upgrade a product (using the upgradefe command), catalogs are created for all products for which you are authorized. To create catalogs only for specific products, you must specify the products on the createdb command line. Valid products are:
• ingres (the base product)
• ingres/dbd
• vision
• windows/4gl
Each of these products requires one or more of the following modules:
Module Name
Catalogs in Module
APPLICATION_DEVELOPMENT_1
Base product catalogs
Required by:
Ingres
Ingres Vision
ii_abfclasses
ii_abfdependencies
ii_abfobjects
ii_encoded_forms
ii_fields
ii_forms
ii_gropts
ii_joindefs
ii_qbfnames
ii_rcommands
ii_reports
ii_sequence_values
ii_trim
APPLICATION_DEVELOPMENT_2
Catalogs for OpenROAD
Required by:
OpenROAD
ii_applications
ii_components
ii_dependencies
ii_incl_apps
ii_srcobj_encoded
ii_stored_bitmaps
ii_stored_strings
APPLICATION_DEVELOPMENT_3
Required by:
Ingres Vision
ii_framevars
ii_menuargs
ii_vqjoins
ii_vqtabcols
ii_vqtables
APPLICATION_DEVELOPMENT_4
ii_stored_nstrings
CORE
Catalogs for Ingres and Ingres tools base product
Required by:
All products
ii_app_cntns_comp
ii_client_dep_mod
ii_dict_modules
ii_encodings
ii_entities
ii_id
ii_locks
ii_longremarks
ii_objects
DATA_MODEL
catalogs for distributed Ingres
Required by:
INGRES/DBD version 1
ii_atttype
ii_atttype_version
ii_defaults
ii_databases
ii_dbd_acl
ii_dbd_identifiers
ii_dbd_locations
ii_dbd_rightslist
ii_dbd_table_char
ii_domains
ii_enttype
ii_joinspecs
ii_key_info
ii_key_map
ii_limits
ii_rel_cncts_ent
ii_reltype
ii_sqlatts
ii_sqltables
METASCHEMA
Required by:
INGRES/DBD version 2
ii_atttype
ii_defaults
ii_databases
ii_domains
ii_enttype
ii_joinspecs
ii_key_info
ii_key_map
ii_limits
ii_rel_cncts_ent
ii_reltype
ii_sqlatts
ii_sqltables
PHYSICAL_DATA_MODELLING
Required by
INGRES/DBD version 2
ii_dbd_acl
ii_dbd_identifiers
ii_dbd_locations
ii_dbd_rightslist
ii_dbd_table_char
Last modified date: 08/28/2024