Pragma facility and SQL3 extension for optimal parallel UDF execution
Patent 6067542 Issued on May 23, 2000. Estimated Expiration Date: September 30, 2017. Estimated Expiration Date is calculated based on simple USPTO term provisions. It does not account for terminal disclaimers, term adjustments, failure to pay maintenance fees, or other factors which might affect the term of a patent.
707/4, Query formulation, input preparation, or translation707/102, Generating database or data structure (e.g., via user interface)707/104.1Application of database or data structure (e.g., distributed, multimedia, image)
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.
Other References
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™ and The BYNET™," 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™ 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-7
September 30, 2017. Estimated Expiration Date is calculated based on simple USPTO term provisions. It does not account for terminal disclaimers, term adjustments, failure to pay maintenance fees, or other factors which might affect the term of a patent.
