Yannis Katsis
Project Scientist
Research Interests: data integration, analytics, and visualization

What's new

  • Video of our data exploration tool for population health:
    Check out this video for a first glimpse of our data exploration tool for public health. The tool (presented in the video by our School of Medicine collaborator Besa Smith), has been recently presented in a meeting with our collaborators from the Virginia Commonwealth University and the San Diego County Health and Human Services. The tool, which is still work in progress, has been developed in the context of the DELPHI project.

Research

      You can find below a list of all ongoing projects:

  • DELPHI:
    A platform for the integration, analysis and visualization of health data. The DELPHI project is a collaboration with the UC San Diego School of Medicine, Calit2 and the Department of Computer Science and Engineering. For more information on DELPHI please refer to our publication.

  • Plato:
    A declarative database management system for spatiotemporal sensor data. Plato enables the declarative querying of sensor data by representing the data through models (i.e., functions over the spatiotemporal domain), which can be generated through learning algorithms borrowed from the signal-processing literature. Representing data through models not only enables declarative querying, but also leads to compression, which in turn leads to both reduced storage requirements and increased efficiency in query processing. For a description of the architecture of the system, please see our publication in the 7th Biennial Conference on Innovative Data Systems Research (CIDR 2015).

  • FORWARD:
    A declarative web application development framework. By allowing the declarative specification of web applications, FORWARD enables the automatic incremental rendering of live visualizations, whenever the underlying data change, through the use of incremental view maintenance techniques. More details on the FORWARD framework (without the details on the incremental rendering features that are currently prepared for submission) can be found on the project's web-site.

  • Ricolla:
    A system for the management of conflicting data in online databases. Ricolla allows the storage and querying of conflicting data by leveraging ideas from models on uncertain data. However, in contrast to existing models for uncertain data that are non-intuitive, Ricolla's data model is, while expressive enough, suitable for the user interface of online databases. Additionally, the reduced expressiveness of Ricolla's data model leads also to more efficient storage solutions, allowing Ricolla to provide significantly better scalability w.r.t. the represented conflicts than existing systems for uncertain data. You can find more information about the system in our technical report.

  • idIVM:
    An incremental view maintenance (IVM) system for relational databases that leverages the existence of keys in the database relations to significantly improve the performance of IVM. idIVM has been shown both theoretically and experimentally to outperform state-of-the-art IVM approaches on most common scenarios. Details on the system together with the theoretical and experimental analyses can be found in our ACM SIGMOD 2015 publication.

Random Bits

  • Photography:
    When out of the office, you may see me taking photos. You can check out some of my photos on my flickr photostream.

  • Greek culture and education:
    If you live in the San Diego area and are interested in the Greek culture or you are from Greece and have questions about UC San Diego, check out the Hellenic Student Association. If you are an undergraduate student in a Greek university, consider applying to the week-long US Educational Trip organized by the Corallia institute.

Publications

Research Publications

  • Live Visualizations with FORWARD: Incrementally Computing and Rendering MVVM Templates
    Yannis Katsis, Yannis Papakonstantinou, Kian Win Ong, Konstantinos Zarifis
    (In preparation)

  • With Great Freedom for Inconsistent Data Comes Great Scalability Responsibility [PDF]
    Yannis Katsis, Alin Deutsch, Yannis Papakonstantinou, Vasilis Vassalos
    (Technical Report)

  • Utilizing IDs to Accelerate Incremental View Maintenance [PDF]
    Yannis Katsis, Kian Win Ong, Yannis Papakonstantinou, Kevin Keliang Zhao
    (ACM SIGMOD 2015)

  • Combining Databases and Signal Processing in Plato [PDF]
    Yannis Katsis, Yoav Freund, Yannis Papakonstantinou
    (CIDR 2015)

  • Complete Yet Practical Search for Minimal Query Reformulations under Constraints [PDF]
    Ioana Ileana, Bogdan Cautis, Alin Deutsch, Yannis Katsis
    (ACM SIGMOD 2014)

  • On the Equivalence of Distributed Systems with Queries and Communication [PDF]
    Serge Abiteboul, Balder ten Cate, Yannis Katsis
    (Journal of Computer and System Sciences, 2013)

  • Growing Triples on Trees: An XML-RDF Hybrid Model for Annotated Documents [PDF]
    Francois Goasdoue, Konstantinos Karanasos, Yannis Katsis, Julien Leblay, Ioana Manolescu, Stamatis Zampetakis
    (The VLDB Journal, October 2013)

  • DELPHI: Data E-Platform for Personalized Population Health [PDF]
    Yannis Katsis, Sanjoy Dasgupta, William G. Griswold, Ted Chan, Claudiu Farcas, Jeannie Huang, Yannis Papakonstantinou, Lucila Ohno-Machado, Fredric Raab, Kevin Patrick
    (Healthcom, 2013)

  • Query Containment in Entity SQL (Extended Abstract) [PDF]
    Guillem Rull, Philip A. Bernstein, Ivo Garcia dos Santos, Yannis Katsis, Sergey Melnik, Ernest Teniente
    (ACM SIGMOD Industrial 2013)

  • Fast-checking the Web [PDF]
    Francois Goasdoue, Konstantinos Karanasos, Yannis Katsis, Julien Leblay, Ioana Manolescu, Stamatis Zampetakis
    (ACM SIGMOD Demo 2013)

  • On the Equivalence of Distributed Systems with Queries and Communication [PDF]
    Serge Abiteboul, Balder ten Cate, Yannis Katsis
    (ICDT 2011)

  • Growing Triples on Trees: An XML-RDF Hybrid Model for Annotated Documents [PDF]
    Francois Goasdoue, Konstantinos Karanasos, Yannis Katsis, Julien Leblay, Ioana Manolescu, Stamatis Zampetakis
    (VLDS 2011)

  • Inconsistency Resolution in Online Databases [PDF]
    Yannis Katsis, Alin Deutsch, Yannis Papakonstantinou, Vasilis Vassalos
    (ICDE Demo 2010)

  • View-based Data Integration [PDF]
    Yannis Katsis, Yannis Papakonstantinou
    (Encyclopedia of Database Systems, 2009)

  • Interactive Source Registration in Community-oriented Information Integration [PDF]
    Yannis Katsis, Alin Deutsch, Yannis Papakonstantinou
    (VLDB 2008)

  • RIDE: A Tool for Interactive Source Registration in Community-oriented Information Integration [PDF]
    Yannis Katsis, Alin Deutsch, Yannis Papakonstantinou, Keliang Zhao
    (VLDB Demo 2008)

  • Simplifying Information Integration: Object-Based Flow-of-Mappings Framework for Integration [PDF]
    Bogdan Alexe, Michael Gubanov, Mauricio A. Hernandez, Howard Ho, Jen-Wei Huang, Yannis Katsis, Lucian Popa, Barna Saha, Ioana Stanoi
    (BIRTE 2008)

  • Exporting and Interactively Querying Web-Service-Accessed Sources: The CLIDE System [PDF]
    Michalis Petropoulos, Alin Deutsch, Yannis Papakonstantinou, Yannis Katsis
    (TODS 2007)

  • Determining Source Contribution in Integration Systems [PDF]
    Alin Deutsch, Yannis Katsis, Yannis Papakonstantinou
    (PODS 2005)

Patents

  • Web-page-based System for Designing Database driven Web Applications [Link]
    Yannis Papakonstantinou, Kian Win Ong, Yannis Katsis
    (US 7971148 B2)