1 / 13

MyNet project: exercise 3

MyNet project: exercise 3. Genoveva Vargas Solar, Christine Collet Technical support: Javier Espinosa, Epal Njamen Orléant , Juan Carlos Castrejón. http://vargas-solar.imag.fr/academika/cloud-data-management/. Objective. Others. MyNet DB. Have a first experience on

kitty
Download Presentation

MyNet project: exercise 3

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. MyNet project: exercise 3 Genoveva Vargas Solar, Christine Collet Technical support: Javier Espinosa, EpalNjamenOrléant, Juan Carlos Castrejón http://vargas-solar.imag.fr/academika/cloud-data-management/

  2. Objective Others MyNetDB Have a first experience on • sharding a relational DBMS • dealing with shards synchronization • deploying the service on the cloud and implement an interface English Français MyNet Service Español

  3. Development environment • Windows Azure http://windows.azure.com • Visual Studio 2012 Professional Edition • Windows Azure SDK http://www.windowsazure.com/en-us/develop/downloads/ • Microsoft Web Platform Installerhttp://www.microsoft.com/web/downloads/platform.aspx

  4. Creating and populating the initial MyNet DB Key concepts: UML  relational transformation rules, Azure federation tool, data provider service

  5. Defining the MyNet relational schema

  6. Transformation rules UML – relational(1) • Create a relation schema for each class with the attributes and using the identifier as primary key • Examine (1,1) associations, for each one proceed as follows: • Let R be an association between classes A  B integrate in the relation schema representing A the key of B. • The transformation of R is terminated

  7. A(1,1) --- B • POST (postID: Integer, timeStamp: Date, geoStamp: String, contentID: Integer) • CONTENT(contentID: Integer, text: String)

  8. Transformation rules UML – relational(2) • Examine associations with cardinality (0,1). For each one proceed as follows: • Let R be an association between classes A(0,1)--- B with cardinality (0,1) in A • Add as foreign key the key of A in B • The transformation of R is terminated

  9. A(0,1)--- B • CONTACT ( contactID: Integer, lastName: String, givenName: String, society : String) • BASICINFO ( socialNetworkID: URI, webSite: URI, contactID: Integer) • POST (postID: Integer, timeStamp: Date, geoStamp: String, contactID: Integer, contentID: Integer)

  10. A(0,1)--- B • BASICINFO ( socialNetworkID: URI, webSite: URI) • ADDRESS (street: String, number: Integer, city: String, ZipCode: String,socialNetworkID: URI) • EMAIL ( email: String, type: String, socialNetworkID: URI) • LANGUAGE (languageID: Integer, Language: String, socialNetworkID: URI)

  11. Transformation rules UML – relational(3) • Examine associations with cardinality (x,n). For each one proceed as follows: • Let R be an association between classes A(x,n)--- B. Create a table with: • R attributes • The key of A and B • The transformation of R is terminated

  12. Creation • Create your database on Azure as explained in previous exercises • Define your DDL script define your relational database schema • Follow the Technical memento for populating your new MyNet database

  13. Hands on the federation Follow the Technical Memento

More Related