Win a copy of Functional Reactive Programming this week in the Other Languages forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Java Database

 
adeeb alexander
Ranch Hand
Posts: 268
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Rancher
Posts: 42968
73
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
Maneesh Godbole
Saloon Keeper
Posts: 11196
15
Android Eclipse IDE Google Web Toolkit Java Mac Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Actually Derby comes bundled with the JDK now.
 
adeeb alexander
Ranch Hand
Posts: 268
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 15493
43
Android IntelliJ IDE Java Scala Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
Rob Spoor
Sheriff
Pie
Posts: 20669
65
Chrome Eclipse IDE Java Windows
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
adeeb alexander
Ranch Hand
Posts: 268
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 11196
15
Android Eclipse IDE Google Web Toolkit Java Mac Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
More about SQL here and here
 
Ulf Dittmer
Rancher
Posts: 42968
73
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Pie
Posts: 50263
79
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Maneesh Godbole wrote:More about SQL here and here
And here.
We usually discuss databases in a different forum. Moving.
 
David Newton
Author
Rancher
Posts: 12617
IntelliJ IDE Ruby
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
A Java CouchDB clone might be interesting.

(Oh, I didn't even know it was an Apache project now.)
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic