PowerBuilder Authors: Chris Pollach, Yeshim Deniz, Jayaram Krishnaswamy, Kevin Benedict, Avi Rosenthal

Related Topics: PowerBuilder

PowerBuilder: Article

Enterprise Database Development in Sybase Workspace Release 1.5

Enterprise Database Development in Sybase Workspace Release 1.5

Sybase ASE
Sybase's flagship data management platform, Sybase ASE, is a versatile enterprise-class RDBMS. It offers enterprises a high-performance system for data and transaction processing for the lowest total cost of ownership among relational databases. ASE focuses on the core factors that affect total cost of ownership - operational requirements, system performance, and application development.

Sybase ASE comes with support for XML and Web Services as well as real-time messaging. Sybase WorkSpace makes assimilating XML in database logic easier by providing a visual XML SQL query builder, XML data transformation, and XML schema development features.
Real-time messaging is simplified with help from messaging SQL creation wizards that streamline development even for experienced developers who may not remember special XML and message-handling SQL constructs and dialects.

Sybase WorkSpace supports service consumer requirements by allowing the quick creation of proxy tables for available Web Services from Web Services Description Language (WSDL), the open standard for describing Web Services to clients. Once a proxy table is generated the corresponding Web Service can be accessed by performing a SQL (SELECT) query on the proxy table with the input parameter passed in the 'WHERE' clause.

Sybase ASA
Sybase ASA, part of SQL Anywhere Studio, is the industry leader in mobile and embedded database management. This powerful database server is optimized for use on smaller servers, laptops, and handheld devices and supports both single- and multi-user implementations. SQL Anywhere Studio also includes UltraLite, a database designed to minimize the memory and system requirements of data-driven applications targeting small devices such as handheld computers.

Sybase WorkSpace supports the ASA developer in generating an UltraLite database from a consolidated database. It can create, execute, and debug ASA-only database objects, including event handlers and user-defined functions. In addition, all features supported for ASE SQL for XML development are supported for ASA.

Since ASA supports both Transact SQL (ASE) and Watcom SQL syntax, the database editor's built-in syntax validation and auto-completion features provide informational messages appropriate in either context (including a mixed context).

Sybase WorkSpace also supports provisioning of the SQL queries, stored procedures, and user-defined functions as Web Services hosted in the ASA database server itself. Web Services will soon be hosted from WorkSpace in ASE server as well. In the meantime, developers can use the database service to expose their ASE stored procedures and SQL commands as Web Services.

Sybase IQ
Sybase IQ is a highly optimized analytics engine designed to deliver dramatically faster results for mission-critical business intelligence, analytics, and reporting solutions. It delivers unsurpassed query performance and storage efficiency for both structured and unstructured data, making it ideal for specialty data stores.

Sybase WorkSpace supports visual data warehouse development at various levels. It's capable of handling routine database development tasks such as creating Sybase IQ database warehouse models, reverse-engineering warehouse models from existing Sybase IQ databases, browsing Sybase IQ databases, and manipulating database objects such as tables, stored procedures, and indexes.

WorkSpace lets developers create multi-dimensional models comprising tables, partitions (horizontal and vertical), join indexes, and cubes using cube elements (facts, dimensions, hierarchies, and attributes). To help with advanced-level testing, cube data can be automatically generated for a test cube. The database editor syntax validation feature also supports Sybase IQ's extended SQL grammar syntax, data types, and warehouse special indexing schemes.

Data Movement
Sybase Workspace supports development across Sybase's core data movement platforms including Sybase Replication Server, Sybase RepConnector, and Sybase Mobile Link Server. WorkSpace's data movement features are geared to database administrators and data architects concerned with setting up database system recovery plans and ensuring data availability across multiple geographies.

Sybase Replication Server
Sybase Replication Server simplifies data movement and synchronization across the enterprise. It lets DBAs quickly set up redundant disaster recovery sites and synchronize data across heterogeneous database platforms including Sybase ASE, Oracle, IBM DB2, and Microsoft.

WorkSpace support for Replication Server (version 12.5 and 12.6) comes from the enterprise modelling component. Database administrators can model and analyze an entire replication architecture and subsequently use code generation to deploy it to the replication server and database servers to create the desired replication environment. The model supports all replication artefacts such as connections, replication definitions, publications, subscriptions, and articles. WorkSpace can also reverse-engineer a model from an existing replication server installation, defining multi-route and multi-site replication. Other commonly used modelling features are creating or changing subscriptions, publications, articles, and function strings; as well as creating the database extensions needed to support replication to the refdef commands themselves.

Sybase WorkSpace also supports connecting to multiple replication servers and directly creating replication artefacts through powerful wizards. Those wizards are specially designed for the large-scale generation of those artefacts with minimal work. The wizards are provided for creating database and table repdefs, subscriptions and publications, and articles.

Sybase WorkSpace extensions into UML make it possible to share all metadata about the replication with business and IT professionals throughout the infrastructure. This capability lets developers design replication schemes in context with the corporate architecture.

Sybase Replication Connector
Sybase Replication Connector is a component of Sybase Real-time Data Services. It lets developers capture business events from any database, transform them into formats used by other applications, and deliver them to any JMS-compliant messaging infrastructure. Sybase Replication Server and Sybase RepConnector combine to form a unique real-time data services solution, providing passive non-intrusive database events extraction and handling without impacting the performance of the online transaction system.

Sybase WorkSpace, in combination with Sybase Unwired Orchestrator, can be used to pass RepConnector database events in a business process or in a composite Java service application, facilitating passive, message-based integration of events and process orchestration.

Sybase MobiLink Server
Sybase MobiLink is a proven, robust, flexible synchronization server supporting wired, wireless, and cradle-based integration between databases. MobiLink offers bi-directional exchange of information between remote Sybase ASA or UltraLite databases and a variety of enterprise data sources including Sybase ASA or Sybase ASE.

Developers working with MobiLink (version 9.0) servers can design, generate, and reverse-engineer MobiLink definitions. They also benefit from MobiLink's support for a broad range of requirements: creating timestamp columns, shadow tables, stored procedures and triggers for consolidated databases; creating MobiLink publication and subscription scripts; creating remote databases from publications and articles; registering MobiLink users; generating MobiLink synchronization scripts; and converting remote ASA databases to UltraLite.

Use Case: Database Development & Integration with Sybase WorkSpace
The following scenario illustrates how Sybase WorkSpace can simplify and accelerate the development of enterprise applications. In this typical order entry and shipping application, customer orders are captured in an order entry database that is being replicated to a standby database for recovery and availability in the case of unforeseen system problems. Orders are captured in an order entry database and specific ordering data is replicated to a shipping database. Once shipping is complete, a confirmation e-mail is sent to the customer.

More Stories By Samir Nigam

Samir Nigam is director of engineering in the information technology and solutions group in Sybase. He is currently looking after Data Management and Data Integration tools in Sybase Workspace - Sybase's next generation unified development environment built on Eclipse. Samir holds a Masters in Computer Engineering from the University of Cincinnati.

Comments (0)

Share your thoughts on this story.

Add your comment
You must be signed in to add a comment. Sign-in | Register

In accordance with our Comment Policy, we encourage comments that are on topic, relevant and to-the-point. We will remove comments that include profanity, personal attacks, racial slurs, threats of violence, or other inappropriate material that violates our Terms and Conditions, and will block users who make repeated violations. We ask all readers to expect diversity of opinion and to treat one another with dignity and respect.