Xcase for System i simplifies tasks throughout the entire life cycle of your database, from initial design through documentation, modification and data management. Its powerful automation transparently does the tedious and demanding work required to accomplish common tasks at key stages of the life cycle, as summarized below. The result: faster and more accurate implementation of your database strategy.

Design

Xcase offers a highly sophisticated visual interface that allows you to accurately design your database by capturing every detail about your company’s or customer's business information world. The automation and maintenance mechanisms provided by Xcase assist you in accomplishing the analysis and design of the database completely and with integrity. No need to be an expert on the databases with which you work. Xcase, your database expert, handles the details while you focus on the design of the database.

Present

Once you have completed the design of the database, Xcase produces high quality diagrams, enabling you to present your design with different views at various levels of detail. By allowing you to customize the presentation at the appropriate level for your customer, your colleagues or your own use, Xcase greatly facilitates the iterative process of analysis, design and presentation.

Document

After you have analyzed and designed your model, and presented it to your customer, it is important to fully document your design, the blue print of your application. Xcase automates this often tedious and time-consuming task for you, allowing you to easily print diagrams and reports and add comments, as well as your own user defined attributes.

Generate

Having adjusted your original design according to the feedback from your customers in response to clear and complete presentations, Xcase's powerful automation features assist you in generating all the database-related code:

• Data Definition Language Code to build the database
• Triggers and Stored Procedures to safeguard data integrity
• Views and Queries to extract data

Manage Data

One of the most striking Lower CASE features offered by Xcase provides a direct link from the conceptual domain into the physical data by allowing you to move data from one database to another, to relationally view physical data and edit physical data with integrity from within Xcase.

Maintain

At the final stage of the development process, your application is installed and running. As good as your original design may be, you are likely to make modifications to enhance and correct it. Again, Xcase is your invaluable assistant, automatically maintaining both metadata in the model and in the Database Catalog. Once you have made any modifications, Xcase allows you to automatically update the database at the customer site while preserving existing data.