{"id":"https://openalex.org/W58358713","doi":null,"title":"Creating a Data Warehouse using SQL Server.","display_name":"Creating a Data Warehouse using SQL Server.","alternate_titles":[],"publication_year":1999,"publication_date":"1999-01-01","ids":{"openalex":"https://openalex.org/W58358713","mag":"58358713"},"language":"en","primary_location":{"id":"pmh:oai:pure.atira.dk:publications/c7ce4c50-24fe-11da-834f-000ea68e967b","doi":null,"is_oa":true,"landing_page_url":"https://pure.au.dk/portal/en/publications/c7ce4c50-24fe-11da-834f-000ea68e967b","pdf_url":"http://sunsite.informatik.rwth-aachen.de/Publications/CEUR-WS/Vol-19/paper10.pdf","source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"S\u00f8rensen, J O & Alnor, K 1999, Creating a Data Warehouse using SQL Server. in Proceeding of the International Workshop on Design and Management of Data Warehouses (DMDW \u00b499). Design and Management of Data Warehouses, 14/06/1999. < http://sunsite.informatik.rwth-aachen.de/Publications/CEUR-WS/Vol-19/paper10.pdf >","raw_type":"contributionToPeriodical"},"parent_works":[],"lineage":["https://openalex.org/W58358713"],"child_works_count":0,"type":"conference-paper","is_traditional":true,"indexed_in":[],"open_access":{"is_oa":true,"oa_status":"green","oa_url":"http://sunsite.informatik.rwth-aachen.de/Publications/CEUR-WS/Vol-19/paper10.pdf","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5006586709","display_name":"Jens Otto S\u00f8rensen","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":false,"contributor_roles":[],"raw_author_name":"Jens Otto S\u00f8rensen","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"last","author":{"id":"https://openalex.org/A5054313701","display_name":"Karl Alnor","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":false,"contributor_roles":[],"raw_author_name":"Karl Alnor","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]}],"institutions":[],"countries_distinct_count":0,"institutions_distinct_count":0,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":0.5338,"has_fulltext":true,"cited_by_count":2,"citation_normalized_percentile":{"value":0.66767372,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":"10","last_page":null},"is_retracted":false,"is_pulled":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11891","display_name":"Big Data and Business Intelligence","score":0.9320999979972839,"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"}},"topics":[{"id":"https://openalex.org/T11891","display_name":"Big Data and Business Intelligence","score":0.9320999979972839,"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/T10317","display_name":"Advanced Database Systems and Queries","score":0.06700000166893005,"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"}},{"id":"https://openalex.org/T13681","display_name":"Engineering and Information Technology","score":0.0,"subfield":{"id":"https://openalex.org/subfields/1712","display_name":"Software"},"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/data-warehouse","display_name":"data warehouse","score":0.9700000286102295},{"id":"https://openalex.org/keywords/sql-server-7-0","display_name":"SQL Server 7.0","score":0.9169999957084656},{"id":"https://openalex.org/keywords/dimensional-modeling","display_name":"dimensional modeling","score":0.7459999918937683},{"id":"https://openalex.org/keywords/data-loading","display_name":"data loading","score":0.6010000109672546},{"id":"https://openalex.org/keywords/operational-databases","display_name":"operational databases","score":0.8080000281333923},{"id":"https://openalex.org/keywords/database-design","display_name":"database design","score":0.5730000138282776}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7723615169525146},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.7427327632904053},{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.702002227306366},{"id":"https://openalex.org/C141589383","wikidata":"https://www.wikidata.org/wiki/Q644775","display_name":"Data Transformation Services","level":5,"score":0.5430521368980408},{"id":"https://openalex.org/C33882796","wikidata":"https://www.wikidata.org/wiki/Q4826222","display_name":"Autocommit","level":5,"score":0.5301797389984131},{"id":"https://openalex.org/C2984286706","wikidata":"https://www.wikidata.org/wiki/Q400708","display_name":"Sql server","level":2,"score":0.5282196998596191},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.5234375},{"id":"https://openalex.org/C30775581","wikidata":"https://www.wikidata.org/wiki/Q632285","display_name":"Database schema","level":3,"score":0.5167285799980164},{"id":"https://openalex.org/C52146309","wikidata":"https://www.wikidata.org/wiki/Q7431116","display_name":"Schema (genetic algorithms)","level":2,"score":0.5134056806564331},{"id":"https://openalex.org/C54239708","wikidata":"https://www.wikidata.org/wiki/Q1329910","display_name":"View","level":3,"score":0.4795650839805603},{"id":"https://openalex.org/C205295232","wikidata":"https://www.wikidata.org/wiki/Q76320","display_name":"Database server","level":2,"score":0.4510176181793213},{"id":"https://openalex.org/C154420247","wikidata":"https://www.wikidata.org/wiki/Q846619","display_name":"Stored procedure","level":5,"score":0.4178684949874878},{"id":"https://openalex.org/C55596503","wikidata":"https://www.wikidata.org/wiki/Q1431648","display_name":"Data definition language","level":3,"score":0.4165634512901306},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.38935741782188416},{"id":"https://openalex.org/C94925161","wikidata":"https://www.wikidata.org/wiki/Q6666854","display_name":"Log shipping","level":4,"score":0.23393630981445312},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.22548136115074158},{"id":"https://openalex.org/C164554305","wikidata":"https://www.wikidata.org/wiki/Q71550","display_name":"Application server","level":2,"score":0.2057441771030426},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.2041471004486084},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.1986909806728363},{"id":"https://openalex.org/C166930804","wikidata":"https://www.wikidata.org/wiki/Q573731","display_name":"Internet Authentication Service","level":3,"score":0.1816924512386322},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.0},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.0}],"mesh":[],"locations_count":3,"locations":[{"id":"pmh:oai:pure.atira.dk:publications/c7ce4c50-24fe-11da-834f-000ea68e967b","doi":null,"is_oa":true,"landing_page_url":"https://pure.au.dk/portal/en/publications/c7ce4c50-24fe-11da-834f-000ea68e967b","pdf_url":"http://sunsite.informatik.rwth-aachen.de/Publications/CEUR-WS/Vol-19/paper10.pdf","source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"S\u00f8rensen, J O & Alnor, K 1999, Creating a Data Warehouse using SQL Server. in Proceeding of the International Workshop on Design and Management of Data Warehouses (DMDW \u00b499). Design and Management of Data Warehouses, 14/06/1999. < http://sunsite.informatik.rwth-aachen.de/Publications/CEUR-WS/Vol-19/paper10.pdf >","raw_type":"contributionToPeriodical"},{"id":"mag:58358713","doi":null,"is_oa":false,"landing_page_url":"http://ceur-ws.org/Vol-19/paper10.pdf","pdf_url":null,"source":null,"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":null},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.40.9677","doi":null,"is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.40.9677","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://SunSITE.Informatik.RWTH-Aachen.DE/Publications/CEUR-WS/Vol-19/paper10.pdf","raw_type":"text"}],"best_oa_location":{"id":"pmh:oai:pure.atira.dk:publications/c7ce4c50-24fe-11da-834f-000ea68e967b","doi":null,"is_oa":true,"landing_page_url":"https://pure.au.dk/portal/en/publications/c7ce4c50-24fe-11da-834f-000ea68e967b","pdf_url":"http://sunsite.informatik.rwth-aachen.de/Publications/CEUR-WS/Vol-19/paper10.pdf","source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"S\u00f8rensen, J O & Alnor, K 1999, Creating a Data Warehouse using SQL Server. in Proceeding of the International Workshop on Design and Management of Data Warehouses (DMDW \u00b499). Design and Management of Data Warehouses, 14/06/1999. < http://sunsite.informatik.rwth-aachen.de/Publications/CEUR-WS/Vol-19/paper10.pdf >","raw_type":"contributionToPeriodical"},"sustainable_development_goals":[],"study_designs":[],"awards":[],"funders":[{"id":"https://openalex.org/F4320310487","display_name":"Samfund og Erhverv, Det Frie Forskningsr\u00e5d","ror":"https://ror.org/02regzg56"},{"id":"https://openalex.org/F4320321409","display_name":"Aalborg Universitet","ror":"https://ror.org/04m5j1k67"}],"has_content":{"pdf":true,"grobid_xml":true},"content_urls":{"pdf":"https://content.openalex.org/works/W58358713.pdf","grobid_xml":"https://content.openalex.org/works/W58358713.grobid-xml"},"referenced_works_count":1,"referenced_works":["https://openalex.org/W1591747115"],"related_works":["https://openalex.org/W7067573577","https://openalex.org/W1890354865","https://openalex.org/W185550390","https://openalex.org/W2385609804","https://openalex.org/W626841726","https://openalex.org/W633303806","https://openalex.org/W2069325139","https://openalex.org/W2808335007","https://openalex.org/W2356654932","https://openalex.org/W576313118"],"abstract_inverted_index":{":":[0],"In":[1],"this":[2,13,121,135,140],"paper":[3],"we":[4],"construct":[5],"a":[6,88],"Star":[7],"Join":[8],"Schema":[9],"and":[10,129],"show":[11],"how":[12],"schema":[14],"can":[15,40],"be":[16,41],"created":[17],"using":[18],"the":[19,32,45,49,60,71,75,85,92,118,124,130,143,148],"basic":[20],"tools":[21],"delivered":[22],"with":[23,97,105],"SQL":[24,66],"Server":[25,67],"7.0.":[26],"Major":[27],"objectives":[28],"are":[29],"to":[30,99,107,123,154,164],"keep":[31],"operational":[33,50,53],"database":[34,54,62,86,125,151],"unchanged":[35],"so":[36],"that":[37],"data":[38],"loading":[39],"done":[42],"without":[43],"disturbing":[44],"business":[46],"logic":[47],"of":[48,59,73,78,84,91,120,142],"database.":[51,81],"The":[52,127],"is":[55,69,87,110],"an":[56],"expanded":[57],"version":[58,83],"Pubs":[61],"[Sol96].":[63],"1":[64],"Introduction":[65],"7.0":[68],"at":[70],"time":[72],"writing":[74],"latest":[76],"release":[77,122,136],"Microsoft's":[79],"\"large\"":[80],"This":[82],"significant":[89],"upgrade":[90],"previous":[93],"(version":[94],"6.5)":[95],"both":[96],"respect":[98,106],"user":[100],"friendliness":[101],"as":[102,104],"well":[103],"capabilities.":[108],"There":[109],"therefore":[111],"in":[112],"our":[113],"minds":[114],"no":[115],"question":[116],"about":[117],"importance":[119],"world.":[126],"pricing":[128],"aggressive":[131],"marketing":[132],"push":[133],"behind":[134],"will":[137,159],"soon":[138],"make":[139,165],"one":[141],"most":[144,149,160],"used,":[145,150],"if":[146],"not":[147],"for":[152],"small":[153],"medium":[155],"sized":[156],"companies.":[157],"Microsoft":[158],"likely":[161],"also":[162],"try":[163],"companies":[166],"...":[167]},"cited_by_api_url":"https://api.openalex.org/works?filter=cites:W58358713","counts_by_year":[],"updated_date":"2026-11-17T12:49:18.490984","created_date":"2016-06-24T00:00:00"}
