Column store index

Here you find the details for the internship named "Column store index" in the company AG Insurance.

Name: Column store index
Company: AG Insurance

Column store index is a way of storing your data column based instead of row based. This can be advantageous for big tables to optimize the required storage and the performance of select queries.

The goal of the study is to evaluate the different uses of the column store indexes. What are the advantages of using column store indexes, and in which case should we use them by
Taking an example of a big database
Evaluate how to apply the column store indexes on this data
Evaluate the performance of the different operations to be done on the data
Evaluate the approach to insert & update the data. Periodicity, impact, unavailability

Target profiles:
    In industries:
    • IT
    • Bank & verzekeringen
    Required special knowledge:

    Duration: 2 weeks
    Paid: No
    Net wage: -
    Foreign: No
    Contact: Laura Antonacci (People Development Facilitator IT)