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.

Claims

20 · 3 independent · depth 5

20 granted claims

›1.independentA method comprising:nstoring a first schema definition describing a first plurality of database objects;storing a first workload description describin…+15

›2.↳ 1The method of claim 1, wherein the selecting of the particular database objects is such that a size of the one or more second database objects fits wi…d2+1

›4.↳ 1The method of claim 1, wherein the selecting of the particular database objects is based on a type, a version, or a configuration of a second database…d2

›5.↳ 1The method of claim 1, wherein the selecting of the particular database objects is based on maximizing a reduction in execution time when a second dat…d2+1

›7.↳ 1The method of claim 1, wherein the first workload description comprises a plurality of queries, and wherein the selecting of the particular database o…d2+6

›8.↳ 7The method of claim 7, wherein for each hierarchy of the plurality of hierarchies, the execution time of the query set and the execution time of the c…d3+3

›12.↳ 7The method of claim 7, wherein the determining of the optimized hierarchy set utilizes one or more of a multi-path greedy selection algorithm and a dy…d3

›13.↳ 7The method of claim 7, wherein an algorithm for the determining of the optimized hierarchy set is chosen based on a size of the first workload descrip…d3

›14.↳ 1The method of claim 1, further comprising:ndetermining one or more database technologies of a second database system for storing the one or more secon…d2

›15.↳ 1The method of claim 1, further comprising outputting a report describing the particular database objects, a mapping from the first schema definition t…d2

›16.↳ 1The method of claim 1, further comprising generating one or more scripts to configure a second database system as a caching system for the first datab…d2

›17.independentA non-transitory computer-readable medium storing one or more sequences of instructions which, when executed by one or more processors, cause performi…+1

›19.independentA database advisor system comprising one or more computing devices configured to:nstore a first schema definition describing a first plurality of data…+1

Classifications

1 codes

IPC · International Patent Classification

Section G — Physics

G06F17/30

Claim changes

Soon

Coming soonHow the claims changed between publication and grant

See which claims were amended, added or cancelled during examination, with every added and removed word marked.

AmendedAddedCancelledUnchanged

The published claims of this patent are not paired with the granted ones in what we hold.

File wrapper

⤢ drag to zoom

USPTOApplicanthover for detail · click to open

Pendency

2.3 y

830 days filing → grant

Office actions

non-final + final

Responses

2 RCE

Examiner

Frantz Coby

art unit 2156 · TC 2100

Law firm

Law firm · Log in to unlock

Citations: 12 back · 1 forward

See the full prosecution history — every USPTO and applicant action on this file, in order.

Term & fees

See the term timeline — pendency span, in-force span, the maintenance fees paid and both computed expiry dates.

Priority chain

1 priority documents

›Priority documents — 1

Type	Document	Date
related publication	US 20140280373 A1	18 Sep 2014

Validity challenges

See the validity challenges on record — reexaminations, IPRs and PGRs, with their institution decisions and outcomes.

Citations

See every patent this one cites and every patent that cites it back — publication, assignee, and how each one was found.