Migrating temporary data of a session

Details Migrating temporary data of a session Migrating temporary data of a session

2007-04-04

2009-12-15

Alam, Shahid A (Department: 2162)

Data processing: database and file management or data structures

Database design

Data structure types

C707S793000, C713S182000

Reexamination Certificate

active

07634512

ABSTRACT:
A technique for migrating (e.g., “copying” or “moving”) temporary data from one session to another session is provided. While executing a workload associated with a particular session, session state is created. A subset of the session state comprises large objects that are referred to as “temporary data.” Thus, temporary data is stored in a database (instead of in the database server) and is normally deleted when the particular session is deleted. To avoid this deletion when the session state is migrated to a different session, the temporary data, in one embodiment, is saved in an external storage that is separate from the database. An external table is created in the external storage and stores the temporary data. Location information to access the external table is provided to the other session.

REFERENCES:
patent: 6094684 (2000-07-01), Pallmann
patent: 6145121 (2000-11-01), Levy et al.
patent: 6167405 (2000-12-01), Rosensteel et al.
patent: 6769054 (2004-07-01), Sahin et al.
patent: 6775826 (2004-08-01), Zahavi et al.
patent: 6813731 (2004-11-01), Zahavi et al.
patent: 6877095 (2005-04-01), Allen
patent: 7194761 (2007-03-01), Champagne
patent: 7415522 (2008-08-01), Kaluskar et al.
patent: 2004/0015600 (2004-01-01), Tiwary et al.
patent: 2004/0221115 (2004-11-01), Sahin et al.
patent: 2005/0038849 (2005-02-01), Kaluskar et al.
patent: 2005/0055383 (2005-03-01), Dias et al.
patent: 2005/0186975 (2005-08-01), Yach et al.
patent: 1 610 238 (2005-12-01), None
patent: WO 02/097664 (2002-12-01), None
patent: WO 03/005202 (2003-01-01), None
patent: WO 03/009139 (2003-01-01), None
“5 Schema Objects” downloaded from the internet Apr. 12, 2007 < http://oracle-docs.dartmouth.edu/dba-docs/10gdoc/server.101/b10743/schema.htm > pp. 11-14.
“6 Application Builder Concepts” downloaded from the Internet Apr. 12, 2007 < http://oracle-docs.dartmouth.edu/dba-docs/10gdoc/appdev.101/b10992/mvl—fund. htm > p. 11.
Dias, K., et al., “Automatic Performance Diagnosis and Tuning in Oracle”, XP-002470748, CIDR Conference, 2005, 12 pages.
European Patent Office, “International Search Report”, PCT/US2007/081966, dated Mar. 11, 2008, 14 pages.
Claims, PCT/US2007/081966, 6 pages.

Affiliated with

Also associated with

Rating

Migrating temporary data of a session does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Migrating temporary data of a session, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Migrating temporary data of a session will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-4077574