SQLToAlgebra icon

SQLToAlgebra

2 big stars
SQLToAlgebra screenshot
Name: SQLToAlgebra
Works on: windowsWindows 7 and above
Developer: Adrian Panasiuk
Version: 7.1
Last Updated: 04 Apr 2017
Release: 21 Feb 2015
Category: System > File Management
Rate this software:
284 downloads
screenshotsView Screenshots(2)
commentsComments
downloadDownload
Liked it? Tell others:
details

SQLToAlgebra Details

Works on: Windows 10 | Windows 8.1 | Windows 8 | Windows 7 | Windows 2012
SHA1 Hash: 42c5a5a210a60d9b888af1432ef3947768f34ce6
Size: 12.79 MB
File Format: zip
Rating: 2.04347826 out of 5 based on 23 user ratings
Publisher Website: External Link
Downloads: 284
License: Free
SQLToAlgebra is a free software by Adrian Panasiuk and works on Windows 10, Windows 8.1, Windows 8, Windows 7, Windows 2012.
You can download SQLToAlgebra which is 12.79 MB in size and belongs to the software category File Management.
SQLToAlgebra was released on 2015-02-21 and last updated on our database on 2017-04-04 and is currently at version 7.1.
download button
Thank you for downloading from SoftPaz! Your download should start any moment now. It would be great if you could rate and share:
Rate this software:
Share in your network:
features

SQLToAlgebra Description

SQL queries are database operations that aim to retrieve information from a table by searching for specific fields, indexes or terms.
To model this information and organize it into data sets, you can use a branch of mathematics called relational algebra and translate the SQL queries.

Enter the database schema and SQL queries

SQLToAlgebra is a Java-based utility that enables you to translate SQL queries directly into relational algebra and export the results for further use in other applications or projects. It provides you with two text fields in which you can enter your data, the first of which is the database schema. This is basically the overall layout of the database, containing the table properties and all of the available fields, as well as their type and value.
The second area enables you to add the SQL queries you want to perform on the previously entered tables. Here you can define any kind of operation involving the fields and values from your database, including SELECT, FROM, WHERE or ORDER BY. The application supports every character type, operator and comparator you might use to sort through your data.

Translate the queries to relational algebra and export the result as a spreadsheet file

As previously mentioned, relational algebra handles data sets and it can model the information stored in relational databases, as well as organize and normalize the data structure using primary keys to identify every created instance. Various operations can then be performed on the data sets, including cartesian product, union and intersection.
The main output of the translation is made into a separate application window, using plain text that can be easily copied and used in other programs. But, if you are so inclined, you can choose to export the final results as a Microsoft Excel document. SQLToAlgebra saves the file using the new XLSX extension, which can be opened using the latest versions of Excel.

Closing arguments

Even though the whole application interface is basically formed out of two text areas and two submit buttons, SQLToAlgebra's simplicity is actually a good thing to see in this case, since it allows you to do your job quickly and free of any distractions.
screenshots

SQLToAlgebra Screenshots

SQLToAlgebra screenshot 1 SQLToAlgebra screenshot 2
similarSimilar Software