Panagiotis G. Ipeirotis

Education

• Ph.D. (with distinction), Computer Science, Columbia University, Sep 2004
      Dissertation Title: Classifying and Searching Hidden-Web Text Databases
      Advisor: Luis Gravano
• M.Phil., Computer Science, Columbia University, Feb 2003
• M.Sc., Computer Science, Columbia University, Feb 2001
• Diploma, Computer Engineering and Informatics, University of Patras, Greece, Jul 1999
      Rank: 1st in School of Engineering (out of approximately 600 students), GPA: 9.34 / 10

Research Interests

• Web Information Retrieval
• Text and Web Mining
• Text Databases
• Data Cleaning and Data Integration
• Economics-based Data Mining

Professional Employment

• Sep 2004 - Present: Assistant Professor. Department of Information, Operations, and Management Sciences, Leonard N. Stern School of Business, New York University, New York, NY, USA
• Oct 2005 - Present: Assistant Professor (Affiliated Faculty, Courtesy Appointment) Computer Science Department, Courant Institute of Mathematical Sciences, New York University, New York, NY, USA
• Sep 1999 - Aug 2004: Graduate Research Assistant. Computer Science Department, Columbia University, New York, NY, USA
• May 2003 - Aug 2003: Research Intern. Microsoft Research Ltd, Cambridge, U.K.
• Sep 1998 - Jun 1999: Research Assistant. Graphics and Multimedia Lab, Computer Engineering & Informatics Department, University of Patras, Greece
• Nov 1997 - Aug 1999: Engineer. Computing and Networking Services, Computer Technology Institute, Patras, Greece
• Oct 1995 - Nov 1997: System Administrator. Computer Engineering and Informatics Department, University of Patras, Greece
• Sep 1992 - Aug 1994: Instructor. Data Computer School, Serres, Greece

Honors and Awards

• Aug 2008: Best Paper Runner Up, ACM International Conference on Knowledge Management and Data Mining (KDD 2008)
• Jul 2007: NET Institute Summer Grant, with Anindya Ghose
• Mar 2007: Microsoft Virtual Earth Award, Unrestricted Cash Gift, $35,000, with Anindya Ghose
• Jan 2007: NSF CAREER Award, IIS-0643846 $499,957 for February 2007-January 2012
• Jun 2006: Best Paper Award, ACM International Conference on Management of Data (SIGMOD 2006)
• May 2006: Microsoft Live Labs Search Award, Unrestricted Cash Gift, $37,000, with Anindya Ghose
• Aug 2005: Departmental Nominee, ACM Doctoral Dissertation Award, Computer Science Department, Columbia University
• Apr 2005: Best Paper Award, IEEE International Conference on Data Engineering (ICDE 2005)
• Oct 2004: Award for Excellence in Teaching, School of Engineering, Columbia University
• Jul 2004: Ph.D. awarded with distinction, Computer Science Department, Columbia University
• Feb 2002: Fellowship, DIMACS (Center for Discrete Mathematics and Theoretical Computer Science)
• Jun 2001: Best Paper Award Finalist, ACM+IEEE Joint Conference on Digital Libraries (JCDL 2001)
• May 2001: Ph.D. Teaching Award of Excellence, Computer Science Department, Columbia University
• Sep 2000: Award for Excellence in Teaching, School of Engineering, Columbia University
• Apr 2001: Honorary Distinction Award, Technical Chamber of Greece
• Sep 1999 - Aug 2001: Fellowship, Empeirikio Foundation, Greece
• Apr 2000: Honorary Distinction Award, Technical Chamber of Greece
• May 1995 - May 1999: Five Fellowships from Greek Scholarship Foundation
• Jul 1994: Member of the Greek Olympiad team in the 26th International Chemistry Olympiad (Oslo 1994)
• May 1994: Gold Medal, 8th National Greek Competition in Chemistry

Teaching Experience

• IOMS Department, Stern School of Business, New York University, New York
  • Fall 2008: Instructor, Search and the New Economy (B20.3136)
  • Fall 2008: Instructor, Information Technology in Business and Society (C20.0001)
  • Winter 2008: Instructor, Search and the New Economy (B20.3136)
  • Fall 2007: Instructor, Information Technology in Business and Society (C20.0001)
  • Spring 2007: Instructor, Information Systems Technical Research Seminar (B20.3383)
  • Fall 2006: Instructor, Information Technology in Business and Society (C20.0001)
  • Spring 2006: Instructor, Information Systems Technical Research Seminar (B20.3383)
  • Spring 2006: Instructor, Information Technology in Business and Society (C20.0001)
  • Spring 2005: Instructor, Computer-based Systems for Management Support (C20.0001)
