C. Après-avoir-identifié-l-'ontologie-de-domaine, C. Lu-bm-g-où, and . Lu, En se référant aux besoins du cahier de charges, nous remarquons que l'ontologie de domaine ne remplit pas toutes les exigences du concepteur (LO ? O) Dans un premier temps, nous définissons un fragment initial (F i ) de l'ontologie par importation d'un ensemble de classes couvrant une partie des exigences de l'utilisateur et une partie ou la totalité des propriétés définies dans les classes importées. Dans un deuxième temps, les besoins non couverts sont traités par l'ajout de nouveaux concepts. Dans le but de répondre aux exigences du cahier de charges, F i est ainsi enrichi par les classes, les propriétés et les dépendances manquantes. Par exemple, le concepts décrivant les étudiants inscrits en master (MasterS tudent) n'est pas défini à travers l'ontologie globale, Par conséquent, cette classe est ajoutée au niveau de l'ontologie locale par la requêtes OntoQL suivante : CREATE #Class MasterStudent (DESCRIPTOR (#name[en] = 'MasterStudent') PROPERTIES(NSS INT

. Dans-cette-section, nous présentons les efforts de développement réalisés pour la mise en oeuvre de notre prototype de validation. Dans un premier temps, nous traitons la mise en oeuvre de l'outil d'aide à la conception OBDBDesignTool. Dans un deuxième temps, nous étudions l

. Modèle-logique-de-données, Dans ce paragraphe, nous traitons le modèle logique de données en troisième forme normale. Les classes de ce diagramme, illustré dans la figure 7

. Agrawal, Storage and querying of e-commerce data, Ce modèle permet d'organiser les classes et les propriétés des ontologies globale et Bibliographie VLDB, pp.149-158, 2001.

W. W. Armstrong, Dependency structures of data base relationships, IFIP Congress, pp.580-583, 1974.

. Bancilhon, Building an Object-Oriented Database System, The Story of O2, 1992.

. Belaid, A semantic handling of geological modeling workflows, Proceedings of the International Conference on Management of Emergent Digital EcoSystems, MEDES '09, pp.83-90, 2009.
DOI : 10.1145/1643823.1643840

. Bellatreche, A design methodology of ontology based database applications, Logic Journal of the IGPL, 2010.
DOI : 10.1093/jigpal/jzq017

. Bellatreche, An automated information integration technique using an ontoly-based database approach, ISPE CE, pp.217-223, 2003.

S. E. Bijan, Pellet: An owl dl reasoner, International Workshop on Description Logics (DL2004), pp.6-8, 2004.

