DML statements for densifying data

Details DML statements for densifying data DML statements for densifying data

2008-04-08

2008-04-08

Alam, Shahid (Department: 2162)

Data processing: database and file management or data structures

Database design

Data structure types

C707S793000

Reexamination Certificate

active

07356542

ABSTRACT:
A method and apparatus for densification of data is provided. A method and apparatus for including a construct for partitioning data within a DML statement is provided. The construct for partitioning data may not necessarily perform a densification of data, and the densification of data may not necessarily include a construct for partitioning data. In an embodiment, the syntax of an OUTER JOIN is extended to include a PARTITION BY construct that may be used for data densification.

REFERENCES:
patent: 5423035 (1995-06-01), DePrez
patent: 5557791 (1996-09-01), Cheng et al.
patent: 5905985 (1999-05-01), Malloy et al.
patent: 5991754 (1999-11-01), Raitto et al.
patent: 6073134 (2000-06-01), Shoup et al.
patent: 6112198 (2000-08-01), Lohman et al.
patent: 6298342 (2001-10-01), Graefe et al.
patent: 6345272 (2002-02-01), Witkowski et al.
patent: 6397204 (2002-05-01), Liu et al.
patent: 6397214 (2002-05-01), Rogers
patent: 6446063 (2002-09-01), Chen et al.
patent: 6625593 (2003-09-01), Leung et al.
patent: 6665663 (2003-12-01), Lindsay et al.
patent: 2002/0078018 (2002-06-01), Tse et al.
patent: 2002/0194163 (2002-12-01), Hopeman et al.
patent: WO 2005/020105 (2005-03-01), None
Codd, E. F., et al., “Extending the Database Relational Model to Capture More Meaning”, ACM Transactions on Database Systems, vol. 4, No. 4, Dec. 1979, pp. 397-434.
Theodoratos, Dimitri, et al., “Heuristic Optimization of OLAP Queries in Multidimensionally Hierarchically Clustered Databases”, DOLAP '01, Atlanta, GA, Nov. 9, 2001, pp. 48-55.
Hurtado, Carlos A., et al., “Updating OLAP Dimensions”, DOLAP '99, Kansas City, MO,® 1999, pp. 60-66.
Nemic, Jaromir D.B., “Partitioned Outer Join”, Jul. 1, 2004, pp. 1-7 (downloaded from: www.db-nemec.com/Partitioned—outer—join.html).
International Preliminary Report on Patentability from PCT Patent Application No. PCT/US2004/027406 (13 pgs.), Aug. 19, 2004.
International Search Report and Written Opinion from PCT Patent Application No. PCT/US2004/027406 (13 pgs.), Dec. 13, 2004.
Current Claims in PCT Patent Application No. PCT/US2004/027406 (8 pgs), Feb. 15, 2005.
Witkowski, A., et al. “Spreadsheets in RDBMS for OLAP” Proceedings of the ACM SIGMOD 2003 Conference, Jun. 9, 2003, pp. 52-63.
Gupta, A., et al. “Data Densification in a Relational Database System” Proceedings of the ACM SIGMOD 2004 Conference, Jun. 13, 2004, entire document.
Graefe, G. “Query Evaluation Techniques For Large Databases” ACM Computing Surveys USA, vol. 25, No. 2, Jun. 1993, pp. 73-170.
Chaudhuri, S., et al. “An Overview Of Data Warehousing And OLAP Technology” SIGMOD Record, SIGMOD, New York, NY, US, vol. 26, No. 1, Mar. 1997, pp. 65-74.
Jaedicke, Michael, et al. “User-Defined Table Operators: Enhancing Extensibility for ORDBMS” Proceedings of 25thVLDB Conference, Edinburgh, Scotland, Sep. 7, 1999, pp. 494-505.
Chaudhuri, S., “An Overview Of Query Optimization In Relational Systems” Proceedings of the 17thACM SIGACT-SIGMOD-SIGART Symposium on Principles of Database Systems, PODS 1998, Seattle, WA, Jun. 1-3, 1998; Proceedings of the ACM SIGACT-SIGMOD-SIGART Symposium on Principles of Database Systems, New York, NY, Jun. 1, 1998, pp. 34-43.

Affiliated with

Also associated with

Rating

DML statements for densifying data does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with DML statements for densifying data, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and DML statements for densifying data will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-2773706