コーソル 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 resident 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 perform 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. ■ KOSOL'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 Operations of KOSOL's Products We provide consistent operation and maintenance for products we handle, such as Dbvisit, Database Performance Analyzer, Toad, Spotlight, SharePlex, and PISO, if purchased from our company.

• Integrated operation management

"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 → Just 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 taken. ■ Comparison and modification of database/schema/table data between databases → You can compare various database objects from the source and target 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 graph reports directly without using Excel.

• Other operation management software
• Other information systems

"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 recovery training ■ Ability to automatically promote the DR site 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, allowing use with BI tools, etc. ■ Licensing is based on the number of CPU sockets ■ No additional costs regardless of how many databases exist within the same chassis

• Other information systems

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 learns the executed SQL using a machine learning feature called Anomaly Detection. Based on the learning results, DPA automatically detects performance degradation and notifies the user.

• Other operation management software