MyJSQLView is an easy to use Java GUI, graphical user interface, frontend DML, data manipulation language, tool for the HSQL, MySQL, Oracle, & PostgreSQL databases. A query tool allows the building & executing of complex SQL statements. Easy data sorting & searching, import/export either in CSV, comma separated values, or DDL, data definition language. History/Utilization The MyJSQLView application is the result of a condensed version of a larger project that was needed to allow users access to an inventory database. The project from its inception has been and will continue to be a tool that allows users access to database data. An effort was made to try and make the user interface as simple as possible to understand and use. The name of the project comes from the concept of 'my java sql view'. The view being the key. The interface provides the user with a standard type of spreadsheet perspective with obvious controls to sort, search, page, view, add, edit, or delete table data. One does not need to know any SQL, structure query language, to use MyJSQLView. Even though the user interface is relatively simple, it does provide some powerful features such as a query tool, import/export of data and an advanced sort/search. The tool provides essentially no support to those that wish to manage databases. The tool is ideal for small businesses, scientific communities, or educations institutions that wish access to database data with a free open source application. The project can and will in the future provide reports and other data mining techniques in the support of business intelligence and scientific analysis. Custom data analysis modules may also be produced by contract if so desired for your specific needs.

Current Tags

You must be logged in to tag this project

No Comments yet