Tag：data warehouse
-
In depth | uncover the secrets of data warehouse tiered storage technology
Introduction:Authors: Chen Hao, Shi Yuan 1、 Background According to the “data age 2025″ report released by IDC, the annual data generated worldwide will increase from 33zb in 2018 to 175zb in 2025, with an average of about 491eb of data generated every day. With the continuous growth of data volume, data storage cost has become […]
-
Smartbi: the application of data warehouse and data mining in business field
Data warehouse and data miningApplication and significance in commercial field I: commodity sales The business sector regards data as a competitive wealth, which may be more important than any other sector. Therefore, it is necessary to evolve a large marketing database into a data mining system. Kraft food company (KGF) is one of the companies […]
-
Smartbi of smart software: some basic concepts of data mining and data warehouse
OLAP: online analytical processing OLAP was proposed by e.f.codd in 1993.OLAP is a kind of software technology, which enables analysts to observe information from all aspects quickly, consistently and interactively, so as to achieve the purpose of in-depth understanding of data. These information is directly converted from the original data, and they reflect the real […]
-
Continue to define SaaS mode cloud data warehouse + real-time analysis
Introduction:From the value of real-time analysis, scenarios and data processes, as well as users’ requirements for platform capabilities, this paper describes the product capability advantages of maxcompute, a cloud data warehouse, and the capability evolution requirements of real-time analysis scenarios. Then, with the best practice of full data process processing, modeling and analysis of real-time […]
-
Smartbi of smart software: the relationship between database, multidimensional database and data warehouse
Phase I After the enterprise informatization reaches a certain degree, there will be a demand for reports. At this time, it is directly from the business systemdatabaseQuery. Second stage Directly querying the business system database is easy to affect the business system. At this time, the data may be extracted and placed in a mirror […]
-
Smartbi: the concept and common methods of big data analysis
Big data analysisConcept of Big data analysis refers to the analysis of large-scale data. Big data can be summarized into five V’s, including volume, velocity, variety, value, and authenticity. Big data is the hottest word in the IT industry at present, and the subsequent use of data warehouse, data security, data analysis, data mining and […]
-
7 big data practical projects that data engineers must master
Introduction: 7 big data practical projects that are worth collecting and must be mastered by data engineersOriginal: lenis about SQL As a film lover, I have read countless films, and some of them are often seen over and over several times. When I was a child, my mother often scratched my ears because of this. […]
-
2021 Alibaba big data technology open class Season 1: external tools connect SaaS mode cloud data warehouse maxcompute actual battle
Introduction:Maxcompute is an analysis oriented enterprise SaaS model cloud data warehouse. It provides fast and fully managed online data warehouse services with serverless architecture, eliminates the limitations of traditional data platforms in terms of resource scalability and elasticity, minimizes user operation and maintenance investment, and helps enterprises and big data developers analyze and process massive […]
-
External tools connecting SaaS mode cloud data warehouse maxcompute practice: business Bi analysis tools
Introduction:Maxcompute is an analysis oriented enterprise SaaS model cloud data warehouse. It provides fast and fully managed online data warehouse services with serverless architecture, eliminates the limitations of traditional data platforms in terms of resource scalability and elasticity, minimizes user operation and maintenance investment, and helps enterprises and big data developers analyze and process massive […]
-
Hive of big data technology Chapter 1 basic concepts of hive
Chapter 1 hive basic concepts 1.1 what is hive 1) Hive introduction Hive: a data statistics tool open source by Facebook to solve massive structured logs. Hive is a data warehouse tool based on Hadoop. It can map structured data files into a table and provide SQL like query functions. 2) Hive essence: Transform HQL […]
-
Complex SQL query and visual report construction
Scenario introduces the data development process of analyticdb mysql.More analyticdb MySQL related toAlibaba cloud experience Lab brief introduction The goal is to enable cloud data warehouse users and developers to experience the main process of building a cloud native data warehouse based on analyticdb MySQL and DMS through simple steps. The activity will experience the […]
-
Viewing the development trend of real-time data warehouse from the core scenario of Alibaba
Author: Guobei, senior technical expert of Alibaba cloud, head of real-time digital warehouse hologres On January 7, 2022, Alibaba cloud’s real-time data warehouse hologres held its annual conference. At the conference, senior technical experts from Alibaba explained the new development trend of real-time data warehouse “online, agile and one-stop” from the core scenarios of Alibaba. […]