RSS Feed for databaseCategory: database

NoSQL RDBMS »

NoSQL is a fast, portable, relational database management system without arbitrary limits, (other than memory and processor speed) that runs under, and interacts with, the UNIX1 Operating System. It uses the "Operator-Stream Paradigm" described in "Unix Review", March, 1991, page 24, entitled "A 4GL Language". There are a number of "operators" that each perform a […]

MySQL WorkBench »

I have written on fabFORCE.net DBDesigner - A Handy MySQL Database Designer. However, MySQL has now a better tool, which is a successor to DBDesigner.

MySQL Workbench is a visual database design tool that is developed by MySQL. It is the successor application of the DBDesigner4 project.

MySQL Workbench is available in two editions, the Community […]

SQLite Database Management Tool »

SQLite2009 Pro Enterprise Manager is a freeware tool that enables you to manage your SQLite3 databases.
Features:

Blob/Image viewer
Built-in FTS3 Extention
Built-in LUA Programming Language
Encrypted database support
Export recordset into excel, csv, xml and html format
Import data from Ms Access / MS SQL server
Includes SQLite2009 Pro ODBC Driver
Includes Additional sqlite3 function (compress, decompress, crc32, md5, lua_exec, etc)
Transactions supported
Visual Query […]

Open Source ADO.NET Provider for SQLite Database Engine »

System.Data.SQLite is the original SQLite database engine and a complete ADO.NET 2.0/3.5 provider all rolled into a single mixed mode assembly.  It is a complete drop-in replacement for the original sqlite3.dll.
The provider was written from scratch on VS2005/2008 specifically for ADO.NET 2.0, using all the most recent changes to the ADO.NET framework.  That includes full […]

MongoDB »

MongoDB is a high-performance, open source, schema-free document-oriented database. MongoDB is written in C++ and offers the following features:

Collection oriented storage - easy storage of object-style data
Dynamic queries
Full index support, including on inner objects
Query profiling
Replication and fail-over support
Efficient storage of binary data including large objects (e.g. videos)
Auto-sharding for cloud-level scalability (currently in early alpha)

A […]

Lightweight SQL Database for Cloud and Web »

The Drizzle project is building a database optimized for Cloud and Net applications. It is being designed for massive concurrency on modern multi-cpu/core architecture. The code is originally derived from MySQL.
The project is focused on making a database that is:1) Reliable2) Fast and scalable on modern architecture3) Simply design for ease of installation and management

Free EBook: Expert Oracle JDBC Programming »

From Apress at http://www.apress.com/resource/bookfile/1909

SELECT COUNT in Database »

This is a common problem often overlooked by Java programmer.
Create the following table in your database

1: create table test_table
2: (
3: field_1 varchar2(10) not null,
4: field_2 varchar2(10)
5: );
6: 
7: 
8: insert […]

Kexi: Alternative for Microsoft Access »

Kexi is a Free/Libre and Open-Source integrated data management application, a long awaited Open Source competitor for products like Microsoft Access. Kexi can be used for creating database schemas, inserting data, performing queries, and processing data. Forms can be created to provide a custom interface to your data. All database objects - tables, queries and […]

Java DB in JDK 6 »

Java DB is Sun’s supported distribution of the open source Apache Derby 100% Java technology database. It is fully transactional, secure, easy-to-use, standards-based — SQL, JDBC API, and Java EE — yet small, only 2MB. The Apache Derby project has a strong and growing community that includes developers from large companies such as Sun Microsystems […]

Open Source Distributed Database System »

Mnesia is a distributed Database Management System, appropriate for telecommunications applications and other Erlang applications which require continuous operation and soft real-time properties. It is one section of the Open Telecom Platform (OTP), which is a control system platform for building telecommunications applications.
From the documentation,
The management of data in telecommunications system has many aspects whereof […]

Library of Free Data Models »

In every application, no matter Java, .NET or PHP, most probably you need to interact with databases. For every domain your application is used for, the database design is definitely different, though basic database design principles are still the same. Every domain requires different database models and unless you are the domain expert, most of […]

Power Architect: Data Modeling and Profiling Tool »

Just after I wrote about Mogwai ER Designer NG, someone told me about Power Architect.

As quoted, Power Architect is a user-friendly data modeling tool created by data warehouse designers, and has many unique features geared specifically for the data warehouse architect. It allows users to reverse-engineer existing databases, perform data profiling on source databases, […]

Using SQuirreL SQL together with an ER Designer »

Most of us should be familiar with SQuirreL SQL. It is a graphical Java program that will allow you to view the structure of a JDBC compliant database, browse the data in tables, issue SQL commands etc.
 
I used SQuirreL SQL in almost all my projects. It supports a wide range of databases.

Axion Java RDBMS.
Daffodil […]

Open Source Database Benchmark »

This is the database benchmark that I stumbled upon when I was searching for similiar information.
PolePosition is a benchmark test suite to compare database engines and object-relational mapping technology. It has done the benchmarking for the followings

db4o - the open source object database for Java and .NET
Hibernate - relational persistence for idiomatic Java
MySQL - […]