Pentaho和MongoDB联合做数据分析

jieforest

Perform  the  following steps  to  download  and  install  Pentaho  on  your Windows computer:

1.  Check  to  make  sure  your  computer  meets  the  minimum  hardware requirements  to  run  Pentaho  server  components at
http://infocenter.pentaho.com/he ... ed_components.html.

2.  If  your  computer  is  64-bit  compliant,  download  Pentaho  Business Analytics  64-bit  Windows  version  to  your  computer from http://www.pentaho.com/download.

Note

You will be asked to register your contact information for a 30-day evaluation of the Pentaho Enterprise Edition. Your download will begin after registration. The downloaded filename should look like the following with [version] being the version you downloaded:

jieforest

1. pentaho-business-analytics-[version]-x64.exe

复制代码

3.  Double-click  on  the  downloaded  executable file, pentaho-business-analytics-[version]-x64.exe,  to  run the installer program, which will launch a Pentaho splash screen.

4.  When  prompted  to  choose  a  setup  type,  select Default, which  will install  the  entire  suite  of  server  and  client  components  to  a  default directory of C:\Program Files\Pentaho.

5.  You will  be  prompted  to  enter  a  single  master  password  for  the PostGreSQL solution repository and enterprise console, and publish it to the web feature. Enter your chosen password and click on Next.

Note

When  the  installation  wizard  completes,  the  BA  and  DI  servers  should  be running on the following default ports:

1) 5432: PostgreSQL server
2) 8080: BA server Tomcat web server startup port
3) 9080: DI server port

If these ports are not available during the installation, Pentaho will automatically increment the port number by one until an available port is found.

jieforest

6.  Upon  wizard  completion,  select  the  option  of  starting  the Pentaho User Console, which will launch the PUC login screen.

7.  Click on the Login as an Evaluator link, which will use the default administrator  login  with admin as  the  username  and password as  the password, and then click on the Go button to access Pentaho.

Summary

Congratulations!  You  should  have  a  working  installation  of  Pentaho,  which installs  the  BA  and  DI  servers  as  Windows  systems  services  that  will  start automatically  the  next  time  you  boot  your  computer.  Please  refer  to  the official Pentaho  Installation  Guide athttp://infocenter.pentaho.com for detailed  installation  information.  In  the  next  chapter,  we  will  explore  the MongoDB data model and establish a connection from Pentaho to the sample MongoDB database.

jieforest

MongoDB database objects

We  will begin  our  journey  of  understanding  MongoDB  database  objects  by comparing each object to its equivalent RDBMS object when applicable. There are  some  similarities  between  MongoDB  and  RDMBS  objects,  although  the object  names  are  different.  MongoDB  object  names  include  databases, collections, documents, fields, and indexes.


The  highest  level  container  in  a  MongoDB  server  instance  is  a  database. A database consists  of  one  or  more  collections.  A collection holds  a grouping of documents just as a RDBMS table holds a grouping of records.

A document is made up of one or more fields, which as you probably guessed, are similar to table fields (that is, columns). Relational databases define fields at  the  table  level  while  document-oriented  databases  define  fields  at  the document  level.  Additionally,  as  with  a  RDBMS,  MongoDB  allows  you  to create indexes on fields for better sorting and lookup performance.

jieforest

The following figure shows a basic object relationship in a MongoDB database with one collection containing two documents and a total of three fields. The mandatory  ObjectId  fields,  the  unique  keys  for  a  collection,  are  left  out intentionally to keep the illustration simple.

icecard

还有下文吗？版主，我现在也在了解如何使用mongodb做数据分析，有没有推荐的文章啊