business, the most important asset is their business data. Therefore it is critically
important to have reliable data management software. Features typically sought are quick
and reliable information retrieval data manipulation, applications that understand this
data and are easy to use, concurrent access by a number of users, and the ability to scale
upwards along various dimensions as the business grows.
Universal Database Version 7.1
DB2 Universal Database Version 7.1 from IBM is stated to be the "the most
powerful solution of its kind in the industry"
Makes operations easier for Dot.coms and large corporations involved in
B2BHelps gain competitive insight about customers
Takes 50% less deployment time
Runs searches 10 times faster than traditional relational database engines
Corporates using DB2 Universal database
Version 7 for business-to-business and emerging e-marketplace applications include:
Global Freight Exchange (GF-X),
Product features and new enhancements
The industry's first and only integrated, in-memory relational database
technology, designed to dramatically speed up text search for Web applications.
Deep XML integration to facilitate data interchange in support of B2B
applications. Integrated, scalable warehousing and data analysis features for fast and
easy deployment of business intelligence solutions.
Integrated support for spatial data allowing companies to visually tie customers
or operations to location, making it easier to analyze data in applications such as
Customer Relationship Management.
Industry-standard SQL Stored Procedure Language for developing applications to
ease migration to DB2 Universal Database from competitors such as Oracle, Microsoft,
Sybase and Informix.
Just as the Internet is changing the way
companies use and access information, Oracle8i changes the way information is managed.
Oracle8i is designed specifically to support the demanding requirements of Internet
applications. From development to deployment, Oracle8i offers unparalleled, revolutionary
functionality to web-enable your business.
Oracle8i, the database for
Internet computing, changes the way information is managed and accessed to meet the
demands of the Internet age, while providing significant new features for traditional
applications. Using solutions developed and deployed with Oracle8i, any
organization can exploit the unlimited opportunities the Internet provides.
Oracle8i provides advanced tools to manage all data
found in todays most popular web sites and the performance and scalability
needed to support these sites and other applications. Oracle8i delivers
unprecedented ease-of-use, power, and price/performance for workgroup or department-level
applications. From single-server environments for small businesses to highly distributed,
branch environments, Oracle8i includes all the facilities necessary to build
business-critical applications. In todays fast-paced business climate, application
developers must produce advanced applications quickly to meet ever-changing needs.
Oracle8i introduces additional support for
Java todays most Machine (VM) within the server. This expands Oracles
support for Java into all tiers of applications, allowing Java programs to be deployed
where they perform best in the client, server, or middle tier without
recompiling or modifying the Java code. Oracle8i also includes Oracle WebDB, a
browser-based application development, deployment, and management toolset that makes it
easy and inexpensive to web-enable a business. Oracle8i is much more than just a
simple relational data store. Having invented the relational database, Oracle continues to
lead and revolutionize the database industry by introducing Oracle iFS and Oracle interMedia
with Oracle8i. Oracle iFS, the Internet file system, combines the easy-to-use
functionality of a file system with the advantages of all data in a single server
data integration with the cost savings of a single server. Oracle8i also introduces
Oracle interMedia, which allows businesses to manage and access multi-media data,
including image, text, audio/video, and spatial data.
- XML SUPPORT
- ORACLE WEBDB FOR DEVELOPING WEB-BASED
- PRODUCTIVE DEVELOPMENT
- CONTENT MANAGEMENT FOR INTERNET
- ORACLE iFS (INTERNET FILE SYSTEM)
- ORACLE interMEDIA
- EASY INSTALLATION
- EASY DATABASE MANAGEMENT
- DATA DISTRIBUTION
- OPEN DATA ACCESS
- OPTIMIZED FOR THE OPERATING SYSTEM
Key Features :
- APPLICATION DEVELOPMENT
- NATIONAL LANGUAGE SUPPORT
- CONTENT MANAGEMENT
- TRANSACTIONAL PROCESSING
- LARGE DATABASE SUPPORT
- HIGH AVAILABILITY
- SYSTEM MANAGEMENT AND EASE OF ADMINISTRATION
- CONCURRENT CONTROL AND RELAIBLE RESULTS
- TRANSCATIONAL DATA ACCESS
- DISTRIBUTED QUERIES AND TRANSACTIONS
- DATA REPLICATION
- LARGE OBJECTS
- DATA SECURITY
- PROGRAMMING INTERFACES
More information : www.oracle.com
Benefits of DB2
Linux has quickly
become the most talked about platform for e-business -- and with good reason. Linux offers
users stability, functionality and value that rivals any platform in the industry.
Millions of users world-wide have chosen Linux for applications from web and e-mail
servers to departmental and enterprise vertical applications.
Now you can combine the power of Linux with the
world's most trusted database for e-business, IBM's DB2! DB2 Universal Database for Linux
offers unmatched Internet functionality. The DB2 Control Center offers administrators an
easy to use interface for maintaining databases that can be run from any Java-enabled Web
browser. For Java developers, DB2 Universal Database for Linux offers support for JDBC and
SQLJ, and Net.Data allows for the creation of dynamic data driven Web applications. Perl
developers can also take advantage of DB2 Universal Database Perl driver for the Perl
DB2 for Linux for
As the foundation for e-business, DB2 Universal Database is the industry's first
multimedia, Web-ready relational database management system, strong enough to meet the
demands of large corporations and flexible enough to serve medium-sized and small
businesses. With Version 6.1, DB2 Universal Database for Linux provides significant
enhancements to ease the development of e-business applications. Some of the features
included in the new DB2 Universal Database Version 6.1 for Linux are:
- Ease of Administration Enhancements - including
the new Index Smart Guide and performance monitor.
- Application Development Enhancements - including
enhanced UNICODE support, and increased table/column limits.
- OLE DB Container Support - providing access to OLE
DB data sources such as Microsoft Access.
- DB2 Connect Enhancements - such as connection
pooling for deployment of large-scale Web-based applications.
More information : www.ibm.com
MySQL is a true
multi-user, multi-threaded SQL database server. SQL (Structured Query Language) is the
most popular and standardized database language in the world. MySQL is a client/server
implementation that consists of a server daemon
mysqld and many different
client programs and libraries.
SQL is a standardized language that makes it easy
to store, update and access information. For example, you can use SQL to retrieve product
information and store customer information for a web site. MySQL is also
fast and flexible enough to allow you to store logs and pictures in it.
The main goals of MySQL are
speed, robustness and ease of use. MySQL was originally developed because
we needed a SQL server that could handle very large databases an order of magnitude faster
than what any database vendor could offer to us on inexpensive hardware. We have now been
using MySQL since 1996 in an environment with more than 40 databases
containing 10,000 tables, of which more than 500 have more than 7 million rows. This is
about 100 gigabytes of mission-critical data.
The base upon which MySQL is
built is a set of routines that have been used in a highly demanding production
environment for many years. Although MySQL is still under development, it
already offers a rich and highly useful function set.
more information : www.mysql.org
Sybase Adaptive Server Enterprise for Linux
Adaptive Server Enterprise
version 11.9.2 Development Kit is now available on the Linux operating system. By porting
ASE to Linux, Sybase provides the Linux development community with the first highly
scalable, high-performance database engine available for the platform. The package
includes the standard features of Adaptive Server Enterprise and all related connectivity
Sybase Adaptive Server Enterprise for Linux is designed to
support the demanding requirements of traditional, mission-critical OLTP and DSS
applications, as well as the evolving requirements of Internet applications. Sybase has
built a reputation for exceeding the demands of mission-critical enterprise business
applications, providing database reliability, integrity, and performance. The efficient
multi-threaded architecture, internal parallelism, and efficient query optimization of
Adaptive Server Enterprise for Linux deliver unsurpassed levels of performance and
The newest release, Adaptive Server Enterprise for Linux version 11.9.2, builds upon this
solid foundation. It extends these capabilities to applications designed to support
personalized customer access to business systems via enterprise information portals with
the delivery of information and management of business transactions.
The adaptive Server Enterprise provides the following locking
Data-Page Locking:Performs page locking on the data page and no transaction duration locks
on the index pages.
Data-Row Locking: Provides true row-level locking in data pages (similar to
Oracle/Informix row-level locking);
All-Page Locking:Holds transaction duration locks on both data and index pages (existing
Adaptive Server Enterprise locking).
Sybase offers a strategy that locks only the data pages, without locking the index
pages.This capability eliminates locking contention for many applications and can greatly
increase concurrency. Some of the benefits of this style of index locking
include:Transaction-duration locks in data pages only locks are not held on index pages
which dramatically increases concurrency;Index modification done as nested top actions
index modifications are performed under non-transactional locks Duplicate key values
stored only once in indexes:Storage of duplicate keys is eliminated which can save both
disk and memory space.
Broadest range of applications supported.
Many existing applications require additional locking strategies beyond
page-level locking to provide higher degrees of concurrency and performance. There
are a number of applications that can benefit
from Adaptive Server Enterprises support for row-level locking Packaged
applications realize significant performance improvements Applications developed using
pessimistic locking strategies; Applications that require concurrent inserts, such as a
database storing real-time feeds from multiple sources; or a data warehouse that requires
parallel loading of data while an index is in place.
Optimized for Mixed-Workload Predictability
The Logical Process Manager (LPM) allows you to assign CPU resources to individual
applications so low-priority work does not impact high-priority work, ensuring more
predictable performance.Together, the LMM and LPM give you the flexibility to support
resource-intensive operations, such as report generation, without adversely affecting the
performance of mission-critical applications.
Breakthrough Power and Performance
Clustered indexes ensure fast row
retrieves and updates
Parallel querying including joins, scans,
and aggregates improve response times
Parallel utilities including sort, index
creation, backup, recovery and loading
enhance data availability
Asynchronous pre-fetch maximizes query
Tunable block I/O improves performance
by reducing physical I/O
Table partitioning enables parallel
Adaptive Server Enterprise can be configured to spawn multiple engines on an SMP
system, allowing even distribution of client connections across all engines. The engines
also handle disk access
on their own, providing near-linear scaling with the incremental addition of users.
Internal parallelism including parallel query execution, parallel sort, and
parallel utilities is optimized for the SMP environment.
Multiple threads and engines are used to carry out a single query in order to enhance
response times. A parallel query can be completed up to fifteen times faster than the same
serial query. By using the
most appropriate degree of parallelism, the parallel-aware optimizer achieves the
fastest response time.
Query Processing Improvements
CREATE INDEX allows specifying ascending or descending ordering for each index
key, allowing the stored order of the index to reflect the order used most frequently in
queries. This feature reduces the sorting required for many queries using ORDER BY;
Running UPDATE STATISTICS on tables using the new locking strategy will
experience greatly reduced locking contentions; More columns per index
Adaptive Server Enterprise 11.9.2
supports up to 31 columns in an index;
"OR" Processing-optimization improvements for SQL queries that contain
Dynamic SQL Performance-Dynamic-SQL requests bypass expensive catalog activity
in tempdb through the use of "lightweight stored procedures". Dynamic-SQL
statements no longer take exclusive table locks on the "sysobjects" table in
Optimizer ImprovementsInternal optimizer enhancements use the new
statistics and new interpolation algorithms to improve the costing of queries. These
include much more accurate selectivity estimates and improved costing for queries using
Distributed Computing for the
Full compatibility with Sybase Replication Server lets you maintain consistency
across a distributed database without the requirement for two-phase commit. Unlike
products that offer read-only snapshot replication of full or partial tables, Sybase
provides full read-write bidirectional replication to popular backends, including Sybase,
Oracle, and DB2, transferring only the data that has been changed.
Management, and Administration
A graphical installation and setup utility eases the task of installing and configuring
the server and client software. Sybase Central ,an easy-to-use, GUI administration tool,
assists you in administering users, your replication environment, security, and storage.
It gives you the power to initiate database backups and restores, and maintain log
files; configure, start, and stop servers;
check database consistency and view server statistics; execute queries; and transfer data
to and from an Adaptive Server Enterprise database. Wizards in Sybase Central also save
you time by visually creating and guiding your SQL coding. Adaptive Server Enterprise
Monitor allows you to graphically
monitor your OLTP/mixed-workload transactions. By examining object-level statistics,
you can quickly tune applications and resolve bottlenecks for maximum performance.
As use of and demand for database
information expands, especially through the Internet, security is becoming an increasingly
important part of database technology. In response to this concern, Adaptive Server
Enterprise for Linux meets the National Computer Security Councils C2 level of
trust. Adaptive Server Enterprise for Linux also Certified ISO 9001 compliant
Data Reliability, Integrity, and Availability
Sybase is the only certified ISO 9001 DBMS vendor and builds Adaptive Server
Enterprise for Linux from the ground up to conform to ISO 9001 specifications. Adaptive
Server Enterprise guarantees high availability of your data. Full online transaction
processing capabilities include automatic rollback and roll-forward recovery. Disk
mirroring, automatic fail-over, and high-speed backup/restore capabilities minimize the
impact of hardware failure on running applications. Adaptive Server Enterprise allows you
to configure the recovery-fault isolation to the page level. A single page fault impacts
only that page while the rest of the database remains online. High-speed, online backup
using Backup Server ensures minimal impact to online performance with writes occurring in
parallel onto as many as 32 tape or disk devices.uses a security control layer to provide
unified authentication, message integrity, and message confidentiality. This advanced,
role-based security system interfaces to industry security services such as native
Linux authentication. In addition, proxy authorization provides improved security and
auditability for multi-tier applications.
More Information : www.sybase.com