Group 4 Research Project Slides
pptx
keyboard_arrow_up
School
Normandale Community College *
*We aren’t endorsed by this school
Course
1005
Subject
Information Systems
Date
Dec 6, 2023
Type
pptx
Pages
27
Uploaded by wildx2012
Group 4 Research
Project
Lauren Wiley, Stella Richards, Urenwa Nwokiwu
University of Maryland Global Campus
ISAS 640 9040 Decision Support Systems and Expert Systems (2238)
Tonya Miller
October 31, 2023
Introduction
Data warehousing can be used by all sizes of organizations and organizations in different industries. Advancements in data
warehousing have made it available to organizations who would consider this technology a capital expense or lack of funds to
support the technology. Data warehousing provides many advantages for organizations regardless of their size since the cloud
allows small and medium organizations to use this technology and not have to invest a lot of resources in supporting it since
cloud-based data warehousing is a viable option for them. However, there are disadvantages to using data warehousing, such
as vendor lock-in and a limited amount of data that can be stored. There are two types of data warehouses that an
organization can decide to use, which are physical data warehousing and cloud-based data warehousing. These two types of
data warehousing have their advantages and disadvantages.
Depending on the needs, size, or overall industry risk, some industries may benefit from physical data warehousing over
cloud-based data warehousing, and others may require the reverse. In addition, for some organizations, the advantages of
cloud-based data warehousing outweigh the disadvantages of physical data warehousing, and other organizations still require
physical data warehousing due to the nature of the industry or prefer to own their data warehouse software and
infrastructure outright. Physical data warehousing will not become obsolete due to some organizations operating in
industries where the cloud is a liability, dealing with confidential data, or having trade secrets.
Topics to Be discussed
•
Advantages of Data Warehousing
•
Disadvantages of Data Warehousing
•
Advantages of Physical Data Warehousing
•
Disadvantages of Physical Data Warehousing
•
When should Physical Data Warehousing be Used
•
Advantages of Cloud Data Warehousing
•
Disadvantages of Cloud Data Warehousing
•
When should Cloud Based Data warehousing be used
•
Do the advantages of cloud-based data warehousing outweigh the disadvantages of physical data warehousing
infrastructure?
•
Will physical data warehousing infrastructure become obsolete, or will it still be needed for some organizations (e.g., high-
stakes industries where the cloud is a liability)?
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Advantages of Data Warehousing
The advantages of data warehousing include saving time, improving data quality, storing historical data, and data security.
Data warehousing saves time by consolidating the data from the repository, which supports decision-making, provides data
quickly, meets deadlines, decisions can be made quickly and effectively, and results can be provided easily to relevant
stakeholders (Fatima 2023; Fivetran, 2023). When an organization uses data warehousing, it can improve the data quality by
cleaning the data, which involves removing inaccurate and duplicated data, resulting in consistent and reliable data that can
be used to create reports, make informed business decisions, reduce costs of data management, and gain business insights.
In addition, data warehouses can be used to store historical data to track and forecast long-term trends, identify periodic
trends, make predictions, regression analysis, make informed decisions based on current or future trends, and identify
opportunities that can improve business growth. Another advantage of data warehousing is that it can increase data security
by encrypting data, data is stored in one centralized location rather than on different platforms, users can have their access
restricted based on permissions, and sensitive data can be restricted to only allow users from certain departments.
Disadvantages of Data Warehousing
The disadvantages of data warehousing are vendor lock-in, storage costs, and limited amount of data that can be stored.
Vendor lock-in is a challenge since the organization may potentially lose access to its data if the organization doesn't keep
paying the subscription, may not own the software outright (only if the software is subscription-based or being leased to the
organization in accordance with the vendor's terms and conditions), long-term economic dependencies on the vendor, the
data warehouse files may be proprietary (e.g., vendor A's file is a .dxn whereas vendor B file is a .xed file) and are not
compatible with another vendor's data warehouse, lose features that were part of a lower tier and moved to a more
expensive tier (e.g., Feature A was part of Silver but was moved to Diamond and Feature B was moved to Gold; thus the
organization has pay $1000 a month for Platinum or $600 a month for Gold rather than $200 a month for Silver that the
features were a part of), data files become locked behind a paywall if the subscription lapses, and cancellation fees if the
organization decides to drop the vendor before the trial period ends.
Disadvantages of Data Warehousing
Cont.
Storage costs are a disadvantage of data warehousing since an organization has to be able to store all of the past and current
data that can be in the terabytes or, have to buy more infrastructure to store new data when the current storage space for
files fills up, upgrade to a new subscription that allows unlimited storage space or to a higher tier that allows more data to be
stored, and storing data can get expensive for organizations if renting storage from a vendor or relying on the organization's
own infrastructure. Data warehouses can limit the amount of data that an organization can store; thus, organizations have to
limit what type of data is stored and collected based on the reporting requirements rather than what may be needed in the
future due to storage costs, limitations of the infrastructure storage space, and software analysis limitations (Faction, 2021).
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Advantages of Physical Data
Warehousing
A data warehouse consolidates business data from internal applications, databases, and SaaS platforms and serves as a single
repository to which an organization can reference to make informed decisions. A data warehouse is the best solution for
business intelligence and analytical reporting because transactional databases are unsuitable for analytical processing. Data
warehouses offload analytical processing from transactional databases and enable faster processing through the use of
columnar data stores, allowing users to quickly access only data elements related (Stitch, n.d.).
Advantages of physical data warehousing include centralized data, improved data quality, enhanced data security, and better
performance. Physical data warehouses store all data in one place, making it easier for users to access and analyze data. Since
all data is stored in a single location, it's easier to maintain and improve data quality. Physical data warehouses often have
robust security measures in place to protect sensitive data. Physical data warehouses are often optimized for performance,
allowing for faster data retrieval and analysis (Foot, 2022).
Disadvantages of Physical Data
Warehousing
Disadvantages of physical data warehousing are high costs, limited scalability, maintenance, data latency, and risk of data
loss. Physical data warehouses can be expensive to set up and maintain. They require significant investment in hardware,
software, and personnel. Physical data warehouses have a finite amount of storage space. As a business grows, it may need to
invest in additional hardware to accommodate increasing amounts of data.
Physical data warehouses require regular maintenance to ensure they continue to operate efficiently. This can be time-
consuming and costly. Since data must be extracted, transformed, and loaded (ETL) into the warehouse, there can be a delay
(latency) in data availability. In case of any physical damage like fire, flood, or any other disaster, there is a risk of losing all the
data stored in the warehouse (Foot, 2022).
When Should Physical Data
Warehousing be Used
Organizations that deal with sensitive and/or confidential data or have trade secrets that are in a high-stakes industries where
corporate espionage is prevalent, such as biotechnology, chemical, and IT, should rely on physical data warehousing rather
than cloud data warehousing. This is due to data security concerns, organizations wanting to own the data warehouse
outright, potential data ownership issues that can arise with cloud data warehouses, and not wanting to be forced to update
the system due to incompatibility with legacy software (e.g., Windows XP or older versions of Linux), and certain updates to
the system may break commonly used functions that can make the data warehouse system unusable (e.g., the update fixed
function A but broke function C). Also, when physical data warehouse vendors are involved in a data breach, the only
sensitive information involved is the company credit card and products purchased since the physical data warehouse is not
connected to the vendor's server and the data warehouses are off-line.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
When Should Physical Data
Warehousing be Used Cont.
Large organizations would be using physical data warehousing since they have the resources to own the data warehouses
outright, have the IT team and administrative team to support physical data warehouse systems, investing in more storage is
not a capital expense or cash sinkhole, wanting to own the products outright, and issues with data warehouse can be easily
fixed by the IT team who can troubleshoot and fix the issue. In addition, organizations may want to use on-premises due to
off-line accessibility since they have frequent internet outages or poor internet connections, require full control of the
system, and need physical access to the infrastructure.
Cloud Data Warehouse
This technology allows data to be stored and queried from the cloud. Cloud data storage software is essentially technology
that allows you to store and query data in the cloud. This can be a great choice if you're looking to reduce your need for on-
premises hardware or want to take advantage of the scalability and flexibility of the cloud. When evaluating your cloud data
warehouse, you should consider the following aspects of your data:
•
Volume – How much data do you need to store?
•
Diversity – How diverse is your data?
•
Location – Where is your data located?
•
Processing – How much data needs to be processed?
•
Query – How often should you query your data?
•
Cost – How much does it cost to use a cloud data warehouse?
Advantages of Cloud Data
Warehousing
Scalability and flexibility is one of the key benefits of a cloud data warehouse is the ability to scale resources on demand. This
flexibility is important for businesses facing fluctuations in data volumes, and it enables seamless cloud data warehouse
modernization as new technologies emerge (Data Sleek, 2023).
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Advantage #1: Low Total Cost of
Ownership
Cloud-based data warehouses are preferred by organizations due to the low costs. On-premises data warehouses can require
expensive hardware, time-consuming upgrades, consistent maintenance, and outage management (Talend, n.d.). When
business collect and store large amount of data, maintaining on-premises data warehouses can get expensive. Thus,
increased costs can result due to being unable to unbundle on-premises data warehouses and infrastructure a business
expansion can result in significantly increased costs (Data Sleek, 2023).
On-premises data warehouses can require significant amounts of resources for major events that can occur that would
require storing or analyzing large amounts of data. Cloud data warehouses, on the other hand, allow data warehouse teams
to purchase as little or as much computing power and storage as needed (Talend, n.d.). Additionally, cloud data warehouses
do not require additional infrastructure, hardware, and networks set up by the organization.
Advantage #2: Improved Speed and
Performance
Cloud data warehouses are essential for keeping up with the growing different types and large amounts of data sources.
Thus, organizations need to utilize ERP, CRM, social media, support, and marketing data while maintaining speed and
performance (Talend, n.d.). On the other hand, on-premises data warehouses are unable to match the capabilities of cloud
data warehouses.
Cloud data warehouses are very efficient; thus, can process and analyze multiple data streams at once. This can be achieved
since cloud data warehouses use multiple servers that can increase the process speed and load times. As a result of using
more than 1 server cloud data warehouses can be used by organizations located in different areas without being overloaded;
thus, leading to improved productivity and efficiency. In addition, any additional data can be integrated and deployed as
needed.
Advantage #3: Seamless Self-
Service Capabilities for Business
Owners
Cloud data warehouses enable stakeholders to make evidence-based decisions quickly by improving the visibility of data, self-
service analytics, and ease of running queries. Cloud data warehouse achieve this by pooling its resources which results in
creating reports for users, performing ad-hoc queries, make data accessible to users, users can make informed decisions, and
IT can focus on more urgent tasks that provide value to the organization.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Advantage #4: More Secure Data
On-premises data storage can be seen as more secure for some users. However, technological advancements have made
cloud more secure and less expensive to maintain, which can surpass on-premises security protocols that can be prone to
human error (Talend, n.d.). Since cloud data is not store in different locations, IT can put controls in place to the protect data
through encryption, multi-factor authentication, and make data transfers over the cloud between locations secure
Disadvantages of Cloud
Warehousing
The disadvantages of cloud data warehousing are lack of governance, lack of qualified resources, lack of planning support,
and lack of automation support. These issues are challenges due to risks of storing and delivering sensitive data in the cloud,
staff sometimes don’t know what type of data is stored in the cloud, what rules and policies need to be followed, and
responsibilities staff have when handling
and storing data in the cloud. In addition, with new technology it requires staff to
have new skills such as design, cataloging, development, and maintenance of these new data warehouses which they may
not have. Another challenge is vendor not providing support that assists organization in understanding how they can use the
data warehouse to the fullest extent possible and gaining its benefits (Sandwell, 2022).
When Should Cloud-Based Data
Warehousing Be Used
Organizations in low and medium-stakes industries such as grocery stores, hardware stores, construction, and tourism would
be better off using cloud-based data warehousing. Also, small and medium organizations should use cloud-based data
warehousing. The reasons these industries and organizations should use cloud-based data warehousing are due to lacking the
funds or staff to support on-premises data warehousing systems, require faster insights to make informed decisions, need the
scalability or unlimited storage to store lots of data (e.g., historic and current data), the data warehouse is continuously
updated by the vendor, low cost of ownership, and vendors handle maintenance of infrastructure. Other reasons
organizations should use cloud-based data warehousing is due to disaster recovery, can handle multiple streams of data at
once, better security protocols, management can integrate different data sources, and can change subscriptions to meet
changing demands and business needs (Talend, n.d.; Naseem, 2023).
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Do the Advantages of Cloud-Based Data Warehousing
Outweigh the Disadvantages of Physical Data
warehousing Infrastructure?
The advantages of Cloud-based data warehousing are being cheaper for organizations, can be set up quickly, scalability, ease
of accessibility, and high availability and disaster recovery. Cloud-based data warehousing is often cheaper because you
cannot buy and maintain physical servers. The scalability of cloud-based data makes it easier to make it bigger or smaller as
organizational needs change. It is accessible anywhere, which is great for remote work. Cloud-based data warehouses are
typically highly available and offer robust disaster recovery capabilities due to its high availability and disaster recovery.
The disadvantages of physical data warehousing are that it can be expensive, takes more time to set up, scaling is difficult,
and cannot be accessed remotely easily.
Physical data warehousing is expensive to buy and maintain the hardware and
building.
Scalability is a disadvantage since it involves buying and installing more hardware.
Do the Advantages of Cloud-Based Data Warehousing
Outweigh the Disadvantages of Physical Data
warehousing Infrastructure? Cont.
Therefore, whether cloud-based is better depends on your needs and budget. For many, the advantages of cloud-based data
warehousing outweigh the disadvantages of physical infrastructure.
ne of the key considerations is the financial aspect.
Cloud-based data warehousing typically requires less upfront investment because you're renting resources as needed, which
can be more budget-friendly, especially for smaller businesses or startups with limited capital. Furthermore, cloud-based
solutions are often lauded for their agility. They allow companies to swiftly adapt to changing data storage requirements.
Whether you need to expand your data capacity to accommodate growth or scale it down during quieter periods, the cloud
can seamlessly adjust, providing a level of flexibility that traditional physical infrastructure struggles to match. Accessibility is
another significant factor. Cloud-based data warehousing offers the convenience of remote access. This is especially valuable
in today's increasingly digital world, where teams might be spread across different locations, and working from home or on
the go is the norm. It enables efficient collaboration and data utilization, no matter where your team members are situated.
Will physical data warehousing infrastructure become
obsolete, or will it still be needed for some organizations
(e.g., high-stakes industries where the cloud is a liability)?
Physical data warehousing won't become obsolete because some organizations have special requirements.
Imagine banks or
government agencies that handle very sensitive information. They may not trust the cloud due to security concerns, and they
want full control over their data. In these high-stakes industries, physical data warehousing may still be needed. So, it
depends on what you need and how important data security is to your organization. Physical data warehousing will still have
a place, especially in industries where trust and control are crucial.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Conclusion
Data warehousing provides many advantages to organizations, such as saving time, improving data quality, storing historical
data, and data security. In addition, data warehouses can be used to store historical data to track and forecast long-term
trends, identify periodic trends, make predictions, regression analysis, make informed decisions based on current or future
trends, and identify opportunities that can improve business growth. Drawbacks of data warehousing include vendor lock-in,
storage costs, and the limited amount of data that can be stored. Vendor lock-in is the biggest challenge due to organizations
running the risk of losing access to data if a payment lapse is caused by an expired company credit card, data warehouse files
may not be compatible with another vendor due to being proprietary (e.g., vendor A's file is a .dxn whereas vendor B file is
a .xed file), and lose features that were part of a lower tier and moved to a more expensive tier (e.g., Feature A was part of
Silver but was moved to Diamond and Feature B was moved to Gold; thus the organization has pay $1000 a month for
Platinum or $600 a month for Gold rather than $200 a month for Silver that the features were a part of).
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Conclusion Cont.
Organizations, regardless of their size, can choose between having a physical data warehouse or a cloud-based data
warehouse, which have leveled competitive fields for smaller organizations who lack the funds, or a physical data warehouse
would be a sunk cost or capital expense. Advantages of data warehousing include centralized data, improved data quality,
enhanced data security, and better performance. The drawbacks of physical data warehousing are high costs, limited
scalability, maintenance, data latency, and risk of data loss. Organizations who would be relying on physical data warehouses
are those that deal with sensitive and/or confidential data or trade secrets where corporate espionage is prevalent; thus the
industry is considered high stakes. Industries that would rely on physical data warehousing are biotechnology, chemical, and
IT due to data security concerns, working with legacy software, and updates run the risk of breaking commonly used
functions. In addition, for some organizations, managers prefer physical data warehousing since they have frequent internet
outages or poor internet connections, require full control of the system, and need physical access to the infrastructure.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Conclusion Cont.
Advantages of cloud data warehousing include scalability, flexibility, low cost of ownership, improved speed and
performance, and better security.
The drawbacks of using cloud data warehousing include lack of governance, lack of
qualified resources, and lack of planning support.
Organizations that would use cloud-based data warehousing are slow and
medium-stakes industries such as grocery stores and tourism, as well as small and medium organizations.
These
organizations and industries would use cloud-based data warehousing due to lacking the funds to support on-premises data
warehousing, need the scalability or unlimited storage to store lots of data (e.g., historic and current data), the vendor
continuously updates the data warehouse, which provides a competitive advantage, and low cost of ownership.
The needs and budget of an organization can impact whether or not a cloud-based data warehouse is better than a physical
data warehouse.
For most organizations, low stakes and medium stakes, a cloud-based data warehouse would be better than
a physical data warehouse due to being budget-friendly for startups and smaller businesses, ease of scalability caused by
changing data storage requirements, and level of flexibility and accessibility.
On the other hand, physical data warehousing
won't become obsolete due to organizations having special requirements, handling sensitive information, security concerns,
and need full control over their data.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
References
Burnside, K. (n.d.).
The disadvantages of a data warehouse
. Chron.
https://smallbusiness.chron.com/disadvantages-data-warehouse-73584.html
Coursera. (2023, June 16).
Data warehouse: definition, uses, and examples
.
https://www.coursera.org/articles/data-warehouse
Data Sleek. (2022, September 16).
What are the advantages of building a cloud data warehouse
.
https://data-sleek.com/blog/what-are-the-advantages-of-building-a-data-warehouse-in-the-cloud/
Faction. (2021, July 2).
Data warehouse vs. data lake: pros and cons
.
https://www.factioninc.com/resources/blog/data-warehouse-vs-data-lake-pros-and-cons/
Fatima, N. (2023, October 11).
What is a data warehouse? definition, example & benefits (a complete guide)
. Astera.
https://www.astera.com/type/blog/data-warehouse-definition/
Fivetran. (2023, May 22).
Top 6 benefits of a data warehouse
.
https://www.fivetran.com/learn/benefits-of-data-warehouse
Foot, C. (2022, July 22).
On-premises vs. cloud data warehouses: pros and cons
. TechTarget.
https://www.techtarget.com/searchdatamanagement/tip/On-premises-vs-cloud-data-warehouses-Pros-and-cons
Herath, S. (October 8).
Are data warehouses obsolete?
Medium.
https://medium.com/@sandaruwanherath/are-data-warehouses-obsolete-ab4aae3a61f4#:~:text=Traditional%20data%20
warehousing%20concepts%20may,for%20organizations%20of%20all%20sizes
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
References Cont.
Kenton, W. (2022, July 12).
Industrial espionage: definition, examples, types, legality
. Investopedia.
https://www.investopedia.com/terms/i/industrial-espionage.asp
Kodikal, P. (2021, August 16).
5 Limitations of data warehouses in today’s world of infinite data
. Dremio.
https://www.dremio.com/blog/5-limitations-of-data-warehouses-in-today-s-world-of-infinite-data/
Naseem, O. (2023, August 19).
What is a cloud data warehouse? 6 benefits of adopting a cloud data warehouse for your
organization
. Astera.
https://www.astera.com/type/blog/cloud-data-warehouse-benefits/
Panoply. (n.d.).
Cloud data warehouse vs traditional data warehouse concepts
.
https://panoply.io/data-warehouse-guide/data-warehouse-concepts-traditional-vs-cloud/
Qlik. (n.d.).
What is a cloud data warehouse?
https://www.qlik.com/us/cloud-data-migration/cloud-data-warehouse
Qnectus. (2022, April 5).
The pros and cons of on-premise storage
.
https://qnectus.com/2022/04/05/the-pros-and-cons-of-on-premise-storage/
Sandwell, D. (2022, August 8).
Cloud data warehouse: navigating the risks and challenges of adoption
. Quest.
https://blog.quest.com/cloud-data-warehouse-navigating-the-risks-and-challenges-of-adoption/
Stitch. (n.d.).
On-premises vs. cloud data warehouses: data warehousing solutions comparison
.
https://www.stitchdata.com/resources/compare-on-premises-and-cloud-data-warehouse/
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
References Cont.
Talend. (n.d.).
8 Benefits of a cloud data warehouse
.
https://www.talend.com/resources/cloud-data-warehouse-benefits/
Teradata. (n.d.).
On-premises vs cloud: Pros and cons
.
https://www.teradata.com/Insights/Data-Architecture/On-Premises-vs-Cloud
WebFX. (n.d.).
What is a cloud data warehouse and how does it work
.
https://www.webfx.com/martech/learn/cloud-data-warehouse/
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help