Publications

Book Chapters
  1. XML Parsing, SAX/DOM. Chengkai Li. A regular entry in Encyclopedia of Database Systems, L. Liu and M. Tamer Özsu (editors), Springer, http://refworks.springer.com/database-systems, 2009. [PDF]
Refereed Journal Papers
  1. Discovering General Prominent Streaks in Sequence Data. Gensheng Zhang, Xiao Jiang, Ping Luo, Min Wang, Chengkai Li. In ACM Transactions on Knowledge Discovery from Data (TKDD), accepted at August 5, 2013, in preprint. [PDF]
  2. On Skyline Groups. Nan Zhang, Chengkai Li, Naeemul Hassan, Sundaresan Rajasekaran, Gautam Das. In IEEE Transactions on Knowledge and Data Engineering (TKDE), accepted at June 14, 2013, in preprint. [PDF]
  3. Set Predicates in SQL: Enabling Set-Level Comparisons for Dynamically Formed Groups. Chengkai Li, Bin He, Ning Yan, Muhammad Assad Safiullah. In IEEE Transactions on Knowledge and Data Engineering (TKDE), accepted at August 1, 2012, in preprint. [PDF]
  4. On Contextual Ranking Queries in Databases. Chengkai Li. In Information Systems, Volume 38, Issue 4, Pages 509–523, June 2013. [PDF]
  5. Personalized Ranking in Web Databases: Establishing and Utilizing an Appropriate Workload. Aditya Telang, Sharma Chakravarthy, Chengkai Li. In Distributed and Parallel Databases (DPD), 31(1):47-70, March 2013. [SpringerLink]
  6. Entity-Relationship Queries over Wikipedia. Xiaonan Li, Chengkai Li, Cong Yu. In ACM Transactions on Intelligent Systems and Technology (TIST), vol. 3, no. 4, article 70:1-20, September 2012. [PDF]
  7. One Size Does Not Fit All: Towards User- and Query-Dependent Ranking For Web Databases. Aditya Telang, Chengkai Li, Sharma Chakravarthy. In IEEE Transactions on Knowledge and Data Engineering (TKDE), 24(9):1671-1685, September 2012. [IEEE Xplore]
  8. Structured Databases on the Web: Observations and Implications. Kevin Chen-Chuan Chang, Bin He, Chengkai Li, Mitesh Patel, Zhen Zhang. SIGMOD Record, 33(3):61-70, September 2004. [PDF]
