A user guide of how to use the tool:
Table of Content
- Introdution
- Login
- Importing Data
- The Query Browser
- Wrangling Data
- Inferring Functional Dependencies
- Normalizing Data
- SQL Export
- References
The following is the manual:
- Schematic Fission lets you turn CSV data into realtional data, which you can choose to keep in database or export to your own database.
- You can use schematic fission on our servers, or on your own deploy using Maven
- To login, type your login credentials in the main screen.
- If you are a new user, type in a new username and password in the boxes. If the user exists, this will not be allowed.
- Upon registration, you will be given an empty database on the server.
- Use the import function to bring CSV data into the database. Do not use this function if your data is still messy - the "wrangle data" function is made just for this.
- Once you have selected your file, click "import" to bring all the data into the database.
- Your imported data should appear on the list on the left.
- Settle bug to note - uploading a messy CSV file here will quitely fail - use the Wrangle Spreadsheet Data feature to do this.
The main window of Schematic Fission is a query browser - letting you explore your database.
- In the left part of thw window you will see all your tables.
- Click on a table to show its content on the right, in the query window.
- Under where your data is displayed you are able to type a query. Click run to run the query and see the result in the query browser.
In order to wrangle data, click on the "Wrangle Spreadsheet Data" option in the menu, which will let you upload a messy CSV file.
For the use of Wrangler - refer to Data Wrangler.