Linuxpertise.com
l i n u x
Click here for Support
Click here to Register
Click here to Sign on
Home Support Linux Update About Us Contact Us

  Databases

Menu
 
Corporate Focus
Why Linux
Linux Presentation

Distributions
Security
Case Studies
General FAQ's
Applications
Databases
Office Suites
Desktop
Mail
Web
Development Tools
Groupware
E-commerce
Vertical Applications
Engineering
Manufacturing
Retail
Publishing
Finance
Hospitality
Penguin Club
Help among peers
Round Table
Your opinions exchanged
Links
Linux Links
Events
Linux Events
Site Map
Explore Linuxpertise

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

For any 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.

   DB2 Universal Database Version 7.1                   new


DB2 Universal Database Version 7.1 from IBM is stated to be the "the most powerful solution of its kind in the industry"

Claimed Usage:

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:

Ariba, i2

Works.com,

Global Freight Exchange (GF-X),

adtender.com

Freight Traders

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.

Details


oraclelogo.gif (3317 bytes)Oracle 8i


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 today’s 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 today’s fast-paced business climate, application developers must produce advanced applications quickly to meet ever-changing needs.

Oracle8i introduces additional support for Java — today’s most Machine (VM) within the server. This expands Oracle’s 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.

Features :

  • XML SUPPORT
  • ORACLE WEBDB FOR DEVELOPING WEB-BASED APPLICATIONS
  • 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


DB2


Benefits of DB2 for Linux:


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 Database Interface.

DB2 for Linux for e-business


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


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.gif (16287 bytes) 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 components.

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 scalability.

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 strategies.
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 Enterprise’s 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

speeds

• Tunable block I/O improves performance

by reducing physical I/O

• Table partitioning enables parallel

processing

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

Descending Keys

—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;

• Update Statistics

—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 "OR" clauses

• 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 tempdb;

• Optimizer Improvements—Internal 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 large I/O. 

Distributed Computing for the Decentralized Workplace: 

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. 

Simplified Installation, 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. 

Enhanced Security Features

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 Council’s C2 level of trust. Adaptive Server Enterprise for Linux also• Certified ISO 9001 compliant

 Maintain 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