Tag：data warehouse
-
Time：2020-5-15
What is a database Wikipedia defines it as: A data set that is stored together in a certain way, can be shared with multiple users, has the minimum redundancy, and is independent of the application program. In short, a database is a data warehouse for storing structured data. What are the database types The database […]
-
Time：2020-4-16
Introduction In the first two articles of this series (the coming of the era of data Intelligence: the essence and technical system requirements and the selection method of multi-dimensional analysis system), we briefly explained the understanding of data intelligence, and introduced the selection method of multi-dimensional analysis system according to the team involved in the […]
-
Time：2020-3-13
Before we start, let’s review the definition of data warehouse. Data warehouse is a topic oriented, integrated, relatively stable data set reflecting historical changes, which is used to support management decisions. This concept was first put forward by bill inmon, the father of data warehouse, in the book “building data warehouse” in 1990. In recent […]
-
Time：2020-2-27
Alibaba cloud analyticdb for PostgreSQL (hereinafter referred to as ADB PG, i.e. the original hybriddb for PostgreSQL) is a real-time data warehouse service based on the MPP architecture of PostgreSQL kernel, which can support complex ETL tasks, as well as high-performance online queries, and is closely integrated with Alibaba cloud ecosystem. Redshift of AWS is […]
-
Time：2020-2-10
Analyticdb for PostgreSQL is built on the open source database Greenplum, which is compatible with the syntax, interface and ecology of Greenplum and PostgreSQL. This chapter describes how to connect the analytical database PostgreSQL version through finebi and develop reports. Preparation Before using finebi, users need to complete the following preparations.Download and install finebi Operation […]
-
Time：2020-2-1
Relying on the database ecosystem, analyticdb for MySQL can provide users with standard solutions under analysis scenarios, especially in the case of high demand for big data and performance, the value of analyticdb for MySQL can be better reflected. Why MySQL users need to build data warehouse independently Why build a data warehouse separately instead […]
-
Time：2020-1-8
— BI EMAIL declare @CC varchar(10),@MAIL varchar(500), @str varchar(800),@year varchar(4),@month varchar(2);declare @file_name varchar(50);declare @mail_subject varchar(50);declare @htmlBody varchar(max);SELECT @year = CONVERT(VARCHAR(4),DATEPART(year,dateadd(MONTH,-1,GETDATE()))) ;SELECT @month = right(‘0’+CONVERT(VARCHAR(2),DATEPART(month,dateadd(MONTH,-1,GETDATE()))),2);SELECT @MAIL=’[email protected]’; begin set @htmlBody=N ‘< H1 style = “margin left: 30px;” >+ N'<table border=”1″ style=”border:1px solid #d5d5d5;border-collapse:collapse;border-spacing:0;margin-left:30px;margin-top:20px;”>’ +N ‘< tr style = “height: 25px;” >+N ‘< th width = 50px > package name […]
-
Time：2019-12-28
By Jose ALC é rreca Original address: viewmodels and livedata: patterns + antipatterns Translator: Theory of mind View and ViewModel Assignment responsibility Ideally, ViewModel should know nothing about the Android world. This improves testability, memory leak security, and modularity.The usual way to do this is to make sure that nothing is imported into your ViewModelandroid.*，android.arch.*Now […]
-
Time：2019-12-14
Introduction of data warehouse business in jushuitan Shanghai jushuitan Network Technology Co., Ltd. was established in 2014. At the beginning of jushuitan’s establishment, it entered the market with e-commerce SaaS ERP, and quickly gained the market leading position with its excellent products and services. With the continuous change of customer demand, now jushuitan has developed […]
-
Time：2019-12-8
Recently Alibaba shared the PPT of Alibaba data in Taiwan practice (searching original articles by itself). We still need to learn from the founder of data in Taiwan with great respect. So we carefully read it and hope to find something different. Reading these professional ppts is actually very time-consuming. You need to peel off […]
-
Time：2019-11-28
Many people asked what Alibaba’s Apsara big data platform, ladder 2, maxcompute and real-time computing really are, and what’s the difference between Alibaba’s own Hadoop platform and Alibaba’s own. Let’s talk about Hadoop first. What is Hadoop? Hadoop is an open source, highly reliable and extensible distributed big data computing framework system, which is mainly […]
-
Time：2019-11-22
On August 26, Alibaba cloud disclosed that it is investing in “super high speed” of self-developed data storage. ESSD, the core storage product, has taken the lead in adopting the latest self-developed storage network protocol, and has realized large-scale commercial use, with data transmission efficiency increased by 50%. It is understood that the protocol will […]
