De-engineered real-time data-warehouse innovate visionary functionalities