Inventor
William J. McKenna
Inventor
Oceanside, CA, US
Overview
Patents· 21 as inventor
Public. Assignee & technology derived from the patent record. Each patent links to its LexDana page.
G06Fprimary
G06FElectric digital data processing48%
Y10STechnical subjects covered by former uspc cross-reference art collections [xracs] and digests23%
G06QInformation and communication technology [ict] specially adapted for administrative, commercial, financial, managerial or supervisory purposes8%
H04HBroadcast communication8%
H04MTelephonic communication8%
H04NPictorial communication, e.g. television8%
PatentTitleYear
10,642,834Pushing joins across a union202010,628,417Physical planning of database queries using partial solutions202010,394,807Rewrite constraints for database queries201910,268,638Limiting plan choice for database queries using plan constraints20199,767,150'System and method for processing database queries'20179,665,619'Optimizing database queries using subquery composition'20179,582,539'Optimizing database queries using reusable subqueries'20179,183,254'Optimizing database queries using subquery composition'20158,510,291'System and method for processing database queries'20138,244,715'System and method for processing database queries'20127,110,999'Maintaining pre-computed aggregate views incrementally in the presence of non-minimal changes'20066,735,587'Maintaining pre-computed aggregate views incrementally in the presence of non-minimal changes'20046,629,094'System and method for rewriting relational database queries'20036,594,653'Server integrated system and methods for processing precomputed views'20036,493,699'Defining and characterizing an analysis space for precomputed views'20026,480,836'System and method for determining and generating candidate views for a database'20026,374,263'System for maintaining precomputed views'20026,199,063'System and method for rewriting relational database queries'20014,816,904'Television and market research data collection system and method'19894,658,290'Television and market research data collection system and method'19874,546,382'Television and market research data collection system and method'1985Career & activity timeline
Assembled from patent assignee/location history and declaration credentials.
1985–1989Based in Barrington, IL, US· patent location history
2001–2006Based in Santa Cruz, CA, US· patent location history
2002–2006Patents assigned to IBM (7)· patent assignee history
2012–2017Patents assigned to PARACCEL INC (4)· patent assignee history
2012–2015Patents assigned to CHEN YIJOU (3)· patent assignee history
2012–2015Patents assigned to COLE RICHARD L (3)· patent assignee history
2012–2020Based in Oceanside, CA, US· patent location history
2015–2020Patents assigned to PARACCEL LLC (4)· patent assignee history
Inventor activity
Assignee and location history derived from the patent record.
Assignees
| Assignee | Patents | Span |
|---|---|---|
| IBM | 7 | 2002–2006 |
| PARACCEL INC | 4 | 2012–2017 |
| PARACCEL LLC | 4 | 2015–2020 |
| CHEN YIJOU | 3 | 2012–2015 |
| COLE RICHARD L | 3 | 2012–2015 |
Locations
| Location | Patents | Span |
|---|---|---|
| Oceanside, California, US | 10 | 2012–2020 |
| Santa Cruz, California, US | 8 | 2001–2006 |
| Barrington, Illinois, US | 3 | 1985–1989 |