1. A virtual data warehouse, comprising: a plurality of virtual tables each comprising at least one virtual record with accompanying virtual fields corresponding to at least one record and fields located in at least one remote database table or file system; a plurality of local hyper-keys identifying unique virtual fields within the plurality of virtual tables; and, a plurality of foreign hyper-keys that link virtual records to the plurality of local hyper-keys.