Posts tagged Sybase
SAP Unveils Unified Strategy for Real-Time Data Management to Grow Database Market Leadership!!!
0Finally the curtain is up :
SAP today provided the following road map details and areas of strategic innovation and investment of its database portfolio to increase its database market leadership by 2015:
- SAP HANA platform: This state-of-the-art in-memory platform is planned to be the core of the SAP real-time data platform, offering extreme performance and innovation for next-generation applications.
- SAP Sybase ASE: SAP Sybase ASE is intended as a supported option for SAP Business Suite applications while SAP HANA is planned to augment the extreme transactions of SAP Sybase ASE with real-time reporting capabilities.
- SAP® Sybase IQ® server: SAP Sybase IQ is planned to deliver data management for “big data” analytics, offering extreme total cost of ownership (TCO). Progressive integration with SAP HANA is intended to provide a smart store for aged/cold data. SAP Sybase IQ is envisioned to share common capabilities and life-cycle management with the SAP HANA platform.
- SAP® Sybase® SQL Anywhere: This market-leading mobile and embedded database with millions of deployments is planned to be the front-end database for the SAP HANA platform, extending its reach to mobile and embedded applications in real time.
- SAP® Sybase® PowerDesigner software: This flagship data modeling, information architecture and orchestration software is envisioned to become the foundation of the modeling solution for the SAP real-time data platform, offering a large base of experts to customers. Ford Motor Company recently selected the software to drive its data modeling and management and centralize all logical and physical modeling functions.
- SAP® Sybase® Event Stream Processor (ESP) software, SAP® Sybase® Replication Server and SAP solutions for EIM: Combined, these offerings are intended to provide data assessment and integration of batch, real-time change data capture and streaming data into the SAP real-time data platform.
- SAP real-time data platform integrated with Hadoop: SAP HANA and SAP Sybase IQ are planned to extend support for accessing “big data” sources such as Hadoop, and offer a deeply integrated pre-processing infrastructure
Source :: http://www.sap.com/corporate-en/press/newsroom/press-releases/press.epx?pressid=18621
Sybase ASE Indexes
0Index:
Indexes are the most important physical design element in improving database performance:
Indexes help to avoid table scans. A few index pages and data pages can satisfy many queries without requiring reads on hundreds of data pages.
Indexes in ASE:
We can divide ASE indexes in two categories by : i) Physical Order of Data with index key ii) Uniqueness of the index column
Based on the physical order of data, Adaptive Server provides two general types of indexes that can be created at the table or at the partition level:
• Clustered indexes, where the data is physically stored in the order of the keys on the index:
• For all pages-locked tables, rows are stored in key order on pages, and pages are linked in key order.
• For data-only-locked tables, indexes are used to direct the storage of data on rows and pages, but strict key ordering is not maintained.
• Non clustered indexes, where the storage order of data in the table is not related to index keys
Based on index column uniqueness, indexes can be unique and non unique.
So following types of indexes present in ASE with permutation and combination with above two properties:
1. Unique Clustered Indexes
2. Non unique Clustered Indexes
3. Unique Non-clustered Indexes
4. Non unique Non-clustered indexes
| Clustered Index | Non Clustered Indexes | |
| Unique | Unique Clustered Index | Unique Non Clustered Index |
| Non – Unique | Non Unique Clustered Index | Non Unique Non Clustered Index |
So, all the indexes come under above 4 types:
In case of more than one index column, we can add prefix composite in above types.
Means Composite indexes are those indexes, which are created on more than on one column. Above four types of index can be composite as well.
In the case of partitions, we can categories above types as local and global indexes.Local indexes get created at partition level and table level index called as Global indexes.
Global indexes with one index tree cover the whole table, or local indexes with multiple index trees, each of which covers one partition of the table.
Function-based indexes are a type of non clustered index which use one or more expressions as the index key.
What is “going concern” concept and how it relates to Kingfisher Airlines nowadays?
0A “going concern” refers to a company’s ability to continue functioning as a business entity in the near future. It is extremely rare that auditors make such mention in the passing.
However, Kingfisher Airline auditors asked if Kingfisher Airlines could be even described as a ‘going concern’. Means auditors were suspicious about that company would able be survive in near future, that’s why it was possible that KFA could even be described as ‘going concern’
Business Exposed To Risks
2Every business is exposed to 3 types of risks.
1. Market Risk
2. Credit Risk
3. Operational Risk
Market Risk: Market risk is referred to as decline in value of investment over a given period of time due to economic slowdown, policy changes or any other event that may impact the market.
Credit Risk: Credit risk is basically an investment risk of lose incurred from borrower’s default.
Operational Risk: Operational risk arises from failed or inadequate internal process, people or any other external event.
If we take latest example of Kingfisher Airlines, I would consider it exposed to primarily operational risk and secondary market risk.
Primarily Operational Risk is because since it’s inception in 2006 it has never made any profit and in-spite of that extra services have been provided continuously, without strengthen it’s presence in domestic market and gaining experience in aviation industry, it has been opened for international routes and etc.
Secondary Market Risk because of rise in fuel prices and taxes, however these are valid for all aviation industry but other companies are still making profit. So I have consider these elements as secondary.
SAP will disclose its Database plans on April 10 in San Francisco !!
0SAP aims to become major database software maker…
* Move will heat up rivalry with Oracle Corp
* May also put SAP at odds with IBM, Microsoft
* To disclose plans at April 10 press conference
German software maker SAP AG says it intends to become a major provider of database software in a move that would heat up its long-running rivalry with Oracle Corp, led by Silicon Valley billionaire Larry Ellison.
SAP said it will disclose its plans at an April 10 news conference in downtown San Francisco, not far from Oracle’s headquarters in Redwood City, California.
The German company is the world’s biggest maker of business management software, which includes programs that manage tasks such as accounting, manufacturing and payroll. While Oracle is the No. 2 player in that market, it sells more software, thanks to its leadership in the multi billion-dollar market for databases.
Source :: http://www.reuters.com/article/2012/03/15/sap-oracle-idUSL2E8EFBU520120315
http://www.zoneic.com/sap-plans-major-database-software-maker-ibm-microsoft-opponent.html
http://sp.m.timesofindia.com/PDATOI/articleshow/12290674.cms
http://misclassblog.com/database-design-and-development/sap-looking-to-take-over-database-market/
http://www.cloudbulletin.com/news/sap-plans-big-for-database-mkt-oracle-rivalry-to-go-fiercer
Oracle Reply : http://articles.timesofindia.indiatimes.com/2012-03-21/strategy/31219619_1_scott-behles-oracle-database-german-software-maker
See the Course Catalog on ASUG Annual Conference @ Orlando, Florida | May 14-16, 2012 , it is probable
SAP is planning to give complete Database Solution by SAP HANA platform, SAP Sybase Adaptive Server Enterprise, the SAP Sybase IQ server, and Sybase SQL Anywhere.
Lets wait on the clarity till Apr 10!!
Happy Reading !!
Recent Comments