Inventor

Sam S. Lightstone

Inventor

Toronto, CA

Overview

1993–2020

Patent span

Physics

Primary field (CPC G)

Patents· 61 as inventor

Public. Assignee & technology derived from the patent record. Each patent links to its LexDana page.

G06Fprimary

G06FElectric digital data processing65%

Y10STechnical subjects covered by former uspc cross-reference art collections [xracs] and digests20%

H04LTransmission of digital information, e.g. telegraphic communication4%

G06QInformation and communication technology [ict] specially adapted for administrative, commercial, financial, managerial or supervisory purposes3%

H03MCoding3%

C12MApparatus for enzymology or microbiology1%

G01NInvestigating or analysing materials by determining their chemical or physical properties1%

G05BControl or regulating systems in general1%

G06NComputing arrangements based on specific computational models1%

PatentTitleYear

10,810,201Technology for join processing2020 10,810,200Technology for join processing2020 10,592,556On-the-fly encoding method for efficient grouping and aggregation2020 10,296,619Multiplication-based method for stitching results of predicate evaluation in column stores2019 10,275,481Updating of in-memory synopsis metadata for inserts in database table2019 10,229,141Parallel load in a column-store database2019 10,042,873Data encoding and processing columnar data2018 10,019,499Adaptive payload management2018 9,946,742Parallel load in a column-store database2018 9,813,502'Data transfers in columnar data systems'2017 9,720,602'Data transfers in columnar data systems'2017 9,674,313'Adaptive payload management'2017 9,535,939'Intra-block partitioning for database management'2017 9,535,940'Intra-block partitioning for database management'2017 9,519,676'Updating of in-memory synopsis metadata for inserts in database table'2016 9,471,710'On-the-fly encoding method for efficient grouping and aggregation'2016 9,405,858'On-the-fly encoding method for efficient grouping and aggregation'2016 9,342,544'Parallel load in a column-store database'2016 9,256,633'Partitioning data for parallel processing'2016 9,244,935'Data encoding and processing columnar data'2016 9,223,820'Partitioning data for parallel processing'2015 9,195,599'Multi-level aggregation techniques for memory hierarchies'2015 9,176,999'Multiplication-based method for stitching results of predicate evaluation in column stores'2015 9,171,043'Dynamically determining join order'2015 9,064,038'Method and system for combining multiple benchmarks'2015 9,037,803'Randomized page weights for optimizing buffer pool page reuse'2015 9,031,826'Method and apparatus for simulating operation in a data processing system'2015 8,880,806'Randomized page weights for optimizing buffer pool page reuse'2014 8,838,598'System and computer program product for automated design of range partitioned tables for relational databases'2014 8,347,289'Method and apparatus for online sample interval determination'2013 8,181,050'Adaptive throttling for data processing systems'2012 8,140,516'Method, system and article of manufacture for improving execution efficiency of a database workload'2012 8,140,490'Method, system and program for prioritizing maintenance of database tables'2012 8,122,450'Method and apparatus for distributing memory in a data processing system'2012 7,917,512'Method for automated design of range partitioned tables for relational databases'2011 7,912,798'System for estimating storage requirements for a multi-dimensional clustering data configuration'2011 7,827,608'Data leak protection system, method and apparatus'2010 7,757,063'Systems for dynamically resizing memory pools'2010 7,739,293'Method, system, and program for collecting statistics of data stored in a database'2010 7,694,102'Systems and methods for self-tuning memory'2010 7,548,903'Method and apparatus for automatic recommendation and selection of clustering indexes'2009 7,502,775'Providing cost model data for tuning of query cache memory in databases'2009 7,499,908'Method for identifying a workload type for a given workload of database requests'2009 7,483,873'Method, system and article of manufacture for improving execution efficiency of a database workload'2009 7,469,329'Methods for dynamically resizing memory pools'2008 7,447,681'Method, system and program for selection of database characteristics'2008 7,440,986'Method for estimating storage requirements for a multi-dimensional clustering data configuration'2008 7,418,441'Data loading from a remote data source record by record'2008 7,401,244'Adaptive throttling system for computing systems'2008 7,363,324'Method, system and program for prioritizing maintenance of database tables'2008 7,346,401'Systems and methods for providing constrained optimization using adaptive regulatory control'2008 7,281,004'Method, system and program for optimizing compression of a workload processed by a database management system'2007 7,243,169'Method, system and program for oscillation control of an internal process of a computer program'2007 7,137,019'Adaptive throttling system for data processing systems'2006 7,080,206'System and method for adaptively loading input data into a multi-dimensional clustering table'2006 7,051,013'Database diagnostic system and method'2006 7,028,022'Heuristic-based conditional data indexing'2006 6,961,835'System and method for autonomically reallocating memory among buffer pools'2005 6,453,314'System and method for selective incremental deferred constraint processing after bulk loading data'2002 6,088,705'Method and apparatus for loading data into a database in a multiprocessor environment'2000 5,206,171'Programmable automated inoculator/replicator'1993

Career & activity timeline

Assembled from patent assignee/location history and declaration credentials.

1993Based in Kingston, CA· patent location history

2000–2020Patents assigned to IBM (60)· patent assignee history

2000Based in North York, CA· patent location history

2002–2020Based in Toronto, CA· patent location history

2008–2018Based in Ontario, CA· patent location history

2012–2015Patents assigned to LIGHTSTONE SAM SAMPSON (6)· patent assignee history

2012–2015Patents assigned to STORM ADAM J (5)· patent assignee history

2012–2017Patents assigned to RAMAN VIJAYSHANKAR (4)· patent assignee history

2014–2017Patents assigned to LIGHTSTONE SAM S (5)· patent assignee history

Inventor activity

Assignee and location history derived from the patent record.

Assignees

Assignee	Patents	Span
IBM	60	2000–2020
LIGHTSTONE SAM SAMPSONself	6	2012–2015
LIGHTSTONE SAM Sself	5	2014–2017
STORM ADAM J	5	2012–2015
RAMAN VIJAYSHANKAR	4	2012–2017

Locations

Location	Patents	Span
Toronto, CA	54	2002–2020
Ontario, CA	5	2008–2018
North York, CA	1	2000
Kingston, CA	1	1993