Austin, Sandra
Grant, Anthony
Pham, Tran
Samuel, Bhanu
Stewart, Doretha
Access Group
Workshop #6
Instructor: Dr. S. Prasad
February 21, 2002
Assignment #5
Table of Contents
Executive Summary 4
Mission Statement 5
Mission Objective 5
History 5
Database Servers 6
Database Architecture 8
Common Database Architecture 10
Mixed and Varying Workloads 11
Leverage Legacy Data 11
Enterprise Connect 12
Replication Server 12
Internet Architecture Support 12
Low and High-end Scalability 13
Where Sybase's Development Solution Is Most Effective 13
Features of Sybase 14
Data Management 15
Information Management (Advanced Management) 15
Enterprise Java Beans (High Performance) 15
Management of External Non-Relational Content 16
Support for Java in the Database, SQLJ, and Java.net Standards 16
Unicode 3.0 Support 17
Dynamic Performance Tuning to Achieve Optimal Performance 17
Row-level Storage Security 18
Secure Socket Layer Support 18
Mission Critical Computing 18
Advantages Of Using Sybase 19
Sybase Adaptive Server Enterprise 20
Anywhere Solutions 20
Adaptive Server IQ 21
Comparison of Sybase vs. Oracle 22
Database Infrastructure: 22
Memory Configurations 22
Data Processing And Manipulation 23
Backup Capabilities 24
Recovery Attributes 24
Security Procedures 24
High Level Procedures On Database Creation 25
Inherent Data Types 25
Storage Methodologies 26
T-SQL and P SQL 26
Performance And Scalability 27
Pricing 27
Advantages of Sybase vs. Oracle 28
Sybase Certifications 30
Total Cost Of Ownership 31
License and Maintenance Fees For The Software 32
Administration 33
System Cost 33
CONCLUSION 34
References 35
Executive Summary
A database is a collection of non-redundant data that can be shared by different applications. The lack of database structure and syntax commands encouraged the creation and implementation of relational databases. Relational databases were introduced in 1970 when there was extensive experimentation with creating relationships of data and manipulating data so that it maybe shared. IBM was the forerunner of research and development of databases by exhilarating their efforts by introducing commercial products such as SQL/DS for DOS and DOS/VSE disk operating system and virtual storage extended and for VM/CMS virtual machine/conversational monitoring system.
A relational database is the data management function of another application. This provides a company the ability to form searches, store, add, delete and modify data through the use of Structured Query Language (SQL). Scalability, performance and security are the most important features when purchasing any database. Many open system databases are in production to allow a terabyte of data. Most data warehousing is due to the fact terabyte provides storage capacity, indexing, temporary space, transaction logs, mirroring, and backup and recovery. Organizations want the ability to manage the data and manipulate it.
Around 1987, Sybase Corporation began developing a database server with the intent of speeding up application processing and development as well as provide an overall system cost reduction. As Sybase began to expand, flexibility of their products exploded from the database technology into the development of software to support international business. In addition, Sybase has developed management solutions for business expansion into healthcare, mobile and wireless computing, business intelligence, financial services, manufacturing operations and hospitality productivity that is cost effective and quickly accessible.
Mission Statement
Sybase databases are developed to accommodate business needs regardless of size. The main focus of the database is Web based to allow portability, integration, manageability, and availability of applications as their dedication to businesses success.
Mission Objective
- Provide high performance, scalable products that are compatible and deliverable anywhere.
- Provide the most comprehensive solutions for processing of critical information globally.
History
Sybase Corporation located in Emeryville, Ca was founded in 1984. Sybase is primarily a UNIX vendor and is recognized as one the largest providers of database software. The corporation introduced the SQL server in 1987 as a client server solution that was as designed to separate the client and server functionality. To complete the availability of the SQL server to the market, Sybase developed a partnership with Ashton-Tate and Microsoft. This transition was incorporated to accommodate the new paradigm with the increase use of the Local Area Networks (LANs). Sybase quickly emerged into the new computing models to include On Line Transaction Processing (OLTP) mixed workload environments, data warehousing, decision support and mobile environments.
As Sybase continue to gain popularity that intent stayed in tact to assist businesses in integrating, managing and delivering applications providing content and data anywhere needed. The products and services permits customers the ability to convert critical stored information that can be personalized and delivered anywhere.
Database Servers
Sybase offers three types of Database Servers in the market: Sybase Adaptive Server Enterprise (ASE), SQL Anywhere Studio, and Adaptive Server IQ Multiplex.
”Sybase Adaptive Server Enterprise is a powerful data management platform designed for transaction-intensive enterprise applications, with advanced capabilities to meet the evolving requirements of e-Business.
SQL Anywhere Studio is a comprehensive package that provides data management and enterprise synchronization to enable the rapid development and deployment of distributed e-Business solutions.
Adaptive Server IQ Multiplex is a high-performance relational database designed specifically from the ground up to meet the needs of business intelligence and a new generation of scalability requirements for Web-enabled data warehousing (http://www.sybase.com/products/dataservers).
Therefore, ASE is used for enterprise data management, Adaptive Server IQ is used for data warehousing, and Adaptive Server Anywhere is using in mobile and occasionally connected deployments. All these database servers represent the overall picture of the Sybase Adaptive Server RDBMS product family. However, each product requires component interfaces to connect together. Sybase provides all interfaces. PowerSoft development tools and PowerBuilder allow rapid, cost-effective addition of new technology to application development. Furthermore, ASE can be the underlying database for major packaged applications such as PeopleSoft. Together with the component interface and development tools, developers can customize these packaged applications effectively.
The current version of Sybase ASE version is 12.5. ASE offers standard features for any business database plus added features to enhance e-business. These features include:
· Performance and scalability at ever-increasing rates
· High availability to the "five nines" for E-Commerce
· Online maintenance operations
· Ability to handle very large objects
· Ability to handle unstructured and user-defined datatypes and functions
· Support for/interface to standard directory services
· Integration with evolving security standards, without sacrificing ability to identify actual user from any interface
· Support for Java Stored Procedures and SQLJ
· Support for XML tagging and manipulation
· Support for application component deployment infrastructures
· Java/J2EE/Corba and/or COM+/DNA support
· Distributed systems management and monitoring
However, ASE 12.5 is a big RDBMS that is not flexible in application-development needs, such as:
· Scalability down to the desktop and up to the enterprise;
· Flexibility to handle the new Internet and distributed-object architectures and to merge them with client-server and host-based solutions;
· Programmer productivity support by supplying powerful object interfaces that allow "write once, deploy many" (http://www.sybase.com/detail/1,6904,1008849,00.html).
Database Architecture
ASE 12.5 includes the following features packaged in their system to set up an Enterprise database:
- Adaptive Server 12.5
- Adaptive Server Enterprise Monitor™ Server 12.5
3. Monitor Client Library 12.5
4. Historical Server 12.5
5. Open Client™ 12.5 SDK
6. Embedded SQL™/C 12.5 SDK
7. SQL Remote™ 7.0.2
8. Language Modules 12.5
9. jConnect for JDBC 4.5
10. jConnect for JDBC 5.5 .
11. Java uitilities:
· JISQL 2.0
· Ribo 2.0
- Sybase Central 3.2
The normal configuration of Sybase RDBMS can be shown in diagram 1:
Sybase Configuration:
1. Dataserver: ASE is a process on the CPU
2. Interface File: the interfaces file determine the network port for ASE
3. Errorlog File: ASE errorlog file
4. Runserver File: Script file that starts the ASE
5. Config File: The configuration file
6. Master DB: All server system tables exist in this database.
7. Model DB: A template database for all new databases.
8. Tempbd DB: A temporary database used for temporary data storage.
9. Sybsystemprocs DB: A database that stores all the system stored procedures.
10. User Databases: Many user databases can exist on ASE.
11. Master Device: The master, model, and temp databases exist on the master device.
12. Sybprocs Device: The subsystemprocs database exists on the sybprocs database device.
13. Other Devices: Many additional devices can exist.
Common Database Architecture
Adaptive Server has a common language capability and a "component layer" that allows developers to write to a common API or class library across Adaptive Server Enterprise, Adaptive Server IQ, and Adaptive Server Anywhere. The library is based on Transact SQL and Java support, and it supports a superset of each DBMS's APIs. Therefore, developers use this interface to write applications for ASE’s Transact SQL that will run without change on the other DBMSs. This is an important feature that saves time in developing applications and matching today’s philosophy "write once, deploy many". Furthermore, ASE can be interfaced with other RDBMS languages through Sybase DirectConnect interface. This feature permits ASE to be used in datamart as shown in figure 2:
Mixed and Varying Workloads
The Logical Process Manager effectively allocates CPU resources and I/O tunable blocks. This process manager assists ASE when changing data-access or updating patterns that permits workload flexibility and scalability. In addition, this increases the efficiency of the database.
Leverage Legacy Data
Through the use of Replication Server, the users can merge legacy and divisional databases periodically or on time-delayed basis into a common database pool. However, the DBA may have to write the front-end to translate the information to the end users; in addition, DBA may have to normalize the table to increase the efficiency of RDBMS. This is a great feature for data warehousing.
Enterprise Connect
Sybase includes an array of gateways, open clients, and open servers that easily connect to the network with a wide variety of functionality. The DirectConnect is high-performance, which universally connects with the network by using Open ClientConnect/ Open ServerConnect. It also provides security for the system and network software such as Novell’s NDS, CICS/6000, Encina, Tuxedo, and Top End.
Replication Server
Replication Servers provide features to developers to replicate data across multiple suppliers' distributed databases. Users can use the Replication Server to synchronize Sybase databases with heterogeneous distributed databases within non-SQL-Server and multi-supplier environments. The OmniSQL Gateway "data catalogs" provides data-dictionary information across multiple databases. Users may apply distributed queries across multiple databases and not only Adaptive Server's databases.
Internet Architecture Support
The Adaptive Server is a Web-based database, which allows users to write its common API to deploy across the Worldwide Web. The Enterprise Connect permits Internet access to more than 21 backend data servers, including partnership databases with firewalls.
Low and High-end Scalability
ASE is highly scalability in database size and number of end users. ASE together with bi-direction index scans; query processing, parallel querying, and parallel backup are significantly faster than most other database.
Overall, Sybase's legacy-data support is exceptionally broad, allowing simple, flexible backend access to a particularly wide range of user data. Moreover, it is industry proven that products such as Open Client and Open Server have been highly popular and field-tested for more than half a decade.
Where Sybase's Development Solution Is Most Effective
Aside from its applicability to a broad range of situations such as the Internet, Sybase Computing Platform offers particularly strong benefits for the following situations:
· Information Systems (IS) are aiming to integrate applications.
· Developers must customize and upgrade applications to add new technologies.
The Sybase Computing Platform offers strong Internet and distributed-object new- standards-based and supports a superset of Sybase's TransactSQL. Therefore, TransactSQL allows applications that invoke SQL Server to run without change over to the Adaptive Server. Sybase users can simply install ASE and recompile their system to expand an application's range to the full spectrum of Adaptive Server platforms and architectures. The new Java development tools enable users to rapidly add new technology to applications across all platforms.
To integrate Windows NT, Internet and host-based, and Unix client-server applications, the use of the Sybase Computing Platform and Powersoft tools are the most sufficient method. The DBA and end users can take advantage of Adaptive Server's common API, Enterprise CONNECT's and the Internet's to operate and maintain the database. In addition, Powersoft development tools can quickly provide remote, location-transparent, application-to-application data pipes or function calls.
Sybase Computing Platform provides tools well suited to upgrade and develop customized packaged applications or upgrade legacy applications. With the use of Powersoft, C++, and Java, these applications allow quick and easy Web development that provides distribute applications to the offsite application. (http://www.sybase.com/detail/1,6904,1008849,00.html)
Features of Sybase
Over the last several years Sybase, like so many of its counterparts has grown to become one of the most technologically advanced Relational Database Management Systems (RDBMS) in the world. This is due to remarkable innovations that have been made to the Sybase RDBMS. The latest RDBMS is called Sybase Adaptive Server Enterprise (ASE). This version was designed specifically to support the demanding requirements of transaction intensive and mission critical support applications. This new version of Sybase introduces innovations that enhance and meet the growing needs of e-Business. Although this new version of Sybase’s enhancements are not transparent, it clearly indicates a shift towards conducting business in a more efficient cost effective manner, which invariably calls for high scale, cutting edge technology. Sybase ASE utilizes tools to facilitate that objective. Sybase ASE includes tools for handling data types, performance management to address the unpredictable nature of Internet-based computing, and enhanced security to protect business data. All these tools are effective in highly distributed Web-based environments providing enhanced e-Business data management, dynamic performance, and security.
Data Management
Information Management (Advanced Management)
The Extensible Markup Language (XML) is the universal format for structured documents and data on the Internet. Sybase has incorporated an embedded query and storage engine, which allows for full transactional capabilities. The Extensive Query Language (XQL) engine in Sybase allows for content generation from XML documents storage without total reliance on writing custom code by programmers to deal with XML documents. The database management function understands XML documents in all dialects, which permits it to interpret XQL queries and generate in memory access structures. This allows for fast retrieval of information. The key capabilities of the management features include: