http://goo.gl/EmKxy0

Archive

Archive for August, 2012

Indian Railways Running on SAP Sybase ASE

August 23rd, 2012 No comments

Indian Railways: Centralizing Ticketing

 

Discover how Asia’s largest rail network is efficiently managing 17 million daily passengers across 6,000 stations with computerized ticketing. With Sybase database technology, Indian Railways is enhancing customer service with 24/7 ticketing and transaction times of less than 20 seconds per ticket.*

Full Story ::  http://www.sap.com/solutions/technology/database/customer-reviews.epx

New features in SAP Sybase ASE 15.7 ESD#2

August 23rd, 2012 No comments

Really very Good and useful new features in Sybase ASE 15.7 ESD#2, Checked Out in Rob’s Blog :

 

A few weeks ago (early August 2012), ASE 15.7 ESD2 was released. Despite being an ESD, this ASE release actually contains a truckload of great new features as well. You should really check these out since some of these are just so useful… Let me just highlight a selected few that I like particularly (I hope to come back to some of these topics in the time ahead).

* larger database size – First, the maximum size of an ASE database has been doubled as of 15.7 ESD2. This means that with a 2KB or 16KB page size, the maximum size of a single ASE database is now 8TB or 64TB, respectively (and you can still have thousands of such databases in a single ASE server).
* async database creation
* split/merge partition
* non-blocking table rebuild
* faster update statistics
* faster index creation
* query performance
* Materialized Views
* security & permission

Source : http://blogs.sybase.com/database/2012/08/why-you-should-check-out-ase-15-7-esd2/#

SAP’s Chen Challenges Oracle, IBM With Database Advances

August 23rd, 2012 No comments

SAP AG (SAP), chasing Oracle (ORCL) Corp. and International Business Machines Corp. (IBM) in the $26.7 billion database market, is betting on new product features to gain ground, said the man who helped build the company’s arsenal.

Read Full Story @ http://www.businessweek.com/news/2012-08-10/sap-s-chen-challenges-oracle-ibm-with-database-advances

Categories: ASE, HANA, News, SAP Tags: , , , ,

Nested Transaction

August 12th, 2012 No comments

NOTE: There must be at least one commit tran executed for each tran statement executed. But, regardless of how many begin tran/commit tran pairs appear to be nested in the code, there is only one transaction.

 

Example:

begin tran

change 1

begin  tran

change 2

commit tran

commit tran

In above pseudocode, there are two nested begin tran statement. Despite, the fact that it appears that there are two transactions (one inside another), there is actually only one open transaction. Thus, the transaction is active until the second commit tran statement is executed.

 

Example:

begin tran

change 1

begin tran

change 2

begin tran

change 3

commit tran

change 4

commit tran

change 5

rollback tran

In this example, none of the five changes would remain in the data after the rollback; again, although it looks like there are three levels of nesting, and it looks like changes 2,3,4, and 5 are fully bounded by begin/commit pairs, there is really only one transaction, and all work must complete in full or not at all. In fact, the transaction shown above is functionally identical to:

begin tran

change 1

change 2

change 3

change 4

change 5

rollback tran

chained and unchained transaction mode

August 12th, 2012 No comments

A chained mode transaction may be thought of as “auto-starting”; when you log in and begin any SQL statement, ASE invisibly begins a transaction which  will continue until you explicitly end it. In this way, you are always making all changes as part of a transaction.

 

In unchained mode, the rule shift in an important manner: while any single data change statement is treated as a transaction, group of statements are not transactions without an explicit command to begin a transaction.