US Patent 9734230 Cross system analytics for in memory data warehouse

A cross system analytics system includes sets of in memory database tables stored on random access memory of the system. Each set of tables corresponds to data from a different source system to provide separation of data from each source system. A separate in memory database schema for each set of tables corresponds to each source system. A replication system is coupled to provide replication of data from the source systems into the sets of in memory database tables. An analytics engine executes cross system views of data in the sets of tables to provide a cross system central and consistent view for reporting and analyzing data for an organization having multiple systems with different database schemas.