Meta Data Management

P.A. Bernstein, S. Melnik: Meta Data Management, ICDE'04 Boston

OO wrapper for SQL (cont’d)

SQL Defns

lThe wrapper generator does the following:

ØImports each table definition into a model

ØGenerates a model for the class wrapper

ØGenerates a mapping from table to class

ØGenerates code from the class model and mapping.

SQL model

PurchaseOrder

OrdID

OrderDate

static void Main()

Console.WriteLine("Importing Schemas");

// transform both to trees

TransformXSDToTree transformXSDToTree = new TransformXSDToTree();

Graph tree1 = transformXSDToTree.Execute(graph1);

Graph tree2 = transformXSDToTree.Execute(graph2);

// linguistic similarity matrix

SimMatrix linguisticMatrix = new SimMatrix(

tree1, tree2,

}

Code

Class model

PurchaseOrder

OrdID

OrderDate