This investigation examined the value of using Apache MADlib for analytical operations versus developing functions and procedures for the same purpose using PL/SQL. Several functions were chosen arbitrarily from the MADlib repository. After implementation for each function was complete, performance testing was conducted to examine the accuracy and runtime of each PL/SQL function against its MADlib counterpart. Results showed using MADlib can be significantly advantageous for through data processing compared to direct implementation. Manually implementing analytical functions could be efficient for smaller queries however as the sample size increases MADlib handled the queries much more effectively.

• This report represents the work of one or more WPI undergraduate students submitted to the faculty as evidence of completion of a degree requirement. WPI routinely publishes these reports on its website without editorial or peer review.

Creator

• Amevor, Justin
• Patterson, Tyrone Victor
• Lyu, Junyu
• Schmidt, Bailey Ryan

Publisher

• Worcester Polytechnic Institute

Identifier

• E-project-033020-183038

Advisor

• Eltabakh, Mohamed Y.

Year

• 2020

Date created

• 2020-03-30

Resource type

• Major Qualifying Project

Major

• Computer Science

Rights statement

• In Copyright