ENTERPRISE SOFTWARE
- S3-CISPUB^TM
-- System Overview
-- Standard Modules
-- Additional Modules
-- Support Services
-- Technical Overview
-- Online Brochures
-- Business Partners
-- Clients
-- Request More Info

Technical Overview...

S3-CISPUB^TM operates in a client-server environment on Microsoft NT or UNIX, and uses a powerful IBM server Relational Database Management System (RDBMS).

Microsoft NT has proven itself as a reliable, secure, easy-to-use and scalable network operating system. It is generally regarded as a strong network foundation for the new generation of business applications. Its built-in network utilities, protocols and services make it easy to administer and provide an infrastructure for powerful client-server applications such as S3-CISPUB^TM.

UNIX has proven itself as a reliable, flexible operating system to support S3-CISPUB^TM's robust functionality and offers users a wide range of advanced hardware options from many different manufacturers. In addition, UNIX's long-term viability protects your investment in applications and training.

The IBM Universe RDBMS is an ideal database for Windows NT and UNIX. It is both flexible and compliant across many industry standards. It offers all of the features required to support today's complex business environments, including:

IBM Universe Features:

Administration Online backup by record, file, table, database
  -  Warm-start recovery
  -  Support for high-availability disk subsystems
  -  Easy-to-use, menu-driven and GUI administration tool

Large Database Support
  -  Horizontal table partitioning
  -  Multiple segment table support
  -  High-speed bulk-data loader
  -  Parallel Index build

SQL Implementation
  -  ANSI SQL 1989 level 2 compliant
  -  ANSI SQL 1989 integrity enhancements
  -  ANSI SQL 1992 entry level compliant
  -  ODBC 2.0 core level API
  -  Robust SQL extensions
  -  ANSI declarative entity and referential integrity constraints (Business Rules)

Concurrency Control
  -  Contention-free queries
  -  Table and row level locking
  -  ANSI 1992 Isolation levels (1-4)
  -  Implicit/explicit lock management

Database Characteristics
  -  Collection types
  -  Variable length columns and rows
  -  Automatic table space management
  -  Clustered tables and indexes
  -  Automatic unique indexes by primary key
  -  Hash indexes
  -  NF2 extensions
  -  B-Tree secondary indexing
  -  Calculated column definitions
  -  Cost-based/rule-based optimization

National Language Support
  -  Supports Unicode standard
  -  Accommodates single or multi-byte characters simultaneously
  -  Per session control of character mapping and national conventions
  -  Support for national conventions, including date/time, monetary, collate, casing and numerics

Transaction Management
  -  Automatic roll forward and roll back
  -  Journaling (pre-image)
  -  Selectable ANSI 1992 Isolation levels (1-4)
  -  Deadlock detection and resolution
  -  Transaction logging
  -  Check-pointing and warm-start recovery

SQL Procedures
  -  Shared, compiled form
  -  Easy-to-use BASIC
  -  Nested transactions
  -  Appropriate isolation levels
  -  Callable from all development interfaces
  -  Multiple, parallel procedure execution
  -  Interactive debugging facilities
  -  ODBC and RPC interfaces to execute remote stored procedures

Database Triggers
  -  Fired once per flow after any file I/O operation, including INSERT, UPDATE and DELETE
  -  Support for BEFORE, AFTER, ENABLE and DISABLE syntax
  -  Uses the UniVerse BASIC stored procedure language
  -  Modeled on ANSI SQL3 specification

Distributed Database
  -  Full location transparency
  -  Transparent multi-site distributed queries
  -  RPC-based remote execution of stored procedures
  -  TCP/IP networking

Data Replication
  -  Publication and Subscription methodology
  -  Automatic multi-site, multi-table replication
  -  Continuous or snap shot (stored-and-forward) options
  -  Hot standby mode

Programmatic ODBC Gateways
  -  Supports any ODBC 2.0 compliant driver
  -  Available for Windows NT and UNIX ODBC driver managers
  -  Relational, non-relational data sources

Interfaces
  -  Windows 16- and 32-bit ODBC drivers
  -  100% pure Java Class library - JDK 1.1.5 or higher
  -  Works with Web servers using CGI, ActiveX, Java environments
  -  ActiveX control (OCX)
  -  Native call-level interface (CLI) for UNIX and 32-bit Windows
  -  Function call interface

Development Tools
  -  Visual Basic
  -  Visual C++, Visual J++
  -  Visual Café
  -  Delphi, J Builder
  -  PowerBuilder, PowerJ
  -  Any Java IDE or ActiveX- or ODBC-enabled tool

Migration Utilities
  -  Popular RDBMS's
  -  Advanced Revelation 4GL
  -  Hierarchical DBMS's


For more information about IBM Universe and other IBM products, visit their web-site at: www.ibm.com.

Welcome  | Products & Services  | Customer Support
Online Brochures  | About Us  | Search

© 2001-2002 S3 Publishing Technologies, Inc. All Rights Reserved.