Chengkai Li   Assistant Professor The Innovative Databases and Information Systems Research (IDIR) Lab bigD* Data Management Group Department of Computer Science and Engineering       University of Texas at Arlington	334 Nedderman Hall 416 Yates St. Arlington, TX 76019-0015 Phone: 817-272-0162 Email: Skype: WWW: http://ranger.uta.edu/~cli

[IDIR Lab]     [Research]     [Teaching]     [Students]     [Publications]     [Talks]

• I am looking for graduate (PhD, Master) and undergraduate students. Financial supports are available.
• I am directing The Innovative Databases and Information Systems Research (IDIR) Lab
• The 1st bigD* Regional Symposium on Data and Information Management, April 19th, 2008.

My wife, Fen Lu, is a system librarian at the UTA Library. She received the M.LIS degree from the Graduate School of Library and Information Science at UIUC in 2005, and M.S. degree in Computer Science from the Oregon State University, in 2004.

My interests are in the areas of databases, Web data management, data mining, and information retrieval, with an emphasis on making data retrieval and exploration in emerging applications more effective, efficient, and robust. In particular, ranking and top-k queries, Web search/mining/integration, database exploration, query processing and optimization, social networks and user-generated content, OLAP and data warehousing. Currently we are working on the following projects.

The Innovative Databases and Information Systems Research (IDIR) Lab

Ongoing Projects

• WikiEQ: Querying and Exploring Wikipedia (Collaboration with Gautam Das (UTA) and Yahoo! Research)
• WebMashup: Mashing-Up Information on the Web
• RankSQL: Enabling Data Retrieval: By Ranking and Beyond
• In my PhD work I built a "Google" for databases. The system, RankSQL, is built inside the kernel of a full-fledged DBMS, PostgreSQL. It enables intuitive, efficient, and robust data retrieval by ranking and mechanisms beyond ranking. It helps users to efficiently retrieve data by non-traditional fuzzy queries with soft criteria, and to explore what choices are available in databases and how they match the query criteria. This line of work has broad applications in many domains including E-commerce, Web search, multimedia retrieval, health data management, and bioinformatics.
• ENABLING DATA RETRIEVAL: BY RANKING AND BEYOND   (PhD dissertation)

• RankSQL system

• InfoMosaic (Collaboration with Sharma Chakravarthy (UTA))
• Set Query (Collaboration with IBM Almaden Research Center)

Previous Projects

• AIM: Supporting Efficient Top-k Query Processing
  
• MetaQuerier: Dynamic Ad-hoc Information Integration across the Internet
• ROLEX: Relational On-Line Exchange with XML

Selected Publications

Supporting Ranking and Clustering as Generalized Order-By and Group-By. Chengkai Li, Min Wang, Lipyeow Lim, Haixun Wang, and Kevin Chen-Chuan Chang. To appear in Proceedings of the 2007 ACM SIGMOD Conference (SIGMOD 2007), Beijing, China, June 2007. (69/480=14%). [PDF] [Slides PPT] Supporting Ad-hoc Ranking Aggregates. Chengkai Li, Kevin Chen-Chuan Chang, and Ihab F. Ilyas. In Proceedings of the 2006 ACM SIGMOD Conference (SIGMOD 2006), pages 61-72, Chicago, Illinois, June 2006. (58/446=13%). [PDF] [Slides PPT] RankSQL: Query Algebra and Optimization for Relational Top-k Queries. Chengkai Li, Kevin Chen-Chuan Chang, Ihab F. Ilyas, and Sumin Song. In Proceedings of the 2005 ACM SIGMOD Conference (SIGMOD 2005), pages 131-142, Baltimore, Maryland, June 2005. (65/431=15%). [PDF] [Slides PPT] Composing XSL Transformations with XML Publishing Views. Chengkai Li, Philip Bohannon, Henry F. Korth, and PPS Narayan. In Proceedings of the 2003 ACM SIGMOD Conference (SIGMOD 2003), pages 515-526, San Diego, California, June 2003. (52/342=15%). [PDF] [Slides PPT]

