Explore chapters and articles related to this topic
Tools of the Trade
Published in Gideon Samid, Computer-Organized Cost Engineering, 2020
Oracle is highly relational and implements the complete SQL that is the standard data manipulation language in the industry. Around SQL, Oracle offers a rich set of utilities or productivity tools that provide for easy design of forms, screens, calculations performed over stored data, and some formatted reports. Internal utilities include “automatic navigation” (or “query optimize”) which optimizes data retrieval. A crack programmer is likely to outdo the automatic mode, but most programmers will break even at best.2
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.
Design of intelligent manufacturing system based on digital twin for smart shop floors
Published in International Journal of Computer Integrated Manufacturing, 2023
Mengke Sun, Zongyan Cai, Ningning Zhao
In the information interaction network architecture, OPC UA server is embedded in field devices such as programmable control devices, sensors RFIDs, QR code and bar code readers. In order to improve the generality of data, OPC UA server converts the format of real-time data into XML format after gathering them. After data management and logical operation, OPC UA client provides corresponding services. When SCADA system obtains data, it adopts the concept of joint server and client, that is, SCADA system provides data for information systems and digital twin system as a server up and obtains data from the lower proxy server as a client down. These real-time data are stored in digital twin database after cleaning, filtering, integrating and mining. MySQL database, Oracle database or Microsoft SQL Server with the ability to read and generate XML data can be used as digital double databases. The simulation software or intelligent algorithms are used to drive the digital twin models simulation of various elements for further analysis and decision making. CAPP system, MES, ERP system and other upper application systems accept decision results to update current process information, planning and scheduling information and monitoring information.
A fresh approach for hybrid SQL/NoSQL database design based on data structuredness
Published in Enterprise Information Systems, 2018
For the needs of testing, hardware was used with quad-core Intel i7 processors, 2.9 GHz, with 16GB RAM and SSD HDDs where the entire system was placed including the databases. For the SQL database, Oracle Enterprise Edition 12c was used, and document-based MongoDB 3.4 was used for NoSQL database. As for performance measurement criteria, a total requirement execution time was chosen, more specifically the time for the application to open a connection to the database (if it has not been established yet) and the time to obtain the result of the executed statements over the database. The described course corresponds to the way applications of information system communicating with the database. For measuring the total time expenditure, NetBeans IDE 8.0.2 (Integrated Development Environment) was used. Even though there are specialized tools to measure the performance of the database management systems, like HammerDB (HammerDB 2017), NetBeans IDE was chosen because of its ability to calculate named costs of execution entire operation.