Method and system for detecting tables to be modified

Details Method and system for detecting tables to be modified Method and system for detecting tables to be modified

2006-09-26

2006-09-26

Alam, Shahid (Department: 2162)

Data processing: database and file management or data structures

Database design

Data structure types

C707S793000, C707S793000, C707S793000, C707S793000, C707S793000, C707S793000, C707S793000

Reexamination Certificate

active

07113951

ABSTRACT:
In an MD schema definition modifying process for specifying tables to be modified in terms of addition of columns or the like when modification such as addition of a dimension is applied to an MD schema in a BI system having a fixed model such as a data model, tables to be modified in terms of addition of columns or the like are specified on the basis of information of modification such as addition of the dimension to the MD schema. In an extraction process of modification candidate tables, all combinations of tables and columns to be modified in terms of addition of columns or the like are output. In a decision process of modification target tables, a combination of tables to be modified can be output.

REFERENCES:
patent: 5717924 (1998-02-01), Kawai
patent: 5724575 (1998-03-01), Hoover et al.
patent: 5870743 (1999-02-01), Cohen et al.
patent: 5930799 (1999-07-01), Tamano et al.
patent: 6161103 (2000-12-01), Rauer et al.
patent: 6484179 (2002-11-01), Roccaforte
patent: 6714935 (2004-03-01), Delo
patent: 6847973 (2005-01-01), Griffin et al.
Bonifati et al.; Dseigning Data Marts for Data Warehouses; ACM vol. 10, No. 4, Oct. 2001, pp. 452-483.
Tolkin et al.; Aggregation Everywhere: Data reduction and transformation in the Phoenix dada Warehouse; ACM 1999, pp. 79-86.
Buchner et al.; Discovering Internet Marketing Intelligence through Online Analytical Web Usage Mining; Sigmod Record, vol. 27, Dec. 1998, pp. 54-61.
Sena et al.; Intellegence systems: a sociotechnical system perspective; ACM 1999, pp. 86-93.
Eick et al.; Visualizing multi-dimensional data; AM 200, pp. 61-67.
Markl et al.; Improving OLAP performance by multidimensional hierarchical clustering; IEEE 1999, pp. 165-177.
Teorey et al.; A Logical Design methodology for Relational Databases Using the Extended Entity-Relationship Model; ACM 1986, pp. 197-222.
Hurtado et al.; Updating OLAP Dimensions; ACM 1999, pp. 60-66.
Agrawal et al.; Automatic Subspace Clustering of High Dimensional Data Mining Applications; ACM 1998, pp. 94-105.
Chandra et al.; Data Distribution Support on Distributed Shared Memory Multiprocessors; ACM 1997, pp. 334-345.
Hasan et al.; Approaches to the Development of Multi-Dimensional Databases: Lessons from Four Case Studies; The Data Base for Advances in Information Systems 2000 vol. 31, No. 3, pp. 10-23.
Yocca Michael, Obtaining Record Counts; SQL Server Magazine, 1999, pp. 1-4.
Oracle, Database Concepts, 1996/2002, Oracle, Oracle 9i 2(9.2), pp. 1-51.
E. Thomsen, et al., Microsoft OLAP solutions, John Wiley & Sons, Inc., 1999, pp. 1-3.
M. Whitehorn, et al., Business Intelligence: The IBM Solution, Springer, 1999, pp. 10-11.
IBM StartNow Solutions for e-business, 2002, pp. 1-3.
Oracle9i Warehouse Builder iDS 2.0, 2002 pp. 1-5.

Affiliated with

Also associated with

Rating

Method and system for detecting tables to be modified does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Method and system for detecting tables to be modified, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Method and system for detecting tables to be modified will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-3530070