Dismiss
InnovationQ will be updated on Sunday, Oct. 22, from 10am ET - noon. You may experience brief service interruptions during that time.
Browse Prior Art Database

Use of a Snapshot Database Archive to Capture Point In Time Project Status and Billable Activity

IP.com Disclosure Number: IPCOM000033259D
Original Publication Date: 2004-Dec-02
Included in the Prior Art Database: 2004-Dec-02
Document File: 3 page(s) / 111K

Publishing Venue

IBM

Abstract

For large scale projects with significant billable activity and/or high rate of change to business critical information, an archive repository is needed. This is an extension of normal file backup software.

This text was extracted from a PDF file.
At least one non-text object (such as an image or picture) has been suppressed.
This is the abbreviated version, containing approximately 100% of the total text.

Page 1 of 3

Use of a Snapshot Database Archive to Capture Point In Time Project Status and Billable Activity

On a regular basis (weekly, monthly, quarterly, etc.) a complete named archive copy of the project database is created. The archive copy may be used to recover from system problems or provide a point-in-time picture of billable activity that existed during the prior billing cycle. The screen capture below shows are practical application as used on a corporate migration project:

1

Page 2 of 3

The archive frequency is configurable as follows. It is much more flexible and robust that existing program products.

A variety of frequencies may be specified and simultaneously used. For instance, a database may be archived both quarterly (with all quarterly archives retained) and nightly (with nightly replacement).

Daily/nightly

2

[This page contains 1 picture or other non-text object]

Page 3 of 3

Weekly (on a specific day of week)

Bi-weekly (on specific days of week)

Monthly (on a specific day of month, for instance, calendar vs. accounting) Bi-monthly (on specific days of month, for instance, calendar vs. final and mid-month accounting)

Quarterly (on a specific day)

Yearly (on a specific day)

Archives are named/stored based on the type of archive and the date the archive was performed for ease of identification
Complete archive history is stored in the parent database

3