Other Publications

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, 2008. Querying for Information Integration: How to go from an Imprecise Intent to a Precise Query?. AdityaTelang, Sharma Chakravarthy, and Chengkai Li. In Proceedings of the 2008 International Conference on Management of Data (COMAD 2008), pages 245-248. 2008. A Structure-Driven Yield-Aware Web Form Crawler: Building a Database of Online Databases. Bin He, Chengkai Li, David Killian, Mitesh Patel, Yuping Tseng, and Kevin Chen-Chuan Chang. UIUCDCS-R-2006-2752, Department of Computer Science, UIUC, July 2006. [PDF] RankSQL: Supporting Ranking Queries in Relational Database Management Systems. Chengkai Li, Mohamed Ali, Kevin Chen-Chuan Chang, and Ihab F. Ilyas. In Proceedings of the 31st International Conference on Very Large Data Bases (VLDB 2005), pages 1342-1345, Trondheim, Norway, August 2005. Demonstration description. [PDF] Query Routing: Finding Ways in the Maze of the Deep Web. Govind Kabra, Chengkai Li, and Kevin Chen-Chuan Chang. In Proceedings of the ICDE Workshop on Challenges in Web Information Retrieval and Integration (ICDE-WIRI 2005), Tokyo, Japan, April 2005. (14/47=30%). [PDF] Structured Databases on the Web: Observations and Implications. K. C.-C. Chang, B. He, C. Li, M. Patel, and Z. Zhang. SIGMOD Record, 33(3):61-70, September 2004. [PDF] 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 2003), pages 673, San Diego, California, June 2003. Demonstration description. [PDF]  The UIUC Web Integration Repository. Kevin Chen-Chuan Chang, Bin He, Chengkai Li, and Zhen Zhang. Department of Computer Science, University of Illinois at Urbana-Champaign.

Invited Talks

Search the Database and Query the Web: Two Sides to the Story. [Slides PPT] Texas A&M University, College Station, TX, November 2008. University of Texas at Dallas, Richardson, TX, October 2008. Supporting Ranking and Clustering as Generalized Order-By and Group-By. [Slides PPT] Southern Methodist University, Dallas, TX, November 2007. Beyond SQL: Structured Data Retrieval by Ranking. [Slides PPT] Florida State University, Tallahassee, FL, April 2007. University of Texas at Arlington, Arlington, TX, March 2007. Purdue University, West Lafayette, IN, November 2006. Indiana University, Bloomington, IN, November 2006. Illinois Institute of Technology, Chicago, IL, October 2006. University of Texas at Arlington, Arlington, TX, September 2006. Supporting Ranking and Clustering as Generalized Order-By and Group-By. In the 2007 ACM SIGMOD Conference (SIGMOD 2007), Beijing, China, June 11, 2007. [Slides PPT] Supporting Ad-hoc Ranking Aggregates. In the 2006 ACM SIGMOD Conference (SIGMOD 2006), Chicago, Illinois, June 27, 2006. [Slides PPT] RankSQL: Query Algebra and Optimization for Relational Top-k Queries. In the 2005 ACM SIGMOD Conference (SIGMOD 2005), Baltimore, Maryland, June 14, 2005. [Slides PPT] Composing XSL Transformations with XML Publishing Views. In the 2003 ACM SIGMOD Conference (SIGMOD 2003), San Diego, California, June 12, 2003. [Slides PPT]

Professional Activities

• Program Committee: PAKDD 2009, ICDM 2008, DBRank 2008, ISDPE 2007, WAIM 2005
• Reviewer: ACM Transactions on Database Systems (TODS), VLDB Journal, IEEE Transactions on Knowledge and Data Engineering (TKDE), IEEE Transactions on Multimedia (TMM), IEEE Transactions on Parallel and Distributed Systems (TPDS), Distributed and Parallel Databases (DAPD), Information Systems
• External referee of conferences: CIKM 2006 2004, DASFAA 2004 2003, DIVO 2004, ICDE 2008, 2007 2006 2005 2003, IIWeb 2007, M-PREF 2007, SDM 2007, SIGKDD 2008, SIGMOD 2006 2005, VLDB 2007, WebDB 2005 2004, WWW 2006 2005

Last Modified: 2009-02-06
Created: 2001-09-18 00:16:21
Mr. Web Counter says you're only visitor ... Keep trying!