{"id":"https://openalex.org/W1982077511","doi":"https://doi.org/10.4018/jtd.2011070104","title":"Using OCL to Model Constraints in Data Warehouses","display_name":"Using OCL to Model Constraints in Data Warehouses","publication_year":2011,"publication_date":"2011-07-01","ids":{"openalex":"https://openalex.org/W1982077511","doi":"https://doi.org/10.4018/jtd.2011070104","mag":"1982077511"},"language":"en","primary_location":{"id":"doi:10.4018/jtd.2011070104","is_oa":false,"landing_page_url":"https://doi.org/10.4018/jtd.2011070104","pdf_url":null,"source":{"id":"https://openalex.org/S190331851","display_name":"International Journal of Technology Diffusion","issn_l":"1947-9301","issn":["1947-9301","1947-931X"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310320424","host_organization_name":"IGI Global","host_organization_lineage":["https://openalex.org/P4310320424"],"host_organization_lineage_names":["IGI Global"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"International Journal of Technology Diffusion","raw_type":"journal-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":false,"oa_status":"closed","oa_url":null,"any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5009642626","display_name":"Fran\u00e7ois Pinet","orcid":"https://orcid.org/0000-0001-7011-9216"},"institutions":[],"countries":[],"is_corresponding":true,"raw_author_name":"Fran\u00e7ois Pinet","raw_affiliation_strings":["Irstea/Cemagref - Clermont Ferrand, France"],"affiliations":[{"raw_affiliation_string":"Irstea/Cemagref - Clermont Ferrand, France","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5107146139","display_name":"Myoung-Ah Kang","orcid":null},"institutions":[{"id":"https://openalex.org/I4210099416","display_name":"Laboratoire d'Informatique, de Mod\u00e9lisation et d'Optimisation des Syst\u00e8mes","ror":"https://ror.org/00t3fpp34","country_code":"FR","type":"facility","lineage":["https://openalex.org/I1294671590","https://openalex.org/I1294671590","https://openalex.org/I198244214","https://openalex.org/I198244214","https://openalex.org/I203339264","https://openalex.org/I205703379","https://openalex.org/I3019848993","https://openalex.org/I4210099416","https://openalex.org/I4210123221","https://openalex.org/I4210159245","https://openalex.org/I4387154249"]}],"countries":["FR"],"is_corresponding":false,"raw_author_name":"Myoung-Ah Kang","raw_affiliation_strings":["LIMOS, France"],"affiliations":[{"raw_affiliation_string":"LIMOS, France","institution_ids":["https://openalex.org/I4210099416"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5082861622","display_name":"Kamal Boulil","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Kamal Boulil","raw_affiliation_strings":["Cemagref - Clermont Ferrand, France"],"affiliations":[{"raw_affiliation_string":"Cemagref - Clermont Ferrand, France","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5022668631","display_name":"Sandro Bimonte","orcid":"https://orcid.org/0000-0003-1727-6954"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Sandro Bimonte","raw_affiliation_strings":["Cemagref - Clermont Ferrand, France"],"affiliations":[{"raw_affiliation_string":"Cemagref - Clermont Ferrand, France","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5019882778","display_name":"Gil de Sousa","orcid":"https://orcid.org/0000-0003-1487-1723"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Gil De Sousa","raw_affiliation_strings":["Cemagref - Clermont Ferrand, France"],"affiliations":[{"raw_affiliation_string":"Cemagref - Clermont Ferrand, France","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5039970666","display_name":"Catherine Roussey","orcid":"https://orcid.org/0000-0002-3076-5499"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Catherine Roussey","raw_affiliation_strings":["Cemagref - Clermont Ferrand, France"],"affiliations":[{"raw_affiliation_string":"Cemagref - Clermont Ferrand, France","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5038430255","display_name":"Michel Schneider","orcid":"https://orcid.org/0000-0002-2701-4731"},"institutions":[{"id":"https://openalex.org/I4210099416","display_name":"Laboratoire d'Informatique, de Mod\u00e9lisation et d'Optimisation des Syst\u00e8mes","ror":"https://ror.org/00t3fpp34","country_code":"FR","type":"facility","lineage":["https://openalex.org/I1294671590","https://openalex.org/I1294671590","https://openalex.org/I198244214","https://openalex.org/I198244214","https://openalex.org/I203339264","https://openalex.org/I205703379","https://openalex.org/I3019848993","https://openalex.org/I4210099416","https://openalex.org/I4210123221","https://openalex.org/I4210159245","https://openalex.org/I4387154249"]}],"countries":["FR"],"is_corresponding":false,"raw_author_name":"Michel Schneider","raw_affiliation_strings":["LIMOS, France"],"affiliations":[{"raw_affiliation_string":"LIMOS, France","institution_ids":["https://openalex.org/I4210099416"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5085846176","display_name":"Jean-Pierre Chanet","orcid":"https://orcid.org/0000-0002-7011-4535"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Jean-Pierre Chanet","raw_affiliation_strings":["Cemagref - Clermont Ferrand, France"],"affiliations":[{"raw_affiliation_string":"Cemagref - Clermont Ferrand, France","institution_ids":[]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":8,"corresponding_author_ids":["https://openalex.org/A5009642626"],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":0.0,"has_fulltext":false,"cited_by_count":1,"citation_normalized_percentile":{"value":0.10532299,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":90,"max":94},"biblio":{"volume":"2","issue":"3","first_page":"36","last_page":"46"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9987999796867371,"subfield":{"id":"https://openalex.org/subfields/1705","display_name":"Computer Networks and Communications"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},"topics":[{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9987999796867371,"subfield":{"id":"https://openalex.org/subfields/1705","display_name":"Computer Networks and Communications"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T10703","display_name":"Business Process Modeling and Analysis","score":0.9930999875068665,"subfield":{"id":"https://openalex.org/subfields/1404","display_name":"Management Information Systems"},"field":{"id":"https://openalex.org/fields/14","display_name":"Business, Management and Accounting"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}},{"id":"https://openalex.org/T10679","display_name":"Service-Oriented Architecture and Web Services","score":0.9915000200271606,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8437327146530151},{"id":"https://openalex.org/keywords/data-warehouse","display_name":"Data warehouse","score":0.8163110017776489},{"id":"https://openalex.org/keywords/object-constraint-language","display_name":"Object Constraint Language","score":0.7892860174179077},{"id":"https://openalex.org/keywords/unified-modeling-language","display_name":"Unified Modeling Language","score":0.6942908763885498},{"id":"https://openalex.org/keywords/context","display_name":"Context (archaeology)","score":0.468711793422699},{"id":"https://openalex.org/keywords/business-intelligence","display_name":"Business intelligence","score":0.4672755002975464},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.44097983837127686},{"id":"https://openalex.org/keywords/constraint","display_name":"Constraint (computer-aided design)","score":0.41518110036849976},{"id":"https://openalex.org/keywords/software-engineering","display_name":"Software engineering","score":0.40197253227233887},{"id":"https://openalex.org/keywords/software","display_name":"Software","score":0.38409918546676636},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.3487408757209778},{"id":"https://openalex.org/keywords/applications-of-uml","display_name":"Applications of UML","score":0.2677455544471741}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8437327146530151},{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.8163110017776489},{"id":"https://openalex.org/C133264317","wikidata":"https://www.wikidata.org/wiki/Q1397689","display_name":"Object Constraint Language","level":5,"score":0.7892860174179077},{"id":"https://openalex.org/C145644426","wikidata":"https://www.wikidata.org/wiki/Q169411","display_name":"Unified Modeling Language","level":3,"score":0.6942908763885498},{"id":"https://openalex.org/C2779343474","wikidata":"https://www.wikidata.org/wiki/Q3109175","display_name":"Context (archaeology)","level":2,"score":0.468711793422699},{"id":"https://openalex.org/C2767350","wikidata":"https://www.wikidata.org/wiki/Q6662173","display_name":"Business intelligence","level":2,"score":0.4672755002975464},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.44097983837127686},{"id":"https://openalex.org/C2776036281","wikidata":"https://www.wikidata.org/wiki/Q48769818","display_name":"Constraint (computer-aided design)","level":2,"score":0.41518110036849976},{"id":"https://openalex.org/C115903868","wikidata":"https://www.wikidata.org/wiki/Q80993","display_name":"Software engineering","level":1,"score":0.40197253227233887},{"id":"https://openalex.org/C2777904410","wikidata":"https://www.wikidata.org/wiki/Q7397","display_name":"Software","level":2,"score":0.38409918546676636},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.3487408757209778},{"id":"https://openalex.org/C41298492","wikidata":"https://www.wikidata.org/wiki/Q4781506","display_name":"Applications of UML","level":4,"score":0.2677455544471741},{"id":"https://openalex.org/C78519656","wikidata":"https://www.wikidata.org/wiki/Q101333","display_name":"Mechanical engineering","level":1,"score":0.0},{"id":"https://openalex.org/C127413603","wikidata":"https://www.wikidata.org/wiki/Q11023","display_name":"Engineering","level":0,"score":0.0},{"id":"https://openalex.org/C86803240","wikidata":"https://www.wikidata.org/wiki/Q420","display_name":"Biology","level":0,"score":0.0},{"id":"https://openalex.org/C151730666","wikidata":"https://www.wikidata.org/wiki/Q7205","display_name":"Paleontology","level":1,"score":0.0}],"mesh":[],"locations_count":4,"locations":[{"id":"doi:10.4018/jtd.2011070104","is_oa":false,"landing_page_url":"https://doi.org/10.4018/jtd.2011070104","pdf_url":null,"source":{"id":"https://openalex.org/S190331851","display_name":"International Journal of Technology Diffusion","issn_l":"1947-9301","issn":["1947-9301","1947-931X"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310320424","host_organization_name":"IGI Global","host_organization_lineage":["https://openalex.org/P4310320424"],"host_organization_lineage_names":["IGI Global"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"International Journal of Technology Diffusion","raw_type":"journal-article"},{"id":"pmh:oai:HAL:hal-02082971v1","is_oa":false,"landing_page_url":"https://hal.science/hal-02082971","pdf_url":null,"source":{"id":"https://openalex.org/S4306402512","display_name":"HAL (Le Centre pour la Communication Scientifique Directe)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I1294671590","host_organization_name":"Centre National de la Recherche Scientifique","host_organization_lineage":["https://openalex.org/I1294671590"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"IJTD, 2011, 2 (3), pp.36--46. ⟨10.4018/jtd.2011070104⟩","raw_type":"Journal articles"},{"id":"pmh:oai:RePEc:igg:jtd000:v:2:y:2011:i:3:p:36-46","is_oa":false,"landing_page_url":"https://services.igi-global.com/resolvedoi/resolve.aspx?doi=10.4018/jtd.2011070104","pdf_url":null,"source":{"id":"https://openalex.org/S4306401271","display_name":"RePEc: Research Papers in Economics","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I77793887","host_organization_name":"Federal Reserve Bank of St. Louis","host_organization_lineage":["https://openalex.org/I77793887"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"article"},{"id":"pmh:oai:irsteadoc.irstea.fr:PUB00034693","is_oa":false,"landing_page_url":"https://irsteadoc.irstea.fr/cemoa/PUB00034693","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"28730","raw_type":"Article de revue scientifique \u00e0 comit\u00e9 de lecture"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":40,"referenced_works":["https://openalex.org/W32696687","https://openalex.org/W56443290","https://openalex.org/W142900317","https://openalex.org/W1486374580","https://openalex.org/W1509485343","https://openalex.org/W1518695183","https://openalex.org/W1519931530","https://openalex.org/W1540492331","https://openalex.org/W1562451657","https://openalex.org/W1575681083","https://openalex.org/W1968189045","https://openalex.org/W1982958427","https://openalex.org/W1987759864","https://openalex.org/W1988156201","https://openalex.org/W2006038203","https://openalex.org/W2016179906","https://openalex.org/W2016218534","https://openalex.org/W2016257365","https://openalex.org/W2023892515","https://openalex.org/W2038327754","https://openalex.org/W2044399674","https://openalex.org/W2048467633","https://openalex.org/W2063859853","https://openalex.org/W2072916859","https://openalex.org/W2076687865","https://openalex.org/W2082948153","https://openalex.org/W2093588231","https://openalex.org/W2099293367","https://openalex.org/W2114887408","https://openalex.org/W2140924391","https://openalex.org/W2159765281","https://openalex.org/W2163065312","https://openalex.org/W2291557532","https://openalex.org/W2298771771","https://openalex.org/W2398624727","https://openalex.org/W2936355644","https://openalex.org/W4249121902","https://openalex.org/W4300901380","https://openalex.org/W6697001719","https://openalex.org/W6736610090"],"related_works":["https://openalex.org/W208715492","https://openalex.org/W2581040172","https://openalex.org/W1511392673","https://openalex.org/W2157349984","https://openalex.org/W2383696629","https://openalex.org/W2120683664","https://openalex.org/W39487940","https://openalex.org/W2374264231","https://openalex.org/W172234034","https://openalex.org/W1551210741"],"abstract_inverted_index":{"Recent":[0],"research":[1],"works":[2],"propose":[3,34],"using":[4],"Object-Oriented":[5],"(OO)":[6],"approaches,":[7],"such":[8],"as":[9],"UML":[10],"to":[11,51,66,84,87,113],"model":[12],"data":[13,58,93,126],"warehouses.":[14,59,127],"This":[15,96],"paper":[16,82,97],"overviews":[17],"these":[18],"recent":[19],"OO":[20],"techniques,":[21],"describing":[22],"the":[23,30,38,77,89,102,116,123,135],"facts":[24],"and":[25,43,72,107,143],"different":[26,90],"analysis":[27],"dimensions":[28],"of":[29,37,57,92,104,125,138,140],"data.":[31],"The":[32,128],"authors":[33,78,129],"a":[35],"tutorial":[36],"Object":[39],"Constraint":[40],"Language":[41],"(OCL)":[42],"show":[44],"how":[45,83],"this":[46,81],"language":[47],"can":[48],"be":[49],"used":[50],"specify":[52],"constraints":[53,68],"in":[54,69,80,101,122],"OO-based":[55],"models":[56,142],"Previously,":[60],"OCL":[61,86,120],"has":[62],"been":[63],"only":[64],"applied":[65],"describe":[67],"software":[70],"applications":[71],"transactional":[73],"databases.":[74],"As":[75],"such,":[76],"demonstrate":[79],"use":[85],"represent":[88],"types":[91,137],"warehouse":[94],"constraints.":[95,145],"helps":[98],"researchers":[99],"working":[100],"fields":[103],"business":[105],"intelligence":[106],"decision":[108],"support":[109],"systems,":[110],"who":[111],"wish":[112],"learn":[114],"about":[115,134],"major":[117],"possibilities":[118],"that":[119],"offer":[121],"context":[124],"also":[130],"provide":[131],"general":[132],"information":[133],"possible":[136],"implementation":[139],"multi-dimensional":[141],"their":[144]},"counts_by_year":[{"year":2016,"cited_by_count":1}],"updated_date":"2026-04-04T16:13:02.066488","created_date":"2025-10-10T00:00:00"}