The first assignment is simple. You need to download Redbase, build it and run simple RQL queries. You will need a linux-like environment to be able to complete the following steps. Windows/Mac users can download VirtualBox and run any linux distribution on a VM. We recommend using either Fedora or Ubuntu. Windows 10 users can also have a look at the WSL (Windows Subsystem for Linux) to compile the given code (Note that you will require a Windows Insider Build installed on your system).
Install the dependencies
sudo apt-get install flex bison g++ g++-multilib git cmake make
Clone repository
git clone https://github.com/PayasR/redbase-spatial.git
Build the project
cd redbase-spatial
mkdir build
cd build
cmake ..
make -j4
Test
./dbcreate Test
./redbase Test
DDL commands
create table data (name c20, id i);
drop table data;
DML commands
insert into data values ("abc", 1);
select * from data;
Deliverables
Write a short two page report (.PDF) on the architecture of the Redbase system, the interfaces of the five layers and the functions of the following classes:
PF_Manager,PF_FileHandle,PF_PageHandle,RM_Manager,RM_FileHandle,RM_FileScan,RM_Record,RID,IX_Manager,IX_IndexHandle,IX_IndexScan,SM_Manager,QL_Manager. You may use the Redbase Specifications, but write the description in your own words. Do not copy text verbatim. (7 points)Using RQL, create a simple table of your choice, insert 5 data entries and show outputs of 3 different SELECT statements. The SELECT queries must use the WHERE clause. Attach screenshots of the queries and the outputs after the two-page writeup. (3 points)
Due date: 17th October 2018, 12:00 pm
How to submit: The submissions will be through iLearn.
Please upload the report on iLearn > CS 236 > Assignments > Project milestone 1.