Fabric Data, Unleash Value
Fabric Data, Unleash Value
--Intelligent Monitoring and Tuning for Oracle/SQL Server Database
--AI-Powered Multi-Source Data Integration and Sharing
--Intelligent Monitoring and Tuning for Oracle/SQL Server Database
--AI-Powered Multi-Source Data Integration and Sharing
Your Trusted Database Intelligence Guardian
KTuner & KCare
KTuner & KCare
KLake Virtual Data Center
KLake Virtual Data Center
KShare Data Sharing Platform
KShare Data Sharing Platform
KAid Cloud Bastion Platform
KAid Cloud Bastion Platform
Unified Data Integration Management System
Database Intelligent Diagnostics & Optimization Platform
Fully Web-based Remote Assistance with Instant Response, without complex configuration.
Real-time Data Sharing & Exchange Across Applications via RESTful APIs
Target Pain Points, Boost System & Data Management Efficiency
Target Pain Points, Boost System & Data Management Efficiency
KTuner Tri-Integrated Ops Solution
KTuner Tri-Integrated Ops Solution
KLake Realizes Multi-source Data Management in Real Time and Accurately
KLake Realizes Multi-source Data Management in Real Time and Accurately
KLake: An MPP-Based High-Performance Real-Time OLAP In-Memory computing Engine
Unifying disparate database resources into a virtual data lake, KLake enables cross-database queries with a single SQL statement—effectively resolving the problems of cross-database data management while delivering real-time analytics with comprehensive data coverage.
KShare: Simplifying Cross-Application Connectivity
KShare: Simplifying Cross-Application Connectivity
KShare Dynamically and real-time desensitize third-party applications and RESTful API services to avoid security risks such as data leakage, and realize real-time data sharing and exchange between different application systems.
Transition from Cost Center to Profit Center
Transition from Cost Center to Profit Center
Efficient IT management, superior business performance, and operation and maintenance personnel are freed from repetitive and tedious work, so that the IT operation and maintenance department can focus more on the operation of the business, realize the transition from the traditional cost center to the profit center, and achieve cost reduction and efficiency improvement
Pinpoint Root Causes of Performance Issues, Ensure Sustained High Database Performance
Application Scenarios
Application Scenarios
Medical
Medical
Finance
Finance
Through KTuner Trinity software, the performance optimization, diagnosis and analysis of the database system are carried out to improve the operation and maintenance efficiency and reduce the operation and maintenance cost
The bank branch will query the data reporting work from KLake regularly, and easily realize parallel query of multiple databases and unified management of data through MPP calculation and processing, and store the results in the interface front-end database, so as to effectively reduce the burden of each business database.
Support real-time BI report application; help management to dynamically grasp real-time business dynamics
Through the KLake platform, Powering the Evolution of Smart Hospital Solutions
Manufacturing
Manufacturing
✔Intelligent Database Diagnostics & Tuning
✔Data Virtualization for Data Fabric Architecture
✔ Empowering Smart Data, Leading the Future
of Enterprise Data Governance
✔Intelligent Database Diagnostics & Tuning
✔Data Virtualization for Data Fabric Architecture
✔ Empowering Smart Data, Leading the Future
of Enterprise Data Governance
Database Intelligent Diagnostics & Optimization
Database Intelligent Diagnostics & Optimization
Customer Service Cases
Customer Service Cases
User Pain Points
During the morning business peak on a workday, the bank's electronic channel system (including third-party payment services) experienced severe response delays and freezes, preventing users from completing small payments for public transportation and subway services. The user team has been handling the issue for over 90 minutes, with multiple database restarts proving ineffective. Complaints from business departments have surged, putting immense pressure on the operations team, yet they remain unable to pinpoint the root cause of the problem
Solution
KTuner captured three high-frequency SQL execution plans in the core transaction chain within 5 minutes, showing significant fluctuations (changes). The execution time soared from an average of 500ms to over 50s. Further investigation revealed that the main business table had as many as 8 layers of indexes, with a fragmentation rate exceeding 85%. Tracing the business logic revealed that this table was used for batch deletion of expired data and insertion of new data (approximately 3 million records per day) at midnight every day. Due to long-term neglect and lack of index optimization and reconstruction, the B+ tree structure severely deteriorated. By using KTuner's one-click execution plan solidification feature, the original efficient execution plan was immediately restored, and business response returned to normal within 10 minutes. Index reconstruction was also performed during maintenance windows to completely resolve the issue
User Pain Points
During the morning business peak on a workday, the bank's electronic channel system (including third-party payment services) experienced severe response delays and freezes, preventing users from completing small payments for public transportation and subway services. The user team has been handling the issue for over 90 minutes, with multiple database restarts proving ineffective. Complaints from business departments have surged, putting immense pressure on the operations team, yet they remain unable to pinpoint the root cause of the problem
Solution
KTuner captured three high-frequency SQL execution plans in the core transaction chain within 5 minutes, showing significant fluctuations (changes). The execution time soared from an average of 500ms to over 50s. Further investigation revealed that the main business table had as many as 8 layers of indexes, with a fragmentation rate exceeding 85%. Tracing the business logic revealed that this table was used for batch deletion of expired data and insertion of new data (approximately 3 million records per day) at midnight every day. Due to long-term neglect and lack of index optimization and reconstruction, the B+ tree structure severely deteriorated. By using KTuner's one-click execution plan solidification feature, the original efficient execution plan was immediately restored, and business response returned to normal within 10 minutes. Index reconstruction was also performed during maintenance windows to completely resolve the issue
Quickly and accurately find the root cause and deeply optimize the database
Quickly discover inefficient SQL, optimize database and improve application experience
User Pain Points
During the course selection period, the school's teaching system was severely stuck, with business responses exceeding 30 seconds, frequent "course selection errors", and a very low success rate for first-time course selection. The school was forced to adopt a "time-divided course selection" strategy (by major and grade), which led to disputes over the fairness of course selection. Students who participated in the popular courses first were locked in, triggering student complaints. The school gave feedback to the business system developer, but multiple attempts to optimize failed and the root cause could not be located, which seriously affected the development of related teaching work.
Solution
The school information center used KTuner to optimize the database of the teaching system. The SQL analysis function quickly located the problem, captured a large number of high-frequency and inefficient SQL statements during business peaks, and accurately located that the single execution efficiency of a certain SQL statement was obviously abnormal, and there was serious lock competition. The automatic optimization function gave a clear solution (automatically generated execution scripts), and completely solved the problem of system freezes during the peak course selection period by supplementing indexes and optimizing logical defects in business storage processes.
User Pain Points
During the course selection period, the school's teaching system was severely stuck, with business responses exceeding 30 seconds, frequent "course selection errors", and a very low success rate for first-time course selection. The school was forced to adopt a "time-divided course selection" strategy (by major and grade), which led to disputes over the fairness of course selection. Students who participated in the popular courses first were locked in, triggering student complaints. The school gave feedback to the business system developer, but multiple attempts to optimize failed and the root cause could not be located, which seriously affected the development of related teaching work.
Solution
The school information center used KTuner to optimize the database of the teaching system. The SQL analysis function quickly located the problem, captured a large number of high-frequency and inefficient SQL statements during business peaks, and accurately located that the single execution efficiency of a certain SQL statement was obviously abnormal, and there was serious lock competition. The automatic optimization function gave a clear solution (automatically generated execution scripts), and completely solved the problem of system freezes during the peak course selection period by supplementing indexes and optimizing logical defects in business storage processes.
User Pain Points
The HIS system (hospital information system) database of a Grade A Tertiary Hospital was directly deployed by the business vendor. There was no professional DBA involved in the planning and design, and the default Oracle installation parameters were basically used. After running for a period of time, during business peaks, the database performance often dropped sharply, and operations such as opening orders and paying bills frequently jammed, often causing complaints from patients. The user adopted the suggestions of the business developer and upgraded and expanded the hardware many times, but each upgrade and expansion was only effective for a short time (2-3 months), and jams still occurred after a while. When the hardware was upgraded to the upper limit (server and storage with the highest configuration), the problem still existed.
Solution
Without changing the hardware, adjusting the architecture, or modifying the code, users deploy KTuner to conduct a comprehensive diagnosis and analysis of the database. Configuration scanning: Marks more than 20 relatively hidden but very unreasonable key configuration items Resource utilization analysis: Through historical load data, analyzes over-configured resources, provides recycling suggestions, and ensures that existing resources are fully and effectively utilized. Automatically generate optimization solutions: Based on the characteristics of the user's actual business, as well as database-related statistical information and logs, automatically generates parameter optimization suggestions to solve the problem of freezing .
User Pain Points
The HIS system (hospital information system) database of a Grade A Tertiary Hospital was directly deployed by the business vendor. There was no professional DBA involved in the planning and design, and the default Oracle installation parameters were basically used. After running for a period of time, during business peaks, the database performance often dropped sharply, and operations such as opening orders and paying bills frequently jammed, often causing complaints from patients. The user adopted the suggestions of the business developer and upgraded and expanded the hardware many times, but each upgrade and expansion was only effective for a short time (2-3 months), and jams still occurred after a while. When the hardware was upgraded to the upper limit (server and storage with the highest configuration), the problem still existed.
Solution
Without changing the hardware, adjusting the architecture, or modifying the code, users deploy KTuner to conduct a comprehensive diagnosis and analysis of the database. Configuration scanning: Marks more than 20 relatively hidden but very unreasonable key configuration items Resource utilization analysis: Through historical load data, analyzes over-configured resources, provides recycling suggestions, and ensures that existing resources are fully and effectively utilized. Automatically generate optimization solutions: Based on the characteristics of the user's actual business, as well as database-related statistical information and logs, automatically generates parameter optimization suggestions to solve the problem of freezing .
Small investment, big benefits, making the database from "usable" to "good to use" transition
transition
Customer Service Cases in Various Industries
Customer Service Cases in Various Industries
User Pain Points
On a morning rush hour, the pharmacy‘s database became locked, causing a massive queue for medication pickup. The hospital IT department was unable to resolve the issue and sought remote diagnosis from a third-party expert. Since the third-party expert was not in front of the computer, they could not handle the situation promptly, resulting in a delay of about 20 minutes; when the expert connected to the hospital temporary interface via remote assistance software, they found that the necessary ssh and database tools were missing, which took another 10 minutes or so to install. After all preparations were completed, it took approximately 30 minutes to resolve the issue, but the overall duration of this performance failure exceeded one hour, causing significant impact on the hospital.
Solution
With KTuner suite, engineers can use any device to provide connectivity through the KAId component to quickly connect to the target via the WEB, avoiding multiple jumps; ensure that processing begins as soon as the connection is established, avoiding wasted time preparing the environment; automate diagnostics to generate executable processing scripts in minutes.
User Pain Points
On a morning rush hour, the pharmacy‘s database became locked, causing a massive queue for medication pickup. The hospital IT department was unable to resolve the issue and sought remote diagnosis from a third-party expert. Since the third-party expert was not in front of the computer, they could not handle the situation promptly, resulting in a delay of about 20 minutes; when the expert connected to the hospital temporary interface via remote assistance software, they found that the necessary ssh and database tools were missing, which took another 10 minutes or so to install. After all preparations were completed, it took approximately 30 minutes to resolve the issue, but the overall duration of this performance failure exceeded one hour, causing significant impact on the hospital.
Solution
With KTuner suite, engineers can use any device to provide connectivity through the KAId component to quickly connect to the target via the WEB, avoiding multiple jumps; ensure that processing begins as soon as the connection is established, avoiding wasted time preparing the environment; automate diagnostics to generate executable processing scripts in minutes.
Quickly connect anytime, anywhere to speed up and improve emergency database troubleshooting ——
——
Real-time data base for smart campus construction
User Pain Points
Smart campus applications (such as IoT device management and campus card consumption analysis) rely on real-time and comprehensive data, but traditional integration platforms (ETL) have problems with data delays and incomplete coverage, and require long-term and high-cost interface maintenance; they involve a large amount of cross-database data integration and historical data tracing, and manual processing is time-consuming and error-prone, making it difficult to cope with national/provincial assessments and audits.
Solution
KLake virtualizes the school's database (such as energy consumption monitoring system, financial system) into a unified data source and provides full data interface in real time. Supports intelligent applications to quickly call cross-system data.
Utilize KLake's cross-database query capabilities to quickly extract relevant data scattered across research systems, financial systems, and asset management systems, automatically generating standardized reports. Support multi-year data comparison (such as trends in research funding growth and changes in equipment utilization) to ensure the completeness and consistency of audit data. Reduce compliance risks, improve efficiency in preparing for audits and reviews, and minimize human resource investment
User Pain Points
Smart campus applications (such as IoT device management and campus card consumption analysis) rely on real-time and comprehensive data, but traditional integration platforms (ETL) have problems with data delays and incomplete coverage, and require long-term and high-cost interface maintenance; they involve a large amount of cross-database data integration and historical data tracing, and manual processing is time-consuming and error-prone, making it difficult to cope with national/provincial assessments and audits.
Solution
KLake virtualizes the school's database (such as energy consumption monitoring system, financial system) into a unified data source and provides full data interface in real time. Supports intelligent applications to quickly call cross-system data.
Utilize KLake's cross-database query capabilities to quickly extract relevant data scattered across research systems, financial systems, and asset management systems, automatically generating standardized reports. Support multi-year data comparison (such as trends in research funding growth and changes in equipment utilization) to ensure the completeness and consistency of audit data. Reduce compliance risks, improve efficiency in preparing for audits and reviews, and minimize human resource investment
User Pain Points
A hospital is a tertiary comprehensive hospital. Its venous thromboembolism (VTE) risk assessment system needs to obtain real-time data from HIS, hand numbness, ultrasound, ECG, pathology, radiology, endoscopy, physical examination and other systems . The hospital's integrated platform, data center, data warehouse and other systems are difficult to provide real-time and comprehensive data support for AI analysis. If data is directly extracted from the production library, it will have a significant performance impact on the production system.
Solution
Through KLake's cross-database SQL capabilities and the scheduling function of the KETTLE tool, results are stored in the interface front-end database. Leveraging the computing power of MPP (Massively Parallel Processing) clusters, this accelerates SQL execution efficiency. Efficiency is typically dozens or even hundreds of times higher than executing on the source database, enabling more efficient cross-database data statistics and comparisons
Through the KShare interface platform, real-time and comprehensive data support is provided for the VTE system, so that the VTE system can be put into trial operation in about one month
User Pain Points
A hospital is a tertiary comprehensive hospital. Its venous thromboembolism (VTE) risk assessment system needs to obtain real-time data from HIS, hand numbness, ultrasound, ECG, pathology, radiology, endoscopy, physical examination and other systems . The hospital's integrated platform, data center, data warehouse and other systems are difficult to provide real-time and comprehensive data support for AI analysis. If data is directly extracted from the production library, it will have a significant performance impact on the production system.
Solution
Through KLake's cross-database SQL capabilities and the scheduling function of the KETTLE tool, results are stored in the interface front-end database. Leveraging the computing power of MPP (Massively Parallel Processing) clusters, this accelerates SQL execution efficiency. Efficiency is typically dozens or even hundreds of times higher than executing on the source database, enabling more efficient cross-database data statistics and comparisons
Through the KShare interface platform, real-time and comprehensive data support is provided for the VTE system, so that the VTE system can be put into trial operation in about one month
Real-time and efficient integration management of multi-source data provides real-time data support for smart hospital applications
Shanghai TaoData Technology Co., Ltd. is a high-tech enterprise focusing on database products, IT operation and maintenance products, and large-scale IT system construction solutions. The company is committed to enhancing customers' capabilities in handling massive data and IT operations. Since its establishment, it has built core database platforms for high-end users including banks, securities firms, transportation, healthcare, universities, and government agencies, as well as IT automation operation and maintenance platforms. These efforts have established ultra-high security, ultra-high stability, and performance IT core systems for customers.
Shanghai Taodata Technology Co., Ltd.
Shanghai Taodata Technology Co., Ltd.
Address: 1625, 16th Floor, Biyun Center, 3680 Zhangyang Road, Pudong New District, Shanghai
Tel: +86-21-68770597
Company Profile
Company Profile
Message Board
Message Board
Address: 1625, 16th Floor, Biyun Center, 3680 Zhangyang Road, Pudong New District, Shanghai
Tel: +86-21-68770597
Address: 1625, 16th Floor, Biyun Center, 3680 Zhangyang Road, Pudong New District, Shanghai
Tel: +86-21-68770597