Proposal For Gui Rdbms Final
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View Proposal For Gui Rdbms Final as PDF for free.
More details
- Words: 958
- Pages: 6
Proposal
IPSR ARJUN.D
GUI FOR RDBMS A Proposal
Presented on 13-07-08
Page 1 of 6
Proposal
Table of Contents 1
Current Scenario .....................................................................................................3
2
Solution....................................................................................................................3 2.1 2.2
3
Objectives....................................................................................................................... 3 Benefits .......................................................................................................................... 4
Implementation Plan ...............................................................................................4 3.1 3.2 3.3 3.4
Methodology................................................................................................................... 4 Schedule ........................................................................................................................ 5 Qualifications................................................................................................................... 5 Costs ............................................................................................................................... 6
4 Conclusion..................................................................................................................6
Page 2 of 6
Proposal
Introduction Harnessing the power of Information Technology to usher in its huge benefits is the motto that drives IPSR on. IPSR is a provider of total IT services:-IT training, Website development, Hardware development hardware sales and service. Born out of the strategic vision of academicians and entrepreneurs IPSR has carved a niche for itself in the field of IT services, through quality and innovative work. IPSR is committed to understanding client needs and providing comprehensive solutions that are in sync with the latest technologies. Our clients include major names from various sectors like banking, manufacturing, retail, services etc.
1
Current Scenario
Database Management Systems or DBMS has evolved from a specialized computer application to a central component of modern computing environment. There are different types systems available of which Relational Database Management System (RDBMS) is the most popular choice for large scale applications. There are different models of RDBMS available in the market for e.g. SQL Server, My SQL, MS Access etc.To interact with databases and tables in it one need to use Structured Query Language (SQL) which includes features on defining structure of data modifying data. But there are some limitations working on these existing systems. •
GUI’s (Graphical User Interface) provided by most of the existing systems are exclusive to its own database.
•
Working with different databases and different DBMS’ through ‘a single user friendly interface’ is impossible.
•
The features and functionality provided by each GUI differ from one RDBMS to another.
•
A GUI that provides an easy interface to a user with little knowledge of SQL is hard to find.
2
Solution
The project entitled ‘GUI for RDBMS’ is aimed at providing a single user friendly interface for working with different RDBMS’ like My SQL, SQL Server, MS Access etc.This project is also in design keeping in mind of the user who has limited or no knowledge of SQL. Another key feature of the project is incorporating it into a network system so that with GUI a user can retrieve databases and tables from other systems and RDBMS’ in the network.
2.1 Objectives The project is aimed at accomplishing the following: •
Create and drop databases in an RDBMS.
Page 3 of 6
Proposal •
View and work with database objects like tables, queries, forms, reports.
•
View database profile in a particular RDBMS.
•
Preparing and printing various reports containing information about existing databases and objects in a database, if needed.
•
Enhanced security features by RSA encryption/decryption algorithm.
•
A provision for an SQL query analyzer for executing queries in SQL mode if required.
2.2
Benefits
GUI for RDBMS is going to provide great benefits to its end user what ever be the scale of application usage.
Using a single product (a general – level GUI) data manipulation can be done on different RDBMS’ simultaneously.
Reduction of time for executing queries because of easy point and click interface with proper visual aids.
A user interface not exclusive to any particular type of RDBMS.
Elimination of overhead that is needed to connect to a different type of interface for a different RDBMS.
Networking enables a access over RDBMS on other systems
3
Implementation Plan
3.1 Methodology Code design is planned to be implemented giving priority to simplicity, clarity, ease of deign to code translation and maintainability. Java 2.0 has been selected as the front end tool for development. As the system aims at creating a user friendly interface the swing class of Java is of much use to development .The swing classes provide more powerful and flexible components than the standard Abstract Window Toolkit (AWT).JDBLC (Java Database Connection) is the right choice for making database connections as the proposed system has to communicate with more than one type of RDBMS.
Page 4 of 6
Proposal
Access to the application will be restricted with an authorization window asking for username and password. Java RMI will be used to incorporate the networking features.
3.2 Schedule
Project Schedule
3.3
Qualifications
IPSR is a provider of total IT solutions of Global standards. Our core competencies lie in customized software solutions, Internet based applications and technical consultancy. In addition IPSR also offers a range of hardware and network solutions. A CMMi level 3 company, we strive to attain consistent reduction in software defect density. Consistent tuning of quality process with the business process of the client and quality service within schedule and budget is our priority.
Page 5 of 6
Proposal
3.4
Costs
A detailed statement on project cost details with particular break down of costs will be produced on request.
4 Conclusion The system is proposed to help the end user easily access and work with databases in different RDBMS, even if he/she has no knowledge on SQL. The proposed system is menu driven so a user can master the interface with little or no formal training. For making the system adaptive to the changing demands of the industry updates will be provided. Also if the user wants to add separate program modules of his choice, they can be combined to the main program to facilitate new features. The system can be further enhanced to handle nested queries, sub queries. An option for backing up databases and restoring them is in the pipeline. Efforts are being made to make the proposed system more general level, by supporting more RDBMS’.
Page 6 of 6
IPSR ARJUN.D
GUI FOR RDBMS A Proposal
Presented on 13-07-08
Page 1 of 6
Proposal
Table of Contents 1
Current Scenario .....................................................................................................3
2
Solution....................................................................................................................3 2.1 2.2
3
Objectives....................................................................................................................... 3 Benefits .......................................................................................................................... 4
Implementation Plan ...............................................................................................4 3.1 3.2 3.3 3.4
Methodology................................................................................................................... 4 Schedule ........................................................................................................................ 5 Qualifications................................................................................................................... 5 Costs ............................................................................................................................... 6
4 Conclusion..................................................................................................................6
Page 2 of 6
Proposal
Introduction Harnessing the power of Information Technology to usher in its huge benefits is the motto that drives IPSR on. IPSR is a provider of total IT services:-IT training, Website development, Hardware development hardware sales and service. Born out of the strategic vision of academicians and entrepreneurs IPSR has carved a niche for itself in the field of IT services, through quality and innovative work. IPSR is committed to understanding client needs and providing comprehensive solutions that are in sync with the latest technologies. Our clients include major names from various sectors like banking, manufacturing, retail, services etc.
1
Current Scenario
Database Management Systems or DBMS has evolved from a specialized computer application to a central component of modern computing environment. There are different types systems available of which Relational Database Management System (RDBMS) is the most popular choice for large scale applications. There are different models of RDBMS available in the market for e.g. SQL Server, My SQL, MS Access etc.To interact with databases and tables in it one need to use Structured Query Language (SQL) which includes features on defining structure of data modifying data. But there are some limitations working on these existing systems. •
GUI’s (Graphical User Interface) provided by most of the existing systems are exclusive to its own database.
•
Working with different databases and different DBMS’ through ‘a single user friendly interface’ is impossible.
•
The features and functionality provided by each GUI differ from one RDBMS to another.
•
A GUI that provides an easy interface to a user with little knowledge of SQL is hard to find.
2
Solution
The project entitled ‘GUI for RDBMS’ is aimed at providing a single user friendly interface for working with different RDBMS’ like My SQL, SQL Server, MS Access etc.This project is also in design keeping in mind of the user who has limited or no knowledge of SQL. Another key feature of the project is incorporating it into a network system so that with GUI a user can retrieve databases and tables from other systems and RDBMS’ in the network.
2.1 Objectives The project is aimed at accomplishing the following: •
Create and drop databases in an RDBMS.
Page 3 of 6
Proposal •
View and work with database objects like tables, queries, forms, reports.
•
View database profile in a particular RDBMS.
•
Preparing and printing various reports containing information about existing databases and objects in a database, if needed.
•
Enhanced security features by RSA encryption/decryption algorithm.
•
A provision for an SQL query analyzer for executing queries in SQL mode if required.
2.2
Benefits
GUI for RDBMS is going to provide great benefits to its end user what ever be the scale of application usage.
Using a single product (a general – level GUI) data manipulation can be done on different RDBMS’ simultaneously.
Reduction of time for executing queries because of easy point and click interface with proper visual aids.
A user interface not exclusive to any particular type of RDBMS.
Elimination of overhead that is needed to connect to a different type of interface for a different RDBMS.
Networking enables a access over RDBMS on other systems
3
Implementation Plan
3.1 Methodology Code design is planned to be implemented giving priority to simplicity, clarity, ease of deign to code translation and maintainability. Java 2.0 has been selected as the front end tool for development. As the system aims at creating a user friendly interface the swing class of Java is of much use to development .The swing classes provide more powerful and flexible components than the standard Abstract Window Toolkit (AWT).JDBLC (Java Database Connection) is the right choice for making database connections as the proposed system has to communicate with more than one type of RDBMS.
Page 4 of 6
Proposal
Access to the application will be restricted with an authorization window asking for username and password. Java RMI will be used to incorporate the networking features.
3.2 Schedule
Project Schedule
3.3
Qualifications
IPSR is a provider of total IT solutions of Global standards. Our core competencies lie in customized software solutions, Internet based applications and technical consultancy. In addition IPSR also offers a range of hardware and network solutions. A CMMi level 3 company, we strive to attain consistent reduction in software defect density. Consistent tuning of quality process with the business process of the client and quality service within schedule and budget is our priority.
Page 5 of 6
Proposal
3.4
Costs
A detailed statement on project cost details with particular break down of costs will be produced on request.
4 Conclusion The system is proposed to help the end user easily access and work with databases in different RDBMS, even if he/she has no knowledge on SQL. The proposed system is menu driven so a user can master the interface with little or no formal training. For making the system adaptive to the changing demands of the industry updates will be provided. Also if the user wants to add separate program modules of his choice, they can be combined to the main program to facilitate new features. The system can be further enhanced to handle nested queries, sub queries. An option for backing up databases and restoring them is in the pipeline. Efforts are being made to make the proposed system more general level, by supporting more RDBMS’.
Page 6 of 6
Related Documents
Proposal For Gui Rdbms Final
November 2019 0
Final Gui
October 2019 4
Comparisons Of Gui Toolkits,rdbms,ide
May 2020 0
Rdbms
November 2019 19
Rdbms
July 2020 8