• Computer Science Department, Columbia University, New York
  • Spring 2003: Teaching Assistant, Advanced Database Systems (COMS 6111)
  • Spring 2002: Teaching Assistant, Advanced Database Systems (COMS 6111)
  • Spring 2001: Teaching Assistant, Advanced Database Systems (COMS 6111)
  • Spring 2000: Teaching Assistant, Advanced Database Systems (COMS 6111)
  • Spring 2001: Instructor, Columbia Video Network, Advanced Database Systems (COMS 6111)
  • Summer 2000: Instructor, Columbia Video Network, Advanced Database Systems (COMS 6111)
• Spring 1996: Grader, Computer Engineering and Informatics Department, University of Patras, Greece.
  Course: Programming Languages
• 1992-1994: Instructor, "Data Computer" School.
  Course: Programming Languages and Operating Systems

Academic Activities

• Program Committee Member:
  • 2009: VLDB 2009, WWW 2009, WSCD 2009
  • 2008: VLDB 2008, ACM SIGMOD 2008, ACM SIGIR 2008, ACM KDD 2008, IEEE ICDE 2008, WWW 2008, DBRank 2008
  • 2007: VLDB 2007, ACM SIGMOD 2007 (Demonstrations), ACM SIGIR 2007, ICEC 2007, DBRank 2007, TDMM 2007, FIND 2007
  • 2006: ACM SIGMOD 2006, ACM SIGIR 2006, WWW 2006, IEEE ICDE 2006, WIRI 2006, IQIS 2006
  • 2005: ACM SIGIR 2005, WWW 2005, SPIRE 2005, ACM Hypertext 2005, ACM Hypertext 2005 Workshop on Peer to Peer and Service Oriented Hypermedia
• Ad-hoc Journal Referee: ACM Transactions on the Web, ACM Transactions on Information Systems, ACM Transactions on Database Systems, IEEE Transactions on Knowledge and Data Engineering, IEEE Transactions on Parallel and Distributed Systems, Elsevier Information Systems, INFORMS Journal on Computing, Management Science, Information Systems Research, IEEE Computer, IEEE Internet Computing,
• External Conference Reviewer: ACM SIGMOD 2005, IEEE ICDE 2004, ACM SIGMOD 2002, VLDB 2002, IEEE ICDE 2001, ACM SIGIR 2001
• Organizer: Fourth New York Area DB/IR day, October 2006
• Web Chair: WebDB 2004

Invited Talks

• Oct 2008: New York Public Library, Text Mining of Electronic News Content for Economic Research, (Forum "On the Record": On Electronic Media and the Preservation of News)
• Jun 2008: Yahoo! Research: Improving Data Quality and Data Mining using Multiple, Noisy Labelers
• Dec 2007: Microsoft Research Cambridge: Opinion Mining using Econometrics: A Case Study on Reputation Systems
• Jul 2007: Microsoft Live Labs Faculty Summit: Opinion Mining using Econometrics: A Case Study on Reputation Systems
• Jul 2007: AT&T Labs - Research: Opinion Mining using Econometrics: A Case Study on Reputation Systems
• Mar 2007: Invited Talk, 18th IEICE Data Engineering Workshop (DEWS), Hiroshima, Japan: Towards a Query Optimizer for Text-Centric Tasks
• Feb 2007: Columbia University: Opinion Mining using Econometrics: A Case Study on Reputation Systems
• Sep 2006: Polytechnic University: Opinion Mining using Econometrics: A Case Study on Reputation Systems
• Jul 2006: Microsoft Research: Opinion Mining using Econometrics: A Case Study on Reputation Systems
• Dec 2005: Athens University of Economics and Business: Classifying and Searching Hidden-Web Databases
• Oct 2005: New Jersey Institute of Technology: Classifying and Searching Hidden-Web Databases
• Nov 2004: University of Toronto: Classifying and Searching Hidden-Web Databases
• Jun 2004: University of Thessaly, Greece: QProber: Classifying and Searching Hidden-Web Databases
• Apr 2004: Purdue University; University of California, Los Angeles; University of Massachusetts, Amherst: QProber: Classifying and Searching Hidden-Web Databases (job talk)
• Mar 2004: University of British Columbia, Canada; University of Maryland: QProber: Classifying and Searching Hidden-Web Databases (job talk)
• Feb 2004: New York University: QProber: Classifying and Searching Hidden-Web Databases (job talk)
• Aug 2002: DIMACS Summer School Tutorial on New Frontiers in Data Mining: Probe, Count, and Classify: Categorizing Hidden Web Databases

