Upgrade to Pro — share decks privately, control downloads, hide ads and more …
Sign up for free

Pentaho + HP Vertica

Sponsored · Ship Features Fearlessly Turn features on and off without deploys. Used by thousands of Ruby developers. →
Avatar for Gleison Silva Gleison Silva
May 16, 2014
Technology
590
0

Pentaho + HP Vertica

Breve apresentação relatando um pouco dos desafios da migração de um projeto de BI para banco de dados Vertica usando Pentaho

Avatar for Gleison Silva

Gleison Silva

May 16, 2014

Other Decks in Technology

See All in Technology
PHPカンファレンス関西の招待状 / Invitation to PHP Conference Kansai
Avatar for Y-KANOH ykanoh
0
110
AI時代のPRレビューにどう向き合うか？
Avatar for KairiM kairim0
1
240
JAWS-UGグッズ職人仕事の流儀
Avatar for Hiroo Katoh kentapapa
0
100
re:Invent初参加で変わったこと、2回目にやってみたいこと（JAWS-UG彩の国埼玉 #12）
Avatar for 株式会社みずほ銀⾏ 情報数理⼯学研究所 デジタル技術開発部 mhrtech
2
230
実体験から学ぶ分析エージェントの開発と運⽤
Avatar for Recruit recruitengineers
PRO
8
2.4k
日本語に強いオープンな大規模言語モデル「LLM-jp」
Avatar for Yusuke Oda odashi
4
1.1k
ストレスなくAIと付き合いたい！こんなときどうしてる？
Avatar for Nami Kimura namiki64
3
520
DGX Spark でどこまでハッキングができるのか？
Avatar for kash1064 kash1064
3
1.3k
Optunaの最新リリースv5.0について
Avatar for Preferred Networks pfn
PRO
0
120
Conditional PED-ANOVA: Hyperparameter Importance in Hierarchical & Dynamic Search Spaces
Avatar for Preferred Networks pfn
PRO
0
130
サブエージェントと Claude Mods で作る独自 Advisor ツールの話
Avatar for Kenichi Odo kenichiodo
2
160
夫婦で子育てするための育児標準化
Avatar for コドモン開発チーム codmoninc
PRO
0
340

Featured

See All Featured
Navigating Weather and Climate Data
Avatar for Ryan Abernathey rabernat
0
560
Everyday Curiosity
Avatar for Cassini Nazir cassininazir
0
350
How to Ace a Technical Interview
Avatar for Jacob Kaplan-Moss jacobian
280
24k
Code Reviewing Like a Champion
Avatar for maltzj maltzj
529
40k
AI Search: Implications for SEO and How to Move Forward - #ShenzhenSEOConference
Avatar for Aleyda Solis aleyda
1
1.4k
"I'm Feeling Lucky" - Building Great Search Experiences for Today's Users (#IAC19)
Avatar for Dan Newman danielanewman
230
23k
Mobile First: as difficult as doing things right
Avatar for Swwweet swwweet
225
10k
Ten Tips & Tricks for a 🌱 transition
Avatar for Manu Carrasco Molina stuffmc
1
270
Easily Structure & Communicate Ideas using Wireframe
Avatar for Afnizar Nur Ghifari afnizarnur
194
17k
Templates, Plugins, & Blocks: Oh My! Creating the theme that thinks of everything
Avatar for Michelle Schulp Hunt marktimemedia
31
2.9k
Stop Working from a Prison Cell
Avatar for Chris Michel hatefulcrawdad
274
21k
How to Talk to Developers About Accessibility
Avatar for Jason CranfordTeague jct
2
580

Transcript

  1. HP Vertica + Pentaho Pentaho e Bancos de Dados Colunares

    Gleison Silva [email protected]

  2. Performance (ou... a eterna busca)

  3. None

  4. Banco de Dados C O L U N A R

  5. fonte: my.vertica.com/vertica-training Tradicionalmente...

  6. fonte: my.vertica.com/vertica-training Colunar

  7. Arquitetura

  8. Replicação

  9. Alguns métodos de compressão

  10. Limitações da Versão Community • 3 Nodes • 1 TB

    • Não inclui Vertica Management Console

  11. Migrando...

  12. Sistema Operacional Apenas Linux

  13. Liquibase (ainda não chegamos ao Pentaho...)

  14. None
  15. None
  16. None
  17. None
  18. None

  19. HP Vertica + Pentaho

  20. Evite ao máximo...

  21. Opte por...

  22. Apenas inserts + delete ao final ao invés de updates

  23. Usando Table Output

  24. Usando Bulk Loading

  25. None

  26. Resultados nas Consultas (em segundos)

  27. Perguntas?

  28. Obrigado! Gleison Silva [email protected]