A Data Science Central Community
Program development for data process often involves cross-database relational operations. The following example will illustrate Java’s method of handling these operations. sales table is in db2 database, employee table is in mysql database. The task is to join sales with employee through sellerid of sales table and eid of employee table, and filter out the data insales and employeethat…Continue
Added by Jessica May on September 9, 2014 at 1:03am — No Comments
The computing power of SQL for mass structured data is complete, that is to say, it is impossible to find anything that SQL cannot compute. But its support layer is too low, which can lead to over-elaborate operation in practical application.…Continue
Added by Jessica May on July 27, 2014 at 9:30pm — No Comments
OLAP is an important constituent part of BI(business intelligence).
Understood literally, OLAP is online analytical processing, that is, users conduct analytical operation on real-time business data.
But, currently the concept of OLAP is seriously narrowed, and only it refers to operations such as conducting drilling,…Continue
Added by Jessica May on May 27, 2014 at 8:00pm — No Comments