MATISSE Editor User Guide for MS Windows
Contents
1. ooooooooooooo 15 Relationship Ordering een 15 VOISIONS ae an ne nee aa decae Godson bd Se ada Be oe end 15 an ddUPQCQ2 2ERmawadad d dQ 2z zwnddddd ad Contents 5 Introduction The Matisse Editor is an application development tool that can be used by developers and database administrators to view create modify or delete database objects Conventions This document uses the following conventions Text The running text is written in 9 point Times Code All computer variables code commands and interactions are shown in 9 point Courier Code and commands that the user must enter are shown in this font on a gray background variable In a program example or in an interaction a variable which means anything that is dependent on the user environment is written in 9 point Courier italics References References to another part of the Matisse documentation are made in 9 point Arial nn oBQooo 6 Matisse Editor User Guide for MS Windows 1 Getting Started 1 1 Starting the Matisse Editor 1 Select mt editor from the Matisse folder of the Start menu or enter mt editor at a command prompt 2 In the Client connection dialog enter the name of the database you wish to edit If the database is not local enter the host username and password as necessary If you wish to select a particular version for editing check Choose Version see section 2 1 Selecting a Different Version Lo2. Seventh Edition Document number DE 97 03 0006R6 Matisse Editor User Guide for MS Windows Document number DE 97 03 0006R6 Copyright 1992 2002 Matisse Software Inc All Rights Reserved Matisse Software Inc 433 Airport Blvd Suite 421 Burlingame CA 94010 USA Printed in USA This manual and the software described in 1t are copyrighted Under the copyright laws this manual or the software may not be copied in whole or in part without prior written consent of Matisse Software Inc This manual and the software described in it are provided under the terms of a license between Matisse Software Inc and the recipient and their use is subject to the terms of that license RESTRICTED RIGHTS LEGEND Use duplication or disclosure by the government is subject to restrictions as set forth in subparagraph c 1 i1 of the Rights in Technical Data and Computer Software clause at DFARS 252 227 7013 and FAR 52 227 19 The product described in this manual may be protected by one or more U S and international patents TRADEMARKS Matisse and the Matisse logo are registered trademarks of Matisse Software Inc All other trademarks belong to their respective owners PDF generated 16 January 2003 Contents 3 GBR SITE AR 7 1 1 Starting the Matisse Editor 0 20 00 cee eee 7 2 Working with Databases 0 0 cee es 8 2 1 Selecting a Different Version Logical Time 8 2 2 Co
3. example browsed object EU Es H lt author Ox54B gt E Shakespeare lt author gt age UNSPECIFIED VALUE ES characteristics UNSPECIFIED VALUE ES too many borrowed books UNSPECIFIED VALUE ES NOTE Selecting edit automatically selects the current version of the database 3 Edit the object s attributes values as desired To set NULL or return the value to its default click its button See Setting NULL or Default Value on page 12 for more information m To change a relationship click its button See section 3 4 Editing Relationships for more information Editing Objects 11 3 3 The Restore and Delete Value Buttons Setting NULL or Default Value Unspecified Value vs NULL Editing String Values Editing Float and Double Values Editing Numeric Values When you click OK the Matisse Editor checks the consistency of the changes against the schema constraints Certain changes that would produce an inconsistency will produce an error message and the Transaction gt Commit and Transaction gt Commit amp Name buttons will be greyed out until the inconsistency is corrected 4 If you wish select and edit additional objects 5 When you have finished making changes select Transaction gt Commit to update the current version of the database or Transaction gt Commit amp Name to create a new version declare a new savetime containing your changes
4. gt Create the changes you make are not immediately applied to the database Instead the Matisse Editor accumulates your changes in an edit transaction A single transaction may include changes to an unlimited number of objects T 10 Matisse Editor User Guide for MS Windows Your changes are not applied to the database until you select Transaction gt Commit or Transaction gt Commit amp Name as discussed below Alternatively you may abandon your changes at any time by selecting Transaction gt Abort 1 If you are editing an instance as opposed to a schema object and need to select new or different successors for one or more of its relationships browse the new successors This will add them to the Edit Relationship dialog s possible successors list See section 3 4 Editing Relationships for more details 2 Select an object by double clicking it in the tree or with one of the alternative methods described in the previous section Select Object gt Edit If this command is greyed out you do not have write access to the database Buttons appear next to the object s editable properties as shown below FA Connected to example at TROCA mt editor x Database Edit View Object Transactions Collections ae ae ole X miel a il lt author 0x54B gt oid 1355 0x54b example schema E author lt Mt Clase name EY book cht Class A ES ES name lt Mt Attributes 5 E person Mb Class surname Ei
5. click OK Editing Objects The most recently selected entry points may be redisplayed by selecting Collections gt Last Entry Points Finding an 1 Select Object gt SQL Query Object with a 2 Enter a SQL statement using the syntax SQL Query select ref x from class name into x where attribute name like value into sel For example 1f the application had a class Person with an attribute LastName to find a person named Smith select ref x from Person into x where LastName like Smith into sel If useful you may paste a SQL query copied from a text editor or other application See the Matisse SOL Programmer s Guide for more information 3 Click Execute 4 If you want to edit an object among the results click on the object reference that is listed as part of the result set The object properties will appear in the main Object Editor window Finding an Select Object gt Object Identifier enter the identifier of the object you wish to Object by its select and click OK Identifier Access an An object may have relationships with other objects These relationships are Object Through represented as object names within a list a Relationship Author of For Whom the Bell Tolls lt Book gt The Old Man and the Sea lt Book gt To access any object that is referenced by a relationship just click the reference 3 2 Starting and Ending an Edit Transaction When you select Object gt Edit or Object
6. 1 Editing You may enter characters directly or specify them using escape sequences Character composed of a backslash followed by the octal code for the character for Values example 1015 for CR Editing Date and Enter dates in the format 2001 10 30 For a timestamp value you may include Timestamp a fractional value of up to six decimal places for example 2001 10 30 Values 14 10 00 000001 Editing Time Specify time intervals in days with a or For example Interval Values 256 12 10 00 000000 Editing Lists Use standard C notation For example 3 4 5 for a list of Integer values abc def for a list of String values 3 4 Editing Relationships The Edit Relationship dialog allows you to add remove and reorder successors Edit Relationship x possible successors SUICCessors Close Hemingway Authors Stevenson lt Author gt Thackeray lt 4uthor gt Add gt Move Up lt Remove Move Dn You may move items between the possible successors and successors list by double clicking The possible successors list includes only objects that are authorized as a successors of the selected relationship U U Editing Objects 13 When editing an instance as opposed to a schema object the possible successors list includes only those authorized successors that appear in the Last browsed lists accessible via the Collections menu This limitation 1s necessary becaus
7. If your changes would create an inconsistency the attempted commit with fail with an error message Editing Attribute Values Two of the buttons in the Edit Attribute dialog are not self explanatory Restore Click to undo changes to the attribute value Delete Value Click to return the attribute value to its default as defined in the schema To set an attribute value to NULL or the default value click the button and pick NULL or default value from the drop down list Do not select default value if no default value has been defined and the attribute is not nullable UNSPECIFIED VALUE means 1 the attribute is nullable 2 no default value has been specified in the attribute descriptor and 3 the attribute value is currently unset for the object being browsed or edited NULL means that the attribute value has been set to NULL for the type Enter any characters You may paste strings copied from other applications or other fields in the editor You may use scientific notation for float and double values as for example in 23 5e12 Numeric values are values that are declared with a fixed precision and scale For instance Numeric 10 2 has precision 10 which means it can hold ten digits maximum and scale 2 which means two digits on the right of the decimal point For instance for a Numeric 10 2 the following values are valid 12 Matisse Editor User Guide for MS Windows 12 100000 99 123
8. e clicking it in the tree Alternatively you may select an object with one of the following methods Browsing ie Instances of an Instances to display the Class Existing Class browser window 2 Select the name of the class whose instances you want to browse and click OK The Instances browser window will appear with a list of instances of the selected class Select one and click OK to display its properties The most recently selected instances may be redisplayed by selecting Collections gt Last Class Instances Browsing Entry When you create the schema for your 9 classes Author Book hak Attribute Mt Class Mt Index Mt Message Mt Method Mt Relationship Mt Universal Method MATISSE Entry Point Points application you can specify a make entry function to be associated with some of the attributes If so the related objects can be found by specifying an entry point value 1 Select Object gt Entry Point to display the Matisse Entry Point dialog 2 Select an attribute for which an entry point has been defined in the schema 3 If you wish to restrict the request to a particular class select it 4 Click OK 5 If Matisse finds more than one matching object it will display the Choose Entry Point Attributes Mt Name Mt Selector Classes Author Person Entry Point Hemingway Entry Point instance browser dialog Select the instance you want and
9. e with large or complex databases the list could easily include thousands of objects Thus as discussed section 3 2 Starting and Ending an Edit Transaction it is necessary to browse the new successors before attempting to edit the relationship Adding objects in the Possible Successors area 1s also possible by using the Class Instances or Entry Point options 3 5 Creating a New Object 1 Select Object gt Create If this command is greyed out you do not have write access to the database 2 Select the class for the new object and click OK Continue as when editing an existing object as discussed in section 3 2 Starting and Ending an Edit Transaction 3 6 Deleting an Object 1 Select the object to be deleted using one of the methods discussed in section 3 1 Selecting an Object for Editing 2 Select Object gt Edit If this command is greyed out you do not have write access to the database 3 Select Object gt Delete 4 Select Transactions gt Commit or Transactions gt Commit amp Name see section 3 2 Starting and Ending an Edit Transaction E See 14 Matisse Editor User Guide for MS Windows 4 Setting User Preferences Select View gt User Preferences to set the following options Streams Sets the maximum number of objects that the Matisse Editor will display for a Number of given stream for example the stream returned for Class Instances Objects Streams First Specifies the minimu
10. ed 7 2 Working with Databases 2 1 Selecting a Different Version Logical Time If multiple versions of the database have been created by declaring savetimes you Choose a version may select a saved version to edit instead Latest Version MONDA Y00000010 1 Select Database gt Set Time TUESDAYOOD00012 2 Select the savetime you wish to edit and click OK NOTE How the Matisse Editor handles new savetimes declared while it is running is determined by the setting chosen on the Versions tab of User Preferences Cancel 2 2 Connecting to a Different Database Before you can connect to a different database you must disconnect the one you are currently editing 1 Select Database gt Disconnect and click OK to confirm If this command is greyed out abort or commit the current transaction 2 Select Database gt Connect Proceed as described in section 1 1 Starting the Matisse Editor 2 3 Importing and Exporting Database Schema The menu choices under Database gt Schema allow you to generate a Matisse ODL file from the currently selected database s schema or update the database s schema from an ODL file See Getting Started with Matisse for more information on these options A oooooBooBAQSBQooeo 11 79927z7 8 Matisse Editor User Guide for MS Windows 3 Editing Objects 3 1 Selecting an Object for Editing You may select an object to view or edit its properties by doubl
11. gical Time 3 Click OK The Matisse Editor will establish a connection with the specified database on the specified host After a successful connection the message Connected to database_name at host_name appears in the title of the window If connection is unsuccessful No database selected or an error message appears instead After you connect to a database the Matisse Editor appears FA Connected to example at TROCA mt editor x Database Edit View Object Transactions Collections aAA Hael Ole N M E example meta schema ig Shakespeare lt author gt oid 1300 0x514 example schema H a author lt Mt Class number of books Ee book Mt Class pB Tr ES person lt Mt Class gt Se example browsed object name Ga Irving lt author gt Shakespeare Ee Romeo and Juliet lt book gt H a Shakespeare lt author surname EY The world according to garp Millian yr age HINIL characteristics HINIL too many borrowed books UNSPECIFIED VALUE Selected works Macbeth lt book gt Romeo and Juliet lt book gt The left frame displays all the objects in the database as a browsable tree If you do not see two frames drag the separator bar to the middle of the window The right frame displays information on the currently selected object To select an object in the tree double click The status bar at the bottom of the window displays the connection status U wu Getting Start
12. m number of instances required for the Matisse Editor to Object Offset return the object Set to 0 the default to return all objects Relationship As stored in the database that is in the order defined by the schema or Orderin g alphabetically Versions Controls what happens when a new savetime is declared Warn you that there is a more recent version of the database and change the Status Area contents indicating the logical number of that version Update automatically the objects that you are currently browsing setting your version access in the new version Do nothing but change the Status Area contents indicating the logical number of the new version a Setting User Preferences 15
13. nnecting to a Different Database 8 2 3 Importing and Exporting Database Schema 8 4 BONO ODIOS zusenden 9 3 1 Selecting an Object for Editing o oooooooooo 9 Browsing Instances of an Existing ClasS 9 Browsing Entry Points 0 0020 c eee eee 9 Finding an Object with a SQL Query o o o ooooo 10 Finding an Object by its Identifier 10 Access an Object Through a Relationship 10 3 2 Starting and Ending an Edit Transaction 10 3 3 Editing Attribute Values 0 cee 12 The Restore and Delete Value Buttons 12 Setting NULL or Default Value o oooooo o o 12 Unspecified Value vs NULL 2220 12 Editing String Values ee eee 12 Editing Float and Double Values 12 Editing Numeric Values a 12 Editing Character Values cece eee eee ee 13 Editing Date and Timestamp Values 13 Editing Time Interval Values o o oooooooooo 13 e 1 A 13 3 4 Editing Relationships a 13 3 5 Creating a New Object 2 0 0 ces 14 3 6 Deleting an Object 0 0c eee 14 4 Setting User Preferences 000 eee 15 Streams Number of Objects 00000 nee 15 Streams First Object OffSet
Download Pdf Manuals
Related Search