Ingres 11.0 | Organization of Extended System Catalogs

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: 01/30/2023