Database Management Systems

basesprocketΔιαχείριση Δεδομένων

31 Οκτ 2013 (πριν από 3 χρόνια και 11 μήνες)

91 εμφανίσεις

Database Management
Systems

Assn2:

Online Research Exercise


Search online for information about a DBMS. Find
out the intended audience, price, and features of the
DBMS


Summer 2006 Students


MySQL


Steven Gangwish


Oracle


Rachel Harris, Ryan Ostolski


IBM (DB2)
-

Rachel McCarthy


Microsoft (SQL Server)


Beverly O’Steen


Microsoft Access


Anastasia Stanovova


Sybase
-

Joshua Thornton,


NCR (Teradata)


Rebecca Sheppard, Randall Monnet

By: Rachel Harris

Oracle

Oracle


First database designed for
grid computing.


Grid Computing:
a large system of
networked computers whose processing
power is used to solve difficult and time
-
consuming problems.


Good example of “relational database”


Uses tables

Oracle Continued…


Uses SQL language


Works on Windows, Linux, and Unix servers


Low Cost


Good for large corporations and small businesses
alike.



http://computer.howstuffworks.com/question599.ht
m


http://www.oracle.com/database/index.html

By: Rachel McCarthy

IBM(DB2)

IBM DB2 Product Family


Flexible, cost
-
effective database platform


Broad support for various types of development
platforms


J2EE (Java 2 Platform, Enterprise Edition)


Microsoft. Net


Products geared for company’s specific needs


Features a large variety of DB2 products each with
multiple editions

DB2 Universal Database


Proven leader in database products


Can handle any workload on the company’s choice
of operating system


Unix


Linux


Windows


Exceptional TCO (Total Cost of Ownership)


Aggressive Pricing


Industry Support


DB2 Universal Database


DB2 Universal Database is…


Reliable


Secure


Readily Available


Intended Customer = Businesses/Companies


Large


Small


Prices


High: $33,125.00
-


IBM DB2 Universal Database Enterprise Server
Edition Processor License


Low: $124.00
-

IBM DB2 Universal Database Express Edition User
License


Average: $6,274.50

By: Beverly O’Steen

Microsoft (SQL Server)

Microsoft (SQL Server)


(Audience) Intended Customer


Businesses


Express, Workgroup, Standard and Enterprise
editions.


Price


Free, $3899, $5999, $24999 and 146 to 162 per CAL


Features


Faster Results


Better Decisions


Trusted Platform


Features



Faster Results



A new Management Studio and integration with Visual Studio 2005
and the Microsoft .Net common language runtime helps you build,
debug and operate application faster and more efficiently.


Better Decisions


A comprehensive business intelligence platform for data integration,
analysis, and reporting that helps you turn insight into action and
make better decisions faster.


Trusted Platform


The highest performance, availability and security to run your most
demanding applications with native data encryption, secure default
settings and password policy enforcement.

Microsoft Access

By: Anastasia Stanovova


Microsoft Office Access



Packaged with Microsoft Office Professional


Relational database management system


Uses Object
-
Oriented programming



Microsoft Office Access
(cont
-
ed)
:

Used:


By end users to maintain personal databases


By small businesses


Within departments of large corporations


By hobby programmers for handling creation and
manipulation with data


By professional programmers for Rapid
Application Development


Microsoft Office Access
(cont
-
ed)
:

Main Features:


User
-
friendly interface


Compatibility with SQL


Easy to use for non
-
skilled users and many useful
features for programmers


Easily applied to small projects


(but scales inefficiently to large projects if
applications are designed poorly)



Microsoft Office Access
(cont
-
ed)
:

Price:

Retail price for Access 2003
-

$229 US


MS Access on
-
line:

http://www.microsoft.com/office/access

By: Rebecca Sheppard

What is Teradata?


Teradata



Relational database management system


A database management system designed to
manage a relational database


Teradata Uses


Is a massively parallel
processing system running
a shared nothing
architecture


The main point is


That it's linearly and
predictably scalable in all
dimensions of a database
system workload


Examples of workload:


Data volume


Breadth


Number of users


Complexity of queries


This explains its
popularity for
enterprise data
warehousing
applications

Operating Systems


NCR UNIX SVR4 MP
-
RAS, a variant of
System V UNIX from AT&T


Microsoft Windows 2000

and Windows
Server 2003


SUSE Linux
on 64
-
bit Intel servers has been
pre
-
announced for 2006


UNIX System V

UNIX

Windows Server 2003

SUSE Linux

Typical Users


Wal
-
Mart


Uses


Central inventory


Other financial systems


Data Warehouse


Largest data warehouse in the world

Other Customers


AT&T (formerly SBC)


Dell


Continental Airlines


National Australia Bank


FedEx


Vodafone


Kaiser Permanente



Price From


Lot of 10 units


Combination of any of the following:


Class 6000
-
9123
-
8090, 6000
-
9102
-
8090, 6000
-
9122
-
8090


Large
-
Scale MPP Teradata Warehouse


NCR Teradata rack, each one which includes:


80

HDD of 18.2GB each HDD, 10,000 RPM


2 NCR UPS(3,000KVA each)


2 unit processors LSI OR SYMBIOS


$7,000


$700 each

Prices from


No prices currently listed


Contact customer service for more details

Web Sites


Official web sites:


www.ncr.com


www.teradata.com


Oracle

Ryan Ostolski

Oracle Databases


Express Edition



Free for one database per machine


Built for small developers and students.


Standard Edition One



Either $149 per user with a minimum
of 5 users or $4995 per CPU with a maximum of 2 CPUs


Built for small to medium size businesses.


Standard Edition



Either $300 per user with a minimum of 5
users or $15,000 per CPU with a maximum of 4 CPUs


Built for medium size businesses.


Enterprise Edition



Either $800 per user with a minimum of
25 users or $40,000 per CPU


Built for any size business.

Oracle Features

(not available on all editions)


Proxy Authentication
-

Detects and authenticates
users connecting through a middle
-
tier application.


Automatic Memory Management
-

Automate
management of shared memory used by an Oracle Database
instance.


Data Compression
-

Compress data stored in relational
tables without impacting query time; reduce disk system
costs.