Showing posts from August, 2010

Introduction to Free / Open Source Databases (Part - 4)

EyeDB is a ODMG 3 specification based on object-oriented database management system for C + + and Java provides a programming interface, it is very powerful and mature, stable and secure, in fact, it originated in 1992, Genome View project it was rewritten in 1994, is widely used in bio-informatics project.

txtSQL is an object-oriented database management system, flat file, it uses PHP prepared to support the operation of ordinary text files, although a text database, but also support a subset of SQL, and the efficiency is very high, txtSQL use file systematic approach and principles of MySQL database tables and similar, it has a management interface similar to phpMyAdmin

db4o is an object-oriented open-source database that allows Java and. NET developers to store and retrieve a single line of code any application objects, without pre-defined or maintain a separate, rigid data model because models are based by db4o be automatically created and updated. db4o success of the secret is beca…

Introduction to Free / Open Source Databases (Part - 3)

CloudStore (formerly known as Kosmos File System) is an open source high performance distributed file system, it is written in C + +,, CloudStore Ke Yi and Yi Ji Hypertable Hadoop integration are then allowed applications are built on those systems, And the bottom Shuojucunchu seamlessly use CloudStore. CloudStore support Linux and Solaris, is mainly used to store data on Web logs and Web crawling.

OpenQM is the only one with both commercial and free open source support multi-value database, released on GPL agreement, multi-value database NoSQL played a role in promoting the sport, it is also because of its speed, small size, cheaper than the relational database quickly recognized. Commercial version supports Windows, Linux (RedHat, Fedora, Debian, Ubuntu), FreeBSD, Mac OS X and Windows Mobile, its list price is less than the value of products more than other 1 / 5, commercial version also includes a GUI management interface and terminal simulator, open source version includes only the…

Introduction to Free / Open Source Databases (Part - 2)

HBase is a distributed, stored column-oriented database engine, also called Hadoop database, because it is Hadoop subprojects, HBase goal is to host billions of lines, millions of rows of large tables, it provides a REST style Web server gateway , support XML, Protobuf and binary data encoding options.

Keyspace is a venture company called Scalien development of highly reliable key / value storage system, Keyspace emphasize technology is highly reliable, has the following characteristics:-
Key / Value Store: a key / value data storage system supports only some basic operations such as: SET (key, value) and GET (key), etc.Distributed: multiple machines (nodes) also store data and status, exchange messages with each other to maintain data consistency, can be regarded as a complete storage system. For more reliable, Keyspace recommended an odd number of nodes, such as: 3,5,7, etc.Data consistency: the data on all machines are updated simultaneously, and not worry about get inconsistent resu…

Introduction to Free / Open Source Databases (Part - 1)

MongoDB is an open source, high performance, scalable, no model for the document (and JSON similar data model) of the database, it is the most popular programming languages, the driver, such as PHP, Python, Perl, Ruby , JavaScript, C + +, and support for full-text indexing, automatic film, extended across LAN or WAN, using Key / Value stored data. MongoDB server can run on Linux, Windows or OS X platform, to support 32-bit and 64-bit applications.
Hypertable is a high-performance distributed data storage system, designed to provide the best application performance, scalability and reliability, it is built on top of Google's BigTable, the main application for large data sets, the objective is to be the world's best high-performance database platform for large-scale concurrency.

Apache CouchDB is a document-oriented database, you can use the JavaScript method by MapReduce queries and indexing, which provides a RESTful JSON API, so you can in any environment through HTTP access, C…

Create List of Values (LOVs) in Oracle Apex 4.0

This artical shows how to create List of Values (LOVs) in Oracle Apex 4.0. It is important that the account you log into in APEX has at least Developer level rights, or Workspace Admin rights. Check out the given below steps to create LOV in apex.

Here is my 1st Tabular Form. In this form i want to create a LOV on Country colum so it can easly editable. To do that click 'Edit Page 1' option on the bottom bar.

On the right hand side under 'Shared Components' you will see a entry i.e. 'List of Values'. Right click on 'List of Values' entry and Click on Create option.

This will bring Create List of Values screen. So I want to create List of Values from Scratch, check this option and click on next button.

Give it to a name, this will be the name that any part of the application will able to find it as. I am giving it Country as name and this will going to be a Dynamic List because when table will be updated, List updated accordingly.

Here in the box enter a SQL …

Create Tabular Form in Oracle Apex 4.0

This artical shows how to create a Tabular Form in Oracle Apex 4.0. It is important that the account you log into in APEX has at least Developer level rights, or Workspace Admin rights. Check out the given below steps to create taular form in apex.

Login to Oracle Apex Workspace.

Click on Application Builder.

After Clicking Create icon select Application Type which is 'Database'.

Select Form Scratch option.

Enter application name, in this case i typed 'Tabular Form'. I used default Application unique ID which is 107. i am creating Tabular Form thorugh 'Form Scratch' and my Schema is Dev.

Select Blank option in Page Selection Type and click on Add Page icon.
After page added click on create icon.

I need One Level of Tabs in my Form thats way i select it.

Select No to copy shared components from another application.

In the Authentication Schema select Application Express.

Theme selection.

Verify the selection and then click on create icon. 

Application created in the name of …