Work in Progress

1. The Dimensions of Reputation in Electronic Markets,
   A. Ghose, P. Ipeirotis, and A. Sundararajan,
   CeDER Working Papers Series; CeDER-06-02
   
2. Automatic Construction of Faceted Hierarchies
   W. Dakka and P. Ipeirotis
   
3. Deriving the Pricing Power of Product Features by Mining Consumer Reviews,
   N. Archak, A. Ghose, and P. Ipeirotis
   Journal version of KDD 2007 paper
4. Predicting the Usefulness and Impact of Product Reviews,
   A. Ghose and P. Ipeirotis,
   Journal version of ICEC 2007, WITS 2006 papers
5. Modeling Volatility in Prediction Markets,
   N. Archak, and P. Ipeirotis

Papers in Refereed Journals

1. A Quality-Aware Optimizer for Information Extraction, To appear
   A. Jain and P. Ipeirotis,
   ACM Transactions on Database Systems (TODS),
2. Classification-Aware Hidden-Web Text Database Selection,
   P. Ipeirotis and L. Gravano,
   ACM Transactions on Information Systems (TOIS), April 2008
3. Towards a Query Optimizer for Text-Centric Tasks,
   P. Ipeirotis, E. Agichtein, P. Jain, and L. Gravano,
   ACM Transactions on Database Systems (TODS), vol. 32, no. 4, December 2007
4. Modeling and Managing Content Changes in Text Databases,
   P. Ipeirotis, A. Ntoulas, J. Cho, and L. Gravano,
   ACM Transactions on Database Systems (TODS), vol. 32, no. 3, September 2007
5. Duplicate Record Detection: A Survey,
   A. Elmagarmid, P. Ipeirotis, and V. Verykios,
   IEEE Transactions on Knowledge and Data Engineering (TKDE), vol. 19, no. 1, January 2007
6. QProber: A System for Automatic Classification of Hidden-Web Databases,
   L. Gravano, P. Ipeirotis, and M. Sahami,
   ACM Transactions on Information Systems (TOIS), vol. 21, no. 1, January 2003

Papers in Refereed Conferences

7. Automatic Extraction of Useful Facet Hierarchies from Text Databases, To appear
   W. Dakka and P. Ipeirotis
   in Proceedings of the 24th IEEE International Conference on Data Engineering (ICDE 2008), 2008
8. Show me the Money! Deriving the Pricing Power of Product Features by Mining Consumer Reviews,
   N. Archak, A. Ghose, and P. Ipeirotis
   in Proceedings of the Thirteenth ACM SIGKDD International Conference on Knowledge Discovery and Data Mining (KDD 2007), 2007 (~100/513 < 20% accepted)
9. Opinion Mining Using Econometrics: A Case Study on Reputation Systems,
   A. Ghose, P. Ipeirotis, and A. Sundararajan
   in Proceedings of the 45th Annual Meeting of the Association for Computational Linguistics (ACL 2007), 2007 (132/588 = 22% accepted)
10. To Search or to Crawl? Towards a Query Optimizer for Text-Centric Tasks, (Best Paper Award)
    P. Ipeirotis, E. Agichtein, P. Jain, and L. Gravano,
    in Proceedings of the 2006 ACM International Conference on Management of Data (SIGMOD 2006), 2006 (58/446 = 13% accepted)
    (the work also appears in the ACM TODS paper "Towards a Query Optimizer for Text-Centric Tasks")
11. Automatic Construction of Multifaceted Browsing Interfaces,
    W. Dakka, P. Ipeirotis, and K. Wood,
    in Proceedings of the 2005 ACM CIKM International Conference on Information and Knowledge Management, 2005 (76/425 = 18% accepted)
