Ihab F Ilyas

Title: Innovations by Ihab F Ilyas

Introduction

Ihab F Ilyas is a notable inventor based in West Lafayette, IN (US). He has made significant contributions to the field of database systems, holding a total of 3 patents. His work focuses on optimizing query performance and enhancing database efficiency.

Latest Patents

One of his latest patents is titled "Estimating the compilation time of a query optimizer." This invention provides a quantified estimate of the optimizer compilation time for a given query optimizer. The compilation time estimator automates the optimizer's selection of the appropriate level of optimization in commercial database systems. It reuses an optimizer's join enumerator to obtain the actual number of joins while bypassing plan generation to save estimation overhead. Additionally, it maintains a small number of interesting physical properties to estimate the number of plans using a linear regression model. The estimator utilizes the number of generated plans to estimate query compilation time.

Another significant patent by Ihab F Ilyas is "Detecting correlation from data." This system and method discover dependencies between relational database column pairs and apply these discoveries to query optimization. For each candidate column pair, a random sample of data values is collected after pruning pairs that do not meet specified heuristic constraints. A candidate column pair is tested for the existence of a soft functional dependency (FD). If no dependency is found, it is statistically tested for correlation using a robust chi-squared statistic. Column pairs with either a soft FD or a statistical correlation are prioritized for recommendation to a query optimizer based on various factors. A dependency graph representing correlations and dependencies is also provided.

Career Highlights

Ihab F Ilyas is currently employed at International Business Machines Corporation (IBM). His work at IBM has allowed him to focus on innovative solutions that enhance database performance and efficiency.

Collaborations

Ihab has collaborated with notable colleagues, including Dengfeng Gao and Guy Maring Lohman. Their combined expertise contributes to the advancement of database technologies.

Conclusion

Ihab F Ilyas is a distinguished inventor whose work in database optimization has led to valuable patents that improve query performance. His contributions continue to influence the field of database systems significantly.