A good Information System must contain a perfect model and a proper database design. In database designing, building the data layer is the first and foremost thing. This indeed,the critical step in planning a new system to get it right requires a lot of attention and planning. A database is a model of […]
Choosing Primary Keys
Posted in Database Development by admin - Sep 14 2010
Java Database-Derbi
Posted in Database Development by admin - Jul 15 2010
Derbi is an apache db subproject and is relational database implemented in Java.It is so small that you can easily embed it in any kind of java based solutions.Derbi has an additional frame work called as Network Server frame work. The main advantage of the DERBI is full-featured, open source relational database management system (RDBMS) […]
Join and View in Sql
Posted in Database Development by admin - Jun 30 2010
SQL queries allow us to form relationships between multiple tables and retrieve data from that table. The process of querying multiple tables is called Joins and it is an important feature of RDBMS .(SQL initially pairs every row in one table with every row in the other table. This causes retrieving of a large number […]