Welcome to the Java Programming Forums


The professional, friendly Java community. 21,500 members and growing!


The Java Programming Forums are a community of Java programmers from all around the World. Our members have a wide range of skills and they all have one thing in common: A passion to learn and code Java. We invite beginner Java programmers right through to Java professionals to post here and share your knowledge. Become a part of the community, help others, expand your knowledge of Java and enjoy talking with like minded people. Registration is quick and best of all free. We look forward to meeting you.


>> REGISTER NOW TO START POSTING


Members have full access to the forums. Advertisements are removed for registered users.

Results 1 to 2 of 2

Thread: Cross-row computing in Java application development

  1. #1
    Junior Member
    Join Date
    Jun 2013
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Question Cross-row computing in Java application development

    In Java application development, ordered or cross-row computation based on database is oftenly involved, such as the last three, the previous one of the current record, the top five, the last but one, and the ranking of a certain record.

    For instance,to find out the monthly growth rate of contract values for each sales man in 2012 in a Contract table. We need to firstly group by salesman, group by year within each group, group by month for each year and summarize, and lastly, perform the inter-row computation between the current month and its previous month.

    We often use SQL to deal with it, but SQL does not offer any direct support for the algorithm related to sequence number. The problem is easy to solve since most ResultSet classes of JDBC support row number, and a few ones which doesn’t support can reload the class by itself. As we all know that there is another solution to the poor portability, such as the rownum in Oracle.

    Do you have any better solutions?


  2. #2
    Super Moderator pbrockway2's Avatar
    Join Date
    Jan 2012
    Posts
    979
    Thanks
    7
    Thanked 206 Times in 182 Posts

    Default Re: Cross-row computing in Java application development

    Also at java.net and sqlteam.com.

Similar Threads

  1. Replies: 3
    Last Post: September 7th, 2013, 03:34 AM
  2. Replies: 0
    Last Post: July 12th, 2013, 03:52 AM
  3. Starting Android Application Development
    By MikeSki3 in forum Android Development
    Replies: 7
    Last Post: August 22nd, 2012, 10:15 PM
  4. Yagnaum : Java Application Development Company
    By yagnaum in forum The Cafe
    Replies: 0
    Last Post: October 13th, 2011, 03:56 AM
  5. cross platform architecture in Java/J2ee
    By softwarebuzz in forum Web Frameworks
    Replies: 1
    Last Post: January 9th, 2010, 02:43 PM

Tags for this Thread