{"id":"https://openalex.org/W2188975716","doi":null,"title":"A Comparative Study of OLTP and OLAP Technologies","display_name":"A Comparative Study of OLTP and OLAP Technologies","publication_year":2013,"publication_date":"2013-01-01","ids":{"openalex":"https://openalex.org/W2188975716","mag":"2188975716"},"language":"en","primary_location":{"id":"mag:2188975716","doi":null,"is_oa":false,"landing_page_url":"http://www.ijcst.com/vol42/2/jasbir.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},"parent_works":[],"lineage":["https://openalex.org/W2188975716"],"child_works_count":0,"type":"article","is_traditional":true,"indexed_in":[],"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/A5101956260","display_name":"Jatinderpal Singh","orcid":"https://orcid.org/0000-0001-9981-3965","observed_orcids":["https://orcid.org/0000-0001-9981-3965"]},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Jatinderpal Singh","raw_affiliation_strings":[],"raw_orcid":"https://orcid.org/0000-0001-9981-3965","affiliations":[]},{"author_position":"last","author":{"id":null,"display_name":"Anshul Sood","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Anshul Sood","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.0,"has_fulltext":false,"cited_by_count":0,"citation_normalized_percentile":{"value":0.0,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":null,"last_page":null},"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.9794999957084656,"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.9794999957084656,"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.01979999989271164,"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/T11734","display_name":"Decision Support System Applications","score":9.999999747378752e-05,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/online-transaction-processing","display_name":"online transaction processing","score":0.8610000014305115},{"id":"https://openalex.org/keywords/olap","display_name":"OLAP","score":0.996999979019165},{"id":"https://openalex.org/keywords/data-warehousing","display_name":"data warehousing","score":0.9509999752044678},{"id":"https://openalex.org/keywords/online-analytical-processing","display_name":"online analytical processing","score":0.9559999704360962},{"id":"https://openalex.org/keywords/decision-support-system","display_name":"decision support system","score":0.843999981880188},{"id":"https://openalex.org/keywords/operational-databases","display_name":"operational databases","score":0.6159999966621399},{"id":"https://openalex.org/keywords/data-storage-and-retrieval","display_name":"data storage and retrieval","score":0.6349999904632568}],"concepts":[{"id":"https://openalex.org/C201932085","wikidata":"https://www.wikidata.org/wiki/Q642514","display_name":"Online analytical processing","level":3,"score":0.9882701635360718},{"id":"https://openalex.org/C191087605","wikidata":"https://www.wikidata.org/wiki/Q1501395","display_name":"Online transaction processing","level":4,"score":0.9836463928222656},{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.7989027500152588},{"id":"https://openalex.org/C72108876","wikidata":"https://www.wikidata.org/wiki/Q844565","display_name":"Transaction processing","level":3,"score":0.6699747443199158},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.6694300174713135},{"id":"https://openalex.org/C75949130","wikidata":"https://www.wikidata.org/wiki/Q848010","display_name":"Database transaction","level":2,"score":0.644195556640625},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.6430563926696777},{"id":"https://openalex.org/C2767350","wikidata":"https://www.wikidata.org/wiki/Q6662173","display_name":"Business intelligence","level":2,"score":0.4156540036201477},{"id":"https://openalex.org/C2522767166","wikidata":"https://www.wikidata.org/wiki/Q2374463","display_name":"Data science","level":1,"score":0.37935033440589905}],"mesh":[],"locations_count":1,"locations":[{"id":"mag:2188975716","doi":null,"is_oa":false,"landing_page_url":"http://www.ijcst.com/vol42/2/jasbir.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}],"best_oa_location":null,"sustainable_development_goals":[],"study_designs":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":6,"referenced_works":["https://openalex.org/W563724364","https://openalex.org/W1508412218","https://openalex.org/W1570448133","https://openalex.org/W2072764742","https://openalex.org/W2108971776","https://openalex.org/W2140190241"],"related_works":["https://openalex.org/W7098581364","https://openalex.org/W7098928215","https://openalex.org/W7128298812","https://openalex.org/W2404676707","https://openalex.org/W289877171","https://openalex.org/W2783669268","https://openalex.org/W2336188071","https://openalex.org/W4213297968","https://openalex.org/W2072764742","https://openalex.org/W2564390746"],"abstract_inverted_index":{"This":[0],"paper":[1],"provides":[2],"an":[3],"overview":[4],"of":[5,11,32,54,61],"Data":[6,44,87],"warehousing":[7,45,88],"and":[8,25,46,65,84,89,101],"comparative":[9],"study":[10],"OLAP,":[12],"OLTP":[13,57],"technologies.":[14],"The":[15],"data":[16,75,98],"warehouse":[17],"supports":[18],"On-Line":[19,34,47],"Analytical":[20,48],"Processing":[21,36,49],"(OLAP)":[22,50],"who\u2019s":[23],"functional":[24],"performance":[26],"requirements":[27],"are":[28,51],"different":[29],"from":[30],"those":[31],"the":[33,41],"Transaction":[35],"(OLTP)":[37],"applications":[38],"supported":[39],"by":[40,77],"operational":[42],"databases.":[43],"essential":[52],"elements":[53],"decision":[55],"support.":[56],"is":[58,72],"a":[59],"class":[60],"program":[62],"that":[63,96],"facilitates":[64],"manages":[66],"transaction-oriented":[67],"applications.":[68],"An":[69],"OLAP":[70,90],"system":[71],"used":[73],"for":[74],"analysis":[76],"knowledge":[78],"workers,":[79],"including":[80],"managers,":[81],"business":[82],"executives":[83],"market":[85],"analysts.":[86],"have":[91],"emerged":[92],"as":[93],"leading":[94],"technologies":[95],"facilitate":[97],"storage,":[99],"organization":[100],"retrieval.":[102]},"counts_by_year":[],"updated_date":"2026-11-14T11:04:58.165337","created_date":"2016-06-24T00:00:00"}