{"id":{"repo_id":"csusb","oai_identifier":"oai:scholarworks.lib.csusb.edu:etd-2025"},"canonical_url":"https://search.ndltd.org/etd/csusb/oai:scholarworks.lib.csusb.edu:etd-2025","repository":{"repo_id":"csusb","name":"CSUniversity San Bernardino","base_url":"https://scholarworks.lib.csusb.edu/do/oai/"},"display":{"title":"EXTRACT TRANSFORM AND LOADING TOOL FOR EMAIL","abstract":"This project focuses on applying Extract, Transform and Load (ETL) operations on the relational data exchanged via emails. An Email is an important form of communication by both personal and corporate means as it enables reliable and quick exchange. Many useful files are shared as a form of attachments which contains transactional/ relational data. This tool allows a user to write the filter conditions and lookup conditions on attachments; define the attribute map for attachments to the database table. The Data Cleansing for each attribute can be performed writing rules and their matching state. A user can add custom functions for the data transformation. The aggregation of the data is done in the form of reports after the operation of data loading into the database is complete. The tool needs one-time setup per file template and its automated from that point.","abstract_html":"This project focuses on applying Extract, Transform and Load (ETL) operations on the relational data exchanged via emails. An Email is an important form of communication by both personal and corporate means as it enables reliable and quick exchange. Many useful files are shared as a form of attachments which contains transactional/ relational data. This tool allows a user to write the filter conditions and lookup conditions on attachments; define the attribute map for attachments to the database table. The Data Cleansing for each attribute can be performed writing rules and their matching state. A user can add custom functions for the data transformation. The aggregation of the data is done in the form of reports after the operation of data loading into the database is complete. The tool needs one-time setup per file template and its automated from that point.","abstract_has_math":false,"creators":["Lawanghare, Amit Rajiv"],"institution":null,"degree_name":"Master of Science in Computer Science","degree_level":"Project","degree_discipline":"School of Computer Science and Engineering","degree_department":null,"school":null,"contributors":["Murphy, Owen"],"advisors":[],"committee_chairs":[],"committee_members":[],"year":null,"date_issued":"","date_published":null,"updated_at":"2026-11-19T08:07:08Z","subjects":["ETL","Exchange Web Service","Systems Architecture"],"languages":[],"rights":[],"rights_urls":[],"identifier_entries":[],"person_identifier_entries":[]},"links":{"outbound_url":"https://scholarworks.lib.csusb.edu/etd/935","outbound_label":"Repository record","outbound_source":"dc:identifier","record_url":"https://scholarworks.lib.csusb.edu/etd/935","record_label":"Repository record","record_kind":"record","record_source":"dc:identifier","download_url":null,"download_label":null,"download_source":null,"access_status":null,"embargo_until":null,"access_note":null},"source_record":{"url":"https://scholarworks.lib.csusb.edu/do/oai/?verb=GetRecord&metadataPrefix=oai_etdms&identifier=oai%3Ascholarworks.lib.csusb.edu%3Aetd-2025","prefix":"oai_etdms"},"metadata_groups":[{"id":"people","label":"People","entries":[{"key":"dc:contributor","label":"Contributor","values":["Murphy, Owen"]},{"key":"dc:creator","label":"Author","values":["Lawanghare, Amit Rajiv"]}]},{"id":"academic_context","label":"Academic Context","entries":[{"key":"dc:date.available","label":"Dc Date Available","values":["2019-08-05T07:00:00Z"]},{"key":"dc:date.created","label":"Dc Date Created","values":["2019-09-01T07:00:00Z"]},{"key":"thesis:degree_discipline","label":"Discipline","values":["School of Computer Science and Engineering"]},{"key":"thesis:degree_level","label":"Degree Level","values":["Project"]},{"key":"thesis:degree_name","label":"Degree Name","values":["Master of Science in Computer Science"]}]},{"id":"subjects_keywords","label":"Subjects and Keywords","entries":[{"key":"dc:subject","label":"Dc Subject","values":["ETL","Exchange Web Service","Systems Architecture"]}]},{"id":"identifiers","label":"Identifiers","entries":[{"key":"dc:identifier","label":"Identifier","values":["https://scholarworks.lib.csusb.edu/etd/935"]}]},{"id":"additional","label":"Additional Metadata","entries":[{"key":"dc:description.abstract","label":"Abstract","values":["This project focuses on applying Extract, Transform and Load (ETL) operations on the relational data exchanged via emails. An Email is an important form of communication by both personal and corporate means as it enables reliable and quick exchange. Many useful files are shared as a form of attachments which contains transactional/ relational data. This tool allows a user to write the filter conditions and lookup conditions on attachments; define the attribute map for attachments to the database table. The Data Cleansing for each attribute can be performed writing rules and their matching state. A user can add custom functions for the data transformation. The aggregation of the data is done in the form of reports after the operation of data loading into the database is complete. The tool needs one-time setup per file template and its automated from that point."]},{"key":"dc:title","label":"Title","values":["EXTRACT TRANSFORM AND LOADING TOOL FOR EMAIL"]}]}],"canonical_facts":{"dc:contributor":["Murphy, Owen"],"dc:creator":["Lawanghare, Amit Rajiv"],"dc:date.available":["2019-08-05T07:00:00Z"],"dc:date.created":["2019-09-01T07:00:00Z"],"dc:description.abstract":["This project focuses on applying Extract, Transform and Load (ETL) operations on the relational data exchanged via emails. An Email is an important form of communication by both personal and corporate means as it enables reliable and quick exchange. Many useful files are shared as a form of attachments which contains transactional/ relational data. This tool allows a user to write the filter conditions and lookup conditions on attachments; define the attribute map for attachments to the database table. The Data Cleansing for each attribute can be performed writing rules and their matching state. A user can add custom functions for the data transformation. The aggregation of the data is done in the form of reports after the operation of data loading into the database is complete. The tool needs one-time setup per file template and its automated from that point."],"dc:identifier":["https://scholarworks.lib.csusb.edu/etd/935"],"dc:subject":["ETL","Exchange Web Service","Systems Architecture"],"dc:title":["EXTRACT TRANSFORM AND LOADING TOOL FOR EMAIL"],"thesis:degree_discipline":["School of Computer Science and Engineering"],"thesis:degree_level":["Project"],"thesis:degree_name":["Master of Science in Computer Science"]},"updated_at":"2026-11-19T08:07:08Z"}