KeepTool cостоит из трех компонент: Hora (среда администрирования и разработки), ER-Diagrammer (инструмент для разработчика) и PL/SQL-Debugger (отладчик). Программа имеет полный базовый уровень для построения всей необходимой функциональности, включая пошаговую отладку, в Oracle. KeepTool - 7-го поколения собрала вместе три инструмента производительности Oracle, каждое предназначенное для определенной цели и доступное по отдельности. Каждое из трех инструментов (Hora, ER Diagrammer и PL/SQL Debugger) также предназначено, чтобы можно было работать с двумя другими совместно. Цель создания данного рода программ состоит в том, чтобы делать их легкими и интуитивно понятными. Над KeepTool 7 постоянно трудятся, чтобы увеличить существующие функциональные возможности и включать новые особенности баз данных Oracle.
Несмотря на набирающие обороты языка Java, основным и наиболее близким к ядру Oracle языком хранимых процедур продолжает оставаться PL/SQL. Он интересует разработчиков не только как наследие прошлого, но и как программная среда, способная наиболее эффективно взаимодействовать с хранимыми данными. В версии 9 разработчики Oracle не только ввели ряд улучшений в средства поддержки работы с Java, но и, в очередной раз, усовершенствовали реализацию PL/SQL.
Однако, с достойной удивления твердостью фирма Oracle долгое время воздерживалась от предоставления программистам специальной среды для работы с PL/SQL. Как же быть тем, кто перешел от освоения этого языка к промышленной разработке и не удовлетворяется больше использованием текстового редактора и удручающе частой выдачей SHOW ERRORS в SQL*Plus? Инициативу в разрешении этого вопроса в добровольном порядке взяла на себя фирма Keep Tool.
The KeepTool 7 family gathers together three Oracle productivity tools, each addressing a specific purpose and available separately. But each of the three products - Hora, ER Diagrammer und PL/SQL Debugger - is also designed to work with the other two, and shares a common design philosophy.
Our goal is to make our products easy and intuitive to use. KeepTool 7 is updated many times each year to enhance its existing functionality and to incorporate new features of the Oracle database.
Hora
Hora is KeepTool's flagship product for viewing and manipulating Oracle databases, and accommodates a variety of users. Primarily designed for both DBA's and developers, it can also help end users query data and generate simple reports. Thanks to its intuitive interface and the ability to preview SQL before execution, Hora does not require that you read the manual before using it.
Its object-oriented navigation system takes you to any database function within a few clicks.
Hora is compact. Everything you need to work with the database is in a single tool. Start-up time and resource usage are minimal.
HoraLight
HoraLight, which follows the design and usability principles of the full version of Hora, makes viewing and modifying tables, and producing simple or complex queries, something that end users can do for themselves with ease.
ER Diagrammer
KeepTool's Entity Relationship Diagrammer shows the tables and their relationships to each other systematically, according to the IDEF1X standard. ER Diagrammer can create an entity-relationship diagram from an existing database. Optionally, for a complex database, ER Diagrammer can generate diagrams for specific portions that you can select. Usually, the result will picture the tables in a manner that shows relationships with all parent tables to the left. If you prefer, you can rearrange the tables differently, and the connectors will follow along. The image can then be saved in a file for future display.
You can also use ER Diagrammer in conjunction with Hora, the parent of the KeepTool 7 family, to generate a data model for a new database. Simply use Hora to define tables—adding, dropping and renaming columns where necessary; then use ER Diagrammer to create a graphic view of your data model.
PL/SQL Debugger
KeepTool 7's PL/SQL Debugger gives you, the PL/SQL developer, all you need to test and debug code. You can set breakpoints and define watches for variables. Breakpoint lines are color-coded and can be removed www.luxter.ru or reset at will. In addition to the source display, there are separate windows that display watched variables, breakpoints and the call stack.
PL/SQL Debugger has been designed with the same emphasis on usability as Hora. This ensures that both tools are closely integrated. Using Hora and the Debugger together, you will be on your way to creating to creating efficient PL/SQL code.
System Requirements
Server:
Hora works with all Oracle versions from 7.2 on any platform.
(Earlier versions of Oracle do not include some of the features that Hora currently supports.)
Oracle SQL*Net Service Version 2 or higher
Client:
PC-compatible with Pentium processor
Windows XP (recommended), Windows 2000
Oracle SQL*Net Version 2 or higher
Version 8.1.2
* In addition to the existing icon that flags primary key columns in the list of table columns, a new blue icon has been added to mark foreign key columns. The primary key icon changed its color from yellow to orange for better visual appearance
* The constraints manager, i.e. Hora's build-in tool that allows you to enable or disable all constraints of the schema, now handles the ORA-00955 error.
* If the index for a primary key or unique constraint already exists, the enable constraint command is re-executed without USING INDEX clause.
* The Reverse DDL engineer now allows you to generate DDL scripts in batch mode. Therefore, you have to run a command like RevDDL.exe <filename> <connectstring> or RevDDL.exe C:\Temp\Scott.SQL SCOTT/TIGER. Please don't forget to "quote" file names including white space.
* If the program is run with at least 2 parameters, error messages are redirected to a file defined by the first parameter.
* In-place editing of table and column comments can be disabled at Extras|Settings, page "behavior".
Home - http://www.keeptool.com/en/products_overwiev.php
