News Updates - DSG Updates
Global leading provider of data management software and unified application development solutions, dedicated to serving enterprise-level large data centers.
A thank you letter, a Sybase multi-database consolidation
发布时间:2023.04.10



Recently, Wangfujing Group Co., Ltd. sent a thank-you letter to DSG, expressing their recognition of the professionalism and dedication shown by the DSG project team members in the group's data collection work.


2

0

2

3

0

3




The letter pointed out that the DSG core technology team has been working diligently to address the challenges of complex system structures, decentralized database deployments, and limited network bandwidth. They have provided on-site, meticulous analysis and targeted technical solutions, as well as a large amount of customized development, and have consistently provided strong technical support services without regard for holidays, ensuring the smooth launch of the data extraction platform and the secure and stable operation of the group's information system.

In response, the customer expressed heartfelt gratitude to the on-site personnel for their hard work!


Wangfujing Group Co., Ltd., referred to as "Wangfujing," is one of the largest retail groups in China and a popular national commercial brand among Chinese consumers. The company was founded in 1955 and was formerly known as the renowned "New China First Store" – Beijing Department Store. Its sales network now covers seven major economic regions in China.

In the past, Wangfujing's related business operations were quite difficult due to low bandwidth issues. Due to environmental factors and data security issues, relevant data had to be retrieved from various stores and brought back to the Beijing headquarters in order to carry out related business operations, which was time-consuming and resource-intensive.

To facilitate business operations in line with Wangfujing's business needs, it was necessary to establish mirror libraries of various stores at the Beijing headquarters as an ODS layer, enabling subsequent business data to be directly applied from the ODS layer, thus eliminating the previous time-consuming and resource-intensive stage and optimizing the overall operational difficulty and timeliness of the business.


The protagonist of this data collection is the Sybase database, a high-performance, highly reliable, and powerful relational database system designed for online transaction processing. It is commonly used in the telecommunications, finance, securities, transportation, energy, and some medium to large enterprises.

For this project, DSG SuperSync for Sybase logical transaction-level synchronization software is deployed on intermediate servers in each store, achieving low-bandwidth, non-stop, non-stop business synchronization of Sybase-MySQL remote full data and real-time incremental data, and centralizing multiple databases into one dataset.


DSG SuperSync is one of the core products of DSG, using a non-interface mode and proprietary database log analysis technology to achieve real-time synchronization between heterogeneous databases, adapting to the complex environments of numerous customers.

As one of the product lines of DSG SuperSync, DSG SuperSync for Sybase logical transaction-level synchronization software has shown its advantages in this data collection process.




Low bandwidth, low latency


DSG SuperSync for Sybase is a logical transaction-level synchronization software that analyzes changes in Sybase transaction logs, generates individual transaction files, and can compress and encrypt files at different levels according to settings, ensuring file transfer speed and security in low-bandwidth situations.



Fully synchronous real-time automatic mode switching integration

DSG SuperSync for Sybase comes with a full synchronization tool that allows for real-time, automatic mode switching and eliminates the need to stop production machines or business operations. This integrated solution reduces the extra workload and time for our customers.



Multiple concurrencies

DSG SuperSync for Sybase provides various technologies such as full-sync concurrent export, full-sync concurrent load, real-time sync concurrent analysis, real-time sync multi-queue concurrent load, and real-time sync single-table concurrent load to improve and optimize the performance of full-sync and real-time synchronization.



High compatibility

DSG SuperSync for Sybase supports synchronization across different operating systems, database versions, and database architecture patterns, providing powerful tool support for client testing environments, database migration, big data applications, and other scenarios.



Comparison of heterogeneous databases

Provide data consistency comparison tool to achieve data comparison from Sybase to MySQL, ensuring the accuracy and consistency of the data. If there are inconsistencies between the source and target records, the inconsistent parts will be automatically repaired.


During the project construction period, the DSG project team worked proactively, responsibly, and with a rapid response, upholding a professional and dedicated work ethic to provide strong technical support services to customers. The core technical colleagues of the project have persisted in updating the project progress daily to ensure the normal operation of the project.

With continuous efforts, there will be gains, and customer approval is ultimately the best manifestation. In the future, DSG will not forget its original intention and will continue to empower various industries with digitalization, leveraging its own controllable advantages and upholding a professional and dedicated service philosophy.

热门动态
警告弹窗