Joy C Hsu, 461100 Maxwell Ln UNIT 605, Uptown, NJ 07030

6640226, Oct 28, 2003

Jun 19, 2001

09/885666

Sanjatha Shringeri - Union City CA
Joy Hsu - Fremont CA

Informatica Corporation - Palo Alto CA

G06F 1730

707 5, 707 4

A method of optimizing ranking queries in analytic applications. The method involves dividing a ranking query constructed by a user into multiple sub-commands. These sub-commands are based on the relationship between the foreign key and ranking attributes of a table of data and are run as a batch of commands. As usable data is extracted from each sub-command, it is stored and the foreign key is used as a filter for the next query in the batch. This eliminates accessing irrelevant data and facilitates the query operation. The extracted data is joined as the last step of the process in order to minimize the number of join operations performed by the query while the batch is being executed, thereby facilitating the query process.

2021030, Sep 30, 2021

Aug 1, 2019

17/263691

- Tokyo, JP
- Little Falls NJ, US
- Osaka, JP
Erica WINTER - New York NY, US
Joy C. HSU - New York NY, US

C07K 16/18
A61K 9/00
A61P 7/06
A61P 37/06

The present invention relates to pharmaceutical compositions for use in the treatment or prevention of a C5-related disease and methods for treating or preventing a C5-related disease. The present invention further relates to dosages and administrations of anti-C5 antibody or pharmaceutical compositions containing the anti-C5 antibody.

2019034, Nov 7, 2019

Sep 28, 2018

16/147067

- Cupertino CA, US
Lee A. Morgan - San Jose CA, US
Elliot C. Liskin - San Jose CA, US
Guillaume Vergnaud - Tokyo, JP
Eric Circlaeys - Los Gatos CA, US
Michael S. Smochko - San Jose CA, US
Joy Hsu - Cypress CA, US
Sabrine Rekik - San Francisco CA, US
Kevin Aujoulet - San Francisco CA, US
Benedikt M. Hirmer - San Francisco CA, US
Kevin Bessiere - Santa Clara CA, US

G06F 17/30
G06F 3/0481

Embodiments of the present disclosure present devices, methods, and computer readable medium for presenting a user interface that allows a user to quickly and easily filter and search a digital asset collection. The disclosed techniques allow for rapid recall of desired digital assets, linking assets into logical collections, and an overall improved user experience. The zero keyword/contextual keyword feature presents multimedia content icons and searchable keywords to allow a user to search the digital asset collection simply by tapping on one of these keywords. The top auto completion feature auto-completes suggestions in the search field based on various heuristics to ensure the method produces diverse and relevant results. The next keyword suggestion feature predicts a next search term based on learned properties about the digital asset collection.