Subscribe to DSC Newsletter

Jessica May's Blog Posts Tagged 'table' (4)

Data alignment join in Java for easier text analytics

The join statements of the database can be used conveniently to perform the operation of alignment join. But sometimes the data is stored in the text files, and to compute it in Java alone we need to write a large number of loop statements. This makes the code cumbersome. Using esProc to help with programming in Java can solve the problem easily and quickly. Let’s look at how this works…

Continue

Added by Jessica May on September 28, 2014 at 8:00am — No Comments

Code Examples of cross database relational computing in Java

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

Some Cases illustrating drawbacks of SQL in data computing and analytics

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

The difference Between esProc’s Sequence Table Object and R’s Data Frame on data processing

Both esProc and R language are typical data processing and analysis languages with two-dimension…

Continue

Added by Jessica May on July 21, 2014 at 1:36am — No Comments

On Data Science Central

© 2019   AnalyticBridge.com is a subsidiary and dedicated channel of Data Science Central LLC   Powered by

Badges  |  Report an Issue  |  Privacy Policy  |  Terms of Service