US 12,271,378 B2
Ubiquitous search on data stored in the RDBMS
Saurabh Naresh Netravalkar, Santa Clara, CA (US); Aleksandra Czarlinska, San Jose, CA (US); Zhen Hua Liu, San Mateo, CA (US); and Beda Christoph Hammerschmidt, Palo Alto, CA (US)
Assigned to ORACLE INTERNATIONAL CORPORATION, Redwood Shores, CA (US)
Filed by Oracle International Corporation, Redwood Shores, CA (US)
Filed on Sep. 13, 2023, as Appl. No. 18/367,722.
Claims priority of provisional application 63/465,426, filed on May 10, 2023.
Prior Publication US 2024/0378199 A1, Nov. 14, 2024
Int. Cl. G06F 16/20 (2019.01); G06F 16/2453 (2019.01)
CPC G06F 16/24539 (2019.01) [G06F 16/24537 (2019.01)] 20 Claims
OG exemplary drawing
 
1. A method comprising:
storing, in a database managed by a database server, a view definition of an unmaterialized view;
wherein the view definition of the unmaterialized view specifies a join between two or more base tables;
wherein the database does not store, separate from the two or more base tables, any copy of data from the two or more base tables for the unmaterialized view;
based on the view definition, determining data for source-rows of the unmaterialized view;
creating, within the database, an index that indexes the source-rows of the unmaterialized view based on the data determined for the source-rows of the unmaterialized view; and
using the index to answer queries that target the unmaterialized view;
wherein the method is performed by one or more computing devices.