{"id":{"repo_id":"calpoly","oai_identifier":"oai:digitalcommons.calpoly.edu:theses-4515"},"canonical_url":"https://search.ndltd.org/etd/calpoly/oai:digitalcommons.calpoly.edu:theses-4515","repository":{"repo_id":"calpoly","name":"Cal Poly","base_url":"https://digitalcommons.calpoly.edu/do/oai/"},"display":{"title":"Filter: Framework For Integrated Legislative Transparency And Exploratory Research","abstract":"Digital Democracy, established at Cal Poly's Institute for Advanced Technology and Public Policy, initially provided users access to a distinctive dataset, including state legislative committee hearings, transcripts, videos, and more. However, the discontinuation of funding ended operations for the project and emphasized the need for a streamlined application independent of third-party dependencies and capable of offering real-time and organized access to the invaluable Digital Democracy dataset. We introduce FILTER, a cloud-hosted API designed for read access to the Digital Democracy dataset through twelve distinct endpoints. The system contains two databases: the Digital Democracy Database (DDDB) and the Digital Democracy Knowledge Graph (DDKG). The latter, designed after DDDB, utilizes the advantages of a graph data structure for efficient data retrieval and novel knowledge discovery. This thesis is a comprehensive resource, providing detailed documentation and architectural design specifications for FILTER. The study outlines the API's design, functionality, and pipeline developed for maintaining DDKG. Furthermore, the thesis presents rigorous API performance evaluations, compares the efficiency of the two databases under significant loads on the API, and a series of case studies showcasing the unique insights derived from analysis performed on the novel DDKG dataset.","abstract_html":"Digital Democracy, established at Cal Poly&#x27;s Institute for Advanced Technology and Public Policy, initially provided users access to a distinctive dataset, including state legislative committee hearings, transcripts, videos, and more. However, the discontinuation of funding ended operations for the project and emphasized the need for a streamlined application independent of third-party dependencies and capable of offering real-time and organized access to the invaluable Digital Democracy dataset. We introduce FILTER, a cloud-hosted API designed for read access to the Digital Democracy dataset through twelve distinct endpoints. The system contains two databases: the Digital Democracy Database (DDDB) and the Digital Democracy Knowledge Graph (DDKG). The latter, designed after DDDB, utilizes the advantages of a graph data structure for efficient data retrieval and novel knowledge discovery. This thesis is a comprehensive resource, providing detailed documentation and architectural design specifications for FILTER. The study outlines the API&#x27;s design, functionality, and pipeline developed for maintaining DDKG. Furthermore, the thesis presents rigorous API performance evaluations, compares the efficiency of the two databases under significant loads on the API, and a series of case studies showcasing the unique insights derived from analysis performed on the novel DDKG dataset.","abstract_has_math":false,"creators":["Lau, Kenny"],"institution":null,"degree_name":"MS in Computer Science","degree_level":null,"degree_discipline":"Computer Science","degree_department":null,"school":null,"contributors":["Alexander Dekhtyar","Computer Science","College of Engineering"],"advisors":[],"committee_chairs":[],"committee_members":[],"year":null,"date_issued":"","date_published":null,"updated_at":"2026-11-19T07:12:23Z","subjects":["Digital Democracy","API","Software Performance","Knowledge Graphs","CalMatters","Electrical and Computer Engineering"],"languages":[],"rights":[],"rights_urls":[],"identifier_entries":[],"person_identifier_entries":[]},"links":{"outbound_url":"https://digitalcommons.calpoly.edu/theses/2864","outbound_label":"Repository record","outbound_source":"dc:identifier","record_url":"https://digitalcommons.calpoly.edu/theses/2864","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://digitalcommons.calpoly.edu/do/oai/?verb=GetRecord&metadataPrefix=oai_etdms&identifier=oai%3Adigitalcommons.calpoly.edu%3Atheses-4515","prefix":"oai_etdms"},"metadata_groups":[{"id":"people","label":"People","entries":[{"key":"dc:contributor","label":"Contributor","values":["Alexander Dekhtyar","Computer Science","College of Engineering"]},{"key":"dc:creator","label":"Author","values":["Lau, Kenny"]}]},{"id":"academic_context","label":"Academic Context","entries":[{"key":"dc:date.available","label":"Dc Date Available","values":["2024-06-14T07:00:00Z"]},{"key":"dc:date.created","label":"Dc Date Created","values":["2024-06-01T07:00:00Z"]},{"key":"thesis:degree_discipline","label":"Discipline","values":["Computer Science"]},{"key":"thesis:degree_name","label":"Degree Name","values":["MS in Computer Science"]}]},{"id":"subjects_keywords","label":"Subjects and Keywords","entries":[{"key":"dc:subject","label":"Dc Subject","values":["Digital Democracy","API","Software Performance","Knowledge Graphs","CalMatters","Electrical and Computer Engineering"]}]},{"id":"identifiers","label":"Identifiers","entries":[{"key":"dc:identifier","label":"Identifier","values":["https://digitalcommons.calpoly.edu/theses/2864"]}]},{"id":"additional","label":"Additional Metadata","entries":[{"key":"dc:description.abstract","label":"Abstract","values":["Digital Democracy, established at Cal Poly's Institute for Advanced Technology and Public Policy, initially provided users access to a distinctive dataset, including state legislative committee hearings, transcripts, videos, and more. However, the discontinuation of funding ended operations for the project and emphasized the need for a streamlined application independent of third-party dependencies and capable of offering real-time and organized access to the invaluable Digital Democracy dataset. We introduce FILTER, a cloud-hosted API designed for read access to the Digital Democracy dataset through twelve distinct endpoints. The system contains two databases: the Digital Democracy Database (DDDB) and the Digital Democracy Knowledge Graph (DDKG). The latter, designed after DDDB, utilizes the advantages of a graph data structure for efficient data retrieval and novel knowledge discovery. This thesis is a comprehensive resource, providing detailed documentation and architectural design specifications for FILTER. The study outlines the API's design, functionality, and pipeline developed for maintaining DDKG. Furthermore, the thesis presents rigorous API performance evaluations, compares the efficiency of the two databases under significant loads on the API, and a series of case studies showcasing the unique insights derived from analysis performed on the novel DDKG dataset."]},{"key":"dc:title","label":"Title","values":["Filter: Framework For Integrated Legislative Transparency And Exploratory Research"]}]}],"canonical_facts":{"dc:contributor":["Alexander Dekhtyar","Computer Science","College of Engineering"],"dc:creator":["Lau, Kenny"],"dc:date.available":["2024-06-14T07:00:00Z"],"dc:date.created":["2024-06-01T07:00:00Z"],"dc:description.abstract":["Digital Democracy, established at Cal Poly's Institute for Advanced Technology and Public Policy, initially provided users access to a distinctive dataset, including state legislative committee hearings, transcripts, videos, and more. However, the discontinuation of funding ended operations for the project and emphasized the need for a streamlined application independent of third-party dependencies and capable of offering real-time and organized access to the invaluable Digital Democracy dataset. We introduce FILTER, a cloud-hosted API designed for read access to the Digital Democracy dataset through twelve distinct endpoints. The system contains two databases: the Digital Democracy Database (DDDB) and the Digital Democracy Knowledge Graph (DDKG). The latter, designed after DDDB, utilizes the advantages of a graph data structure for efficient data retrieval and novel knowledge discovery. This thesis is a comprehensive resource, providing detailed documentation and architectural design specifications for FILTER. The study outlines the API's design, functionality, and pipeline developed for maintaining DDKG. Furthermore, the thesis presents rigorous API performance evaluations, compares the efficiency of the two databases under significant loads on the API, and a series of case studies showcasing the unique insights derived from analysis performed on the novel DDKG dataset."],"dc:identifier":["https://digitalcommons.calpoly.edu/theses/2864"],"dc:subject":["Digital Democracy","API","Software Performance","Knowledge Graphs","CalMatters","Electrical and Computer Engineering"],"dc:title":["Filter: Framework For Integrated Legislative Transparency And Exploratory Research"],"thesis:degree_discipline":["Computer Science"],"thesis:degree_name":["MS in Computer Science"]},"updated_at":"2026-11-19T07:12:23Z"}