Help Center> CloudTable Service> Developer Guide> Developing HBase Applications> Typical Application Scenario
View PDF

Typical Application Scenario

You can quickly learn and master the HBase development process and know key interface functions in a typical application scenario.

Description

Develop an application to manage information about users who use service A in an enterprise. Table 1 provides the user information. Procedures are as follows:

  • Create a user information table.
  • Add users' educational backgrounds and titles to the table.
  • Query user names and addresses by user ID.
  • Query information by user name.
  • Query information about users whose age ranges from 20 to 29.
  • Collect the number of users and their maximum, minimum, and average age.
  • Deregister users and delete user data from the user information table.
  • Delete the user information table after service A ends.
    Table 1 User information

    ID

    Name

    Gender

    Age

    Address

    12005000201

    A

    Male

    19

    Shenzhen, Guangdong

    12005000202

    B

    Female

    23

    Shijiazhuang, Hebei

    12005000203

    C

    Male

    26

    Ningbo, Zhejiang

    12005000204

    D

    Male

    18

    Xiangyang, Hubei

    12005000205

    E

    Female

    21

    Shangrao, Jiangxi

    12005000206

    F

    Male

    32

    Zhuzhou, Hunan

    12005000207

    G

    Female

    29

    Nanyang, Henan

    12005000208

    H

    Female

    30

    Kaixian, Chongqing

    12005000209

    I

    Male

    26

    Weinan, Shaanxi

    12005000210

    J

    Male

    25

    Dalian, Liaoning

Data Planning

Proper design of a table structure, RowKeys, and column names enable you to make full use of HBase advantages. In the sample project, a unique ID is used as a RowKey, and columns are stored in the info column family.