Store Table in Java Object - Datastructure

Question

I have to store data structured as a table in JAVA. Besides the columnnames and data i store different metadata like the data type of the column. At the moment I'm using this object.

public class Data {

    private final Map<String, List<Object>> values;
    private final Map<String, Integer> columnSpec;
    private int rowSize;

    //Getter and Setter

As you can see I save the data columnoriented. Sometimes I have to itterate over data in specific column. Sometimes over specific rows. I'm looking for a structre where i can easily switch from column to row layout (or vice versa).

Which object do you suggest? How can i reach the maximum performance (less iteration to change layout)? The table can have over 1 Million lines in some cases.

rdonuk · Accepted Answer · 2016-04-19 09:42:53Z

1

If using a library is not a problem, you can use Guava table structures. Some of the avaliable structures are: TreeBasedTable, HashBasedTable, ImmutableTable and ArrayTable. You can pick the most suitable one.

answered Apr 19, 2016 at 9:42

rdonuk

3,94624 silver badges42 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Daniel Over a year ago

Thanks guava was exactly what i was looking for. This reduced my code enormously.

Collectives™ on Stack Overflow

Store Table in Java Object - Datastructure

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related