Data source task pane

Details Data source task pane Data source task pane

2005-12-22

2009-06-09

Lu, Kuen S. (Department: 2169)

Data processing: database and file management or data structures

Database design

Data structure types

C707S793000, C707S793000

Reexamination Certificate

active

07546291

ABSTRACT:
A user interface is provided that allows users to create queries interactively. The user interface operates by creating a source query (or, for example, SQL commands) for the user while they select fields from a data source. This provides users with an alternative to using conventional designers, wizards, or other tools to manually generate a query.

REFERENCES:
patent: 5121499 (1992-06-01), McCaskill et al.
patent: 5175810 (1992-12-01), Young 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: 5455853 (1995-10-01), Cebulka 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: 5649192 (1997-07-01), Stucky
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: 5740370 (1998-04-01), Battersby et al.
patent: 5752253 (1998-05-01), Geymond et al.
patent: 5758337 (1998-05-01), Hammond
patent: 5768158 (1998-06-01), Adler et al.
patent: 5812983 (1998-09-01), Kumagai
patent: 5819293 (1998-10-01), Comer et al.
patent: 5838965 (1998-11-01), Kavanagh et al.
patent: 5881381 (1999-03-01), Yamashita et al.
patent: 5890174 (1999-03-01), Khanna et al.
patent: 5913033 (1999-06-01), Grout
patent: 5920725 (1999-07-01), Ma et al.
patent: 5926822 (1999-07-01), Garman
patent: 5944789 (1999-08-01), Tzelnic et al.
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: 6070177 (2000-05-01), Kao et al.
patent: 6112214 (2000-08-01), Graham et al.
patent: 6134552 (2000-10-01), Fritz et al.
patent: 6134563 (2000-10-01), Clancey et al.
patent: 6134583 (2000-10-01), Herriot
patent: 6138130 (2000-10-01), Adler et al.
patent: 6151601 (2000-11-01), Papierniak et al.
patent: 6151624 (2000-11-01), Teare et al.
patent: 6216139 (2001-04-01), Listou
patent: 6292811 (2001-09-01), Clancey et al.
patent: 6334158 (2001-12-01), Jenny et al.
patent: 6374268 (2002-04-01), Testardi
patent: 6477527 (2002-11-01), Carey et al.
patent: 6510439 (2003-01-01), Rangarajan et al.
patent: 6542933 (2003-04-01), Durst, Jr. et al.
patent: 6567822 (2003-05-01), Cudahy et al.
patent: 6640234 (2003-10-01), Coffen et al.
patent: 6694321 (2004-02-01), Berno
patent: 6785704 (2004-08-01), McCanne
patent: 6820088 (2004-11-01), Hind et al.
patent: 7062502 (2006-06-01), Kesler
patent: 7139768 (2006-11-01), Janzig et al.
patent: 7174327 (2007-02-01), Chau et al.
patent: 2002/0049764 (2002-04-01), Boothby et al.
patent: 2002/0052769 (2002-05-01), Navani et al.
patent: 2002/0063734 (2002-05-01), Khalfay et al.
patent: 2002/0087729 (2002-07-01), Edgar
patent: 2002/0184043 (2002-12-01), Lavorgna et al.
patent: 2003/0046366 (2003-03-01), Pardikar et al.
patent: 2003/0145224 (2003-07-01), Bailey
patent: 2003/0154191 (2003-08-01), Fish et al.
patent: 2003/0154197 (2003-08-01), Millet et al.
patent: 2003/0158947 (2003-08-01), Bloch et al.
patent: 2003/0159089 (2003-08-01), DiJoseph
patent: 2003/0225758 (2003-12-01), Yamasaki
patent: 2004/0001106 (2004-01-01), Deutscher 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.
patent: 2004/0172424 (2004-09-01), Edelstein et al.
patent: 2004/0193969 (2004-09-01), Nemoto et al.
patent: 2004/0236777 (2004-11-01), Pardikar et al.
patent: 2005/0034064 (2005-02-01), Meyers et al.
patent: 2005/0069361 (2005-03-01), Wang et al.
patent: 2005/0080823 (2005-04-01), Collins
patent: 2005/0091253 (2005-04-01), Cragun et al.
patent: 2005/0187897 (2005-08-01), Pawar et al.
patent: 2005/0228990 (2005-10-01), Kato et al.
patent: 2006/0020586 (2006-01-01), Prompt et al.
patent: 2006/0155705 (2006-07-01), Kamper et al.
patent: 2006/0168325 (2006-07-01), Wood et al.
patent: 2006/0168557 (2006-07-01), Agrawal et al.
patent: 2006/0242189 (2006-10-01), Leetaru et al.
patent: 2006/0259506 (2006-11-01), Kim
patent: 2007/0198657 (2007-08-01), Saliba et al.
patent: WO 00/60484 (2000-10-01), None
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.sbaurmann/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. 10/782,074, filed Feb. 19, 2004 entitled “Data Source Write back and Offline Data Editing and Storage in a 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/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.
Louis Davidson; “Professional SQL Server 2000 Database Design”; Wrox Press Ltd., 464 pgs.
U.S. Official Action mailed Oct. 16, 2007 on U.S. Appl. No. 11/231,260.
U.S. Official Action mailed Jan. 9, 2008 in U.S. App. No. 11/300,728.
U.S. Official Action mailed Oct. 3, 2007 in U.S. Appl. No. 11/169,856.
PCT International Search Report in PCT/US2007/002662 mailed Jul. 5, 2007.
Davidson, “Professional SQL Server 2000 Database Design”, Wrox Press Ltd., 2001, 464 pp.
“Mapping Windows XP Professional to Your Business Needs”, Microsoft: Windows XP Resource Kits, http://www.microsoft.com/resources/documentation/Windows/XP/all/reskit/en-us/Default.asp?url=/resources/documentation/Windows/XP/all/reskit/en-us/prba—dwp—tnvo.asp, printed Dec. 15, 2005, 8 pp.
Strong, Craeg, “Release Information”, http://www.zope.org/Members/arielpartners/CVSFile/readme/document—view, Apr. 2003, 6 pp.
Onion, Fritz, “Understanding Paths in ASP.NET”, Informit.com, http://www.informit.com/articles/article.asp?p=101145&redir=1, Sep. 2003, 4 pp.
U.S. Official Action in U.S. Appl. No. 11/343,957 mailed Jan. 15, 2008.
U.S. Official Action in U.S. Appl. No. 11/231,260, Selca et al., mailed Jul. 18, 2008, 34 pgs, (14917.0202US11).
U.S. Official Action in U.S. 11/169,856, Selca et al., (14917.0109US01), mailed in Jul. 21, 2008, 7 pgs.

Affiliated with

Also associated with

Rating

Data source task pane 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 task pane, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Data source task pane will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-4084038