Explore chapters and articles related to this topic
Databases
Published in Ian Foster, Rayid Ghani, Ron S. Jarmin, Frauke Kreuter, Julia Lane, Big Data and Social Science, 2020
We also see increasing use being made of cloud-hosted relational DBMSs, such as Amazon Relational Database Service (RDS; this supports MySQL, PostgreSQL, and various commercial DBMSs), Microsoft Azure, and Google Cloud SQL. These systems obviate the need to install local software, administer a DBMS, or acquire hardware to run and scale your database. Particularly if your database is bigger than can fit on your workstation, a cloud-hosted solution can be a good choice, both for scalability but also for ease of configuration and management.
Implementing a web-based optimized artificial intelligence system with metaheuristic optimization for improving building energy performance
Published in Journal of Asian Architecture and Building Engineering, 2023
Ngoc-Tri Ngo, Ngoc-Son Truong, Thi Thu Ha Truong, Anh-Duc Pham, Nhat-To Huynh
The data layer aims to collect and store data. Collected data involves energy consumption data, weather data, and building information. Data were collected by the energy metering system, sensors, and the communication network. The collected data are stored in database management systems, such as MySQL or cloud-based database services. Amazon Relational Database Service (Amazon RDS) is a managed relational database service that provides users with several database engines to select from, involving Amazon Aurora, MySQL, MariaDB, Oracle, Microsoft SQL Server, and PostgreSQL (Aws 2021b). Amazon RDS handles routine database tasks, such as provisioning, patching, backup, recovery, failure detection, and repair. Amazon RDS is a cost-efficient and resizable capacity while automating time-consuming administration tasks, such as hardware provisioning, database setup, patching, and backups. MySQL is the most widely used open-source relational database in the world and it can be easy to set up, operate, and scale MySQL deployments in the cloud by Amazon RDS (Aws 2021b). With Amazon RDS, a scalable MySQL server can be deployed in minutes with cost-efficient and resizable hardware capacity.