Kevin WilliamsAvalon Consulting Solutions Inc
Kevin Williams
MBA (Finance), PhD (Information Systems)
About
5
Publications
13,812
Reads
How we measure 'reads'
A 'read' is counted each time someone views a publication summary (such as the title, abstract, and list of authors), clicks on a figure, or views or downloads the full-text. Learn more
222
Citations
Citations since 2017
Introduction
Recently named an Amazon Web Services (AWS) Faculty Cloud Ambassador for 2020 - one of 450 worldwide.
Design Science dissertation research on a method and application to substantially improve the insertion or deletion of data from active transactional processing relational databases. The application has improved performance, decreased contention, and requires zero downtime. Commercial software licensed under the name Somersetâ„¢ and is currently available for Oracleâ„¢ Enterprise databases.
Additional affiliations
November 2005 - September 2020
Avalon Consulting Solutions, Inc
Position
- Consultant
August 2004 - March 2016
Education
August 2004 - March 2016
September 1984 - May 1986
Publications
Publications (5)
Organizations can benefit greatly from database archiving strategies to control data growth, improve system performance, and reduce storage costs. Structured data archiving (SDA) requires removing data from transactional processing databases (TPDs) safely and accurately. However, existing approaches for data deletion either require planned database...
Organizations are wasting money and sacrificing efficiency by buying additional hardware to store their data when what they should be doing is removing unneeded data. However, a problem is that deletion is not often used to reduce data growth in busy transactional processing relational databases (TPRDs) because it greatly increases locking and syst...
Rapid Elasticity is often described as an essential characteristic of cloud computing, but there are some good reasons to rethink how it is described and implemented – especially as it relates to transaction processing relational databases, which are broadly used in many organizations. These types of relational databases, which support transaction...
There has been a gigantic shift from a product-based economy to one based on services, specifically digital services. From
every indication it is likely to be more than a passing fad and the changes these emerging digital services represent will
continue to transform commerce and have yet to reach market saturation. Digital services are being desig...
There has been a gigantic shift from a product based economy to one based on services, specifically digital services. From every indication it is likely to be more than a passing fad and the changes these emerging digital services represent will continue to transform commerce and have yet to reach market saturation. Digital services are being desig...
Questions
Question (1)
One of the barriers to rebuilding tables in Oracle's relational database is that on a table with multiple indexes, the system has to rebuild each index with a separate full table scan. It seems that a "full table scan" should have all of the columns (for all of the indexes) in one pass, but I haven't found any way to do this. Some database systems lock operations during the building of indexes, so this problem becomes even more significant.
Thank you in advance.
Projects
Project (1)
The number of professional credentials has grown spectacularly in recent years and continues to grow year after year. This research seeks to understand the science behind credentialization and its relationship with value - both real and perceived.
