R-PMA: Rapid & Efficient Statistical Reporting on Heterogeneous Resources
Abdul Rehman, Jian Liu, Muhammad Qasim Yasin, Ahmed Mateen, Keqiu Li · 2020
In contemporary organizations, different units of the corporation use a diverse system to produce, save, and search their important data. However, these enterprises synchronize the diversified data of these different systems to understand the full value of the data. Data federation is an approach to integrate the data of heterogeneous data sources. R-PMA is a web-based reporting tool, that federates the heterogeneous data sources e.g. RDF, Relational Databases, and text data in different formats. R-PMA imports all features of datasets and builds interactive reports, based on the imported data resources. It can interact with sparkR for statistical analysis of large datasets. R- PMA also provides an SQL interface to query SparkSQL and MySQL for procuring the required information for reporting. Finally, we have developed it as a plugin in PHPMy Admin to facilitate the organizations that have been using rational databases for years.