Win a copy of Escape Velocity: Better Metrics for Agile Teams this week in the Agile and Other Processes forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Liutauras Vilda
  • Tim Cooke
  • Paul Clapham
  • Jeanne Boyarsky
Sheriffs:
  • Ron McLeod
  • Frank Carver
  • Junilu Lacar
Saloon Keepers:
  • Stephan van Hulst
  • Tim Moores
  • Tim Holloway
  • Al Hobbs
  • Carey Brown
Bartenders:
  • Piet Souris
  • Frits Walraven
  • fred rosenberger

Java Database

 
Ranch Hand
Posts: 268
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
 
Rancher
Posts: 43028
76
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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.
 
Bartender
Posts: 11497
19
Android Google Web Toolkit Mac Eclipse IDE Ubuntu Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
 
Java Cowboy
Posts: 16084
88
Android Scala IntelliJ IDE Spring Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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.
 
Sheriff
Posts: 22684
128
Eclipse IDE Spring VI Editor Chrome Java Windows
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
Bartender
Posts: 11497
19
Android Google Web Toolkit Mac Eclipse IDE Ubuntu Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
More about SQL here and here
 
Ulf Dittmer
Rancher
Posts: 43028
76
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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.
 
Marshal
Posts: 76487
366
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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.
 
Author
Posts: 12617
IntelliJ IDE Ruby
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
A Java CouchDB clone might be interesting.

(Oh, I didn't even know it was an Apache project now.)
 
This is my favorite tiny ad:
the value of filler advertising in 2021
https://coderanch.com/t/730886/filler-advertising
reply
    Bookmark Topic Watch Topic
  • New Topic