File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes Java Database Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Java 8 in Action this week in the Java 8 forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Java Database" Watch "Java Database" New topic
Author

Java Database

adeeb alexander
Ranch Hand

Joined: May 29, 2008
Posts: 268
Hi all.
I have come to know that all the databases are developed in C language. So is it possible to develop a database in java if YES how, and if NO Why? and what will be the issues if developed also. Please some one give me appropriate answer so that i may come to know the diffrences.



Thanks and Regards
alexander
Ulf Dittmer
Marshal

Joined: Mar 22, 2005
Posts: 39578
    
  27
I have come to know that all the databases are developed in C language.

Database can be (and have been) written in many languages. I suggest to question the source where you heard this.

DBs written in Java include HSQLDB and Derby.


Ping & DNS - updated with new look and Ping home screen widget
Maneesh Godbole
Saloon Keeper

Joined: Jul 26, 2007
Posts: 9995
    
    7

Actually Derby comes bundled with the JDK now.


[How to ask questions] [Donate a pint, save a life!] [Onff-turn it on!]
adeeb alexander
Ranch Hand

Joined: May 29, 2008
Posts: 268
So. My question was that why aren't java databases so popular such as Oracle or DB2. I think there might be some or the other drawback due to which java databases are not used so widely. If i want to develop a database in java then which guides shall i follow.


Thanks and Regards
alexander
Jesper de Jong
Java Cowboy
Saloon Keeper

Joined: Aug 16, 2005
Posts: 13884
    
  10

Probably for historical reasons, and because companies like Oracle and IBM are good at selling their databases, and because nobody wrote database software which is as robust, scalable and feature-rich as Oracle or DB2. It does not have anything to do with in which language the database itself is written, and certainly does not mean that there is anything wrong with the Java programming language.


Java Beginners FAQ - JavaRanch SCJP FAQ - The Java Tutorial - Java SE 7 API documentation
Scala Notes - My blog about Scala
Rob Spoor
Sheriff

Joined: Oct 27, 2005
Posts: 19557
    
  16

It's also because of when these databases were developed. Oracle (1979), DB2 (1983) and even MS SQL Server (1990) have been around before Java was conceived.


SCJP 1.4 - SCJP 6 - SCWCD 5 - OCEEJBD 6
How To Ask Questions How To Answer Questions
adeeb alexander
Ranch Hand

Joined: May 29, 2008
Posts: 268
My friends said that to develop a database one requires 100's of programmers. Moreover i want to know that SQL is a language or just Syntaxes that a database should follow like Syntax is: "SELECT * FROM TAB";

I even want to learn to develop a database in java, from where should i start.



Thanks and Regards
alexander
Maneesh Godbole
Saloon Keeper

Joined: Jul 26, 2007
Posts: 9995
    
    7

More about SQL here and here
Ulf Dittmer
Marshal

Joined: Mar 22, 2005
Posts: 39578
    
  27
My friends said that to develop a database one requires 100's of programmers.

That depends entirely on the type of DB. On SourceForge you can find numerous DBs that have been developed by single persons. If you're talking about a commercial-grade relational DB, then hundreds of man-years of effort will be involved.

Moreover i want to know that SQL is a language or just Syntaxes that a database should follow like Syntax is: "SELECT * FROM TAB";

SQL is a query language for relational DBs. See its Wikipedia entry for much more information.

I even want to learn to develop a database in java, from where should i start.

Decide what kind of DB it should be. For example, should it be relational or non-relational? If the answer is relational, then I'd advise to give up; it's too much work for a single person. Then take a look at the existing Java DBs out there, and think about how your DB should be similar or different from those.
Campbell Ritchie
Sheriff

Joined: Oct 13, 2005
Posts: 36599
    
  16
Maneesh Godbole wrote:More about SQL here and here
And here.
We usually discuss databases in a different forum. Moving.
David Newton
Author
Rancher

Joined: Sep 29, 2008
Posts: 12617

A Java CouchDB clone might be interesting.

(Oh, I didn't even know it was an Apache project now.)
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Java Database
 
Similar Threads
General Error in SQL Server 2000
creating setup for software in java
Green Light for Java!
Want to develop a site with JSP?
is java really dying ?????