Monday, June 15, 2026
HomeBig DataScaling Actual-Time Gaming Leaderboards with DynamoDB and Rockset

Scaling Actual-Time Gaming Leaderboards with DynamoDB and Rockset

[ad_1]

Social gaming is on the rise. Throughout COVID-19, 29% of customers reported enjoying video games on a weekly foundation and the aim for a lot of gamers was to attach with family and friends (Deloitte: Video games and Streaming Companies Battle it Out Throughout Pandemic from VentureBeat). One of many challenges that gaming corporations face is quickly constructing options that may strengthen community results. Investments in these options will preserve gamers coming again, enabling efficient monetization of video games.

A kind of social options is a gaming leaderboard. A leaderboard offers a scored rating of the gamers within the recreation to encourage wholesome competitors. Players can see their place relative to others within the recreation, motivating them to extend their in-game exercise to compete and advance.

Whereas the idea of the leaderboard is just not new, many gaming corporations have taken leaderboards to the following degree. They supply social sharing and commenting choices to permit customers to brag about their ends in gaming boards. And, new flavors of leaderboards have popped as much as enable for avid gamers to compete with small teams of buddies, geographic areas, superstar avid gamers and extra. These new traits of leaderboards are enhancing the social elements of gaming.

A leaderboard is one instance of real-time analytics in gaming. Gamer information needs to be continually up to date and mirrored in real-time within the leaderboard. And, a leaderboard requires complicated analytics as a number of attributes must be considered to rank avid gamers. Assembly these real-time analytics necessities on the scale of 1000’s to hundreds of thousands of avid gamers is a problem.

On this weblog, we’ll focus on the pace and scale necessities of gaming leaderboards. We’ll then share how Rockset is ready to meet these difficult necessities and devise a brand new information stack for real-time analytics in gaming utilizing Amazon DynamoDB and Rockset.

Necessities for Leaderboards

Leaderboards are computationally intensive, requiring a number of elements of gameplay to be considered when calculating a rating.

Constructing these complicated analytical options are additionally doubly difficult within the gaming business given the variety of avid gamers and the dimensions of knowledge. A preferred recreation can simply appeal to hundreds of thousands of avid gamers worldwide and attain 1-5 TBs of knowledge a day.

Leaderboards and different real-time analytics options in gaming have a singular set of necessities. They should:

  • Scale to hundreds of thousands of avid gamers and 1000’s of concurrent avid gamers
  • Mirror real-time gamer exercise for an correct view of gamer rankings
  • Assist low-latency aggregations and joins to rank avid gamers based mostly on a number of attributes
  • Incorporate new indicators as the sport evolves and standards for rankings shift
  • Guarantee excessive availability

Many methods haven’t been designed to fulfill the difficult necessities of leaderboards. They both lack the speed- the question pace or help for real-time data- or can’t obtain the size required of purposes.

Why Rockset for Leaderboards

Rockset is purpose-built to serve real-time analytics at scale. Rockset makes use of an indexing method to ship millisecond latency complicated analytics to hundreds of thousands of avid gamers.

Indexes are a further information construction that works like a lookup desk on the listed fields, enabling quick information retrieval at question time. FAANG corporations like Google and Fb have employed indexing methods to energy textual content search, newsfeed content material, spam detection, promoting and extra.

Rockset took the identical method of the FAANGs- index all the things. Which means, any semi-structured, geo or time sequence information is ingested and listed in a search index, columnar index and row index for quick queries out-of-the-box. This removes the necessity for tedious, time-consuming index creation and administration. It additionally allows builders to simply incorporate new indicators as the sport or the factors evolve. We predict the flexibleness of indexing all the things is the important thing to releasing new social gaming options quickly.

Rockset meets the difficult necessities for leaderboards with the next core options:

  • One-second information latency: Rockset processes information in real-time and makes new information queryable in lower than a second. Rockset makes use of RocksDB’s LSM timber to cache incoming writes and makes writes seen to current queries as quickly as they occur.
  • Absolutely mutable Converged Index: Mutability is vital to processing continually altering information resembling gamer profile, behaviors and extra and making that accessible for querying.
  • SQL on schemaless information: Rockset delivers search, aggregations and joins on any information with out requiring any information modeling or efficiency tuning. This makes it simple for gaming corporations to investigate information in trendy codecs.
  • Severless service: Rockset is a distributed database that may be scaled with a click on of the button or an API name. This makes it simple for gaming corporations to entry quick analytics whereas staying lean.

DynamoDB + Rockset: The Final Gaming Analytics Stack

We’ve devised the last word gaming analytics stack by pairing Amazon DynamoDB, a number one NoSQL key-value database, with Rockset. This stack allows recreation builders to get the perfect of each worlds: quick writes and heavy reads.

DynamoDB is utilized by main gaming corporations to course of 100s of 1000’s of requests per second. Gaming corporations together with Digital Arts (EA), FanDuel, Riot Video games, Gametime and Pennypop all use DynamoDB to retailer recreation participant information. That’s as a result of DynamoDB is a widely known serverless service that excels at quick writes at excessive scale.

Whereas DynamoDB is a wonderful system for write-heavy workloads, it was not designed to help complicated analytics. That’s why it’s a finest observe to pair DynamoDB with an analytics system like Rockset. As Rockset indexes DynamoDB information, queries and information can simply be added or modified with out impacting the information modeling in DynamoDB. This provides builders higher flexibility to construct new social options and performance.

scaling-real-time-gaming-leaderboards-with-dynamodb-and-rockset-figure-1 Leaderboards information stack utilizing DynamoDB and Rockset.

Rockset has a built-in connector to DynamoDB streams to repeatedly keep in sync with the newest information. As quickly as new information arrives into Rockset it’s listed for serving millisecond-latency search, aggregations and joins. The complete information stack for analytics- DynamoDB and Rockset- is serverless, releasing groups from managing infra ops.

eGoGames, an esports platform for cell gaming, makes use of DynamoDB to retailer all of the grasp information associated to gamers and matches on their platform. They use Rockset to question DynamoDB information inside seconds of updates to optimize the
gamer expertise. eGoGames chosen Rockset for real-time analytics as a result of it allowed them to rise up and working with out spending time on coding or managing methods. And, Rockset might be used for a variety of gaming analytics use instances.

scaling-real-time-gaming-leaderboards-with-dynamodb-and-rockset-figure-2 eGoGames is a number one eSports platform that makes use of Rockset for real-time analytics.

The Way forward for Social Gaming: Actual-Time Analytics

Leaderboards are only one instance of a rising wave of social options in gaming. Gaming corporations are utilizing real-time analytics to enhance the client expertise with matchmaking, enhance engagement with exercise feeds, optimize advert experiences and extra.

These social options have a set of necessities round question latency, complicated analytics, information latency and scale which might be difficult to attain utilizing current information stacks. That’s why Rockset is introducing a brand new information stack for gaming analytics that allows builders to launch new social options quickly.

See for your self how simple it’s to serve leaderboards and different social options utilizing Rockset with a 14-day free trial and $300 in credit.



[ad_2]

RELATED ARTICLES

LEAVE A REPLY

Please enter your comment!
Please enter your name here

Most Popular

Recent Comments