{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2025,5,21]],"date-time":"2025-05-21T10:42:59Z","timestamp":1747824179525,"version":"3.28.0"},"reference-count":13,"publisher":"IEEE","license":[{"start":{"date-parts":[[2020,10,14]],"date-time":"2020-10-14T00:00:00Z","timestamp":1602633600000},"content-version":"vor","delay-in-days":0,"URL":"https:\/\/ieeexplore.ieee.org\/Xplorehelp\/downloads\/license-information\/IEEE.html"},{"start":{"date-parts":[[2020,10,14]],"date-time":"2020-10-14T00:00:00Z","timestamp":1602633600000},"content-version":"stm-asf","delay-in-days":0,"URL":"https:\/\/doi.org\/10.15223\/policy-029"},{"start":{"date-parts":[[2020,10,14]],"date-time":"2020-10-14T00:00:00Z","timestamp":1602633600000},"content-version":"stm-asf","delay-in-days":0,"URL":"https:\/\/doi.org\/10.15223\/policy-037"}],"content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":[],"published-print":{"date-parts":[[2020,10,14]]},"DOI":"10.1109\/icccs49678.2020.9276824","type":"proceedings-article","created":{"date-parts":[[2020,12,10]],"date-time":"2020-12-10T03:21:19Z","timestamp":1607570479000},"page":"1-5","source":"Crossref","is-referenced-by-count":3,"title":["Proposed Techniques to Optimize the DW and ETL Query for Enhancing data warehouse efficiency"],"prefix":"10.1109","author":[{"given":"Abhishek","family":"Gupta","sequence":"first","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Arun","family":"Sahayadhas","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]}],"member":"263","reference":[{"journal-title":"SYSTEMS AND METHODS FOR STORING AND QUERYING SLOWLY CHANGING DIMIENSIONS United States Patent","year":"2012","author":"braden","key":"ref10"},{"journal-title":"COMPARATIVE STUDY OF INDEXING TECHNIQUES IN DBMS","year":"2012","author":"gupta","key":"ref11"},{"key":"ref12","doi-asserted-by":"publisher","DOI":"10.1109\/ICICIS.2011.36"},{"journal-title":"METHOD OF MANAGING SLOWLY CHANGING DIMENSIONS United States Patent","year":"2005","author":"griffin","key":"ref13"},{"journal-title":"SLOWLY CHANGING DMENSION ATTRIBUTES IN EXTRACT TRANSFORM LOAD PROCESSES","year":"2016","author":"bhide","key":"ref4"},{"key":"ref3","first-page":"515","article-title":"Comparative Analysis of Query Optimization Techniques in Database Systems","volume":"4","author":"wankhade","year":"2019","journal-title":"International journal of science engineering development research"},{"key":"ref6","first-page":"22","article-title":"Query Optimization Techniques - Tips For Writing Efficient And Faster SQL Queries","volume":"4","author":"habimana","year":"2015","journal-title":"International Journal of Scientific & Technology Research"},{"journal-title":"An Extensive Survey on Various Query Optimization Techniques","year":"2016","author":"thangam","key":"ref5"},{"journal-title":"A Study on the Role of Equivalence Rules in the Enhancement of Query Performance","year":"2013","author":"johnson","key":"ref8"},{"journal-title":"A Survey on Query Processing and Optimization in Relational Database Management System","year":"2015","author":"gupta","key":"ref7"},{"journal-title":"A Comparative Study of Indexing using Oracle and MS-SQL Server for Relational Database Management Systems","year":"2019","author":"hashim","key":"ref2"},{"key":"ref1","first-page":"463","article-title":"A Comprehensive Survey to Design Efficient Data Warehouse for Betterment of Decision Support Systems for Management and Business Corporates","volume":"11","author":"gupta","year":"2020","journal-title":"International Journal of Management (IJM)"},{"key":"ref9","volume":"2","author":"kumari","year":"2012","journal-title":"Sql Server Query Optimization Techniques – Tips For Writing Efficient and Faster Queries"}],"event":{"name":"2020 5th International Conference on Computing, Communication and Security (ICCCS)","start":{"date-parts":[[2020,10,14]]},"location":"Patna, India","end":{"date-parts":[[2020,10,16]]}},"container-title":["2020 5th International Conference on Computing, Communication and Security (ICCCS)"],"original-title":[],"link":[{"URL":"http:\/\/xplorestaging.ieee.org\/ielx7\/9276407\/9276491\/09276824.pdf?arnumber=9276824","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2022,6,28]],"date-time":"2022-06-28T00:23:55Z","timestamp":1656375835000},"score":1,"resource":{"primary":{"URL":"https:\/\/ieeexplore.ieee.org\/document\/9276824\/"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2020,10,14]]},"references-count":13,"URL":"https:\/\/doi.org\/10.1109\/icccs49678.2020.9276824","relation":{},"subject":[],"published":{"date-parts":[[2020,10,14]]}}}