A Modular User-Oriented Decision Support for Physical Database Design

0
104

Authors: Claudio Sartori, Dario Maio, Maria Rita Scalas

Tags: 1987, conceptual modeling

A decision support package for the design of indexes in a relational database environment is presented. It originates from the theoretical results collected inside the DATAID methodology. Its main features are a high level language user interface, an incremental description of the design environment, a forecasting of the execution I/O costs if the proposed solution is adopted and also a guidance for the access paths to be selected in the various operations.

Read the full paper here: https://pdf.sciencedirectassets.com/271653/1-s2.0-S0167923600X01340/1-s2.0-0167923687900741/main.pdf?X-Amz-Security-Token=IQoJb3JpZ2luX2VjEIP%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCXVzLWVhc3QtMSJHMEUCIGmlxfP6%2B%2BbruzTl9%2FHv%2BvJkvC%2FWcXtRbLwdlLbDlbKaAiEArVjix2TdS8P5WvnCLMTo5IIG1nZEf9GJSEVitW3zlsgqtAMIfBADGgwwNTkwMDM1NDY4NjUiDIMKpOVBg2hMh6LbJSqRA06%2FClGaJHsAJfkQSzq%2FOJNajeBIKBnRTEdcRIOKeydUxg0FOSFb9%2BXyBuyeYlItaJ%2F0lY0kwprWvn8QVecYi3pXlfQhj8a1TmcfSHmgX0Q%2F%2B8fulv%2BfEMIU%2BYVcKYSVfhvWxuxiFsk%2Fn4MYyqWkj2w9lJobrAzOG2e2H1P545UPaq49bvsKqVYHdt3hT8rYC7oqcYsWoPBXaQRNDw%2BjYHTlBNYQBd164FPH%2Bv6gLjRFhKU8uO%2Fc2OP%2BlFw1qvrBJ7j7s%2Bu%2FslFOV4SNqXzXeNCBuRi%2Bj%2FJ1DTen%2BCPUFuGG2yFvG3R9n%2F3WzXTpr4hNjM1VyNjQEk9Dl2zYifP3t1oktxeaEYv2Fx2VW99SpnTwcqldSDXe8bizZU6iNiPS9pEDWxXvHGN00Q4z3rNyOkpw%2FSSoneMq1rXbeUrcucnYJv09gQPKgLHxlKAycsPA1bi2C5vVhZAQ9%2FG85bT3SbvDKIyrXVz4%2FxXo3SAfA1EEAMSEUt7ykZoN1OFJXdjuBMyoOH6bodxwfBvlh9SesSQpMJyzuvoFOusBYtkFS76fwJx%2By%2FOQfBMDPpeX7%2F3COquCZuPemsma6daoOfJA0z9kSnexoPe0sc%2BUQhVPjt400B03ZX2geKOVcpwtJr%2BDwlIh0VcdChHp6jvtXGyRSz%2FSC9BipWZ1OQMs%2F09W%2BjVUKcE0MeLSdf95tDPMHzPpXmt3pQgQs4L7hj0CRbpXSwcO43qnl7XBNo7W3brR%2BYUqtTsYqwaxwGX5SpgUdgFAvVJuGgrcvk6V9u1qSMJFu5cLM9ie0581lpOkIHtHoSV9lzPwGtyRuZ4gx4NF%2FSpvJ3d2Xf6wTL%2FqijvDE%2FheEHtYYo6FPg%3D%3D&X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Date=20200901T190538Z&X-Amz-SignedHeaders=host&X-Amz-Expires=300&X-Amz-Credential=ASIAQ3PHCVTYX2FS5HMA%2F20200901%2Fus-east-1%2Fs3%2Faws4_request&X-Amz-Signature=8c94b1735c90259869fe98dfc1de74d37a31690484ca84253237ad5198b63694&hash=0b95e8d62fff2bdbe5a198a1a38a9acf1131bd87e2ef82e1d7a0d0940805e684&host=68042c943591013ac2b2430a89b270f6af2c76d8dfd086a07176afe7c76c2c61&pii=0167923687900741&tid=spdf-a0ae7d65-a6c9-41ed-b326-b22daef7d2c7&sid=5197408c7fd491488449d4c875e97cc5949bgxrqa&type=client