International Business Machines Corporation

Beijing Jindong Zhenshi Information Technology Co., Ltd.

Zhongliang Zhang

Xiaobo Wang

Hong Min

Chao Wang

Terence Patrick Purcell

Yefim Shuf

Dongsheng Chen

Wankui Ju

Zhenlong Qu

Ru Wang

Jianmin Yang

Xiaonan Yan

The present invention relates to the technical field of computers. Disclosed are a mailing method and a mailing apparatus. An embodiment of the method comprises: in response to a mailing request from a user, sending an open instruction to an intelligent mailing cabinet, controlling an article placement region of the intelligent mailing cabinet to open, and acquiring article information of an article to be mailed already placed inside the article placement region; generating recommended service information according to the acquired article information, and sending the recommended service information to the intelligent mailing cabinet, such that the intelligent mailing cabinet displays the recommended service information; and in response to the user making an adjustment to the recommended service information, determining mailing service information corresponding to the article, and controlling the intelligent mailing cabinet to perform a mailing operation with respect to the article according to the mailing service information.

Mailing method and mailing apparatus

Techniques for generating a set of one or more materialized query table (MQT) candidates for a workload are provided. The techniques include receiving a workload, wherein the workload comprises a set of one or more queries, generating one or more best matching MQTs (BMQTs) based on one or more query blocks of the one or more queries by removing syntax that is not qualified for a MQT re-write, determining one or more frequently used multi-joins in the workload, using the one or more BMQTs and the one or more frequently used multi-joins to generate a set of one or more workload MQTs (WMQTs), and grouping one or more WMQTs and one or more BMQTs into one or more groups to merge into a set of a smaller number of MQTs and to cover the workload.

Generating materialized query table candidates

Growing community of inventors

Beijing, China

Zhongliang Zhang