Data warehouse which is accessed by a user using a schema of virtual tables

A method for providing access to information stored in a database warehouse, the method comprising the steps of:

• (a) arranging data in data tables within the database warehouse;
• (b) providing to a user, by a warehouse database hub interface, a schema of the data in the database warehouse, the schema consisting of virtual tables, wherein arrangement of the data in the virtual tables is different than arrangement of the data in the data tables, and wherein the user is allowed access to the data in the data tables only through the schema consisting of the virtual tables;
• and,
• (c) in response to a query from the user for particular information stored in the database warehouse, the query being based on the schema provided by the warehouse database hub interface, performing the following substeps by the warehouse database hub interface:
• (c.1) receiving, by the warehouse database hub interface, the query from the user before the query is forwarded to the database warehouse,
• (c.2) modifying, by the warehouse database hub interface, the query to take into account the arrangement of the data within the database warehouse
• (c.3) querying, by the warehouse database hub interface, the database warehouse using the modified query to obtain the particular information from the database warehouse, and
• (c.4) forwarding the particular information obtained from the database warehouse to the user.