Advanced Database System_I

Project I of Advanced Database System (CS-422) of EPFL

Implementation of the following data layouts:

1. Row (NSM).
2. Columnar (DSM).
3. Partition Across Data Layout (PAX).

Implementation of the following execution models:

1. Volcano-style, tuple-at-a-time engine.
2. Column-at-a-time engine.
3. Volcano-style, vector-at-a-time engine.

Usage

Prerequisites

1. Install apache maven.
2. Install Java 8.
3. Export maven to your environment:

export PATH=$PATH:/path/to/maven/bin

4. Clone this repository.
5. Go inside to directory:

cd advanced_database_system_1

Testing All Implementations

mvn test

Example of Testing Specific Implementation

mvn -Dtest=ColumnarVectorTest test

Advanced Testing using Big Datasets

1. Download the big datasets for lineitem and order here.
2. Unzip and put them inside input dir.
3. Run the test in ch.epfl.dias.ops.bench: ScenarioOne.java, ScenarioTwo.java, ScenarioThree.java, ScenarioFour.java. For example:

mvn -Dtest=ScenarioOne test

License

MIT.