Tair (Redis® OSS-Compatible):Implement multidimensional leaderboards using exZset

Prerequisites

Before you begin, ensure that you have:

• A Tair instance endpoint, port, and password

• TairJedis SDK added to your project

Add the TairJedis dependency

Add the following to pom.xml:

<dependency>
    <groupId>com.aliyun.tair</groupId>
    <artifactId>alibabacloud-tairjedis-sdk</artifactId>
    <version>5.3.1</version>
</dependency>

Insert and query leaderboard data

The following example uses the LeaderBoard class from the TairJedis SDK. The constructor takes the key name, connection pool, page size, and sort options.

import io.valkey.JedisPool;
import io.valkey.JedisPoolConfig;
import com.aliyun.tair.tairzset.LeaderBoard;

public class LeaderBoardExample {
    // Replace with your instance endpoint and credentials.
    private static final int DEFAULT_CONNECTION_TIMEOUT = 5000;
    private static final int DEFAULT_SO_TIMEOUT = 2000;
    private static final String HOST = "<r-bp1mx0ydsivrbp****.redis.rds.aliyuncs.com>";
    private static final int PORT = 6379;
    private static final String PASSWORD = "<Pass****word>";
    private static final JedisPoolConfig config = new JedisPoolConfig();

    public static void main(String[] args) {
        JedisPool jedisPool = new JedisPool(config, HOST, PORT, DEFAULT_CONNECTION_TIMEOUT,
                DEFAULT_SO_TIMEOUT, PASSWORD, 0, null);

        // Create a leaderboard named "leaderboard".
        LeaderBoard lb = new LeaderBoard("leaderboard", jedisPool, 10, true, false);

        // Add members with three-dimensional scores: gold, silver, bronze.
        lb.addMember("A",  32, 21, 16);
        lb.addMember("B",  25, 29, 21);
        lb.addMember("C",  20,  7, 12);
        lb.addMember("D",  14,  4, 16);
        lb.addMember("E",  13, 21, 18);
        lb.addMember("F",  13, 17, 14);

        // Get the rank of A (1-indexed).
        System.out.println(lb.rankFor("A"));
        // 1

        // Get the top 3.
        System.out.println(lb.top(3));
        // [{"member":"A","score":"32#21#16","rank":1},
        //  {"member":"B","score":"25#29#21","rank":2},
        //  {"member":"C","score":"20#7#12","rank":3}]

        // Get the full leaderboard.
        System.out.println(lb.allLeaders());
        // [{"member":"A","score":"32#21#16","rank":1},
        //  {"member":"B","score":"25#29#21","rank":2},
        //  {"member":"C","score":"20#7#12","rank":3},
        //  {"member":"D","score":"14#4#16","rank":4},
        //  {"member":"E","score":"13#21#18","rank":5},
        //  {"member":"F","score":"13#17#14","rank":6}]
    }
}

For all available LeaderBoard methods, see the alibabacloud-tairjedis-sdk Javadoc under com.aliyun.tair.tairzset.LeaderBoard.

Key and score design

Store all data for a month in one key (for example, julyZset). Each entry encodes time in six dimensions:

score format:  month#week#day#hour#minute#points
member format: month#week#day#hour#minute_username

The time prefix in the member name links each entry to a specific minute. Because exZset compares dimensions left to right, setting the lower dimensions to 0 in EXZREVRANGEBYSCORE creates an inclusive lower bound for any time granularity — the leftmost dimensions act as the primary filter.

Insert data with EXZINCRBY

Use EXZINCRBY to add or increment a member's score atomically — no read-modify-write cycle required.

EXZINCRBY julyZset 7#2#6#16#22#100 7#2#6#16#22_user1
EXZINCRBY julyZset 7#2#6#16#22#50  7#2#6#16#22_user2
EXZINCRBY julyZset 7#2#6#16#23#70  7#2#6#16#23_user1
EXZINCRBY julyZset 7#2#6#16#23#80  7#2#6#16#23_user1

Query leaderboards by time window

All range queries use EXZREVRANGEBYSCORE with score bounds matched to the desired time window.