eDBServer : DATABASE MANAGER

ERPWEB is e-Business Operating System

Software Demo: Database | Tables | Views/Query | Stored Procedures | Trigger/Events

Database Design Management

ERPWEB Database Manager helps you manage your database design.
You can view database Tables and can Add/Edit/Delete or view data from this Tables.
You can view database Views/Query and can Add/Edit/Delete or view data from this Views.
You can view database Stored procedures and can Add/Edit/Delete or execute this procedures.
You can view database Triggers and can Add/Edit/Delete or test triggers.
Remember this Tables, Views, Stored Procedures & Triggers are very well connected to applications.
It is recommended to directly work with above mentioned application design managers to maintain integrity.
Views, Triggers & Stored procedures contains business logic for applications.
You can also access all this database management features when you login to Database manager from main menu.
You can use 3rd party Database management Tools like MS SQL Server Enterprise Manager, Query Analyzer etc. to build or modify database design..

Creating and Maintaining Databases :

A client/server database system comprises two components:

Programs that provide an interface for client-based users to access data.
The database structure that manages and stores the data on the server.

For example, if you use Microsoft® SQL Server™ 2000 to create a checking account application, you must set up a database structure to manage the account transaction data and an application that acts as the user interface to the database, allowing users to access checking account information.

Creating a database to serve your business needs requires an understanding of how to design, create, and maintain each of these components to ensure that your database performs optimally.

Topic	Description
Databases	Describes how databases are used to represent, manage, and access data.
Tables	Describes how tables are used to store rows of data and define the relationships between multiple tables.
Indexes	Describes how indexes are used to increase the speed of accessing the data in the table.
Views	Describes views and their usefulness in providing an alternative way of looking at the data in one or more tables.
Stored Procedures	Describes how these Transact-SQL programs centralize business rules, tasks, and processes within the server.
Enforcing Business Rules with Triggers	Describes the function of triggers as special types of stored procedures executed only when data in a table is modified.
Full-Text Indexes	Describes how full-text indexes facilitate the querying of data stored in character-based columns, such as varchar and text.

Database Management languages are used to design Business Logic & manage databases:

A database language defines the syntax of the commands sent to the database. The commands sent through the API allow the application to access and modify data. They also allow the application to create and modify objects in the database. All commands are subject to the permissions granted to the user. SQL Server 2000 supports two languages:

a) SQL Business Logic

Structured Query Language - SQL is central to the use of Database Server. All applications that communicate with Database Server do so by sending SQL statements to the server, regardless of an application's user interface.

b) XPath

SQL Server 2000 supports a subset of the XPath language defined by the World Wide Web Consortium (W3C). XPath is a graph navigation language used to select nodes from XML documents. You first use a mapping schema to define an XML-based view of the data in one or more SQL Server tables and views. You can then use XPath queries to retrieve data from that mapping schema.

You usually use XPath queries in either URLs or the ADO API, XPath queries are also supported by the OLE DB API.

ERPWEB provides complete e-Business Infrastructure at lowest costs

This document last updated on