Karachi

ASTERI项目的主要目的是演示联机事务处理（OLTP）系统的数据库的星星模式关系数据仓库表示的自动创建。OLTP系统的数据库结构针对数据存储进行了优化，因此在获取面向分析的信息方面结构不佳。基于星星模式的解决方案针对数据检索（即创建分析）进行了优化。ASTERI项目的创新基于以下应用：a）机器学习技术，将原始OLTP数据库格式转换为数据仓库中使用的关系数据库格式。然后，数据工程师用于确认转换，而不是创建转换。B）使用基于HTML5的数据表示的事件驱动可视化。这包括对成千上万的数据点进行高效和响应式的可视化。相关的报告将反映最新的可用数据。虽然星星模式对数据仓库表示的重要性在过去的20年里已经众所周知，只是在过去的5年里，对使用“机器学习”来创建星星模式表示的研究才显示出这种方法的潜力。可以大大减少吸引新客户的工作量和成本，并可以快速创建新的行业数据库模式，使其能够扩展到新市场，并在较小的组织中获得市场份额。RAL还打算利用新工具将其新兴的OEM销售扩展到Xerox、皮特尼Bowes和Qlikview等全球主要数据分析服务提供商，作为其数据分析服务引擎。此外，自动化工具将允许使用RAL RAPid工具集为自己的客户提供价值的开发合作伙伴增加销售额

The key aim of the ASTERI project is to demonstrate the automated creation of a Star Schemarelational data warehouse representation of the database for an On-line Transaction Processing(OLTP) system. Database structures for OLTP systems are optimised for data storage and soare poorly structured for obtaining analytics-oriented information. Star Schema-basedsolutions are optimised for data retrieval i.e. the creation of analytics. Ease of access toanalytics by a wide range of users is of increasing commercial importance.The innovation in the ASTERI project is based upon the application of:a) Machine learning techniques to produce the transformation from the original OLTPdatabase format to the relational database form used in the data warehouse. The data engineeris then used to confirm a transformation as opposed to its creation.b) Event-driven visualisation using HTML5 based data presentation. This includes addressingefficient and responsive visualization of 100s of thousands of data points. The associatedreports will then reflect the latest data available.While the significance of Star Schema to data warehouse representation has been well knownfor the past 20 years, it is only in the past 5 years that research into the use of ‘MachineLearning’ to create a Star Schema representation has shown the potential of the approach.With these new capabilities Rosslyn Analytics (RAL) can substantially reduce the effort andcost to engage new customers and can rapidly create new sector database schemas enabling itto expand into new markets and gain market share with smaller organisations. RAL alsointends to leverage the new tools to expand its emerging OEM sales to major global dataanalysis service providers such as Xerox, Pitney Bowes and Qlikview to be used as their dataanalysis service engine. In addition, the automated tools will permit increased sales bydevelopment partners who use the RAL RAPid toolset to deliver value for their own clients