{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2025,12,18]],"date-time":"2025-12-18T14:10:48Z","timestamp":1766067048382},"reference-count":57,"publisher":"Association for Computing Machinery (ACM)","issue":"11","content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":["Proc. VLDB Endow."],"published-print":{"date-parts":[[2019,7]]},"abstract":"<jats:p>Online users are constantly seeking experiences, such as a hotel with clean rooms and a lively bar, or a restaurant for a romantic rendezvous. However, e-commerce search engines only support queries involving objective attributes such as location, price, and cuisine, and any experiential data is relegated to text reviews.<\/jats:p>\n          <jats:p>\n            In order to support experiential queries, a database system needs to model\n            <jats:italic>subjective<\/jats:italic>\n            data. Users should be able to pose queries that specify subjective experiences using their own words, in addition to conditions on the usual objective attributes. This paper introduces OpineDB, a subjective database system that addresses these challenges. We introduce a data model for subjective databases. We describe how OpineDB translates subjective queries against the subjective database schema, which is done by matching the user query phrases to the underlying schema. We also show how the experiential conditions specified by the user can be combined and the results aggregated and ranked. We demonstrate that subjective databases satisfy user needs more effectively and accurately than alternative techniques through experiments with real data of hotel and restaurant reviews.\n          <\/jats:p>","DOI":"10.14778\/3342263.3342271","type":"journal-article","created":{"date-parts":[[2019,9,18]],"date-time":"2019-09-18T18:36:11Z","timestamp":1568831771000},"page":"1330-1343","source":"Crossref","is-referenced-by-count":16,"title":["Subjective databases"],"prefix":"10.14778","volume":"12","author":[{"given":"Yuliang","family":"Li","sequence":"first","affiliation":[{"name":"Megagon Labs"}]},{"given":"Aaron","family":"Feng","sequence":"additional","affiliation":[{"name":"Megagon Labs"}]},{"given":"Jinfeng","family":"Li","sequence":"additional","affiliation":[{"name":"Megagon Labs"}]},{"given":"Saran","family":"Mumick","sequence":"additional","affiliation":[{"name":"Megagon Labs"}]},{"given":"Alon","family":"Halevy","sequence":"additional","affiliation":[{"name":"Megagon Labs"}]},{"given":"Vivian","family":"Li","sequence":"additional","affiliation":[{"name":"Megagon Labs"}]},{"given":"Wang-Chiew","family":"Tan","sequence":"additional","affiliation":[{"name":"Megagon Labs"}]}],"member":"320","published-online":{"date-parts":[[2019,7]]},"reference":[{"key":"e_1_2_1_1_1","first-page":"265","volume-title":"OSDI","author":"Abadi M.","year":"2016","unstructured":"M. Abadi , P. Barham , J. Chen , Z. Chen , A. Davis , J. Dean , M. Devin , S. Ghemawat , G. Irving , M. Isard , : A system for large-scale machine learning . In OSDI , pages 265 -- 283 , 2016 . M. Abadi, P. Barham, J. Chen, Z. Chen, A. Davis, J. Dean, M. Devin, S. Ghemawat, G. Irving, M. Isard, et al. Tensorflow: A system for large-scale machine learning. In OSDI, pages 265--283, 2016."},{"key":"e_1_2_1_2_1","doi-asserted-by":"publisher","DOI":"10.1017\/S135132490000005X"},{"key":"e_1_2_1_3_1","doi-asserted-by":"publisher","DOI":"10.1609\/aimag.v36i1.2564"},{"key":"e_1_2_1_4_1","doi-asserted-by":"publisher","DOI":"10.1145\/3209581"},{"key":"e_1_2_1_5_1","doi-asserted-by":"publisher","DOI":"10.3115\/1219044.1219075"},{"key":"e_1_2_1_6_1","first-page":"804","volume-title":"NAACL HLT","author":"Brody S.","year":"2010","unstructured":"S. Brody and N. Elhadad . An unsupervised aspect-sentiment model for online reviews . In NAACL HLT , pages 804 -- 812 , 2010 . S. Brody and N. Elhadad. An unsupervised aspect-sentiment model for online reviews. In NAACL HLT, pages 804--812, 2010."},{"key":"e_1_2_1_7_1","volume-title":"Amazon's mechanical turk: A new source of inexpensive, yet high-quality, data? Perspectives on psychological science, 6(1):3--5","author":"Buhrmester M.","year":"2011","unstructured":"M. Buhrmester , T. Kwang , and S. D. Gosling . Amazon's mechanical turk: A new source of inexpensive, yet high-quality, data? Perspectives on psychological science, 6(1):3--5 , 2011 . M. Buhrmester, T. Kwang, and S. D. Gosling. Amazon's mechanical turk: A new source of inexpensive, yet high-quality, data? Perspectives on psychological science, 6(1):3--5, 2011."},{"key":"e_1_2_1_8_1","first-page":"892","volume-title":"COLING","author":"Chen B.","year":"2018","unstructured":"B. Chen , B. An , L. Sun , and X. Han . Semi-supervised lexicon learning for wide-coverage semantic parsing . In COLING , pages 892 -- 904 , 2018 . B. Chen, B. An, L. Sun, and X. Han. Semi-supervised lexicon learning for wide-coverage semantic parsing. In COLING, pages 892--904, 2018."},{"issue":"177","key":"e_1_2_1_9_1","first-page":"5","article-title":"Introduction to information retrieval","volume":"151","author":"Christopher D. M.","year":"2008","unstructured":"D. M. Christopher , R. Prabhakar , and S. Hinrich . Introduction to information retrieval . An Introduction To Information Retrieval , 151 ( 177 ): 5 , 2008 . D. M. Christopher, R. Prabhakar, and S. Hinrich. Introduction to information retrieval. An Introduction To Information Retrieval, 151(177):5, 2008.","journal-title":"An Introduction To Information Retrieval"},{"key":"e_1_2_1_10_1","doi-asserted-by":"publisher","DOI":"10.18653\/v1\/D17-1070"},{"key":"e_1_2_1_11_1","volume-title":"Bert: Pre-training of deep bidirectional transformers for language understanding. arXiv preprint arXiv:1810.04805","author":"Devlin J.","year":"2018","unstructured":"J. Devlin , M.-W. Chang , K. Lee , and K. Toutanova . Bert: Pre-training of deep bidirectional transformers for language understanding. arXiv preprint arXiv:1810.04805 , 2018 . J. Devlin, M.-W. Chang, K. Lee, and K. Toutanova. Bert: Pre-training of deep bidirectional transformers for language understanding. arXiv preprint arXiv:1810.04805, 2018."},{"key":"e_1_2_1_12_1","doi-asserted-by":"publisher","DOI":"10.1145\/3308558.3314125"},{"key":"e_1_2_1_13_1","doi-asserted-by":"publisher","DOI":"10.1145\/237661.237715"},{"key":"e_1_2_1_14_1","doi-asserted-by":"publisher","DOI":"10.1016\/S0022-0000(03)00026-6"},{"key":"e_1_2_1_15_1","doi-asserted-by":"publisher","DOI":"10.1145\/2858036.2858535"},{"key":"e_1_2_1_16_1","doi-asserted-by":"publisher","DOI":"10.1007\/s10791-011-9174-8"},{"key":"e_1_2_1_17_1","volume-title":"https:\/\/github.com\/macanv\/BERT-BiLSTM-CRF-NER","author":"NER.","year":"2018","unstructured":"GitHub. BERT-BiLSMT-CRF- NER. https:\/\/github.com\/macanv\/BERT-BiLSTM-CRF-NER , 2018 . GitHub. BERT-BiLSMT-CRF-NER. https:\/\/github.com\/macanv\/BERT-BiLSTM-CRF-NER, 2018."},{"key":"e_1_2_1_18_1","volume-title":"https:\/\/github.com\/rit-git\/opinedb_public","author":"DB.","year":"2018","unstructured":"GitHub. Opine DB. https:\/\/github.com\/rit-git\/opinedb_public , 2018 . GitHub. OpineDB. https:\/\/github.com\/rit-git\/opinedb_public, 2018."},{"key":"e_1_2_1_19_1","volume-title":"Elasticsearch: The Definitive Guide: A Distributed Real-Time Search and Analytics Engine. \"O'Reilly Media","author":"Gormley C.","year":"2015","unstructured":"C. Gormley and Z. Tong . Elasticsearch: The Definitive Guide: A Distributed Real-Time Search and Analytics Engine. \"O'Reilly Media , Inc .\", 2015 . C. Gormley and Z. Tong. Elasticsearch: The Definitive Guide: A Distributed Real-Time Search and Analytics Engine. \"O'Reilly Media, Inc.\", 2015."},{"key":"e_1_2_1_20_1","doi-asserted-by":"publisher","DOI":"10.18653\/v1\/D16-1057"},{"key":"e_1_2_1_21_1","doi-asserted-by":"publisher","DOI":"10.18653\/v1\/P17-1036"},{"key":"e_1_2_1_22_1","doi-asserted-by":"publisher","DOI":"10.1145\/1014052.1014073"},{"key":"e_1_2_1_23_1","first-page":"755","volume-title":"AAAI","author":"Hu M.","year":"2004","unstructured":"M. Hu and B. Liu . Mining opinion features in customer reviews . In AAAI , pages 755 -- 760 , 2004 . M. Hu and B. Liu. Mining opinion features in customer reviews. In AAAI, pages 755--760, 2004."},{"key":"e_1_2_1_24_1","doi-asserted-by":"publisher","DOI":"10.1145\/1391729.1391730"},{"key":"e_1_2_1_25_1","doi-asserted-by":"publisher","DOI":"10.18653\/v1\/P17-1089"},{"key":"e_1_2_1_26_1","first-page":"3294","volume-title":"NIPS","author":"Kiros R.","year":"2015","unstructured":"R. Kiros , Y. Zhu , R. R. Salakhutdinov , R. Zemel , R. Urtasun , A. Torralba , and S. Fidler . Skip-thought vectors . In NIPS , pages 3294 -- 3302 , 2015 . R. Kiros, Y. Zhu, R. R. Salakhutdinov, R. Zemel, R. Urtasun, A. Torralba, and S. Fidler. Skip-thought vectors. In NIPS, pages 3294--3302, 2015."},{"key":"e_1_2_1_27_1","doi-asserted-by":"publisher","DOI":"10.1142\/S0218488503002053"},{"key":"e_1_2_1_28_1","volume-title":"Fuzzy sets and fuzzy logic","author":"Klir G.","year":"1995","unstructured":"G. Klir and B. Yuan . Fuzzy sets and fuzzy logic , volume 4 . Prentice hall New Jersey , 1995 . G. Klir and B. Yuan. Fuzzy sets and fuzzy logic, volume 4. Prentice hall New Jersey, 1995."},{"key":"e_1_2_1_29_1","doi-asserted-by":"publisher","DOI":"10.1145\/2949741.2949744"},{"key":"e_1_2_1_30_1","volume-title":"Subjective databases. arXiv preprint arXiv:1902.09661","author":"Li Y.","year":"2019","unstructured":"Y. Li , A. Feng , J. Li , S. Mumick , A. Y. Halevy , V. Li , and W. Tan . Subjective databases. arXiv preprint arXiv:1902.09661 , 2019 . Y. Li, A. Feng, J. Li, S. Mumick, A. Y. Halevy, V. Li, and W. Tan. Subjective databases. arXiv preprint arXiv:1902.09661, 2019."},{"key":"e_1_2_1_31_1","doi-asserted-by":"crossref","DOI":"10.1007\/978-3-031-02145-9","volume-title":"Sentiment Analysis and Opinion Mining. Morgan Claypool","author":"Liu B.","year":"2012","unstructured":"B. Liu . Sentiment Analysis and Opinion Mining. Morgan Claypool , 2012 . B. Liu. Sentiment Analysis and Opinion Mining. Morgan Claypool, 2012."},{"key":"e_1_2_1_32_1","first-page":"223","volume-title":"WEBIST","author":"Makris C.","year":"2014","unstructured":"C. Makris and P. Panagopoulos . Improving opinion-based entity ranking . In WEBIST , pages 223 -- 230 , 2014 . C. Makris and P. Panagopoulos. Improving opinion-based entity ranking. In WEBIST, pages 223--230, 2014."},{"key":"e_1_2_1_33_1","volume-title":"Efficient estimation of word representations in vector space. arXiv preprint arXiv:1301.3781","author":"Mikolov T.","year":"2013","unstructured":"T. Mikolov , K. Chen , G. Corrado , and J. Dean . Efficient estimation of word representations in vector space. arXiv preprint arXiv:1301.3781 , 2013 . T. Mikolov, K. Chen, G. Corrado, and J. Dean. Efficient estimation of word representations in vector space. arXiv preprint arXiv:1301.3781, 2013."},{"key":"e_1_2_1_34_1","first-page":"19","volume-title":"SemEval-2016","author":"Pontiki M.","year":"2016","unstructured":"M. Pontiki , D. Galanis , H. Papageorgiou , I. Androutsopoulos , S. Manandhar , A.-S. Mohammad , M. Al-Ayyoub , Y. Zhao , B. Qin , O. De Clercq, et al. Semeval-2016 task 5: Aspect based sentiment analysis . In SemEval-2016 , pages 19 -- 30 , 2016 . M. Pontiki, D. Galanis, H. Papageorgiou, I. Androutsopoulos, S. Manandhar, A.-S. Mohammad, M. Al-Ayyoub, Y. Zhao, B. Qin, O. De Clercq, et al. Semeval-2016 task 5: Aspect based sentiment analysis. In SemEval-2016, pages 19--30, 2016."},{"key":"e_1_2_1_35_1","doi-asserted-by":"publisher","DOI":"10.18653\/v1\/S15-2082"},{"key":"e_1_2_1_36_1","doi-asserted-by":"publisher","DOI":"10.3115\/v1\/S14-2004"},{"key":"e_1_2_1_37_1","first-page":"933","volume-title":"ACL","author":"Poon H.","year":"2013","unstructured":"H. Poon . Grounded unsupervised semantic parsing . In ACL , pages 933 -- 943 , 2013 . H. Poon. Grounded unsupervised semantic parsing. In ACL, pages 933--943, 2013."},{"key":"e_1_2_1_38_1","doi-asserted-by":"publisher","DOI":"10.1145\/604045.604070"},{"key":"e_1_2_1_39_1","doi-asserted-by":"publisher","DOI":"10.1162\/coli_a_00034"},{"key":"e_1_2_1_40_1","volume-title":"Gensim-statistical semantics in python","author":"Reh\u0159ek R.","year":"2011","unstructured":"R. Reh\u0159ek and P. Sojka . Gensim-statistical semantics in python . 2011 . R. Reh\u0159ek and P. Sojka. Gensim-statistical semantics in python. 2011."},{"key":"e_1_2_1_41_1","doi-asserted-by":"publisher","DOI":"10.18653\/v1\/N16-1091"},{"key":"e_1_2_1_42_1","volume-title":"Introduction to the conll-2003 shared task: Language-independent named entity recognition. arXiv preprint cs\/0306050","author":"Sang E. F.","year":"2003","unstructured":"E. F. Sang and F. De Meulder . Introduction to the conll-2003 shared task: Language-independent named entity recognition. arXiv preprint cs\/0306050 , 2003 . E. F. Sang and F. De Meulder. Introduction to the conll-2003 shared task: Language-independent named entity recognition. arXiv preprint cs\/0306050, 2003."},{"key":"e_1_2_1_43_1","doi-asserted-by":"publisher","DOI":"10.1145\/16856.16888"},{"key":"e_1_2_1_44_1","doi-asserted-by":"publisher","DOI":"10.5555\/2031527"},{"key":"e_1_2_1_45_1","doi-asserted-by":"publisher","DOI":"10.1145\/2539150.2539190"},{"key":"e_1_2_1_46_1","unstructured":"The Booking.com Dataset. https:\/\/www.kaggle.com\/jiashenliu\/515k-hotel-reviews-data-in-europe.  The Booking.com Dataset. https:\/\/www.kaggle.com\/jiashenliu\/515k-hotel-reviews-data-in-europe ."},{"key":"e_1_2_1_47_1","unstructured":"The Yelp Dataset. https:\/\/www.yelp.com\/dataset.  The Yelp Dataset. https:\/\/www.yelp.com\/dataset ."},{"key":"e_1_2_1_48_1","doi-asserted-by":"publisher","DOI":"10.1145\/2723372.2750548"},{"key":"e_1_2_1_49_1","doi-asserted-by":"publisher","DOI":"10.3115\/v1\/E14-1010"},{"key":"e_1_2_1_50_1","doi-asserted-by":"publisher","DOI":"10.18653\/v1\/D16-1059"},{"key":"e_1_2_1_51_1","first-page":"3316","volume-title":"AAAI","author":"Wang W.","year":"2017","unstructured":"W. Wang , S. J. Pan , D. Dahlmeier , and X. Xiao . Coupled multi-layer attentions for co-extraction of aspect and opinion terms . In AAAI , pages 3316 -- 3322 , 2017 . W. Wang, S. J. Pan, D. Dahlmeier, and X. Xiao. Coupled multi-layer attentions for co-extraction of aspect and opinion terms. In AAAI, pages 3316--3322, 2017."},{"key":"e_1_2_1_52_1","doi-asserted-by":"publisher","DOI":"10.3115\/1220575.1220619"},{"key":"e_1_2_1_53_1","doi-asserted-by":"publisher","DOI":"10.1145\/3183713.3183732"},{"key":"e_1_2_1_54_1","doi-asserted-by":"publisher","DOI":"10.1145\/2488388.2488514"},{"key":"e_1_2_1_55_1","doi-asserted-by":"publisher","DOI":"10.1109\/91.493904"},{"key":"e_1_2_1_56_1","doi-asserted-by":"publisher","DOI":"10.1002\/widm.1253"},{"key":"e_1_2_1_57_1","volume-title":"Seq2sql: Generating structured queries from natural language using reinforcement learning. arXiv preprint arXiv:1709.00103","author":"Zhong V.","year":"2017","unstructured":"V. Zhong , C. Xiong , and R. Socher . Seq2sql: Generating structured queries from natural language using reinforcement learning. arXiv preprint arXiv:1709.00103 , 2017 . V. Zhong, C. Xiong, and R. Socher. Seq2sql: Generating structured queries from natural language using reinforcement learning. arXiv preprint arXiv:1709.00103, 2017."}],"container-title":["Proceedings of the VLDB Endowment"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/dl.acm.org\/doi\/pdf\/10.14778\/3342263.3342271","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2022,12,28]],"date-time":"2022-12-28T09:56:45Z","timestamp":1672221405000},"score":1,"resource":{"primary":{"URL":"https:\/\/dl.acm.org\/doi\/10.14778\/3342263.3342271"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2019,7]]},"references-count":57,"journal-issue":{"issue":"11","published-print":{"date-parts":[[2019,7]]}},"alternative-id":["10.14778\/3342263.3342271"],"URL":"https:\/\/doi.org\/10.14778\/3342263.3342271","relation":{},"ISSN":["2150-8097"],"issn-type":[{"value":"2150-8097","type":"print"}],"subject":[],"published":{"date-parts":[[2019,7]]}}}