University Information Systems (UIS): Home Page
  About UIS
  Contact Us
  UIS Site Index

Application Access

Business Applications

Training

Download

Technology

Login

Operations
Relational Database Management a
   Technology: Database, File Systems and Tools
 

  Microsoft SQL Server 2000:

 

Is a relational database management system (RDBMS) from Microsoft. Its primary query language is Transact-SQL, an implementation of the ANSI/ISO standard Structured Query Language (SQL) used by both Microsoft and Sybase. SQL Server is commonly used by businesses for small- to medium-sized databases, but the past five years have seen greater adoption of the product for larger enterprise databases.

 

Adaptive Server Enterprise (ASE):

 

Is a relational database management system from Sybase.ASE is a direct descendant of Sybase SQL Server as it was a change in name only starting from version 11.5 in 1996. In 1998, ASE 11.9.2 was rolled out with support for row-level locking and distributed joins and improved SMP performance. ASE 12.0 was released in 1999 providing support for Java, high availability and distributed transaction management. In 2001, ASE 12.5 was released providing features such as dynamic memory allocation and support for XML and SSL among others. Support of an EJB container within the database server along with efficient in-memory connections to the database engine, suggests an object oriented access to the relational data.

 

  DBArtisan:

 

Is the leading database administration solution for managing Sybase for Open Systems.  Its rich feature set helps maximize the availability, performance, and security of databases throughout the enterprise.  DBArtisan Professional automates and streamlines day-to-day administrative tasks such as managing space, creating user accounts, altering objects, migrating schemas between development, test and production databases, monitoring performance, and much more.

 

 

  Record Management Services (RMS):

 

Are procedures in the VMS, operating systems that programs may call to process files and records within files. VMS RMS is an integral part of the system software; its procedures run in executive mode.

 

RMS supports four record access methods:

  • Sequential Access

  • Relative Record Number Access

  • Record File Address Access

  • Indexed Access

RMS supports four record formats:

  • Fixed length

  • Variable length

  • Variable record length with fixed-length control blocks

  • Stream files

Printer Friendly Version  ]