Student Work

 

In-Database Analytics Public

Downloadable Content

Download PDF

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.

Creator
Publisher
Identifier
  • E-project-033020-183038
Advisor
Year
  • 2020
Date created
  • 2020-03-30
Resource type
Major
Rights statement
License

Relationships

In Collection:

Items

Permanent link to this page: https://digital.wpi.edu/show/0r9676338