John Bair - Superior CO Charles M Bender - Rancho Santa Margarita CA
Assignee:
Amazon. com - Seattle WA
International Classification:
G06F 1730
US Classification:
707 3
Abstract:
A system and method selects rows from a fact table in a dimensional database containing a fact table, a time dimension table and other dimension tables. The other dimension tables each contain rows containing a time invariant attribute to identify an item described by the row, an effective time attribute for the row, and other attributes. If an attribute for an item changes, a new row is added to the dimension table containing the time-invariant attribute for the item and current attributes for the item, without deleting or overwriting any existing rows for that item. Such dimension tables can be selected or used to create other tables using one or more time attributes of the dimension tables. The tables created can be selected or used to create still other tables using one or more time attributes of those tables. One or more of the resulting tables or one or more tables created from a resulting table are then joined to a table in the dimensional database or a table created from a table in the dimensional database.
System And Method For Selecting Rows From Dimensional Databases Having Temporal Dimention
John Bair - Superior CO Charles M Bender - Rancho Santa Margarita CA
Assignee:
Amazon.com, Inc. - Seattle WA
International Classification:
G06F 1730
US Classification:
707 3
Abstract:
A system and method selects rows from a fact table in a dimensional database containing a fact table, a time dimension table and other dimension tables. The other dimension tables each contain rows containing a time invariant attribute to identify an item described by the row, an effective time attribute for the row, and other attributes. If an attribute for an item changes, a new row is added to the dimension table containing the time-invariant attribute for the item and current attributes for the item, without deleting or overwriting any existing rows for that item. Such dimension tables can be selected or used to create other tables using one or more time attributes of the dimension tables. The tables created can be selected or used to create still other tables using one or more time attributes of those tables. One or more of the resulting tables or one or more tables created from a resulting table are then joined to a table in the dimensional database or a table created from a table in the dimensional database.
Name / Title
Company / Classification
Phones & Addresses
Charles Bender Owner
Bender's Bed & Breakfast Hotels
(907)6754329, (907)6754329
Charles Bender President
BENDER'S OIL SERVICE, INC Ret Fuel Oil Dealer Gasoline Service Station
Magee Womens Hospital Of UPMC Neonatology 300 Halket St, Pittsburgh, PA 15213 (412)6414111 (phone), (412)6415313 (fax)
Languages:
English
Description:
Dr. Bender works in Pittsburgh, PA and specializes in Neonatal-Perinatal Medicine. Dr. Bender is affiliated with Magee Womens Hospital Of UPMC and UPMC Mercy.
Philadelphia, PA St. Paul, MN Detroit, MI Chicago, IL Cincinnati, OH
Education:
Walnut Hills High School, Macalester College, Pratt Institute
Relationship:
Married
Charles Bender
Work:
Charles Bender and Company - Owner (1991) Irion Company Furniture Makers - Head of case and chair production, responsible for everything - authorized to do nothing (1982-1991)
About:
I am Charles (Chuck) Bender, woodworker and period furniture maker. I am also the lead mentor, and one of the founding partners, of the Acanthus Workshop, LLC, a school for fine craftsmanship. I live,...