Jinsoo Lee

dblp:55/1346 · DBLP profile ↗
← Back
13ranked-venue papers
3as first author
1since 2021 · last 2021
—ORCID · none

Domains — the database's venue-derived domains; a paper can count in several

Databases, data management, data science and information retrieval · 8 · 1 first-authorApplied, interdisciplinary, general and emerging computing · 2 · 1 first-authorArtificial intelligence and machine learning · 1Systems, architecture and hardware · 1 · 1 since 2021Graphics, computer vision, multimedia, augmented reality and games · 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
9 papers
Graph data management · 63% Query processing and optimization · 16% Spatial and temporal data management · 10%
Computer architecture, parallel and distributed computing, and storage systems
5 papers
Performance modeling and evaluation · 40% Parallel and multicore computing · 34% Distributed systems · 26%
Theoretical computer science
1 paper
Graph algorithms and graph theory · 100%

Topics — the 19 heaviest of 19, each with the papers that count most for it

TopicWeightPapersLastEvidence papers
Graph data management › graph query processing
distributed graph queries
0.512021
aDFS: An Almost Depth-First-Search Distributed Graph-Querying System · USENIX ATC 2021
Graph data management
graph query processing
0.322013
Turboiso: towards ultrafast and robust subgraph isomorphism search in large graph databases · SIGMOD Conference 2013
An In-depth Comparison of Subgraph Isomorphism Algorithms in Graph Databases · Proc. VLDB Endow. 2012
Graph data management › graph pattern matching › subgraph matching
subgraph isomorphism
0.322012
An In-depth Comparison of Subgraph Isomorphism Algorithms in Graph Databases · Proc. VLDB Endow. 2012
iGraph: A Framework for Comparisons of Disk-Based Graph Indexing Techniques · Proc. VLDB Endow. 2010
Graph data management › graph indexing
disk-based graph indexing
0.222011
iGraph in action: performance analysis of disk-based graph indexing techniques · SIGMOD Conference 2011
iGraph: A Framework for Comparisons of Disk-Based Graph Indexing Techniques · Proc. VLDB Endow. 2010
Graph data management
graph indexing
0.222011
iGraph in action: performance analysis of disk-based graph indexing techniques · SIGMOD Conference 2011
iGraph: A Framework for Comparisons of Disk-Based Graph Indexing Techniques · Proc. VLDB Endow. 2010
Performance modeling and evaluation
benchmarking
0.222011
iGraph in action: performance analysis of disk-based graph indexing techniques · SIGMOD Conference 2011
iGraph: A Framework for Comparisons of Disk-Based Graph Indexing Techniques · Proc. VLDB Endow. 2010
Spatial and temporal data management › time series data management
subsequence matching
0.222011
A new approach for processing ranked subsequence matching based on ranked union · SIGMOD Conference 2011
Ranked Subsequence Matching in Time-Series Databases · VLDB 2007
Query processing and optimization › query optimization
parallel query optimization
0.222009
Dependency-aware reordering for parallelizing query optimization in multi-core CPUs · SIGMOD Conference 2009
Parallelizing query optimization · Proc. VLDB Endow. 2008
Query processing and optimization
query optimization
0.222009
Dependency-aware reordering for parallelizing query optimization in multi-core CPUs · SIGMOD Conference 2009
Parallelizing query optimization · Proc. VLDB Endow. 2008
Graph data management › graph pattern matching
subgraph isomorphism query
0.212013
Turboiso: towards ultrafast and robust subgraph isomorphism search in large graph databases · SIGMOD Conference 2013
Graph algorithms and graph theory
subgraph isomorphism
0.212013
Turboiso: towards ultrafast and robust subgraph isomorphism search in large graph databases · SIGMOD Conference 2013
Distributed systems › distributed database
distributed query processing
0.112021
aDFS: An Almost Depth-First-Search Distributed Graph-Querying System · USENIX ATC 2021
Information retrieval › retrieval models
ranked retrieval
0.122011
A new approach for processing ranked subsequence matching based on ranked union · SIGMOD Conference 2011
Ranked Subsequence Matching in Time-Series Databases · VLDB 2007
Data mining › pattern mining › association rule mining
rule pruning
0.112012
An In-depth Comparison of Subgraph Isomorphism Algorithms in Graph Databases · Proc. VLDB Endow. 2012
Query processing and optimization › query optimization
join enumeration
0.112008
Parallelizing query optimization · Proc. VLDB Endow. 2008
Parallel and multicore computing › parallel algorithms › dynamic programming
parallel dynamic programming
0.112008
Parallelizing query optimization · Proc. VLDB Endow. 2008
Parallel and multicore computing
parallel programming models
0.112008
Parallelizing query optimization · Proc. VLDB Endow. 2008
Spatial and temporal data management › time series data management
time series database
0.112007
Ranked Subsequence Matching in Time-Series Databases · VLDB 2007
Parallel and multicore computing › parallel computing
multicore parallelism
0.012009
Dependency-aware reordering for parallelizing query optimization in multi-core CPUs · SIGMOD Conference 2009

