SoftTree Technologies Releases Five New Management and Productivity Tools for Oracle Databases

Business Wire, March 30, 2005

NEW YORK -- Extending its leadership in the database management and development tools market, SoftTree Technologies, Inc. today announced 5 new database management and productivity tools for Oracle databases. These tools significantly extend the capabilities of its DB Tools for Oracle(TM) suite of multi-purpose database tools used to detect, diagnose, and correct database performance issues; and also code, monitor, debug and benchmark database applications. The new solutions will provide database developers and administrators (DBAs) with the ability to maximize database uptime, make faster and more informed decisions, and reduce costs for significant savings over the competition.

The new DB Tools for Oracle v5.0 consists of 21 unique tools that cover virtually all aspects of everyday database management and development tasks. To further extend its value, SoftTree Technologies is including the new tools at no additional cost, making DB Tools the industry's most affordable, easy-to-use database management and development solution for Oracle databases. To achieve comparable functionality from other vendors, the cost can be up to 30 times more expensive than the SoftTree Technologies solution.

DB Space Expert

The addition of the space management component with built-in online reorganization capabilities to the DB Tools suite, DB Space Expert, takes Oracle database availability to new levels by providing DBAs with the tools to make intelligent decisions about critical database issues, before problems arise. DB Space Expert provides the ability to reorganize business-critical databases online, while applications remain up and running and fully available to users. DB Space Expert can be used to quickly identify objects that would benefit most from space reorganization and then reorganize them either in a real-time or schedule reorganization jobs for those objects or even entire tablespaces. By optimizing object storages, defragging tablespaces and files, and reclaiming wasted disk space, DB Space Expert reduces the need for additional storage requirements and helps to avoid expensive storage upgrades.

DB Consumer Expert

DB Consumer Expert provides one-stop solution for managing Oracle database users, security settings, database resource quotas and resource usage plans. DB Consumer Expert enables aligning database resources with the real-world demands of daily business and realigning those resources as demands change--especially in terms of meeting service-level agreements with internal and external customers. In addition it provides a large set of analytical reports for exploring database usage patterns and trends by users and applications. Using these reports Oracle DBAs can now easily pinpoint who is consuming most of the database resources and then use the available DB Consumer Expert's resource management functions to realigning those resource as needed ensuring that critical business applications meet their service levels.

DB Copy Expert

DB Copy Expert is a must-have tool for every DBA and developer who works with multiple Oracle databases. DB Copy Expert can be used to copy and migrate schema objects and entire schemas between Oracle databases; copy tables with and without data; copy samples of production data to development or QA environment; copy entire database schemas. DB copy Expert provides tremendous timesavings by intelligently resolving schema object dependencies and referential constrains and ensuring that schema objects are copied in the proper order thus freeing DBAs and developers form the need to recursively migrate database application using tedious multiple-step methods. DB Copy Expert also provides robust code and data migration solution to Oracle DBAs and developers who upgrade or downgrade their existing applications to support different versions of Oracle database servers. DB Copy Expert is able to migrate existing applications automatically without any user intervention, downgrading or upgrading application components as required by the version of the target database. Best of all, DB Copy Expert features easy-to-use intuitive graphical interface supporting convenient drag-and-drop methods that make copying and migrating schema objects and data between Oracle databases as simple as copying files between folders using Windows Explorer.

LOB Viewer and Loader

This unique solution can be used for browsing and viewing various types of documents saved in database LOB (Large Object) columns as well as for loading new documents into the database. LOB Viewer is especially helpful to database developers because it enables them to view data stored in LOB columns which cannot be done using regular database development tools such as SQL*Plus and other. Developers can now view, delete, update and insert almost any document or file directly into the database without launching the document's native application.

Test Data Generator

One of the biggest roadblocks for database developers is to create realistic test databases that accurately simulate the production environment. DB Tools' Test Data Generator is an efficient tool for creating large volumes of meaningful data for performance testing, quality assurance testing, usability analysis, and many other purposes. Test Data Generator intelligently detects database referential integrity constraints and without any user intervention generates test data that match all referential integrity rules. The default data generation rules can be customized on per-table-column basis to fit specific business requirements. Test Data Generator comes with a large set of pre-built data libraries containing the most commonly used data values including meaningful addresses, names, phone numbers, company names, industries, financial terms, healthcare data, drugs, auto-parts and more. It also provides developers with the flexibility to create and modify their own data libraries, create custom data generation rules, and extract samples of the excising production data. With its intuitive user interface, project management capabilities and ability to model complex data relationships, Test Data Generator is a fast, easy source of meaningful test data.