{"id":{"repo_id":"south-carolina","oai_identifier":"oai:scholarcommons.sc.edu:etd-1799"},"canonical_url":"https://search.dev.ndltd.org/etd/south-carolina/oai:scholarcommons.sc.edu:etd-1799","repository":{"repo_id":"south-carolina","name":"University of South Carolina","base_url":"https://scholarcommons.sc.edu/do/oai/"},"display":{"title":"Column Store Database - A New Approach to GIS Application","abstract":"<p>Geographic Information Systems (GIS) were designed to model the world. However, with the growth of data and increasing sophistication of analy- sis and processing techniques, the traditional methods of performing GIS processing on desktops are insucient. This thesis addresses this issue by studying the applicability of Column-store databases for GIS. This is accomplished by implementing two sets of spatial database systems, one using row store and the other using column store. These implementations are then evaluated for eciency of data retrieval. Oracle is used as the row-store database system, while MonetDb is used as the column-store database system. Our hypothesis is that storing GIS in a Column-store format will increase the performance of data retrieval. To establish this hypothesis we 1. Calculate the cost of query processing for both column-store and row- store database systems. Analyze the result in context of Geographic Information System. 2. Design an GIS architecture using column-store database management system. 3. Implement the corresponding platform, including column-store database management system and Geographic Information Systems. 4. Perform experiments to evaluate the eciency of data retrieval using traditional row-store DBMS and column-stored DBMS on the context of GIS. 5. Analyze empirical results.</p>","abstract_html":"&lt;p&gt;Geographic Information Systems (GIS) were designed to model the world. However, with the growth of data and increasing sophistication of analy- sis and processing techniques, the traditional methods of performing GIS processing on desktops are insucient. This thesis addresses this issue by studying the applicability of Column-store databases for GIS. This is accomplished by implementing two sets of spatial database systems, one using row store and the other using column store. These implementations are then evaluated for eciency of data retrieval. Oracle is used as the row-store database system, while MonetDb is used as the column-store database system. Our hypothesis is that storing GIS in a Column-store format will increase the performance of data retrieval. To establish this hypothesis we 1. Calculate the cost of query processing for both column-store and row- store database systems. Analyze the result in context of Geographic Information System. 2. Design an GIS architecture using column-store database management system. 3. Implement the corresponding platform, including column-store database management system and Geographic Information Systems. 4. Perform experiments to evaluate the eciency of data retrieval using traditional row-store DBMS and column-stored DBMS on the context of GIS. 5. Analyze empirical results.&lt;/p&gt;","abstract_has_math":false,"creators":["Senapati, Biswa Ranjan"],"institution":null,"degree_name":"M.S.","degree_level":"Campus Access Thesis","degree_discipline":"Computer Science and Engineering","degree_department":null,"school":null,"contributors":["Csilla Farkas"],"advisors":[],"committee_chairs":[],"committee_members":[],"year":2012,"date_issued":"2012-01-01T08:00:00Z","date_published":"2012-01-01T08:00:00Z","updated_at":"2026-07-24T04:38:14Z","subjects":["Computer Sciences","Electrical and Computer Engineering","Engineering","Physical Sciences and Mathematics","Column store","database"],"languages":[],"rights":["© 2012, Biswa Ranjan Senapati"],"rights_urls":[],"identifier_entries":[]},"links":{"outbound_url":"https://scholarcommons.sc.edu/etd/798","outbound_label":"Repository record","outbound_source":"dc:identifier"},"metadata_groups":[{"id":"people","label":"People","entries":[{"key":"dc:contributor","label":"Contributor","values":["Csilla Farkas"]},{"key":"dc:creator","label":"Author","values":["Senapati, Biswa Ranjan"]}]},{"id":"academic_context","label":"Academic Context","entries":[{"key":"thesis:degree_discipline","label":"Discipline","values":["Computer Science and Engineering"]},{"key":"thesis:degree_level","label":"Degree Level","values":["Campus Access Thesis"]},{"key":"thesis:degree_name","label":"Degree Name","values":["M.S."]}]},{"id":"subjects_keywords","label":"Subjects and Keywords","entries":[{"key":"dc:subject","label":"Dc Subject","values":["Computer Sciences","Electrical and Computer Engineering","Engineering","Physical Sciences and Mathematics","Column store","database"]}]},{"id":"language_rights","label":"Language and Rights","entries":[{"key":"dc:rights","label":"Dc Rights","values":["© 2012, Biswa Ranjan Senapati"]}]},{"id":"identifiers","label":"Identifiers","entries":[{"key":"dc:identifier","label":"Identifier","values":["https://scholarcommons.sc.edu/etd/798"]}]},{"id":"additional","label":"Additional Metadata","entries":[{"key":"dc:description.abstract","label":"Abstract","values":["<p>Geographic Information Systems (GIS) were designed to model the world. However, with the growth of data and increasing sophistication of analy- sis and processing techniques, the traditional methods of performing GIS processing on desktops are insucient. This thesis addresses this issue by studying the applicability of Column-store databases for GIS. This is accomplished by implementing two sets of spatial database systems, one using row store and the other using column store. These implementations are then evaluated for eciency of data retrieval. Oracle is used as the row-store database system, while MonetDb is used as the column-store database system. Our hypothesis is that storing GIS in a Column-store format will increase the performance of data retrieval. To establish this hypothesis we 1. Calculate the cost of query processing for both column-store and row- store database systems. Analyze the result in context of Geographic Information System. 2. Design an GIS architecture using column-store database management system. 3. Implement the corresponding platform, including column-store database management system and Geographic Information Systems. 4. Perform experiments to evaluate the eciency of data retrieval using traditional row-store DBMS and column-stored DBMS on the context of GIS. 5. Analyze empirical results.</p>"]},{"key":"dc:title","label":"Title","values":["Column Store Database - A New Approach to GIS Application"]}]}],"canonical_facts":{"dc:contributor":["Csilla Farkas"],"dc:creator":["Senapati, Biswa Ranjan"],"dc:description.abstract":["<p>Geographic Information Systems (GIS) were designed to model the world. However, with the growth of data and increasing sophistication of analy- sis and processing techniques, the traditional methods of performing GIS processing on desktops are insucient. This thesis addresses this issue by studying the applicability of Column-store databases for GIS. This is accomplished by implementing two sets of spatial database systems, one using row store and the other using column store. These implementations are then evaluated for eciency of data retrieval. Oracle is used as the row-store database system, while MonetDb is used as the column-store database system. Our hypothesis is that storing GIS in a Column-store format will increase the performance of data retrieval. To establish this hypothesis we 1. Calculate the cost of query processing for both column-store and row- store database systems. Analyze the result in context of Geographic Information System. 2. Design an GIS architecture using column-store database management system. 3. Implement the corresponding platform, including column-store database management system and Geographic Information Systems. 4. Perform experiments to evaluate the eciency of data retrieval using traditional row-store DBMS and column-stored DBMS on the context of GIS. 5. Analyze empirical results.</p>"],"dc:identifier":["https://scholarcommons.sc.edu/etd/798"],"dc:rights":["© 2012, Biswa Ranjan Senapati"],"dc:subject":["Computer Sciences","Electrical and Computer Engineering","Engineering","Physical Sciences and Mathematics","Column store","database"],"dc:title":["Column Store Database - A New Approach to GIS Application"],"thesis:degree_discipline":["Computer Science and Engineering"],"thesis:degree_level":["Campus Access Thesis"],"thesis:degree_name":["M.S."]},"updated_at":"2026-07-24T04:38:14Z"}