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.