Cassandra
Cassandra is a statistics management and manipulation tool for Oracle databases. It provides, through statistics manipulation, the possibility for Oracle developers to tune their SQL for databases of different size and contents. This ensures that SQL is written correctly already during the development phase and that bottlenecks are caught early on, before they become a problem in mission-critical applications. Large Database Simulation via Statistics ManipulationOracle's execution plans are based on statistics, that is, the size and contents of the database. Cassandra is used to manipulate these statistics and, as a result, Oracle's optimizer as well. This unique ability enables the simulation of the behaviour of Oracle's optimizer in databases of different size and contents. Therefore there is no need to have any actual data available while tuning SQL. Normally creating a test environment from a production database is time consuming and tedious. Cassandra renders this task unnecessary since with Cassandra there is no need to generate or transfer any data from the production environment to the test database. Simply adjusting the statistics of the test database to the required values is all that is needed for a virtual production database to be used for generating viable execution plans. This greatly reduces the costs associated with creating and maintaining a test environment. Efficient Management of Database StatisticsCassandra stores all of its statistics information in its own repository. It is possible to create multiple, easily manageable versions of a single table's statistics to reflect tables with varying size and contents. Cassandra stores these statistics in easily modifiable table- and database scenarios. The database scenarios can be used for simulation purposes or as backups of Oracle's data dictionary statistics, for example. Switching between different database scenarios can be performed quickly and easily with the Database Scenario Editor. Generating and Manipulating Statistics Quickly and EasilyGenerating statistics for very large and heavily used tables with Oracle's analyze command can take anything up to several hours depending on the size and usage of the table being analyzed. With Cassandra, those statistics can be calculated within minutes. Cassandra offers several tools for creating and modifying table, index and column statistics. The statistics can be retrieved from the actual database, estimated from the contents of the tables, retrieved from Oracle's data dictionary or created from scratch. Several figures, for example block counts and index depth, can be estimated from the given row count of the table. Cassandra's autoconsistency feature makes sure that all statistics are kept consistent while editing. Storing and Managing Execution PlansCassandra can be used to generate, compare and store execution plans created with Oracle's explain plan command. The ability to store execution plans also gives developers the possibility to easily document their tuning work on SQL. An editor for executing SQL queries and Data Manipulation Language (DML) commands is also provided. RDBMS SupportOracle RDBMS version 8.1.X and higher System requirements for Cassandra 3.1.0 Client Application
For more information please contact Thomas Antila. A free-of-charge trial version of Cassandra can be acquired for testing purposes. For more information about the trial version, send your inquiries to support. Please include your complete contact information (name, company, street & postal address, e-mail address and telephone number) in the e-mail.
|
