Halo Database has been successfully deployed in core business systems across finance, government, energy, healthcare and more industries
A certain core business system
Covers the entire process of stock housing, incremental housing, and land offline business, as well as read and write operations of stored procedures, comprehensively testing the product's performance in core business areas and key data processing links. All test scenarios passed smoothly, the product has excellent stability and adaptability, and no application code modification was required throughout the process, achieving a seamless and smooth migration to the Halo database.
Integrated Planning and Decision Management Support
Original business based on Alibaba Cloud RDS-MySQL 5.7.42 database, using Halo database self-developed migration tool (Halo migration Tool) to migrate online business test data as a whole to Halo database, the original application linked to Halo for business testing, this compatibility MySQL database test covered 232 business function points, all core business function test items passed, no changes were made to the original application code during the compatibility test process. For the 8 core scenarios covering the application business system, performance comparison tests were conducted at 50, 100, and 200 concurrency respectively, and four pressure test values of TPS, Samples, Network, and response time were counted respectively to test the performance of Halo and MySQL. The results show that the Halo database is more than 3 times the original MySQL performance in the four pressure test value dimensions.
Shanghai Gas Core System
Original application system developed in C#, database using Oracle 11G, migrated to Halo database using Halo migration platform HMT, this test covered core business scenarios such as batch data insertion, sporadic entry function, comprehensive query function, and bill query.
Master Data System
Master data system, database is MySQL; this test covers three major scenarios: system scenario testing, functional scenario testing, and application performance scenario testing. System scenario testing 12 categories of scenarios, 33 scenario points; functional testing 7 modules, 32 functional items, performance testing 5 scenarios including batch import, batch change, batch audit, data query interface call, data receiving interface call, gradually increase the concurrency in the order of 10, 20, 50, 100, 200, 500, 1000 and perform pressure tests on the mysql environment and halo environment respectively for 30 minutes; Halo's performance in batch addition, batch change, batch audit, batch interface query, and batch interface receiving is generally better than mysql.
Library Core System
The test covers the main functions of the library core management system, especially the retrieval performance was tested in detail. The test results show that on the basis of not performing any optimization of the application code, the overall retrieval performance can be improved.
Electronic Medical Record System
Completed the migration of the electronic medical record system from the original Oracle to Halo in just 1 week, and completed the testing of main functions.
Bancassurance & Property Insurance Core Systems
Successfully migrated the core system from Oracle to Halo database without modifying the code, and completed all module functional and performance tests to meet business production environment requirements.
ECIF Customer Information Management
Successfully migrated the ECIF system from Oracle to Halo database quickly without modifying the code, batch interface performance test is 5 times faster than the Oracle database in the production environment on average, and up to 10 times faster.
Bancassurance & Group Policy Core Systems
Successfully migrated the core business system DB2 database to Halo database without modifying the code, passed Yinbaotong and group policy module interface tests. Yinbaotong interface response time improved by 2 times compared to DB2.
Life Insurance Core System
Successfully migrated the life insurance core system from Oracle to Halo database without modifying the code, and passed all functional and performance tests, meeting production requirements.
Multi-functional Terminal Digital Production Management Platform
The entire platform used a large number of Oracle database built-in packages, which greatly increased the migration difficulty. Through the powerful compatibility of the Halo database, the database migration was finally completed smoothly and passed all tests.
Manufacturing product life cycle management system
Provided professional IT technical services for Shantui Construction Machinery Co., Ltd., completed the deployment and initialization of the database basic environment, and provided data storage support for the business. Configure a master and slave stream replication architecture, conduct failover drills, and ensure that the master database can quickly switch to the slave database when an anomaly occurs, reducing the risk of business interruption. Establish a regular backup and recovery mechanism, and at the same time improve the data recovery process to ensure that data is traceable and recoverable. SQL optimization enhances database query efficiency and operational performance, and improves business access experience. Sort out and compile a standardized operation and maintenance manual, covering daily operation and maintenance operation norms, emergency handling procedures for faults, and daily inspection lists. Form a standardized operation and maintenance knowledge base to help the team achieve standardized and efficient operation and maintenance, ensure the long-term stable operation of the database, and solve the full-process pain points of customers in database construction and operation and maintenance in one stop.
Centralized Clearing Business Integrated System
Successfully migrated the centralized clearing business integrated system from Oracle to Halo database without modifying the code, and passed all functional and performance tests.
Real feedback from our customers
"Halo Database completed the migration of our core business system without modifying any application code - unique among domestic databases."
"Performance testing showed Halo outperformed Oracle in multiple scenarios, exceeding our expectations."
"The migration process was very smooth, from assessment to production in a short time, with zero application code changes."
Contact us for professional database migration solutions and technical support