Entity-based business intelligence

Details Entity-based business intelligence Entity-based business intelligence

2011-07-12

2011-07-12

Robinson, Greta L (Department: 2169)

Data processing: database and file management or data structures

Database and file access

Preparing data for information retrieval

Reexamination Certificate

active

07979436

ABSTRACT:
A method is disclosed for conducting a query to transform data in a pre-existing database, the method comprising: collecting database information from the pre-existing database, the database information including inconsistent dimensional tables and fact tables; running an entity discovery process on the inconsistent dimensional tables and the fact tables to produce entity mapping tables; using the entity mapping tables to resolve the inconsistent dimensional tables into resolved dimensional tables; and running the query on a resolved database to obtain a query result, the resolved database including the resolved dimensional table.

REFERENCES:
patent: 6519604 (2003-02-01), Acharya et al.
patent: 6574623 (2003-06-01), Leurg et al.
patent: 6775662 (2004-08-01), Witkowski et al.
patent: 6775681 (2004-08-01), Ballmkonda et al.
patent: 6775682 (2004-08-01), Ballmkonda et al.
patent: 7035843 (2006-04-01), Ballmkonda et al.
patent: 2003/0184811 (2003-10-01), Overton
patent: 2004/0210763 (2004-10-01), Jonas
patent: 2005/0027690 (2005-02-01), Zhang et al.
patent: 2006/0020619 (2006-01-01), Netz et al.
Andritsos et al., “Clean Answers over Dirty Databases: A Probabilistic Approach,” Proceedings of the 22nd International Conference on Data Engineering, published Apr. 3, 2006.
Office Action from U.S. Appl. No. 11/771,668 dated Sep. 30, 2009.
Arenas et al. “Scalar Aggregation in Inconsistent Databases” Theoretical Computer Science, ICDT 2001 Department of Computer Science and Engineering, University of Buffalo, Buffalo NY.
Fuxman et al. “ConQuer: Efficient Management of Inconsistent Databases” SIGMOD Jun. 14-16, 2005 Baltimore, Maryland Copyright 2005 ACM.
Fuxman A et al: “ConQuer: Efficient Management of Inconsistent Databases” Proceedings of the 2005 ACM SIGMOD International Conference on Management of Data, [Online] Jun. 14, 2005-Jun. 16, 2005 pp. 155-166, XP002489781 Baltimore, Maryland, USA ISBN: 1-59593-060-4 Retrieved from the Internet: URL:http://portal.acm.org/citation.cfm?doi d=1066176> [retrieved on Jul. 24, 2008] the whole document.
Ananthakrishna R et al: “eliminating Fuzzy Duplicates in Data Warehouses” VLDB2002, 2002, XP008094697 Hong Kong, China the whole document.
Patent Cooperation Treaty International Search Report and the Written Opinion Aug. 7, 2008.

Affiliated with

Also associated with

Rating

Entity-based business intelligence does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Entity-based business intelligence, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Entity-based business intelligence will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-2699942