{"id":"https://openalex.org/W2041628891","doi":"https://doi.org/10.3166/jds.13.155-172","title":"SQL Extensions to Enable Decision Support within Database Systems","display_name":"SQL Extensions to Enable Decision Support within Database Systems","publication_year":2004,"publication_date":"2004-01-01","ids":{"openalex":"https://openalex.org/W2041628891","doi":"https://doi.org/10.3166/jds.13.155-172","mag":"2041628891"},"language":"en","primary_location":{"id":"doi:10.3166/jds.13.155-172","is_oa":false,"landing_page_url":"https://doi.org/10.3166/jds.13.155-172","pdf_url":null,"source":{"id":"https://openalex.org/S119153320","display_name":"Journal of Decision System","issn_l":"1246-0125","issn":["1246-0125","2116-7052"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310320547","host_organization_name":"Taylor & Francis","host_organization_lineage":["https://openalex.org/P4310320547"],"host_organization_lineage_names":["Taylor & Francis"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Journal of Decision Systems","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/A5055613958","display_name":"Damianos Chatziantoniou","orcid":null},"institutions":[{"id":"https://openalex.org/I73142707","display_name":"Athens University of Economics and Business","ror":"https://ror.org/03s262162","country_code":"GR","type":"education","lineage":["https://openalex.org/I73142707"]}],"countries":["GR"],"is_corresponding":true,"raw_author_name":"Damianos Chatziantoniou","raw_affiliation_strings":["a Department of Management Science and Technology , Athens University of Economics and Business , Room 910, Evelpidon 47A & Lefakdos, Athens , 11362 , Greece","Department of Management Science and Technology , Athens University of Economics and Business , Room 910, Evelpidon 47A & Lefakdos, Athens , 11362 , Greece"],"affiliations":[{"raw_affiliation_string":"a Department of Management Science and Technology , Athens University of Economics and Business , Room 910, Evelpidon 47A & Lefakdos, Athens , 11362 , Greece","institution_ids":["https://openalex.org/I73142707"]},{"raw_affiliation_string":"Department of Management Science and Technology , Athens University of Economics and Business , Room 910, Evelpidon 47A & Lefakdos, Athens , 11362 , Greece","institution_ids":["https://openalex.org/I73142707"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5110420894","display_name":"George Doukidis","orcid":null},"institutions":[{"id":"https://openalex.org/I73142707","display_name":"Athens University of Economics and Business","ror":"https://ror.org/03s262162","country_code":"GR","type":"education","lineage":["https://openalex.org/I73142707"]}],"countries":["GR"],"is_corresponding":false,"raw_author_name":"George Doukidis","raw_affiliation_strings":["a Department of Management Science and Technology , Athens University of Economics and Business , Room 910, Evelpidon 47A & Lefakdos, Athens , 11362 , Greece","Department of Management Science and Technology , Athens University of Economics and Business , Room 910, Evelpidon 47A & Lefakdos, Athens , 11362 , Greece"],"affiliations":[{"raw_affiliation_string":"a Department of Management Science and Technology , Athens University of Economics and Business , Room 910, Evelpidon 47A & Lefakdos, Athens , 11362 , Greece","institution_ids":["https://openalex.org/I73142707"]},{"raw_affiliation_string":"Department of Management Science and Technology , Athens University of Economics and Business , Room 910, Evelpidon 47A & Lefakdos, Athens , 11362 , Greece","institution_ids":["https://openalex.org/I73142707"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":2,"corresponding_author_ids":["https://openalex.org/A5055613958"],"corresponding_institution_ids":["https://openalex.org/I73142707"],"apc_list":null,"apc_paid":null,"fwci":0.0,"has_fulltext":false,"cited_by_count":0,"citation_normalized_percentile":{"value":0.15859311,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":null,"biblio":{"volume":"13","issue":"2","first_page":"155","last_page":"172"},"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.9997000098228455,"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.9997000098228455,"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/T11106","display_name":"Data Management and Algorithms","score":0.9945999979972839,"subfield":{"id":"https://openalex.org/subfields/1711","display_name":"Signal Processing"},"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/T12205","display_name":"Time Series Analysis and Forecasting","score":0.9937999844551086,"subfield":{"id":"https://openalex.org/subfields/1711","display_name":"Signal Processing"},"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.8854812979698181},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.7302088737487793},{"id":"https://openalex.org/keywords/data-warehouse","display_name":"Data warehouse","score":0.6327347755432129},{"id":"https://openalex.org/keywords/online-analytical-processing","display_name":"Online analytical processing","score":0.5830702781677246},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.5566384792327881},{"id":"https://openalex.org/keywords/decision-support-system","display_name":"Decision support system","score":0.5455883741378784},{"id":"https://openalex.org/keywords/data-definition-language","display_name":"Data definition language","score":0.5084649324417114},{"id":"https://openalex.org/keywords/context","display_name":"Context (archaeology)","score":0.4516375660896301},{"id":"https://openalex.org/keywords/data-science","display_name":"Data science","score":0.4005450904369354},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.3446260988712311}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8854812979698181},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.7302088737487793},{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.6327347755432129},{"id":"https://openalex.org/C201932085","wikidata":"https://www.wikidata.org/wiki/Q642514","display_name":"Online analytical processing","level":3,"score":0.5830702781677246},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.5566384792327881},{"id":"https://openalex.org/C107327155","wikidata":"https://www.wikidata.org/wiki/Q330268","display_name":"Decision support system","level":2,"score":0.5455883741378784},{"id":"https://openalex.org/C55596503","wikidata":"https://www.wikidata.org/wiki/Q1431648","display_name":"Data definition language","level":3,"score":0.5084649324417114},{"id":"https://openalex.org/C2779343474","wikidata":"https://www.wikidata.org/wiki/Q3109175","display_name":"Context (archaeology)","level":2,"score":0.4516375660896301},{"id":"https://openalex.org/C2522767166","wikidata":"https://www.wikidata.org/wiki/Q2374463","display_name":"Data science","level":1,"score":0.4005450904369354},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.3446260988712311},{"id":"https://openalex.org/C151730666","wikidata":"https://www.wikidata.org/wiki/Q7205","display_name":"Paleontology","level":1,"score":0.0},{"id":"https://openalex.org/C86803240","wikidata":"https://www.wikidata.org/wiki/Q420","display_name":"Biology","level":0,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.3166/jds.13.155-172","is_oa":false,"landing_page_url":"https://doi.org/10.3166/jds.13.155-172","pdf_url":null,"source":{"id":"https://openalex.org/S119153320","display_name":"Journal of Decision System","issn_l":"1246-0125","issn":["1246-0125","2116-7052"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310320547","host_organization_name":"Taylor & Francis","host_organization_lineage":["https://openalex.org/P4310320547"],"host_organization_lineage_names":["Taylor & Francis"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Journal of Decision Systems","raw_type":"journal-article"}],"best_oa_location":null,"sustainable_development_goals":[{"display_name":"Peace, Justice and strong institutions","score":0.5299999713897705,"id":"https://metadata.un.org/sdg/16"}],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":26,"referenced_works":["https://openalex.org/W123968353","https://openalex.org/W146175679","https://openalex.org/W1480446764","https://openalex.org/W1481218190","https://openalex.org/W1483324348","https://openalex.org/W1489843519","https://openalex.org/W1514949376","https://openalex.org/W1526700922","https://openalex.org/W1527356121","https://openalex.org/W1539916429","https://openalex.org/W1918398775","https://openalex.org/W1970911465","https://openalex.org/W2001474264","https://openalex.org/W2002110561","https://openalex.org/W2060947232","https://openalex.org/W2078451216","https://openalex.org/W2099189392","https://openalex.org/W2103201239","https://openalex.org/W2118828104","https://openalex.org/W2132520482","https://openalex.org/W2140406474","https://openalex.org/W2143979434","https://openalex.org/W2149133292","https://openalex.org/W2150950420","https://openalex.org/W2169593628","https://openalex.org/W4237578258"],"related_works":["https://openalex.org/W2378213774","https://openalex.org/W2357522326","https://openalex.org/W6138692","https://openalex.org/W2363019959","https://openalex.org/W1535822977","https://openalex.org/W23190051","https://openalex.org/W2367419170","https://openalex.org/W2377387014","https://openalex.org/W2353410296","https://openalex.org/W2084266952"],"abstract_inverted_index":{"Modern":[0],"organizations":[1],"store":[2],"massive":[3],"amount":[4],"of":[5,41,84,134],"information":[6],"within":[7],"their":[8],"data":[9,35,50,61,119,146],"warehouses":[10],"to":[11,27,93,104],"carry":[12],"out":[13,29],"complex":[14,115],"analysis":[15],"and":[16,30,88,140],"decision":[17,68,97,142],"support,":[18],"such":[19],"as":[20,54,59],"identifying":[21],"interesting":[22],"trends,":[23],"making":[24],"unusual":[25],"patterns":[26],"stand":[28],"verifying":[31],"hypotheses.":[32],"Besides":[33],"traditional":[34,118],"warehousing":[36],"applications,":[37],"a":[38,96],"new":[39],"class":[40],"data-intensive":[42],"systems":[43,86],"is":[44,51,102],"emerging:":[45],"applications":[46],"in":[47,114,131],"which":[48],"the":[49,71,80,132],"modeled":[52],"not":[53],"persistent":[55],"relations":[56],"but":[57],"rather":[58],"transient":[60],"streams.":[62],"In":[63],"this":[64,125],"article":[65],"we":[66,138],"approach":[67,108],"support":[69,143],"from":[70],"database":[72,85],"viewpoint.":[73],"We":[74,122],"briefly":[75],"mention":[76],"SQL":[77],"features":[78],"\u2013":[79,87],"standard":[81],"query":[82],"language":[83],"review":[89,139],"several":[90],"proposed":[91],"extensions":[92],"make":[94],"it":[95],"support-oriented":[98],"language.":[99],"Special":[100],"emphasis":[101],"given":[103],"EMF":[105],"SQL,":[106],"an":[107],"that":[109,124],"has":[110],"proven":[111],"very":[112],"useful":[113,130],"querying":[116],"over":[117,145],"ware-housing":[120],"applications.":[121],"argue":[123],"extension":[126],"can":[127],"also":[128],"be":[129],"context":[133],"stream":[135,147],"data.":[136],"Finally,":[137],"discuss":[141],"challenges":[144],"systems.":[148]},"counts_by_year":[],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}