Asia’s E-Commerce Giant Dangdang Increases Order Processing Speed by 30% — Saves Over Ten Million in Technology Budget with Apache ShardingSphere

Business Challenges

  • Limited computing and storage capabilities
  • Expensive development and maintenance cost
  • Exclusiveness

The Solution

  • Compatible with JDBC and any JDBC-based ORM framework such as JPA, Hibernate, Mybatis, Spring JDBC Template.
  • Supports all third-party database connection pools such as DBCP, C3P0, BoneCP, HikariCP, etc.
  • Supports all databases implementing JDBC standards. Currently, ShardingSphere-JDBC supports MySQL, PostgreSQL, Oracle, SQL Server, and any database that can be accessed via JDBC.
The ShardingSphere-JDBC Topography
  • Basic: stores user, area, and menu data.
  • Business: stores order and package data.
  • Inventory: stores stock and working data.
Topography of Dangdang’s Warehouse Management System (of a Single Warehouse)

User Advantages

  • Extraordinary performance
  • Keep the system stable
  • Low risk & zero invasion
  • Allow developers to focus on the business side
  • Cost effective and efficient
  • In 2014, Dangdang introduced a centralized development framework targeting at its e-commerce platform called dd-frame. It was created to unify the development framework, standardize its technical components, and achieve efficient cross-team communication by separating business code from technical code. In this way, engineers can devote all their efforts to the business side. The relational database module named dd-rdb in the framework was developed to handle data access and implement the data sharding function. It was the precursor of Sharding-JDBC, as well as a major part of dd-frame 2.x.
  • In 2015, Dangdang decided to rebuild its WMS and TMS. As it needed a data sharding plan, the team launched the project in September. In December, 2015, Sharding-JDBC 1.0.0 was released and used within Dangdang.
  • In early 2016, Sharding-JDBC was separated from dd-rdb and became open source. The product is an enhanced JDBC driver providing service in .jar files.
  • At the end of 2017, Version 2.0.0 was released with the new data governance function.
  • In 2018, ShardingSphere was enrolled into Apache Incubator. The release of Version 3.0.0 was a notable turnaround: Sharding-Proxy was released as an independent service. It supported heterogeneous languages, and the project was renamed from Sharding-JDBC to ShardingSphere. It’s in 2018 that the community decided to build the criteria and ecosystem above databases.
  • In 2019, Version 4.0.0 was released capable of supporting more database products.
  • In 2020, ShardingSphere graduated as a Top-Level Project of the ASF.
  • On November 10, 2021, Version 5.0.0 GA was released as a third-anniversity celebration with the whole Apache ShardingSphere community, and the distributed database industry.
Apache ShardingSphere—Roadmap

Conclusion

Apache ShardingSphere Open Source Project Links:

 by the author.

--

--

--

Transform any DBMS in a distributed database system & enhance it with sharding, elastic scaling features & more. https://linktr.ee/ApacheShardingSphere

Love podcasts or audiobooks? Learn on the go with our new app.

Recommended from Medium

CleverTap Push Notification APNs Bad Device Token

Introduction to Cloud Computing

Firebase: Cloud Firestore Data Types, Costs, & Query Examples

How to Improve Readability in Your Daily Code

Create a Custom CLI Tool and Distribute with HomeBrew Using Goreleaser and Github Actions

The new darling of Tech firms — Working from home

How To Do Project Estimates — Tentamen Software Testing Blog

Master the User Authentication in Django — AllAuth

A user facing three screens indicating authentication and authorization layers

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Apache ShardingSphere

Apache ShardingSphere

Transform any DBMS in a distributed database system & enhance it with sharding, elastic scaling features & more. https://linktr.ee/ApacheShardingSphere

More from Medium

RepliByte — synchronize your cloud databases and obfuscate sensitive data

Outgrowing Postgres? Keep using Postgres!

Getting Started with Apache Iceberg Tables Using AWS Glue Custom Connector

Introducing Credmark’s Senior Data Engineer