| Version 1 (modified by liaojiaohe, 14 years ago) (diff) |
|---|
场景大概是:需要记录大量用户的操作Action,需要查询用户最新的行为
采用数据库设计有类似的SQL
SELECT id, name, stamp FROM actions WHERE userid = 1 ORDER BY stamp DESC LIMIT 10 OFFSET 20; NSERT INTO actions (id, userid, name, stamp) VALUES (newid(), 1, 'Joe User', epoch());
如果采用HBASE设计,ROW设计为<userid><reverse_order_stamp><actionid>
![(please configure the [header_logo] section in trac.ini)](http://www1.pconline.com.cn/hr/2009/global/images/logo.gif)