How to solve mutating table Error? Oracle PL\SQL

What is mutating table Error?

One of the scenario when mutating table errors occurs when Table A is parent to Table B and there are triggers defined on table A trigger a1 and on Table B trigger b1.
Triggers are defined in such way that before insert trigger a1 on A

Mutating table error
before insert trigger b1 on Table B. inside trigger b1 you are trying to check value in parent table if it exits parent field. While in parent Table A triggers are called before insert which having reference to Table B values. this leads to kind of race conditions causing mutating table error.
How to solve mutating table error?
While writing trigger care should be taken that parent table triggers should try to avoid update to child table otherwise mutating table error occur.
There are more scenario which would be covered in next Example you can just read many reference available on Mutating table Error.
just do a google search and read its common PL/SQL error which would face.

second option: Use after insert trigger.
More details: next

Architecture and SAP Hana Vs Oracle Exadata competitive Analysis

SAP Vs Oracle
This debate of SAP Vs Oracle or last 2 yrs buzz SAP HANA vs Oracle Exalytics

Every year in Enterprise Software space Competition of SAP Vs Oracle Hots up with new announcements and New technology comparisons of SAP new Tech Vs Oracle New Tech.
The Enterprise Software stack built up by No.1 and No.2  world’s top most valued companies in Enterprise Technology Space.
So SAP Vs Oracle comparison will never go out of picture only every year it will up the ante
How Oracle Exadata and SAP HANA similar?

First, they are both are appliances – bundles of hardware and software and services that give you something that will run out the box. This means that the 3 elements: hardware, software and tuning – are highly optimised to work together.

Second, they are both initially optimised for Data Warehousing scenarios.

Third, both scale more or less linearly for large datasets.

SAP HANA more detailed:

