08-16-2017, 09:33 PM
[attachment=14779]
INTRODUCTION
The MySQL GUI is the most powerful MySQL manager and admin tool, combining the features of MySQL Query Browser, Administrator, phpMyAdmin and various other MySQL Front Ends.
Features
Complete Unicode/UTF8 Support
MySQL 5.x objects support
Relationship/Foreign Key Manager
Table diagnostics
Creating/dropping database
Creating/Dropping/Altering tables
Multi-tab Query Editor and Result-set Editor
Multiple Query Execution
Advantages
It allows you to manage and browse your databases and tables from an intuitive Windows and Linux interface. One of the most wanted, needed features was a GUI for creating and editing triggers, available in MySQL 5.0.2 and above. Now implemented and hopefully as usable at it can be. Very simple compared to editing tables or procedures. The recently refactored "Table tools" dialog has a new tab now: "Bulk table editor". What is bulk editing? Move all tables of one or more databases to another database.Create and edit stored procedures and functions. The very first dialog which asks for hostname and credentials. The list of wanted databases can be limited and sorted alphabetically.
Administer MySQL accounts as easily as a toy. A pulldown showing assigned database objects reveals everything, details about tables and views. Switchable column headers is used to rename, delete, empty and modify tables. Create, modify databases and visually create and edit tables, create exact copies of an existing table, within the same database or in another one.
Table contents are editable in a grid. Switchable columns and sorting orders. Various filtering mechanisms. SQL query editing: Customizable syntax highlighting, snippet files, completion proposal pulldown and editable results. Pump database structures and data into a single dump file, one file per table or directly to another host. Save the result of any data grid to HTML and XML files. Find text in a table, a database or even on the whole server. Send any list of tables, columns, variables etc. to your printer. Browse through the topics in MySQL's built in help system. Create and edit stored procedures and functions.
CHAPTER II
SYSTEM STUDY
The system study phase includes the study of an existing system, proposing a new system and undergoing feasibility study. Firstly the developer studies how the existing system works, what are the advantages of existing system and what are the drawbacks? Studying the existing system completely the developer prepares a new system ie the proposed system and determines what all enhancements can be made to the existing system to build a better product. He also studies to advantages and disadvantages of proposed system. He then undergoes a detailed feasibility study ie he determines whether the proposed system is technically, socially and economically feasible.
2.1 EXISTING SYSTEM
In the present scenario, for database transactions the queries need to be written manually. Also multiple queries cannot be executed at a time. The creation of triggers, stored procedures are not in an easier way in the existing system. No import or export facility is available in existing system. So this existing system cannot satisfy the customer needs. Most of these sites are mainly focused on limited databases.
2.2 PROPOSED SYSTEM
In our proposed system the creation of databases and data transactions are simpler compared to the existing system. Here the creation of stored procedures, functions and triggers can be done in an easier way.
The advantages of proposed system are:
GUI for creating and editing triggers
Create and edit stored procedures and functions
Create exact copies of an existing table, within the same database or in another one.
Table contents editable in a grid. Switch able columns and sorting orders. Various filtering mechanisms
Pump database structures and data into a single dump file, one file per table or directly to another host. Save the result of any data grid to HTML and XML or PDF files
Send any list of tables, columns, variables etc. to your printer
2.3 FEASIBILITY STUDY
The main aim of feasibility study is to determine whether it would be functionally and technically feasible to develop the product. The feasibility study involves the analysis of the problem and the collection of relevant information relating to the product such as the different data item which would be the input to the system, the processing required to be carried out on these data, the output data required to be produced by the system, as well as various constraints on the behavior of the system. A feasibility study is a rest of the system proposal according to its working, impact on the organization, ability to meet users and effective use of resources. The objective of the feasibility study is acquiring the sense of scope of the system. The collected data are analyzed to arrive following:
An abstract problem definition: An abstract problem definition is a rough description of the problem, which considers only the important requirements and ignores the rest.
Formulation of different strategies.
Analysis of alternative solution strategies to compare their benefits and short comings. This analysis usually requires making estimates of the resources required, cost of development and development time for each of the options. These estimates are used as the basis for comparing the different solution identified; all later phases of development are carried out as per this solution. Thus during the feasibility study, most of the high level architectural design decisions are made. Therefore feasibility study is considered as the important stage. During this study, it may come to light that none of the solutions is feasible due to high cost, resource constraints or some other technical reasons.
The development of a computer-based system is more likely to be projects that are feasible. Three essential factors are involved in the feasibility analysis:
Operational Feasibility
Technical Feasibility
Economical Feasibility
INTRODUCTION
The MySQL GUI is the most powerful MySQL manager and admin tool, combining the features of MySQL Query Browser, Administrator, phpMyAdmin and various other MySQL Front Ends.
Features
Complete Unicode/UTF8 Support
MySQL 5.x objects support
Relationship/Foreign Key Manager
Table diagnostics
Creating/dropping database
Creating/Dropping/Altering tables
Multi-tab Query Editor and Result-set Editor
Multiple Query Execution
Advantages
It allows you to manage and browse your databases and tables from an intuitive Windows and Linux interface. One of the most wanted, needed features was a GUI for creating and editing triggers, available in MySQL 5.0.2 and above. Now implemented and hopefully as usable at it can be. Very simple compared to editing tables or procedures. The recently refactored "Table tools" dialog has a new tab now: "Bulk table editor". What is bulk editing? Move all tables of one or more databases to another database.Create and edit stored procedures and functions. The very first dialog which asks for hostname and credentials. The list of wanted databases can be limited and sorted alphabetically.
Administer MySQL accounts as easily as a toy. A pulldown showing assigned database objects reveals everything, details about tables and views. Switchable column headers is used to rename, delete, empty and modify tables. Create, modify databases and visually create and edit tables, create exact copies of an existing table, within the same database or in another one.
Table contents are editable in a grid. Switchable columns and sorting orders. Various filtering mechanisms. SQL query editing: Customizable syntax highlighting, snippet files, completion proposal pulldown and editable results. Pump database structures and data into a single dump file, one file per table or directly to another host. Save the result of any data grid to HTML and XML files. Find text in a table, a database or even on the whole server. Send any list of tables, columns, variables etc. to your printer. Browse through the topics in MySQL's built in help system. Create and edit stored procedures and functions.
CHAPTER II
SYSTEM STUDY
The system study phase includes the study of an existing system, proposing a new system and undergoing feasibility study. Firstly the developer studies how the existing system works, what are the advantages of existing system and what are the drawbacks? Studying the existing system completely the developer prepares a new system ie the proposed system and determines what all enhancements can be made to the existing system to build a better product. He also studies to advantages and disadvantages of proposed system. He then undergoes a detailed feasibility study ie he determines whether the proposed system is technically, socially and economically feasible.
2.1 EXISTING SYSTEM
In the present scenario, for database transactions the queries need to be written manually. Also multiple queries cannot be executed at a time. The creation of triggers, stored procedures are not in an easier way in the existing system. No import or export facility is available in existing system. So this existing system cannot satisfy the customer needs. Most of these sites are mainly focused on limited databases.
2.2 PROPOSED SYSTEM
In our proposed system the creation of databases and data transactions are simpler compared to the existing system. Here the creation of stored procedures, functions and triggers can be done in an easier way.
The advantages of proposed system are:
GUI for creating and editing triggers
Create and edit stored procedures and functions
Create exact copies of an existing table, within the same database or in another one.
Table contents editable in a grid. Switch able columns and sorting orders. Various filtering mechanisms
Pump database structures and data into a single dump file, one file per table or directly to another host. Save the result of any data grid to HTML and XML or PDF files
Send any list of tables, columns, variables etc. to your printer
2.3 FEASIBILITY STUDY
The main aim of feasibility study is to determine whether it would be functionally and technically feasible to develop the product. The feasibility study involves the analysis of the problem and the collection of relevant information relating to the product such as the different data item which would be the input to the system, the processing required to be carried out on these data, the output data required to be produced by the system, as well as various constraints on the behavior of the system. A feasibility study is a rest of the system proposal according to its working, impact on the organization, ability to meet users and effective use of resources. The objective of the feasibility study is acquiring the sense of scope of the system. The collected data are analyzed to arrive following:
An abstract problem definition: An abstract problem definition is a rough description of the problem, which considers only the important requirements and ignores the rest.
Formulation of different strategies.
Analysis of alternative solution strategies to compare their benefits and short comings. This analysis usually requires making estimates of the resources required, cost of development and development time for each of the options. These estimates are used as the basis for comparing the different solution identified; all later phases of development are carried out as per this solution. Thus during the feasibility study, most of the high level architectural design decisions are made. Therefore feasibility study is considered as the important stage. During this study, it may come to light that none of the solutions is feasible due to high cost, resource constraints or some other technical reasons.
The development of a computer-based system is more likely to be projects that are feasible. Three essential factors are involved in the feasibility analysis:
Operational Feasibility
Technical Feasibility
Economical Feasibility