Sybase Inc., Emeryville, CA, www.sybase.com) A software company founded in 1984 that specializes in client/server development products. It was originally known for its SQL Server relational DBMS, but expanded its line in 1995 when it acquired Powersoft, makers of the PowerBuilder application development software. Sybase offers a variety of application development tools, compilers, middleware, database and data warehousing products.
Published on Fri, 19 Aug 2005 15:59:15 -0400 Read: 1448 times
This tutorial cover the following topics in Sybase.
Sybase data types
Listing object names and attributes
Creating a table
Creating a proxy table
Altering a table
Creating an index
Clustered vs non-clustered indexes
Creating a constraint
Table partitioning
Tables which span multiple segments
Creating a stored procedure
Object... Read Article.
Published on Fri, 19 Aug 2005 15:59:15 -0400 Read: 1639 times
This tutorial cover the following topics in Sybase.
Database Administration
Post-installation check
Starting the Sybase process
Device initialization
Database creation
A backup routine
Striping dump devices
Moving the transaction log to another device
Adding a segment to a database
Setting the thresholds
Configuring the cache... Read Article.
Published on Fri, 19 Aug 2005 15:59:15 -0400 Read: 2164 times
This tutorial cover the following topics in Sybase. The Sybase Server
A Sybase server consists of:
A) two processes, data server and backup server ;
B) devices which house the databases; one database (master) contains system and configuration data ;
C) a configuration file which contains the server attributes .
Sybase Overview... Read Article.
Published on Fri, 19 Aug 2005 15:59:15 -0400 Read: 983 times
The Sybase Server
A Sybase server consists of:
A) two processes, data server and backup server ;
B) devices which house the databases; one database (master) contains system and configuration data ;
C) a configuration file which contains the server attributes .
The Oracle Instance
An Oracle instance consists of:
A) five processes: system... Read Article.
Published on Fri, 19 Aug 2005 15:59:15 -0400 Read: 968 times
Our tests revealed that Sybase is significantly faster than Oracle. Caveats: 1) The hardware used was not 'Enterprise' class, no RAID was implemented. 2) The amount of data used in the test (about 15mb worth) is fairly substantial, but much smaller than the data manipulated in a typical enterprise class application. Finally, a test which compares... Read Article.
Published on Fri, 19 Aug 2005 15:59:15 -0400 Read: 1590 times
Here are the list of Sybase Documentation Manuals for all the Product that Sybase offers.
Adaptive Server Anywhere (Archive)
Adaptive Server Enterprise (Archive)
Adaptive Server Enterprise Monitor (Archive)
Adaptive Server IQ (Archive)
Sybase Character Sets (Archive)
ClearConnect (Archive)
Sybase dbQueue (Archive)
DirectConnect... Read Article.
Published on Fri, 19 Aug 2005 15:59:15 -0400 Read: 713 times
Here are the list of Sybase Documentation Manuals for all the Product that Sybase offers.
Industry Warehouse Studio
Sybase IQ
Risk Analytics Platform
Warehouse Studio... Read Article.
Published on Fri, 19 Aug 2005 15:59:15 -0400 Read: 1280 times
Often people in newsgroups ask about some comparison of Microsoft SQL Server and Sybase Adaptive Server. In this article, I compare SQL Server 2000 with Sybase Adaptive Server Enterprise 12.5 (Sybase ASE 12.5) regarding price, performance, platforms supported, SQL dialects and products limits.... Read Article.
Published on Fri, 19 Aug 2005 15:59:15 -0400 Read: 1535 times
Welcome Back! In the first two parts of this series, we installed the Sybase database and configured the Perl language to work with the database. In part three, we will create a web application using our newly installed database server. Before you can manage an application using the Sybase server, some background information is in order. I will assume... Read Article.
Published on Fri, 19 Aug 2005 15:59:15 -0400 Read: 1542 times
This is very good tutorial on Sybase Stored Procedures covers teh following topics in detail. This guide will attempt to show you how to create stored procedures for the World Wide Web. As I was in the middle of writing this guide, I realized it was about 10 times more lengthy than what I intended. The interface you will be using is slick, writing stored... Read Article.