|
Various types of editing tasks can be carried out on a data model using the CES Data Modeler. The editing types are: |
|
Online editing helps you to work on an active database and commit changes to the database. Offline editing does not require an active database connection and involves:
|
|
Basic editing in the CES Data Modeler involves several features, namely: |
|
You can edit the class label in the CES class hierarchy. |
|
|
This task explains how to edit the class label: |
|
|
|
|
You can create a duplicate of a class and save it in the data model. |
|
|
This task explains how to duplicate a class: |
|
|
|
|
You can add classes, pointers, properties and custom functions in the Table View. You can also add range valid value or enumerated valid values for a property. Adding a data model element involves one or more of the following: |
|
You can add a Subclass or a Folder Class. |
|
|
This task explains how to add a Subclass or Folder Class: |
|
|
|
|
|
Follow the procedures explained in steps 1 through 5 to create a Folder Class. Instead of selecting Subclass, select Folder Class. |
|
You can add class properties to the selected class. |
||
|
This task explains how to add a new property: |
||
|
|
||
|
Do not insert a large number of properties, as the CES Administration Desktop might crash owing to insufficient memory. |
||
|
|
You can add Pointer Class properties to the selected class. |
|||
|
This task explains how to add Pointer Class Properties: |
|||
|
|
|
You can add notes to the selected class. |
|||
|
This task explains how to add notes to the selected class: |
|||
|
|
|
You can add custom functions to the selected class. |
|
|
This task explains how to add custom functions to the selected class: |
|
|
|
|
You can add a JAVA custom function to the selected class. |
|
This task explains how to add JAVA custom function to the selected class: |
|
|
|
You can add enumerated Valid Values for a class property. |
||
|
This task explains how to add Enumerated Valid Values to the selected class: |
||
|
|
|
You can add Range Valid Values for a class property. |
|
|
This task explains how to add Range Valid Values to the selected class: |
|
|
|
|
After each edit operation, the CES Data Modeler highlights all the data model elements affected by an operation in the Table View window. The highlighted data model elements signifies that they are marked for committing. The changes are stored in the database to which you are connected. You need to explicitly commit the action at the end of each edit operation or after you connect to the database. |
||
|
This task explains how to commit the edit task to the database: |
||
|
|
||
|
If you fail to commit, the changes made are lost, and the CES Data Modeler will not reflect these changes when you reconnect to the database. |
|
You can revert changes made to the data model, since the previous commit operation. The revert changes rolls back the changes, and reverts the data model to its original state. |
|
|
This task explains how to revert changes made in the data model: |
|
|
|
|
You can delete any data model element from the CES class hierarchy. There are two methods by which the data model elements can be deleted. The deleting methods are: |
|
You can mark a class to be deleted and commit changes to the database. |
||
|
This task explains how to delete a data model element in the Browser View: |
||
|
|
||
|
If you mark a parent class for deletion, all elements under the parent class, for example, subclasses, pointers, and custom functions are also marked for deletion. |
|
You can also delete a class directly from the database. |
||
|
This task explains how to directly delete a class in the Browser View: |
||
|
|
|
You can restore only those data model elements are marked for deletion. |
|
|
This task explains how unmark the element, which is selected for deletion: |
|
|
|
|
|
If a parent class is marked for deletion, its child class cannot be restored. |
|
You can modify a data model element after it is created. |
|
|
This task explains how to modify a data model element: |
|
|
|
![]() |
You can convert a class property which is: |
|
You can convert a class property which is a non-primary key value to a primary key value. |
|
|
This task explains how to covert a normal class property to a primary key value: |
|
|
|
|
|
A class property with a primary key appears in the
Table View with a key symbol
|
|
|
||
|
The Make Primary Key selection is valid for the entire row in the Table View. |
|
You can convert a class property which is a primary key value to a non-primary key value. |
|
|
This task explains how to covert a normal class property to a non-primary key value: |
|
|
|
|
|
A class property with a primary key appears in the
Table View with a key symbol
|
|
|
|
You can use advanced editing features to edit multiple data model elements in a class in the class hierarchy. Advanced editing in the CES Data Modeler involves several features, namely: |
|
The basic tasks in advanced editing comprise the most commonly used tasks. These are: |
|
You can view multiple class properties simultaneously in the Table View window. |
|
This task explains how to view multiple class properties: |
|
|
|
You can transpose data model elements in the Table View. By default, the details for the selected class are displayed horizontally. Using the Transpose View, you can view the details for the selected class vertically. |
|
You can manually adjust the rows and columns in the Table View window. |
|
This task explains how to manually adjust rows and columns in the Table View window: |
|
|
|
You can type and modify the text in a given cell in the Table View window. You can also use the Delete and Backspace keys to delete the text. You can use mouse to mark the whole or part of the text to select, and then press the Delete or Backspace keys to replace the text. |
|
You can copy and paste a value from one cell to another. |
|
This task explains how to copy and paste a value from one cell to another: |
|
|
|
You can copy and paste a class hierarchy from one data model file to another data model file. You can also copy and paste a class hierarchy from the database to a file and vice-versa. |
|
This task explains how to copy and paste the hierarchy: |
|
|
|
You can add multiple elements to the database. Adding multiple elements constitute adding multiple pointer properties and multiple custom functions. For more information about adding multiple elements, see: |
|
You can add multiple pointer properties. |
|
This task explains how to add multiple pointer properties: |
|
|
|
You can add multiple custom functions. |
|
This task explains how to add multiple custom functions: |
|
|
|
You can delete multiple data model elements. |
|
This task explains how to delete multiple data model elements: |
|
|
|
If you mark a main class for deletion, all elements under main class, for example, subclasses, pointers, and properties are also marked for deletion. |
|
You might need to reorganize or change the display order of data model elements in the CES class hierarchy. |
|
This task explains how to drag and drop a data model elements: |
|
|