Use Cases

This page enlists the Use Cases of the CSS project.

1. Flat File Import

1.1 Import/Select Flat File

1.2 Schema Edit

On successfully reaching this page, automatically imported the schema from the flat file is shown. However, the user is given an option to edit column names, data type and size. Following are the conventions for data type and size:

data type

The two data types appearing in the flat files from our observation are string and integer. For simplicity, the same two data types are provided at this point. As a general rule, any data type can be stored as string.

size

Following the idea to keep it simple and stupid, we have provided three predefined sizes for each data type. The Description for each size is outlined here:

Data Type	Size	Description
Integer	Default	INTEGER equivalent for the database.
	Medium	MEDIUMINT equivalent for the database.
	Big	BIGINT equivalent for the database.
String	Default	VARCHAR equivalent column with size 30 characters.
	Medium	VARCHAR equivalent column with size 50 characters.
	Big	VARCHAR equivalent column with size 150 characters.

Search

Access Control

Analytics