DB MAIN Reference Manual
DB-MAIN-Reference-Manual
User Manual: Pdf
Open the PDF directly: View PDF
Page Count: 300 [warning: Documents this large are best viewed by clicking the View PDF Link!]
- Table of contents
- Introduction
- Projects, products and processes
- Data schemas: Entity types, Relationship types and attributes
- Processing schemas: UML activity and use case diagrams
- Text files
- Common rules
- Engineering process control
- Sample DB-MAIN schemas
- 8.1 An Entity-Relationship conceptual schema
- 8.2 A NIAM/ORM conceptual schema
- 8.3 An UML conceptual schema
- 8.4 A relational logical schema
- 8.5 A CODASYL-DBTG logical schema
- 8.6 A COBOL file logical schema
- 8.7 An object-oriented logical schema
- 8.8 A relational (ORACLE) physical schema
- 8.9 An activity diagram
- 8.10 An use case diagram
- 8.11 An organizational structure model
- 8.12 References
- The components of the DB-MAIN environment (Version 9)
- List of the DB-MAIN functions
- The File menu (File)
- 11.1 The commands of the File menu - Summary
- 11.2 Managing projects
- 11.3 Exporting and importing
- 11.4 Executing a user-defined plug-in
- 11.5 Extracting and generating DDL text files
- 11.6 Using external texts
- 11.7 Reporting and printing
- 11.8 Configuring the DB-MAIN environment
- 11.9 Opening a recently used project
- 11.10 Quitting DB-MAIN
- The Edit menu (Edit)
- The Product menu (Product)
- The New menu (New)
- The Transform menu (Transform)
- The Assist menu (Assist)
- The Engineering menu (Engineering)
- The Log menu (Log)
- The View menu (View)
- The Window menu (Window)
- The Help menu (Help or F1 key)
- Elementary constraints of schema analysis assistant
- 1.1 Constraints on schema
- 1.2 Constraints on collections
- 1.3 Constraints on entity types
- 1.3.1 ALL_ET
- 1.3.2 ATT_per_ET <min> <max>
- 1.3.3 ATT_LENGTH_per_ET <min> <max>
- 1.3.4 ROLE_per_ET <min> <max>
- 1.3.5 ONE_ROLE_per_ET <min> <max>
- 1.3.6 N_ROLE_per_ET <min> <max>
- 1.3.7 MAND_ROLE_per_ET <min> <max>
- 1.3.8 OPT_ROLE_per_ET <min> <max>
- 1.3.9 GROUP_per_ET <min> <max>
- 1.3.10 ID_per_ET <min> <max>
- 1.3.11 PID_per_ET <min> <max>
- 1.3.12 ALL_ATT_in_ID_ET <yn>
- 1.3.13 ALL_ATT_ID_per_ET <min> <max>
- 1.3.14 HYBRID_ID_per_ET <min> <max>
- 1.3.15 KEY_ID_per_ET <min> <max>
- 1.3.16 ID_NOT_KEY_per_ET <min> <max>
- 1.3.17 KEY_ALL_ATT_ID_per_ET <min> <max>
- 1.3.18 EMBEDDED_ID_per_ET <min> <max>
- 1.3.19 ID_DIFF_in_ET <type>
- 1.3.20 KEY_per_ET <min> <max>
- 1.3.21 ALL_ATT_KEY_per_ET <min> <max>
- 1.3.22 HYBRID_KEY_per_ET <min> <max>
- 1.3.23 ID_KEY_per_ET <min> <max>
- 1.3.24 KEY_PREFIX_in_ET <type>
- 1.3.25 REF_per_ET <min> <max>
- 1.3.26 REF_in_ET <type>
- 1.3.27 COEXIST_per_ET <min> <max>
- 1.3.28 EXCLUSIVE_per_ET <min> <max>
- 1.3.29 ATLEASTONE_per_ET <min> <max>
- 1.3.30 PROCUNIT_per_ET
- 1.3.31 COLL_per_ET <min> <max>
- 1.3.32 DYN_PROP_of_ET <dynamic property> <parameters>
- 1.3.33 SELECTED_ET
- 1.3.34 MARKED_ET
- 1.3.35 PLUGIN_CONSTRAINT_on_ET <plugin-file> <plugin-predicate> <parameters>
- 1.4 Constraints on is-a relations
- 1.5 Constraints on rel-types
- 1.5.1 ALL_RT
- 1.5.2 ATT_per_RT <min> <max>
- 1.5.3 ATT_LENGTH_per_RT <min> <max>
- 1.5.4 ROLE_per_RT <min> <max>
- 1.5.5 ONE_ROLE_per_RT <min> <max>
- 1.5.6 N_ROLE_per_RT <min> <max>
- 1.5.7 MAND_ROLE_per_RT <min> <max>
- 1.5.8 RECURSIVITY_in_RT <min> <max>
- 1.5.9 GROUP_per_RT <min> <max>
- 1.5.10 ID_per_RT <min> <max>
- 1.5.11 PID_per_RT <min> <max>
- 1.5.12 ALL_ATT_ID_per_RT <min> <max>
- 1.5.13 HYBRID_ID_per_RT <min> <max>
- 1.5.14 EMBEDDED_ID_per_RT <min> <max>
- 1.5.15 ID_DIFF_in_RT <type>
- 1.5.16 KEY_per_RT <min> <max>
- 1.5.17 COEXIST_per_RT <min> <max>
- 1.5.18 EXCLUSIVE_per_RT <min> <max>
- 1.5.19 ATLEASTONE_per_RT <min> <max>
- 1.5.20 PROCUNIT_per_RT
- 1.5.21 DYN_PROP_of_RT <dynamic property> <parameters>
- 1.5.22 SELECTED_RT
- 1.5.23 MARKED_RT
- 1.5.24 PLUGIN_CONSTRAINT_on_RT <plugin-file> <plugin-predicate> <parameters>
- 1.6 Constraints on roles
- 1.7 Constraints on attributes
- 1.7.1 ALL_ATT
- 1.7.2 MIN_CARD_of_ATT <min> <max>
- 1.7.3 MAX_CARD_of_ATT <min> <max>
- 1.7.4 DEPTH_of_ATT <min> <max>
- 1.7.5 SUB_ATT_per_ATT <min> <max>
- 1.7.6 TYPES_ALLOWED_for_ATT <list>
- 1.7.7 TYPES_NOTALLOWED_for_ATT <list>
- 1.7.8 SET_TYPES_ALLOWED_for_ATT <list>
- 1.7.9 SET_TYPES_NOTALLOWED_for_ATT <list>
- 1.7.10 TYPE_DEF_for_ATT <type> <parameters>
- 1.7.11 PART_of_GROUP_ATT <min> <max>
- 1.7.12 ID_per_ATT <min> <max>
- 1.7.13 PID_per_ATT <min> <max>
- 1.7.14 PART_of_ID_ATT <min> <max>
- 1.7.15 KEY_per_ATT <min> <max>
- 1.7.16 REF_per_ATT <min> <max>
- 1.7.17 PART_of_REF_ATT <min> <max>
- 1.7.18 DYN_PROP_of_ATT <dynamic property> <parameters>
- 1.7.19 SELECTED_ATT
- 1.7.20 MARKED_ATT
- 1.7.21 PLUGIN_CONSTRAINT_on_ATT <plugin-file> <plugin- predicate> <parameters>
- 1.8 Constraints on groups
- 1.8.1 ALL_GROUP
- 1.8.2 COMP_per_GROUP <min> <max>
- 1.8.3 ATT_per_GROUP <min> <max>
- 1.8.4 ROLE_per_GROUP <min> <max>
- 1.8.5 GROUP_per_GROUP <min> <max>
- 1.8.6 ID_in_GROUP <yn>
- 1.8.7 PID_in_GROUP <yn>
- 1.8.8 KEY_in_GROUP <yn>
- 1.8.9 REF_in_GROUP <yn>
- 1.8.10 COEXIST_in_GROUP <yn>
- 1.8.11 EXCLUSIVE_in_GROUP <yn>
- 1.8.12 ATLEASTONE_in_GROUP <yn>
- 1.8.13 LENGTH_of_ATT_GROUP <min> <max>
- 1.8.14 TRANSITIVE_GROUP <yn>
- 1.8.15 DYN_PROP_of_GROUP <dynamic property> <parameters>
- 1.8.16 SELECTED_GROUP
- 1.8.17 MARKED_GROUP
- 1.8.18 PLUGIN_CONSTRAINT_on_GROUP <plugin-file> <plugin- predicate> <parameters>
- 1.9 Constraints on entity type identifiers
- 1.9.1 ALL_EID
- 1.9.2 COMP_per_EID <min> <max>
- 1.9.3 ATT_per_EID <min> <max>
- 1.9.4 OPT_ATT_per_EID <min> <max>
- 1.9.5 MAND_ATT_per_EID <min> <max>
- 1.9.6 SINGLE_ATT_per_EID <min> <max>
- 1.9.7 MULT_ATT_per_EID <min> <max>
- 1.9.8 MULT_ATT_per_MULT_COMP_EID <min> <max>
- 1.9.9 SUB_ATT_per_EID <min> <max>
- 1.9.10 COMP_ATT_per_EID <min> <max>
- 1.9.11 ROLE_per_EID <min> <max>
- 1.9.12 OPT_ROLE_per_EID <min> <max>
- 1.9.13 MAND_ROLE_per_EID <min> <max>
- 1.9.14 ONE_ROLE_per_EID <min> <max>
- 1.9.15 N_ROLE_per_EID <min> <max>
- 1.9.16 GROUP_per_EID <min> <max>
- 1.9.17 ALL_EPID
- 1.9.18 COMP_per_EPID <min> <max>
- 1.9.19 ATT_per_EPID <min> <max>
- 1.9.20 OPT_ATT_per_EPID <min> <max>
- 1.9.21 MAND_ATT_per_EPID <min> <max>
- 1.9.22 SINGLE_ATT_per_EPID <min> <max>
- 1.9.23 MULT_ATT_per_EPID <min> <max>
- 1.9.24 MULT_ATT_per_MULT_COMP_EPID <min> <max>
- 1.9.25 SUB_ATT_per_EPID <min> <max>
- 1.9.26 COMP_ATT_per_EPID <min> <max>
- 1.9.27 ROLE_per_EPID <min> <max>
- 1.9.28 OPT_ROLE_per_EPID <min> <max>
- 1.9.29 MAND_ROLE_per_EPID <min> <max>
- 1.9.30 ONE_ROLE_per_EPID <min> <max>
- 1.9.31 N_ROLE_per_EPID <min> <max>
- 1.9.32 GROUP_per_EPID <min> <max>
- 1.9.33 DYN_PROP_of_EID <dynamic property> <parameters>
- 1.9.34 SELECTED_EID
- 1.9.35 MARKED_EID
- 1.9.36 PLUGIN_CONSTRAINT_on_EID <plugin-file> <plugin-predicate> <parameters>
- 1.10 Constraints on rel-type identifiers
- 1.10.1 ALL_RID
- 1.10.2 COMP_per_RID <min> <max>
- 1.10.3 ATT_per_RID <min> <max>
- 1.10.4 OPT_ATT_per_RID <min> <max>
- 1.10.5 MAND_ATT_per_RID <min> <max>
- 1.10.6 SINGLE_ATT_per_RID <min> <max>
- 1.10.7 MULT_ATT_per_RID <min> <max>
- 1.10.8 MULT_ATT_per_MULT_COMP_RID <min> <max>
- 1.10.9 SUB_ATT_per_RID <min> <max>
- 1.10.10 COMP_ATT_per_RID <min> <max>
- 1.10.11 ROLE_per_RID <min> <max>
- 1.10.12 OPT_ROLE_per_RID <min> <max>
- 1.10.13 MAND_ROLE_per_RID <min> <max>
- 1.10.14 ONE_ROLE_per_RID <min> <max>
- 1.10.15 N_ROLE_per_RID <min> <max>
- 1.10.16 GROUP_per_RID <min> <max>
- 1.10.17 ALL_RPID
- 1.10.18 COMP_per_RPID <min> <max>
- 1.10.19 ATT_per_RPID <min> <max>
- 1.10.20 OPT_ATT_per_RPID <min> <max>
- 1.10.21 MAND_ATT_per_RPID <min> <max>
- 1.10.22 SINGLE_ATT_per_RPID <min> <max>
- 1.10.23 MULT_ATT_per_RPID <min> <max>
- 1.10.24 MULT_ATT_per_MULT_COMP_RPID <min> <max>
- 1.10.25 SUB_ATT_per_RPID <min> <max>
- 1.10.26 COMP_ATT_per_RPID <min> <max>
- 1.10.27 ROLE_per_RPID <min> <max>
- 1.10.28 OPT_ROLE_per_RPID <min> <max>
- 1.10.29 MAND_ROLE_per_RPID <min> <max>
- 1.10.30 ONE_ROLE_per_RPID <min> <max>
- 1.10.31 N_ROLE_per_RPID <min> <max>
- 1.10.32 GROUP_per_RPID <min> <max>
- 1.10.33 DYN_PROP_of_RID <dynamic property> <parameters>
- 1.10.34 SELECTED_RID
- 1.10.35 MARKED_RID
- 1.10.36 PLUGIN_CONSTRAINT_on_RID <plugin-file> <plugin- predicate> <parameters>
- 1.11 Constraints on attribute identifiers
- 1.11.1 ALL_AID
- 1.11.2 COMP_per_AID <min> <max>
- 1.11.3 ATT_per_AID <min> <max>
- 1.11.4 OPT_ATT_per_AID <min> <max>
- 1.11.5 MAND_ATT_per_AID <min> <max>
- 1.11.6 SINGLE_ATT_per_AID <min> <max>
- 1.11.7 MULT_ATT_per_AID <min> <max>
- 1.11.8 MULT_ATT_per_MULT_COMP_AID <min> <max>
- 1.11.9 SUB_ATT_per_AID <min> <max>
- 1.11.10 COMP_ATT_per_AID <min> <max>
- 1.11.11 GROUP_per_AID <min> <max>
- 1.11.12 ALL_APID
- 1.11.13 COMP_per_APID <min> <max>
- 1.11.14 ATT_per_APID <min> <max>
- 1.11.15 OPT_ATT_per_APID <min> <max>
- 1.11.16 MAND_ATT_per_APID <min> <max>
- 1.11.17 SINGLE_ATT_per_APID <min> <max>
- 1.11.18 MULT_ATT_per_APID <min> <max>
- 1.11.19 MULT_ATT_per_MULT_COMP_APID <min> <max>
- 1.11.20 SUB_ATT_per_APID <min> <max>
- 1.11.21 COMP_ATT_per_APID <min> <max>
- 1.11.22 GROUP_per_APID <min> <max>
- 1.11.23 DYN_PROP_of_AID <dynamic property> <parameters>
- 1.11.24 SELECTED_AID
- 1.11.25 MARKED_AID
- 1.11.26 PLUGIN_CONSTRAINT_on_AID <plugin-file> <plugin- predicate> <parameters>
- 1.12 Constraints on access keys
- 1.12.1 ALL_KEY
- 1.12.2 COMP_per_KEY <min> <max>
- 1.12.3 ATT_per_KEY <min> <max>
- 1.12.4 OPT_ATT_per_KEY <min> <max>
- 1.12.5 MAND_ATT_per_KEY <min> <max>
- 1.12.6 SINGLE_ATT_per_KEY <min> <max>
- 1.12.7 MULT_ATT_per_KEY <min> <max>
- 1.12.8 MULT_ATT_per_MULT_COMP_KEY <min> <max>
- 1.12.9 SUB_ATT_per_KEY <min> <max>
- 1.12.10 COMP_ATT_per_KEY <min> <max>
- 1.12.11 ROLE_per_KEY <min> <max>
- 1.12.12 OPT_ROLE_per_KEY <min> <max>
- 1.12.13 MAND_ROLE_per_KEY <min> <max>
- 1.12.14 ONE_ROLE_per_KEY <min> <max>
- 1.12.15 N_ROLE_per_KEY <min> <max>
- 1.12.16 GROUP_per_KEY <min> <max>
- 1.12.17 DYN_PROP_of_KEY <dynamic property> <parameters>
- 1.12.18 SELECTED_KEY
- 1.12.19 MARKED_KEY
- 1.12.20 PLUGIN_CONSTRAINT_on_KEY <plugin-file> <plugin- predicate> <parameters>
- 1.13 Constraints on referential groups
- 1.13.1 ALL_REF
- 1.13.2 COMP_per_REF <min> <max>
- 1.13.3 ATT_per_REF <min> <max>
- 1.13.4 OPT_ATT_per_REF <min> <max>
- 1.13.5 MAND_ATT_per_REF <min> <max>
- 1.13.6 SINGLE_ATT_per_REF <min> <max>
- 1.13.7 MULT_ATT_per_REF <min> <max>
- 1.13.8 MULT_ATT_per_MULT_COMP_REF <min> <max>
- 1.13.9 SUB_ATT_per_REF <min> <max>
- 1.13.10 COMP_ATT_per_REF <min> <max>
- 1.13.11 ROLE_per_REF <min> <max>
- 1.13.12 OPT_ROLE_per_REF <min> <max>
- 1.13.13 MAND_ROLE_per_REF <min> <max>
- 1.13.14 ONE_ROLE_per_REF <min> <max>
- 1.13.15 N_ROLE_per_REF <min> <max>
- 1.13.16 GROUP_per_REF <min> <max>
- 1.13.17 LENGTH_of_REF <operator>
- 1.13.18 TRANSITIVE_REF <yn>
- 1.13.19 DYN_PROP_of_REF <dynamic property> <parameters>
- 1.13.20 SELECTED_REF
- 1.13.21 MARKED_REF
- 1.13.22 PLUGIN_CONSTRAINT_on_REF <plugin-file> <plugin- predicate> <parameters>
- 1.14 Constraints on processing units
- 1.15 Constraints on names
- 1.15.1 CONCERNED_NAMES <list>
- 1.15.2 NONE_in_LIST_NAMES <list>
- 1.15.3 NONE_in_LIST_CI_NAMES <list>
- 1.15.4 ALL_in_LIST_NAMES <list>
- 1.15.5 ALL_in_LIST_CI_NAMES <list>
- 1.15.6 NONE_in_FILE_NAMES <name of file>
- 1.15.7 NONE_in_FILE_CI_NAMES <name of file>
- 1.15.8 ALL_in_FILE_NAMES <name of file>
- 1.15.9 ALL_in_FILE_CI_NAMES <name of file>
- 1.15.10 NO_CHARS_in_LIST_NAMES <list>
- 1.15.11 ALL_CHARS_in_LIST_NAMES <list>
- 1.15.12 LENGTH_of_NAMES <min> <max>
- 1.15.13 UNIQUE_among_NAMES <scope>
- 1.15.14 DYN_PROP_of_NAMES <dynamic property> <parameters>
- 1.15.15 SELECTED_NAMES
- 1.15.16 MARKED_NAMES
- 1.15.17 PLUGIN_CONSTRAINT_on_NAMES <plugin-file> <plugin- predicate> <parameters>
- 1.16 Using plug-in constraints
- 1.17 Using dynamic property constraints
- The Pattern Definition Language syntax