Sybase Introduction

Sybase is a relational database management system (RDBMS) that lets you create, update, and administer a relational database. Sybase use the Structured Query Language (SQL) to access the database, although SQL was invented after the development of the relational model and is not necessary for its use.

Other leading RDBMS products are Oracle, IBM’s DB2 and Microsoft’s SQL Server but we will focus on Sybase here.

Facts:

  • 1984: Sybase (initially called Systemware) is founded by Mark Hoffman, Bob Epstein, Jane Doughty and Tom Haggin out of Epstein’s home in California.
  • 1988: Sybase goes into partnership with Microsoft to port SQL Server to Windows and OS/2
  • 1989: Sybase launches Replication Server, a data replication technology that moves and synchronizes data across the enterprise.
  • August 1991: Sybase goes public at a split adjusted price of $6.75.
  • 1993: Sybase and Microsoft dissolve their partnership. Microsoft bought the Windows code base from Sybase.
  • November 14, 1994: Sybase acquires Powersoft, which bought Watcom earlier that year.
  • 1995: Sybase launches PowerDesigner, a modeling and metadata management solution, following its acquisition of PowerAMC.
  • 1995: Sybase renames the main product SQL Server to its current name Adaptive Server Enterprise (ASE) for version 11.5.
  • 1995: SQL Anywhere 5 is released. It includes SQL Remote, SQL Central, Transact SQL syntax, and support for the Sybase Replication Server.
  • 1996: Mitchell Kertzman, PowerSoft CEO, is appointed CEO.
  • 1996: Sybase launches Sybase IQ, the first column-based analytics platform.
  • 1997: Sybase’s flagship database product Adaptive Server Enterprise (ASE) starts its life in the mid-eighties as “Sybase SQL Server”. Microsoft is a Sybase distributor, reselling the Sybase product for OS/2 and NT under the name “Microsoft SQL Server.” Around 1994, Microsoft begins independently developing its own product. When Sybase releases version 11.5 in 1997, Sybase renames its product to “Adaptive Server Enterprise” to better distinguish itself from MS SQL Server.
    • October 1998: John Chen is appointed Chairman, CEO and President.[18]
    • 1998: SQL Anywhere 6 is released, with new names “Adaptive Server Anywhere” as the engine and part of the “SQL Anywhere Studio” which now includes SQL Modeler (later PowerDesigner), Java is introduced to the database.
    • 2000: iAnywhere Solutions, Inc. is founded as a subsidiary of Sybase.
    • June 20, 2001: Sybase acquires New Era of Networks, a leading application integration company that produces the e-Biz Integrator middleware, though it stops offering this product in 2004.
    • November 2003: Sybase launches the “Unwired Enterprise” strategy.[19]
    • 2004: Sybase acquires XcelleNet, frontline device management software, to enhance its Unwired Enterprise strategy.
    • September 12, 2005: Sybase releases ASE 15.0.
    • August 7, 2006: iAnywhere announces release of SQL Anywhere 10.
    • November 8, 2006: Sybase acquires Mobile 365, a mobile data and messaging company, and renames it Sybase 365.
    • February 2008: Sybase releases Adaptive Server Enterprise, Cluster Edition, with Oracle RAC-like shared-everything clusterability, but based on an open architecture and less costly.
    • May 2008: Sybase IQ analytics server sets a new Guinness World Record by powering the world’s largest data warehouse.
    • May 2008: Sybase launches RAP – The Trading Edition, an analytics platform for Wall Street.
    • August 2008: Sybase unveils the Sybase Unwired Platform (SUP), a platform for developing mobile applications across a heterogeneous environment.
    • September 2008: Sybase 365 expands its messaging interoperability with the launch of its global Multi-media Messaging Exchange, MMX 365.
    • March 2009: Sybase and SAP partner to deliver the SAP Business Suite software to iPhone, Windows Mobile, BlackBerry and other devices.
    • May 2009: Sybase begins packaging MicroStrategy business intelligence software with its Sybase IQ server.[20]
    • September 2009: Sybase and Verizon partner to manage mobility solutions for enterprises worldwide through Verizon’s Managed Mobility Solutions, which utilizes Sybase’s enterprise device management platform.
    • May 2010: SAP makes an offer to acquire Sybase for $5.8 billion.[11]
    • July 2010: SAP completes tender offer for shares of Sybase and its acquisition.[21]
    • August 2010: Sybase partners with telecommunications partners to offer the world’s first fully operational IPX Voice hub.[22]
    • November 2010: Sybase and Verizon deliver Mobile Services Enablement Platform, a new managed mobility offering, to reduce the complexity in developing and deploying mobile applications running across a variety of back-end enterprise systems and mobile device types.[14]
    • February 2011: Sybase is positioned in Leaders quadrant in Gartner’s 2011 Data Warehouse Database Management System Magic Quadrant.[16]
    • July 2011: Sybase awarded Best CEP Provider and Best Enterprise Data Management Provider at the Water Rankings Awards.[23]

Sybase, an SAP company, creates technology that enables the Unwired Enterprise for our customers and partners by delivering enterprise and mobile infrastructure, development and integration software solutions. The world’s most critical data in commerce, finance, government, healthcare and defense runs on Sybase. Below is a brief history of selected accomplishments spanning two decades as a leading technology company.

 

Overview of system databases:

When you install Adaptive Server, it includes these default system databases:

  • The master database
  • The model database
  • The system procedure database, sybsystemprocs
  • The two-phase commit transaction database, sybsystemdb
  • The temporary database, tempdb

Above is an example of a Sybase server named SYBASERAYS_SERVER1, which contains default databases i.e. master, model, sybsystemdb, sybsystemprocs, tempdb (in red border).  Sybaserays_userdb (You can name it anything for your user database) is a user database for storing data of users and its not a default database.

 

Note: The master, model, sybsystemdb, and temporary databases reside on the device named during installation, which is known as the master device. The master database is contained entirely on the master device and cannot be expanded onto any other device. All other databases and user objects should be created on other devices.

 

Optionally, you can install:

  • The auditing database, sybsecurity
  • The sample databases, pubs2 and pubs3
  • The dbcc database, dbccdb
  • The Job Scheduler database, sybmgmtdb

Leave a Reply