Database generation systems and methods

Details Database generation systems and methods Database generation systems and methods

2005-03-08

2010-11-30

Wu, Yicun (Department: 2169)

Data processing: database and file management or data structures

Data warehouse, data mart, online analytical processing ,...

Tools to automate schema definition process

C707S605000, C707S606000, C707S803000

Reexamination Certificate

active

07844570

ABSTRACT:
The subject invention pertains to systems and methods that facilitate generation of a database to support a multidimensional model. A database schema is generated in a top-down fashion. In particular, multidimensional structures and attributes such as cubes and dimensions can be defined. From such definition, a proposed database schema can be produced. This schema can subsequently be modified prior to or after populating the database. For example, a table or column could be added. Thereafter, the cubes and dimensions could be altered and a modified schema generated that preserves changes made to the schema. Accordingly, the subject systems and methods disclose an iterative approach that supports both top-down and bottom-up multidimensional database design.

REFERENCES:
patent: 5937410 (1999-08-01), Shen
patent: 6205447 (2001-03-01), Malloy
patent: 6233583 (2001-05-01), Hoth
patent: 6377934 (2002-04-01), Chen et al.
patent: 6434557 (2002-08-01), Egilsson et al.
patent: 6473750 (2002-10-01), Petculescu et al.
patent: 6651055 (2003-11-01), Kilmer et al.
patent: 7062479 (2006-06-01), Edmunds et al.
patent: 2002/0116389 (2002-08-01), Chen et al.
patent: 2003/0208468 (2003-11-01), McNab et al.
patent: 2003/0225736 (2003-12-01), Bakalash et al.
patent: 2004/0044671 (2004-03-01), Yoshimura et al.
patent: 2004/0123048 (2004-06-01), Mullins et al.
patent: 2004/0181518 (2004-09-01), Mayo et al.
patent: 2004/0193567 (2004-09-01), Dettinger et al.
patent: 2005/0049831 (2005-03-01), Lilly
patent: 2005/0071737 (2005-03-01), Adendorff et al.
patent: 2005/0216831 (2005-09-01), Guzik et al.
patent: 2005/0228818 (2005-10-01), Murthy et al.
patent: 2005/0256896 (2005-11-01), Pfeifer et al.
patent: 2006/0010164 (2006-01-01), Netz
patent: 2006/0020933 (2006-01-01), Pasumansky
Microsoft BI Accelerator Overview, Chapter 1, Published: Jul. 10, 2002, 17 pages plus coversheet www.microsoft.com/sql/prodinfo/previousversions/ssabi/ch1overview.mspx.
Microsoft SQL 2000 Technical Articles, Analysis Services: Choosing Dimension Types in SQL Server 2000 Analysis Services, Published: Jul. 2000, 18 pages.
SQL Server Accelerator for BI Overview. http://www.microsoft.com/sql/prodinfo/previousversions/ssabi/overview. mspx. Jun. 24, 2003, Last accessed Mar. 27, 2006. 4 pages.
MSDN Library, SQL Server 2000, Analysis Services (Analysis Services SQL Server). http://msdn.microsoft.com/ library/en-us/olapdmad/aggettingstart—80xj.asp?frame=true. 2006 Microsoft Corporation. Last accessed Mar. 27, 2006. pp. 1-101.
MSDN Library, SQL Server 2000, Analysis Services (Analysis Services SQL Server). http://msdn.microsoft.com/ library/en-us/olapdmad/aggettingstart—80xj.asp?frame=true. 2006 Microsoft Corporation. Last accessed Mar. 27, 2006. pp. 2-230.
MSDN Library, SQL Server 2000, Analysis Services (Analysis Services SQL Server). http://msdn.microsoft.com/ library/en-us/olapdmad/aggettingstart—80xj.asp?frame=true. 2006 Microsoft Corporation. Last accessed Mar. 27, 2006. pp. 231-330.
MSDN Library, SQL Server 2000, Analysis Services (Analysis Services SQL Server). http://msdn.microsoft.com/ library/en-us/olapdmad/aggettingstart—80xj.asp?frame=true. 2006 Microsoft Corporation. Last accessed Mar. 27, 2006. pp. 331-493.
Microsoft Corp., Expressions (MDX), Microsoft TechNet, SQL Server 2005 Books Online (Sep. 2007), 3 pages.
OA Dated Jan. 5, 2009 for U.S. Appl. No. 11/116,924, 49 pages.
OA Dated Dec. 29, 2008 for U.S. Appl. No. 11/050,130, 29 pages.
OA Dated Jul. 1, 2008 for U.S. Appl. No. 11/050,130, 22 pages.
Youness, “Using NDX and ADOMD to Access Microsoft OLAP Data” dated 2000.
Office Action dated May 17, 2007 cited in U.S. Appl. No. 11/050,130.
Office Action dated Nov. 1, 2007 cited in U.S. Appl. No. 11/050,130.
Office Action dated Oct. 1, 2009 cited in U.S. Appl. No. 11/050,130.
Office Action dated Sep. 4, 2007 cited in U.S. Appl. No. 11/116,924.
Office Action dated Mar. 5, 2008 cited in U.S. Appl. No. 11/116,924.
Office Action dated Dec. 8, 2009 cited in U.S. Appl. No. 11/116,924.

Affiliated with

Also associated with

Rating

Database generation systems and methods does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Database generation systems and methods, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Database generation systems and methods will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-4241863