{"id":{"repo_id":"mit","oai_identifier":"oai:dspace.mit.edu:1721.1/63075"},"canonical_url":"https://search.dev.ndltd.org/etd/mit/oai:dspace.mit.edu:1721.1/63075","repository":{"repo_id":"mit","name":"MIT","base_url":"https://dspace.mit.edu/oai/request"},"display":{"title":"A spreadsheet-based user interface for managing plural relationships in structured data","abstract":"A key feature of relational database applications is managing plural relationships-one-to-many and many-to-many-between entities, be they customers and invoices, parts and suppliers, or meetings and conference rooms. However, since it is often infeasible to adopt or develop a new database application for any given schema at hand, information workers instead turn to spreadsheets, a general and more familiar data management tool which, unfortunately, lends itself poorly to schemas requiring multiple related entity sets. In this thesis, we propose to reduce the cost-usability gap between spreadsheets and tailormade relational database applications by extending the spreadsheet paradigm to let the user establish relationships between rows in related worksheets as well as view and navigate the hierarchical cell structure that arises as a result. We present Related Worksheets, a spreadsheet-like prototype application, and evaluate it with a study involving 36 regular Excel users. First-time users of our software were able to solve most lookup-type query tasks without instruction, in one case 40% faster than on Excel.","abstract_html":"A key feature of relational database applications is managing plural relationships-one-to-many and many-to-many-between entities, be they customers and invoices, parts and suppliers, or meetings and conference rooms. However, since it is often infeasible to adopt or develop a new database application for any given schema at hand, information workers instead turn to spreadsheets, a general and more familiar data management tool which, unfortunately, lends itself poorly to schemas requiring multiple related entity sets. In this thesis, we propose to reduce the cost-usability gap between spreadsheets and tailormade relational database applications by extending the spreadsheet paradigm to let the user establish relationships between rows in related worksheets as well as view and navigate the hierarchical cell structure that arises as a result. We present Related Worksheets, a spreadsheet-like prototype application, and evaluate it with a study involving 36 regular Excel users. First-time users of our software were able to solve most lookup-type query tasks without instruction, in one case 40% faster than on Excel.","abstract_has_math":false,"creators":["Bakke, Eirik"],"institution":"Massachusetts Institute of Technology","degree_name":null,"degree_level":null,"degree_discipline":null,"degree_department":"Massachusetts Institute of Technology. Dept. of Electrical Engineering and Computer Science.","school":null,"contributors":[],"advisors":["David R. Karger and Robert C. Miller."],"committee_chairs":[],"committee_members":[],"year":2011,"date_issued":"2011","date_published":"2011","updated_at":"2026-07-22T22:22:11Z","subjects":["Electrical Engineering and Computer Science."],"languages":["eng"],"rights":["M.I.T. theses are protected by copyright. They may be viewed from this source for any purpose, but reproduction or distribution in any format is prohibited without written permission. See provided URL for inquiries about permission."],"rights_urls":["http://dspace.mit.edu/handle/1721.1/7582"],"identifier_entries":[]},"links":{"outbound_url":"http://hdl.handle.net/1721.1/63075","outbound_label":"Handle","outbound_source":"dc:identifier.uri"},"metadata_groups":[{"id":"people","label":"People","entries":[{"key":"dc:contributor.advisor","label":"Advisor","values":["David R. Karger and Robert C. Miller."]},{"key":"dc:contributor.department","label":"Department","values":["Massachusetts Institute of Technology. Dept. of Electrical Engineering and Computer Science."]},{"key":"dc:contributor.other","label":"Dc Contributor Other","values":["Massachusetts Institute of Technology. Dept. of Electrical Engineering and Computer Science."]},{"key":"dc:creator","label":"Author","values":["Bakke, Eirik"]}]},{"id":"academic_context","label":"Academic Context","entries":[{"key":"dc:date.accessioned","label":"Dc Date Accessioned","values":["2011-05-23T18:13:37Z"]},{"key":"dc:date.available","label":"Dc Date Available","values":["2011-05-23T18:13:37Z"]},{"key":"dc:date.issued","label":"Date","values":["2011"]},{"key":"dc:publisher","label":"Institution","values":["Massachusetts Institute of Technology"]},{"key":"dc:type","label":"Dc Type","values":["Thesis"]}]},{"id":"subjects_keywords","label":"Subjects and Keywords","entries":[{"key":"dc:subject","label":"Dc Subject","values":["Electrical Engineering and Computer Science."]}]},{"id":"language_rights","label":"Language and Rights","entries":[{"key":"dc:language.iso","label":"Language (ISO)","values":["eng"]},{"key":"dc:rights","label":"Dc Rights","values":["M.I.T. theses are protected by copyright. They may be viewed from this source for any purpose, but reproduction or distribution in any format is prohibited without written permission. See provided URL for inquiries about permission."]},{"key":"dc:rights.uri","label":"Rights URI","values":["http://dspace.mit.edu/handle/1721.1/7582"]}]},{"id":"identifiers","label":"Identifiers","entries":[{"key":"dc:identifier.uri","label":"Identifier URI","values":["http://hdl.handle.net/1721.1/63075"]}]},{"id":"additional","label":"Additional Metadata","entries":[{"key":"dc:description","label":"Description","values":["Thesis (S.M.)--Massachusetts Institute of Technology, Dept. of Electrical Engineering and Computer Science, 2011.","Cataloged from PDF version of thesis.","Includes bibliographical references (p. 57-58)."]},{"key":"dc:description.abstract","label":"Abstract","values":["A key feature of relational database applications is managing plural relationships-one-to-many and many-to-many-between entities, be they customers and invoices, parts and suppliers, or meetings and conference rooms. However, since it is often infeasible to adopt or develop a new database application for any given schema at hand, information workers instead turn to spreadsheets, a general and more familiar data management tool which, unfortunately, lends itself poorly to schemas requiring multiple related entity sets. In this thesis, we propose to reduce the cost-usability gap between spreadsheets and tailormade relational database applications by extending the spreadsheet paradigm to let the user establish relationships between rows in related worksheets as well as view and navigate the hierarchical cell structure that arises as a result. We present Related Worksheets, a spreadsheet-like prototype application, and evaluate it with a study involving 36 regular Excel users. First-time users of our software were able to solve most lookup-type query tasks without instruction, in one case 40% faster than on Excel."]},{"key":"dc:description.degree","label":"Dc Description Degree","values":["S.M."]},{"key":"dc:title","label":"Title","values":["A spreadsheet-based user interface for managing plural relationships in structured data"]}]}],"canonical_facts":{"dc:contributor.advisor":["David R. Karger and Robert C. Miller."],"dc:contributor.department":["Massachusetts Institute of Technology. Dept. of Electrical Engineering and Computer Science."],"dc:contributor.other":["Massachusetts Institute of Technology. Dept. of Electrical Engineering and Computer Science."],"dc:creator":["Bakke, Eirik"],"dc:date.accessioned":["2011-05-23T18:13:37Z"],"dc:date.available":["2011-05-23T18:13:37Z"],"dc:date.issued":["2011"],"dc:description":["Thesis (S.M.)--Massachusetts Institute of Technology, Dept. of Electrical Engineering and Computer Science, 2011.","Cataloged from PDF version of thesis.","Includes bibliographical references (p. 57-58)."],"dc:description.abstract":["A key feature of relational database applications is managing plural relationships-one-to-many and many-to-many-between entities, be they customers and invoices, parts and suppliers, or meetings and conference rooms. However, since it is often infeasible to adopt or develop a new database application for any given schema at hand, information workers instead turn to spreadsheets, a general and more familiar data management tool which, unfortunately, lends itself poorly to schemas requiring multiple related entity sets. In this thesis, we propose to reduce the cost-usability gap between spreadsheets and tailormade relational database applications by extending the spreadsheet paradigm to let the user establish relationships between rows in related worksheets as well as view and navigate the hierarchical cell structure that arises as a result. We present Related Worksheets, a spreadsheet-like prototype application, and evaluate it with a study involving 36 regular Excel users. First-time users of our software were able to solve most lookup-type query tasks without instruction, in one case 40% faster than on Excel."],"dc:description.degree":["S.M."],"dc:identifier.uri":["http://hdl.handle.net/1721.1/63075"],"dc:language.iso":["eng"],"dc:publisher":["Massachusetts Institute of Technology"],"dc:rights":["M.I.T. theses are protected by copyright. They may be viewed from this source for any purpose, but reproduction or distribution in any format is prohibited without written permission. See provided URL for inquiries about permission."],"dc:rights.uri":["http://dspace.mit.edu/handle/1721.1/7582"],"dc:subject":["Electrical Engineering and Computer Science."],"dc:title":["A spreadsheet-based user interface for managing plural relationships in structured data"],"dc:type":["Thesis"]},"updated_at":"2026-07-22T22:22:11Z"}