Pragma facility and SQL3 extension for optimal parallel UDF exec

Details Pragma facility and SQL3 extension for optimal parallel UDF exec Pragma facility and SQL3 extension for optimal parallel UDF exec

1997-09-30

2000-05-23

Black, Thomas G.

Data processing: database and file management or data structures

Database design

Data structure types

707104, 707103, 707102, G06F 1730

Patent

active

06067542&

ABSTRACT:
A method, apparatus, and article of manufacture for a computer implemented query optimizer. A query is to be executed containing user defined functions and abstract data type parameters to retrieve data from a database. Optimization information is received from a user. Then, the execution of the query is optimized based on the received optimization information for execution within a massively parallel, shared nothing architecture.

REFERENCES:
patent: 5325525 (1994-06-01), Shan et al.
patent: 5504894 (1996-04-01), Ferguson et al.
patent: 5754841 (1998-05-01), Carino, Jr.
patent: 5765147 (1998-06-01), Mattos et al.
patent: 5794250 (1998-08-01), Carino, Jr. et al.
patent: 5799310 (1998-08-01), Anderson et al.
patent: 5806061 (1998-09-01), Chaudhuri et al.
patent: 5845113 (1998-12-01), Swami et al.
patent: 5850550 (1998-12-01), Li et al.
patent: 5857180 (1999-01-01), Hallmark et al.
patent: 5864843 (1998-01-01), Carino, Jr. et al.
patent: 5873075 (1997-06-01), Cochrane et al.
patent: 5873083 (1999-02-01), Jones et al.
patent: 5930786 (1999-07-01), Carino et al.
patent: 6006235 (1999-12-01), Macdonald et al.
Sudhir R. Ahuja, et al. --"Multimedia Collaboration," AT&T Technical Journal, Sep./Oct. 1995, pp. 46-53.
Shaku Atre, et al. --"Data Distribution and Warehousing," Enterprise Client/Server DBMS, Oct. 1995, pp. 54-62.
Alexandros Biliris, et al., AT&T Bell Laboratories, Murray Hill, NJ 07974 --"A High Performance Configurable Storage Manager," IEEE, 1995, pp. 35-43.
Felipe Carino, Jr., "HETERO--Heterogeneous DBMS Frontend", Office Systems: Methods and Tools, Elsevier Science Publishers B.V. (North-Holland), IFIP 1987, Oct. 1986, pp. 159-171.
Felipe Carino, Jr., et al., "Industrial Database Supercomputer Exegesis--The DBC/1012, The NCR 3700, The Ynet.TM. and The BYNET.TM.," IEEE Computer Society Press, Database Machine Exegesis, pp. 1-17 (no date).
Felipe Carino, Jr., et al., "MOONBASE--A Complete Multimedia Database Solution," ACM Multimedia Workshop on Multimedia Databases, San Francisco, CA Oct. 21, 1994, 10 pages.
E. F. Codd, "A Relational Model of Data for Large Shared Data Banks," Communications of the ACM, vol. 13, No. 6, Jun. 1970, pp. 377-387.
Michael R. Genesereth, et al., "Software Agents", Communications of the ACM, Special Issue on Intelligent Agents, vol. 37, No. 7, Jul. 1994, pp. 48-53.
Dr. Richard Hackathorn, "Data WAREHOUSING Energizes Your Enterprise," Datamation, Feb. 1, 1995, pp. 38-42.
Howard P. Katseff, et al., "Predictive Prefetch in the Nemesis Multimedia Information Service," Proceedings of ACM Multimedia, San Francisco, CA, Oct. 1994, pp. 201-209.
Nikos Koudas, et al., "Declustering Spatial Databases on a Multi-Computer Architecture," Proceedings Extending Database Technology, France, Mar. 1996, pp. 592-614.
Mary E.S. Loomis, Ph.D., "Moving Objects into Relational Systems," Database World, Boston, Jun. 14, 1993, pp. D5-1-D5-15.
W. O'Connell, et al., "A Teradata Content-Based Multimedia Object Manager for Massively Parallel Architectures," ACM-SIGMOD, Montreal, Canada, Jun. 1996, pp. 68-78.
William O'Connell, et al., "The Teradata SQL3 Multimedia Database Server," Technology for Multimedia, IEEE Press, Dec. 1996, pp. 217-252.
Warren Sterling, et al., "Multimedia Databases and Servers," AT&T Tecnical Journal, Sep./Oct. 1995, pp. 54-67.
Michael Stonebraker, "The Case for Shared Nothing," IEEE Data Engineering Bulletin, vol. 9, No. 2, 1986, pp. 4-9.
Michael Ubell, "The Montage Extensible DataBlade.TM. Architecture," Proceedings of ACM-SIGMOD, vol. 23, No. 2, Jun. 1994, p. 482.
Murali Venkatrao, et al., "SQL/CLI--A New Binding Style for SQL," ACM-SIGMOD Record, vol. 24, No. 4, Dec. 1995, pp. 72-77.

Affiliated with

Also associated with

Rating

Pragma facility and SQL3 extension for optimal parallel UDF exec does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Pragma facility and SQL3 extension for optimal parallel UDF exec, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Pragma facility and SQL3 extension for optimal parallel UDF exec will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-1843981