A Novel Approach For Transaction in Heterogeneous Distributed Database

Dheeraj Bhimrao Lokhande

ISBN 10: 6207449940 / ISBN 13: 9786207449941

Edité par LAP LAMBERT Academic Publishing Dez 2023, 2023

A propos de cet article

Neuware -The process of index creation demands highly experienced person who should have detailed knowledge of physical database designing. TIER provides help to these persons to take decision regarding index implementation. Hence, TIER should be able to recommend index for any type of inputted query. Presently, TIER takes simple queries with one level of nesting and simple join queries as input. However, user can input ¿n¿ number of queries. To strengthen TIER, it could be expanded in terms of variety of inputted queries, more types of index suggestions, runtime enabling or disabling indexes, automated interface to connect all RDBMS which participate in distributed database, etc. TIER could be enhanced to make it recommend function-based indexes. The inputted workload in TIER contains only SELECT statements. No data manipulation commands are considered in the workload. To find out CPU and IO overhead, the DML statements can also be given as inputs in TIER. The distributed tables from remote databases are accessed through Oracle Gateway service in Oracle, The heuristic which could make user access data in reverse fashion could also be developed.Books on Demand GmbH, Überseering 33, 22297 Hamburg 188 pp. Englisch.

N° de réf. du vendeur 9786207449941

Détails bibliographiques

• Titre: A Novel Approach For Transaction in Heterogeneous Distributed Database
• Éditeur: LAP LAMBERT Academic Publishing Dez 2023
• Date de parution: 2023
• Langue: anglais
• ISBN à 10 chiffres: 6207449940
• ISBN à 13 chiffres: 9786207449941
• Reliure: Taschenbuch
• État de l'article: Neu

A propos de ce titre

Synopsis

The process of index creation demands highly experienced person who should have detailed knowledge of physical database designing. TIER provides help to these persons to take decision regarding index implementation. Hence, TIER should be able to recommend index for any type of inputted query. Presently, TIER takes simple queries with one level of nesting and simple join queries as input. However, user can input “n” number of queries. To strengthen TIER, it could be expanded in terms of variety of inputted queries, more types of index suggestions, runtime enabling or disabling indexes, automated interface to connect all RDBMS which participate in distributed database, etc. TIER could be enhanced to make it recommend function-based indexes. The inputted workload in TIER contains only SELECT statements. No data manipulation commands are considered in the workload. To find out CPU and IO overhead, the DML statements can also be given as inputs in TIER. The distributed tables from remote databases are accessed through Oracle Gateway service in Oracle, The heuristic which could make user access data in reverse fashion could also be developed.