Invention Grant
- Patent Title: Statistical applications in OLTP environment
- Patent Title (中): OLTP环境中的统计应用
-
Application No.: US13610395Application Date: 2012-09-11
-
Publication No.: US08862539B2Publication Date: 2014-10-14
- Inventor: Lin Zhao
- Applicant: Lin Zhao
- Applicant Address: KY Grand Cayman
- Assignee: Alibaba Group Holding Limited
- Current Assignee: Alibaba Group Holding Limited
- Current Assignee Address: KY Grand Cayman
- Agency: Lee & Hayes, PLLC
- Priority: CN200710188104 20071109
- Main IPC: G06F17/30
- IPC: G06F17/30

Abstract:
The present disclosure provides a method of statistical application in an OLTP environment to reduce the intensive computational load of invoking SQL statements for statistical calculations. The method introduces a time element into statistical records, and use the time element to determine the time status of previously computed statistical records. Upon receiving a query for a statistical record, the system first searches for an existing copy of the statistical record, and checks the time status of the statistical record if found. The system sends the statistical record to the inquirer if the record exists and is unexpired, and invokes an SQL statement to compute the statistical record only if the record does not exist or has expired. The statistical records may be placed in statistical table in a database and/or a cache of an application server. The disclosed strategy may also increase attack resistance of the system.
Public/Granted literature
- US20130006918A1 Statistical Applications in OLTP Environment Public/Granted day:2013-01-03
Information query