A Review on Specific Data Structures Using Data Preprocessing and Refinement of Existing Algorithms in Order to Improve Time Complexities
Keywords:
Data preprocessing, Data Structures, external sorting, Optimal Binary Search Trees, Pattern Matching, Time ComplexitiesAbstract
The data preprocessing is helpful in removing noise, inconsistency in the given data and produce quality data. The output of the data preprocessing is then given to refinement of existing algorithm that can later applied over the data structures called external sorting, optimal binary search trees, and pattern matching algorithms. In external sorting(first case), user data entered can be qualified using Data preprocessing, then separate algorithms used to different data items such as numeric and alphabets. In Optimal binary search trees (second case), user entered data can be made quality data using data preprocessing (second case), then refined algorithm used over the data elements that produce OBSTs separately for numeric items, and String items. In pattern matching (third case), user entered data can be made quality data, then refined algorithm used over the text which immediately finds out index for the pattern along with history of indices for the substring which further helpful in manual identification of the given pattern in the large given text. The results and graphs were also demonstrated based on certain examples. This also differentiates between time complexities obtained of the existing and proposed algorithm used over the data structures such as external sorting, OBST, and pattern matching.
References
Partitioning in Oracle Database, http://www.oracle.com/technetwork/database/enterprise-edition/partitioning-11g-whitepaper-159443.pdf, Jul 4, 2014
Create Tablespace, https://docs.oracle.com/database/121/SQLRF/statements_7003.htm#SQLRF01403 Aug 23, 2014
Managing Tablespace and Datafiles, http://www.oracle-dba-online.com/tablespaces_and_datafiles.htm Aug 30, 2014
Managing Resumable Space Allocation, http://docs.oracle.com/cd/B28359_01/server.111/b28310/schema002.htm#ADMIN11581 Sep 15, 2014
Resumable Space Allocation, http://gavinsoorma.com/2009/06/resumable-space-allocation/ Oct 1,2014
SQL Loader Concepts, https://docs.oracle.com/cd/B19306_01/server.102/b14215/ldr_concepts.htm Oct 27, 2014
The Query Optimizer, http://docs.oracle.com/cd/B28359_01/server.111/b28274/optimops.htm Dec 20, 2014
Performance Tuning Overview, http://docs.oracle.com/cd/E11882_01/server.112/e41573/perf_overview.htm#PFGRF025 Jan 24, 2015
Database Performance Tuning, Guidehttps://docs.oracle.com/database/121/TGDBA/toc.htm Feb 25, 2015
How to tune your Oracle database's performance, http://www.theregister.co.uk/2014/05/06/oracle_database_performance_workshop/ Mar 2, 2015
Explain Plan Usage, https://oracle-base.com/articles/8i/explain-plan-usage Jul 15, 2015
Downloads
Published
How to Cite
Issue
Section
License

This work is licensed under a Creative Commons Attribution 4.0 International License.
Authors contributing to this journal agree to publish their articles under the Creative Commons Attribution 4.0 International License, allowing third parties to share their work (copy, distribute, transmit) and to adapt it, under the condition that the authors are given credit and that in the event of reuse or distribution, the terms of this license are made clear.
