DB Management System (Oracle DB using PL/SQL)
This project was implemented during Oracle DB course at Afeka Academic College of Engineering.
The main idea of the project was to create a DB management system where the user can run different queries edit,create and manage DB tables.
I chose to implement the project on a known MMORPG game,creating and thinking about the tables structures and the connections between them done by me.
While developing this project one of the most important constraint was to write a code on the client side while it doesn't includes any line of SQL code,
This means that all the DB calculations are done on the server side and sent back to the client.
The requirements of the project required implementing complicated DB functions,procedures and queries which was done using PL/SQL ,
One of them which really impressed the lecturer and none of the students implement was a generic function which converts any table to a string,
This means that in the client side I can call this function with any table structure and get a string of a table and then I can parse and view it to the user.
The project implements :
1. Use of JDBC MySQL Connector in order to create and communicate with the DB.
2. PL/SQL
3. MVC (Model View Control) Architecture.
Please enter to my blog for more information and details :
Soon...
The main idea of the project was to create a DB management system where the user can run different queries edit,create and manage DB tables.
I chose to implement the project on a known MMORPG game,creating and thinking about the tables structures and the connections between them done by me.
While developing this project one of the most important constraint was to write a code on the client side while it doesn't includes any line of SQL code,
This means that all the DB calculations are done on the server side and sent back to the client.
The requirements of the project required implementing complicated DB functions,procedures and queries which was done using PL/SQL ,
One of them which really impressed the lecturer and none of the students implement was a generic function which converts any table to a string,
This means that in the client side I can call this function with any table structure and get a string of a table and then I can parse and view it to the user.
The project implements :
1. Use of JDBC MySQL Connector in order to create and communicate with the DB.
2. PL/SQL
3. MVC (Model View Control) Architecture.
Hosted by Mr. Libis Alex
Please enter to my blog for more information and details :
Soon...