데이터베이스(DBMS)

The best company specialized in developing IT operation management solution in Korea

01

Summary

DPM, a database monitoring solution, is a solution which supports various types of DBs and checks various status of database on the integrated screen.

02

Features

  1. Stability and excellence of the verified product
    • Stability and excellence of the product verified through deployment of large site monitoring system such as National Information Resources Service, Defense Integrated Data Center, LGCNS IDC, Shinsegae IDC and more.
    • GS Certified Solution
    • Winners of various awards such as Grand Prize Winner of Korea SW Company Competitiveness, SW division award winner, etc.
  2. User-Friendly UI
    • Provide maximum convenience by enhancing user-driven configuration and management functions through flexible UI which matches users’ characteristics
  3. Support Integrated View of Database Performance Monitoring
    • Provide monitoring function which integrates performance information of various database (performance, wait event, database information, memory information, session status, SQL status) on a single screen
    • All corresponding information is saved as history and used for later analysis.
  4. Equipped with large size data processing engine
    • Apply NoSQL-based large size processing engine (ElasticSearch)
    • Possible to process in real time large size data accumulated for statistics, event logs, and real-time performance
  5. Cluster Structure for High Availability
    • Add clusters with simple configuration when Scale-out of AP is required due to increase of monitoring devices
    • Architecture structure which can be extended and modularized by supporting clustering-based 3-Tier structure
    • Failure of a specific AP among clustered APs does not affect the operation of the entire monitoring system.
03

Main Screens

  • Tablespace Status Information
  • Real-time Session/Lock Session and History Analysis Screen
  • Database Detailed History Trace and Analysis Screen
04

Main Functions

Database Monitoring
  • Monitor database core status (connection status, normal collection status, Listener status, collection delay, etc.) in real time
  • Provide integrated view for various configuration and performance information of database
  • Provide information of database usage (Tablespace/Database) and I/O
  • Provide detailed information of session (connection information, session execution SQL, Lock information, etc.)
  • Provide detailed information of SQL (SQL performance information, TOP SQL, Plan information, etc.)
  • Provide performance and event linkage analysis screen
User Indicator Management
  • Provide query results and response time of indicators which the user registers
  • Provide detection function by registering result and response time as event
Real-time Session/Lock Status and History Analysis
  • Provide various visualized screens in order to save detailed history of database and analyze them efficiently by using Big Data technology
Tablespace Status
  • Possible to check problematic tablespaces by viewing configuration and performance information for all tablespaces added under the database at a glance, and when selecting a group, possible to check a list of all tablespaces in the database under the corresponding group.
Detailed History Trace and Analysis
  • Provide detailed history information such as graph/summary information to save and analyze detailed history, detailed history of session, Top SQL, same view for each DB by using Big Data technology.