Portal de Periódicos da CAPES

Oracle APEX as a Tool for Data Analytics

2024; Springer International Publishing; Linguagem: Inglês

10.1007/978-3-031-60328-0_20

2367-3370

Ivan Pastierik,

Big Data and Business Intelligence

In the contemporary landscape of data-driven decision-making, data analytics plays a crucial role in extracting meaningful insights from extensive datasets. Oracle Application Express (APEX) emerges as a robust platform for data analytics, offering a low-code environment that facilitates the development of powerful applications. Oracle APEX's declarative approach expedites the development cycle, allowing for swift creation tailored to specific data analytics needs. The seamless integration of Oracle APEX with the Oracle Database ensures optimal performance, security, and scalability for data-intensive applications, laying a robust foundation for analytics. This narrative explores the foundational aspects of Oracle APEX and its integration with the Oracle Cloud. Oracle APEX's data-centric design, customization capabilities, and support for RESTful APIs enhance its relevance in data analytics. The Oracle Cloud integration introduces unparalleled scalability, security, and performance optimization. The collaboration extends to Oracle Autonomous Database, an intelligent solution leveraging machine learning for autonomous operation, minimizing the workload on administrators. The practical application of Oracle APEX in climate anomaly detection exemplifies its analytical capabilities. By showcasing a real-world Climate Anomaly Detection Application, this narrative demonstrates how Oracle APEX analyzes historical weather data, identifies anomalies, and visualizes insights through interactive dashboards. The application's principle is grounded in standardized data and boxplot analysis, ensuring accessibility and effectiveness in anomaly detection. The inclusion of Oracle Cloud Infrastructure Services and advanced analytics tools further enhances Oracle APEX's capabilities, making it a versatile tool for data analysis in various domains.