IP Library Granted Patent US 10,229,149
Granted Patent B2
US 10,229,149 · App. 15/597,555 · Granted Mar 12, 2019

Global filter factor estimation

Inventors: Ke Wei Wei (Beijing, CN); Maryela E. Weihrauch (San Jose, CA); Hao Wu (Beijing, CN); Xin Ying Yang (Beijing, CN); Miao Zheng (Beijing, CN)
Assignee: International Business Machines Corporation
G06F17/30345G06F17/30153G06F17/30469G06F17/30699G06F17/30914
View Patent ↗
Loading inventors, assignments & file history…
Monitor This Case
Get email alerts when status or documents change.
Order Certified Copies
Most orders are placed with the USPTO same day — all within 24 business hours.
Order via The Patent Place →
Pre-filled with this patent's details
Quick Facts
Patent No.
US 10,229,149
App. No.
15/597,555
Granted
Mar 12, 2019
Kind
B2
Abstract

A computer maps a literal in a database query to a digital representation, wherein the database query comprises a predicate, the literal is a part of the predicate, and the digital representation is predetermined based at least in part on external statistical data. The computer estimates a filter factor for the predicate based at least in part on the digital representation and compressed statistical data, wherein the compressed statistical data are prepared at least in part from the external statistical data.

Claims (11)

1. A computer-implemented method for estimation of a filter factor comprising:

mapping a literal in a database query to a digital representation, wherein the database query comprises a predicate, the literal is a part of the predicate, and the digital representation is predetermined based at least in part on external statistical data; and

estimating a filter factor for the predicate based at least in part on the digital representation and compressed statistical data, wherein the compressed statistical data are prepared at least in part from the external statistical data.

2. The method according to claim 1 , wherein the predicate of the database query is related to a column of a table, and the external statistical data contain statistical information relevant to content of the column.

3. The method according to claim 2 , wherein the statistical information relevant to the content of the column comprises information about occurrences of possible literals in a context relevant to the content of the column, and the possible literals comprise the literal in the database query.

4. The method according to claim 3 , wherein the possible literals are assigned with respective digital representations having lengths which are related to the occurrences of the possible literals in the context.

5. The method according to claim 2 , wherein the compressed statistical data comprise statistical information on a scale of lengths of digital representations determined according to content of the column.

6. The method according to claim 2 , further comprising:

updating the compressed statistic data based at least in part on change in at least one of: content of the column, and the external statistical data.

7. The method according to claim 1 , further comprising:

determining an access path for the database query based at least in part on the filter factor.

Assignments (2)
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Jan 15, 2021
From: INTERNATIONAL BUSINESS MACHINES CORPORATION
To: AIRBNB, INC.
Reel/Frame 056427/0193 →
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded May 17, 2017
From: WEI, KE WEI; WEIHRAUCH, MARYELA E.; WU, HAO; YANG, XIN YING; ZHENG, MIAO
To: INTERNATIONAL BUSINESS MACHINES CORPORATION
Reel/Frame 042411/0640 →
Continuity (2)
Continuation 14930736 · Nov 3, 2015
Related Publication 20170249346A1 · Aug 31, 2017