A Tool for Every Database User

Everyone who uses the Integrated Data Dictionary can benefit from CA IDMS DQF. The following display illustrates some typical queries. With or without knowledge of IDD syntax or structure, you can find dictionary information easily by using the menus.
idms
Everyone who uses the Integrated Data Dictionary can benefit from CA IDMS DQF. The following display illustrates some typical queries. With or without knowledge of IDD syntax or structure, you can find dictionary information easily by using the menus.
Developers or Programmers
do not need special syntax to locate information. With CA IDMS DQF they can:
  • Review existing entities before starting a new application
  • Compare record definitions while developing an application
  • Verify definitions
  • Study effects of proposed modifications on other entities
  • Determine the far reaching effects of changes in a data element or record
  • Standardize applications.
Database Administrators (DBAs)
can manage dictionaries more efficiently by accessing information online. Many tasks the DBA performs will benefit from easy access to facts from the dictionary. The DBA can use CA IDMS DQF to:
  • Monitor entities being added to the IDD
  • Manage schemas and subschemas
  • Ensure that all systems and applications are documented
  • Resolve conflicts such as similar names for elements
  • Standardize routines.
System Analysts
can analyze old and new systems faster. Online information from the IDD helps the analyst perform several different tasks:
  • Analyze proposed changes to systems
  • Determine if existing entities can be used for new systems
  • Verify components to be turned over for migration
  • Standardize system documentation.
IDMSDB--A Tool for Every Database User
Exhibit 2.1: Typical Queries for CA IDMS DQF