Demo Data from EDBT 2026 / reviewers in the wild / expert
John McPherson
dblp:02/5355
· DBLP profile ↗
12ranked-venue papers
0as first author
0since 2021 · last 2014
0000-0003-3371-7481ORCID · corroborated
Domains — the database's venue-derived domains; a paper can count in several
Databases, data management, data science and information retrieval · 11Artificial intelligence and machine learning · 2Software engineering, systems software and programming languages · 1
Expertise — from the expertise taxonomy: the topics of the expert's papers under the CCF categories. A weight counts papers with recency: 1 for a paper about the topic, 0.3 when the topic is its context, halved every five years.
| Databases, data mining, and information retrieval
10 papers |
Graph data management · 31% Distributed and cloud data management · 29% Web and social media mining · 24% | |
| Computer architecture, parallel and distributed computing, and storage systems
4 papers |
GPUs and heterogeneous computing · 44% Storage systems · 24% High-performance computing · 17% |
Topics — the 21 heaviest of 24, each with the papers that count most for it
| Topic | Weight | Papers | Last | Evidence papers |
|---|---|---|---|---|
Query processing and optimization
analytical query processing |
0.2 | 1 | 2013 | WOW: what the world of (data) warehousing can learn from the World of Warcraft · SIGMOD Conference 2013 |
Graph data management
distributed graph processing |
0.2 | 1 | 2013 | From "Think Like a Vertex" to "Think Like a Graph" · Proc. VLDB Endow. 2013 |
Graph data management
graph partitioning |
0.2 | 1 | 2013 | From "Think Like a Vertex" to "Think Like a Graph" · Proc. VLDB Endow. 2013 |
GPUs and heterogeneous computing
GPU query processing |
0.2 | 1 | 2013 | WOW: what the world of (data) warehousing can learn from the World of Warcraft · SIGMOD Conference 2013 |
Web and social media mining › location-based social network
event-based social networks |
0.1 | 1 | 2012 | Event-based social networks: linking the online and offline social worlds · KDD 2012 |
Web and social media mining
social network analysis |
0.1 | 1 | 2012 | Event-based social networks: linking the online and offline social worlds · KDD 2012 |
Distributed and cloud data management
data placement |
0.1 | 1 | 2011 | CoHadoop: Flexible Data Placement and Its Exploitation in Hadoop · Proc. VLDB Endow. 2011 |
Distributed and cloud data management
mapreduce |
0.1 | 1 | 2011 | CoHadoop: Flexible Data Placement and Its Exploitation in Hadoop · Proc. VLDB Endow. 2011 |
Storage systems › file systems
distributed file system |
0.0 | 2 | 2011 | CoHadoop: Flexible Data Placement and Its Exploitation in Hadoop · Proc. VLDB Endow. 2011 Implementing Atomicity in Two Systems: Techniques, Tradeoffs, and Experience · IEEE Trans. Software Eng. 1993 |
Distributed systems
fault tolerance |
0.0 | 1 | 2011 | CoHadoop: Flexible Data Placement and Its Exploitation in Hadoop · Proc. VLDB Endow. 2011 |
High-performance computing › data-intensive computing
large-scale data analytics |
0.0 | 1 | 2010 | Ricardo: integrating R and Hadoop · SIGMOD Conference 2010 |
High-performance computing
scientific computing systems |
0.0 | 1 | 2010 | Ricardo: integrating R and Hadoop · SIGMOD Conference 2010 |
Distributed systems › transaction processing
atomicity |
0.0 | 1 | 1993 | Implementing Atomicity in Two Systems: Techniques, Tradeoffs, and Experience · IEEE Trans. Software Eng. 1993 |
Distributed systems › distributed database
commit protocol |
0.0 | 1 | 1993 | Implementing Atomicity in Two Systems: Techniques, Tradeoffs, and Experience · IEEE Trans. Software Eng. 1993 |
Database system architecture and tuning
relational database system |
0.0 | 2 | 1990 | Starburst Mid-Flight: As the Dust Clears · IEEE Trans. Knowl. Data Eng. 1990 A Data Management Extension Architecture · SIGMOD Conference 1987 |
Database system architecture and tuning
extensible database system |
0.0 | 1 | 1990 | Starburst Mid-Flight: As the Dust Clears · IEEE Trans. Knowl. Data Eng. 1990 |
Query processing and optimization
join processing |
0.0 | 1 | 1990 | An Incremental Join Attachment for Starburst · VLDB 1990 |
Database system architecture and tuning › extensible database system
extensible database architecture |
0.0 | 1 | 1987 | A Data Management Extension Architecture · SIGMOD Conference 1987 |
Transaction processing and concurrency control
atomicity |
0.0 | 1 | 1993 | Implementing Atomicity in Two Systems: Techniques, Tradeoffs, and Experience · IEEE Trans. Software Eng. 1993 |
Data models and query languages
query language |
0.0 | 1 | 1991 | Starburst II: The Extender Strikes Back! · SIGMOD Conference 1991 |
Data models and query languages
SQL |
0.0 | 1 | 1991 | Starburst II: The Extender Strikes Back! · SIGMOD Conference 1991 |
Methods — techniques the papers use, named apart from their topics
data partitioning · 0.2colocation hints · 0.2r statistical analysis · 0.2mapreduce · 0.2algorithm decomposition · 0.2message passing · 0.2logging · 0.0concurrency control · 0.0query optimization · 0.0extensibility · 0.0
| Year | Publication | Venue | Position |
|---|---|---|---|
| 2014 | Distributed Graph SummarizationabstractGraph has been a ubiquitous and essential data representation to model real world objects and their relationships. Today, large amounts of graph data have been generated by various applications. Graph summarization techniques are crucial in uncovering useful insights about the patterns hidden in the underlying data. However, all existing works in graph summarization are single-process solutions, and as a result cannot scale to large graphs. In this paper, we introduce three distributed graph summarization algorithms to address this problem. Experimental results show that the proposed algorithms can produce good quality summaries and scale well with increasing data sizes. To the best of our knowledge, this is the first work to study distributed graph summarization methods. Xingjie Liu, Yuanyuan Tian 0001, Qi He 0002, Wang-Chien Lee, John McPherson |
CIKM | 5 |
| 2013 | WOW: what the world of (data) warehousing can learn from the World of WarcraftabstractAlthough originally designed to accelerate pixel monsters, graphics Processing Units (GPUs) have been used for some time as accelerators for selected data base operations. However, to the best of our knowledge, no one has yet reported building a complete system that allows executing complex analytics queries, much less an entire data warehouse benchmark at realistic scale. In this demo, we showcase such a complete system prototype running on a high-end GPU paired with an IBM storage system that achieves >90% hardware efficiency. Our solution delivers sustainable high throughput for business analytics queries in a realistic scenario, i.e., the Star Schema Benchmark at scale factor 1,000. Attendees can interact with our system through a graphical user interface on a tablet PC. They will be able to experience first hand how queries that require processing more than six billion rows, or 100 GB of data, are answered in less than 20 seconds. The user interface allows submitting queries, live performance monitoring of the current query all the way down to the operator level, and viewing the result once the query completes. René Müller 0001, Tim Kaldewey, Guy M. Lohman, John McPherson |
SIGMOD Conference | 4 |
| 2013 | From "Think Like a Vertex" to "Think Like a Graph"abstractTo meet the challenge of processing rapidly growing graph and network data created by modern applications, a number of distributed graph processing systems have emerged, such as Pregel and GraphLab. All these systems divide input graphs into partitions, and employ a "think like a vertex" programming model to support iterative graph computation. This vertex-centric model is easy to program and has been proved useful for many graph algorithms. However, this model hides the partitioning information from the users, thus prevents many algorithm-specific optimizations. This often results in longer execution time due to excessive network messages (e.g. in Pregel) or heavy scheduling overhead to ensure data consistency (e.g. in GraphLab). To address this limitation, we propose a new "think like a graph" programming paradigm. Under this graph-centric model, the partition structure is opened up to the users, and can be utilized so that communication within a partition can bypass the heavy message passing or scheduling machinery. We implemented this model in a new system, called Giraph++, based on Apache Giraph, an open source implementation of Pregel. We explore the applicability of the graph-centric model to three categories of graph algorithms, and demonstrate its flexibility and superior performance, especially on well-partitioned data. For example, on a web graph with 118 million vertices and 855 million edges, the graph-centric version of connected component detection algorithm runs 63X faster and uses 204X fewer network messages than its vertex-centric counterpart. Yuanyuan Tian 0001, Andrey Balmin, Severin Andreas Corsten, Shirish Tatikonda, John McPherson |
Proc. VLDB Endow. | 5 |
| 2012 | Event-based social networks: linking the online and offline social worldsabstractNewly emerged event-based online social services, such as Meetup and Plancast, have experienced increased popularity and rapid growth. From these services, we observed a new type of social network - event-based social network (EBSN). An EBSN does not only contain online social interactions as in other conventional online social networks, but also includes valuable offline social interactions captured in offline activities. By analyzing real data collected from Meetup, we investigated EBSN properties and discovered many unique and interesting characteristics, such as heavy-tailed degree distributions and strong locality of social interactions. Xingjie Liu, Qi He 0002, Yuanyuan Tian 0001, Wang-Chien Lee, John McPherson, Jiawei Han 0001 |
KDD | 5 |
| 2011 | CoHadoop: Flexible Data Placement and Its Exploitation in HadoopabstractHadoop has become an attractive platform for large-scale data analytics. In this paper, we identify a major performance bottleneck of Hadoop: its lack of ability to colocate related data on the same set of nodes. To overcome this bottleneck, we introduce CoHadoop, a lightweight extension of Hadoop that allows applications to control where data are stored. In contrast to previous approaches, CoHadoop retains the flexibility of Hadoop in that it does not require users to convert their data to a certain format (e.g., a relational database or a specific file format). Instead, applications give hints to CoHadoop that some set of files are related and may be processed jointly; CoHadoop then tries to colocate these files for improved efficiency. Our approach is designed such that the strong fault tolerance properties of Hadoop are retained. Colocation can be used to improve the efficiency of many operations, including indexing, grouping, aggregation, columnar storage, joins, and sessionization. We conducted a detailed study of joins and sessionization in the context of log processing---a common use case for Hadoop---, and propose efficient map-only algorithms that exploit colocated data partitions. In our experiments, we observed that CoHadoop outperforms both plain Hadoop and previous work. In particular, our approach not only performs better than repartition-based algorithms, but also outperforms map-only algorithms that do exploit data partitioning but not colocation. 8. Mohamed Y. Eltabakh, Yuanyuan Tian 0001, Fatma Özcan 0001, Rainer Gemulla, Aljoscha Krettek, John McPherson |
Proc. VLDB Endow. | 6 |
| 2010 | Ricardo: integrating R and HadoopabstractMany modern enterprises are collecting data at the most detailed level possible, creating data repositories ranging from terabytes to petabytes in size. The ability to apply sophisticated statistical analysis methods to this data is becoming essential for marketplace competitiveness. This need to perform deep analysis over huge data repositories poses a significant challenge to existing statistical software and data management systems. On the one hand, statistical software provides rich functionality for data analysis and modeling, but can handle only limited amounts of data; e.g., popular packages like R and SPSS operate entirely in main memory. On the other hand, data management systems - such as MapReduce-based systems - can scale to petabytes of data, but provide insufficient analytical functionality. We report our experiences in building Ricardo, a scalable platform for deep analytics. Ricardo is part of the eXtreme Analytics Platform (XAP) project at the IBM Almaden Research Center, and rests on a decomposition of data-analysis algorithms into parts executed by the R statistical analysis system and parts handled by the Hadoop data management system. This decomposition attempts to minimize the transfer of data across system boundaries. Ricardo contrasts with previous approaches, which try to get along with only one type of system, and allows analysts to work on huge datasets from within a popular, well supported, and powerful analysis environment. Because our approach avoids the need to re-implement either statistical or data-management functionality, it can be used to solve complex problems right now. Sudipto Das, Yannis Sismanis, Kevin S. Beyer, Rainer Gemulla, Peter J. Haas, John McPherson |
SIGMOD Conference | 6 |
| 2006 | Indexing Shared Content in Information Retrieval Systems
Andrei Z. Broder, Nadav Eiron, Marcus Fontoura, Michael Herscovici, Ronny Lempel, John McPherson, Runping Qi, Eugene J. Shekita |
EDBT | 6 |
| 1993 | Implementing Atomicity in Two Systems: Techniques, Tradeoffs, and ExperienceabstractThis paper presents our experience with implementing atomicity in two systems: the QuickSilver distributed file system and the Starburst relational database manager. Each of these systems guarantees that certain collections of operations done on behalf of their clients execute atomically, despite process, machine, or network failures. In this paper we describe the atomic properties implemented by each system, present the algorithms and mechanisms used, examine the similarities and differences between the two systems, and give the rationale for different design decisions. We demonstrate that the support of atomicity with high performance requires a variety of techniques carefully chosen to balance the amount of data logged, the level of concurrency allowed, and the mutual consistency requirements of sets of objects, The main goal is to help others implement efficient systems that support atomicity.> Luis-Felipe Cabrera, John McPherson, Peter M. Schwarz, James C. Wyllie |
IEEE Trans. Software Eng. | 2 |
| 1991 | Starburst II: The Extender Strikes Back!abstractNo abstract available. Guy M. Lohman, George Lapis, Tobin J. Lehman, Rakesh Agrawal 0001, Roberta Cochrane, John McPherson, C. Mohan 0001, Hamid Pirahesh, Jennifer Widom |
SIGMOD Conference | 6 |
| 1990 | An Incremental Join Attachment for Starburst
Michael J. Carey 0001, Eugene J. Shekita, George Lapis, Bruce G. Lindsay 0001, John McPherson |
VLDB | 5 |
| 1990 | Starburst Mid-Flight: As the Dust ClearsabstractThe purpose of the Starburst project is to improve the design of relational database management systems and enhance their performance, while building an extensible system to better support nontraditional applications and to serve as a testbed for future improvements in database technology. The design and implementation of the Starburst system to date are considered. Some key design decisions and how they affect the goal of improved structure and performance are examined. How well the goal of extensibility has been met is examined: what aspects of the system are extensible, how extensions can be done, and how easy it is to add extensions. Some actual extensions to the system, including the experiences of the first real customizers, are discussed.> Laura M. Haas, Walter Chang, Guy M. Lohman, John McPherson, Paul F. Wilms, George Lapis, Bruce G. Lindsay 0001, Hamid Pirahesh, Michael J. Carey 0001, Eugene J. Shekita |
IEEE Trans. Knowl. Data Eng. | 4 |
| 1987 | A Data Management Extension ArchitectureabstractA database management system architecture is described that facilitates the implementation of data management extensions for relational database systems. The architecture defines two classes of data management extensions alternative ways of storing relations called relation “storage methods”, and access paths, integrity constraints, or triggers which are “attachments” to relations. Generic sets of operations are defined for storage methods and attachments, and these operations must be provided in order to add a new storage method or attachment type to the system. The data management extension architecture also provides common services for coordination of storage method and attachment execution. This article describes the data management extension architecture along with some implementation issues and techniques. Bruce G. Lindsay 0001, John McPherson, Hamid Pirahesh |
SIGMOD Conference | 2 |