Search Results for "keys"

JoinFinder is a useful tool that helps you to find join between two tables by foreign keys defined into tables or by a brute-force method. It is a Java8 project and it uses jna library for autocompletition feature. At the moment JoinFinder is in Italian and supports only MS SQL server, but I hope to add soon other DB support and English translation.

...Currently EnterAccess queries are limited to a single table. All DML and DDL queries are limited by the capabilities of Jackcess, which is good at reading a database and weak on creating a view, creating foreign keys, or modifying a schema.

Now stored at https://github.com/gregorydgraham/DBvolution Available from Maven Central: nz.co.gregs.dbvolution Makes relational data easy and fast to use with semantic annotations and encapsulated datatypes. Simple declaration of a DB table: @DBTableName("mytable") public class MyTable extends DBRow { @DBColumn("numeric_code") @DBForeignKey(Code.class) private DBNumber numericCode = new DBNumber(); @DBColumn("uid_mytable") @DBPrimaryKey @DBAutoIncrement private...

...DataRoller is a small program that will insert rows into your database based on a file describing your tables and columns. Script files describe how each table relates to other tables, how DataRoller should geneate foreign keys, and how each column should look. DataRoller executes your script file, generating insert statements and filling your database with data.

...Program can be run from UI or from command line. There's one more advanced feature which allows merging of data from CSV file to Database. It is only available from command line. (It will take foreign keys and unique keys into consideration and then try to insert data with minimum change as possible). Note: 1) If tables do not exist, this program will not automatically create table while loading data from CSV.

miMas is an intuitive GUI tool for SQL query development and data browsing. It provides a common set of features across all databases and can be installed on any Operating System which has a Java Runtime available. The tool uses JDBC drivers for connecting to a database. For most popular databases (Oracle, DB2, MySQL, MS SQL Server, Sybase, Cloudscape, PostgreSQL and Firebird), the JDBC driver is already included. For connecting to databases other than these, please refer to the tool's...

The goal of this project is to create a tool that can partially copy data from a table and all related data(imported and exported keys). This tool aims to help debuging and testing systems with a large database. The tool uses the netbeans plataform.

Web-based Squirrel SQL client. it allow you to view database structure, import/export and manage your databases, including create database, table, store procedure, view,trigger and user. it support oracle, db2, mysql, MS SQL server, FireBird,Postgres

Tabular data generator software written in Java. Column data types, ranges and sizes can be configured via XML file. Supports primary keys and foreign keys. JDBC and CSV outputs supported.

Standalone Java application to view any hierarchical data structures in a JTree. Keys and names to show in the tree are solely driven by SQL statements. The same applies to the additional node's data, which is shown in a separate table panel aside.

This tool enables you to produce a LaTeX (standard, no extension required) report for database objects (tables, views, indexes, functions, primary/foreign keys, columns, types, keywords, system functions) thanks to the JDBC Api.

EditDB is a database front-end wriiten in Java (JDBC used) for editing content of databases. Various details about database structure can be viewed. In edit mode, special help is provided to the user when s/he edits foreign or private keys.

db2db is a database client for transferring database objects (tables, their data, primary keys, foreign keys, indexes) among heterogeneous RDBMS. db2db is written in java and uses jdbc.

[RETIRED] Tornado/DB is an object-relational mapping engine for Java. Features include object caching, multi-table inheritance, compound keys, relationships, XML config., JSP tags, small footprint.

Tiger is an object-oriented database, written in java. It uses the concept of primary keys, aggregates, relations and indexes for finding java objects in persistent storage. Tiger have support for transactions and remote access.

Java Object DBMS stores serialized java objects in a file with keys. The keys are automatically maintained. Heavy use of introspection minimizes programming burden. Future plans include transactions, network (RMI, SOAP) access.

JDBC-based Object-Relational mapping system. It maps Java objects to RDBMS. It generates SQL for retrieving, saving, and deleting objects. It does XML<=>RDBMS. It autogenerates keys, maintains dependent objects and relations.