Sam (S.S.) Lightstone  Sam (S.S.) Lightstone photo         

contact information

CTO for Data & IBM Fellow, IBM Data and AI
Markham, ON, Canada
  

links



 

 

Patents Issued

Issue  Date

Patent Num.

Issuing Country

69

A MULTIPLICATION-BASED METHOD FOR STITCHING RESULTS OF PREDICATE EVALUATION IN COLUMN STORES

20-5-2019

10296619

United States

68.

UPDATING OF IN-MEMORY SYNOPSIS METADATA FOR INSERTS IN DATABASE TABLE

29-04-2019

10275481

United States

67.

PARALLEL LOAD IN A COLUMN STORE DATABASE

2019-03-12

10,229,141

United States

66.

DATA ENCODING AND PROCESSING COLUMNAR DATA

2018-09-06

10042873

United States

65.

ADAPTIVE PAYLOAD MANAGEMENT

2018-07-09

10019499

United States

64.   

PARALLEL LOAD IN A COLUMN STORE DATABASE

2018-04-09

9,946,742

United States

63.     

DATA ENCODING AND PROCESSING COLUMNAR DATA

2018-03-26

ZL201410264282.6

China

62.    

DATA TRANSFERS IN COLUMNAR DATA SYSTEMS

2017-11-07

9813502

United States

61     

DATA TRANSFERS IN COLUMNAR DATA SYSTEMS

2017-07-31

9720602

United States

60.    

BUFFERING INSERTS INTO A COLUMN STORE DATABASE

 2017-07-03

9697242

United States

59.       

ADAPTIVE PAYLOAD MANAGEMENT

2017-05-06

9674313

United States

58.    

INTRA-BLOCK PARTITIONING FOR DATABASE MANAGEMENT

2017-01-03

9535939

United States

57.  

INTRA-BLOCK PARTITIONING FOR DATABASE MANAGEMENT

2017-01-03

9535940

United States

56.     

UPDATING OF IN-MEMORY SYNOPSIS METADATA FOR INSERTS IN DATABASE TABLES

2016-12-13

9519676

United States

55.     

ON-THE-FLY ENCODING METHOD FOR EFFICIENT GROUPING AND AGGREGATION

2016-10-18

9471710

 

United States

 

54.     

ON-THE-FLY ENCODING METHOD FOR EFFICIENT GROUPING AND AGGREGATION

2016-08-02

9405858

 

United States

53.     

PARALLEL LOAD IN A COLUMN-STORE DATABASE

2016-05-17

9342544

United States

52.     

PARTITIONING DATA FOR PARALLEL PROCESSING                   

2016-02-09

9256633

United States

51.     

DATA ENCODING AND PROCESSING COLUMNAR DATA                               

2016-01-26

9244935

United States

50.     

PARTITIONING DATA FOR PARALLEL PROCESSING                   

2015-12-29

9223820

United States

49.     

A MULTIPLICATION-BASED METHOD FOR STITCHING RESULTS OF PREDICATE EVALUATION IN COLUMN STORES            

2015-11-03                  

9176999

United States

48.     

DYNAMICALLY DETERMINING JOIN ORDER              

2015-10-27

9171043

United States

47.     

METHOD AND SYSTEM FOR COMBINING MULTIPLE BENCHMARKS

2015-06-23

9064038

United States

46.     

RANDOMIZED PAGE WEIGHTS FOR OPTIMIZING BUFFER POOL PAGE REUSE                                                      

2015-05-19

9037803

United States

45.     

METHOD AND APPARATUS FOR SIMULATING OPERATION IN A DATA PROCESSING SYSTEM                                                    

2015-05-12

9031826

United States

44.     

Randomized page weights for optimizing buffer pool page reuse

2014-11-04

8,880,806

United States

43.     

System and computer program product for automated design of range partitioned tables for relational databases

2014-09-16

8,838,598

United States

42.     

METHOD AND APPARATUS FOR ONLINE SAMPLE INTERVAL DETERMINATION

2013-01-01

8347289

United States

41.     

ADAPTIVE THROTTLING FOR DATA PROCESSING SYSTEMS 

2012-05-15

8181050

United States

40.     

METHOD, SYSTEM AND PROGRAM FOR PRIORITIZING MAINTENANCE OF DATABASE TABLES

2012-03-20

8140490

United States

39.     

METHOD, SYSTEM AND ARTICLE OF MANUFACTURE FOR IMPROVING EXECUTION EFFICIENCY OF A DATABASE WORKLOAD

2012-03-20

8140516

United States

38.     

METHOD AND APPARATUS FOR DISTRIBUTING MEMORY IN A DATA PROCESSING SYSTEM

2012-02-21

8122450

United States

37.     

METHOD FOR AUTOMATED DESIGN OF RANGE PARTITIONED TABLES FOR RELATIONAL DATABASES

2011-03-29

7917512

United States

36.     

SYSTEM FOR ESTIMATING STORAGE REQUIREMENTS FOR A MULTI-DIMENSIONAL CLUSTERING DATA CONFIGURATION

2011-03-22

7912798

United States

35.     

DATA LOADING FROM A REMOTE DATA SOURCE

2010-11-09

2441960

Canada

34.     

DATA LEAK PROTECTION SYSTEM, METHOD AND APPARATUS

2010-11-02

7827608

United States

33.     

SYSTEMS FOR DYNAMICALLY RESIZING MEMORY POOLS

