{"id":"https://openalex.org/W4249893271","doi":"https://doi.org/10.1002/int.20012","title":"A data warehouse/online analytic processing framework for web usage mining and business intelligence reporting","display_name":"A data warehouse/online analytic processing framework for web usage mining and business intelligence reporting","publication_year":2004,"publication_date":"2004-01-01","ids":{"openalex":"https://openalex.org/W4249893271","doi":"https://doi.org/10.1002/int.20012"},"language":"en","primary_location":{"id":"doi:10.1002/int.20012","doi":"https://doi.org/10.1002/int.20012","is_oa":false,"landing_page_url":"https://doi.org/10.1002/int.20012","pdf_url":null,"source":{"id":"https://openalex.org/S57950554","display_name":"International Journal of Intelligent Systems","issn_l":"0884-8173","issn":["0884-8173","1098-111X"],"is_oa":false,"is_in_doaj":false,"is_core":true,"listed_in":["anvur-scientific","ccf-c","cwts-core","dongbi-c","jufo-1","norway-1","poland-100","russia-white-list-1"],"host_organization":"https://openalex.org/P4310320595","host_organization_name":"Wiley","host_organization_lineage":["https://openalex.org/P4310320595"],"host_organization_lineage_names":["Wiley"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"International Journal of Intelligent Systems","raw_type":"journal-article"},"volume":null,"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/A5101569679","display_name":"Xiaohua Tony Hu","orcid":"https://orcid.org/0000-0002-4777-3022","observed_orcids":["https://orcid.org/0000-0002-4777-3022","https://orcid.org/0009-0009-9813-8457"]},"institutions":[{"id":"https://openalex.org/I72816309","display_name":"Drexel University","ror":"https://ror.org/04bdffz58","country_code":"US","type":"education","lineage":["https://openalex.org/I72816309"]}],"countries":["US"],"is_corresponding":true,"raw_author_name":"Xiaohua Hu","raw_affiliation_strings":["College of Information Science, Drexel University, Philadelphia, PA 19104"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"College of Information Science, Drexel University, Philadelphia, PA 19104","institution_ids":["https://openalex.org/I72816309"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5105530330","display_name":"Nick J. Cercone","orcid":null,"observed_orcids":[]},"institutions":[{"id":"https://openalex.org/I129902397","display_name":"Dalhousie University","ror":"https://ror.org/01e6qks80","country_code":"CA","type":"education","lineage":["https://openalex.org/I129902397"]}],"countries":["CA"],"is_corresponding":false,"raw_author_name":"Nick Cercone","raw_affiliation_strings":["Faculty of Computer Science, Dalhousie University, Halifax, Nova Scotia, Canada"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Faculty of Computer Science, Dalhousie University, Halifax, Nova Scotia, Canada","institution_ids":["https://openalex.org/I129902397"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":2,"corresponding_author_ids":["https://openalex.org/A5101569679"],"corresponding_institution_ids":["https://openalex.org/I72816309"],"apc_list":{"value":2700,"currency":"USD","value_usd":2700},"apc_paid":null,"fwci":0.6173,"has_fulltext":false,"cited_by_count":23,"citation_normalized_percentile":{"value":0.843122,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":98},"biblio":{"volume":"19","issue":"7","first_page":"585","last_page":"606"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11891","display_name":"Big Data and Business Intelligence","score":0.6547999978065491,"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.6547999978065491,"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/T12016","display_name":"Web Data Mining and Analysis","score":0.1860000044107437,"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/T10538","display_name":"Data Mining Algorithms and Applications","score":0.07150000333786011,"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/web-usage-mining","display_name":"web usage mining","score":1.0},{"id":"https://openalex.org/keywords/data-warehouse","display_name":"data warehouse","score":0.9610000252723694},{"id":"https://openalex.org/keywords/olap","display_name":"OLAP","score":0.8209999799728394},{"id":"https://openalex.org/keywords/business-intelligence-reporting","display_name":"business intelligence reporting","score":0.9900000095367432},{"id":"https://openalex.org/keywords/e-commerce","display_name":"e-commerce","score":0.8360000252723694},{"id":"https://openalex.org/keywords/clickstream-data","display_name":"clickstream data","score":0.9390000104904175},{"id":"https://openalex.org/keywords/data-transformation","display_name":"data transformation","score":0.7889999747276306},{"id":"https://openalex.org/keywords/pattern-discovery","display_name":"pattern discovery","score":0.6769999861717224},{"id":"https://openalex.org/keywords/consumer-behavior-analysis","display_name":"customer behavior analysis","score":0.5180000066757202},{"id":"https://openalex.org/keywords/session-analysis","display_name":"session analysis","score":0.4180000126361847}],"concepts":[{"id":"https://openalex.org/C201932085","wikidata":"https://www.wikidata.org/wiki/Q642514","display_name":"Online analytical processing","level":3,"score":0.918705403804779},{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.848309338092804},{"id":"https://openalex.org/C138744977","wikidata":"https://www.wikidata.org/wiki/Q5132438","display_name":"Clickstream","level":5,"score":0.8135577440261841},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7505348920822144},{"id":"https://openalex.org/C2767350","wikidata":"https://www.wikidata.org/wiki/Q6662173","display_name":"Business intelligence","level":2,"score":0.7236276865005493},{"id":"https://openalex.org/C197046077","wikidata":"https://www.wikidata.org/wiki/Q785337","display_name":"Web mining","level":3,"score":0.7197585105895996},{"id":"https://openalex.org/C544335954","wikidata":"https://www.wikidata.org/wiki/Q2553348","display_name":"Web intelligence","level":4,"score":0.5274752974510193},{"id":"https://openalex.org/C89198739","wikidata":"https://www.wikidata.org/wiki/Q3079880","display_name":"Data stream mining","level":2,"score":0.4956570863723755},{"id":"https://openalex.org/C516187249","wikidata":"https://www.wikidata.org/wiki/Q10719477","display_name":"Web analytics","level":5,"score":0.4700830280780792},{"id":"https://openalex.org/C2522767166","wikidata":"https://www.wikidata.org/wiki/Q2374463","display_name":"Data science","level":1,"score":0.45544055104255676},{"id":"https://openalex.org/C150670458","wikidata":"https://www.wikidata.org/wiki/Q4272815","display_name":"Data transformation","level":3,"score":0.4309886395931244},{"id":"https://openalex.org/C37952496","wikidata":"https://www.wikidata.org/wiki/Q5001829","display_name":"Business analytics","level":4,"score":0.41983097791671753},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.3841826617717743},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.3769834637641907},{"id":"https://openalex.org/C21959979","wikidata":"https://www.wikidata.org/wiki/Q36774","display_name":"Web page","level":2,"score":0.36454272270202637},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.35334911942481995},{"id":"https://openalex.org/C130436687","wikidata":"https://www.wikidata.org/wiki/Q7978591","display_name":"Web modeling","level":3,"score":0.2519075274467468},{"id":"https://openalex.org/C189076506","wikidata":"https://www.wikidata.org/wiki/Q1518232","display_name":"Business analysis","level":3,"score":0.19224223494529724},{"id":"https://openalex.org/C4216890","wikidata":"https://www.wikidata.org/wiki/Q815823","display_name":"Business model","level":2,"score":0.14931151270866394},{"id":"https://openalex.org/C144133560","wikidata":"https://www.wikidata.org/wiki/Q4830453","display_name":"Business","level":0,"score":0.1199997067451477},{"id":"https://openalex.org/C127613066","wikidata":"https://www.wikidata.org/wiki/Q557770","display_name":"Web API","level":4,"score":0.1197873055934906},{"id":"https://openalex.org/C162853370","wikidata":"https://www.wikidata.org/wiki/Q39809","display_name":"Marketing","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1002/int.20012","doi":"https://doi.org/10.1002/int.20012","is_oa":false,"landing_page_url":"https://doi.org/10.1002/int.20012","pdf_url":null,"source":{"id":"https://openalex.org/S57950554","display_name":"International Journal of Intelligent Systems","issn_l":"0884-8173","issn":["0884-8173","1098-111X"],"is_oa":false,"is_in_doaj":false,"is_core":true,"listed_in":["anvur-scientific","ccf-c","cwts-core","dongbi-c","jufo-1","norway-1","poland-100","russia-white-list-1"],"host_organization":"https://openalex.org/P4310320595","host_organization_name":"Wiley","host_organization_lineage":["https://openalex.org/P4310320595"],"host_organization_lineage_names":["Wiley"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"International Journal of Intelligent Systems","raw_type":"journal-article"}],"best_oa_location":null,"sustainable_development_goals":[],"study_designs":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":7,"referenced_works":["https://openalex.org/W1484728537","https://openalex.org/W1485828998","https://openalex.org/W1521725368","https://openalex.org/W1588882338","https://openalex.org/W1623603061","https://openalex.org/W1657646951","https://openalex.org/W1982896842"],"related_works":["https://openalex.org/W2131781085","https://openalex.org/W2082985473","https://openalex.org/W2040134882","https://openalex.org/W7095898443","https://openalex.org/W2387301269","https://openalex.org/W7097755226","https://openalex.org/W2085109630","https://openalex.org/W2097479883","https://openalex.org/W2384727959","https://openalex.org/W7039477092"],"abstract_inverted_index":{"Web":[0],"usage":[1,12,54,87,126,193],"mining":[2,8,55,93,127,194],"is":[3],"the":[4,36,63,73,81,138,152,156],"application":[5],"of":[6,100],"data":[7,18,46,65,68,96,103,121,167,181],"techniques":[9],"to":[10,27,151],"discover":[11],"patterns":[13],"and":[14,29,34,56,70,83,92,111,114,117,128,134,140,154,195],"behaviors":[15],"from":[16,161],"web":[17,53,64,86,125,164,192],"(clickstream,":[19],"purchase":[20],"information,":[21,23],"customer":[22,135],"etc.)":[24],"in":[25,131,143,146],"order":[26],"understand":[28],"serve":[30],"e-commerce":[31,74,176],"customers":[32],"better":[33],"improve":[35],"online":[37],"business.":[38],"In":[39],"this":[40,76,180],"article,":[41],"we":[42,61],"present":[43],"a":[44],"general":[45],"warehouse/online":[47],"analytic":[48],"processing":[49],"(OLAP)":[50],"framework":[51,98,157,169,183],"for":[52,85,124,188],"business":[57,89,129,196],"intelligence":[58,90,197],"reporting.":[59],"When":[60],"integrate":[62],"warehouse":[66],"construction,":[67,113],"mining,":[69,88],"OLAP":[71],"into":[72,173],"system,":[75],"tight":[77],"integration":[78],"dramatically":[79],"reduces":[80],"time":[82],"effort":[84],"reporting,":[91],"deployment.":[94,118],"Our":[95,166],"warehouse/OLAP":[97,168,182],"consists":[99],"four":[101],"phases:":[102],"capture,":[104],"webhouse":[105],"construction":[106],"(clickstream":[107],"marts),":[108],"pattern":[109,115],"discovery":[110],"cube":[112],"evaluation":[116],"We":[119,178],"discuss":[120],"transformation":[122],"operations":[123],"reporting":[130,198],"clickstream,":[132],"session,":[133],"levels;":[136],"describe":[137],"problems":[139],"challenging":[141],"issues":[142],"each":[144],"phase":[145],"detail;":[147],"provide":[148],"plausible":[149],"solutions":[150],"issues;":[153],"demonstrate":[155],"with":[158],"some":[159,162,174],"examples":[160],"real":[163],"sites.":[165],"has":[170],"been":[171],"integrated":[172],"commercial":[175],"systems.":[177,199],"believe":[179],"would":[184],"be":[185],"very":[186],"useful":[187],"developing":[189],"any":[190],"real-world":[191],"\u00a9":[200],"2004":[201],"Wiley":[202],"Periodicals,":[203],"Inc.":[204]},"counts_by_year":[{"year":2025,"cited_by_count":2},{"year":2024,"cited_by_count":1},{"year":2020,"cited_by_count":4},{"year":2019,"cited_by_count":1},{"year":2015,"cited_by_count":3},{"year":2014,"cited_by_count":4},{"year":2013,"cited_by_count":1}],"updated_date":"2026-10-16T09:59:22.235173","created_date":"2022-05-12T00:00:00"}