Pre-Grant Publication Number: 20070150488
Please help the USPTO examine the application by evaluating the relevance of the publicly submitted prior art to the patent application.
Peer-to-Patent forwards the Top 10 most relevant prior art submissions and their annotations to the United States Patent and Trademark Office.
Review this prior art and click on the thumbs up (or down) to indicate whether this submission should be forwarded to the USPTO.
If you login then you can add an annotation by typing in the box at the bottom of the screen to comment on the relevance of the prior art to the claims of the patent application.
Review this prior art and click on the thumbs up (or down) to indicate whether this submission should be forwarded to the USPTO.
If you login then you can add an annotation by typing in the box at the bottom of the screen to comment on the relevance of the prior art to the claims of the patent application.
Prior Art Detail
Summary / Description
| Summary / Description | Best practices say to store performance related data about your database. It's a measure of the process. After a migration, it's one of the critical measures of the process to determine if it was improved. |
Basic Information
| Type of Prior Art | Online Publication |
| URL | http://www.dmreview.com/article... |
| Author/Creator | William Laurent |
| Title | Best Practices for Data Warehouse Database Developers |
| Publication Date | December 1, 2001 |
| Publisher | DM Review Magazine |
| Directions to Document Location | |
| Additional Information | |
Notes / To Do
| Notes | |
Excerpt
Excerpt Save query plans, run times and performance benchmarks in the database. Storing processing performance information and benchmarking data in the database can be done quite easily, although it is often an afterthought in many data warehouses. For example, recording a process start time and end time for every critical batch or processing task in the warehouse can easily be implemented via such things as stored procedures, shell scripts or ETL tool tasks that serve as wrapper or control objects. |
Relevance
Claims
1
A computer-implemented method for optimizing migration of a database from a source system to a target system, comprising:
collecting source parameters related to performance characteristics for the database on the source system;
generating database configuration information on the basis of the collected source parameters and target parameters of the target system, wherein the target parameters will affect the operation of the database on the target system as compared to the operation of the database on the source system; and wherein the database configuration information is applicable to tune the database to operate on the target system; and
configuring the database to run on the target system according to the database configuration information.
Relevance
collecting source parameters related to performance characteristics for the database on the source system; - a best practice
collecting source parameters related to performance characteristics for the database on the source system; - a best practice
Claim Chart
All
11
A computer-readable medium having a program stored thereon which, when executed, performs operations for optimizing migration of a database from a source system to a target system, the operations comprising:
receiving source parameters related to performance characteristics for the database on the source system; and
generating database configuration information on the basis of the collected source parameters and target parameters of the target system, wherein the target parameters will affect the operation of the database on the target system as compared to the operation of the database on the source system; and wherein the database configuration information is applicable to tune the database to operate on the target system.
Relevance
collecting source parameters related to performance characteristics for the database on the source system; - a best practice
collecting source parameters related to performance characteristics for the database on the source system; - a best practice
Claim Chart
All
21
A data processing system, comprising:
a source system having a database;
a target system; and
a detection/restoration component for optimizing migration of the database from the source system to the target system, the detection/restoration component being configured to:
collect source parameters related to performance characteristics for the database on the source system;
generate database configuration information on the basis of the collected source parameters and target parameters of the target system, wherein the target parameters will affect the operation of the database on the target system as compared to the operation of the database on the source system; and wherein the database configuration information is applicable to tune the database to operate on the target system; and
configure the database to run on the target system according to the database configuration information.
Relevance
collecting source parameters related to performance characteristics for the database on the source system; - a best practice
collecting source parameters related to performance characteristics for the database on the source system; - a best practice
Claim Chart
All
26
A computer-implemented method for optimizing migration of a database from a source system to a target system, comprising:
collecting source parameters related to performance characteristics for the database on the source system; and
restoring the database on the target system according at least to the source parameters; wherein the restoring accounts for a difference in operating characteristics between the source system and the target system.
Relevance
collecting source parameters related to performance characteristics for the database on the source system; - a best practice
collecting source parameters related to performance characteristics for the database on the source system; - a best practice
Claim Chart
All
0 days left