2010-07-13

7757063

United States

32.     

METHOD, SYSTEM, AND PROGRAM FOR COLLECTING STATISTICS OF DATA STORED IN A DATABASE

2010-06-15

7739293

United States

31.     

SYSTEMS AND METHODS FOR SELF -TUNING MEMORY

2010-04-06

7694102

United States

30.     

AUTONOMIC REALLOCATION OF MEMORY AMONG BUFFER POOLS

2009-10-06

2408481

Canada

29.     

METHOD AND APPARATUS FOR AUTOMATIC RECOMMENDATION AND SELECTION OF CLUSTERING INDEXES

2009-06-16

7548903

United States

28.     

PROVIDING COST MODEL DATA FOR TUNING OF QUERY CACHE MEMORY IN DATABASES

2009-03-10

7502775

United States

27.     

METHOD FOR IDENTIFYING A WORKLOAD TYPE FOR A GIVEN WORKLOAD OF DATABASE REQUESTS

2009-03-03

7499908

United States

26.     

METHOD, SYSTEM AND ARTICLE OF MANUFACTURE FOR IMPROVING EXECUTION EFFICIENCY OF A DATABASE WORKLOAD

2009-01-27

7483873

United States

25.     

METHODS FOR DYNAMICALLY RESIZING MEMORY POOLS

2008-12-23

7469329

United States

24.     

METHOD, SYSTEM AND PROGRAM FOR SELECTION OF DATABASE CHARACTERISTICS

2008-11-04

7447681

United States

23.     

METHOD FOR ESTIMATING STORAGE REQUIREMENTS FOR A MULTI-DIMENSIONAL CLUSTERING DATA CONFIGURATION

2008-10-21

7440986

United States

22.     

DATA LOADING FROM A REMOTE DATA SOURCE RECORD BY RECORD

2008-08-26

7418441

United States

21.     

ADAPTIVE THROTTLING SYSTEM FOR COMPUTING SYSTEMS

2008-07-15

7401244

United States

20.     

METHOD, SYSTEM AND PROGRAM FOR PRIORITIZING MAINTENANCE OF DATABASE TABLES

2008-04-22

7363324

United States

19.     

SYSTEMS AND METHODS FOR PROVIDING CONSTRAINED OPTIMIZATION USING ADAPTIVE REGULATORY CONTROL

2008-03-18

7346401

United States

18.     

METHOD FOR ESTIMATING STORAGE REQUIREMENTS FOR A MULTI-DIMENSIONAL CLUSTERING DATA CONFIGURATION

2007-11-06

2453608

Canada

17.     

METHOD, SYSTEM AND PROGRAM FOR OPTIMIZING COMPRESSION OF A WORKLOAD PROCESSED BY A DATABASE MANAGEMENT SYSTEM

2007-10-09

7281004

United States

16.     

METHOD, SYSTEM AND PROGRAM FOR OSCILLATION CONTROL OF AN INTERNAL PROCESS OF A COMPUTER PROGRAM

2007-07-10

7243169

United States

15.     

ADAPTIVE THROTTLING SYSTEM FOR DATA PROCESSING SYSTEMS

2006-11-14

7137019

United States

14.     

DATA LOADING FROM A REMOTE DATA SOURCE

2006-09-27

ZL 02805708.2

China

13.     

ADAPTIVE PARALLEL DATA CLUSTERING WHEN LODADING A DATA STRUCTURE CONTAINING DATA CLUSTER ALONG ONE OR MORE DIMENSIONS

2006-09-19

2415018

Canada

12.     

SYSTEM AND METHOD FOR ADAPTIVELY LOADING INPUT DATA INTO A MULTI-DIMENSIONAL CLUSTERING TABLE

2006-07-18

7080206

United States

11.     

DATABASE DIAGNOSTIC SYSTEM AND METHOD

2006-05-23

7051013

United States

10.    

HEURISTIC-BASED CONDITIONAL DATA INDEXING

2006-04-11

7028022

United States

9.     

METHOD FOR RECOMMENDING INDEXES AND MATERIALIZED VIEWS FOR A DATABASE WORKLOAD

2006-02-28

7007006

United States

8.     

SYSTEM AND METHOD FOR AUTONOMICALLY REALLOCATING MEMORY AMONG BUFFER POOLS

2005-11-01

6961835

United States

7.     

HEURISTIC-BASED CONDITIONAL DATA INDEXING

2004-10-19

2279119

Canada

6.     

DATA LOADING FROM A REMOTE DATA SOURCE

2004-09-27

202975

Taiwan

5.     

SYSTEM AND METHOD FOR SELECTIVE INCREMENTAL DEFERRED CONSTRAINT PROCESSING AFTER BULK LOADING DATA

2002-09-17

6453314

United States

4.     

METHOD AND APPARATUS FOR LOADING DATA INTO A DATABASE IN A MULTIPROCESSOR ENVIRONMENT

2000-07-11

6088705

United States

3.     

METHOD AND APPARATUS FOR LOADING DATA INTO A DATABASE IN A MULTIPROCESSOR ENVIRONMENT

2000-05-02

2209549

Canada

2.     

PROGRAMMABLE AUTOMATED INOCULATOR/REPLICATOR

1995-10-31

2098585

Canada

1.  

PROGRAMMABLE AUTOMATED INOCULATOR/REPLICATOR

1993-04-27

5206171

United States