Abstract: Managing categories in an electronic commerce system, includes obtaining transaction information pertaining to a set of back-end categories, the transaction information includes user information of users in the system who completed transactions in the set of back-end categories during a preset period, determining, based on the user information, a set of front-end categories that were selected by users in the system during the preset period, determining number of times a front-end category in the set of front-end categories was selected by the users in the system during the preset period, and adjusting the front-end category according to the transaction information and the number of times the front-end category was selected during the preset period.

Abstract: The present disclosure provides a method and apparatus for accessing large object collection tables in a data warehouse, so that input-output complexities are reduced and the performance and responsiveness of the data warehouse are improved. In one aspect, a process may set up a new large object collection table by determining the object identification information of business activities occurring in a business period using the records in a business flow table. A sub-table from the original large object collection table may be generated based on the derived object identification information. The resulting sub-table may be incorporated into a new large object collection table that is partitioned according to business periods.

Abstract: Managing categories in an electronic commerce system, includes obtaining transaction information pertaining to a set of back-end categories, the transaction information includes user information of users in the system who completed transactions in the set of back-end categories during a preset period, determining, based on the user information, a set of front-end categories that were selected by users in the system during the preset period, determining number of times a front-end category in the set of front-end categories was selected by the users in the system during the preset period, and adjusting the front-end category according to the transaction information and the number of times the front-end category was selected during the preset period.