Data processing: database and file management or data structures – Database design – Data structure types
Reexamination Certificate
2004-06-30
2009-10-20
Alam, Hosian T (Department: 2166)
Data processing: database and file management or data structures
Database design
Data structure types
C707S793000, C707S793000, C707S793000, C707S793000, C707S793000, C707S793000, C707S793000, C707S793000, C707S793000, C707S793000
Reexamination Certificate
active
07606792
ABSTRACT:
The present invention describes an efficient and fast framework for implementing table-valued functions (TVF's) in a relational database server. The framework provides desirable extensibility properties and has the ability to minimize performance degradations by integrating tightly with the optimization infrastructure in a query processor. The present invention also enables a managed execution environment (MEE) such as the Common-Language-Runtime (CLR), to efficiently and dynamically extend the logic of the database engine with user-supplied code.
REFERENCES:
patent: 4664496 (1987-05-01), Shinoda et al.
patent: 5544355 (1996-08-01), Chaudhuri et al.
patent: 5822750 (1998-10-01), Jou et al.
patent: 5864862 (1999-01-01), Kriens et al.
patent: 5875334 (1999-02-01), Chow et al.
patent: 6282581 (2001-08-01), Moore et al.
patent: 6351742 (2002-02-01), Agarwal et al.
patent: 6360214 (2002-03-01), Ellis et al.
patent: 6370522 (2002-04-01), Agarwal et al.
patent: 6401083 (2002-06-01), Agarwal et al.
patent: 6460043 (2002-10-01), Tabbara et al.
patent: 6496819 (2002-12-01), Bello et al.
patent: 6496833 (2002-12-01), Goldberg et al.
patent: 6505189 (2003-01-01), On Au et al.
patent: 6567802 (2003-05-01), Popa et al.
patent: 6567819 (2003-05-01), Cheng et al.
patent: 6594651 (2003-07-01), Kabra et al.
patent: 6609123 (2003-08-01), Cazemier et al.
patent: 6738968 (2004-05-01), Bosworth et al.
patent: 6778977 (2004-08-01), Avadhanam et al.
patent: 6823329 (2004-11-01), Kirk et al.
patent: 7103590 (2006-09-01), Murthy et al.
patent: 7302422 (2007-11-01), Bossman et al.
patent: 7319945 (2008-01-01), Shapiro et al.
patent: 7330848 (2008-02-01), Chaudhuri et al.
patent: 7506329 (2009-03-01), Boucher
patent: 2003/0172368 (2003-09-01), Alumbaugh et al.
patent: 2004/0236762 (2004-11-01), Chaudhuri et al.
patent: 2005/0120000 (2005-06-01), Ziauddin et al.
patent: 2005/0177579 (2005-08-01), Blakeley et al.
patent: 2005/0204340 (2005-09-01), Ruminer et al.
SQL Tuning for Oracle White Paper by Marty Weber. Copyright 2001. Retrieved from google.com on Jan. 26, 2007.
Chapter 5: Gathering and Analyzing Information. Oracle Enterprise Manager Database Tuning with Oracle Tuning Pack. Release 9.0.1 Part No. A86647-01. Copyright 2001. Retrieved from Oracle Website on Jan. 26, 2007.
Chapter 14: The Query Optimizer. Oracle Database Performance Tuning Guide. 10g Release 1 (10.1). Part No. B10752-01. Retrieved from Oracle Website Jan. 26, 2007.
Eric Brown. Yukon Basics. XML, T-SQL, and the CLR Create a New World of Database Programming. MSDN Magazine. Feb. 2004.
Michael Otey. YukonXML. Chapter 4- New Development Features. Mar. 1, 2004.
Steven Pratschner. Microsoft.NET: Implement a Custom Common Language Runtime Host for Your Managed App. MSDN Magazine. Mar. 2001.
M. Jaedicke: Parallel Object-Relational Query Processing. Chapter 7: Implementation of UDTO. Springer-Verlag Berlin Heidelberg 2001.
Qiong Luo and Wenwei Xue. Template- Based Caching for Tabel-Valued Functions. Springer-Verlag Berlin Heidelberg 2004.
PL?SQL Subprograms. User's Guide and Reference. Release 2 (9.2). Part No. A96624-01. Oracle Website copyright 2002.
Reducing Dependencies in .Net Development. By Scott Allen. Dr. Dobb's Journal Jan 1, 2002 URL:http://www.ddj.com/windows/184404942.
By A. Somani, D. Choy, and J. C. Kleewein Bringing together content and data management systems: Challenges and opportunities. vol. 41, No. 4, 2002. IBM Systems.
Dessloch, S. et al., “Integrating SQL Databases with Content-Specific Search Engines”, Proceedings of the International Conference on Very Large Data Bases, Aug. 26-29, 1997, 528-537, XP009061586.
Blakeley, J.A. et al., “Microsoft Universal Data Access Platform”,SIGMOD, 1998, 502-503.
Fuhr, N. et al., “A Probabilistic Relational Algebra for the Integration of Information Retrieval and Database Systems”,ACM Transactions on Information Systems, 1997, 15(1), 32-66.
Kennedy, A. et al., “Design and Implementation of Generics for the .Net Common Language Runtime”,PLDI, 2001, 1-12.
Nakano, R., “Translation with Optimization from Relational Calculus to Relational Algebra Having Aggregate Functions”,ACM Transactions on Database Systems, 1990, 15(4), 518-557.
Cunningham Conor
Sezgin Beysim
Venkatesh Ramachandran
Alam Hosian T
Microsoft Corporation
Saeed Usmaan
Woodcock & Washburn LLP
LandOfFree
System and method for efficient evaluation of a query that... does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with System and method for efficient evaluation of a query that..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and System and method for efficient evaluation of a query that... will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-4128607