Subscribe to DSC Newsletter

Lynn Guo
  • Beijing
  • China, mainland
Share on Facebook
Share
 

Lynn Guo's Page

Profile Information

Short Bio:
Data analysis
Field of Expertise:
Business Analytics, Data Mining
Years of Experience in Analytical Role:
5
Professional Status:
Manager
Interests:
New Venture, Recruiting

Lynn Guo's Blog

esProc Helps Process Structured Text in Java - Import data into the database

Posted on December 22, 2014 at 7:04pm 0 Comments

While importing the structured text files into the database using Java alone, we need to combine the SQL statements together manually, and to deal with various troublesome situations as well, like if the data in a table has been existed, whether we should update it or insert data into it, if some fields are included in the file, and if the fields in the file are consistent with those in the table.

 

As esProc participates in Java programming, these problems can be solved…

Continue

esProc Helps Process Structured Texts in Java – Handle Big Files in Groups

Posted on December 15, 2014 at 6:24pm 0 Comments

There is a type of text files that they are too big to be entirely loaded into the memory, yet as the data have been sorted by a certain column and if they are imported in groups according to this column, they can be all put into the memory for computing. These text files include the call detail record of a telecom company, statistics of visitors on a website, information of members of a shopping mall, etc.

 

A great deal of complicated code, which is difficult to maintain, is…

Continue

esProc Helps Process Structured Texts in Java –Expression Computing

Posted on December 10, 2014 at 6:30pm 0 Comments

As Java doesn’t directly support dynamically parsing expressions in the text files, the computation can only be realized by splitting strings manually and then writing a recursive program. The whole process requires writing a great amount of code, is complicated and the code is difficult to maintain. With the assistance of esProc, we can develop program for the computation in Java without writing code manually. Let’s look at how esProc works through an example.

 

Here is a text…

Continue

esProc Simplifies SQL-style Computations – In-group Computation

Posted on December 3, 2014 at 6:30pm 0 Comments

During developing the database applications, we often need to perform computations on the grouped data in each group. For example, list the names of the students who have published papers in each of the past three years; make statistics of the employees who have taken part in all previous training; select the top three days when each client gets the highest scores in a golf game; and the like. To perform these computations, SQL needs multi-layered nests, which will…

Continue

Comment Wall

You need to be a member of AnalyticBridge to add comments!

Join AnalyticBridge

  • No comments yet!
 
 
 

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