Data processing: database and file management or data structures – Database design – Data structure types
Reexamination Certificate
2007-05-29
2007-05-29
Chace, Christian (Department: 2167)
Data processing: database and file management or data structures
Database design
Data structure types
C715S252000
Reexamination Certificate
active
10782074
ABSTRACT:
Methods and systems provide for bi-directional communication between a spreadsheet application worksheet and a database data source that allows modified data to be written from a spreadsheet application to source data in a database data source from which the original pre-modified data was obtained. Offline data changes in a spreadsheet application are cached by a data provider application and are published to a remote data source when the spreadsheet application is synchronized with the data source. Error conditions and data conflicts resulting from new or modified data published to a database data source from a spreadsheet application worksheet are reported to a user of the spreadsheet application worksheet through a data provider application to allow the user an opportunity to resolve error conditions and data conflicts between the user's data changes and other data changes made to the same source data contained in the database data source.
REFERENCES:
patent: 5121499 (1992-06-01), McCaskill et al.
patent: 5247611 (1993-09-01), Norden-Paul et al.
patent: 5255356 (1993-10-01), Michelman et al.
patent: 5319777 (1994-06-01), Perez
patent: 5359729 (1994-10-01), Yarnell et al.
patent: 5396587 (1995-03-01), Reed et al.
patent: 5418898 (1995-05-01), Zand et al.
patent: 5418902 (1995-05-01), West et al.
patent: 5471575 (1995-11-01), Giansante
patent: 5510980 (1996-04-01), Peters
patent: 5535324 (1996-07-01), Alvarez et al.
patent: 5553215 (1996-09-01), Kaethler
patent: 5598519 (1997-01-01), Narayanan
patent: 5600584 (1997-02-01), Schlafly
patent: 5604854 (1997-02-01), Glassey
patent: 5685001 (1997-11-01), Capson et al.
patent: 5701499 (1997-12-01), Capson et al.
patent: 5708827 (1998-01-01), Kaneko et al.
patent: 5752253 (1998-05-01), Geymond et al.
patent: 5768158 (1998-06-01), Adler et al.
patent: 5812983 (1998-09-01), Kumagai
patent: 5819293 (1998-10-01), Comer et al.
patent: 5881381 (1999-03-01), Yamashita et al.
patent: 5890174 (1999-03-01), Khanna et al.
patent: 5926822 (1999-07-01), Garman
patent: 5966716 (1999-10-01), Comer et al.
patent: 5987481 (1999-11-01), Michelman et al.
patent: 6055548 (2000-04-01), Comer et al.
patent: 6055549 (2000-04-01), Takano
patent: 6112214 (2000-08-01), Graham et al.
patent: 6134563 (2000-10-01), Clancey et al.
patent: 6138130 (2000-10-01), Adler et al.
patent: 6216139 (2001-04-01), Listou
patent: 6292811 (2001-09-01), Clancey et al.
patent: 6567822 (2003-05-01), Cudahy et al.
patent: 6640234 (2003-10-01), Coffen et al.
patent: 2004/0039743 (2004-02-01), Maleport et al.
patent: 2004/0103365 (2004-05-01), Cox
patent: 2004/0138815 (2004-07-01), Li et al.
Louis Davison: Professional SQL Server 2000 Database Design, Wrox Press Ltd.®, 2001.
Anonymous, “Method and Apparatus for Automatic Character Line Fill of Decimal Fields.” IBM Technical Disclosure Bulletin vol. 36, No. 10, pp. 155-156, Oct. 1993.
Miastkowski, S. “Excel 5.0—a Quick-start Guide to Using Excel's Powerful New Features.” Macworld vol. 11, No. 10, pp. 146-151, Oct. 1994.
Microsoft Corp. Help File on ‘Series’ ‘Repeated Entries’, and ‘Auto Fill’ (screen shot) of Microsoft Excel 97 (1996), taken Mar. 2001, 6 pp.
Crew, Ed, ed. “Lesson in Excel 97: Lesson One . . . ”, Web page tutorial on Excel 97 downloaded from pathways.uwe.ac.uk/Edict/Excel/Excel-01.asp on Mar. 29, 2002, 6 pp.
Sonic.net. “Microsoft Excel 5.0 (Tips on Using MS Excel 5.0 Repeat Entries)” downloaded from www.sonic.net/.about.sbaumann/excel.html on Apr. 2, 2002, 5 pp.
Microsoft Office 2000/Visual Basic Programmer's Guide, “Creating Dynamic Reports with Query Tables in Excel”, http://msdn.microsoft.com/library/en-us/odeopg/html/deconcreatingdynamicreportswithq . . . , downloaded May 16, 2006, 2 pp.
Khor, “Microsoft Office Excel 2003 Preview”, Jun. 2003, http://msdn.microsoft.com/library/en-us/odc—x12003—ta/html/odc—xlov.asp?frame=true, downloaded May 16, 2006, 19 pp.
U.S. Appl. No. 10/667,543, filed Sep. 22, 2003 entitled “Extension of Formulas and Formatting in an Electronic Spreadsheet”.
U.S. Appl. No. 11/169,856, filed Jun. 29, 2005 entitled “Modifying Table Definitions Within a Database Application”.
U.S. Appl. No. 11/317,648, filed Dec. 22, 2005 entitled “Data Source Task Pane”.
U.S. Appl. No. 11/300,728, filed Dec. 15, 2005 entitled “Offline Multi-Table Data Editing and Storage System”.
U.S. Appl. No. 11/231,260, filed Sep. 20, 2005 entitled “Templates in a Schema Editor”.
Official Action in U.S. Appl. No. 10/667,543 mailed Feb. 15, 2006.
Official Action in U.S. Appl. No. 10/667,543 mailed Aug. 2, 2006.
Davidson, “Professional SQL Server 2000 Database Design,” Wrox Press Ltd., 2001, 464 pp.
Chauhan Sumit
Coffen Robert W.
Dickinson Richard L.
Eatough Michael J.
Hafner Paul A.
Chace Christian
Lu Kuen S.
Merchant & Gould
LandOfFree
Data source write back and offline data editing and storage... does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with Data source write back and offline data editing and storage..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Data source write back and offline data editing and storage... will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-3740127