By admin on Mar 14, 2010 in database, open source | 0 Comments
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 […]
By admin on Nov 30, 2009 in database | 0 Comments
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 […]
By admin on Aug 31, 2009 in database, open source | 0 Comments
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 […]
By admin on Aug 31, 2009 in .NET, database, open source | 0 Comments
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 […]
By admin on Jul 27, 2009 in database, open source | 0 Comments
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 […]
By admin on Jul 22, 2009 in database, open source | 0 Comments
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
By admin on Feb 12, 2009 in Oracle, database, free ebook, general | 0 Comments
From Apress at http://www.apress.com/resource/bookfile/1909
By admin on Oct 21, 2008 in database | 0 Comments
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 […]
By admin on Oct 6, 2008 in database, open source | 0 Comments
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 […]
By admin on Sep 30, 2008 in Java, database | 0 Comments
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 […]
By admin on Sep 24, 2008 in database, open source | 0 Comments
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 […]
By admin on Aug 5, 2008 in database | 3 Comments
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 […]
By admin on Apr 19, 2008 in Java, database, open source | 0 Comments
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, […]
By admin on Apr 19, 2008 in Java, database, open source | 0 Comments
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 […]
By admin on Nov 18, 2007 in database, open source | 1 Comment
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 - […]