Data processing: database and file management or data structures – Database design – Data structure types
Reexamination Certificate
2007-06-05
2007-06-05
Alam, Hosain (Department: 2167)
Data processing: database and file management or data structures
Database design
Data structure types
C707S793000, C707S793000, C709S201000
Reexamination Certificate
active
10706731
ABSTRACT:
A method, apparatus, and computer instructions for direct linkage of relational database table to a data preparation tool for data preparation. In a preferred embodiment, the mechanism of the present invention allows data to be read directly from one or more relational database tables to a data preparation tool into datasets without generating output flat files. Multiple datasets from different relational database table are merged into one dataset if more than one relational database table is read. Upon completion of necessary data preparation on the dataset by the data preparation tool, the present invention creates a new relational database table and loads resulting data from the prepared dataset into the new relational database table.
REFERENCES:
patent: 5787416 (1998-07-01), Tabb et al.
patent: 6128628 (2000-10-01), Waclawski et al.
patent: 6356897 (2002-03-01), Gusack
patent: 6438549 (2002-08-01), Aldred et al.
patent: 6519601 (2003-02-01), Bosch
patent: 6728726 (2004-04-01), Bernstein et al.
patent: 6985901 (2006-01-01), Sachse et al.
patent: 7047232 (2006-05-01), Serrano
patent: 2003/0212960 (2003-11-01), Shaughnessy et al.
1994 Database Buyer's Guide and Client/Server Sourcebook, The Gale Group, v.7, n.6 p. 63(29), Jun. 15, 1994.
Dilorio et al., “Data About Data: An Introduction to Dictionary Tables”, Proceedings of the Twenty-First Annual SAS Users Group, International Conference, SUGI 21, Pt. vol. 1, pp. 213-219, Published Cary, NC, USA, 1996.
Loren, “SAS Connections to DB2: Tools and Techniques”, Proceedings of the Twenty-First Annual SAS Us rs Group, International Conference, SUGI 21, Pt. vol. 1, pp. 498-507, Published Cary, NC, USA, 1996.
Dickson et al., “Select Items from PROC.SQL Where Items>Basics”, Proceedings of the Twenty-First Annual SAS Users Group, International Conference, SUGI 21, Pt. vol. 1, pp. 227-236, Published Cary, NC, USA, 1996.
Crandall, “Building and Using %Window Applications in SAS”, Proceedings of the Twenty-First Annual SAS Users Group, International Conference, SUGI 21, Pt. vol. 1, pp. 926-930, Published Cary, NC, USA, 1996.
McCaskell, “Looking for Mr. X Bar: Supporting Statistical Computing in the Personal Computer Era”, Capitalizing on Communication, ACM SIGUCCS XVII, 1989, pp. 367-375.
Chiu et al., “A Robust and Scalable Clustering Algorithm for Mixed Type Attributes in Large Database Environment”, ACM Digital Library, 2001, pp. 263-268.
IBM Technical Disclosure Bulletin, vol. 25, No. 11A, Apr. 1983, “Data Space Manager”, pp. 5456-5459.
“Welcome to the IBM TPF Product Information Center”, IBM TPF Product Information Center, pp. 1-3, (updated Sep. 2005) retrieved Jul. 12, 2006. http://publib.boulder.ibm.com/infocenter/tpfhelp/current/topic/com.ibm.tpf.doc/pichHome.html.
“Relational database tables”, IBM Corporation, Red Brick Warehouse (last updated Mar. 2004), pp. 1-3, retrieved Jul. 10, 2006. http://publib.boulder.ibm.com/infocenter/rb63help/topic/com.ibm.redbrick.doc6.3/sqlrg/sqlrg12.htm.
Welcome to the IBM Red Brick Warehouse 6.34 Information Center, pp. 1-2, (updated Mar. 2004), retrieved Jul. 12, 2006. http://publib.boulder.ibm.com/infocenter/rb63help/topic/com.ibm.redbrick.doc6.3/welcome—rb63.htm.
“Understanding Virtual Storage Access Method (VSAM) database support”, IBM TPF Product Information Center, 1 page, retrieved Jul. 10, 2006. http://publib.boulder.ibm.com/infocenter/tpfhelp/current/topic/com.ibm.ztpf.doc—put.02/gtpa2/gtpa2m2q.htm.
“VSAM concepts”, pp. 1-2, retrieved Jul. 10, 2006. http://publib.boulder.ibm.com/infocenter/tpfhelp/current/topic/com.ibm.ztpf.doc—put.02/gtpa2/gtpa2m2r.htm.
“VSAM data support”, pp. 1-14, retrieved Jul. 10, 2006. http://publib.boulder.ibm.com/infocenter/tpfhelp/current/topic/com.ibm.ztpf.doc—put.02/gtpa2/gtpa2m2s.htm.
Loren et al., “SAS Connections to DB2: Tools and Techniques”, Proceedings of the Twenty-First Annual SAS Users Group International Conference, Chicago, Illinois Mar. 1996, pp. 498-507.
Alam Hosain
Garg Rakesh
Pivnichny John R.
Rayyan Susan
Yee Duke W.
LandOfFree
Method and system for direct linkage of a relational... does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with Method and system for direct linkage of a relational..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Method and system for direct linkage of a relational... will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-3844199