Method to select an efficient access path to a remote database
Original Publication Date: 2004-Nov-26
Included in the Prior Art Database: 2004-Nov-26
Database federation provides users with a virtual data warehouse, without necessarily moving any of the data. A virtual table on the federated database is used to let the users access to remote data sources in heterogeneous database environment. When multiple paths which lead a user to one and the same data source exist in the environment above, this invention makes it possible to identify the shortest path. The shortest path is selected by checking the virtualization index, which represents the number of the virtual tables on each path.