W. Borgida, A. Borgida, and G. E. Weddell, Adding uniqueness constraints to description logics (preliminary report), Deductive and Object-Oriented Databases, 5th International Conference (DOOD'97, pp.85-102, 1997.

K. Broekstra, J. Broekstra, and A. Kampman, Serql: An rdf query and transformation language, 2004.
DOI : 10.1007/3-540-28347-1_2

. Broekstra, Sesame: A generic architecture for storing and querying rdf and rdf schema, International Semantic Web Conference, pp.54-68, 2002.

. Calbimonte, Functional dependencies in owl abox, Brazilian Symposium on Databases (SBBD), pp.16-30, 2009.

. Calì, On the Expressive Power of Data Integration Systems, 21st International Conference on Conceptual Modeling (ER), pp.338-350, 2002.
DOI : 10.1007/3-540-45816-6_33

. Calvanese, Path-based identification constraints in description logics, pp.231-241, 2008.

. Calvanese, Identification constraints and functional dependencies in description logics, Proceedings of the Seventeenth International Joint Conference on Artificial Intelligence (IJCAI'2001), pp.155-160, 2001.

P. P. Chen, The enity-relationship model: Toward a unified view of data, VLDB, p.173, 1975.

E. F. Codd, A relational model of data for large shared data banks, pp.377-387, 1970.

. Das, Supporting Ontology-based Semantic Matching in RDBMS, VLDB, pp.1054-1065, 2004.
DOI : 10.1016/B978-012088469-8.50092-9

. Dehainsala, OntoDB: An Ontology-Based Database for Data Intensive Applications, DASFAA, pp.497-508, 2007.
DOI : 10.1007/978-3-540-71703-4_43

R. Del-mar and . García, A design methodology for semantic web database-based systems, Third International Conference on Information Technology and Applications (ICITA), pp.233-237, 2005.

. Fankam, Sisro, conception de bases de données à partir d'ontologies de domaine, Technique et Science Informatiques, p.28, 2009.

. Fensel, OIL: an ontology infrastructure for the Semantic Web, IEEE Intelligent Systems, vol.16, issue.2, pp.38-45, 2001.
DOI : 10.1109/5254.920598

T. R. Gruber, A translation approach to portable ontology specifications, Knowledge Acquisition, vol.5, issue.2, pp.199-220, 1993.
DOI : 10.1006/knac.1993.1008

T. R. Gruber, A translation approach to portable ontology specifications Towards principles for the design of ontologies used for knowledge sharing, Chapter, 1993.

. Guo, LUBM: A benchmark for OWL knowledge base systems, Web Semantics: Science, Services and Agents on the World Wide Web, vol.3, issue.2-3, pp.158-182, 2005.
DOI : 10.1016/j.websem.2005.06.005

S. Harris and N. Gibbins, 3store: Efficient bulk rdf storage, PSSS, 2003.

D. Hondjack, Explicitation de la sémantique dans les bases de données: Le modèle ontodb de bases de données à base ontologique, 2007.

I. Horrocks and P. F. Patel-schneider, Reducing owl entailment to description logic satisfability, Description Logics, 2003.
DOI : 10.1007/978-3-540-39718-2_2

URL : http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.296.7748

. Horrocks, From SHIQ and RDF to OWL: the making of a Web Ontology Language, Web Semantics: Science, Services and Agents on the World Wide Web, vol.1, issue.1, pp.7-26, 2003.
DOI : 10.1016/j.websem.2003.07.001

. Karvounarakis, RQL, Proceedings of the eleventh international conference on World Wide Web , WWW '02, pp.592-603, 2002.
DOI : 10.1145/511446.511524

URL : https://hal.archives-ouvertes.fr/hal-01124850

. Mbaiossoum, Towards Performance Evaluation of Semantic Databases Management Systems, proceeding of the 29th British National Conference on Databases (BNCOD), 2013.
DOI : 10.1007/978-3-642-39467-6_12

. Motik, Bridging the gap between OWL and relational databases, Web Semantics: Science, Services and Agents on the World Wide Web, vol.7, issue.2, pp.74-89, 2009.
DOI : 10.1016/j.websem.2009.02.001

Z. Pan and J. Heflin, Dldb: Extending relational databases to support semantic web queries, The First International Workshop on Practical and Scalable Semantic Systems, 2003.

. Pan, DLDB2: A Scalable Multi-perspective Semantic Web Repository, 2008 IEEE/WIC/ACM International Conference on Web Intelligence and Intelligent Agent Technology, pp.489-495, 2008.
DOI : 10.1109/WIIAT.2008.290

. Park, An Efficient and Scalable Management of Ontology, Proceedings of the 12th International Conference on Database Systems for Advanced Applications (DASFAA'07), volume 4443 of Lecture Notes in Computer Science, 2007.
DOI : 10.1007/978-3-540-71703-4_88

. Petrini, . Risch, J. Petrini, and T. Risch, SWARD: Semantic Web Abridged Relational Databases, 18th International Conference on Database and Expert Systems Applications (DEXA 2007), pp.455-459, 2007.
DOI : 10.1109/DEXA.2007.125

URL : http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.63.2334

G. Pierra, Représentation et échange de données techniques, In Mec. Ind, vol.1, pp.397-414, 2000.
DOI : 10.1016/s1296-2139(00)01044-7

G. Pierra, Context-explication in conceptual ontologies: the plib approach, Proceedings of the 10th ISPE International Conference on Concurrent Engineering (ISPE CE 2003), pp.243-253, 2003.

G. Pierra, Context Representation in Domain Ontologies and Its Use for Semantic Integration of Data, Journal on Data Semantics, vol.10, pp.174-211, 2008.
DOI : 10.1007/978-3-540-77688-8_6

. Pierra, Bases de donn??es ?? base ontologique. Principe et mise en oeuvre, Ing??nierie des syst??mes d'information, vol.10, issue.2, pp.91-115, 2005.
DOI : 10.3166/isi.10.2.91-115

. Prud-'hommeaux, . Seaborne, E. Prud-'hommeaux, and A. Seaborne, Sparql query language for rdf

A. Rochfeld, Merise, an information system design and development methodology, tutorial, ER, pp.489-528, 1986.
DOI : 10.1016/0378-7206(83)90032-0

. Romero, Discovering functional dependencies for multidimensional design, Proceeding of the ACM twelfth international workshop on Data warehousing and OLAP, DOLAP '09, pp.1-8, 2009.
DOI : 10.1145/1651291.1651293

. Spyns, Data modelling versus ontology engineering, ACM SIGMOD Record, vol.31, issue.4, pp.12-17, 2002.
DOI : 10.1145/637411.637413

URL : http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.544.4986

S. Stocker, M. Stocker, and M. Smith, Owlgres: A scalable owl reasoner, The Sixth International Workshop on OWL: Experiences and Directions, 2008.

M. Stonebraker, M. Stonebraker, and D. Moore, Object-Relational DBMSs: The Next Great Wave, 1996.

. Sure, OntoEdit: Guiding Ontology Development by Methodology and Inferencing, Confederated International Conferences DOA, CoopIS and ODBASE, pp.1205-1222, 2002.
DOI : 10.1007/3-540-36124-3_76

. Tapucu, Définition et exploitation des préférences au niveau sémantique, Journées Francophones sur les Ontologies, pp.29-36, 2009.

. Tian, The design and performance evaluation of alternative XML storage strategies, ACM SIGMOD Record, vol.31, issue.1, pp.315-325, 2002.
DOI : 10.1145/507338.507341

. Wilkinson, Efficient rdf storage and retrieval in jena2, SWDB, pp.131-150, 2003.

. Wu, Implementing an inference engine for rdfs/owl constructs and userdefined rules in oracle, Proceedings of the 24th International Conference on Data Engineering, pp.1239-1248, 2008.

C. Chakroun, L. Bellatreche, Y. Aït-ameur, N. Berkani, and S. Jean, Be careful when designing semantic databases: Data and concepts redundancy, IEEE 7th International Conference on Research Challenges in Information Science (RCIS), 2013.
DOI : 10.1109/RCIS.2013.6577692

C. Chakroun and L. Bellatreche, Yamine Aït-Ameur, It is time to propose a complete methodology for designing semantic databases, proceedings of the 9th International Conference on Web Information Systems and Technologies (WEBIST), 2013.

Y. Bazhar, C. Chakroun, Y. Aït-ameur, L. Bellatreche, and S. Jean, Extending Ontology-Based Databases with Behavioral Semantics, proceedings of the 11th international conference on Ontologies, DataBases, and Applications of Semantics (ODBASE), pp.879-896, 2012.
DOI : 10.1007/978-3-642-33615-7_31

A. Bakhtouchi, C. Chakroun, and L. Bellatreche, Yamine Aït-Ameur, Mediated Data Integration Systems using Functional Dependencies Embedded in Ontologies , Recent Trends in Information Reuse and Integration, pp.227-256, 2012.

C. Chakroun, L. Bellatreche, and Y. Aït-ameur, The Role of Class Dependencies in Designing Ontology-Based Databases, proceedings of the 7th International IFIP Workshop on Semantic Web & Web Semantics (SWWS'2011), pp.444-453, 2011.
DOI : 10.1145/1166074.1166083

L. Bellatreche, Y. Aït-ameur, and C. Chakroun, A design methodology of ontology based database applications, Logic Journal of IGPL, vol.19, issue.5, pp.648-665, 2011.
DOI : 10.1093/jigpal/jzq017