You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@accumulo.apache.org by Noah Randolph <nr...@kountable.com> on 2019/10/22 01:51:37 UTC
Business Analytics and Visualization Tools
Hi,
We have a need for business analysts to be able to look at and analyze our
tables. For this, we are implementing Presto on top of Accumulo
<https://prestodb.github.io/docs/current/connector/accumulo.html>, which
requires us to redesign our tables to be in at least second normal form (we
were previously storing variable information in the family and qualifier
strings, similar to Bigtable's Schema Design for Time Series Data
<https://cloud.google.com/bigtable/docs/schema-design-time-series>). Also,
our security requirements are such that we can't just 'extract, transform,
load' our single-table design to a normalized database.
Has anyone implemented decent analytic, visualization, or other front end
tools with Accumulo without having normalized tables?
Also, does anyone know of any tools that can connect to Accumulo and allow
us to embed live tables in a website without being master Javascript
programmers? We are a Python shop, mostly.
Thanks!
Noah
Re: Business Analytics and Visualization Tools
Posted by Sam Chance <sg...@gmail.com>.
www.cambridgesemantics.com
On Mon, Oct 21, 2019, 21:52 Noah Randolph <nr...@kountable.com> wrote:
> Hi,
>
> We have a need for business analysts to be able to look at and analyze our
> tables. For this, we are implementing Presto on top of Accumulo
> <https://prestodb.github.io/docs/current/connector/accumulo.html>, which
> requires us to redesign our tables to be in at least second normal form (we
> were previously storing variable information in the family and qualifier
> strings, similar to Bigtable's Schema Design for Time Series Data
> <https://cloud.google.com/bigtable/docs/schema-design-time-series>).
> Also, our security requirements are such that we can't just 'extract,
> transform, load' our single-table design to a normalized database.
>
> Has anyone implemented decent analytic, visualization, or other front end
> tools with Accumulo without having normalized tables?
>
> Also, does anyone know of any tools that can connect to Accumulo and allow
> us to embed live tables in a website without being master Javascript
> programmers? We are a Python shop, mostly.
>
> Thanks!
> Noah
>
Re: Business Analytics and Visualization Tools
Posted by Noah Randolph <nr...@kountable.com>.
Dave,
Thanks. That looks pretty good. I think I may be able to use it for
internal purposes.
Noah Randolph
415-413-6374
On Tue, Oct 22, 2019 at 4:35 AM Dave Boyd <db...@incadencecorp.com> wrote:
> Noah:
>
> Take a look at Apache Zeppelin Notebook. We are using it with
> Accumulo and Spark
> successfully.
> On 10/21/2019 9:51 PM, Noah Randolph wrote:
>
> Hi,
>
> We have a need for business analysts to be able to look at and analyze our
> tables. For this, we are implementing Presto on top of Accumulo
> <https://prestodb.github.io/docs/current/connector/accumulo.html>, which
> requires us to redesign our tables to be in at least second normal form (we
> were previously storing variable information in the family and qualifier
> strings, similar to Bigtable's Schema Design for Time Series Data
> <https://cloud.google.com/bigtable/docs/schema-design-time-series>).
> Also, our security requirements are such that we can't just 'extract,
> transform, load' our single-table design to a normalized database.
>
> Has anyone implemented decent analytic, visualization, or other front end
> tools with Accumulo without having normalized tables?
>
> Also, does anyone know of any tools that can connect to Accumulo and allow
> us to embed live tables in a website without being master Javascript
> programmers? We are a Python shop, mostly.
>
> Thanks!
> Noah
>
> --
> ========= mailto:dboyd@incadencecorp.com <db...@incadencecorp.com> ============
> David W. Boyd
> VP, Data Solutions
> 10432 Balls Ford, Suite 240
> Manassas, VA 20109
> office: +1-703-552-2862
> cell: +1-703-402-7908
> ============== http://www.incadencecorp.com/ ============
> ISO/IEC JTC1 SC42/WG2, editor ISO/IEC 20546, ISO/IEC 20547-1
> Chair ANSI/INCITS TG Big Data
> Co-chair NIST Big Data Public Working Group Reference Architecture
> First Robotic Mentor - FRC, FTC - www.iliterobotics.org
> Board Member- USSTEM Foundation - www.usstem.org
>
> The information contained in this message may be privileged
> and/or confidential and protected from disclosure.
> If the reader of this message is not the intended recipient
> or an employee or agent responsible for delivering this message
> to the intended recipient, you are hereby notified that any
> dissemination, distribution or copying of this communication
> is strictly prohibited. If you have received this communication
> in error, please notify the sender immediately by replying to
> this message and deleting the material from any computer.
>
>
Re: Business Analytics and Visualization Tools
Posted by Dave Boyd <db...@incadencecorp.com>.
Noah:
Take a look at Apache Zeppelin Notebook. We are using it with Accumulo and Spark
successfully.
On 10/21/2019 9:51 PM, Noah Randolph wrote:
Hi,
We have a need for business analysts to be able to look at and analyze our tables. For this, we are implementing Presto on top of Accumulo<https://prestodb.github.io/docs/current/connector/accumulo.html>, which requires us to redesign our tables to be in at least second normal form (we were previously storing variable information in the family and qualifier strings, similar to Bigtable's Schema Design for Time Series Data<https://cloud.google.com/bigtable/docs/schema-design-time-series>). Also, our security requirements are such that we can't just 'extract, transform, load' our single-table design to a normalized database.
Has anyone implemented decent analytic, visualization, or other front end tools with Accumulo without having normalized tables?
Also, does anyone know of any tools that can connect to Accumulo and allow us to embed live tables in a website without being master Javascript programmers? We are a Python shop, mostly.
Thanks!
Noah
--
========= mailto:dboyd@incadencecorp.com ============
David W. Boyd
VP, Data Solutions
10432 Balls Ford, Suite 240
Manassas, VA 20109
office: +1-703-552-2862
cell: +1-703-402-7908
============== http://www.incadencecorp.com/ ============
ISO/IEC JTC1 SC42/WG2, editor ISO/IEC 20546, ISO/IEC 20547-1
Chair ANSI/INCITS TG Big Data
Co-chair NIST Big Data Public Working Group Reference Architecture
First Robotic Mentor - FRC, FTC - www.iliterobotics.org<http://www.iliterobotics.org>
Board Member- USSTEM Foundation - www.usstem.org<http://www.usstem.org>
The information contained in this message may be privileged
and/or confidential and protected from disclosure.
If the reader of this message is not the intended recipient
or an employee or agent responsible for delivering this message
to the intended recipient, you are hereby notified that any
dissemination, distribution or copying of this communication
is strictly prohibited. If you have received this communication
in error, please notify the sender immediately by replying to
this message and deleting the material from any computer.