EverGreen Computer Solutions

Services / data base

DESIGN

Identify and document database requirements
Create a conceptual model
Transform the conceptual model into a logical model
Implement a physical model from the logical model
Refine the physical model
Build a prototype and test the database design

DESIGNING FOR OLTP ACTIVITY

Functional Dependencies
Data Normalization Objectives
Achieving a Normalized Design

DATABASE SECURITY

Authentication
Authorization
Data Protection
Auditing
Encryption Tradeoffs

DESIGNING STORED PROCEDURES

Selecting between Transact-SQL and CLR stored procedures

Among the DataBase Systems used by Evergreen Computer Solutions are:

Microsoft Access 2005

Microsoft Access is a relational database management system from Microsoft, packaged with Microsoft Office Professional which combines the Jet relational database engine with a graphical interface. The development environment provides productivity-enhancing features for both advanced developers and beginning users.

DB2 400

The AS400 contains a relational database called DB2/400. DB2/400 is integrated into the AS/400 partly above the MI and partly in the LIC. Conventional databases are separate software components that reside on top of the operating system. Since DB2/400 is integrated throughout the entire system it can achieve a higher level of efficiency because it is tightly integrated with the components with which it communicates.

SQL Server 2000 / 2005

SQL Server 2005 is a comprehensive database software platform providing enterprise-class data management and integrated business intelligence (BI) tools. The SQL Server 2005 database engine provides more secure, reliable storage for a relational database format or XML. By supporting both a relational database format and XML, the SQL Server 2005 database engine provides the flexibility necessary to support the way you work. It also enables you to build and manage highly available, well-performing database software applications that you and your people can use to take your business to the next level.

Footer