Versant Vorkout is an add-on module for the Versant Object Database. Vorkout is a Database Reorganizer Tool for applications that delete large numbers of objects.
It lets you reclaim unused space in your database while it is in normal operation, increasing available free space and improving database performance. Last but not least Vorkout is tightly integrated and can be used through Versant Vitness.
In a freshly populated database the objects are efficiently packed on disk, in storage units called pages. A compact database enjoys performance advantages caused by better allocation of data on disk. A compact database also utilizes its back end cache to the fullest extent because each page in cache contains the maximum possible number of objects.
Over time as objects grow or are deleted, empty holes are created in the tightly packed database resulting in fragmentation of data segments. Thus, performance starts degrading and disk usage is also increased.
Versant has addressed this issue by introducing Vorkout – the enhanced tool provides the user the ability to analyze a database for wasted space and reorganizes the data for reduced fragmentation and restored performance.
To help the database administrator to determine if a database needs a reorganization, Vorkout can perform a detailed analysis of the database and report the freespace and degree of fragmentation. The analysis component of Vorkout can determine the degree of fragmentation of data segments by inspecting every page in the database.
The analysis can be started by selecting the database in Vitness' Network Tree Pane and clicking the "Analyze Database" button in the Vitness toolbar. The data gathered by the analysis operation is used by the compact component of Vorkout:
The Vorkout compact database tool is started from the Vitness console by selecting the database from the Network Tree Pane and clicking the "Compact Database" button in the Vitness toolbar.
A dialog allows the administrator to select the class(es) which should be compacted in the database. Only the objects of the selected class(es) will be compacted. If the administrator has run an analysis of the database beforehand the number of free bytes (i.e., the bytes lost to fragmentation) is displayed in the free bytes column.
Once you have selected the classes you want to compact, the administrator can set the desired Batchsize from the list. The batchsize specifies the number of objects to be compacted in a given operational pass. This can be used to tune the memory requirements and execution speed of the Vorkout. The database and class currently being compacted is displayed as well as a progress bar showing the progress for the entire operation. The dialog can be closed to run the operation in the background. The progress will then be displayed in the Vitness Progress pane.
The system table is a hash table that is used by the database server to lookup physical object locations within the database volumes given an objects LOID (logical object identifier) as the key. It is implemented using extensible hashing which is a form of dynamic hashing scheme. The LOID values are the keys for the hash
table. Due to the random nature of insertions and deletions into this hash table, the table gets fragmented over time and this leads to a large hash bucket directory as well as a large number of leaf pages containing very few or no key/data values. This fragmented table can lead to increased memory consumption, slower lookups,
and unnecessary space usage in the database.
The administrator can select whether to perform the system table de-fragmentation by selecting the Compact System Tables option in the appropriate Vorkout dialog. The Thershold in % selector allows the administrator to determine the level of fragmentation in the system tables at which the de-framentation is run.
The tool may be run on an online database and there is minimum impact on clients.
Please use the Purchase Inquiry Form to receive individual information on runtime pricing and licensing.
Be sure to visit the Versant Developer Center! Versant provides a variety of technical resources to help you getting into object-oriented data management and to support you become productive using the Versant Object Database:
Technical Questions:
Message Boards
Purchase Inquiries:
Versant Object Database
FastObjects .NET
General Questions:
Quick Message Form
For postal adresses, phone numbers, e-mail addresses, driving directions etc please refer to:
Get a free 60-day Evaluation copy and testdrive the Versant Object Database or FastObjects .NET! Downloads are available within the Versant Developer Center:
Versant is offering a free one-day “checkup” of your Versant database setup and server configuration.
In today's fast paced world you want to be part of a company that is on the leading edge of technology? Join Versant!
The Versant Developer Center (VDC) provides all the essential information and valuable resources needed for developers, just like
OEM Partner Program: Versant offers independent software vendors and
value-added resellers an OEM Jump Start Package for free!
www.versant.com | Copyright © 2003-2008 Versant Corp. All rights reserved.
For questions about this site please contact webmaster@versant.com
Versant, Vitness, Vorkout, Vildcard, Vhistle, Vhisper, Varehouse, Vedding, reVind and FastObjects are either registered trademarks or trademarks of Versant Corporation in the United States and/or other countries. All other products might be a registered trademark or trademark of their respective company in the United States and/or other countries.
Add-on Modules for the Versant Object Database.
If mission critical deployments are a part of your business or if you need to access data through SQL, Versant provides Enterprise-class Add-on Modules for the Versant Object Database.
The observation of a production system is a cornerstone to the proper establishment of an adequate System & Network Management policy.
Using Versant Vitness for the advanced monitoring of your entire Versant Object Database environment provides you with a fundamental tool for all database administration operations and decisions.
The Vitness add-on module delivers real-time views of performance data and analytical information about the Versant Object Database at the push of a button. Proactive database monitoring prevents potential faults that could be unexpectedly generated by an unobserved system - Versant Vitness alerts administrators before database availability is affected. Can life get any easier?
Versant Vorkout is a Database Reorganizer Tool for applications that delete large numbers of objects. It lets you reclaim unused space in your database while it is in normal operation, increasing available free space and improving database performance. Last but not least Vorkout is tightly integrated and can be used through Versant Vitness.
Over time as objects grow or are deleted, empty holes are created in the tightly packed database resulting in fragmentation of data segments. Thus, performance starts degrading and disk usage is also increased.
Versant has addressed this issue by introducing Vorkout - the enhanced tool provides the user the ability to analyze a database for wasted space and reorganizes the data for reduced fragmentation and restored performance.
Vedding is an add-on software module for the Versant Object Database enabling automatic fail-over and recovery in the case of hardware or software failure. This is commonly known as a Fault Tolerance environment.
Vedding uses synchronous replication between two database instances and supports transparent re-synchronization in the event of a failure. Synchronous database replication mirrors the contents of one database to another in a predictable and orderly manner. This provides either local or geographically remote redundancy, which protects against the unavailability of data.
The Vhistle add-on module for Asynchronous Replication supports both master-slave and peer-to-peer asynchronous replication between multiple Versant Object Database servers. This can be used to replicate data to a distributed recovery site or to replicate data between multiple local object servers for increased performance and reliability.
In many applications, there is a need to replicate data, typically to improve availability, to improve performance by geographically co-locating databases with the applications that access the databases, to isolate decision support systems from online production systems, and to help in recovery from failures using warm-standby systems.
Vhisper provides Warm Standby capabilities to a Versant Object Database. The add-on module is used as an incremental rollforward recovery. It is designed to minimize the downtime in an emergency event.
With Vhisper, an up-to-date copy of the primary database is maintained - this is a Warm Standby database. In case of an emergency, the Vhisper's Warm Standby database can be updated very quickly to the state of the primary database. Instead of starting a full database restore that may take a considerable time with large databases, you just need to apply the last roll forward archive plus the logical.log of the primary database to the Warm Standby database - and you are ready for anything.
Varehouse is an add-on software module that enables the Versant Object Database to use the disk mirroring features of EMC Symmetrix or other enterprise storage systems to take an online backup of very large data volumes without impacting availability (High Availability Backup, HAbackup).
Varehouse, Versant's High Availability Backup solution, is a generic way of achieving continuous online backup of the Versant Object Database. It exploits the capabilities of special storage devices. It allows the user to execute certain operations such as, splitting a mirrored device, after bringing the database to a consistent state.
Vildcard enables you to run a discounted standby server in parallel to your initial Versant Object Database server.
Most likely, Vildcard is used for generic cold standby environments where backups are accomplished manually in certain periods.
reVind is an Add-on module for the Versant Object Database. The Versant/SQL suite of software modules permits you to use conventional Structured Query Language (SQL) semantics to access data that resides in a Versant Object Database.
The resulting application architecture can offer the strengths of both the relational and the object database models, such as the openness and interconnectivity of relational tables along with the expressiveness and performance of object collections.