Experiences with EDO: An Evolutionary Database Optimizer

Authors: Patrick van Bommel

Tags: 1994, conceptual modeling

In this paper we introduce the database design tool EDO: an Evolutionary Database Optimizer. The term ‘evolutionary’ refers to a basic feature of the tool. After generating an initial pool of preliminary internal representations for a given conceptual data model, EDO allows a database designer to activate evolution strategies, modifying the preliminary internal representations into more desirable ones. The quality of the internal representations found as yet is used to perform a guided walk through the solution space of alternative internal representations for the conceptual model under consideration. This quality (called fitness) takes into account the expected storage space and the expected average response time of a candidate internal representation.

Read the full paper here: https://pdf.sciencedirectassets.com/271546/1-s2.0-S0169023X00X01139/1-s2.0-0169023X94000174/main.pdf?X-Amz-Security-Token=IQoJb3JpZ2luX2VjEBgaCXVzLWVhc3QtMSJHMEUCIElQ4yAUDvdzZnPYPoQtG9%2Fij5NpaJE9ziiLKwrd%2B0DJAiEAqnHywY84fymcU3LwHZdzDChEQqYbRSTd%2B4UqrxrFXK0qtAMIMRADGgwwNTkwMDM1NDY4NjUiDI93W%2FrP%2B9NfCtcd8yqRA3MRbntkdaDath2Sd3tjjXkkLORvalalp1hF7%2B7%2Fn7bUMK9RK%2BNPF9a2wWhc%2B8m2gDvtTcFg1JJFkFLGxLQjjraXzqFgXZ5vn7mihQmH0nw5tuGex2WJMP0K3z3Fb%2B8xqBvALnJ7LDOdVYTdQ%2FYb44yLDUospr4cTxf6AZ%2FH%2BgAea7JGzbuJBahfhmbfjf6j0ZPoZ83sx4k7%2FvYAZ8%2B0TzPa%2FpSh%2BzEiYviorH9j8FbxfU9yo0Vk7We6h9fQrDuKvqh52Q4ixdZ9lAO30L7R8dxrjwozzIWywJXWX%2BGjWGj6oZNfFld%2BAGEIyu85j857f2LC6VQSR4PM%2BvY6ILvHotGsGUNqfZxgaerN6KGwqm%2BnTY2tqk8LO0HapF1fl2ZLJ22HMKL6dYEnC5VrJUAE7t61p%2Bt6hEGCqLm1czacNGjaE3t6q8Zme%2BaOp1AHhxmGDWk7yyJvq4jxY1TgHM%2FF%2Fi7yX8jsUCdGjEpRr8Vszv5aa51pGecPRmT0pzw2qQGNtLG%2Br5Puwim%2B5qcCOZWPBF0mMJCrk%2FsFOusBrln%2FqgMLQzficHh2qjRqekTPp1Sv26GP70EIrdvjGkBwP7lIhq3FC6ANJV0QudGbBAsLsyd1nkXFgMgNU5d6fn9ChvhH2kr7p9tgMG0%2Fy%2F5WnErOuMULbxoAYsjGU9ymuZOjvB9B0kFR5bd8Arj13dAvHrTx3dhnVQ6jKucbbqBwwigamvVHl69ezhIKMeSTTigWDjlIiDvDkkN8oAyEPHJ%2FBjXAQ86AJJEuRzfw1U9C74wzIx%2FAfJYh6KMIMfbWfldtH6XDMOm3Q5QQv6J%2Fp2wcUVwYh9i2cvvR%2Bol61IDghPJCbrXWL8h10A%3D%3D&X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Date=20200918T162244Z&X-Amz-SignedHeaders=host&X-Amz-Expires=300&X-Amz-Credential=ASIAQ3PHCVTYSO4LHY76%2F20200918%2Fus-east-1%2Fs3%2Faws4_request&X-Amz-Signature=766fec199e6e621b041a96a78de930d7f302604861e9f1e60ae70fe9df93794f&hash=a4b85ccb03ee24247b18465aa505ced13f61435277608b9e0d74bd8a40e7a6d2&host=68042c943591013ac2b2430a89b270f6af2c76d8dfd086a07176afe7c76c2c61&pii=0169023X94000174&tid=spdf-cbb7e4f6-dbe1-41bc-b36f-92590236717e&sid=ce3e6b217906524963386c21db5fa5ebfaccgxrqa&type=client