Database is a logical concept. It is a warehouse used to store data through database software. The database is composed of many tables. The tables are two-dimensional, and there can be many fields in one table. The fields are lined up, and the corresponding data is written into the table line by line. The database tables are capable of expressing multi-dimensional relationships in two dimensions. Currently, the popular databases on the market are two-dimensional databases. Such as Oracle, DB2, MySQL, Sybase, MS SQL Server, etc.
The data warehouse is an upgrade of the database concept. From a logical understanding, there is no difference between a database and a data warehouse. They are all places where data is stored through database software, but in terms of data volume, data warehouses are much larger than databases. The data warehouse is mainly used for data mining and data analysis to assist leaders in making decisions.
A data warehouse is theme-oriented, integrated, stable, and time-varying. It is used to support management decision-making. A data warehouse collects all of the enterprise data and provides a centralized and standard data outlet for all enterprise departments.
A data warehouse (model) is a methodology of best practices for manual data collection, storage, understanding, organization, management, and decision-making. The model is not affected by where it is used or what technology it uses. However, the logical model and the physical model are integrated closely into the final solution. Therefore, we need the business and technical capabilities provided by data warehouses.
On March 25, 2021, Forrester, the authoritative global analysis organization, released The Forrester Wave™: Cloud Data Warehouse, Q1 2021 research report. In this report, Alibaba Cloud was named one of the Forrester Wave 2021 Q1 Cloud Data Warehouse strong performers with its existing product capabilities, product strategies, and market performance. Alibaba Cloud is the sole Chinese manufacturer selected for this evaluation after leaping from a contender to a strong performer.
According to the report, "Alibaba Cloud is as great as or even greater than some leading cloud vendors in terms of the existing product capabilities." As for market performance, cloud data warehouses represented by MaxCompute have become the most popular cloud data warehouse service in China.
Alibaba Cloud Named a Leader in the 2020 Gartner Magic Quadrant for Cloud Database Management Systems.
Database Gateway is a database connection service that supports remote access to private network databases. Through the database gateway, you can use applications or cloud services to access and manage databases on local IDC or other cloud platforms.
Alibaba Clouder - June 18, 2018
Alibaba EMR - June 22, 2021
ApsaraDB - July 20, 2021
Alibaba Clouder - September 4, 2020
Hologres - June 30, 2021
Apache Flink Community China - December 25, 2019
A real-time data warehouse for serving and analytics which is compatible with PostgreSQL.Learn More
Help media companies build a discovery service for their customers to find the most appropriate content.Learn More
TSDB is a stable, reliable, and cost-effective online high-performance time series database service.Learn More
Protect, backup, and restore your data assets on the cloud with Alibaba Cloud database services.Learn More
More Posts by Alibaba Clouder