Projects tagged ‘java’ and ‘relational’

hsqldb is a relational database engine written in Java with a JDBC driver that supports a subset of ANSI SQL:1999. It offers a small, fast database engine. Embedded and server modes are available. It includes tools such as a minimal Web server ... [More] , in-memory query and management tools (which can be run as applets or servlets, too), a test framework, PHP compatibility, Eclipse and NetBeans IDE compatibility, and a number of demonstration examples. [Less]

H2 is an SQL database engine written in Java. It is very fast and small (about 1 MB), and supports embedded, server, and clustering modes. A browser based console application is included. Disk based and in-memory tables and databases are supported. ... [More] Some of its features are transactions isolation, multi-version concurrency (MVCC), table level locking, encrypted databases, fulltext search, and strong security. The main API is JDBC, however ODBC and others are also supported via PostgreSQL network protocol compatibility. [Less]

SchemaSpy is a Java-based tool that analyzes the metadata of a schema in a database and generates a visual representation of it in a browser-displayable format. It lets you click through the hierarchy of database tables via child and parent table ... [More] relationships. The browsing through relationships can occur though HTML links and/or though the graphical representation of the relationships. It's also designed to help resolve the obtuse errors that a database sometimes gives related to failures due to constraints. [Less]

Java Desktop SQL Database Engine with JDBC 3.0 API. SmallSQL is small, fast, embeddable, SQL 99 conformance, platform independent and 100% pure Java

SchemaCrawler is a command-line tool to output your database schema and data in a readable form. The output is designed to be diff-ed with previous versions of your database schema. SchemaCrawler is also an API that improves on the standard JDBC metadata.

easy ORM (Object Relational Mapping)We had to change the name of this project because of one of the already existing more matured project which is also called "Simple ORM"Recently there have been lots of hype about dynamic languages and frameworks ... [More] like Ruby on Rails. Many have blogged about pros and cons of RoR and such dynamic languages. The hype is so high that it made me learn (J)RoR. After some reading and some projects on RoR I learned that programmers love these languages because of its ease of use and I loved it too. Many also say that these kind of languages are "threat" to Java, after all Java is complex!! For a Java developer it is a hard thing to just start working in a whole different environment and start using whole different syntax because no-one likes learning curves. Finally I thought that isn't it possible to get this kind of ease of use and simplicity in Java, Java is a powerful language, isn't it? This is an API which is easier then usual JDBC way of retrieving and storing data, it is easier then Java persistence and and compatible with all the JDK versions. The project is created one goal, SIMPLICITY. A simple ORM model which can substantially reduce code re-writing and is built on simple java concept of inheritance, it should involve no Rocket science. This API is right now only getting tested in MySql Follow the link bellow for more detailed explanation of SORM http://sites.google.com/a/cynosuredev.com/simple-orm/Home/Documentation If you have any questions or suggestions please feel free to email me at sapanparikh18 at gmail dot com --sapan [Less]

SimpleDBM is a transactional database engine, written in Java. It has a very small footprint and can be embedded in the address space of an application. It provides a simple programming API, which can be learned very quickly. FeaturesSimpleDBM has ... [More] the following features: Transactional - SimpleDBM fully supports ACID transactions. SimpleDBM uses a STEAL/NO-FORCE buffer management strategy for transactions. Multi-threaded - SimpleDBM is multi-threaded and supports concurrent reads and writes of data. Write Ahead Log - SimpleDBM uses a write ahead log to ensure transaction recovery in the event of system crashes. Lock based concurrency - SimpleDBM uses shared, update and exclusive row locks to manage concurrency. Multiple Isolation Levels - SimpleDBM supports read-committed, repeatable-read, and serializable isolation levels. B-Tree Indexes - SimpleDBM implements B-plus Tree indexes, that fully support concurrent reads, inserts and deletes. SimpleDBM B-Trees continually re-balance themselves, and do not suffer from fragmentation. Tables - SimpleDBM supports tables, but for maximum flexibility, treats table rows as blobs of data. Table rows can have any internal structure as you like, and can span multiple disk pages. Standard table rows with multiple columns are supported via add-on modules. Latches and Locks - SimpleDBM uses latches for internal consistency, and locks for concurrency. Latches are more efficient locking mechanisms that do not suffer from deadlocks. Deadlock detection - SimpleDBM has support for deadlock detection. A background thread periodically checks the lock table for deadlocks and aborts transactions to resolve deadlocks. StatusSimpleDBM is currently in early BETA and not suitable for use in Production systems. The latest builds can be downloaded from http://code.google.com/p/simpledbm/downloads/list. NOTICEThe new SimpleDBM RSS 1.0.11 BETA release fixes several critical bugs. If you are using an older version, please upgrade to this release. [Less]