LightBlog
Contact at mumbai.academics@gmail.com or 8097636691/9323040215
Responsive Ads Here

Thursday, 1 February 2018

Sql Web Manager

Sql Web Manager

ABSTRACT
Sql Web Management is a innovative, intuitive online Database Tool and. Specifically aimed at developers developing online, Intranet and Internet database related projects,
Website, etc., Sql Web Management profiles host of features that are very much crucial but neglected in general. This document provides very superficial information and capabilities of Sql Web Management.
In simple, using Sql Web Management any developer with minimal knowledge can easily do the following things
  • Connect to multiple databases easily
  • Create databases online
  • Modify databases online
  • Import and export data
  • Execute SQL statements online
Sql Web Management’s core features…
  • Login screen (connection requirements)
  • SQL Editor window
  • Results Window
  • Syntax highlighter and help
  • Saving SQL statements
  • Saving output results
  • Schema generation with UI
  • Multiple database connections
    • MS Access
    • SQL Server
    • Oracle
  • Storing multiple connection information
  • Importing data
  • Exporting data
  • Relationship diagram between tables
  • Database properties / structure details
Existing System:
The features offered by the Sql Web Management or the general day to day activities of the administrator are not available under one applications roof. The administrator has to use various tools to do achieve different tasks on different database systems. Shifting of applications between operations is time consuming and also lethargic to the user, often this makes overlooked errors and mistakes. Some of these errors may create chaotic situations, where recovering seems to be a nightmare.
The solution to the problem is to bring a Sql Web Management with all these operations without changing the applications or tools. There exist few tools / applications available to the administrator to do the activities mentioned in the overview. But the problem is that they are not integrated properly. Few of the    applications of platform specific, they can’t run on all operating systems.
Proposed System:
After analyzing the existing system, and some of the features offered by some of the existing tools, we bring all-in-one tools or application to the administrator’s satisfaction. It is intended to meet the entire requirements one looking for. The proposed model has features mentioned in the features list, yet all of these were accessible to the user in a planned manner with pleasing and simple interface.
  • Initial screen, which is going to ask user on what type of database that the user wants to interact.
  • Then it will ask for the required parameters to act on that particular database.
  • Based on the parameters it establishes the connection and executes the user queries to his satisfaction.
In addition to all these features, it also provides an important feature for importing and exporting the data.
Modules
Login
Administrator, Normal User’s login through the browser (Mozilla, Internet Explorer.Etc) by entering username and password.
a.       Administrator – Administrator login’s as Administrator or a Normal User.
He can access anything in the project
b.      Normal User - Normal User’s are login through the browser. The entered username and password are checked by the administrator after that he enter to next screen
Selection
Selection process is the one first welcomes the user by providing three options to choose. These are different database providers where the target database is going to be processed by the Sql Web Management.
a. MS Access - To process access database, we require DSN to be created. The user needs to enter the DSN name for the desired database. Using this ‘User DSN’ the program establishes the connection to the selected database.
b. Oracle – To process oracle database, we require three things namely, User Name, Password and Host (server) name. After the selection of the Oracle provider, user should enter the above-mentioned parameters to successfully connect to the specified database. For the connection we use ODBC / JDBC thin drivers. Once the connection is established the programmer can have full access (as per the privileges) to the database.
c. MS SQL Server – The processing of MS SQL Server is somewhat tricky in nature, as the behavior of the database including the structure is different from the rest of the two. The careful usage of the ODBC / JDBC thin drivers reveals the internal structure of the MS SQL Server for further usage. Here also user has to provide the user name, password and server name for establishing a successful connection.
Listing
This module does a simple and routine work. It gets the database information and displays it on screen accordingly.
a. Find the tables under the selection – Based on the user’s choice, using the connection established (as explained in the previous modules), and the selected database is analyzed to get its schema and other details. From this analysis, we can get the details of the tables existing under the database, table space, or in the tree view.
b. List the tables in the left pane of the screen - All the tables’ information from the previous module will be used to display it on the screen. The table information is so arranged in the left pane the screen in a tree view like structure for easy navigation. Further this leads to view the table data in the right side pane in a grid like structure.
Execution
Execution module simply executes the given query by expelling the results and status. It takes the users query formatted properly under SQL rules.
a. Query Execution – The top of the screen provides a big widened text box to the user to enter SQL statements. It accepts all valid SQL statements. These statements were analyzed according to the SQL standards before they have been executed. The execution of these SQL statements will be done over the user-selected database. This doesn’t restrict the user to successfully connect to the specified database. For the connection we use ODBC / JDBC thin drivers. Once the connection is established the programmer can have full access (as per the privileges) to the database.
b. MS SQL Server – The processing of MS SQL Server is somewhat tricky in nature, as the behavior of the database including the structure is different from the rest of the two. The careful usage of the ODBC / JDBC thin drivers reveals the internal structure of the MS SQL Server for further usage. Here also user has to provide the user name, password and server name for establishing a successful connection.
Export & Import
As the name suggests, this module exports as well as imports a database. This whole operation is three pronged, one for each database provider. The export and import functions for each database type is different from one another.
a. Export – Exports selected database – Depending on the user selected database type (based on the provider, such as Access, SQL server, and Oracle) the required routine to export will be selected and executed. This routine generally reads the data from the different tables in that database and exports it to a file of SWM own format.
b. Import – Imports an already exported database – Depending on the file selected for import, the file headers were analyzed to find out what type of database it is, and where it has to be imported. After this part, the actual data from the file is read and placed in proper positions of the target database.
SOFTWARE REQUIREMENTS:
Operating System           : Driver for Windows 95/98/NT
Back End                        : Oracle8I, SQL Server 2000, MS-Access
Front End                        : JAVA using Applets
Database Connectivity    : JDBC, Microsoft ODBC Oracle
HARDWARE REQUIREMENTS:
32 Pentium Min. 233 MHz.
16MB Ram
512 KB Cache Memory
Hard disk 4.3 GB
Microsoft Compatible 101 or more Key Board

No comments:

Post a Comment