Geertjan is a DZone Zone Leader and has posted 459 posts at DZone. You can read more from them at their website. View Full User Profile

Egyptian Database Student Project on the NetBeans Platform

02.10.2009
| 17530 views |
  • submit to reddit
Ahmed Gaber, a student at the faculty of computers and informatics at Suez Canal University in Egypt, is in his final year and lives in Ismailia. Here he talks about the graduation project that he and a team of other students are working on, called Visual Database, which will be based on the NetBeans Platform and which has a project site on SourceForge:

http://visualdb.sourceforge.net

Can you start by giving a high level view of what you're planning to create? We envision our project as a tool for visually manipulating databases, particularly for designing and creating them. So, in short, the plan is to create a visual designer for databases, to handle the DDL of databases, through wizards, as well as a canvas for drawing ER diagrams.

And what should the tool's output consist of? From the wizards and the designer, the user should be able to instantly generate DDL scripts, which handle the structuring of databases. In addition, the application should also be able to handle the testing of databases. The user should be able to create test databases so that they can verify the validity of the database structure prior to going into production.

Which database management systems are you planning to support? We're planning to provide support for several types of database management systems, which will be easy with the NetBeans Platform, since NetBeans IDE comes prepackaged with database support already. Initially we're planning to provide support for MySQL and Oracle. In the future other developers should be able tp extend the support with additional databases to meet their specific needs.

There are different types of notations for entity relationships. Will you support more than one? Yes,  we'll provide support for several ER notations, such as Chen and Craw's Foot. In doing this, we will give the user several choices to fit their work environment.

Any other features you're thinking of? Well, the user will be given the ability to generate DBdoc for the created database. This feature will be useful for those who are involved in the development of open source applications. Together with the docs for their code, they'll be able to make docs for their database too.

The application will also provide several formats for exporting the SQL and ER. For example, the user will be able to export their database in a binary Dump, SQL Scripts, XML databases, CSV, and so on. They'll also be able to export the ER in various formats, such as PDF, SVG, and PNG

Right now, that's all about the guidelines of our project, and more details will be provided on our project's website at  http://visualdb.sourceforge.net.

Would you like help from the community? Actually, we need help from NetBeans Platform experts, as well as users of NetBeans IDE! If they can specify their needs, assuming they need a tool of this kind, that would be very helpful. "What kind of work would you like to do with this application?", for example, is the kind of question that could be answered by sending an e-mail to me at aigdonia AT gmail DOT com. We will consider all ideas and, where applicable, add them to the features list that we'll publish in the coming days. At this time, that's all the help we can accept, in terms of direct contributions, since it is still a graduation project!

What is the deadline of the project? We'll deliver our application, i.e., our graduation release, next July. But, our beta and test releases will be coming out during the next months for trying it out!

AttachmentSize
fig-2.png16.32 KB
Published at DZone with permission of its author, Geertjan Wielenga.

Comments

Wai Ho replied on Tue, 2009/02/10 - 3:35pm

Hi that project sounds a lot like this one: http://java.dzone.com/news/interview-konstantin-chikarev-. Good luck!

Ahmed Gaber replied on Thu, 2009/02/12 - 4:49pm in response to: Wai Ho

Thanks for this tip,

I'll post more about the project here on DZone

Ashley Ford replied on Tue, 2011/01/11 - 2:02pm

I just read this interview (thanks Wai Ho!) http://java.dzone.com/news/interview-konstantin-chikarev-MP Surgeons and they do sound similar but that doesn't mean they aren't different! It seems like you learned from some of his setbacks already!  I agree with you about users and experts specifiying needs -- if you don't ask, you can't receive! I would not be a NetBeans junkie if I didn't ask for help when I needed it!

 Tina Figgler

 

Matt Coleman replied on Wed, 2012/07/04 - 5:37am in response to: Ahmed Gaber

yes, post more project please!! graphic design buffalo

 

Mateo Gomez replied on Thu, 2012/07/05 - 2:18am

 good for Egyptian  students for creating this

mexican salsa recipes

Mada Leenah replied on Mon, 2012/10/01 - 7:18am

I have graduated from a computer science university last year and I am currently a public health worker managing a hospital's computer network and database. This kind of projects are interesting for me because they can make my work a lot easier and faster. I won't have to code for days, every aspect of the database maintenance would be done through wizards. Your idea is kind of a CMS for databases.

Stork Club replied on Thu, 2012/10/18 - 2:03am

what great opportunity for these students to learn from you NB

stork club new york

Edward Villanueva replied on Wed, 2012/12/12 - 12:05am

NB is really cool. Thanks for sharing those project here on dzone. edongzki 

Bryan Low replied on Sun, 2013/02/24 - 4:54am

Bartley Ridge is also near elite schools such as Cedar Primary School and St. Gabriel Secondary School. Paya Lebar Methodist Girls’ School and DPS International School are also around in the area.

Bartley Ridge Site Plan 

Gigi Han replied on Mon, 2013/07/15 - 3:38pm

The project in which Ahmed Gaber is involved looks compromising, I am glad they have chosen Netbeans platform as it gives them a lot of new opportunities. My nephew is a social media and school applicant , he was involved in a couple of projects and he posted them on SourceForge, a lot of people appreciated his work and told him to continue his ideas.

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.