Return-Path: X-Original-To: archive-asf-public-internal@cust-asf2.ponee.io Delivered-To: archive-asf-public-internal@cust-asf2.ponee.io Received: from cust-asf.ponee.io (cust-asf.ponee.io [163.172.22.183]) by cust-asf2.ponee.io (Postfix) with ESMTP id CD02E200BD4 for ; Fri, 16 Dec 2016 08:17:12 +0100 (CET) Received: by cust-asf.ponee.io (Postfix) id CB838160B24; Fri, 16 Dec 2016 07:17:12 +0000 (UTC) Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by cust-asf.ponee.io (Postfix) with SMTP id EEDE1160AF6 for ; Fri, 16 Dec 2016 08:17:11 +0100 (CET) Received: (qmail 46334 invoked by uid 500); 16 Dec 2016 07:17:06 -0000 Mailing-List: contact user-help@kylin.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@kylin.apache.org Delivered-To: mailing list user@kylin.apache.org Received: (qmail 46325 invoked by uid 99); 16 Dec 2016 07:17:06 -0000 Received: from mail-relay.apache.org (HELO mail-relay.apache.org) (140.211.11.15) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 16 Dec 2016 07:17:06 +0000 Received: from mail-yw0-f176.google.com (mail-yw0-f176.google.com [209.85.161.176]) by mail-relay.apache.org (ASF Mail Server at mail-relay.apache.org) with ESMTPSA id C5BE61A028B for ; Fri, 16 Dec 2016 07:17:05 +0000 (UTC) Received: by mail-yw0-f176.google.com with SMTP id r204so27066948ywb.0 for ; Thu, 15 Dec 2016 23:17:05 -0800 (PST) X-Gm-Message-State: AKaTC03BaN0DCuEiBqQs1Xl7TXLD86qBSEOWZemtJEhfCvtZXVSt5WAVCnEEmGLWY+Eu/SyjvOiBABodvzzlNw== X-Received: by 10.129.43.133 with SMTP id r127mr1103820ywr.213.1481872624942; Thu, 15 Dec 2016 23:17:04 -0800 (PST) MIME-Version: 1.0 Received: by 10.129.179.196 with HTTP; Thu, 15 Dec 2016 23:16:24 -0800 (PST) In-Reply-To: References: From: ShaoFeng Shi Date: Fri, 16 Dec 2016 15:16:24 +0800 X-Gmail-Original-Message-ID: Message-ID: Subject: Re: Kylin in a multitenant environment To: user Content-Type: multipart/alternative; boundary=001a1141e46269895e0543c15bf0 archived-at: Fri, 16 Dec 2016 07:17:13 -0000 --001a1141e46269895e0543c15bf0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Hi Victor, Are these 40.000 customers sharing the same data/cube model? If the model is the same, creating 1 cube will be good for maintenance; creating thousands of cube will be horrible. The open source Kylin's security control is only at Cube level; To get finer control, you need customize or try its enterprise version called KAP. 2016-12-16 14:12 GMT+08:00 Victor Sauermann : > Hi there! > > I'm working as an architect for a german company and we are evaluating th= e > kylin system for extreme scale OLAP scenarios. > Currently we got our hands around the system that we basically understand > the usage of it. But now it is going further into a multitenant use. > > Let me describe the core issue first: > > We are an individual software vendor and our software currently resides o= n > the PCs of our customers. We are planning to migrate these software > products into our own already existing data center. Our portfolio with > nearly 300 applications address various business domains. One main asset = is > the ability to drive analytical processes over the data from all of these > applications - and this for example based on OLAP Analytics. > Right now we have more than 40.000 installation sites with a relational > database store. If we migrate this data to our data center we are > definitely facing Big Data solutions. Kylin apparently fits our need. But= - > and this is mission critical - each customer needs a dedicated access to > these analytical systems and may use BI Tools like Tableau and such. We > will provide the access to the Kylin system and cope with the needed > authentication. If now the complete data relevant for BI analyitcs reside > in the data cluster for kylin the data shall only be used by its dedicate= d > responsible customer - each customer must not see in that way data from > other customers. > > In facts: Minmal 40.000 customers with in future 4000 parallel accesses. > > Our first investigation provides the information, that we have to provide > a dedicated cube for each tenant. Is that correct? This means we need to > define for each interested customer a cube based on the residing data. Wi= ll > this cube definition be enough to seperate each tenant from other's data? > Will the system provide enough power to yield that many cube definitions? > > Thanks upfront > Victor Sauermann > > --=20 Best regards, Shaofeng Shi =E5=8F=B2=E5=B0=91=E9=94=8B --001a1141e46269895e0543c15bf0 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Hi Victor,=C2=A0

Are these 40.000 custo= mers sharing the same data/cube model? If the model is the same, creating 1= cube will be good for maintenance; creating thousands of cube will be horr= ible.=C2=A0

The open source Kylin's security c= ontrol is only at Cube level; To get finer control, you need customize or t= ry its enterprise version called KAP.

2016-12-16 14:12 GMT+08:00 Victor Sauermann= <victor.sauermann@gmail.com>:
Hi there!

I'm working as an architect for a german company and we are evaluat= ing the kylin system for extreme scale OLAP scenarios.
Currently we got our hands aro= und the system that we basically understand the usage of it. But now it is = going further into a multitenant use.

Let me describe the core issue first:

We are an individual software vendor = and our software currently resides on the PCs of our customers. We are plan= ning to migrate these software products into our own already existing data = center. Our portfolio with nearly 300 applications address various business= domains. One main asset is the ability to drive analytical processes over = the data from all of these applications - and this for example based on OLA= P Analytics.
Right now we have more than 40.000 installation sites with a relational = database store. If we migrate this data to our data center we are definitel= y facing Big Data solutions. Kylin apparently fits our need. But - and this= is mission critical - each customer needs a dedicated access to these anal= ytical systems and may use BI Tools like Tableau and such. We will provide = the access to the Kylin system and cope with the needed authentication. If = now the complete data relevant for BI analyitcs reside in the data cluster = for kylin the data shall only be used by its dedicated responsible customer= - each customer must not see in that way data from other customers.

In facts: Minmal 40.000 c= ustomers with in future 4000 parallel accesses.

Our first investigation provides the informati= on, that we have to provide a dedicated cube for each tenant. Is that corre= ct? This means we need to define for each interested customer a cube based = on the residing data. Will this cube definition be enough to seperate each = tenant from other's data? Will the system provide enough power to yield= that many cube definitions?

Thanks upfront
Victor Sauermann




--
Best regards,

Shaofeng Shi =E5=8F=B2= =E5=B0=91=E9=94=8B

--001a1141e46269895e0543c15bf0--