12. Modeling and Managing Content Changes in Text Databases, (Best Paper Award)
    P. Ipeirotis, A. Ntoulas, J. Cho, and L. Gravano,
    in Proceedings of the 21st IEEE International Conference on Data Engineering (ICDE 2005), 2005 (67/521 = 13% accepted)
    (the work also appears in the ACM TODS paper "Modeling and Managing Content Changes in Text Databases")
13. When one Sample is not Enough: Improving Text Database Selection Using Shrinkage,
    P. Ipeirotis and L. Gravano,
    in Proceedings of the 2004 ACM International Conference on Management of Data (SIGMOD 2004), 2004 (69/431 = 16% accepted)
    (the work also appears in the ACM TOIS paper "Classification-Aware Hidden-Web Text Database Selection")
14. Text joins in an RDBMS for Web Data Integration,
    L. Gravano, P. Ipeirotis, N. Koudas, and D. Srivastava,
    in Proceedings of the 12th International World-Wide Web Conference (WWW2003), 2003 (13% accepted, more than 600 submissions)
15. Text Joins for Data Cleansing and Integration in an RDBMS,
    L. Gravano, P. Ipeirotis, N. Koudas, and D. Srivastava,
    in Proceedings of the 19th IEEE International Conference on Data Engineering (ICDE 2003), 2003
16. Distributed Search over the Hidden-Web: Hierarchical Database Sampling and Selection,
    P. Ipeirotis and L. Gravano,
    in Proceedings of the 28th International Conference on Very Large Databases (VLDB 2002), 2002 (69/432 = 16% accepted)
    (the work also appears in the ACM TOIS paper "Classification-Aware Hidden-Web Text Database Selection")
17. Extending SDARTS: Extracting Metadata from Web Databases and Interfacing with the Open Archives Initiative,
    P. Ipeirotis, T. Barry, and L. Gravano,
    in Proceedings of the Second ACM+IEEE Joint Conference on Digital Libraries (JCDL 2002), 2002 (33% accepted)
18. Approximate String Joins in a Database (Almost) for Free,
    L. Gravano, P. Ipeirotis, H.V. Jagadish, N. Koudas, S. Muthukrishnan, and D. Srivastava,
    in Proceedings of the 27th International Conference on Very Large Databases (VLDB 2001), 2001 (59/339 = 17% accepted)
19. Probe, Count, and Classify: Categorizing Hidden-Web Databases,
    P. Ipeirotis, L. Gravano, and M. Sahami,
    in Proceedings of the 2001 ACM International Conference on Management of Data (SIGMOD 2001), 2001 (15% accepted)
    (the work also appears in the ACM TOIS paper "QProber: A System for Automatic Classification of Hidden-Web Databases")
20. SDLIP + STARTS = SDARTS. A Protocol and Toolkit for Metasearching,
    N. Green, P. Ipeirotis, and L. Gravano,
    in Proceedings of the First ACM+IEEE Joint Conference on Digital Libraries (JCDL 2001), 2001

Papers in Refereed Workshops and Demonstration Sessions

21. Multifaceted Browsing over Large Databases of Text-Annotated Objects,
    W. Dakka, P. Ipeirotis, and K. Wood,
    in Proceedings of the 23rd IEEE International Conference on Data Engineering, Demonstrations (ICDE 2007), 2007 (28/73 = 38% accepted)
22. Designing Ranking Systems for Consumer Reviews: The Impact of Review Subjectivity on Product Sales and Review Quality
    A. Ghose and P. Ipeirotis,
    in Proceedings of the 2006 Workshop on Information Technology and Systems (WITS 2006), 2006 (36/105 = 35% accepted)
23. Automatic Discovery of Useful Facet Terms,
    WW. Dakka, R. Dayal, and P. Ipeirotis
    in Proceedings of the ACM SIGIR 2006 Workshop on Faceted Search, 2006
24. Reputation Premiums in Electronic Peer-to-Peer Markets: Analyzing Textual Feedback and Network Structure,
    A. Ghose, P. Ipeirotis, and A. Sundararajan
    in ACM SIGCOMM 2005 Workshop Proceedings, Third Workshop on Economics of Peer-to-Peer Systems,  (P2PEcon 2005), 2005
