Demonstration venue · read-only. Every page can be browsed; the buttons that would change it are switched off. Create an account to run TaxoReview on your own data. A simulation from public publication records: the people listed were not invited and did not agree to review.
? Tutorial for this page

Ekow J. Otoo

dblp:10/3587 · DBLP profile ↗
← Back
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

TopicWeightPapersLastEvidence papers
Indexing and storage engines
bitmap index
0.122006
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.122004
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.112006
Optimizing bitmap indices with efficient compression · ACM Trans. Database Syst. 2006
Information retrieval › indexing
index compression
0.112006
Optimizing bitmap indices with efficient compression · ACM Trans. Database Syst. 2006
Distributed systems › grid computing
data grid
0.022004
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.022006
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.012006
Optimizing bitmap indices with efficient compression · ACM Trans. Database Syst. 2006
Database system architecture and tuning › database design › physical database design
index selection
0.012004
On the performance of bitmap indices for high cardinality attributes · VLDB 2004
Information retrieval › hashing › hash table design
extendible hashing
0.031988
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.012002
Disk cache replacement algorithm for storage resource managers in data grids · SC 2002
Spatial and temporal data management
geographic information systems
0.011992
Georgraphic Information Systems, A Challenge for the 90's (Panel) · VLDB 1992
Information retrieval
hashing
0.021988
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.021986
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.011986
Balanced Multidimensional Extendible Hash Tree · PODS 1986
Indexing and storage engines
multidimensional indexing
0.011986
Balanced Multidimensional Extendible Hash Tree · PODS 1986
Indexing and storage engines › file organization
directory structure
0.011988
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
YearPublicationVenuePosition
2014 New approaches to storing and manipulating multi-dimensional sparse arrays
abstract
In 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
SSDBM1
2013 PEXTA: A Parallel Chunked Extendible Dense Array I/O for global array (GA)
abstract
Over 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
CLUSTER2
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
SSDBM1
2009 Workload-adaptive management of energy-smart disk storage systems
abstract
Recent 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
CLUSTER1
2009 Analysis of trade-off between power saving and response time in disk storage systems
abstract
It 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
IPDPS1
2009 Energy Smart Management of Scientific Data
Ekow J. Otoo, Doron Rotem, Shih-Chiang Tsao
SSDBM1
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 arrays
abstract
Datasets 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
CLUSTER1
2007 Optimal chunking of large multidimensional arrays for data warehousing
abstract
Very 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
DOLAP1
2006 Efficient Storage Allocation of Large-Scale Extendible Multi-dimensional Scientific Datasets
abstract
Data 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
SSDBM1
2006 Optimizing bitmap indices with efficient compression
abstract
Bitmap 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
DEXA1
2004 Optimal File-Bundle Caching Algorithms for Data-Grids
abstract
The 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
SC1
2004 On the performance of bitmap indices for high cardinality attributes
Kesheng Wu, Ekow J. Otoo, Arie Shoshani
VLDB2
2002 Disk cache replacement algorithm for storage resource managers in data grids
abstract
We 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
SC1
2002 Compressing Bitmap Indexes for Faster Search Operations
abstract
We 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
SSDBM2
2001 A Performance Comparison of bitmap indexes
abstract
We 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
CIKM2
2001 Clustering High dimensional Massive Scientific Dataset
abstract
Many 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
SSDBM1
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
VLDB1
1988 Linearizing the Directory Growth in Order Preserving Extendible Hashing
abstract
Proposes 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
ICDE1
1987 Improving Semi-Join Evaluation in Distributed Query Processing
Ekow J. Otoo, Nicola Santoro, Doron Rotem
ICDCS1
1986 Balanced Multidimensional Extendible Hash Tree
abstract
We 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
PODS1
1985 A Multidimensional Digital Hashing Scheme for Files With Composite Keys
abstract
Article 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 Conference1
1984 A Mapping Function for the Directory of a Multidimensional Extendible Hashing
Ekow J. Otoo
VLDB1
1979 Distribution Models of Relations
T. H. Merrett, Ekow J. Otoo
VLDB2