|International Journal of Computer Applications
|Foundation of Computer Science (FCS), NY, USA
|Volume 183 - Number 31
|Year of Publication: 2021
|Authors: Jimmy Z. Bantog, Luisito Lolong Lacatan, Mary Ann F. Quioc
Jimmy Z. Bantog, Luisito Lolong Lacatan, Mary Ann F. Quioc . Cross-Platform Relational Data Extraction Utilizing SQL Server (X-PRESS). International Journal of Computer Applications. 183, 31 ( Oct 2021), 34-41. DOI=10.5120/ijca2021921703
The use of data is vital to the advantage and success of every company and businesses. However, querying, extracting and analyzing data from cross-platform relational databases in just a single run without the need for programming is very challenging. While this process can be done manually, it requires more resources, very time consuming and prone to error. This also involves the use of different tools and lots of consolidation. Data are coming from multi-platform applications, from open source or proprietary software, from different operating systems, from different relational database management systems, from different servers and from any location within the organization. Data are complex that requires it to be processed, stored and managed in several ways. There is a need for a solution that can analyze through the company’s different data sources and allowing users to perform queries. Analyzing data is best performed with the use of tools that facilitates efficient data exploration and better querying. This study finds its way to the development of a single tool that is capable of exploring, analyzing and transforming data into information regardless of its environment and configuration and makes it available to everyone. This all-in-one database querying tool provides the facility for accessing data from any cross-platform database across the network via SQL Server linked server connection through distributed and heterogeneous query execution. This tool commonly known as X-PRESS is built on top of a framework based on dynamic creation of entities and attributes and utilizes the power of Structured Query Language. Connection to data is more secure and took advantage of server processing power thus making this tool faster and more suitable for data analysis. X-PRESS is the acronym of Cross-Platform Relational Data Extraction Utilizing SQL Server. “X-P” derives from Cross-Platform while “RESS” is the initial of the keywords Relational Data, Extraction, SQL and Server, respectively.