{"id":"https://openalex.org/W2032301868","doi":"https://doi.org/10.4018/jdm.2001100103","title":"The Development of Ordered SQL Packages to Support Data Warehousing","display_name":"The Development of Ordered SQL Packages to Support Data Warehousing","publication_year":2001,"publication_date":"2001-10-01","ids":{"openalex":"https://openalex.org/W2032301868","doi":"https://doi.org/10.4018/jdm.2001100103","mag":"2032301868"},"language":"en","primary_location":{"id":"doi:10.4018/jdm.2001100103","is_oa":false,"landing_page_url":"https://doi.org/10.4018/jdm.2001100103","pdf_url":null,"source":{"id":"https://openalex.org/S73024538","display_name":"Journal of Database Management","issn_l":"1063-8016","issn":["1063-8016","1533-8010"],"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":"Journal of Database Management","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/A5067034635","display_name":"Wilfred Ng","orcid":"https://orcid.org/0000-0001-6639-0521"},"institutions":[{"id":"https://openalex.org/I200769079","display_name":"Hong Kong University of Science and Technology","ror":"https://ror.org/00q4vv597","country_code":"HK","type":"education","lineage":["https://openalex.org/I200769079"]}],"countries":["HK"],"is_corresponding":false,"raw_author_name":"Wilfred Ng","raw_affiliation_strings":["Hong Kong University of Science and Technology, Hong Kong","Hong Kong University of Science and Technology; Hong Kong"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Hong Kong University of Science and Technology, Hong Kong","institution_ids":["https://openalex.org/I200769079"]},{"raw_affiliation_string":"Hong Kong University of Science and Technology; Hong Kong","institution_ids":["https://openalex.org/I200769079"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5015725705","display_name":"Mark Levene","orcid":"https://orcid.org/0000-0001-8632-4732"},"institutions":[{"id":"https://openalex.org/I124357947","display_name":"University of London","ror":"https://ror.org/04cw6st05","country_code":"GB","type":"education","lineage":["https://openalex.org/I124357947"]}],"countries":["GB"],"is_corresponding":false,"raw_author_name":"Mark Levene","raw_affiliation_strings":["University of London, UK","University of London, UK > > > >"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of London, UK","institution_ids":["https://openalex.org/I124357947"]},{"raw_affiliation_string":"University of London, UK > > > >","institution_ids":["https://openalex.org/I124357947"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":2,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":0.0,"has_fulltext":false,"cited_by_count":2,"citation_normalized_percentile":{"value":0.18966486,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":null,"biblio":{"volume":"12","issue":"4","first_page":"26","last_page":"39"},"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.9995999932289124,"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.9995999932289124,"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/T11719","display_name":"Data Quality and Management","score":0.9972000122070312,"subfield":{"id":"https://openalex.org/subfields/1803","display_name":"Management Science and Operations Research"},"field":{"id":"https://openalex.org/fields/18","display_name":"Decision Sciences"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}},{"id":"https://openalex.org/T10215","display_name":"Semantic Web and Ontologies","score":0.9958000183105469,"subfield":{"id":"https://openalex.org/subfields/1702","display_name":"Artificial Intelligence"},"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.8415114879608154},{"id":"https://openalex.org/keywords/data-warehouse","display_name":"Data warehouse","score":0.787529468536377},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.7333009839057922},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.6115890145301819},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.6048339009284973},{"id":"https://openalex.org/keywords/relational-model","display_name":"Relational model","score":0.5219758749008179},{"id":"https://openalex.org/keywords/database-model","display_name":"Database model","score":0.4774663746356964},{"id":"https://openalex.org/keywords/relational-database-management-system","display_name":"Relational database management system","score":0.46036139130592346},{"id":"https://openalex.org/keywords/database-design","display_name":"Database design","score":0.4569239616394043},{"id":"https://openalex.org/keywords/data-definition-language","display_name":"Data definition language","score":0.43108850717544556},{"id":"https://openalex.org/keywords/online-analytical-processing","display_name":"Online analytical processing","score":0.4112854301929474}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8415114879608154},{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.787529468536377},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.7333009839057922},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.6115890145301819},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.6048339009284973},{"id":"https://openalex.org/C40207289","wikidata":"https://www.wikidata.org/wiki/Q755662","display_name":"Relational model","level":3,"score":0.5219758749008179},{"id":"https://openalex.org/C5968703","wikidata":"https://www.wikidata.org/wiki/Q267136","display_name":"Database model","level":3,"score":0.4774663746356964},{"id":"https://openalex.org/C24394798","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database management system","level":3,"score":0.46036139130592346},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.4569239616394043},{"id":"https://openalex.org/C55596503","wikidata":"https://www.wikidata.org/wiki/Q1431648","display_name":"Data definition language","level":3,"score":0.43108850717544556},{"id":"https://openalex.org/C201932085","wikidata":"https://www.wikidata.org/wiki/Q642514","display_name":"Online analytical processing","level":3,"score":0.4112854301929474}],"mesh":[],"locations_count":3,"locations":[{"id":"doi:10.4018/jdm.2001100103","is_oa":false,"landing_page_url":"https://doi.org/10.4018/jdm.2001100103","pdf_url":null,"source":{"id":"https://openalex.org/S73024538","display_name":"Journal of Database Management","issn_l":"1063-8016","issn":["1063-8016","1533-8010"],"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":"Journal of Database Management","raw_type":"journal-article"},{"id":"pmh:oai:RePEc:igg:jdm000:v:12:y:2001:i:4:p:26-39","is_oa":false,"landing_page_url":"http://services.igi-global.com/resolvedoi/resolve.aspx?doi=10.4018/jdm.2001100103","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:eprints.bbk.ac.uk.oai2:44625","is_oa":false,"landing_page_url":"https://eprints.bbk.ac.uk/id/eprint/44625/","pdf_url":null,"source":{"id":"https://openalex.org/S4306400466","display_name":"BIROn (Birkbeck, University of London)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I98259816","host_organization_name":"Birkbeck, University of London","host_organization_lineage":["https://openalex.org/I98259816"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":"Article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":21,"referenced_works":["https://openalex.org/W109127539","https://openalex.org/W1489672817","https://openalex.org/W1493938990","https://openalex.org/W1499274542","https://openalex.org/W1570058570","https://openalex.org/W1589039917","https://openalex.org/W1589223644","https://openalex.org/W1831125142","https://openalex.org/W1908950999","https://openalex.org/W1983117661","https://openalex.org/W1983520140","https://openalex.org/W1992810975","https://openalex.org/W1999670122","https://openalex.org/W2009957586","https://openalex.org/W2016909265","https://openalex.org/W2044009024","https://openalex.org/W2072960837","https://openalex.org/W2108971776","https://openalex.org/W2126979161","https://openalex.org/W2163168510","https://openalex.org/W2915777784"],"related_works":["https://openalex.org/W2048495764","https://openalex.org/W3085968255","https://openalex.org/W1491042988","https://openalex.org/W2505630977","https://openalex.org/W2045503597","https://openalex.org/W2326848084","https://openalex.org/W279222092","https://openalex.org/W3111548647","https://openalex.org/W1574818954","https://openalex.org/W4286283116"],"abstract_inverted_index":{"Data":[0],"warehousing":[1],"is":[2,114],"a":[3,25,34,92,131,141,160],"corporate":[4],"strategy":[5],"that":[6,45,115,137,166],"needs":[7],"to":[8,32,54,73,119,149],"integrate":[9],"information":[10,38],"from":[11,40,188],"several":[12],"sources":[13],"of":[14,24,37,48,95,107,124,127,159,163,183,194],"separately":[15],"developed":[16],"Database":[17],"Management":[18],"Systems":[19],"(DBMSs).":[20],"A":[21],"future":[22],"DBMS":[23],"data":[26,57,78,129,157,170],"warehouse":[27],"should":[28,51],"provide":[29],"adequate":[30],"facilities":[31,110],"manage":[33,150],"wide":[35,161],"range":[36,162],"arising":[39,187],"such":[41,172],"integration.":[42],"We":[43,68,86,179],"propose":[44],"the":[46,70,82,108,121,125,128,151,155,181,184,192],"capabilities":[47],"database":[49],"languages":[50],"be":[52,145],"enhanced":[53],"manipulate":[55],"user-defined":[56],"orderings,":[58],"since":[59],"business":[60],"queries":[61],"in":[62,169,191],"an":[63,146],"enterprise":[64],"usually":[65],"involve":[66],"order.":[67],"extend":[69],"relational":[71,84,104],"model":[72],"incorporate":[74],"partial":[75],"orderings":[76],"into":[77],"domains":[79,158],"and":[80,90,154,176,201],"describe":[81],"ordered":[83,103],"model.":[85],"have":[87],"already":[88],"defined":[89],"implemented":[91],"minimal":[93],"extension":[94],"SQL,":[96],"called":[97],"OSQL,":[98],"which":[99],"allows":[100,117],"querying":[101],"over":[102],"databases.":[105],"One":[106],"important":[109],"provided":[111],"by":[112],"OSQL":[113,138,196],"it":[116],"users":[118],"capture":[120],"underlying":[122,156],"semantics":[123],"ordering":[126],"for":[130],"given":[132],"application.":[133],"Herein":[134],"we":[135],"demonstrate":[136],"aided":[139],"with":[140],"package":[142],"discipline":[143],"can":[144],"effective":[147],"means":[148],"inter-related":[152],"operations":[153,186],"advanced":[164],"applications":[165,190],"are":[167],"vital":[168],"warehousing,":[171],"as":[173],"temporal,":[174],"incomplete":[175],"fuzzy":[177],"information.":[178],"present":[180],"details":[182],"generic":[185],"these":[189],"form":[193],"three":[195],"packages":[197],"called:":[198],"OSQL_TIME,":[199],"OSQL_INCOMP":[200],"OSQL_FUZZY.":[202]},"counts_by_year":[],"updated_date":"2026-06-11T09:08:48.828518","created_date":"2025-10-10T00:00:00"}