JAMES MCGEE PLATT
Pilots at Leon St, Austin, TX
License number
Texas A5156028
Issued Date
Nov 2013
Expiration Date
Nov 2018
Category
Airmen
Type
Authorized Aircraft Instructor
Address
Address
2502 Leon St APT 412, Austin, TX 78705
Professional information
Populating A Database Using Inferred Dependencies
US Patent:
2005000, Jan 6, 2005
Filed:
Jul 2, 2003
Appl. No.:
10/612701
Inventors:
James Platt - Austin TX, US
Assignee:
INTERNATIONAL BUSINESS MACHINES CORPORATION - ARMONK NY
International Classification:
G06F017/00
US Classification:
707100000
Abstract:
Populating a database, including providing a database having a schema; inferring from the schema dependencies among a fact table and related dimension tables; and inserting, in accordance with the dependencies, rows of data into the fact table and rows of data into the dimension tables. In typical embodiments, inferring dependencies further comprises selecting from metadata describing a schema for the database expressions of dependencies and inserting the expressions of dependencies into a dependency list. In typical embodiments, wherein inserting rows of data further comprises determining whether related dimension data exists for each foreign key in each row of data inserted into the fact table and for each foreign key for which related dimension data does not exist, inserting a row of dimension data into a dimension table related to the fact table through the foreign key.
James Platt
Location:
Austin, Texas Area
Industry:
Internet