Refereed Conference Papers
  1. iPLUG: Personalized List Recommendation in Twitter. Lijiang Chen, Yibing Zhao, Shimin Chen, Hui Fang, Chengkai Li, Min Wang. In Proceedings of the 14th International Conference on Web Information System Engineering (WISE), pages -, Nanjing, China, October 2013. (acceptance rate 49/198=24.7%) [PDF]
  2. Wiki3C: Exploiting Wikipedia for Context-aware Concept Categorization. Peng Jiang, Huiman Hou, Lijiang Chen, Shimin Chen, Conglei Yao, Chengkai Li, Min Wang. In Proceedings of the 6th ACM International Conference on Web Search and Data Mining (WSDM), pages 345-354, Rome, Italy, February 2013. (acceptance rate 73/387=19%) [PDF]
  3. Infobox Suggestion for Wikipedia Entities. Afroza Sultana, Quazi Hasan, Ashis Biswas, Soumyava Das, Habibur Rahman, Chris Ding, Chengkai Li. In Proceedings of the 21st ACM International Conference on Information and Knowledge Management (CIKM), pages 2307-2310, Maui, Hawaii, October 2012. (poster paper, acceptance rate 106/228=46.5%) [PDF]
  4. On Skyline Groups. Chengkai Li, Nan Zhang, Naeemul Hassan, Sundaresan Rajasekaran, Gautam Das. In Proceedings of the 21st ACM International Conference on Information and Knowledge Management (CIKM), pages 2119-2123, Maui, Hawaii, October 2012. (short Paper, full paper acceptance rate 146/1088=13.4%, short paper acceptance rate 156/1088=14.3%) [PDF] [Slides]
  5. On “One of the Few” Objects. You Wu, Pankaj K. Agarwal, Chengkai Li, Jun Yang, Cong Yu. In Proceedings of the 18th ACM SIGKDD International Conference on Knowledge Discovery and Data Mining (KDD), pages 1487-1495, Beijing, China, August 2012. (acceptance rate 133/755=17.6%) [PDF] [Slides] [Poster]
  6. An Optimization Framework for Map-Reduce Queries. Leonidas Fegaras, Chengkai Li, Upa Gupta. In Proceedings of the 15th International Conference on Extending Database Technology (EDBT), pages 26-37, Berlin, Germany, March 2012. (acceptance rate 43/193=22.5%) [PDF]
  7. Testing MapReduce-Style Programs. Christoph Csallner, Leonidas Fegaras, Chengkai Li. In Proceedings of the 19th ACM SIGSOFT Symposium on the Foundations of Software Engineering (FSE), New Ideas Track, pages 504-507, Szeged, Hungary, September 2011. (acceptance rate 11/43=25.6%) [PDF] [Slides]
  8. Prominent Streak Discovery in Sequence Data. Xiao Jiang, Chengkai Li, Ping Luo, Min Wang, Yong Yu. In Proceedings of the 17th ACM SIGKDD International Conference on Knowledge Discovery and Data Mining (KDD), pages 1280-1288, San Diego, California, USA, August 2011. (full paper, poster presentation, acceptance rate 125/714=17.5%) [PDF] [Poster]
  9. Computational Journalism: A Call to Arms to Database Researchers. Sarah Cohen, Chengkai Li, Jun Yang, Cong Yu. In Proceedings of the 5th Biennial Conference on Innovative Data Systems Research (CIDR), pages 148-151, Asilomar, California, USA, January 2011. (3rd place in best Outrageous Ideas and Vision (OIV) Track paper competition) [PDF] [Slides]
  10. Facetedpedia: Dynamic Generation of Query-Dependent Faceted Interfaces for Wikipedia. Chengkai Li, Ning Yan, Senjuti Basu Roy, Lekhendro Lisham, Gautam Das. In Proceedings of the 19th International World Wide Web Conference (WWW), pages 651-660, Raleigh, North Carolina, USA, April 2010. (acceptance rate 104/743=14%) [PDF] [Slides]
  11. Query-By-Keywords (QBK): Query Formulation Using Semantics and Feedback. AdityaTelang, Sharma Chakravarthy, Chengkai Li. In Proceedings of the 2009 International Conference on Conceptual Modeling (ER), pages 191-204, 2009. (acceptance rate 31/162=19%) [PDF]
  12. Querying for Information Integration: How to go from an Imprecise Intent to a Precise Query? AdityaTelang, Sharma Chakravarthy, Chengkai Li. In Proceedings of the 2008 International Conference on Management of Data (COMAD), pages 245-248, Bombay, India, December 2008. [PDF]
  13. Supporting Ranking and Clustering as Generalized Order-By and Group-By. Chengkai Li, Min Wang, Lipyeow Lim, Haixun Wang, Kevin Chen-Chuan Chang. In Proceedings of the 2007 ACM SIGMOD Conference (SIGMOD), pages 127-138, Beijing, China, June 2007. (acceptance rate 69/480=14%) [PDF] [Slides]
  14. Supporting Ad-hoc Ranking Aggregates. Chengkai Li, Kevin Chen-Chuan Chang, Ihab F. Ilyas. In Proceedings of the 2006 ACM SIGMOD Conference (SIGMOD), pages 61-72, Chicago, Illinois, USA, June 2006. (acceptance rate 58/446=13%) [PDF] [Slides]
  15. RankSQL: Query Algebra and Optimization for Relational Top-k Queries. Chengkai Li, Kevin Chen-Chuan Chang, Ihab F. Ilyas, Sumin Song. In Proceedings of the 2005 ACM SIGMOD Conference (SIGMOD), pages 131-142, Baltimore, Maryland, USA, June 2005. (acceptance rate 65/431=15%) [PDF] [Slides]
  16. Composing XSL Transformations with XML Publishing Views. Chengkai Li, Philip Bohannon, Henry F. Korth, PPS Narayan. In Proceedings of the 2003 ACM SIGMOD Conference (SIGMOD), pages 515-526, San Diego, California, USA, June 2003. (acceptance rate 52/342=15%) [PDF] [Slides]
