
Annan Q. Shang
Examiner (ID: 5591, Phone: (571)272-7355 , Office: P/2424 )
| Most Active Art Unit | 2424 |
| Art Unit(s) | 2424, 2614, 2623, 2617 |
| Total Applications | 1106 |
| Issued Applications | 711 |
| Pending Applications | 97 |
| Abandoned Applications | 314 |
Applications
| Application number | Title of the application | Filing Date | Status |
|---|---|---|---|
Array
(
[id] => 18982044
[patent_doc_number] => 11907217
[patent_country] => US
[patent_kind] => B2
[patent_issue_date] => 2024-02-20
[patent_title] => Database object validation for reusing captured query plans
[patent_app_type] => utility
[patent_app_number] => 17/826007
[patent_app_country] => US
[patent_app_date] => 2022-05-26
[patent_effective_date] => 0000-00-00
[patent_drawing_sheets_cnt] => 9
[patent_figures_cnt] => 9
[patent_no_of_words] => 14465
[patent_no_of_claims] => 20
[patent_no_of_ind_claims] => 3
[patent_words_short_claim] => 236
[patent_maintenance] => 1
[patent_no_of_assignments] => 0
[patent_current_assignee] =>[type] => patent
[pdf_file] =>[firstpage_image] =>[orig_patent_app_number] => 17826007
[rel_patent_id] =>[rel_patent_doc_number] =>) 17/826007 | Database object validation for reusing captured query plans | May 25, 2022 | Issued |
Array
(
[id] => 19321243
[patent_doc_number] => 20240242789
[patent_country] => US
[patent_kind] => A1
[patent_issue_date] => 2024-07-18
[patent_title] => ARTIFICIAL INTELLIGENCE MATERIALS ASSISTANT
[patent_app_type] => utility
[patent_app_number] => 18/562080
[patent_app_country] => US
[patent_app_date] => 2022-05-24
[patent_effective_date] => 0000-00-00
[patent_drawing_sheets_cnt] => 0
[patent_figures_cnt] => 0
[patent_no_of_words] => 3701
[patent_no_of_claims] => 0
[patent_no_of_ind_claims] => -8
[patent_words_short_claim] => 130
[patent_maintenance] => 1
[patent_no_of_assignments] => 0
[patent_current_assignee] =>[type] => publication
[pdf_file] =>[firstpage_image] =>[orig_patent_app_number] => 18562080
[rel_patent_id] =>[rel_patent_doc_number] =>) 18/562080 | ARTIFICIAL INTELLIGENCE MATERIALS ASSISTANT | May 23, 2022 | Abandoned |
Array
(
[id] => 18756152
[patent_doc_number] => 20230359597
[patent_country] => US
[patent_kind] => A1
[patent_issue_date] => 2023-11-09
[patent_title] => SYSTEM AND METHOD FOR REDUCING DATA INCONSISTENCY AFTER PURGING CLIENT RECORDS, IN FINANCIAL INSTITUTE (FI) DATABASES, WHEN EXCEEDING RETENTION PERIOD
[patent_app_type] => utility
[patent_app_number] => 17/735137
[patent_app_country] => US
[patent_app_date] => 2022-05-03
[patent_effective_date] => 0000-00-00
[patent_drawing_sheets_cnt] => 0
[patent_figures_cnt] => 0
[patent_no_of_words] => 4476
[patent_no_of_claims] => 0
[patent_no_of_ind_claims] => -10
[patent_words_short_claim] => 165
[patent_maintenance] => 1
[patent_no_of_assignments] => 0
[patent_current_assignee] =>[type] => publication
[pdf_file] =>[firstpage_image] =>[orig_patent_app_number] => 17735137
[rel_patent_id] =>[rel_patent_doc_number] =>) 17/735137 | SYSTEM AND METHOD FOR REDUCING DATA INCONSISTENCY AFTER PURGING CLIENT RECORDS, IN FINANCIAL INSTITUTE (FI) DATABASES, WHEN EXCEEDING RETENTION PERIOD | May 2, 2022 | Abandoned |
Array
(
[id] => 18111871
[patent_doc_number] => 20230004751
[patent_country] => US
[patent_kind] => A1
[patent_issue_date] => 2023-01-05
[patent_title] => Clustering Method and Apparatus for Spatial Points, and Electronic Device
[patent_app_type] => utility
[patent_app_number] => 17/729326
[patent_app_country] => US
[patent_app_date] => 2022-04-26
[patent_effective_date] => 0000-00-00
[patent_drawing_sheets_cnt] => 0
[patent_figures_cnt] => 0
[patent_no_of_words] => 7910
[patent_no_of_claims] => 0
[patent_no_of_ind_claims] => -17
[patent_words_short_claim] => 84
[patent_maintenance] => 1
[patent_no_of_assignments] => 0
[patent_current_assignee] =>[type] => publication
[pdf_file] =>[firstpage_image] =>[orig_patent_app_number] => 17729326
[rel_patent_id] =>[rel_patent_doc_number] =>) 17/729326 | Clustering Method and Apparatus for Spatial Points, and Electronic Device | Apr 25, 2022 | Abandoned |
Array
(
[id] => 17763550
[patent_doc_number] => 20220237162
[patent_country] => US
[patent_kind] => A1
[patent_issue_date] => 2022-07-28
[patent_title] => SYSTEM AND METHOD FOR CARDINALITY ESTIMATION FEEDBACK LOOPS IN QUERY PROCESSING
[patent_app_type] => utility
[patent_app_number] => 17/724087
[patent_app_country] => US
[patent_app_date] => 2022-04-19
[patent_effective_date] => 0000-00-00
[patent_drawing_sheets_cnt] => 0
[patent_figures_cnt] => 0
[patent_no_of_words] => 13345
[patent_no_of_claims] => 0
[patent_no_of_ind_claims] => -17
[patent_words_short_claim] => 146
[patent_maintenance] => 1
[patent_no_of_assignments] => 0
[patent_current_assignee] =>[type] => publication
[pdf_file] =>[firstpage_image] =>[orig_patent_app_number] => 17724087
[rel_patent_id] =>[rel_patent_doc_number] =>) 17/724087 | SYSTEM AND METHOD FOR CARDINALITY ESTIMATION FEEDBACK LOOPS IN QUERY PROCESSING | Apr 18, 2022 | Abandoned |
Array
(
[id] => 19566345
[patent_doc_number] => 12141116
[patent_country] => US
[patent_kind] => B2
[patent_issue_date] => 2024-11-12
[patent_title] => Systems and methods for SNP analysis and genome sequencing
[patent_app_type] => utility
[patent_app_number] => 17/723053
[patent_app_country] => US
[patent_app_date] => 2022-04-18
[patent_effective_date] => 0000-00-00
[patent_drawing_sheets_cnt] => 6
[patent_figures_cnt] => 6
[patent_no_of_words] => 9839
[patent_no_of_claims] => 8
[patent_no_of_ind_claims] => 1
[patent_words_short_claim] => 366
[patent_maintenance] => 1
[patent_no_of_assignments] => 0
[patent_current_assignee] =>[type] => patent
[pdf_file] =>[firstpage_image] =>[orig_patent_app_number] => 17723053
[rel_patent_id] =>[rel_patent_doc_number] =>) 17/723053 | Systems and methods for SNP analysis and genome sequencing | Apr 17, 2022 | Issued |
Array
(
[id] => 19645115
[patent_doc_number] => 20240419635
[patent_country] => US
[patent_kind] => A1
[patent_issue_date] => 2024-12-19
[patent_title] => RECORDING MEDIUM, ASSET MANAGEMENT DEVICE, LEARNING DEVICE, ASSET MANAGEMENT SYSTEM, AND ASSET MANAGEMENT METHOD
[patent_app_type] => utility
[patent_app_number] => 18/721906
[patent_app_country] => US
[patent_app_date] => 2022-04-15
[patent_effective_date] => 0000-00-00
[patent_drawing_sheets_cnt] => 0
[patent_figures_cnt] => 0
[patent_no_of_words] => 9656
[patent_no_of_claims] => 0
[patent_no_of_ind_claims] => -8
[patent_words_short_claim] => 86
[patent_maintenance] => 1
[patent_no_of_assignments] => 0
[patent_current_assignee] =>[type] => publication
[pdf_file] =>[firstpage_image] =>[orig_patent_app_number] => 18721906
[rel_patent_id] =>[rel_patent_doc_number] =>) 18/721906 | Recording medium, asset management device, learning device, asset management system, and asset management method | Apr 14, 2022 | Issued |
Array
(
[id] => 19078161
[patent_doc_number] => 11947526
[patent_country] => US
[patent_kind] => B2
[patent_issue_date] => 2024-04-02
[patent_title] => System, method, and apparatus for generating analytics with structured query files
[patent_app_type] => utility
[patent_app_number] => 17/713328
[patent_app_country] => US
[patent_app_date] => 2022-04-05
[patent_effective_date] => 0000-00-00
[patent_drawing_sheets_cnt] => 3
[patent_figures_cnt] => 4
[patent_no_of_words] => 7329
[patent_no_of_claims] => 20
[patent_no_of_ind_claims] => 3
[patent_words_short_claim] => 226
[patent_maintenance] => 1
[patent_no_of_assignments] => 0
[patent_current_assignee] =>[type] => patent
[pdf_file] =>[firstpage_image] =>[orig_patent_app_number] => 17713328
[rel_patent_id] =>[rel_patent_doc_number] =>) 17/713328 | System, method, and apparatus for generating analytics with structured query files | Apr 4, 2022 | Issued |
Array
(
[id] => 17739490
[patent_doc_number] => 20220224952
[patent_country] => US
[patent_kind] => A1
[patent_issue_date] => 2022-07-14
[patent_title] => SYSTEM AND METHOD FOR CONTINUOUS MEDIA SEGMENT IDENTIFICATION
[patent_app_type] => utility
[patent_app_number] => 17/585950
[patent_app_country] => US
[patent_app_date] => 2022-01-27
[patent_effective_date] => 0000-00-00
[patent_drawing_sheets_cnt] => 0
[patent_figures_cnt] => 0
[patent_no_of_words] => 18687
[patent_no_of_claims] => 0
[patent_no_of_ind_claims] => -17
[patent_words_short_claim] => 2
[patent_maintenance] => 1
[patent_no_of_assignments] => 0
[patent_current_assignee] =>[type] => publication
[pdf_file] =>[firstpage_image] =>[orig_patent_app_number] => 17585950
[rel_patent_id] =>[rel_patent_doc_number] =>) 17/585950 | System and method for continuous media segment identification | Jan 26, 2022 | Issued |
Array
(
[id] => 18513429
[patent_doc_number] => 20230229659
[patent_country] => US
[patent_kind] => A1
[patent_issue_date] => 2023-07-20
[patent_title] => ESTIMATING QUERY EXECUTION PERFORMANCE USING A SAMPLED COUNTER
[patent_app_type] => utility
[patent_app_number] => 17/580071
[patent_app_country] => US
[patent_app_date] => 2022-01-20
[patent_effective_date] => 0000-00-00
[patent_drawing_sheets_cnt] => 0
[patent_figures_cnt] => 0
[patent_no_of_words] => 10081
[patent_no_of_claims] => 0
[patent_no_of_ind_claims] => -17
[patent_words_short_claim] => 120
[patent_maintenance] => 1
[patent_no_of_assignments] => 0
[patent_current_assignee] =>[type] => publication
[pdf_file] =>[firstpage_image] =>[orig_patent_app_number] => 17580071
[rel_patent_id] =>[rel_patent_doc_number] =>) 17/580071 | Estimating query execution performance using a sampled counter | Jan 19, 2022 | Issued |
Array
(
[id] => 20415842
[patent_doc_number] => 12499128
[patent_country] => US
[patent_kind] => B2
[patent_issue_date] => 2025-12-16
[patent_title] => System and method for in-place data writes to reduce fragmentation in a multidimensional database environment
[patent_app_type] => utility
[patent_app_number] => 17/553577
[patent_app_country] => US
[patent_app_date] => 2021-12-16
[patent_effective_date] => 0000-00-00
[patent_drawing_sheets_cnt] => 6
[patent_figures_cnt] => 6
[patent_no_of_words] => 0
[patent_no_of_claims] => 19
[patent_no_of_ind_claims] => 3
[patent_words_short_claim] => 424
[patent_maintenance] => 1
[patent_no_of_assignments] => 0
[patent_current_assignee] =>[type] => patent
[pdf_file] =>[firstpage_image] =>[orig_patent_app_number] => 17553577
[rel_patent_id] =>[rel_patent_doc_number] =>) 17/553577 | System and method for in-place data writes to reduce fragmentation in a multidimensional database environment | Dec 15, 2021 | Issued |
Array
(
[id] => 18668617
[patent_doc_number] => 11775520
[patent_country] => US
[patent_kind] => B2
[patent_issue_date] => 2023-10-03
[patent_title] => Updating of a denormalized database object after updating, deleting, or inserting a record in a source database object
[patent_app_type] => utility
[patent_app_number] => 17/534425
[patent_app_country] => US
[patent_app_date] => 2021-11-23
[patent_effective_date] => 0000-00-00
[patent_drawing_sheets_cnt] => 8
[patent_figures_cnt] => 9
[patent_no_of_words] => 12271
[patent_no_of_claims] => 23
[patent_no_of_ind_claims] => 4
[patent_words_short_claim] => 210
[patent_maintenance] => 1
[patent_no_of_assignments] => 0
[patent_current_assignee] =>[type] => patent
[pdf_file] =>[firstpage_image] =>[orig_patent_app_number] => 17534425
[rel_patent_id] =>[rel_patent_doc_number] =>) 17/534425 | Updating of a denormalized database object after updating, deleting, or inserting a record in a source database object | Nov 22, 2021 | Issued |
Array
(
[id] => 17415939
[patent_doc_number] => 20220050843
[patent_country] => US
[patent_kind] => A1
[patent_issue_date] => 2022-02-17
[patent_title] => LEARNING-BASED QUERY PLAN CACHE FOR CAPTURING LOW-COST QUERY PLAN
[patent_app_type] => utility
[patent_app_number] => 17/452948
[patent_app_country] => US
[patent_app_date] => 2021-10-29
[patent_effective_date] => 0000-00-00
[patent_drawing_sheets_cnt] => 0
[patent_figures_cnt] => 0
[patent_no_of_words] => 13652
[patent_no_of_claims] => 0
[patent_no_of_ind_claims] => -19
[patent_words_short_claim] => 68
[patent_maintenance] => 1
[patent_no_of_assignments] => 0
[patent_current_assignee] =>[type] => publication
[pdf_file] =>[firstpage_image] =>[orig_patent_app_number] => 17452948
[rel_patent_id] =>[rel_patent_doc_number] =>) 17/452948 | LEARNING-BASED QUERY PLAN CACHE FOR CAPTURING LOW-COST QUERY PLAN | Oct 28, 2021 | Pending |
Array
(
[id] => 20123435
[patent_doc_number] => 20250238466
[patent_country] => US
[patent_kind] => A1
[patent_issue_date] => 2025-07-24
[patent_title] => GENERATING KNOWLEDGE BASE QUERIES AND OBTAINING ANSWERS TO KNOWLEDGE BASE QUERIES
[patent_app_type] => utility
[patent_app_number] => 18/705126
[patent_app_country] => US
[patent_app_date] => 2021-10-28
[patent_effective_date] => 0000-00-00
[patent_drawing_sheets_cnt] => 0
[patent_figures_cnt] => 0
[patent_no_of_words] => 3259
[patent_no_of_claims] => 0
[patent_no_of_ind_claims] => -18
[patent_words_short_claim] => 2
[patent_maintenance] => 1
[patent_no_of_assignments] => 0
[patent_current_assignee] =>[type] => publication
[pdf_file] =>[firstpage_image] =>[orig_patent_app_number] => 18705126
[rel_patent_id] =>[rel_patent_doc_number] =>) 18/705126 | GENERATING KNOWLEDGE BASE QUERIES AND OBTAINING ANSWERS TO KNOWLEDGE BASE QUERIES | Oct 27, 2021 | Pending |
Array
(
[id] => 17358790
[patent_doc_number] => 20220019586
[patent_country] => US
[patent_kind] => A1
[patent_issue_date] => 2022-01-20
[patent_title] => PREDICTED PROPERTIES FOR DATABASE QUERY PLANNING
[patent_app_type] => utility
[patent_app_number] => 17/489484
[patent_app_country] => US
[patent_app_date] => 2021-09-29
[patent_effective_date] => 0000-00-00
[patent_drawing_sheets_cnt] => 0
[patent_figures_cnt] => 0
[patent_no_of_words] => 7973
[patent_no_of_claims] => 0
[patent_no_of_ind_claims] => -17
[patent_words_short_claim] => 133
[patent_maintenance] => 1
[patent_no_of_assignments] => 0
[patent_current_assignee] =>[type] => publication
[pdf_file] =>[firstpage_image] =>[orig_patent_app_number] => 17489484
[rel_patent_id] =>[rel_patent_doc_number] =>) 17/489484 | PREDICTED PROPERTIES FOR DATABASE QUERY PLANNING | Sep 28, 2021 | Abandoned |
Array
(
[id] => 17261163
[patent_doc_number] => 20210374148
[patent_country] => US
[patent_kind] => A1
[patent_issue_date] => 2021-12-02
[patent_title] => SYSTEMS AND METHODS FOR IDENTIFYING A CATEGORY OF A SEARCH TERM AND PROVIDING SEARCH RESULTS SUBJECT TO THE IDENTIFIED CATEGORY
[patent_app_type] => utility
[patent_app_number] => 17/400283
[patent_app_country] => US
[patent_app_date] => 2021-08-12
[patent_effective_date] => 0000-00-00
[patent_drawing_sheets_cnt] => 0
[patent_figures_cnt] => 0
[patent_no_of_words] => 16338
[patent_no_of_claims] => 0
[patent_no_of_ind_claims] => -18
[patent_words_short_claim] => 2
[patent_maintenance] => 1
[patent_no_of_assignments] => 0
[patent_current_assignee] =>[type] => publication
[pdf_file] =>[firstpage_image] =>[orig_patent_app_number] => 17400283
[rel_patent_id] =>[rel_patent_doc_number] =>) 17/400283 | Systems and methods for identifying a category of a search term and providing search results subject to the identified category | Aug 11, 2021 | Issued |
Array
(
[id] => 19917561
[patent_doc_number] => 12292931
[patent_country] => US
[patent_kind] => B2
[patent_issue_date] => 2025-05-06
[patent_title] => Systems and methods for multi-vendor storage infrastructure in a dashboard
[patent_app_type] => utility
[patent_app_number] => 17/387012
[patent_app_country] => US
[patent_app_date] => 2021-07-28
[patent_effective_date] => 0000-00-00
[patent_drawing_sheets_cnt] => 13
[patent_figures_cnt] => 16
[patent_no_of_words] => 3276
[patent_no_of_claims] => 18
[patent_no_of_ind_claims] => 3
[patent_words_short_claim] => 437
[patent_maintenance] => 1
[patent_no_of_assignments] => 0
[patent_current_assignee] =>[type] => patent
[pdf_file] =>[firstpage_image] =>[orig_patent_app_number] => 17387012
[rel_patent_id] =>[rel_patent_doc_number] =>) 17/387012 | Systems and methods for multi-vendor storage infrastructure in a dashboard | Jul 27, 2021 | Issued |
Array
(
[id] => 18161686
[patent_doc_number] => 20230028278
[patent_country] => US
[patent_kind] => A1
[patent_issue_date] => 2023-01-26
[patent_title] => Systems, Methods, Applications, and User Interfaces for Providing Triggers in a System of Record
[patent_app_type] => utility
[patent_app_number] => 17/383032
[patent_app_country] => US
[patent_app_date] => 2021-07-22
[patent_effective_date] => 0000-00-00
[patent_drawing_sheets_cnt] => 0
[patent_figures_cnt] => 0
[patent_no_of_words] => 26870
[patent_no_of_claims] => 0
[patent_no_of_ind_claims] => -17
[patent_words_short_claim] => 201
[patent_maintenance] => 1
[patent_no_of_assignments] => 0
[patent_current_assignee] =>[type] => publication
[pdf_file] =>[firstpage_image] =>[orig_patent_app_number] => 17383032
[rel_patent_id] =>[rel_patent_doc_number] =>) 17/383032 | Systems, methods, applications, and user interfaces for providing triggers in a system of record | Jul 21, 2021 | Issued |
Array
(
[id] => 19956463
[patent_doc_number] => 12326877
[patent_country] => US
[patent_kind] => B2
[patent_issue_date] => 2025-06-10
[patent_title] => Methods and systems for multi-dimensional aggregation using composition
[patent_app_type] => utility
[patent_app_number] => 17/378896
[patent_app_country] => US
[patent_app_date] => 2021-07-19
[patent_effective_date] => 0000-00-00
[patent_drawing_sheets_cnt] => 4
[patent_figures_cnt] => 7
[patent_no_of_words] => 1150
[patent_no_of_claims] => 27
[patent_no_of_ind_claims] => 3
[patent_words_short_claim] => 341
[patent_maintenance] => 1
[patent_no_of_assignments] => 0
[patent_current_assignee] =>[type] => patent
[pdf_file] =>[firstpage_image] =>[orig_patent_app_number] => 17378896
[rel_patent_id] =>[rel_patent_doc_number] =>) 17/378896 | Methods and systems for multi-dimensional aggregation using composition | Jul 18, 2021 | Issued |
Array
(
[id] => 19375448
[patent_doc_number] => 12067013
[patent_country] => US
[patent_kind] => B2
[patent_issue_date] => 2024-08-20
[patent_title] => Data aggregation in a hierarchy for query execution
[patent_app_type] => utility
[patent_app_number] => 17/362957
[patent_app_country] => US
[patent_app_date] => 2021-06-29
[patent_effective_date] => 0000-00-00
[patent_drawing_sheets_cnt] => 9
[patent_figures_cnt] => 9
[patent_no_of_words] => 8982
[patent_no_of_claims] => 20
[patent_no_of_ind_claims] => 3
[patent_words_short_claim] => 242
[patent_maintenance] => 1
[patent_no_of_assignments] => 0
[patent_current_assignee] =>[type] => patent
[pdf_file] =>[firstpage_image] =>[orig_patent_app_number] => 17362957
[rel_patent_id] =>[rel_patent_doc_number] =>) 17/362957 | Data aggregation in a hierarchy for query execution | Jun 28, 2021 | Issued |