Relational Data Explorer 1.1 Publisher Review:
RDE is a tool to comfortably navigate between dbms tables along foreign key relationships defined via sql. It is a quick&easy analysis tool for a large network of tables, with the integration of csv files to reconcile with the data in the database.
(RDE) is a tool to comfortably navigate between database tables and csv/txt files connected by foreign key relationships. It is not meant as database administration tool treating tables as isolated monoliths, but as browser tool that allows the user to do all the task necessary to find information in a widespread network of structured data objects, as it is the reality of today's office work. This means especially the integration and reconciliation of everyday's csv/txt files (spreadsheets) with the data pooled in a database.
In order to do this a definition of the relationships and dialog structures is done nearly completely by using SQL. These definitions get done via RDE Designer. Currently the following database systems are supported by their own native interface:
- MySQL
- SQLite3
- PostgreSQL
- Oracle
A lot of other systems are supported via ODBC, esp. MS SQL Server.
CSV/TXT files (semicolon or tab separated) are supported by loading them dynamically into a temporary SQLite database, also enabeling joins to the main database.
So the target is to provide an easy to use and easy to configure application development platform for database investigation tasks. It is not meant to replace tailor-made, sophisticated, large scale and expensive business applications, but to do its job in those cases, where you need some sort of spreadsheet for sql-based data structures, a flexible information management tool, rapidly adaptable to new tasks and requirements, i.e. in the home, small business and back office area, for development and support people who need a more direct and unfiltered view of the data than what a complex application may offer. RDE was designed as a native Windows application in order to offer a grade of speed and comfort that an HTML-based web application can never achieve.
RDE is currently available in English, German, French and Spanish; the help file is in English only. The supported platform is MS-Windows 2000 or later.Relational Data Explorer 1.1 details and screenshot
RECOMMENDED TOOLS
Related tags:
Related downloads
Altova MapForce Professional Edition 2009
Altova MapForce Pro is a graphical data mapping tool for XML, DBs, & flat files.
Price: 499$, Rating: 6, Downloads: 1186
Altova MapForce Pro is a graphical data mapping tool for XML, DBs, & flat files.
Price: 499$, Rating: 6, Downloads: 1186
DreamCoder for MySQL Enterprise 4.0
DreamCoder for MySQL is tool for MySQL Database administration and development
Price: 125$, Rating: 10, Downloads: 1185
DreamCoder for MySQL is tool for MySQL Database administration and development
Price: 125$, Rating: 10, Downloads: 1185
Advanced Database Recovery 1.0
Database recovery suite for MS Access MDB databases and DBF databases.
Price: 349.95$, Rating: 10, Downloads: 1184
Database recovery suite for MS Access MDB databases and DBF databases.
Price: 349.95$, Rating: 10, Downloads: 1184
Export Query to Excel for SQL Server 1.02.00
Export Query for Microsoft SQL Server helps to save query results to Excel file
Price: 45$, Rating: 5, Downloads: 1183
Export Query for Microsoft SQL Server helps to save query results to Excel file
Price: 45$, Rating: 5, Downloads: 1183
KeyedAccess for Microsoft Access 4.2
Lock your MS Access app, require users to enter installation-specific UnlockCode
Price: 299.00$, Rating: 10, Downloads: 1181
Lock your MS Access app, require users to enter installation-specific UnlockCode
Price: 299.00$, Rating: 10, Downloads: 1181
EMS DB Extract for MySQL 3.0
Utility for creating database backups in a form of SQL scripts.
Price: 95.00$, Rating: 9, Downloads: 1179
Utility for creating database backups in a form of SQL scripts.
Price: 95.00$, Rating: 9, Downloads: 1179
MySQL Turbo Manager Free Edition 3.7
MySQL Turbo Manager is tool for MySQL Database administration and development
Price: 0$, Rating: 8, Downloads: 1179
MySQL Turbo Manager is tool for MySQL Database administration and development
Price: 0$, Rating: 8, Downloads: 1179
CDBF for Windows 2.99.02
View, edit and repair the DBF database files, create reports, export data, etc.
Price: 35$, Rating: 7, Downloads: 1178
View, edit and repair the DBF database files, create reports, export data, etc.
Price: 35$, Rating: 7, Downloads: 1178