Refereed Conference Demo Papers
  1. Facetedpedia: Enabling Query-Dependent Faceted Search for Wikipedia. Ning Yan, Chengkai Li, Senjuti B. Roy, Rakesh Ramegowda, Gautam Das. In Proceedings of the 19th ACM International Conference on Information and Knowledge Management (CIKM), pages 1927-1928, Toronto, Canada, October 2010. Demonstration description. [PDF]
  2. EntityEngine: Answering Entity-Relationship Queries using Shallow Semantics. Xiaonan Li, Chengkai Li, Cong Yu. In Proceedings of the 19th ACM International Conference on Information and Knowledge Management (CIKM), pages 1925-1926, Toronto, Canada, October 2010. Demonstration description. [PDF]
  3. RankSQL: Supporting Ranking Queries in Relational Database Management Systems. Chengkai Li, Mohamed Ali, Kevin Chen-Chuan Chang, Ihab F. Ilyas. In Proceedings of the 31st International Conference on Very Large Data Bases (VLDB), pages 1342-1345, Trondheim, Norway, August 2005. Demonstration description. (acceptance rate 29/69=42%) [PDF]
  4. Relational On-Line Exchange with XML. Philip Bohannon, Xin (Luna) Dong, Sumit Ganguly, Henry F. Korth, Chengkai Li, P.P.S. Narayan, and Pradeep Shenoy. In Proceedings of the 2003 ACM SIGMOD Conference (SIGMOD), pages 673, San Diego, California, USA, June 2003. Demonstration description. [PDF]
Refereed Workshop Papers
  1. Extracting Storm-Centric Characteristics from Raw Rainfall Data for Storm Analysis and Mining. Kulsawasd Jitkajornwanich, Ramez Elmasri, John Mcenery, Chengkai Li. In Proceedings of the 1st ACM SIGSPATIAL International Workshop on Analytics for Big Geospatial Data (BigSpatial), pages -, Redondo Beach, California, USA, November 2012. (Co-located with ACM SIGSPATIAL GIS 2012) [PDF]
  2. Formalization of 2-D Spatial Ontology and OWL/Protégé Realization. Kulsawasd Jitkajornwanich, Ramez Elmasri, Chengkai Li, John Mcenery. In Proceedings of the 3rd International Workshop on Semantic Web Information Management (SWIM), 6 pages, Athens, Greece, June 2011. (Co-located with SIGMOD 2011) [PDF]
  3. XML Query Optimization in Map-Reduce. Leonidas Fegaras, Chengkai Li, Upa Gupta, Jijo Philip. In Proceedings of the 14th International Workshop on the Web and Databases (WebDB), 6 pages, Athens, Greece, June 2011. (Co-located with SIGMOD 2011) (acceptance rate 12/43=27.9%) [PDF]
  4. Entity-Relationship Queries over Wikipedia. Xiaonan Li, Chengkai Li, Cong Yu. In Proceedings of the 2nd International Workshop on Search and Mining User-generated Contents (SMUC), pages 21-28, Toronto, Canada, October 2010. (Co-located with CIKM 2010) (acceptance rate 8/32=25%) [PDF] [Slides]
  5. Dynamic Symbolic Database Application Testing. Chengkai Li, Christoph Csallner. In Proceedings of the Third International Workshop on Testing Database Systems (DBTest), 6 pages, Indianapolis, Indiana, USA, June 2010. (Co-located with SIGMOD 2010) [PDF] [Slides]
  6. Query Routing: Finding Ways in the Maze of the Deep Web. Govind Kabra, Chengkai Li, Kevin Chen-Chuan Chang. In Proceedings of the International Workshop on Challenges in Web Information Retrieval and Integration (WIRI), pages 64-73, Tokyo, Japan, April 2005. (In conjunction with ICDE 2005) (acceptance rate 14/47=30%) [PDF]
Technical Reports
  1. A Structure-Driven Yield-Aware Web Form Crawler: Building a Database of Online Databases. Bin He, Chengkai Li, David Killian, Mitesh Patel, Yuping Tseng, Kevin Chen-Chuan Chang. UIUCDCS-R-2006-2752, Department of Computer Science, UIUC, July 2006. [PDF]
  2. Discovering Attribute Locality across the Deep Web: an Ordering-Based Approach. Chengkai Li, Kevin Chen-Chuan Chang. UIUCDCS-R-2003-2323, Department of Computer Science, UIUC, February 2003. [PDF]
Dissertations
  1. Enabling Data Retrieval: By Ranking and Beyond. Chengkai Li. Ph.D. Dissertation. University of Illinois at Urbana-Champaign, 2007. [PDF]
Datasets
  1. The UIUC Web Integration Repository. Kevin Chen-Chuan Chang, Bin He, Chengkai Li, Zhen Zhang. Department of Computer Science, University of Illinois at Urbana-Champaign.