Mitrol banner

Solutions

History

Contacts

Users

What's new?


Image margintop blue


DBMS access

Data dictionary

Mitrol contains a built-in data schema and integrated data definition language used to maintain the complete repository of information about :

  • data, tables and files
  • relations
  • user programs and user profiles
  • Stored definitions of virtual fields
  • Stored programs
  • Predefined selection criteria
  • Rules for referential integrity

Integration of the schema with the Mitrol System eliminates potential data inconsistencies inherent in standalone products. It also greatly reduces the maintenance effort by eliminating redundancy and affecting all occurences of the data with only one modification to the schema. The internal database files, allowing program access to the structure of the database. Program compilation will cross reference fields to programs within the data dictionary, reducing the maintenance overhead and aiding documentation.

Mitrol Fourth Generation Request Language

The Mitrol language is a proven fourth generation application development language to access the Mitrol DBMS that can dramatically reduce the programming time required to accomplish a broad spectrum of data processing tasks. With the Mitrol language, you do not have to specify detailed procedures to perform a task. Instead, you specify the desired results, and the Mitrol System determines how to obtain them. For example, the verb TOTALIZE uses its own structures to accumulate data items such as costs and expenses throughout a bill of material. Also, the verb EXPLODE will walk through tree structures to print data items, such as all sub-accounts that compose a summary account. Units of measure and shop calendar are fully supported.

These powerful verbs eliminate hours of users trying to figure out report totalling and account roll-up schemes, not to mention the potential for errors in data entry, confusion when the reporting organisation changes, and the inevitable late night links and compiles.

Eliminating the procedural portion of coding significantly improves programmer productivity and is easier and less costly to maintain than systems written in traditional third generation programming languages. Because Mitrol applications require less code than traditional languages, maintenance costs are correspondingly lower. In fact, Mitrol users have reported significant decreases in application development. In a customer controlled test against Cobol/CICS/DLI Mitrol did require only 40% of chargeable resources for application and database coding.




Go to ApplicationsAPPLICATIONS
Go to DictionaryDATA DICTIONARY
Back to SolutionsSOLUTIONS

© 2000-2003 Teamco Systems Innovation, email: info@mitrol.com.

Top of the page