System and method of client server aggregate transformation

Details System and method of client server aggregate transformation System and method of client server aggregate transformation

2004-05-27

2008-09-23

Abel-Jalil, Neveen (Department: 2165)

Data processing: database and file management or data structures

Database design

Data structure types

C707S793000, C707S793000

Reexamination Certificate

active

07428532

ABSTRACT:
A system for transforming client/server aggregates is provided. The system comprises a client/server analysis component for analyzing one or more queries that are not supported by a target database system, and a client/server transformation component for transforming the one or more queries into semantically equivalent queries that are supported by the target database system.

REFERENCES:
patent: 5963936 (1999-10-01), Cochrane et al.
patent: 6009432 (1999-12-01), Tarin
patent: 6341281 (2002-01-01), MacNicol et al.
patent: 6345272 (2002-02-01), Witkowski et al.
patent: 6370524 (2002-04-01), Witkowski
patent: 6438537 (2002-08-01), Netz et al.
patent: 6519604 (2003-02-01), Acharya et al.
patent: 6609123 (2003-08-01), Cazemier et al.
patent: 6651055 (2003-11-01), Kilmer et al.
patent: 6847962 (2005-01-01), Cochrane et al.
patent: 6985895 (2006-01-01), Witkowski et al.
patent: 7133865 (2006-11-01), Pedersen et al.
patent: 7315849 (2008-01-01), Bakalash et al.
patent: 2002/0087524 (2002-07-01), Leathers
patent: 2003/0115194 (2003-06-01), Pitts et al.
patent: 1 081 611 (2001-03-01), None
patent: WO 03/012698 (2003-02-01), None
Holger Schwarz et al. Improving the Processing of Decision Support Queries: Strategies for a DSS Optimizer. Technical Report.University Stuttgart. Germany. May 2001.
Hamid Pirahesh et al. A Rule Engine for Query Transformation in Starburst and IBM DB2 C/S DBMS. IEEE 1997.
SQL/OLAP: Powerpoint presentation by Sang-Won Lee Jul. 12, 2001.http://vldb.skku.ac.kr/vldb/talk/sql-olap.ppt.
Zemke et al. Introduction to OLAP functions. www.ncb.ernet.in/education/modules/dbms/SQL99/OLAP-99-154r2.pdf Pub. May 5, 1999.
Schwarz, H. et al: “Improving the processing of Decision Support queries: The case for a DSS Optimizer” Proceedings, International Database Engineering and Applications Symposium, Jul. 16, 2001, pp. 177-186, XP002275210.
Retrieved from the Internet; Oracle Technology Network—Discussion Forums; ′Online!; Oct. 11, 2002.
Winter, R: “SQL-99's New OLAP Functions” Intelligent Enterprise Magazine, ′Online!; vol. 3, No. 2, Jan. 20, 2000 XP002337528.
Ross, K.A. et al.: “Complex Aggregation at Multiple Granularities” Lecture Notes in Computer Science, ′Online! vol. 1377, 1998, XP002337531.
Chiou A.S., et al: “Optimization for queries with holistic functions” Database Systems for Advanced Applications, 2001, Piscataway, NJ, USA, IEEE, Apr. 18, 2001, pp. 327-334. XP010538590.
EPO Search Report Aug. 8, 2005 Application No. 04076566.1-2201 PCT.

Affiliated with

Also associated with

Rating

System and method of client server aggregate transformation 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 of client server aggregate transformation, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and System and method of client server aggregate transformation will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-3974603