コーソル List of Products and Services

■What is Remote DBA Service? This is a remote connection-based database operation and maintenance service for customers who do not require a full-time DBA due to low frequency of failures and maintenance, and prefer support only when needed remotely. Through remote connection, database and operations professionals provide support inquiries and database operations for the necessary duration when required. The supported database products include Oracle Database, MS SQL Server, PostgreSQL, and MySQL. *Please consult us for other database products. ■Kosal's Technical Expertise - ORACLE MASTER Platinum holders: 43 (No.1 in Japan) - ORACLE MASTER Gold holders: 61 - OSS-DB certified professionals: 17 - MySQL certified professionals: 8 ■Support for Kosal's Product Operations We also provide consistent operation and maintenance for products handled by Kosal, such as Dbvisit, Database Performance Analyzer, Toad, Spotlight, SharePlex, and PISO, as long as they are purchased from us.

• Database

"Toad" is a database management tool for developers and database administrators, with over 4 million licenses sold worldwide. It is available for Oracle Database and SQL Server. 【Feature Introduction】 ■ Automatic SQL Tuning → Simply paste the SQL you want to tune on the screen and press the analyze button! Toad automatically generates SQL rewrite patterns that change the execution plan, executes the rewritten SQL in the connected environment, and measures the time. ■ Comparison and Modification of Database/Schema/Table Data Between Databases → You can compare various database objects between the source and target databases during data migration. ■ Graphical Display of STATSPACK and AWR Reports → Normally, graphing Statspack or AWR reports is done through Excel, but with Toad, you can directly graph the reports without going through Excel.

• Other Software

"Dbvisit Standby" is a solution that allows for easy construction and management of disaster recovery (DR) environments with Oracle and MS SQL Server Standard Edition, as well as PostgreSQL. Operations are conducted through a browser-based management console, making it very simple. Additionally, if you request us to set up the environment, we will provide a standard operational lecture on how to use this product. Please feel free to contact us if you have any requests. 【Features】 ■ A product that can serve as an alternative to Standby Express ■ Supports Oracle Database, SQL Server, and PostgreSQL ■ Simple and easy-to-use web browser-based management console ■ Accelerated creation of standby databases ■ DR test functionality that can be utilized during disaster response training ■ Automatic promotion of the DR site's database to production during a production site failure ■ Easy copying of production environment data to any desired environment ■ Standby DB can be opened as read-only for use with BI tools, etc. ■ Licensing is based on the number of CPU sockets installed ■ No additional costs regardless of how many databases exist within the same chassis

• Other Software

The "Database Performance Analyzer (DPA)" is a monitoring product that performs operational monitoring of databases. DPA has two features that are not found in other monitoring products. Strength 1: It can monitor various database products and managed instances in the cloud with a single product module. Monitored database products: - Oracle Database - SQL Server - SAP ASE (Sybase) - DB2 - MySQL - MariaDB - Percona - PostgreSQL - EDB Postgres Strength 2: DPA detects and notifies about slow SQL queries. DPA utilizes a machine learning feature called Anomaly Detection to learn the SQL being executed. Based on the learning results, DPA automatically detects performance degradation and notifies the user.

• Other Software