Methods — techniques the papers use, named apart from their topics

neighborhood equivalence class · 0.3combine and permute strategy · 0.3candidate region exploration · 0.3visual performance analysis · 0.2pipelining · 0.2dependency-aware reordering · 0.2re-implementation · 0.1empirical comparison · 0.1matching subsequence equivalence class · 0.1cost-aware density-based scheduling · 0.1synchronization-free MEMO · 0.1skip vector array · 0.1dynamic programming · 0.1
YearPublicationVenuePosition
2021 aDFS: An Almost Depth-First-Search Distributed Graph-Querying System
Vasileios Trigonakis, Jean-Pierre Lozi, Tomás Faltín, Nicholas P. Roth, Iraklis Psaroudakis, Arnaud Delamare, Vlad Haprian, Calin Iorgulescu, Petr Koupy, Jinsoo Lee, Sungpack Hong, Hassan Chafi
USENIX ATC10
2013 Extended communication interface for remote vehicle diagnosis using Internet Protocol
abstract
Nowadays, vehicles have a lot of Electronic Control Unit (ECU). In order to check ECU software reprogramming and ECU assembly line inspection, international standards are developed. Among the standards the Diagnostic Communication over Internet Protocol (DoIP) is a typical protocol for remote diagnostic of vehicles which consists of International Standard Organization (ISO) 13400 parts. The DoIP just consider in-vehicle scenario where the communication range is a Local Area Network (LAN). In this paper, we propose a new communication interface extends the communication range to Wide Area Network (WAN) to implement remote vehicle diagnosis. The simulation results show that the CPU Utilization Threshold Area (CUTA) is between -20.70266 and 20.70266 which implies remote vehicle diagnosis is possible from the long distance site.
Jinsoo Lee, Eunjo Lee, Sungkwon Park
APCC1
2013 Turboiso: towards ultrafast and robust subgraph isomorphism search in large graph databases
abstract
Given a query graph q and a data graph g, the subgraph isomorphism search finds all occurrences of q in g and is considered one of the most fundamental query types for many real applications. While this problem belongs to NP-hard, many algorithms have been proposed to solve it in a reasonable time for real datasets. However, a recent study has shown, through an extensive benchmark with various real datasets, that all existing algorithms have serious problems in their matching order selection. Furthermore, all algorithms blindly permutate all possible mappings for query vertices, often leading to useless computations. In this paper, we present an efficient and robust subgraph search solution, called TurboISO, which is turbo-charged with two novel concepts, candidate region exploration and the combine and permute strategy (in short, Comb/Perm). The candidate region exploration identifies on-the-fly candidate subgraphs (i.e, candidate regions), which contain embeddings, and computes a robust matching order for each candidate region explored. The Comb/Perm strategy exploits the novel concept of the neighborhood equivalence class (NEC). Each query vertex in the same NEC has identically matching data vertices. During subgraph isomorphism search, Comb/Perm generates only combinations for each NEC instead of permutating all possible enumerations. Thus, if a chosen combination is determined to not contribute to a complete solution, all possible permutations for that combination will be safely pruned. Extensive experiments with many real datasets show that TurboISO consistently and significantly outperforms all competitors by up to several orders of magnitude.
Wook-Shin Han, Jinsoo Lee, Jeonghoon Lee 0004
SIGMOD Conference2
2012 An In-depth Comparison of Subgraph Isomorphism Algorithms in Graph Databases
abstract
Finding subgraph isomorphisms is an important problem in many applications which deal with data modeled as graphs. While this problem is NP-hard, in recent years, many algorithms have been proposed to solve it in a reasonable time for real datasets using different join orders, pruning rules, and auxiliary neighborhood information. However, since they have not been empirically compared one another in most research work, it is not clear whether the later work outperforms the earlier work. Another problem is that reported comparisons were often done using the original authors' binaries which were written in different programming environments. In this paper, we address these serious problems by re-implementing five state-of-the-art subgraph isomorphism algorithms in a common code base and by comparing them using many real-world datasets and their query loads. Through our in-depth analysis of experimental results, we report surprising empirical findings.
Jinsoo Lee, Wook-Shin Han, Romans Kasperovics, Jeonghoon Lee 0004
Proc. VLDB Endow.1
2011 A new approach for processing ranked subsequence matching based on ranked union
abstract
Ranked subsequence matching finds top-k subsequences most similar to a given query sequence from data sequences. Recently, Han et al. [12] proposed a solution (referred to here as HLMJ) to this problem by using the concept of the minimum distance matching window pair (MDMWP) and a global priority queue. By using the concept of MDMWP, HLMJ can prune many unnecessary accesses to data subsequences using a lower bound distance. However, we notice that HLMJ may incur serious performance overhead for important types of queries. In this paper, we propose a novel systematic framework to solve this problem by viewing ranked subsequence matching as ranked union. Specifically, we propose a notion of the matching subsequence equivalence class (MSEQ) and a novel lower bound called the MSEQ-distance. To completely eliminate the performance problem of HLMJ, we also propose a cost-aware density-based scheduling technique, where we consider both the density and cost of the priority queue. Extensive experimental results with many real datasets show that the proposed algorithm outperforms HLMJ and the adapted PSM [22], a state-of-the-art index-based merge algorithm supporting non-monotonic distance functions, by up to two to three orders of magnitude, respectively.
Wook-Shin Han, Jinsoo Lee, Yang-Sae Moon, Seung-won Hwang, Hwanjo Yu
SIGMOD Conference2
2011 iGraph in action: performance analysis of disk-based graph indexing techniques
abstract
Graphs provide a powerful way to model complex structures such as chemical compounds, proteins, images, and program dependence. The previous practice for experiments in graph indexing techniques is that the author of a newly proposed technique does not implement existing indexes on his own code base, but instead uses the original authors' binary executables and reports only the wall clock time. However, we observed that this practice may result in several problems [6]. In order to address these problems, we have implemented all representative graph indexing techniques on a common framework called iGraph [6]. In this demonstration we showcase iGraph and its visual tools using several real datasets and their workloads. For selected queries of the workloads, we show several unique features including visual performance analysis.
Wook-Shin Han, Minh-Duc Pham, Jinsoo Lee, Romans Kasperovics, Jeffrey Xu Yu
SIGMOD Conference3
2011 Processing SPARQL queries with regular expressions in RDF databases
abstract
BACKGROUND: As the Resource Description Framework (RDF) data model is widely used for modeling and sharing a lot of online bioinformatics resources such as Uniprot (dev.isb-sib.ch/projects/uniprot-rdf) or Bio2RDF (bio2rdf.org), SPARQL - a W3C recommendation query for RDF databases - has become an important query language for querying the bioinformatics knowledge bases. Moreover, due to the diversity of users' requests for extracting information from the RDF data as well as the lack of users' knowledge about the exact value of each fact in the RDF databases, it is desirable to use the SPARQL query with regular expression patterns for querying the RDF data. To the best of our knowledge, there is currently no work that efficiently supports regular expression processing in SPARQL over RDF databases. Most of the existing techniques for processing regular expressions are designed for querying a text corpus, or only for supporting the matching over the paths in an RDF graph. RESULTS: In this paper, we propose a novel framework for supporting regular expression processing in SPARQL query. Our contributions can be summarized as follows. 1) We propose an efficient framework for processing SPARQL queries with regular expression patterns in RDF databases. 2) We propose a cost model in order to adapt the proposed framework in the existing query optimizers. 3) We build a prototype for the proposed framework in C++ and conduct extensive experiments demonstrating the efficiency and effectiveness of our technique. CONCLUSIONS: Experiments with a full-blown RDF engine show that our framework outperforms the existing ones by up to two orders of magnitude in processing SPARQL queries with regular expression patterns.
Jinsoo Lee, Minh-Duc Pham, Wook-Shin Han, Hune Cho, Hwanjo Yu, Jeonghoon Lee 0004
BMC Bioinform.1
2010 Exposure balancing and difference blurring to eliminate seam-lines in a real-time bird's eye view monitor
abstract
A Bird's Eye View Monitor usually shows visible seam-lines. Previous seam-line elimination methods limit the dynamic range of mosaicked image and require that the reference images are equal geometrically the regions that overlap. In this paper, we propose a camera model based alternative exposure compensation algorithm which controls brightness of reference images using calculated offset, and a seam-line difference blurring algorithm which gradually spreads the pixel by pixel difference of a seam-line over across the seam-line with no geometrical assumption. Moreover, we generalize the compensation algortihm for a circularly positioned and consecutively positioned N reference image mosaicking system. Our approach aims at extending the dynamic range, eliminating ghost images, and increasing system efficiency. Proposed algorithms run on real-time systems. Results are demonstrated using several images.
Sangseok Hong, Jinsoo Lee, Sang-Bok Choi
ICARCV2
2010 iGraph: A Framework for Comparisons of Disk-Based Graph Indexing Techniques
abstract
Graphs are of growing importance in modeling complex structures such as chemical compounds, proteins, images, and program dependence. Given a query graph Q , the subgraph isomorphism problem is to find a set of graphs containing Q from a graph database, which is NP-complete. Recently, there have been a lot of research efforts to solve the subgraph isomorphism problem for a large graph database by utilizing graph indexes. By using a graph index as a filter, we prune graphs that are not real answers at an inexpensive cost. Then, we need to use expensive subgraph isomorphism tests to verify filtered candidates only. This way, the number of disk I/Os and subgraph isomorphism tests can be significantly minimized. The current practice for experiments in graph indexing techniques is that the author of a newly proposed technique does not implement existing indexes on his own code base, but instead uses the original authors' binary executables and reports only the wall clock time. However, we observe this practice may result in several problems. In order to address these problems, we have made significant efforts in implementing all representative indexing methods on a common framework called iGraph. Unlike existing implementations which either use (full or partial) in-memory representations or rely on OS file system cache without guaranteeing real disk I/Os, we have implemented these indexes on top of a storage engine that guarantees real disk I/Os. Through extensive experiments using many synthetic and real datasets, we also provide new empirical findings in the performance of the full disk-based implementations of these methods.
Wook-Shin Han, Jinsoo Lee, Minh-Duc Pham, Jeffrey Xu Yu
Proc. VLDB Endow.2
2009 Dependency-aware reordering for parallelizing query optimization in multi-core CPUs
abstract
The state of the art commercial query optimizers employ cost-based optimization and exploit dynamic programming (DP) to find the optimal query execution plan (QEP) without evaluating redundant sub-plans. The number of alternative QEPs enumerated by the DP query optimizer can increase exponentially, as the number of joins in the query increases. Recently, by exploiting the coming wave of multi-core processor architectures, a state of the art parallel optimization algorithm [14], referred to as PDPsva, has been proposed to parallelize the "time-consuming" DP query optimization process itself. While PDPsva significantly extends the practical use of DP to queries having up to 20-25 tables, it has several limitations: 1) supporting only the size-driven DP enumerator, 2) statically allocating search space, and 3) not fully exploiting parallelism. In this paper, we propose the first generic solution for parallelizing any type of bottom-up optimizer, including the graph-traversal driven type, and for supporting dynamic search allocation and full parallelism. This is a challenging problem, since recently developed, state of art DP optimizers such as DPcpp [21] and DPhyp [22] are very difficult to parallelize due to tangled dependencies in the join pairs they generate. Unless the solution is very carefully devised, a lot of synchronization conflicts are bound to occur. By viewing a serial bottom-up optimizer as one which generates a totally ordered sequence of join pairs in a streaming fashion, we propose a novel concept of dependency-aware reordering, which minimizes waiting time caused by dependencies of join pairs. To maximize parallelism, we also introduce a series of novel performance optimization techniques: 1) pipelining of join pair generation and plan generation; 2) the synchronization-free global MEMO; and 3) threading across dependencies. Through extensive experiments with various query topologies, we show that our solution supports any type of bottom up optimization, achieving linear speedup for each type. Despite the fact that our solution is generic, due to sophisticated optimization techniques, our generic parallel optimizer outperforms PDPsva tailored to size-driven enumeration. Experimental results also show that our solution is much more robust than PDPsva with respect to search space allocation.
Wook-Shin Han, Jinsoo Lee
SIGMOD Conference2
2008 Parallelizing query optimization
abstract
Many commercial RDBMSs employ cost-based query optimization exploiting dynamic programming (DP) to efficiently generate the optimal query execution plan. However, optimization time increases rapidly for queries joining more than 10 tables. Randomized or heuristic search algorithms reduce query optimization time for large join queries by considering fewer plans, sacrificing plan optimality. Though commercial systems executing query plans in parallel have existed for over a decade, the optimization of such plans still occurs serially. While modern microprocessors employ multiple cores to accelerate computations, parallelizing query optimization to exploit multi-core parallelism is not as straightforward as it may seem. The DP used in join enumeration belongs to the challenging nonserial polyadic DP class because of its non-uniform data dependencies. In this paper, we propose a comprehensive and practical solution for parallelizing query optimization in the multi-core processor architecture, including a parallel join enumeration algorithm and several alternative ways to allocate work to threads to balance their load. We also introduce a novel data structure called skip vector array to significantly reduce the generation of join partitions that are infeasible. This solution has been prototyped in PostgreSQL. Extensive experiments using various query graph topologies confirm that our algorithms allocate the work evenly, thereby achieving almost linear speed-up. Our parallel join enumeration algorithm enhanced with our skip vector array outperforms the conventional generate-and-filter DP algorithm by up to two orders of magnitude for star queries-linear speedup due to parallelism and an order of magnitude performance improvement due to the skip vector array.
Wook-Shin Han, Wooseong Kwak, Jinsoo Lee, Guy M. Lohman, Volker Markl
Proc. VLDB Endow.3
2007 A Scalable Pipeline Data Processing Framework Using Database and Visualization Techniques
Wook-Shin Han, Soon Ki Jung, Jeyong Shin, Jinsoo Lee, Mina Yoon, Chang Geol Yoon, Won Seok Seo, Sang Ok Koo
ICIC (1)4
2007 Ranked Subsequence Matching in Time-Series Databases
Wook-Shin Han, Jinsoo Lee, Yang-Sae Moon
VLDB2