{"id":{"repo_id":"uiuc","oai_identifier":"oai:www.ideals.illinois.edu:2142/88060"},"canonical_url":"https://search.dev.ndltd.org/etd/uiuc/oai:www.ideals.illinois.edu:2142/88060","repository":{"repo_id":"uiuc","name":"University of Illinois - Urbana-Champaign","base_url":"https://www.ideals.illinois.edu/oai-pmh"},"display":{"title":"Structured entity querying over unstructured text","abstract":"The web is a collection of unstructured webpages. This characteristic makes it very hard for users to search complex queries -- in most of the times, queries are just plain text and it is very difficult for users to describe the internal relationships that they contain. The EntityRank system allows users to specify the target entities for which they are interested within the query, which brings us one step closer to being able to describe the entity relationships. But this expressiveness is still limited because the queries are still in a flat format. On the other hand, SQL queries for relational databases are very expressive. Users can easily specify multiple entities and the relationships between them. But in order to use SQL queries, we need to extract all the entities and relationships existing in the domain beforehand. The cost of maintaining the tables is very large. Also it is very hard if we want to add or modify the schema after the initial domain design. Thus we want to build a system that can combine the advantages of the flexibility and informativeness of unstructured webpages and the expressiveness of SQL queries. In this work we design a system which allows users to use structured SQL queries on unstructured webpages using the help of the EntityRank system. We design the conceptual framework to map the concepts between two systems and also propose a ranking algorithm for the final results.","abstract_html":"The web is a collection of unstructured webpages. This characteristic makes it very hard for users to search complex queries -- in most of the times, queries are just plain text and it is very difficult for users to describe the internal relationships that they contain. The EntityRank system allows users to specify the target entities for which they are interested within the query, which brings us one step closer to being able to describe the entity relationships. But this expressiveness is still limited because the queries are still in a flat format. On the other hand, SQL queries for relational databases are very expressive. Users can easily specify multiple entities and the relationships between them. But in order to use SQL queries, we need to extract all the entities and relationships existing in the domain beforehand. The cost of maintaining the tables is very large. Also it is very hard if we want to add or modify the schema after the initial domain design. Thus we want to build a system that can combine the advantages of the flexibility and informativeness of unstructured webpages and the expressiveness of SQL queries. In this work we design a system which allows users to use structured SQL queries on unstructured webpages using the help of the EntityRank system. We design the conceptual framework to map the concepts between two systems and also propose a ranking algorithm for the final results.","abstract_has_math":false,"creators":["Jiang, Jiahui"],"institution":"University of Illinois at Urbana-Champaign","degree_name":"M.S.","degree_level":"Thesis","degree_discipline":"Computer Science","degree_department":null,"school":null,"contributors":["Chang, Kevin Chen-chuan"],"advisors":[],"committee_chairs":[],"committee_members":[],"year":2015,"date_issued":"2015-09-29T20:38:31Z","date_published":"2015-09-29T20:38:31Z","updated_at":"2026-07-22T22:26:31Z","subjects":["structured query","unstructured dataset","rank"],"languages":["en"],"rights":["Copyright 2015 Jiahui Jiang"],"rights_urls":[],"identifier_entries":[]},"links":{"outbound_url":"http://hdl.handle.net/2142/88060","outbound_label":"Handle","outbound_source":"dc:identifier"},"metadata_groups":[{"id":"people","label":"People","entries":[{"key":"dc:contributor","label":"Contributor","values":["Chang, Kevin Chen-chuan"]},{"key":"dc:creator","label":"Author","values":["Jiang, Jiahui"]}]},{"id":"academic_context","label":"Academic Context","entries":[{"key":"dc:date","label":"Dc Date","values":["2015-09-29T20:38:31Z","2015-08","2015-07-16","2015-8"]},{"key":"dc:type","label":"Dc Type","values":["text"]},{"key":"thesis:degree_discipline","label":"Discipline","values":["Computer Science"]},{"key":"thesis:degree_level","label":"Degree Level","values":["Thesis"]},{"key":"thesis:degree_name","label":"Degree Name","values":["M.S."]},{"key":"thesis:institution_name","label":"Thesis Institution Name","values":["University of Illinois at Urbana-Champaign"]}]},{"id":"subjects_keywords","label":"Subjects and Keywords","entries":[{"key":"dc:subject","label":"Dc Subject","values":["structured query","unstructured dataset","rank"]}]},{"id":"language_rights","label":"Language and Rights","entries":[{"key":"dc:language","label":"Dc Language","values":["en"]},{"key":"dc:rights","label":"Dc Rights","values":["Copyright 2015 Jiahui Jiang"]}]},{"id":"identifiers","label":"Identifiers","entries":[{"key":"dc:identifier","label":"Identifier","values":["http://hdl.handle.net/2142/88060"]}]},{"id":"additional","label":"Additional Metadata","entries":[{"key":"dc:description","label":"Description","values":["The web is a collection of unstructured webpages. This characteristic makes it very hard for users to search complex queries -- in most of the times, queries are just plain text and it is very difficult for users to describe the internal relationships that they contain. The EntityRank system allows users to specify the target entities for which they are interested within the query, which brings us one step closer to being able to describe the entity relationships. But this expressiveness is still limited because the queries are still in a flat format. On the other hand, SQL queries for relational databases are very expressive. Users can easily specify multiple entities and the relationships between them. But in order to use SQL queries, we need to extract all the entities and relationships existing in the domain beforehand. The cost of maintaining the tables is very large. Also it is very hard if we want to add or modify the schema after the initial domain design. Thus we want to build a system that can combine the advantages of the flexibility and informativeness of unstructured webpages and the expressiveness of SQL queries. In this work we design a system which allows users to use structured SQL queries on unstructured webpages using the help of the EntityRank system. We design the conceptual framework to map the concepts between two systems and also propose a ranking algorithm for the final results.","Submission original under an indefinite embargo labeled 'Open Access'. The submission was exported from vireo on 2015-09-29 without embargo terms","The student, Jiahui Jiang, accepted the attached license on 2015-07-16 at 10:57.","The student, Jiahui Jiang, submitted this Thesis for approval on 2015-07-16 at 11:08.","This Thesis was approved for publication on 2015-07-16 at 13:52.","DSpace SAF Submission Ingestion Package generated from Vireo submission #8496 on 2015-09-29 at 13:22:56","Made available in DSpace on 2015-09-29T20:38:31Z (GMT). No. of bitstreams: 2 JIANG-THESIS-2015.pdf: 297643 bytes, checksum: 61c5bbffae7984c5c8a1d6b323e87a46 (MD5) LICENSE.txt: 4209 bytes, checksum: 45e508a679e5f18c38b2d9d0c3d02f15 (MD5) Previous issue date: 2015-07-16"]},{"key":"dc:format","label":"Dc Format","values":["application/pdf"]},{"key":"dc:title","label":"Title","values":["Structured entity querying over unstructured text"]}]}],"canonical_facts":{"dc:contributor":["Chang, Kevin Chen-chuan"],"dc:creator":["Jiang, Jiahui"],"dc:date":["2015-09-29T20:38:31Z","2015-08","2015-07-16","2015-8"],"dc:description":["The web is a collection of unstructured webpages. This characteristic makes it very hard for users to search complex queries -- in most of the times, queries are just plain text and it is very difficult for users to describe the internal relationships that they contain. The EntityRank system allows users to specify the target entities for which they are interested within the query, which brings us one step closer to being able to describe the entity relationships. But this expressiveness is still limited because the queries are still in a flat format. On the other hand, SQL queries for relational databases are very expressive. Users can easily specify multiple entities and the relationships between them. But in order to use SQL queries, we need to extract all the entities and relationships existing in the domain beforehand. The cost of maintaining the tables is very large. Also it is very hard if we want to add or modify the schema after the initial domain design. Thus we want to build a system that can combine the advantages of the flexibility and informativeness of unstructured webpages and the expressiveness of SQL queries. In this work we design a system which allows users to use structured SQL queries on unstructured webpages using the help of the EntityRank system. We design the conceptual framework to map the concepts between two systems and also propose a ranking algorithm for the final results.","Submission original under an indefinite embargo labeled 'Open Access'. The submission was exported from vireo on 2015-09-29 without embargo terms","The student, Jiahui Jiang, accepted the attached license on 2015-07-16 at 10:57.","The student, Jiahui Jiang, submitted this Thesis for approval on 2015-07-16 at 11:08.","This Thesis was approved for publication on 2015-07-16 at 13:52.","DSpace SAF Submission Ingestion Package generated from Vireo submission #8496 on 2015-09-29 at 13:22:56","Made available in DSpace on 2015-09-29T20:38:31Z (GMT). No. of bitstreams: 2 JIANG-THESIS-2015.pdf: 297643 bytes, checksum: 61c5bbffae7984c5c8a1d6b323e87a46 (MD5) LICENSE.txt: 4209 bytes, checksum: 45e508a679e5f18c38b2d9d0c3d02f15 (MD5) Previous issue date: 2015-07-16"],"dc:format":["application/pdf"],"dc:identifier":["http://hdl.handle.net/2142/88060"],"dc:language":["en"],"dc:rights":["Copyright 2015 Jiahui Jiang"],"dc:subject":["structured query","unstructured dataset","rank"],"dc:title":["Structured entity querying over unstructured text"],"dc:type":["text"],"thesis:degree_discipline":["Computer Science"],"thesis:degree_level":["Thesis"],"thesis:degree_name":["M.S."],"thesis:institution_name":["University of Illinois at Urbana-Champaign"]},"updated_at":"2026-07-22T22:26:31Z"}