D Y S M –Dynamic System Level Dbase Mergers

Project Synopsis

Project Title: D Y S M –Dynamic System Level Dbase Mergers

Tools / Platform: The project will be in Windows-2000 platform with C#.Net as front end tool And Oracle as back end tool.

Introduction To application Area:

This is a total System based solution for all data base managers in any large orginisation. It comprises of 3 main components namely Stored Procedure, D- Enterpriser, and Data Transformation

 Enterprise Manager (Dynamic Enterpriser)

Enterprise Manager is the primary administrative tool for Oracle/Sql.

Enterprise manager deals with creation of oracle objects, logins, users, and permissions in each registered server.

 Custom data movement solutions

Many organizations need to centralize data to improve corporate decision-making. However, their data may be stored in a variety of formats and in different locations. Data Transformation Services (DTS) addresses this vital business need by providing a set of tools that lets you extract, transform, and consolidate data from disparate sources into single or multiple destinations supported by DTS connectivity.

 EASY STORED PROCEDURES

The project titled easy stored procedures contains two main areas. First we can generate the TSQL code for an INSERT or UPDATE Microsoft SQL Stored Procedures. This application uses some basic SQLDMO (SQL Database Management Object) methods to achieve the complete result.

The project has been developed based on these modules.

1. Create User

Using this module we can create new users and can give privileges to the user.

2. Create Table

A table is a 2 dimensional matrix that consists of rows and columns. A column represents a type of information and a row represents a record. A column is also known as an attribute and a row is known as a TUPLE

3. Create View

Views are masks placed upon table. This allows the programmer to develop a method via which we can display predetermined data to users according to our desire. To make the querying of the table easier oracle provides for the generation of views. A view is created unique, according to the needs of the user, where the user can then only access those fields of the database allowed by the view. This provides security for data within a table. OR Views are tables whose contents are taken or derived from other tables.

4. Create Function

Functions are named PL/SQL blocks that can take parameters, perform an action and returns a value to the host environment. A function can only return one value.

5. Create Procedure

Procedures are named PL/SQL blocks that can take parameters, perform an action and can be invoked. Procedures are made up of a declarative part, an executable part and an optional exception handling part.

6. Create Trigger

Database triggers are procedures that are stored in the database and are implicitly executed when the contents of table are changed.

7. Create Package

A package is a database object that groups logically related PL/SQL types, objects and subprograms. Packages usually have two parts, A specification and A body, although sometimes the body is unnecessary. The specification is the interface to your programs; it declares the types, variables, constants exceptions, cursors and subprograms available for use. The body fully defines cursors and subprograms and so implements the specification.

8. Grant Privileges

Data Control languages (DCL) .It provides control statements that govern data security with grant and revoke statements. The objects created by one user are not accessible by another user unless the owner of these objects gives such permission to other users. These permissions can be given by using the GRANT statement. The permission once given can be denied using the REVOKE command.

9. Convert to Sql

In this module we can convert word document, excel document, oracle, xml, notepad and access data to SQL database. We can perform the reverse action also.

10. Convert to access

In this module we can convert word document, excel document, oracle, xml, notepad and sql data to access database. We can perform the reverse action also.

11. Convert to oracle

In this module we can convert word document, excel document, sql, xml, notepad and access data to oracle database. We can perform the reverse action also.

12 Server Listing Modules

The module helps in listing of available servers in the machine. We can add or type in the name of the sql server we want to use instead of selecting a server from the available list. After selecting the server we want to use we can key in the username and password which we have the right to use. After this process the application will authenticate the user.

13 Database Listing Module

After the authentication process the application will try to connect to the database, and list the entire available database to the user. Here user will be able traverse through every database and its tables.

14 Generator Module

The module is the heart of the application. With this module we can generate the stored procedure for inserting or updating a table without spending lot of time to create to correct the errors. If we create stored procedure manually there may come errors due to data type mismatch or variable mismatch. But this application eliminates the chance of a minute error. The application uses a tree view structure to list out databases and tables. With the application we can create the stored procedure to create or update a table with a button click.