Abstract
Data mining and very large databases offer a great deal of promise for business and government alike. Unfortunately, due to the ever changing data needs of the modern organization, as evidenced by the growing number of petabyte data applications, the task to efficiently extract data in a timely manner becomes more difficult. The research described herein presents some encouraging findings in regard to using indexing to improve upon the ETL process. Specifically, a decrease of about 3 times in run time was observed when moving from a flat table to an indexed table function logic. The business value of this decrease may be realized in terms of less wait time when end-user queries are executed.
Talk to us
Join us for a 30 min session where you can share your feedback and ask us any queries you have
Disclaimer: All third-party content on this website/platform is and will remain the property of their respective owners and is provided on "as is" basis without any warranties, express or implied. Use of third-party content does not indicate any affiliation, sponsorship with or endorsement by them. Any references to third-party content is to identify the corresponding services and shall be considered fair use under The CopyrightLaw.