An operational data store (ODS) can be generally described as an architectural construct that is both similar and different in design and purpose to a data warehouse. It is similar in that it is subject-oriented and integrated from the various systems and sources that feed it. However, it is unique in that the data is volatile and updated on a relatively regular basis, it holds little to no archival data, and the data is kept at a detailed level with little summarization. The purpose of this thesis is to provide an overview of an ODS and the data that it holds, as well as to describe the author’s participation in a corporate project to build an ODS used to process and score customer information for a direct marketing application. This application gathers customer information from point-of-sale transactions and online orders. The author’s role on the project was to develop, test, and implement solutions concerning database performance, as well to provide database analysis and support throughout the project lifecycle. This thesis will provide an overview of the system’s functionality and the individual contributions the author made to the overall solution.
","abstract_html":"<p>An operational data store (ODS) can be generally described as an architectural construct that is both similar and different in design and purpose to a data warehouse. It is similar in that it is subject-oriented and integrated from the various systems and sources that feed it. However, it is unique in that the data is volatile and updated on a relatively regular basis, it holds little to no archival data, and the data is kept at a detailed level with little summarization. The purpose of this thesis is to provide an overview of an ODS and the data that it holds, as well as to describe the author’s participation in a corporate project to build an ODS used to process and score customer information for a direct marketing application. This application gathers customer information from point-of-sale transactions and online orders. The author’s role on the project was to develop, test, and implement solutions concerning database performance, as well to provide database analysis and support throughout the project lifecycle. This thesis will provide an overview of the system’s functionality and the individual contributions the author made to the overall solution.</p>","abstract_has_math":false,"creators":["Smith, Chad"],"institution":null,"degree_name":"MS in Computer Science","degree_level":null,"degree_discipline":"Computer Science","degree_department":null,"school":null,"contributors":["Alexander Dekhtyar","College of Agriculture, Food, and Environmental Sciences"],"advisors":[],"committee_chairs":[],"committee_members":[],"year":2009,"date_issued":"2009-03-01T08:00:00Z","date_published":"2009-03-01T08:00:00Z","updated_at":"2026-07-24T01:30:51Z","subjects":[],"languages":[],"rights":[],"rights_urls":[],"identifier_entries":[{"key":"dc:identifier","label":"Identifier","values":["10.15368/theses.2009.21"],"render_values":[{"text":"10.15368/theses.2009.21","href":"https://doi.org/10.15368/theses.2009.21","code":true}]}]},"links":{"outbound_url":"https://digitalcommons.calpoly.edu/theses/51","outbound_label":"Repository record","outbound_source":"dc:identifier"},"metadata_groups":[{"id":"people","label":"People","entries":[{"key":"dc:contributor","label":"Contributor","values":["Alexander Dekhtyar","College of Agriculture, Food, and Environmental Sciences"]},{"key":"dc:creator","label":"Author","values":["Smith, Chad"]}]},{"id":"academic_context","label":"Academic Context","entries":[{"key":"dc:date.available","label":"Dc Date Available","values":["2019-10-22T07:00:00Z"]},{"key":"thesis:degree_discipline","label":"Discipline","values":["Computer Science"]},{"key":"thesis:degree_name","label":"Degree Name","values":["MS in Computer Science"]}]},{"id":"identifiers","label":"Identifiers","entries":[{"key":"dc:identifier","label":"Identifier","values":["https://digitalcommons.calpoly.edu/theses/51","10.15368/theses.2009.21"]}]},{"id":"additional","label":"Additional Metadata","entries":[{"key":"dc:description.abstract","label":"Abstract","values":["An operational data store (ODS) can be generally described as an architectural construct that is both similar and different in design and purpose to a data warehouse. It is similar in that it is subject-oriented and integrated from the various systems and sources that feed it. However, it is unique in that the data is volatile and updated on a relatively regular basis, it holds little to no archival data, and the data is kept at a detailed level with little summarization. The purpose of this thesis is to provide an overview of an ODS and the data that it holds, as well as to describe the author’s participation in a corporate project to build an ODS used to process and score customer information for a direct marketing application. This application gathers customer information from point-of-sale transactions and online orders. The author’s role on the project was to develop, test, and implement solutions concerning database performance, as well to provide database analysis and support throughout the project lifecycle. This thesis will provide an overview of the system’s functionality and the individual contributions the author made to the overall solution.
"]},{"key":"dc:title","label":"Title","values":["Building an Operational Data Store for a Direct Marketing Application System"]}]}],"canonical_facts":{"dc:contributor":["Alexander Dekhtyar","College of Agriculture, Food, and Environmental Sciences"],"dc:creator":["Smith, Chad"],"dc:date.available":["2019-10-22T07:00:00Z"],"dc:description.abstract":["An operational data store (ODS) can be generally described as an architectural construct that is both similar and different in design and purpose to a data warehouse. It is similar in that it is subject-oriented and integrated from the various systems and sources that feed it. However, it is unique in that the data is volatile and updated on a relatively regular basis, it holds little to no archival data, and the data is kept at a detailed level with little summarization. The purpose of this thesis is to provide an overview of an ODS and the data that it holds, as well as to describe the author’s participation in a corporate project to build an ODS used to process and score customer information for a direct marketing application. This application gathers customer information from point-of-sale transactions and online orders. The author’s role on the project was to develop, test, and implement solutions concerning database performance, as well to provide database analysis and support throughout the project lifecycle. This thesis will provide an overview of the system’s functionality and the individual contributions the author made to the overall solution.
"],"dc:identifier":["https://digitalcommons.calpoly.edu/theses/51","10.15368/theses.2009.21"],"dc:title":["Building an Operational Data Store for a Direct Marketing Application System"],"thesis:degree_discipline":["Computer Science"],"thesis:degree_name":["MS in Computer Science"]},"updated_at":"2026-07-24T01:30:51Z"}