Patent ID: 8055609
Filing Date: 2011-11-08
Classification: G06F

Abstract:
1. A method for updating a data warehouse comprising: identifying, by a computer, a raw key for each fact entry in a data warehouse, said data warehouse including call center data, said data warehouse having a fact table and a set of dimensions, each dimension in said set of dimensions corresponding to a predetermined schema said raw key including problem ticket identifiers; mapping, by the computer, said each dimension in said set of dimensions directly to the fact table using said raw key; for said each dimension in said set of dimensions, batch deleting records subject to an update, based on said raw key; for said each dimension in said set of dimensions, bulk loading new records into a corresponding dimension table, based on said raw key, said bulk loading comprising relational database management system bulk loading, said dimension table comprising a set of attributes said set of attributes includes at least one of the following attributes: agent, status, opening and closing times, opening and closing dates, and call logs; bulk loading said new records into said fact table, based on said raw key, wherein said predetermined schema is selected from a group of schemas consisting of: measures, facts, star, snowflake, and newfact schema; and in response to bulk loading said new records performing: when the predetermined schema is a snowflake schema, detecting and bulk deleting any unlinked rows; and when the predetermined schema is a measures, facts, star, or newfact schema, populating said fact table and a primary key dimension.