The Comparison of Database Management Systems on the Speed of Analysis by Artificial Intelligence

School Name

Spring Valley High School

Grade Level

10th Grade

Presentation Topic

Computer Science

Presentation Type

Non-Mentored

Abstract

Artificial Intelligence (AI) is a common program of mathematical sequences that can conduct the calculations as if it were a human brain. Over the years, lots of attention has been focused on the development of AI due to its significance in society today. Due to the large amounts of data needed to be handled, lots of AI use database management systems (DBMS) to hold the information. The purpose of this study was to explore the effect of DBMS on AI and to determine which DBMS produce a quicker response time. It was hypothesized that PostgreSQL would show a faster response time due to it being a structured database designed to hold raw data. In order to conduct the experiment, VSCondium, a source code editor based on Microsoft VSCode was used after retrieving the AI, ImageAI. Pictures were then stored in the DBMS and analyzed and the response time of the program was recorded at the end of the script in seconds. A one-way ANOVA test and a Tukey Post HOC test were conducted and produced an F-value of 5.969123767994860 and a p-value of 0.00372172430607. The Tukey test displayed that there was a significant difference between PostgreSQL and MySQL and between MySQL and MongoDB. Therefore, it was concluded that PostgreSQL and MongoDB are similar in their capacity to hold raw data such as binary and blob data. And that PostgreSQL and MongoDB excel in storing images compared to MySQL.

Location

HSS 206

Start Date

4-2-2022 11:15 AM

Presentation Format

Oral and Written

Group Project

No

COinS
 
Apr 2nd, 11:15 AM

The Comparison of Database Management Systems on the Speed of Analysis by Artificial Intelligence

HSS 206

Artificial Intelligence (AI) is a common program of mathematical sequences that can conduct the calculations as if it were a human brain. Over the years, lots of attention has been focused on the development of AI due to its significance in society today. Due to the large amounts of data needed to be handled, lots of AI use database management systems (DBMS) to hold the information. The purpose of this study was to explore the effect of DBMS on AI and to determine which DBMS produce a quicker response time. It was hypothesized that PostgreSQL would show a faster response time due to it being a structured database designed to hold raw data. In order to conduct the experiment, VSCondium, a source code editor based on Microsoft VSCode was used after retrieving the AI, ImageAI. Pictures were then stored in the DBMS and analyzed and the response time of the program was recorded at the end of the script in seconds. A one-way ANOVA test and a Tukey Post HOC test were conducted and produced an F-value of 5.969123767994860 and a p-value of 0.00372172430607. The Tukey test displayed that there was a significant difference between PostgreSQL and MySQL and between MySQL and MongoDB. Therefore, it was concluded that PostgreSQL and MongoDB are similar in their capacity to hold raw data such as binary and blob data. And that PostgreSQL and MongoDB excel in storing images compared to MySQL.