Archive

Posts Tagged ‘Sybase’

Sybase CEO John Chen Left SAP After Successful Integration of Sybase

November 1st, 2012 1 comment

SAP AG (SAP) is losing a top executive from Sybase Inc., the largest acquisition in the German software company’s history, after fully integrating the maker of mobile applications for business management

Some Comments :

Chen, i started my career in 1999 as a Sybase consultant and from that time i am following Sybase and still continuing. You have  made a great company and it is a classic story of  rebirth. You deserve full credit to what Sybase is today. I still remember the stock price from $2 when you took over and reaching a peak of mid $30 and then subsequent sales to SAP. I am a optimimist and still believes “SAP & Sybase marriage is made in heaven” . All the best for you Chen ” You are a great leader , innovator , strategist  and a game changert and your story with Sybase  will be remembered in the history books as one of the classics”.  Good luck for your next venture.

 

Source : http://www.businessweek.com/news/2012-10-30/sap-loses-sybase-s-chen-after-gaining-blueprint-for-deals

http://www.bloomberg.com/article/2012-10-30/aElmqt8q7ntU.html

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

Sybase DBA Interview Q&A – You Must Know !

October 9th, 2012 4 comments

Dear All,

Few month back, we posted  for Sybase DBA Interview Questions &  Answers Series and we received the lot of your valuable suggestions, regarding that.
Today, I would like to thanks for your thoughts , we tried to consider  same as per our feasibility

Wait is over Now !!  Please download the First Q&A Bank (Limited Edition) with below link :

Sybase-DBA-Interview-Q &A (780)

We are still improving and adding more questions and will be releasing full version by the Month End.
If you are still seeing any correction, improvement, you are most welcome.

Again Thanks, and Happy Learning Sybase !

-Team, sybaseblog.com.

PS : You need to login to download the Q&A Bank.

 

 

SAP bundles analytic apps with IQ database

September 26th, 2012 No comments

SAP on Monday announced a new family of products that marry its Business Objects BI (business intelligence) software with the Sybase IQ analytic database and include specialized business content for use by various industries.

The four offerings include BI suite, analytics edition; BI platform, analytics edition; Edge analytics edition; and Crystal Server, analytics edition. The latter two are mostly aimed at small and medium-size companies.

 

Source : http://www.pcworld.idg.com.au/article/437296/sap_bundles_analytic_apps_iq_database/

http://www.cio.in/news/sap-bundles-analytic-apps-iq-database-308692012

 

Top 3 Benefits of SAP Business All-in-One on SAP Sybase ASE

September 14th, 2012 No comments
  • Closer and simpler business relationship with SAP. One vendor for both the database and application layer streamlines the processes for customers and partners.
  • Lower costs. SAP Sybase ASE has been shown to have lower maintenance costs over competitive database platforms, which lowers the TCO for the entire landscape.
  • Platform for innovation. Using an SAP database platform provides the foundation for future technology innovation opportunities coming with SAP HANA.

Read Full Story @ http://sapinsider.wispubs.com/Article/Database-Distress-No-More/6610

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.

Optimization Goals

July 22nd, 2012 No comments

Query — How to set the optimization Goals?

Answer — Optimization goals allow you to choose an optimization strategy that best fits your query environment:

• allrows_mix – the default goal, and the most useful goal in a mixed-query environment. allows_mix balances the needs of OLTP and DSS query environments.
• allrows_dss – the most useful goal for operational DSS queries of medium to high complexity. Currently, this goal is provided on an experimental basis.
• allrows_oltp – the optimizer considers only nested-loop joins.

At the server level, use sp_configure. For example:sp_configure “o

ptimization goal”, 0, “allrows_mix”
At the session level, use set plan optgoal. For example:

set plan optgoal allrows_dss

At the query level, use a select or other DML command. For example:
select * from A order by A.a plan “(use optgoal allrows_dss)”
In general, you can set query-level optimization goals using select, update, and delete statements. However, you cannot set query-level optimization goals in pure insert statements, although you can set optimization goals in insert…select
statements.

Courtesy: Sybooks

Categories: ASE Tags: , ,