Contents


What is ODDIS (Version 2.11)?

ODDIS (Oracle Data Dictionary Information System) is intended as an aid for novice users as well as administrators of Oracle databases (>= Version 7). Since the data dictionary contains a vast amount of information, it is often difficult to obtain required information about certain users or database objects.

The Oracle Data Dictionary Information System (ODDIS) provides a graphical user interface which allows you to retrieve most of the static information contained in the Oracle Data Dictionary (ODD). You can select a database object from the menu and the tool displays detailed information about the object in a formatted output window. From this window you then can navigate to further information connected with the chosen object. Besides this you have the possibility to edit an SQL statement in a special window. You can load, save and execute this statement. Also you can save and print the results of the execution of an SQL statement. Using the menus you can calculate statistics for user-objects and get an execution plan for the given SQL statement. An execution plan can be displyed as tree from which you can select detailed information about objects involved in the execution plan. Also you can save and print the results of the analysis of a SQL statement. As a DBA you can create new tables with information about physical devices. ODDIS provides an integrated access to the Oracle help tables and a graphical aid for navigating through the ODD.

ODDIS provides a graphical user interface which is programmed using Tcl/Tk developed by John Ousterhout. Tom Poindexter's wosql influenced the development of ODDIS and his Oratcl made it possible at all. Some ideas concerning DBA information were taken from Tim L. Olesen's ODMS - Oracle Database Management System.


Current Features and Progress

The following functionalities are currently implemented as extensions to the current version of ODDIS: All functions will be fully integrated into ODDIS to obtain a database tool which provides support from the conceptual design up to administrating an Oracle Database. If you have any suggestions or ideas which should be integrated into ODDIS, contact
oddis@informatik.uni-hannover.de.


System Requirements, Download and Installation

System Requirements
Download ODDIS 2.11 from: ftp://ftp.informatik.uni-hannover.de/software/oddis/oddis-2.11.tar.gz

or previous versions from

ftp://ftp.informatik.uni-hannover.de/software/oddis/oddis-2.0.tar.gz

The distribution includes the Program, a README file, and a Copyright notice.

Installation

Put the file oddis in a directory contained in your search path. You may have to adjust the first line of oddis to match the correct location of the orawishx interpreter at your site.

Bug Reports / Suggestions

We are interested in comments, suggestions for changes or extensions and bug reports. Please mail to oddis@informatik.uni-hannover.de


Documentation

Due to the regulations at the University of Hannover most of the documentation (as part of a diploma thesis etc) is written in german. But the usage of ODDIS should be straightforward, since all menus and buttons are labeled in english (or what we think is english).

The following documents are available:


Acknowledgments

ODDIS 2.1.1 was written by Michael Bethke (bethke@informatik.uni-hannover.de) and Axel Schlueter (schluete@informatik.uni-hannover.de) and includes minor extensions to ODDIS 2.1. ODDIS 2.1 was written by Regine Kasten (kasten@informatik.uni-hannover.de) also as an one term project in computer science using ODDIS 2.0. ODDIS 2.0 was written by Michael Bethke (bethke@informatik.uni-hannover.de) and Axel Schlueter (schluete@informatik.uni-hannover.de) also as an one term project in computer science using ODDIS 1.0. ODDIS 1.0 was written by Rainer Grtzner (gruetzne@informatik.uni-hannover.de) as an one term project in computer science. The graphical user interface was built with Tcl/Tk.


Legal Stuff

ODDIS is a tool for administrating Oracle databases ODDIS 2.1, Copyright (C) 1996 Regine Kasten & Universitaet Hannover, Institut fuer Informatik ODDIS 2.0, Copyright (C) 1995 Michael Bethke, Axel Schlueter & Universitaet Hannover, Institut fuer Informatik ODDIS 1.0, Copyright (C) 1995 Rainer Gruetzner & Universitaet Hannover, Institut fuer Informatik This program is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software Foundation; either version 2 of the License, or (at your option) any later version.

This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.

You should have received a copy of the GNU General Public License along with this program; if not, write to the Free Software Foundation, Inc., 675 Mass Ave, Cambridge, MA 02139, USA.



Michael Gertz 04.10.96
mg@informatik.uni-hannover.de