25. Modeling Query-Based Access to Text Databases,
    E. Agichtein, P. Ipeirotis, and L. Gravano,
    in Proceedings of the Sixth ACM SIGMOD International Workshop on the Web and Databases (WebDB 2003), 2003 (25% accepted)
26. PERSIVAL Demo: Categorizing Hidden-Web Resources,
    P. Ipeirotis, L. Gravano, and M. Sahami,
    in Proceedings of the First ACM+IEEE Joint Conference on Digital Libraries (JCDL 2001), 2001
27. Automatic Classification of Text Databases through Query Probing,
    P. Ipeirotis, L. Gravano, and M. Sahami,
    in Proceedings of the Third International Workshop on the Web and Databases, (WebDB 2000), 2000 (29% accepted)
    (the work also appears in the ACM TOIS paper "QProber: A System for Automatic Classification of Hidden-Web Databases" and in the ACM SIGMOD 2001 conference paper "Probe, Count, and Classify: Categorizing Hidden-Web Databases")

Invited Papers

28. Designing Novel Review Ranking Systems: Predicting Usefulness and Impact of Reviews,
    A. Ghose and P. Ipeirotis,
    Proceedings of the Ninth International Conference on Electronic Commerce (ICEC 2007), 2007
29. Query- vs. Crawling-based Classification of Searchable Web Databases,
    L. Gravano, P. Ipeirotis, and M. Sahami,
    IEEE Data Engineering Bulletin, vol. 25, no. 1, March 2002
30. Using q-grams in a DBMS for Approximate String Processing,
    L. Gravano, P. Ipeirotis, H. V. Jagadish, N. Koudas, S. Muthukrishnan, L. Pietarinen, and D. Srivastava,
    IEEE Data Engineering Bulletin, vol. 24, no. 4, December 2001

Miscellaneous Publications

31. Stay Elsewhere? The Economic Impact of Location-based Hotel Features: A View from Remote Sensing Image Analysis
    B. Li, A. Ghose, and P. Ipeirotis
    Winter Conference on Business Intelligence, 2008
32. Designing Novel Review Ranking Systems on the Web: Combining Economics with Opinion Mining
    A. Ghose and P. Ipeirotis
    Third Research Symposium on Statistical Challenges in E-Commerce, 2007
33. Towards Automating the Pricing Power of Product Attributes: An Analysis of Online Product Reviews
    N. Archak, A. Ghose, and P. Ipeirotis,
    Winter Conference on Business Intelligence, 2007
34. Designing Ranking Systems for Consumer Reviews: The Economic Impact of Customer Sentiment in Electronic Markets
    A. Ghose and P. Ipeirotis,
    Proceedings of the International Conference on Decision Support Systems (ICDSS 2007), 2007
35. The Dimensions of Reputation in Electronic Markets,
    A. Ghose, P. Ipeirotis, and A. Sundararajan
    Second Research Symposium on Statistical Challenges in E-Commerce, 2006

Society membership

• Member of ACM since 1998
• Member of IEEE since 1998
• Technical Chamber of Greece, Chartered Engineer since 1999

University Service

• 2006: Global Task Force, Stern School of Business, New York University
• 2006-2007: NYU Institutional Repository Working Group, New York University
• 2005-2007: Information Systems / CeDER Research Seminar Coordinator, IOMS Department, New York University
• 2004-2007: PhD Committee, IOMS Department, New York University
• 1999-2004: PhD Admissions Committee, Student member, Computer Science Department, Columbia University
• 2000-2001: Webmaster, Hellenic Association, Columbia University
• 2000-2002: Webmaster, Database Research Group, Columbia University
• 1995-1998:  Board of Directors, Elected Student Representative, Computer Engineering and Informatics Department, University of Patras, Greece

Other Educational Activities

• Ph.D. Dissertation Committees: Ziyang Wang, Incremental Web Search: Tracking Changes in the Web, New York University, Computer Science Department, May 2006, Caryn Conley, May 2008; Gal Oestreicher-Singer, December 2007; Alpa Jain, May 2008; Wisam Dakka, May 2008
• Ph.D. Thesis Proposal Committees: Caryn Conley, December 2005; Gal Oestreicher-Singer, May 2006; Alpa Jain, January 2007; Wisam Dakka, February 2007

Last Modified: Tuesday, 28-Oct-2008 22:27:54 EDT