Get documents about "Database Principles and Design
Description
Database Principles and Design document sample
Document Sample
Domain Name Database
Component # Name Component Description Product Sub-Domain
Turnkey datamart/warehouse solution
includes hardware, storage, db and
DB Appliance datamodel Netezza
Components that allow client applications
to connect with DBMS systems
DB Connectivity ODBC
Components that allow client applications
to connect with DBMS systems
DB Connectivity JDBC
Components that allow client applications
to connect with DBMS systems
DB Connectivity OLE DB
Database Management Systems
DBMS Oracle
DBMS Database Management Systems Microsoft SQL-Server
DBMS Database Management Systems MS-Access
DBMS Database Management Systems DB2 (Mainframe)
DBMS Database Management Systems DB2 UDB (AIX)
DBMS Database Management Systems IDMS
DBMS Database Management Systems Hyperion Essbase
DBMS Database Management Systems MySQL
DBMS Database Management Systems NCR Teradata
DBMS Database Management Systems Informix
DBMS Database Management Systems DB2 UDB (I-Series)
Tools to affect configuration,
administration and support of the DBMS
environment that facilitate the database
DB Backup and manager ability to do his/her job.
Recovery Backup Exec
Tools to affect configuration,
administration and support of the DBMS
environment that facilitate the database
DB Backup and manager ability to do his/her job.
Recovery Quest Lightspeed
Tools to affect configuration,
administration and support of the DBMS
environment that facilitate the database
DB Backup and manager ability to do his/her job.
Recovery Veritas
Tools to affect configuration,
administration and support of the DBMS
environment that facilitate the database
manager ability to do his/her job.
DB Management Microsoft SQL Enterprise Manager
Tools to affect configuration,
administration and support of the DBMS
environment that facilitate the database
manager ability to do his/her job.
DB Management Oracle Entrpise Manager
Tools to affect configuration,
administration and support of the DBMS
environment that facilitate the database
manager ability to do his/her job.
DB Management Oracle Grid Control
Tools to affect configuration,
administration and support of the DBMS
environment that facilitate the database
manager ability to do his/her job.
DB Management Quest Spotlight
Tools to affect configuration,
administration and support of the DBMS
environment that facilitate the database
manager ability to do his/her job.
DB Management Toad
Tools to affect configuration,
administration and support of the DBMS
environment that facilitate the database
manager ability to do his/her job.
DB Management Enterprise Manager (Embarcadero co.)
Tools to affect configuration,
administration and support of the DBMS
environment that facilitate the database
manager ability to do his/her job.
DB Management Quest Foglight
Tools to affect configuration,
administration and support of the DBMS
environment that facilitate the database
manager ability to do his/her job.
DB Management ERWin (modeling tool)
Tools used to provide performance and
db activity statistics along with alerting
DB Monitoring mechanisms. Tivoli
Tools used to provide performance and
db activity statistics along with alerting
DB Monitoring mechanisms. Mercury Monitoring
Tools used to provide performance and
db activity statistics along with alerting
DB Monitoring mechanisms. Embarcadero + other 3rd party tools
Tools used to provide performance and
db activity statistics along with alerting
DB Monitoring mechanisms. Net-IQ
Infrastructure Road Map
Infrastructure Component Catalog (and Glossary) Final Component Product Standard Decisions (Future Architecture, Technology, Product Goals by Year)
Component Description Vendor + Product Version Life Cycle Comments Previous Today Year 1 Year 2 Year 3-5 Year 5+ Comments
Chosen State Period (Current)
Turnkey datamart/warehouse solution includes
hardware, storage, db and datamodel "Data warehouse
in a box". Includes
hardware,
software, DBMS
and storage. X Not in the
Used for BI type environment as of
applications. yet. Expected to
Lower cost possibly be
solution in some evaluated within 2
DB Appliance Netezza Evaluating cases. years.
Components that allow client applications to Connections to the
connect with DBMS systems DB for non-Java
based
applications. May
require driver
X
installations on Standard
client. The database access
specific driver is method. Will
determined by the remain so for the
DB Connectivity ODBC Various Mainstream backend DBMS. forseeable future.
Components that allow client applications to
connect with DBMS systems Connections to the
DB for Java based
applications. May
require driver
X
installations on Standard
client. The database access
specific driver is method. Will
determined by the remain so for the
DB Connectivity JDBC Various Mainstream backend DBMS. forseeable future.
Components that allow client applications to Primarly used by
connect with DBMS systems Microsoft visual
studio suite of
products.
Provides a direct Direct access
X
connection to the program method.
DB. The specific Will remain in use
driver is for several years.
determined by the ODBC/JDBC
DB Connectivity OLE DB N/A Containment backend DBMS. preferred.
DBMS Database Management Systems
High availablity,
High transaction
volume mission
critical or strategic X
client server Upgrade to 11g
applications (N- will be considered
tier, Fat Client, once 12g is
Oracle 11g Evaluating etc). released.
DBMS Database Management Systems
High availablity,
High transaction
volume mission
critical or strategic X
client server 10g to remain
applications (N- standard Oracle
tier, Fat Client, platform for at
Oracle 10g Mainstream etc). least 2 years.
DBMS Database Management Systems SQL Server 7 is
Mid-range web still within the
based environment and
applications. will be
X
Rapid discontinued with
development, the SQL Server
SQL Server 7 lower cost 2005 upgrade in
Microsoft SQL-Server SP4 Retirement alternative. 2008
Infrastructure Road Map
Infrastructure Component Catalog (and Glossary) Final Component Product Standard Decisions (Future Architecture, Technology, Product Goals by Year)
Component Description Vendor + Product Version Life Cycle Comments Previous Today Year 1 Year 2 Year 3-5 Year 5+ Comments
Chosen State Period (Current)
DBMS Database Management Systems SQL Server 2000
will be going out of
primary support
within 2008.
Mid-range web Applications non-
based X SQL Server 2005
applications. compatible will
Rapid remain on SQl
development, Server 2000 for
SQL Server lower cost the forseeable
Microsoft SQL-Server 2000 SP4 Containment alternative. future.
DBMS Database Management Systems Mid-range web
based
applications.
Rapid X
development, Mainstream SQL
SQL Server lower cost Server RDBMS for
Microsoft SQL-Server 2005 SP1 Mainstream alternative. the next few years.
DBMS Database Management Systems Mid-range web
based
applications. Will be released
Rapid X 2008. Will not be
development, mainstream in
SQL Server lower cost environment until
Microsoft SQL-Server 2008 Emerging alternative. next release.
DBMS Database Management Systems Multi-dimensional
OLAP database
used for complex
financial planning X
and what-if
analysis and
Hyperion Essbase System 9 Mainstream modeling.
DBMS Database Management Systems Small department
level applications
with less than 5
conurrent users.
X
Non-user facing
applications,
internal only. No For small limited
Microsoft Access Access 2007 Containment security. use applications.
DBMS Database Management Systems Limited to Primary DB2
mainframe mainframe
applications, no RDBMS for the
X
new non- next few years. V8
mainframe being installed
DB2 (mainframe) DB2 v8 Mainstream development 2008.
DBMS Database Management Systems Limited to
mainframe
applications, no Current DB2
X
new non- version. Will be
mainframe replaced with 8 in
DB2 (mainframe) DB2 v7 Retirement development 2008.
DBMS Database Management Systems Limited to existing
applications, no No current plans to
new development, upgrade as current
X
maintenance only. environment will
Legacy not support this
DB2 UDB (AIX) UDB v8 Evaluating datawarehouse. version.
DBMS Database Management Systems Limited to existing
applications, no
new development,
X
maintenance only. Current version
Legacy with no current
DB2 UDB (AIX) UDB v7 Containment datawarehouse. plans to upgrade.
DBMS Database Management Systems Non-relational Evaluating the
database, limited possibility of
new development X upgrading to
when required by version16 within
IDMS v 16.0 Evaluating application. the next 2 years.
Infrastructure Road Map
Infrastructure Component Catalog (and Glossary) Final Component Product Standard Decisions (Future Architecture, Technology, Product Goals by Year)
Component Description Vendor + Product Version Life Cycle Comments Previous Today Year 1 Year 2 Year 3-5 Year 5+ Comments
Chosen State Period (Current)
DBMS Database Management Systems Non-relational
database, limited
new development X
when required by Current IDMS
IDMS v 15.0 SP3 Containment application. version.
DBMS Database Management Systems
Open source,
lightweight DB.
Not for complex
data processing.
Used for small X
applications. (Sun For use in small
aquired MySQL environments.
and implemented Evaluating usage
2 phase within
MySQL 5 Evaluating transactions) environment.
DBMS Database Management Systems High volume
warehousing and
X
BI based
NCR Teradata Evaluating applications.
DBMS Database Management Systems Well known for
OTLP and High
X
availability
Informix 11.1 Evaluating processing.
DBMS Database Management Systems
Limited to AS400
applications, no
new non-
mainframe
development.
(This is used on
AS400 and is an
X
intrinsic part of
AS400 operating
system, cannot be
decoupled from
these AS400 No change in this
apps. As long as environment is
we have AS400 expected within
DB2 UDB (I-Series) v8 Containment apps, this will stay) the next few years.
DB Tools to affect configuration, administration and Compression
Backup/Recovery support of the DBMS environment that facilitate software used to
the database manager ability to do his/her job. backup SQL-
Server databases
to disk.
Compresses DB X Primary SQL
up to 85% of Server backup
original size. Used software. Will be in
in most of our mainstream usage
production for the forseeable
Quest Lightspeed 4.8.4 Mainstream environments. future.
DB Tools to affect configuration, administration and DB backup utility
Backup/Recovery support of the DBMS environment that facilitate for SQL-Server to
X
the database manager ability to do his/her job. move data copies Currently in use by
Backup Exec Containment to tape. the backup teams.
DB Tools to affect configuration, administration and
Backup/Recovery support of the DBMS environment that facilitate Used as a
the database manager ability to do his/her job. backup/recovery X
tool for SQL- Currently in use by
Veritas Containment Server and Oracle. the backup teams.
Infrastructure Road Map
Infrastructure Component Catalog (and Glossary) Final Component Product Standard Decisions (Future Architecture, Technology, Product Goals by Year)
Component Description Vendor + Product Version Life Cycle Comments Previous Today Year 1 Year 2 Year 3-5 Year 5+ Comments
Chosen State Period (Current)
DB Management Tools to affect configuration, administration and
support of the DBMS environment that facilitate Used to create DB,
the database manager ability to do his/her job. tablespace, index,
manage users,
schedule jobs,
manage security
and manage
overall SQL Server
X
environment. This
would be used to
manage our SQL-
Server database.
Also used for SQL-
Server process Management tool
Microsoft SQL SQL Server 7 and performance that is packaged
Enterprise Manager SP4 Retirement management. with SQL Server
DB Management Tools to affect configuration, administration and
support of the DBMS environment that facilitate Used to create DB,
the database manager ability to do his/her job. tablespace, index,
manage users,
schedule jobs,
manage security
and manage
overall SQL Server
X
environment. This
would be used to
manage our SQL-
Server database.
Also used for SQL-
Server process Management tool
Microsoft SQL SQL Server and performance that is packaged
Enterprise Manager 2000 SP4 Containment management. with SQL Server
DB Management Tools to affect configuration, administration and
support of the DBMS environment that facilitate Used to create DB,
the database manager ability to do his/her job. tablespace, index,
manage users,
schedule jobs,
manage security
and manage
overall SQL Server
X
environment. This
would be used to
manage our SQL-
Server database.
Also used for SQL-
Server process Management tool
Microsoft SQL SQL Server and performance that is packaged
Enterprise Manager 2005 SP1 Mainstream management. with SQL Server
DB Management Tools to affect configuration, administration and
support of the DBMS environment that facilitate Used to create DB,
the database manager ability to do his/her job. tablespace, index,
manage users,
schedule jobs,
manage security
and manage
overall SQL Server
X
environment. This
would be used to
manage our SQL-
Server database.
Also used for SQL-
Server process Management tool
Microsoft SQL SQL Server and performance that is packaged
Enterprise Manager 2008 Emerging management. with SQL Server
Infrastructure Road Map
Infrastructure Component Catalog (and Glossary) Final Component Product Standard Decisions (Future Architecture, Technology, Product Goals by Year)
Component Description Vendor + Product Version Life Cycle Comments Previous Today Year 1 Year 2 Year 3-5 Year 5+ Comments
Chosen State Period (Current)
DB Management Tools to affect configuration, administration and
support of the DBMS environment that facilitate Used to create DB,
the database manager ability to do his/her job. tablespace, index,
manage users,
schedule jobs,
manage security
and manage
overall Oracle
X
environment. This
would be used to
manage our
Oracle database.
Also used for
Oracle process Management tool
Oracle Entrpise and performance that is packaged
Manager 11g latest Evaluating management. with Oracle
DB Management Tools to affect configuration, administration and
support of the DBMS environment that facilitate Used to create DB,
the database manager ability to do his/her job. tablespace, index,
manage users,
schedule jobs,
manage security
and manage
overall Oracle
X
environment. This
would be used to
manage our
Oracle database.
Also used for
Oracle process Management tool
Oracle Entrpise and performance that is packaged
Manager v 10g Mainstream management. with Oracle
DB Management Tools to affect configuration, administration and Creation of DB
support of the DBMS environment that facilitate objects, stored
the database manager ability to do his/her job. procedures, SQL
statement tuning.
DBA's use this X Primary DBA
product for Oracle development tool,
DB, may also be outside of
3.2 for SQL used for other packaged
Toad Server Mainstream DBSMs software.
DB Management Tools to affect configuration, administration and Creation of DB
support of the DBMS environment that facilitate objects, stored
the database manager ability to do his/her job. procedures, SQL
statement tuning.
DBA's use this X Primary DBA
product for Oracle development tool,
DB, may also be outside of
used for other packaged
Toad 9.6 for Oracle Mainstream DBSMs software.
DB Management Tools to affect configuration, administration and Primary modeling
support of the DBMS environment that facilitate software for the
the database manager ability to do his/her job. X environment.
ERWin (modeling Data Modeling Upgraded Qtr 1
tool) 7.2 Mainstream tool. 2008.
DB Management Tools to affect configuration, administration and Highly
support of the DBMS environment that facilitate recommeded
the database manager ability to do his/her job. enterprise
management tool
for management,
monitoring,
performance
tuning, trouble
shooting. Could
X
be the
replacement for
Oracle Enterprise
Manager and Monitoring tool
possibly Microsoft used for Oracle
SQL Enterprise environment. Will
Manager. be installed with
Manages clusters Oracle 11g
Oracle Grid Control 11g Evaluating and virtualization. RDBMS.
Infrastructure Road Map
Infrastructure Component Catalog (and Glossary) Final Component Product Standard Decisions (Future Architecture, Technology, Product Goals by Year)
Component Description Vendor + Product Version Life Cycle Comments Previous Today Year 1 Year 2 Year 3-5 Year 5+ Comments
Chosen State Period (Current)
DB Management Tools to affect configuration, administration and Highly
support of the DBMS environment that facilitate recommeded
the database manager ability to do his/her job. enterprise
management tool
for management,
monitoring,
performance
tuning, trouble
shooting. Could
X
be the
replacement for
Oracle Enterprise
Manager and
possibly Microsoft Monitoring tool
SQL Enterprise used for Oracle
Manager. environment.
Manages clusters Installed Qtr 2.
Oracle Grid Control 10g Emerging and virtualization. 2008.
DB Management Tools to affect configuration, administration and Active monitoring
support of the DBMS environment that facilitate tool works with
the database manager ability to do his/her job. Oralce and SQL- Used to monitor
Server. Designed X COE SQl Server
to deep dive into environment. 1
performance license within the
Quest Spotlight 2 Containment issues. environment.
DB Management Tools to affect configuration, administration and Platform
support of the DBMS environment that facilitate independent DB
the database manager ability to do his/her job. monitoring tool for
performance. Use
X
for Oracle DB in Monitoring tool for
the past (Wendy). an enterprise
Enterprise Manager Also used for SQL- environment.
(Embarcadero co.) Evaluating Server (Tom). Similar to Foglight.
DB Management Tools to affect configuration, administration and
support of the DBMS environment that facilitate Enterprise level
the database manager ability to do his/her job. monitoring tool for Monitoring tool for
DB and X an enterprise
Application service environment.
level monitoring. Similar to
Quest Foglight v5 Evaluating Like Tivoli. Embarcadero.
DB Monitoring Tools used to provide performance and db Enterprise scale
activity statistics along with alerting monitoring tool,
mechanisms. includes alerting
mechanisms and
archiving tools.
Has plug ins for
SQL-Server,
X
Oracle and UDB
rdbms. Has
connections into Primary monitoring
helpdesk ticket tool for RDBMS
processes and enviroments. Will
monitors active DB be in use for the
Tivoli v5 Mainstream processes. forseeable future.
DB Monitoring Tools used to provide performance and db
activity statistics along with alerting Site Scope tool.
mechanisms. Monitors SQL-
Server, Oracle
X
RDMS and others.
Also monitors
operating system
Mercury Monitoring v 8.5 Emerging service levels.
DB Monitoring Tools used to provide performance and db
activity statistics along with alerting Requires agent
mechanisms. install on
computer. Used X
for SQL-server.
Passive monitoring
Net-IQ Retirement tool for alerting. Retiring.
Infrastructure Road Map
Infrastructure Component Catalog (and Glossary) Final Component Product Standard Decisions (Future Architecture, Technology, Product Goals by Year)
Component Description Vendor + Product Version Life Cycle Comments Previous Today Year 1 Year 2 Year 3-5 Year 5+ Comments
Chosen State Period (Current)
DB Monitoring Tools used to provide performance and db
activity statistics along with alerting Potential for Single
mechanisms. DB Monitoring
X
tool. Needs
Embarcadero + other further evaluation
3rd party tools Evaluating on functionality.
Netezza Emerging
Infrastructure Road Map
Infrastructure Component Catalog (and Glossary) Key Pattern/Services Mappings Final Component Product Standard Decisions (Future Architecture, Technology, Product Goals by Year)
Dom. Domain Component Description Examples Key Key Dept Vendor + Version Approval Life Comments Previous Today Year 1 Year 2 Year 3-5 Year 5+ Comments
# (Vendors and Products) Pattern Service Owner Product Rating Cycle Period (Current)
Chosen State
5 Database Database Software that enables applications to access a IBI EDA/SQL, Sybase OmniSQL, OLE 3/N-Tier Transact Transactional
Gateway variety of back-end DBMS-based data, DB and ODBC drivers Integration
transforming calls into native calls for each
DBMS supported.
5 Database DBMS Software that stores data in formats that allow for Oracle, Sybase, Ingres, IBM DB2, 3/N-Tier Transact Database
easy and fast retrieval along with efficient writing Microsoft SQL Server, NCR Teradata,
of data for transact patterns, or for decisional Hyperion
query analysis in publish patterns. Often
relational in structure (RDBMS).
5 Database Extract/Tran Provides the data extraction functionality Informatica, Ardent 3/N-Tier Transact Database
sform necessary to extract information from production
Software systems and then cleanse/transform to the
format for the decisional publish applications.
5 Database Search Indexes, searches, and retrieves content across Verity Web Publish Content
Engine Web sites. Integration
5 Database Voice Software that enables voice mail and messaging Octel, Centigram, Lucent Real-Time Voice
Messaging (including storing that data type). Collaborate
Store
9f8150b7-6b85-4df6-a0c8-980879763182.xls
PATTERN NAME 3/N-Tier Transaction Pattern
Pattern Definition Presentation, data access and busienss logic partitioned
Diagram
Owner Name, Dept. Bob Smith, Architect
Date Last Update 10/10/2007
Document Creator Bob Smith, Architect
Date of Next Update 10/1/2008
Hosting/Sourcing
Strategy TBD
Cost/Pricing Determine after first few implementations
Application Examples SAP R/3 and Siebel CRM
ETA Principles (implications of principles, etc.)
Principle #1 Stateless farm design (except database management)
Principle #2 Mulitpoint interface (Web and interactive voice response)
Use Case Matches
Who Anyone
Use
Where Anywhere
Cases What
Transactional applications
Service-Level Matches
Scalability - (more than 500 users)
SLMs Changing presentation logic
Integrating sources/consumers with the application
Slow speed of initial deployment
Manifest (by domain)
Domain Architecture Technology Product Configuration
Application (Tool)
API Domain Ent Javabeans, J2EE
Presentation Apache
Application Server Web framework Websphere
M
a Integration EAI standards
n Database Oracle V8i
i
Platform (Server/Client
f
HW/OS) Linux on Compaq Suse Linux
e
s Storage SAN EMC SAN
t Network WAN with CoS Cisco, ATT
Security
Management IBM Operational Services
ETA Pattern Template Gartner Confidential Page 10
9f8150b7-6b85-4df6-a0c8-980879763182.xls
PATTERN
Transaction Pattern NAME
Pattern Definition
ogic partitioned
Diagram
Owner Name, Dept.
Date Last Update
Document Creator
Date of Next Update
Hosting/Sourcing
Strategy
Cost/Pricing
Application Examples
implications of principles, etc.)
management) Principle #1
Principle #2
voice response)
se Case Matches
Who
Use
Where
Cases What
Service-Level Matches
SLMs
pplication
nifest (by domain)
Server OS/HW
Domain
Platform
Application (Tool)
API Domain
Presentation
Application Server
M
a Integration
n Database
i
Platform (Server/Client
f
HW/OS) Compaq 2400
e
s Storage EMC DMX
t Network Cisco 8500
Security
Management
ETA Pattern Template Gartner Confidential Page 11
9f8150b7-6b85-4df6-a0c8-980879763182.xls
SERVICE NAME Identity infrastructure services
Service Definition
Providing user identity information (atrtributes), including authentication credentials and related
single sign-on services
Diagram
Owner Name, Dept Sally Jones, architect
Date Last Update 10/10/2007
Document Creator Sally Jones, architect
Date of Next update 10/1/2008
Interface/Process
Change Authority
Service Design Overview
Maturity Installed since 2001
Hosting Internal hosting
Volatility Changed by release quarterly
ETA Principles (Implications of Principles, Etc.)
Principle #1 Simple authentication usually sufficient
Principle #2 Replication to scale (mostly read-omly)
Use Case and Service-Level Matches
Who Direct use by application (lightweight directory access protocol)
Where Anywhere
What
Indirect use via Web server (with attribute passing in headers)
Use
Direct use by application (security APIs)
Cases Specific Use Case
Scenarios (Functional
Definition)
Potential Users/Apps/
Patterns
Service-Level Matches
Scalability - (more than 500 users)
SLMs Scale incrementally using replicas
Direct application support
ETA Service Template Gartner Confidential Page 12
9f8150b7-6b85-4df6-a0c8-980879763182.xls
SERVICE NAME Identity infrastructure services
Manifest (By Domain)
Server OS/HW
Domain Architecture Technology Product Configuration
Platform
Application (Tool)
API Lightweight Directory Access Protocol, Web Server exits
Presentation
M Application Server
a
Integration Meta-Directory Utilities
n
i Database
f Platform (Server/Client
Sun Solaris on
e HW/OS)
SPARC
s
Storage
t
Network
Security Single Sign-on Netegrity SiteMinder
Management
Manifest (By Operational Process/Service)
Process #1
Process #2
ETA Service Template Gartner Confidential Page 13
Enterprise Technology Architecture
Current State Components With Road Map
Current State Technology
Component Products Component Road Map
Component Catalog
Domain Component Description Owner Vendor + Life Cycle Comments Today Years 1-3 Comments
Product s Status (Current)
9f8150b7-6b85-4df6-a0c8-980879763182.xls
Services Catalog
Category Service
Description Example
or Domain Name
Network LAN Local-area network (very fast networking implemented Ethernet with switches and routers
internally with owned equipment and wire).
Network WAN Wide-area network (usually slower and higher-latency Frame relay or T1 services from AT&T
network implemented by service providers and "rented" by or other service providers, plus routers
enterprises). to connect into the services
Network Remote Single-user access networks (slow and higher-latency with VPN equipment/software with modem
Access wide variations in last-mile connection speeds from modems service from UUNet or other service
at up to 58Kbps to DSL and cable for speeds significantly providers, etc.
higher than this. In the past, often implemented on internally
built and owned modem banks, now increasingly leveraging
VPN solutions for encryption and service providers for
connectivity.
Network Voice Voice is another network or communication service, but PBX, cabling, voice mail, etc. plus
convergence with the data networking services has access to outside phone services for
remained problematic. voice calls
PresentationHTML HTML: The combination of standard Web browser, Web Web servers front-ended with network
server, caches, etc. that together are treated as a service by load balancers — could look a lot like
the application. The application generates HTML, and the Web hosting, but that might include
HTML service renders it. This or an evolved version of it more than just HTML services (DB,
would include additional Web edge devices/services to security, etc.)
improve service levels, including HTTP caching, using CDN
services, ISP link bandwidth, network load balancers of
various types, on-the-fly device-specific compression,
encryption services (SSL-izing), etc.
PresentationPortal Portal: Adds profile, personalization, and portlet services to BroadVision or Vignette products
HTML service.
PresentationDevice Device: Presentation services for nonstandard browsers, See 3GPP's Open Service Access
mobile devices, etc. Generic User Interaction Service
Capability Feature 3GPP TS 29.198-5,
a user interaction service for 3rd
Generation wireless devices
(www.3gpp.org)
PresentationDesktop Desktop: Some organizations consider the desktop itself a Desktop services for five common
service, but it is not literally implemented once for all desktop types
applications; with many locations, the standards for
infrastructure technology as well as help desk and
applications are often bundled into a service IT offers to the
business.
Security These are some of the first services to be intermediary-
based — that is, the service sits between the app and the
network (the service is not explicitly invoked by the app).
Security Identity Identity: Authentication, nonrepudiation (could include SSO, Directory service with WebSSO
will need a directory service).
Security Isolation Isolation: Encryption, anonymity (including firewall, NAT, Firewall with full DMZ architecture
etc.).
Security Permission Permission: Access control, authorization, etc. Separate permissions management
(the larger part of what the WebSSO
products provide for a multivendor set
of Web servers)
ETA Service Catalog Gartner Confidential Page 15
9f8150b7-6b85-4df6-a0c8-980879763182.xls
Services Catalog
Category Service
Description Example
or Domain Name
Integration Transactional Transactional: Enterprise application integration (EAI), inter- Products like IBM MQSI or SeeBeyond
enterprise integration (IEI).
Integration Analytic Analytic: ODS (operational data store), DW (data Data warehouses and data marts
warehouse), enterprise reporting.
Integration Content Content: WebDAV (Web Distributed Authoring and Some portals do content integration
Versioning), ICE (Internet Content Exchange)
Storage SAN SAN: Storage-area network. A major example of the Products from EMC, Compaq and
evolution from component, to internal subsystem, to external many others
subsystem, to LAN service, to WAN service, to full-service
provider model. All enabled by putting a network between
the client and service interfaces.
Storage File System File system: NAS (network-attached storage). Another NOS solutions like NetWare and NT or
example of moving the implementation of a service (file NFS storage solutions, whether
system) out of the OS and over a network. NOS is another applianced or not
example — not just on the device itself, but over a network;
an NOS includes printing, etc.
Storage Database Database: Another example of a service that is network- Oracle, SQL Server and many others
based but not as often shared across multiple applications.
ETA Service Catalog Gartner Confidential Page 16
9f8150b7-6b85-4df6-a0c8-980879763182.xls
Patterns Catalog
Category Pattern Name Description Example
Transact 1-Tier Transact 1-Tier Transact: These are batch-processing applications or Host access over tn3270
OLTP applications without logical abstraction between protocol through gateways (or
presentation, application and data logic. Although the application direct over SNA networks) to
itself is fully centralized, users may be widely distributed, due to mainframes (or other terminal
the wide-area network (WAN) friendliness of terminal traffic. systems like Unix or AS/400
boxes)
Transact 3/N-Tier 3/N-Tier Transact: This is a thin presentation-logic-only client SAP R/3 or PeopleSoft v8 or
Transact communicating with a client-neutral, server-based application things built on BEA WebLogic
logic, which in turn communicates with a back-end database or IBM WebSphere application
server. It is the most scalable and flexible client/server (C/S) servers (if done correctly)
pattern. Due to the WAN-friendliness of the client to application
server protocols, users can be highly decentralized. When
implemented correctly, the 3/N-Tier Transact pattern results in
clearly defined interfaces, making it the most flexible to integrate
with other applications or points of interaction.
Publish Client/Server Client/Server Publish: This pattern is defined by the use of a fat- Specific data mining tools that
Publish client technical component (e.g., a sophisticated business allow for graphical analysis of
intelligence client) and associated session-oriented protocol (e.g., datasets, usually connected
SQLNet) between the client and back-end database. This pattern directly to an optimized
is best used for implementing sophisticated data analysis database back end
capabilities to a small, well-defined user base.
Publish Web Publish Web Publish: This pattern is defined by the use of an HTML Common Web sites for
browser interacting through the HTTP protocol to enable read- advertising with mostly read-
only access to structured (i.e., XML, HTML, etc.) documents. As only content, including
such, it is more flexible than the C/S Publish pattern in supporting firewalls, file servers, Web
large, less defined user bases, but is limited (due to HTML/HTTP servers, etc.
technical limitations) in the sophistication of read-only
interactivity/analysis it can support.
Publish Stream Publish Stream Publish: The business use case for this pattern is for real- Real audio or IP-TV servers
time publishing of streaming content (i.e., audio, video, text, etc.) with multicast capabilities in
to "player" (i.e., Windows Media Player, Real Audio, etc.) clients. networks
Although the Web Publish pattern previously discussed enables
downloading (HTTP as a file transfer protocol) of multimedia
content to be played later, the latency requirements of real time
(i.e., broadcasting a live Webcast) are different enough that
streaming requires a separate pattern.
Collaborate Real-Time Real-Time Collaborate: The infrastructure necessary to support Phone systems, two-way video
Collaborate this pattern will be similar to the infrastructure supporting the (either dedicated systems or
Stream Publish pattern, because both will involve enabling real- desktop), voice over IP, etc.
time transmission of information (i.e., audio, video, chat, voice, with special networking
etc.). However, because collaboration involves bidirectional settings for latency and jitter
transmission (versus one-way publish transmission), real-time control as well as multicast
collaboration warrants its own separate pattern.
ETA Pattern Catalog Gartner Confidential Page 17
9f8150b7-6b85-4df6-a0c8-980879763182.xls
Patterns Catalog
Category Pattern Name Description Example
Collaborate Store and Store and Forward Collaborate: The use case for this pattern is NetWare and/or NT for file
Forward ad hoc sharing of documents (i.e., using the store and forward and print plus Exchange or
Collaborate characteristics of e-mail to transfer attachments between Notes for e-mail along with
members of a workgroup). Although easy to implement (and some desktop standards for
widely used for collaboration), the technical components used to hardware and software (MS
implement this pattern (i.e., SMTP, NNTP) offer little in the way Office) and software
of integrity enforcement/version control, forcing users of the distribution (SMS, etc.)
application to keep track of these variables themselves (i.e., the
infamous, "Who has the latest .ppt version?" problem).
Collaborate Structured Structured Collaborate: Structured collaboration (aka workflow or Documentum for document
Collaborate document management) implements the collaborative integrity management
functionality (version control, check-in/check-out, data validation)
the Store and Forward Collaborate pattern lacks. For this reason,
it is more scalable (from a business perspective) for business
use cases requiring these capabilities, but also requires a longer
implementation cycle and is several times more expensive.
ETA Pattern Catalog Gartner Confidential Page 18
9f8150b7-6b85-4df6-a0c8-980879763182.xls
Domain Glossary
Domain Example
Domain Name Definition
Type Components
Application Application Application technology (not business Application development tools (Java dev
Tools logic or function) including specific tools, Visual Basic, C++, etc.), debugging and
development tools, packages etc. testing tools, compilers, etc. Actual
Sometimes, applications too are applications are better described not as
viewed as infrastructure, but the technology but as solution domains and/or
application code for business logic is components - architects should flesh those
NOT included as other infrastructure; items out in an Enterprise Solutions
some planners include office Architecture (and/or application portfolio
productivity tools (office, e-mail, etc.) structure).
as infrastructure because they are so
completely standardized and stable
and no longer managed or planned
by application developers.
Infrastructure API Technology that models new APIs or Intra-API, Inter-API and Infra-API services
techniques that ensure best API use. (including UML modeling tools like Rational
Rose) including Web services technologies
Infrastructure Presentation Technology that provides points of Web Server, IVR and WAP or Mobile
interaction (POI) or different Application Server
presentations of data.
Infrastructure Application Application server software that Application Server
Server executes business logic.
Infrastructure Integration Enterprise application integration Integration Server, Inter-Enterprise Integration
Server (EAI) software that connects different (IEI) Server
applications together, reformatting
and routing data as necessary.
Infrastructure Database Software that stores data for efficient DBMS, Data Access Middleware
Server record and field-level retrieval along
with data access and gateway
functions.
Infrastructure Platform Server as well as client hardware, Application Server HW and OS and HA, Web
(Server/Client operating system and high-availability Server HW and OS and HA, desktop choices
HW/OS) (HA) solutions. for this as well
Infrastructure Storage Hardware including disk and tape Storage Server, Business Continuance SW
approaches along with software for
backup and recovery.
Infrastructure Network Hardware, software and services WAN Access Product (router), Campus
providing connectivity between Equipment
devices.
Infrastructure Security Hardware, software and services Security solutions like WebSSO or directory
providing authentication, servers
authorization and encryption.
Infrastructure Management Hardware, software and services Management solutions including element
providing management of managers (that could have been noted in
components and services. separate domains but collected here) and
frameworks (HP OpenView, etc.) as well as
service-level management solutions (SLA
monitors, etc.) that really apply to the whole
infrastructure across all domains
Note: We have dropped in 2002 the terms "platform" and "platform layers" — these are now called just "domains."
Note: We have stopped "strata grouping" the layers (now domains) — they could apply, but may be confusing.
Strata All elements providing interaction by
people or programs to infrastructure
Interface and applications. API, Presentation
All elements dealing with data
manipulation including logical
storage, exchange, transformation Application Server, Integration Server,
Functional and workflow. Database Server
All elements dealing with the tasks of
physical connectivity, storage and
Physical processing. Server, Storage, Network
Other Security, Management
ETA Domain Catalog Gartner Confidential Page 19
Database specific tools such as SQL-Loader, SQL-Plus and
database specific languages such as PL/SQL will be
covered by application domains.
Things like Indexing will not be covered within this domain.
The team agreed that DB2 Connect, Oracle Client, etc
would not be addressed in the component catalog for this
pass through of the domain definition. Generally installed in
order to get the ODBC drivers.
Web services to connect to DB outside of this domain
scope because it will connect via ODBC or some other
method.
Principle for data domain - reduce redundancy and
fragmentation of data across multiple applications.
Related docs
Other docs by npk11277
Database Systems a Practical Approach to Design, Implementation, and Management
Views: 4 | Downloads: 0
