Automatically determining an optimal database subsection
AssigneeOracle International Corporation
InventorsJohn Raitto, Tirthankar Lahiri, Marie-Anne Neimat, Chih-Ping Wang
Life of this patent
Estimating the term…
Loading patent…
AssigneeOracle International Corporation
InventorsJohn Raitto, Tirthankar Lahiri, Marie-Anne Neimat, Chih-Ping Wang
Estimating the term…
A method, apparatus, and system for automatically determining an optimal database subsection is provided. A database subsection is selected to optimize certain benefits when the database subsection is translated, transferred, and cached on an alternative database system, which may utilize a different technology or database engine that provides certain performance benefits compared to the original database system. Algorithms such as multi-path greedy selection and/or dynamic programming may provide optimal or near-optimal results. A host for the alternative database server may be shared with or otherwise located in close physical proximity to improve latency for a database application or client layer. Once the database subsection analysis is completed, a report may be generated and presented to the user, and an implementation script may also be created to automatically configure a client host to function as a cache or replacement system according various cache size configurations described in the report.
A method comprising:
A non-transitory computer-readable medium storing one or more sequences of instructions which, when executed by one or more processors, cause performing of:
A database advisor system comprising one or more computing devices configured to:
Dependencies are inferred from the claim text.