Demo Data from EDBT 2026 / reviewers in the wild / expert
Ekow J. Otoo
dblp:10/3587
· DBLP profile ↗
28ranked-venue papers
20as first author
0since 2021 · last 2014
—ORCID · none
Domains — the database's venue-derived domains; a paper can count in several
Databases, data management, data science and information retrieval · 18 · 13 first-authorSystems, architecture and hardware · 9 · 7 first-authorArtificial intelligence and machine learning · 3 · 1 first-author
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
8 papers |
Indexing and storage engines · 57% Information retrieval · 24% Query processing and optimization · 11% | |
| Computer architecture, parallel and distributed computing, and storage systems
2 papers |
Memory systems · 70% Distributed systems · 21% Storage systems · 9% |
Topics — the 16 heaviest of 19, each with the papers that count most for it
| Topic | Weight | Papers | Last | Evidence papers |
|---|---|---|---|---|
Indexing and storage engines
bitmap index |
0.1 | 2 | 2006 | Optimizing bitmap indices with efficient compression · ACM Trans. Database Syst. 2006 On the performance of bitmap indices for high cardinality attributes · VLDB 2004 |
Memory systems › cache management
cache replacement |
0.1 | 2 | 2004 | Optimal File-Bundle Caching Algorithms for Data-Grids · SC 2004 Disk cache replacement algorithm for storage resource managers in data grids · SC 2002 |
Indexing and storage engines › bitmap index
compressed bitmap index |
0.1 | 1 | 2006 | Optimizing bitmap indices with efficient compression · ACM Trans. Database Syst. 2006 |
Information retrieval › indexing
index compression |
0.1 | 1 | 2006 | Optimizing bitmap indices with efficient compression · ACM Trans. Database Syst. 2006 |
Distributed systems › grid computing
data grid |
0.0 | 2 | 2004 | Optimal File-Bundle Caching Algorithms for Data-Grids · SC 2004 Disk cache replacement algorithm for storage resource managers in data grids · SC 2002 |
Query processing and optimization
range query |
0.0 | 2 | 2006 | Optimizing bitmap indices with efficient compression · ACM Trans. Database Syst. 2006 Balanced Multidimensional Extendible Hash Tree · PODS 1986 |
Query processing and optimization › range query
multidimensional range query |
0.0 | 1 | 2006 | Optimizing bitmap indices with efficient compression · ACM Trans. Database Syst. 2006 |
Database system architecture and tuning › database design › physical database design
index selection |
0.0 | 1 | 2004 | On the performance of bitmap indices for high cardinality attributes · VLDB 2004 |
Information retrieval › hashing › hash table design
extendible hashing |
0.0 | 3 | 1988 | Linearizing the Directory Growth in Order Preserving Extendible Hashing · ICDE 1988 Balanced Multidimensional Extendible Hash Tree · PODS 1986 A Mapping Function for the Directory of a Multidimensional Extendible Hashing · VLDB 1984 |
Storage systems › storage management
storage resource management |
0.0 | 1 | 2002 | Disk cache replacement algorithm for storage resource managers in data grids · SC 2002 |
Spatial and temporal data management
geographic information systems |
0.0 | 1 | 1992 | Georgraphic Information Systems, A Challenge for the 90's (Panel) · VLDB 1992 |
Information retrieval
hashing |
0.0 | 2 | 1988 | Linearizing the Directory Growth in Order Preserving Extendible Hashing · ICDE 1988 A Multidimensional Digital Hashing Scheme for Files With Composite Keys · SIGMOD Conference 1985 |
Indexing and storage engines › hash index
multidimensional hashing |
0.0 | 2 | 1986 | Balanced Multidimensional Extendible Hash Tree · PODS 1986 A Mapping Function for the Directory of a Multidimensional Extendible Hashing · VLDB 1984 |
Indexing and storage engines › file organization
hierarchical directory |
0.0 | 1 | 1986 | Balanced Multidimensional Extendible Hash Tree · PODS 1986 |
Indexing and storage engines
multidimensional indexing |
0.0 | 1 | 1986 | Balanced Multidimensional Extendible Hash Tree · PODS 1986 |
Indexing and storage engines › file organization
directory structure |
0.0 | 1 | 1988 | Linearizing the Directory Growth in Order Preserving Extendible Hashing · ICDE 1988 |
Methods — techniques the papers use, named apart from their topics
simulation · 0.1timing measurement · 0.1compression scheme design · 0.1complexity analysis · 0.1utility function ranking · 0.0order-preserving hashing · 0.0balanced m-way tree · 0.0multidimensional b-tree · 0.0extendible hash tree · 0.0
| Year | Publication | Venue | Position |
|---|---|---|---|
| 2014 | New approaches to storing and manipulating multi-dimensional sparse arraysabstractIn this paper, we introduce some storage schemes for multi-dimensional sparse arrays (MDSAs) that handle the sparsity of the array with two primary goals; reducing the storage overhead and maintaining efficient data element access. Four schemes are proposed. These are: i.) The PATRICIA trie compressed storage method (PTCS) which uses PATRICIA trie to store the valid non-zero array elements; ii.)The extended compressed row storage (xCRS) which extends CRS method for sparse matrix storage to sparse arrays of higher dimensions and achieves the best data element access efficiency of all the methods; iii.) The bit encoded xCRS (BxCRS) which optimizes the storage utilization of xCRS by applying data compression methods with run length encoding, while maintaining its data access efficiency; and iv.) a hybrid approach that provides a desired balance between the storage utilization and data manipulation efficiency by combining xCRS and the Bit Encoded Sparse Storage (BESS). These storage schemes were evaluated and compared on three basic array operations; constructing the storage scheme, accessing a random element and retrieving a sub-array, using a set of synthetic sparse multi-dimensional arrays. Ekow J. Otoo, Gideon Nimako |
SSDBM | 1 |
| 2013 | PEXTA: A Parallel Chunked Extendible Dense Array I/O for global array (GA)abstractOver the past decade, I/O is has been a limiting factor for extreme scale parallel computing even though there has been substantial growth in the amount of data produced by parallel scientific applications. The datasets usually grow incrementally to massive sizes of the order of terabytes and petabytes. As such, the storage of such datasets, typically modelled as multidimensional arrays, requires efficient dynamic storage schemes where the array is allowed to arbitrary extend the bounds of the dimensions. This paper introduces PEXTA, a new parallel I/O model for the Global Array Toolkit. PEXTA provides the necessary APIs for explicit transfer between the memory resident global array and its secondary storage counterpart but also allows the persistent array to be extended on any dimension without compromising on the access time of an element or sub-array elements. Such a feature currently exists in the Hierarchical Data Format version 5 (HDF5) and parallel HDF5. However, extending the bound of a dimension in the HDF5 array file can be unusually expensive in time. Extensions, in our storage scheme for parallel dense array files, can still be performed while still accessing elements of the array much faster than parallel HDF5. We illustrate the PEXTA APIs with three applications; an out-of-core matrix-matrix multiplication, lattice Boltzmann simulation and Molecular Dynamics of Lennard Jones System. Gideon Nimako, Ekow J. Otoo, Daniel Ohene-Kwofie |
CLUSTER | 2 |
| 2013 | Chunked extendible dense arrays for scientific data storage
Ekow J. Otoo, Gideon Nimako, Daniel Ohene-Kwofie |
Parallel Comput. | 1 |
| 2012 | Fast Parallel Algorithms for Blocked Dense Matrix Multiplication on Shared Memory Architectures
Gideon Nimako, Ekow J. Otoo, Daniel Ohene-Kwofie |
ICA3PP (1) | 2 |
| 2010 | Dynamic Data Reorganization for Energy Savings in Disk Storage Systems
Ekow J. Otoo, Doron Rotem, Shih-Chiang Tsao |
SSDBM | 1 |
| 2009 | Workload-adaptive management of energy-smart disk storage systemsabstractRecent studies have identified disk storage systems as one of the major consumers of power in data centers. Many disk power management (DPM) schemes were suggested where the power consumed by disks is reduced by spinning them down during long idle periods. Spinning the disks down and up results in additional energy and response time costs. For that reason, DPM schemes are effective only if the disks experience relatively long idle periods and the scheme does not introduce a severe response time penalty. In this paper we introduce a dynamic block exchange algorithm which switches data between disks based on the observed workload such that frequently accessed blocks end up residing on a few ldquohotrdquo disks thus allowing the majority of disks to experience longer idle periods. We validate the effectiveness of the algorithm with trace-driven simulations showing power savings of up to 50% with very small response time penalties. Ekow J. Otoo, Doron Rotem, Shih-Chiang Tsao |
CLUSTER | 1 |
| 2009 | Analysis of trade-off between power saving and response time in disk storage systemsabstractIt is anticipated that in the near future disk storage systems will surpass application servers and will become the primary consumer of power in the data centers. Shutting down of inactive disks is one of the more widespread solutions to save power consumption of disk systems. This solution involves spinning down or completely shutting off disks that exhibit long periods of inactivity and placing them in standby mode. A file request from a disk in standby mode will incur an I/O cost penalty as it takes time to spin up the disk before it can serve the file. In this paper, we address the problem of designing and implementing file allocation strategies on disk storage that save energy while meeting performance requirements of file retrievals. We present an algorithm for solving this problem with guaranteed bounds from the optimal solution. Our algorithm runs in O(nlogn) time where n is the number of files allocated. Detailed simulation results and experiments with real life workloads are also presented. Ekow J. Otoo, Doron Rotem, Shih-Chiang Tsao |
IPDPS | 1 |
| 2009 | Energy Smart Management of Scientific Data
Ekow J. Otoo, Doron Rotem, Shih-Chiang Tsao |
SSDBM | 1 |
| 2009 | Optimizing two-pass connected-component labeling algorithms
Kesheng Wu, Ekow J. Otoo, Kenji Suzuki 0001 |
Pattern Anal. Appl. | 2 |
| 2007 | Parallel access of out-of-core dense extendible arraysabstractDatasets used in scientific and engineering applications are often modeled as dense multi-dimensional arrays. For very large datasets, the corresponding array models are typically stored out-of-core as array files. The array elements are mapped onto linear consecutive locations that correspond to the linear ordering of the multi-dimensional indices. Two conventional mappings used are the row-major order and the column-major order of multi-dimensional arrays. Such conventional mappings of dense array files highly limit the performance of applications and the extendibility of the dataset. Firstly, an array file that is organized in say row-major order causes applications that subsequently access the data in column-major order, to have abysmal performance. Secondly, any subsequent expansion of the array file is limited to only one dimension. Expansions of such out-of-core conventional arrays along arbitrary dimensions, require storage reorganization that can be very expensive. We present a solution for storing out-of-core dense extendible arrays that resolve the two limitations. The method uses a mapping function F*(), together with information maintained in axial vectors, to compute the linear address of an extendible array element when passed its k-dimensional index. We also give the inverse function, F*-1() for deriving the k-dimensional index when given the linear address. We show how the mapping function, in combination with MPI-IO and a parallel file system, allows for the growth of the extendible array without reorganization and no significant performance degradation of applications accessing elements in any desired order. We give methods for reading and writing sub-arrays into and out of parallel applications that run on a cluster of workstations, The axial-vectors are replicated and maintained in each node that accesses sub-array elements. Ekow J. Otoo, Doron Rotem |
CLUSTER | 1 |
| 2007 | Optimal chunking of large multidimensional arrays for data warehousingabstractVery large multidimensional arrays are commonly used in data intensive scientific computations as well ason-line analytical processing applications referred to as MOLAP. The storage organization of such arrays on disks is done by partitioning the large global array into fixed size sub-arrays called chunks or tiles that form the units of data transfer between disk and memory. Typical queries involve the retrieval of sub-arrays in a manner that access all chunks that overlap the query results. An important metric of the storage efficiency is the expected number of chunks retrieved over all such queries. The question that immediately arises is "what shapes of array chunks give theminimum expected number of chunks over a query workload?" The problem of optimal chunking was first introduced by Sarawagi and Stonebraker [11] who gave an approximate solution. In this paper we develop exact mathematical models of the problem and provide exact solutions using steepest descent and geometric programming methods. Experimental results, using synthetic and real life workloads, show that our solutions are consistently within than 2.0% of the true number of chunks retrieved for any number of dimensions. In contrast, the approximate solution of [11] can deviate considerably from the true result with increasing number of dimensions and also may lead suboptimal chunk shapes. Ekow J. Otoo, Doron Rotem, Sridhar Seshadri |
DOLAP | 1 |
| 2006 | Efficient Storage Allocation of Large-Scale Extendible Multi-dimensional Scientific DatasetsabstractData analyses in scientific domains involve storage, retrieval, processing and visualization of large scale multidimensional datasets. The datasets incrementally grow by appending new data to the dataset without reorganizing the already allocated data storage. The datasets, typically modeled as k-dimensional arrays, are maintained in files where the array elements are allocated in a sequence of consecutive storage locations according to some ordering of an array mapping function. Such mapping functions limit the degree of extendibility of the arrays to one dimension only. To allowing new data elements to be appended to the dataset effectively implies allowing for the arbitrary extendibility of the array. We present a mapping function Fscr*(), that uses additional O(klogEscr) storage, where Escr is the number of array segments appended. The function is realized with approximately the approximately the same order of complexity as a conventional array function. The algorithm presented for addressing elements of datasets in extendible multi-dimensional array files apply equally well to addressing memory resident extendible arrays Ekow J. Otoo, Doron Rotem |
SSDBM | 1 |
| 2006 | Optimizing bitmap indices with efficient compressionabstractBitmap indices are efficient for answering queries on low-cardinality attributes. In this article, we present a new compression scheme called Word-Aligned Hybrid (WAH) code that makes compressed bitmap indices efficient even for high-cardinality attributes. We further prove that the new compressed bitmap index, like the best variants of the B-tree index, is optimal for one-dimensional range queries. More specifically, the time required to answer a one-dimensional range query is a linear function of the number of hits. This strongly supports the well-known observation that compressed bitmap indices are efficient for multidimensional range queries because results of one-dimensional range queries computed with bitmap indices can be easily combined to answer multidimensional range queries. Our timing measurements on range queries not only confirm the linear relationship between the query response time and the number of hits, but also demonstrate that WAH compressed indices answer queries faster than the commonly used indices including projection indices, B-tree indices, and other compressed bitmap indices. Kesheng Wu, Ekow J. Otoo, Arie Shoshani |
ACM Trans. Database Syst. | 2 |
| 2004 | Efficient Algorithms for Multi-file Caching
Ekow J. Otoo, Doron Rotem, Sridhar Seshadri |
DEXA | 1 |
| 2004 | Optimal File-Bundle Caching Algorithms for Data-GridsabstractThe file-bundle caching problem arises frequently in scientific applications where jobs process several files concurrently. Consider a host system in a data-grid that maintains a disk cache for servicing jobs of file requests where a job is serviced only if all its requested files are present in the disk cache. Files must now be admitted into the cache and replaced in sets of file-bundles. We show that traditional caching algorithms based on file popularity measures do not perform well since they may hold in cache non-relevant combinations of files. We present and analyze a new caching algorithm for maximizing the throughput of jobs and minimizing data replacement costs at such data-grid hosts. We tested the new algorithm using a disk cache simulation model under a wide range of conditions of file request distributions, varying cache size, file size distribution, etc. The results show significant improvement over traditional caching algorithms. Ekow J. Otoo, Doron Rotem, Alexandru Romosan |
SC | 1 |
| 2004 | On the performance of bitmap indices for high cardinality attributes
Kesheng Wu, Ekow J. Otoo, Arie Shoshani |
VLDB | 2 |
| 2002 | Disk cache replacement algorithm for storage resource managers in data gridsabstractWe address the problem of cache replacement policies for Storage Resource Managers (SRMs) that are used in Data Grids. An SRM has a disk storage of bounded capacity that retains some N objects. A replacement policy is applied to determine which object in the cache needs to be evicted when space is needed. We define a utility function for ranking the candidate objects for eviction and then describe an efficient algorithm for computing the replacement policy based on this function. This computation takes time O (log N). We compare our policy with traditional replacement policies such as Least Frequently Used (LFU), Least Recently Used (LRU), LRU-K, Greedy Dual Size (GDS), etc., using simulations of both synthetic and real workloads of file accesses to tertiary storage. Our simulations of replacement policies account for delays in cache space reservation, data transfer and processing. The results obtained show that our proposed method is the most cost effective cache replacement policy for Storage Resource Managers (SRM). Ekow J. Otoo, Frank Olken, Arie Shoshani |
SC | 1 |
| 2002 | Compressing Bitmap Indexes for Faster Search OperationsabstractWe study the effects of compression on bitmap indexes. The main operations on the bitmaps during query processing are bitwise logical operations. Using the general purpose compression schemes the logical operations on the compressed bitmaps are much slower than on the uncompressed bitmaps. Specialized compression schemes, like the byte-aligned bitmap code (BBC), are usually faster in performing logical operations than the general purpose schemes, but in many cases they are still orders of magnitude slower than the uncompressed scheme. To make the compressed bitmap indexes operate more efficiently, we designed a CPU-friendly scheme which we refer to as the word-aligned hybrid code (WAH). Tests on both synthetic and real application data show that the new scheme significantly outperforms well-known compression schemes at a modest increase in storage space. Compared to BBC, WAH performs logical operations about 12 times faster and uses only 60% more space. Compared to the uncompressed scheme, in most test cases WAH is faster while still using less space. We further verified with additional tests that the improvement in logical operation speed translates to similar improvement in query processing speed. Kesheng Wu, Ekow J. Otoo, Arie Shoshani |
SSDBM | 2 |
| 2001 | A Performance Comparison of bitmap indexesabstractWe present a comparison of two new word-aligned schemes with some schemes for compressing bitmap indexes, including the well-known byte-aligned bitmap code (BBC). On both synthetic data and real application data, the new word-aligned schemes use only 50% more space, but perform logical operations on compressed data 12 times faster than BBC. The new schemes achieve this performance advantage by guaranteeing that during logical operations every machine instruction performs useful work on words rather than on bytes or bits as in BBC. Kesheng Wu, Ekow J. Otoo, Arie Shoshani |
CIKM | 2 |
| 2001 | Clustering High dimensional Massive Scientific DatasetabstractMany scientific applications can benefit from an efficient clustering algorithm of massively large high dimensional datasets. However most of the developed algorithms are impractical to use when the amount of data is very large. Given N objects each defined by an M-dimensional feature vector any clustering technique for handling very large datasets in high dimensional space should run in time O(N) at best, and O(N log N) in the worst case, using no more than O(NM) storage, for it to be practical. A parallelized version of the same algorithm should achieve a linear speed-up in processing time with increasing number of processors. We introduce a hybrid algorithm called HyCeltyc, as an approach for clustering massively large high dimensional datasets. HyCeltyc, which stands for Hybrid Cell Density Clustering method combines a cell-density based algorithm with a hierarchical agglomerative method to identify clusters in linear time. The main steps of the algorithm involve sampling, dimensionality reduction and selection of significant features on which to cluster the data. Ekow J. Otoo, Arie Shoshani, Seung-won Hwang |
SSDBM | 1 |
| 2001 | Clustering High Dimensional Massive Scientific Datasets
Ekow J. Otoo, Arie Shoshani, Seung-won Hwang |
J. Intell. Inf. Syst. | 1 |
| 1992 | Georgraphic Information Systems, A Challenge for the 90's (Panel)
Ekow J. Otoo, Ron Lake, Wo-Shun Luk, T. H. Merrett, Hanan Samet |
VLDB | 1 |
| 1988 | Linearizing the Directory Growth in Order Preserving Extendible HashingabstractProposes a method of implementing an order-preserving extendible hashing scheme using a balanced hierarchical directory. The directory is implemented as a balanced m-way tree where m=2/sup theta / for some predefined constant theta . This approach gives an almost linear growth in the directory size for both uniform and nonuniform key distributions at the expense of possibly one extra disk. Given records whose pseudokeys are w-bit nonnegative integers, each of value K'> Ekow J. Otoo |
ICDE | 1 |
| 1987 | Improving Semi-Join Evaluation in Distributed Query Processing
Ekow J. Otoo, Nicola Santoro, Doron Rotem |
ICDCS | 1 |
| 1986 | Balanced Multidimensional Extendible Hash TreeabstractWe present a method for designing a multidimensional order preserving extendible hashing scheme that allows the directory to grow almost linearly with the number of insertions, irrespective of the key distribution.Such robustness in the design is achieved through the use of a hierarchical directory that grows in a manner similar to a multidimensional B-tree.For most practical directory sizes of at most 2s* entries, we guarantee no more than three diik accesses for an exact match search.Like the grid file, the directory corresponds to a rectilinearly partitioned attribute space which is represented as d-dimensional extendible &ray.Hence range and partial-range searches are efficiently executed in 0(n~), where no is the number of rectangular cells that cover the response region. Ekow J. Otoo |
PODS | 1 |
| 1985 | A Multidimensional Digital Hashing Scheme for Files With Composite KeysabstractArticle Free Access Share on A multidimensional digital hashing scheme for files with composite keys Author: Ekow J. Otoo School of Computer Science, Carleton University, Ottawa, Canada School of Computer Science, Carleton University, Ottawa, CanadaView Profile Authors Info & Claims SIGMOD '85: Proceedings of the 1985 ACM SIGMOD international conference on Management of dataMay 1985 Pages 214–229https://doi.org/10.1145/318898.318918Published:01 May 1985Publication History 9citation278DownloadsMetricsTotal Citations9Total Downloads278Last 12 Months13Last 6 weeks4 Get Citation AlertsNew Citation Alert added!This alert has been successfully added and will be sent to:You will be notified whenever a record that you have chosen has been cited.To manage your alert preferences, click on the button below.Manage my Alerts New Citation Alert!Please log in to your account Save to BinderSave to BinderCreate a New BinderNameCancelCreateExport CitationPublisher SiteeReaderPDF Ekow J. Otoo |
SIGMOD Conference | 1 |
| 1984 | A Mapping Function for the Directory of a Multidimensional Extendible Hashing
Ekow J. Otoo |
VLDB | 1 |
| 1979 | Distribution Models of Relations
T. H. Merrett, Ekow J. Otoo |
VLDB | 2 |