Databases as we see earlier evolved from file based systems to Row oriented (RDBMS ) databases. to Column Oriented databases like SAP HANA (http://blogs.sap.com/SAPHANA/),that stores its content by column rather than by row.This has advantages for data warehouses and library catalogues where aggregates are computed over large numbers of similar data items. But what about OLTP Systems we are told that remove layers and everything in memory and it is not disruptive.But Still there are probabilitic databases which are advanced then column oriented databases.but are under evolution..

SAP HANA Architecture: why is distruptive? what problem does it solves?:

Normal Web App architerture : Portal linked to ESB which is taking to multiple Web Apps(these Apps have there own databases).Then We have ETL taking all these delta loads to EDW.Ontop of EDW we have multiple Analytical Apps. There are 3 problem in this design:

1. Problem #1: There is always Delta between App and EDW.Also Delta between App.

2.Problem #2: Since Delta between App and Analytic App decisions are delayed or misrepresented by delta leading delay in Actions.

3. Problem #3: Value in App T1 > value in Analytic App T2.

Solution presented By HANA:

1. For All events happening in databases like any changes should trigger event . Called Complex Event Processing CEP. It will collect and process all events.These changes also needs to replicated quickly to other associated events databases..hence Sybase Replication Server comes handy.

2. Replace Application databases and EDW databases with Single in memory DB (inside RAM).And One Archival database.All App and Analytical App point to In-Memory DB hence there is no Delta between them.With these 2 changes above problems are solved by HANA.

Some time back , Bob Evans from SAP wrote a blog entitled The Top 10 Reasons SAP HANA Is Disrupting Larry Ellison’s Grand Plans.

Link: http://blogs.sap.com/bobevans/2011/06/23/the-top-10-reasons-sap-hana-is-disrupting-larry-ellison%E2%80%99s-grand-plans/

How are Oracle Exadata and SAP HANA fundamentally different?

Oracle Exadata is a cell based Oracle appliance. This means that an Exadata Appliance is made up of multiple Oracle Exadata Storage Servers, each of which handles a workload, and part of a response set. So you ask a question of Exadata and the central node chunks stuff up and the Storage Servers crunch out responses. The node compiles those responses into an overall response.

SAP HANA is an in-Memory Appliance. It does break up responses if you have multiple nodes just like Exadata, but that’s not really the point. The point is that even with a single HANA node, you can get blistering performance from a reporting query, because it performs the calculation in main memory.

HANA has an application layer that sits with the In-Memory Database. This is the killer blow because the first native app is a calculation engine. This means it can do complex calculations without an application layer, which massively improves application performance.

So the key here is that whilst Exadata remains a database, SAP are pushing HANA as an application platform – and with good reason.

SAP new version come with (netweaver,BI,ABAP,Java). Enterprise workspaces into portal.

SAP improvements : In 2011 we had following changes:

Stack Vs Non Stack: War of Words

Semantic layer can handle (universes,dimensional data and multi-dimensional data, integrated to netweaver (people integration,data integration, process integration)(includes identity/lifecycle management) event processing, 16 clients report  flavour together into single design time.But is not netweaver developed on Java open source platform.But going forward its with Oracle.Is SAP going to pay royality on everything it create over it?  Where do we go from here?. History: SAP worked withIBM  to put away its default databases on vanilla install from Oracle to IBM DB2. then came new installer for vanilla install IBM+SAP products. Is is not stackized approach? Still it not how open source or collaborative source software are based.

2. Then SAP long back came with announcement that we are doing away with dependency of Java..and came BSP to take over at-least JSP.but where does it stands about open Systems like Java eco-systems where we have community system.Does Any SAP tech has ecosystem. If there is no eco-system will system evolve..that’s where Oracle has taken leap faith.A  community can create and breed new technology or a closed wall announcements.My take is SAP customers are more traditional enterprises that have long relationships with the existing ERP platform and appreciate stable upgrade paths, maintenance and support to keep operations running smoothly.

3.HANA: HANA(http://blogs.sap.com/SAPHANA/) can process both structured , unstructured, machine generated and also Social networking  data. So is Hadoop which uses the strategy of bringing the computation to the data instead of transferring the data for computation thus reducing the network delay and further running Map reduce algorithms over the data. (http://developer.yahoo.com/hadoop/ )Hadoop doesn’t suit for interactive data processing.SAP HANA focuses at interactive or realtime analytics whereas Big Data processing technologies like Hadoop which is an open source and deals with petabytes and exabytes and is not realtime based.Mere realtime examples are analyzing the logs generated by web servers of enterprises and Facebook or Linked-In data which generates hundreds of terabytes data across world everyday. But this can be analyzed with any other data warehousing tool.

CRM: Customers will be interested in running data analytics against increasing amounts of data stored in both SAP and non-SAP systems. Hence mostly they do not employ researchers or data scientists to experiment with still developing technologies like Hadoop for distributed computing and Big Data analytics.

Finally according to me HANA is not about Bigdata but more about quick or fast data for  all its customers to make quicker, better business decisions to stay ahead of the competition and hence puts SAP in a good position to expand its analytics business.But we will look further is it really able to reduce layers.

Oracle Exadata:SAP certified for exadata:

http://www.oracle.com/us/corporate/customers/turkcell-1-exadata-case-study-456284.pdf

http://www.oracle.com/us/products/database/exadata-database-machine/overview/index.html?origref=http://www.google.co.in/url?sa=t&rct=j&q=oracle%20exadata&source=web&cd=1&sqi=2&ved=0CDQQFjAA&url=http%3A%2F%2Fwww.oracle.com%2Fus%2Fexadata%2Findex.html&ei=hAu0TovnOsPQrQf5-9C-Aw&usg=AFQjCNEU0irinR_Il-5Ehwy7x2lFDXz7yg

Important Question While considering SAP HANA:

1) Cost benefit analysis :Whilst true the cost of hardware (memory / CPU) keeps decreasing and how much do you think you will be spending to deliver a system 3600x faster than your current one? Its the usual cost to benefit comparison.

2) HANA is underpinned by solid state storage / this can be raided etc for redundancy. HANA offers snapshot backups for recovery / HA / DR purposes. In its current version although it has a log capability (similar to transaction log/archive log), this log does not offer a backup option so “point in time recovery” is only available locally. ie in a disaster you could only recover to the most recent snapshot. It is for this reason (and probably others) that SAP is only focussing on it’s use in warehouse type scenarios (eg BW7.3x is to run on HANA) where it is not the database of record. In the upcoming versions when some of these enterprise database facilities are deployed then SAP I’m guessing will offer HANA as the DB for it’s operational applications (ERP / CRM etc).

4. Sybase: Mission critical financial application and mobility.Tech talks about stack-less future of heterogeneity.

-Hana comes with columar database not the latest probalistic databases.

Watch youngest india head ever presenting SAP Teched in india.

New Social Computing War Oracle Web Centre

 

Oracle Web centre is built on top of JSF based Oracle Application Framework or OAF which was the latest improvement over OAF(Oracle Application Framework).Integrated with portlet,integrated webservices,RSS,peoplesoft,BI,Mail or calendar system,content mangement, databases, Enterprise 2.0 discussion, blogs, wikki, worklist.user can collaborate and create content only, secure enterprise search, Tag on website.

It comes with Oracle presence which provides the core services needed to deliver a presence service to IP/SIP network.

The base WebCenter Framework allows you to embed portlets, ADF Taskflows, content, and customizable components in your Oracle ADF application. All Framework pieces are integrated into the Oracle Jdeveloper IDE, providing access to these resources as you build your applications.. It incorporates Web 2.0 components such as content, collaboration, and communication services

Also there are products like Oracle web centre ..which are stated to be Oracle’s new Social Network software.OSN solves the problem by bringing together real-time communication, content sharing, integration with other business applications, activity streams and search tools..Its can also take data from SIP..

 

The feature of Oracle Web centre:

WebCenter services capabilities: 80/20 rule. 80% data is unstructured data.(documents,files,word,spreadsheet,image,blog,web content management,

Social Networking Services – Enables users to maximize productivity through collaboration.

  • People Connection/Behavioral customization  – access to pages based on behaviour. Enables users to assemble their business networks like linked-in.
  • Discussions – Provides the ability to create and participate in threaded discussion. This is an embedded version of Forums provided by Jive Software.Also  they have formed an agreement that will integrate SAP’s BusinessObjects BI OnDemand software with Jive’s community and collaboration platform
  • Announcements – Enables users to post, personalize, and manage announcements.
  • Phone call from website/email button,Instant Messaging and Presence (IMP) – Provides the ability to observe the online presence status of other authenticated users (whether online, offline, busy, or idle) and to contact them.Oracle presence which provides the core services needed to deliver a presence service to IP/SIP network.you can start phone conversation using SIP netowork just by click of button(see my other blog on SIP future of telecom for more details.)
  • Blog – Enables blogging functionality within the context of an application. This feature comes from an embedded version of open source package jzWiki.
  • Wiki – Self-service, community, oriented-content publishing and sharing. This is an embedded version of open source package jzWiki.

Shared Services/competing with Sharepoint server MOSS – Provides features for both social networking and personal productivity.can be integrated with Oracle have multiple products Oracle content management OCM leader in universal content management UCM,WCM Web content management rule to make look consistent ,universal Record management (forms),images pictures sent (image management),digital asset management compress pictures/movie ,Information right management (expiration time).

  • Documents – Provides content management and storage capabilities, including content upload, file and folder creation and management, file check out, versioning, and so on. This functionality requires licensing of a JCR (JSR-170) compliant document repository product. Java community process started  8 yrs back with JSR 170 Content Repository for Java technology API. JCR started with everything is content then came JSR 170,283 Java content repository and standards on repository. http://jackrabbit.apache.org/ The Apache Jackrabbit™ content repository is a fully conforming implementation of the Content Repository for Java Technology API . “A content repository is a hierarchical content store with support for structured and unstructured content, full text search, versioning, transactions, observation, and more.” JCR standard content repository demo http://youtu.be/SObd28EuP-c .
  • Links – Provides the ability to view, access, and associate related information; for example, you can link to a solution document from a discussion thread.
  • Lists – Enables users to create, publish, and manage lists. (Available only in WebCenter Spaces)
  • Page – Provides the ability to create and manage pages at run time.
  • Tags – Provides the ability to assign one or more personally relevant keywords to a given page or document. This feature is similar to the del.cio.us website.
  • Events -Provides group calendars, which users can use to schedule meetings, appointments, and any other type of team get-together. This feature requires deployment of a separate calendering server, which may be Oracle Beehive or Microsoft Exchange. (Available only in WebCenter Spaces)

Personal Productivity Services – Focuses on the requirements of an individual, rather than a group.

  • Mail – Provides integration with IMAP and SMTP mail servers to enable users to perform simple mail functions such as viewing, reading, creating, and deleting messages, creating messages with attachments, and replying to or forwarding existing messages.
  • Notes – Provides the ability to “jot down” and retain quick bits of personally relevant information. (Available only in WebCenter Spaces)
  • Recent Activities – Provides a summary view of recent changes to documents, discussions, and announcements.
  • RSS – Provides the ability to publish content from WebCenter Web 2.0 Services as news feeds in RSS 2.0 and Atom 1.0 formats. In addition, the RSS service enables you to publish news feeds from external sources on your application pages.
  • Search – Provides the ability to search tags, services, an application, or an entire site. This makes use of a license limited version of Oracle’s search product.
  • Worklist – Provides a personal, at-a-glance view of business processes that require attention. These can include a request for document review and other types of business process that come directly from enterprise applications.

The new Cloud war and mobile Strategy

cloud wars between apple,amazon,microsoft
Apple:
From itune,ipad to iphone, to now icloud.which can leverage all these technologies and trends.now from my last post
you can guess why amazon is coming with new cloud based browser and its architectural details.As cloud comes up it breeds
new tool, new war, necessity is mother of invention..so new split browser does 90% work on cloud uses cloud power
only 10% om mobile.Amazon is only competitor to apple on icloud.
-iwork: When i work gets released, new generation office tool from apple on mobile or any devices, its ready to compete
with Microsoft office 365, and google doc. apple most wealthy company in this world is still less prized. only 14 times
its future revenue compared 11 times of microsoft or google..reason its growing 67% in revenue...its no.1 and double the 
size of next competitor.iWork: When its start cutting iwork it will eat up more of Microsoft revenue.
Apple cross-platform app open strategy of apple is winning streak bringing collaboration to work. 

Google: 

Chormebook, with chrome based apps (just like app store for apple) will start competing iPad.
features last year
- file storage,music stream all chrome app.
- get more dependent on webizimo.
- sun had old net strategy.(but no content was given). google has so much content to consume from Gmail to YouTube,
- leverage pattern to see consumer behaviour.
google finance etc.
Microsoft - leveraging of complaint is gift.(they like your product except for).
- Microsoft.people preception MS not fixing issues in present version but releasing new versions every time.
- IBM (the legacy player) has Microsoft eating its revenue stream from OS,servers,office,mail servers,database,langauge.
- icloud,iwork for tablet vision office suit will be competing with office 365.
- on tablet .Microsoft will going to become legacy provider for migrations.
biggest legacy company IBM has highest share still..interesting how stock market behave.

Samsung
interesting to see how Samsung (the dark horse) is only provider of hardware and licensed version of other software OS.
Samsung has collaborated with google last year launch of android phone..then ran into dispute will apple and losing it.
now also had tied up with windows mobile.Looks like Samsung is taking all side just want to be one eating everyone 
revenue.
interesting to see how samsung (the dark horse) is only provider of hardware and licensed version of other software OS.
samsung has collaborated with google last year launch of andriod phone..then ran into dispute will apple and lossing it.
now also had tied up with windows mobile.Looks like samasung is taking all side just want to be one eating everyone revenue.
 
Oracle:
The late comer had Oracle RAC for RDBMS which does same almost computation as Hadoop hive do for realtime data.
Oracle has every component on cloud from server to storage to databases, identity management to ERP and now cloud is 
ready but where is mobile strategy.Even open world Larry Ellison announced cloud will be ready in next few moths after
getting jitters from sales force CRM CEO.Lary has taken best of both world approach. The application unlimited strategy.
Just like FMCG majors Hindustan levers strategy of different product for each differentiation. Fusion app is being ready
as platform for future cloud.
EMC mobile stategy.
focused on mobile user response to application,gestures,content they want to access,function and capabilty of device
New software application for mobile based on 
--guided navigation.
(GUIDE WHERE is content,what they want to see )
--search and filter capabilities.(taking content offline).
--acessing content anywhere.
--document and repository.