In place migration when changing datatype of column

Details In place migration when changing datatype of column In place migration when changing datatype of column

2011-08-02

2011-08-02

Ali, Mohammad (Department: 2158)

Data processing: database and file management or data structures

Database design

Database and data structure management

C707S601000

Reexamination Certificate

active

07991798

ABSTRACT:
Techniques are described herein for altering the datatype of a column without having to immediately migrate the data items that currently reside in the column. In one embodiment, the alteration is performed without migration by creating a new column having the desired datatype while retaining the old column. Instead of migrating the data items from to the new column at the time the column is altered, the items remain in the original column until the items are updated.

REFERENCES:
patent: 5227967 (1993-07-01), Bailey
patent: 5315709 (1994-05-01), Alston et al.
patent: 5440743 (1995-08-01), Yokota et al.
patent: 5448727 (1995-09-01), Annevelink
patent: 5555388 (1996-09-01), Shaughnessy
patent: 5608903 (1997-03-01), Prasad et al.
patent: 5640550 (1997-06-01), Coker
patent: 5717924 (1998-02-01), Kawai
patent: 5978426 (1999-11-01), Glover et al.
patent: 6016497 (2000-01-01), Suver
patent: 6122630 (2000-09-01), Strickler et al.
patent: 6122640 (2000-09-01), Pereira
patent: 6173313 (2001-01-01), Klots et al.
patent: 6268850 (2001-07-01), Ng
patent: 6304867 (2001-10-01), Schmidt
patent: 6324535 (2001-11-01), Bair et al.
patent: 6363387 (2002-03-01), Ponnekanti et al.
patent: 6460055 (2002-10-01), Midgley et al.
patent: 6480848 (2002-11-01), DeKimpe et al.
patent: 6519613 (2003-02-01), Friske et al.
patent: 6598059 (2003-07-01), Vasudevan et al.
patent: 6611848 (2003-08-01), Bradley
patent: 6633870 (2003-10-01), Bradley
patent: 6633883 (2003-10-01), Koskas
patent: 6681225 (2004-01-01), Uceda-Sosa et al.
patent: 6745209 (2004-06-01), Holenstein et al.
patent: 6769124 (2004-07-01), Schoening et al.
patent: 6801983 (2004-10-01), Abe et al.
patent: 6834290 (2004-12-01), Pugh et al.
patent: 2002/0087271 (2002-07-01), Rozenshtein et al.
patent: 2002/0188600 (2002-12-01), Lindsay et al.
patent: 2003/0154216 (2003-08-01), Arnold et al.
patent: 2003/0217069 (2003-11-01), Fagin et al.
patent: 2003/0229610 (2003-12-01), Van Treeck
patent: 2004/0064487 (2004-04-01), Nguyen et al.
patent: 2006/0015528 (2006-01-01), Hejlsberg et al.
patent: 2006/0085457 (2006-04-01), Gelfand
patent: 2007/0038651 (2007-02-01), Bernstein et al.
patent: 2007/0079140 (2007-04-01), Metzger et al.
patent: 2007/0219951 (2007-09-01), Ahmed et al.
Paapanen, Eric, et al. Oracle Database Application Developer's Guide—Large Objects, 10g Release 1 (10.1) Part No. B10796-01(2003) Apr. 21, 2008 <http://www.stanford.edu/dept/itss/docs/oracle/10g/appdev.101/b10796.pdf>.
Smith, Jeff. “The shortest, fastest, and easiest way to compare two tables in SQL Server: UNION!” Jeff's SQL Server Blog. Nov. 10, 2004. Apr. 22, 2008 <http://weblogs.sqlteam.com/jeffs/archive/2004/11/10/2737.aspx>.
T-SQL, “sp—rename (T-SQL).” Mar. 27, 2003 Apr. 22, 2008 <http://web.archive.org/web/20030327184148/http://doc.ddart.net/mssql/sql70/sp—ra-rz—11.htm>.
Davidson, Tom. “Managing Schema Changes (Part 2).” MSSQL Server Development Customer Advisory Team. Mar. 31, 2006. Microsoft Corporation. Nov. 19, 2008 <http://blogs.msdn.com/sqlcat/archive/2006/03/31/566046.aspx>.
Ambler, Scott, and Pramod Sadalage. Refactoring Databases: Evolutionary Database Design. Mar. 3, 2006.
Date, C.J., et al., “A Guide to SQL/DS”, Codd and Date Consulting Group, Addison-Wesley Publishing Company, Printed Feb. 1989, 13 pages.
Lassen, Allen R., “Experiences With Object Oriented Development in PL/SQL”, Centre for Object Technology, Copyright 2000, COT/4-18-v1.4, 27 pages.
Oracle, “Object Cache Navigation”, Copyright 1996, 2002 Oracle Corporation, Oracle Call Interface Programmer's Guide, Release 2 (9.2), Part No. A96584-01, 18 pages.
Quest, “Reorganization for the 24×7 Database”, Quest Software, Inc., LiveReorg®, 2001, 4 pages.
U.S. Appl. No. 11/201,797, filed Aug. 10, 2005, Final Office Action, Dec. 7, 2010.
U.S. Appl. No. 11/875,478, filed Oct. 19, 2007, Office Action, Aug. 30, 2010.
Scott Ambler et al., “Refactoring Databases: Evolutionary Database Design”, Mar. 3, 2006, 7 pages.
Tom Davidson, Managing Schema Changes (Part 2), MSSQL Server Development Customer Advisory Teach, Mar. 31, 2006, Microsoft Corporation, Nov. 19, 2000, http://blgs.msdn.com/squlcat/archive/2006/03/31/566046.aspx, 11 pages.
U.S. Appl. No. 11/801,495, filed May 9, 2007, Office Action, mailing date Jun. 3, 2011.

Affiliated with

Also associated with

Rating

In place migration when changing datatype of column does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with In place migration when changing datatype of column, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and In place migration when changing datatype of column will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-2756529