Skip navigation.

Feed aggregator

Code Comments Gone Wrong

Eddie Awad - Sat, 2012-05-19 22:15

Dimitrios Kalogirou offers good advice:

Write self descriptive code ! Your code should be read like sentences. Avoid smart shortcuts and tricks because they break the reading… I use code comments when the code is not really self documenting. Comments should convey what code cannot. They should explain the reasons for a specific design decision, they should explain what code is supposed to achieve and why.

Related articles:

© Eddie Awad's Blog, 2012. | Permalink | Add a comment | Topic: Tips | Tags:

Oracle Adaptive Access Manager (OAAM) for beginners

Online Apps DBA - Sat, 2012-05-19 17:52


Oracle Adaptive Access Manger  is an Access Management product from Oracle Access Management Suite Plus (other products from Access Management Suite plus are OAM, OES, OIF, eSSO, OpenSSO Fedlet, OWSM, and STS ).  To know more about OAAM check Mahendra’s post and for OAAM version 11.1.1.5 my previous post here. For list of all Oracle Identity and Access Management products click here

This post covers OAAM 11g R1 (11.1.1.*) for beginners and highlight overview of OAAM installation, configuration, and accessing OAAM for first time .

 

1. OAAM 11g is a J2EE application deployed on Oracle WebLogic Server. If you are new to Oracle WebLogic Server then check  WebLogic Domain, Admin Server and Managed Server

2. OAAM 11g includes two components
a) OAAM Online : For Real-time risk analysis
b) OAAM Offline : For offline risk analysis

3. OAAM is part of Identity and Access Management software (IAM) same software that contains OAM, OIM, OES, and OIN .

4. OAAM’s deployed applications for OAAM 11g are

a) OAAM Server: OAAM Server is a run-time component that includes rules engine and end user interface flows deployed on WebLogic Managed Server. OAAM server provides Adaptive Risk Manager, Adaptive Strong Authenticator, Web Services etc.

b) OAAM Admin Console : Administration console (Web Application aka OAAM Admin) that contains customer service and security analyst case management functionality.

 

High Level Installation Steps for OAAM 11g:

1. Install Database for OAAM schema
2. Use RCU  to load OAAM schema


3.
Install WebLogic Server, for 64 bit O.S. use steps mentioned here

4.
Install Identity and Access Management Software as mentioned here  (Steps here are for 11.1.1.3. Use same steps but install version 11.1.1.5 Note: 11.1.1.5 is latest OAAM version as of May 2012)

5. Configure OAAM by running $MW_HOME/oracle_common/common/bin/config.sh

  • when prompted for schema name, provide schema details creating using RCU

 

  • OAAM configuration in online mode will create Admin Server and two Managed Servers (one for OAAM Admin Server and second for OAAM Server)


6.
Start Node Manager, Admin Server, and Managed Servers (Do Not forget to set StartScriptEnabled=true in nodemanager.properties)

7. Create User for OAAM and add user in OAAM* group (to grant OAAM Role) using WebLogic Console

8. Access OAAM Admin Console http://host:OAAMAdmin_ManagedServer_port/oaam_admin


9.
Access OAAM Server http://host:OAAMServer_ManagedServer_port/oaam_server

 

Previous in series Related Posts for OAAM
  1. Oracle Adaptive Access Manager – Strong Authentication Overview
  2. Oracle Adaptive Access Manager 10g R3 – Released, New Features
  3. Oracle Adaptive Access Manager (OAAM) for beginners
Categories: APPS Blogs

Week Two of the RM BI Forum 2012, in Atlanta

Rittman Mead Consulting - Sat, 2012-05-19 11:34

I’m just back now from Atlanta, having been over there for the past week helping run the second week of the RM BI Forum 2012. Around 55 BI professionals from around the USA (and with a few from Europe) got together over four days to network, share tips and techniques around Oracle BI development, meet the Oracle PMs, and enjoy themselves downtown in Atlanta, GA.

The format of the US BI Forum followed the same structure as the UK one, with Kevin McGinley providing the masterclass on the Tuesday, the main conference running on Wednesday and Thursday, and the NDA BI Developer day on the Friday organized in conjunction with Oracle. Kevin’s session was if anything even better received than in Brighton, with topics ranging from the Action Framework through Oracle Scorecard & Strategy Management, UI customization and of course BI Mobile. Thanks again to Kevin for taking the time to develop the materials, and then join us over two weeks to deliver the masterclass and then take part in the event itself.

Untitled

The main conference then kicked-off with Tim and Dan Vlamis talking about dashboard best practices, then went on to cover Endeca, OBIEE performance tuning, security, Exalytics, RPD data modeling, big data and the new 11.1.1.6.2 SampleApp. As with Brighton, we ran a number of 10-minute sessions over the two days, including some Ignite-style sessions that had slides that auto-advanced every thirty seconds, and TED-style sessions where the speaker covered a controversial or counter-intuitive topic with minimal slides and sometimes props. Here’s Christian Screen, from Cap Gemini and ArtofBI.com, delivering his Ignite session on how to become an Oracle ACE.

Untitled

The Best Presentation Award went in the end to our own Jordan Meyer, who talked about the wider world of data visualizations including examples such as the Billion Dollar Gram, a facebook network visualization created using R, and other examples created using Oracle’s R toolkit and embedded in Oracle BI dashboards. Jordan had a great relaxed but engaging presenting manner, covered some hot new technology and even managed to create a visualization based on Stewart’s comments about Apple on our internal mailing list, shown in the photo below along with the subject.

Untitled

Although the event is primarily community organized, we had some exceptional support from the Oracle BI product management/development team again this year in Atlanta, including Matt Bedin who heads-up developer outreach for Oracle BI, Philippe Lions who demonstrated the new 11.1.1.6.2 SampleApp and provided a beta version for delegates to take away with them, and Pravin Janardanam who recently joined the product management team and is responsible for the metadata elements of the BI Server. We were also privileged to be joined for the second year by Jean-Pierre Dijcks who ran a whiteboarding session on big data, and Adam Ferrari, ex-CTO of Endeca who talked about the Oracle Endeca Information Discovery platform and analyzed, live, the tweet stream from this week’s, and the previous week’s, attendees. Thanks again to everyone from Oracle, especially for staying around for all four days and taking part in all of the sessions.

Untitled

Friday, as with the Brighton week, was a special BI Developer day organized in conjunction with Oracle BI product development and held under NDA (non-disclosure agreement), where we were taken through the product roadmap in more detail and looked in particular at a couple of significant changes/developments in the OBIEE product architecture. Of course I can’t go into any detail now, but thanks again to Oracle for this and watch this space for insight and analysis once things become public.

So that’s it for now. I’ll do one final blog post early next week to post all of the presentation PDFs, and photos from the US event can be viewed in this BI Forum Atlanta 2012 Flickr set. Thanks again to everyone, and no doubt we’ll start planning the 2013 event very soon!

Categories: BI & Warehousing

using ovm_utils

Wim Coekaerts - Sat, 2012-05-19 11:03
Now that we released Oracle VM 3.1 and I just added ovm_utils 0.5.2 on ARU, it's time to give a few examples/use cases of the utilities :)

The utilities are available for download from http://support.oracle.com search for patch name 13602094.

It's a small 2.5Mb zip file which you should install on the manager node and unzip in /u01/app/oracle/ovm-manager-3. There are manpages for the utilities as well. These are installed in /u01/app/oracle/ovm-manager-3/ovm_utils/man/man8. To make it easy, simply add this to your MANPATH : export MANPATH=/u01/app/oracle/ovm-manager-3/ovm_utils/man.

To use the utilities you need the admin username and password for the manager instance and in general you can just use localhost as the hostname. If you want to be able to connect to a remote manager instance, you have to first enable SSL on the manager node. By default we listen only on 127.0.0.1. There is an option in the utils to make a secure connection, use -X, but again, you first have to enable SSL for this. You can enable secure connections using ovm_utils and the addkeystore command. We have a support note for this.

So the format is something like : ./ovm_managercontrol -u admin -p mypassword -h localhost -c [options...]..
There are quite a few commands in the various utilities at this point. I broke the utilities up into categories :br

  • ovm_managercontrol : generic manager level functions
  • yuminfo : display yum configuration
    setupyum : configure yum
    addkeystore : configure the SSL keystore
    keystoreinfo : display keystore file and path
    createcpugroup : create a CPU Compatibility group
    removecpugroup : delete CPU Compatibility group
    addservertocpugroup : add server to CPU Compatibility group
    removeserverfromcpugroup : remove server from CPU Compatibility group
    listcpugroups : list all CPU Compatibility groups and its servers
    setsessiontimeout : set VM Console session timeout (Oracle VM 3.1+)
    getsessiontimeout : display VM Console session timeout(Oracle VM 3.1+)

  • ovm_repocontrol : generic repository level functions
  • list : list all repositories
    status : query repository status
    info : display repository information
    refresh : send a repository refresh command
    fixrepo : fix a failed repository create
    create : create repository on a storage device

  • ovm_poolcontrol : generic server pool level functions
  • status : display the current status of the server pool
    info : display server pool info such as memory, utilization, servers,...
    list : list all server pools registered with this Oracle VM Manager instance
    events : list all latest event types for this server pool
    addserver: add server to this server pool (-S server name)
    removeserver: remove server to this server pool (-S server name)
    refresh : refresh storage in the server pool

  • ovm_servercontrol : generic server level functions
  • start : use IPMI to power-on the server
    stop : shutdown the server
    kill : use IPMI to power-off the server
    mainton : turn on maintenance mode for this server
    maintoff : turn off maintenance mode for this server
    status : display the current status of the server (Running,Stopped,...)
    info : display server info such as memory, utilization, server-pool,...
    lock : temporarily lock the server disallowing any updates to happen
    upgrade : send an upgrade command to the server
    list : list all servers registered with this Oracle VM Manager instance
    events : list all latest event types for this server
    discover : discover server with provided hostname or IP address and Oracle VM agent password (-P)
    listnfsexports : list NFS exports on this server
    deletenfsexport : delete an NFS export on this server
    createnfsexport : create a new NFS export on this server

  • ovm_vmcontrol : generic Virtual Machine level functions
  • start : start the Virtual Machine
    stop : Power-off the Virtual Machine
    suspend : Suspend a running Virtual Machine
    kill : Kill the Virtual Machine
    resume : Resume a suspended Virtual Machine
    restart : Restart a running Virtual Machine (Power-off, start)
    status : display the current status of the Virtual Machine (Running, Stopped,Suspended)
    info : display Virtual Machine info such as memory, utilization, server-pool,...
    lock : temporarily lock the server disallowing any updates to happen
    events : list all latest events for this Virtual Machine requiring acknowledgement
    list : list all Virtual Machines registered with this Oracle VM Manager instance
    vcpuset : bind virtual cpu’s to physical threads for this Virtual Machine
    vcpuget : list bindings of virtual cpus to physical threads for this Virtual Machine
    settags : store a set of comma separate custom tags for a Virtual Machine
    gettags : retrieve list of tags for this Virtual Machine
    fixcfg : fix Virtual Machine Configuration file
    delete : delete Virtual Machine

  • ovm_vmdisks : a utility to list the virtual disk info for a given Virtual Machine
  • ovm_vmmessage : utility to send/receive message to/from a Virtual Machine using the Oracle VM VM API
  • Here a a few (hopefully) useful examples:

    # ovm_managercontrol -u admin -p Manager -h localhost -c getsessiontimeout
    # ovm_managercontrol -u admin -p Manager -h localhost -c setsessiontimeout -T 60

    Session timeout is the Oracle VM Console session timeout (connect to a Virtual Machine console). When you have a slow network, the default timeout of 30 seconds might be too short and this lets you set this to a longer (or shorter value).

    # ovm_servercontrol -u admin -p Manager -h localhost -c listnfsexports -s server1
    Oracle VM Server Control utility 0.5.1.
    Connected.
    Command : listnfsexports
    NFS Exports :
            id         : 0004fb0000230000978a28e2dc85e06b
            client     : ca-srs1
            options    :
            repository : SATA_ST3500320AS_5QM1EYTX
            path       : /OVS/Repositories/0004fb000003000031fac25b24740cca/
    ---
            id         : 0004fb00002300004b161fd1a0d106b7
            client     : ca-vdi1
            options    : rw,no_root_squash
            repository : SATA_ST3500320AS_5QM1EYTX
            path       : /OVS/Repositories/0004fb000003000031fac25b24740cca/
    ---
    Exit... 

    nfs exports are very useful and new in 3.1. It is now possible to export a local ocfs2 repository on a FC, iscsi or local disk device to be exported from an Oracle VM server to the outside world. You define which repository and which client can mount the repository. listnfsexports lists the exports defined on a specific Oracle VM Server.

    # ovm_servercontrol -u admin -p Manager -h localhost -c createnfsexport -s server1 
    -C ca-vdi1 -o rw,no_root_squash -r SATA_ST3500320AS_5QM1EYTX
    Oracle VM Server Control utility 0.5.1.
    Connected.
    Command : createnfsexport
    Creating nfs export for repository 'SATA_ST3500320AS_5QM1EYTX' on server.
    Created repository export
    Exit... 

    Here I have a repository named SATA_ST3500320AS_5QM1EYTX (this happens to be a local disk on server1) and I am exporting that repo through nfs to external server ca-vdi1. So now, on ca-vdi1, I can do mount server1:/OVS/Repositories/0004fb000003000031fac25b24740cca /mnt and I can backup(or restore) files.

    # /ovm_servercontrol -u admin -p Manager -h localhost -c deletenfsexport -s server1 
    -i 0004fb0000230000978a28e2dc85e06b
    Oracle VM Server Control utility 0.5.1.
    Connected.
    Command : deletenfsexport
    Deleting nfs export with ID '0004fb0000230000978a28e2dc85e06b'
    Deleted repository export
    Exit... 

    Simply deleting a repository. You need to specify the UUID of the nfs export, which you can find using listnfsexports.

    # ovm_repocontrol -u admin -p Manager -h localhost -c create -r foo -s wopr5 
    -i 3600144f057ef8a0000004fb3194b0001
    Oracle VM Repository Control utility 0.5.1.
    Connected.
    Command : create
    Found LUN with id '3600144f057ef8a0000004fb3194b0001'
    Creating Filesystem...
    Creating repository... Please wait...
    Create repository completed.
    Exit... 

    Create a repository on the LUN with a specific UUID. This works around slow storage where we hit a 2 minute timeout.

    # ovm_vmcontrol -u admin -p Manager -h ovmm -c vcpuget -v apitest
    Oracle VM VM Control utility 0.3.9.
    Connected.
    Command : vcpuget
    Current pinning of virtual CPUs to physical threads : 2,3
    

    Pinning virtual CPU's to physical threads.

    # ovm_vmcontrol -u admin -p Manager -h ovmm -c vcpuset -v apitest -s 5,6
    Oracle VM VM Control utility 0.3.9.
    Connected.
    Command : vcpuset
    Pinning virtual CPUs
    Pinning of virtual CPUs to physical threads '5,6' 'apitest' completed.
    A restart of Virtual Machine 'apitest' is required. 
    

    # vm_servercontrol  -u admin -p Manager -h localhost -s server -c events -A all
    Oracle VM Server Control utility 0.3.10.
    Connected.
    Command : events
    Server Events
    Acknowledging Virtual Machine events
            Virtual Machines on this server :
    VM : el5u4_32_pvm_1
    VM : el6u1_64_hvm_1
    VM : el5u7_64_hvm_1
    VM : el5u7_64_pvm_1
    VM : el6u1_64_pvm_1
    VM : el6u2bd5_32_pvhvm_1
    VM : el6u1_32_pvm_1
    VM : uek-boot-el5-64
    Exit..

    Acknowledging events on a given server, including any guest events.

    My First Experience Running SLOB – Don’t repeat my errors (AWR)

    Pythian Group - Sat, 2012-05-19 09:36
    If you are wondering what I am busy with then this post explains it. As you may noticed I am still testing one of the Oracle systems using the SLOB framework and learning on my way. I ran several tests with the same parameters (Readers 24) and I noticed that for one reason or another awr.txt reports [...]
    Categories: DBA Blogs

    Repairman Jack : Harbingers

    Tim Hall - Sat, 2012-05-19 08:16

    Harbingers is the tenth book in the Repairman Jack series by F. Paul Wilson.

    The last of Jack’s relatives are gone. Are his girlfriend (Gia), her daughter (Vicky) and Jack’s unborn child the next in line? Is there anything Jack can do to protect them?

    This book focuses more on Jack’s relationship to “The Otherness” and “The Ally”. We see a more aggressive side of Jack, as well as the cold calm detachment when he’s doing his job. Dark, dark, dark, but also kinda exciting.

    Cheers

    Tim…

     

     

    Repairman Jack : Harbingers was first posted on May 19, 2012 at 3:16 pm.
    ©2012 "The ORACLE-BASE Blog". Use of this feed is for personal non-commercial use only. If you are not reading this article in your feed reader, then the site is guilty of copyright infringement.


    Meet The Experts: Matthew Morris

    OCP Advisor - Sat, 2012-05-19 06:19
    OCP Advisor interviewed Matthew Morris, one of the earliest Oracle Certified Professional (OCP) and now a popular author of OCP study guides. Matthew was among the first hundred to be OCP DBA certified on Oracle 7.3 and has since upgraded his certification to releases 8i, 9i, 10g and 11g. 
    OCP Advisor: Hello Matt, on behalf of OCP blog readers we are delighted to have you as our featured Oracle Expert. Please tell us something about your professional experience.
    Matthew Morris: In early 1996, I started working for Oracle Support as part of the RDBMS Server Technologies team.  Over the first few months, I read every Oracle Press book I could get my hands on from cover-to-cover! I was the top rated support analyst and was asked to develop and deliver courses for team members.  After four years of DBA support, I changed my focus to PL/SQL and Web development.  I developed database tools and applications to assist managers and analysts in the Oracle Support team.  Currently I work at Computer Sciences Corporation and is responsible for developing custom database applications using PL/SQL and Oracle APEX. 
    OCP Advisor: Please tell us about your Oracle Certification path and what motivated you on this path.

    Matthew Morris: Two years after I started working for Oracle, Oracle Certified Professional program was launched.  Sylvan created at testing center in our office building. I was interested in demonstrating my knowledge, so I took and passed all four of the OCP DBA tests. I learned that this made me one of the first hundred people to become an Oracle Certified Professional (OCP)! Later that year, Oracle introduced the Oracle Developer Certification and I took the four developer tests in a single day and became one of the first hundred Oracle Certified Developers.  Since then, I have tried to keep my certifications current. 
    OCP Advisor: You are a popular author of several Oracle Certification guides. Please let us know how you started writing them.

    Matthew Morris: In May 2011, I developed a study guide for 1Z0-050: New Features for Administrators.  Then in late 2011, I began studying for 1Z0-450: Oracle Application Express 4: Developing Web Applications.  For almost every exam, my preparation includes creating a study sheet with key testing points.  For 1Z0-450, this sheet rapidly became much larger and more elaborate than usual.  It seemed reasonable at the time to go the extra mile and make it into a publishable study guide.  Ultimately, I found that doing this did not add an extra mile but rather an extra ten to fifteen miles!  However, once it was published, the result was heartening.  I modified the 1Z0-050 course material I had developed earlier into a second study guide and published it as well.  Since those first two, I have published study guides for the SQL Expert and SQL Fundamentals exams. Currently, I am developing exam guides for the OCP DBA I and DBA II exams.
    OCP Advisor: Please share with our blog readers about the content of the Oracle Certification Guides you have published?

    Matthew Morris: The Oracle Certification Prep series targets two groups of candidates.  The first group consists of Oracle professionals who want to get certified in a subject they are experienced in and would like a reference guide to help them ‘bridge the gaps’.  The second group are those who are already using another source of information in their study plan but would like to have a second reference.  It is especially valuable for candidates using only Oracle documentation but would like to have an inexpensive reference against which to determine how well they did.  To help both these audiences, the study guides present information about the test topics in a very condensed format.  The intent is to deliver facts that candidates need to know, functions and features they need to recognize, in a compact format enough to revise several times.  
    OCP Advisor: What advice do you have for candidates preparing for an Oracle Certification exams?

    Matthew Morris: From the posts on the various certification forums I frequent, there are many candidates who are studying just to pass the exams rather than to gain knowledge.  Learning how to pass a test does not prepare someone to perform well at professional level.  Use the opportunity when studying for Oracle certification to make a concerted effort to learn the concepts first.
    OCP Advisor: Please share with our blog readers one habit that has contributed most to your professional success?

    Matthew Morris: Setting a realistic expectation determines whether you succeed or fail.  I try to set a reasonable time frame and give my very best to deliver ahead of every deadline. 

    Much Ado About Nothing?

    Rob van Wijk - Sat, 2012-05-19 03:58
    I was reading this presentation PDF of Hugh Darwen recently, called How To Handle Missing Information Without Using NULL. Several great thinkers and founders of the relational theory consider NULL as the thing that should not be. For example, one slide in the above mentioned PDF is titled SQL's Nulls Are A Disaster. And I found a paper with the amusing title The Final Null In The Coffin. I can Rob van Wijkhttp://www.blogger.com/profile/00499478359372903250noreply@blogger.com0

    Advisor Webcast Inter-window Communication (IWC)

    Kasper Kombrink - Sat, 2012-05-19 02:49
    On May 15 Oracle held an Advisor Webcast on Inter-window Communication. In my opinion one the most exciting features added in PeopleTools 8.52. IWC makes it possible to have Pagelets communicate with each other on homepages, dashboards, workcenters and related content. This really brings an interactive Dashboard experience to PeopleSoft in the way Webcenter does [...] Related posts:
    1. PeopleTools 8.51 Advisor Webcast
    2. PeopleTools 8.51 Available
    3. Create interactive dashboards with InterWindow Communication (IWC)

    Advisor Webcast Inter-window Communication (IWC)

    LogicaCMG - Sat, 2012-05-19 02:49
    On May 15 Oracle held an Advisor Webcast on Inter-window Communication. In my opinion one the most exciting features added in PeopleTools 8.52. IWC makes it possible to have Pagelets communicate with each other on homepages, dashboards, workcenters and related content. This really brings an interactive Dashboard experience to PeopleSoft in the way Webcenter does [...] Related posts:
    1. PeopleTools 8.51 Advisor Webcast
    2. PeopleTools 8.51 Available
    3. Create interactive dashboards with InterWindow Communication (IWC)

    OEM12c Discovery of Exadata Cluster

    Pythian Group - Sat, 2012-05-19 01:00
    dbm_configurator.xls is needed to generate databasemachine.xml file which is needed by OEM 12c to discover an exadata cluster. Following is a step  by step process as how to generate databasemachine.xml file to be used with OEM 12c: 1) Get the dbm_configurator70.xls file from /opt/oracle.SupportTools/onecommand directory from the first compute node of Exadata cluster. 2) Also [...]
    Categories: DBA Blogs

    C.J. Date's Database Design and Relational Theory: Normal Forms and All That Jazz Master Class

    Surachart Opun - Fri, 2012-05-18 19:31
    How to make the good design databases? That is the hard question. In my opinion, You were supposed to understand the theory, that can help. Database Design theory, Like Normalization or Normal Form.  Anyway, You can find out about them in the internet. By the way, I suggest to attend "C.J. Date's Database Design and Relational Theory: Normal Forms and All That Jazz Master Class" seminar.
    You will learn about.
    1. Preamble2. Normalization (= further normalization)a. Generalities b. FDs and BCNF  - informal  - formal  - preserving FDs  - FD axiomatizationc. A remark on denormalizationd. JDs and 5NF- informal- formal- implicit dependencies- the chasee. MVDs and 4NFf. Other normal forms- 6NF and RFNF3. Orthogonality4. Redundancy
    However, You can purchase "C.J. Date's Database Design and Relational Theory: Normal Forms and All That Jazz Master Class" videos from O'reilly. You can take your time for learning and understand about Normal Forms and etc.

    What will you see in Videos?- Preamble :- What design theory is and why its important. Logical vs. physical design. Redundancy and update anomalies.- A Review of Relational Basics :- Relations vs. relvars. Predicates. The importance of constraints.- Normalization - Preliminaries :- Nonloss decomposition. Normalization serves two purposes. Role of projection and join. The normal form hierarchy.- Normalization - FDs and BCNF (informal) - Part 1 :- What 1NF really is. Functional dependencies (FDs).- Normalization - FDs and BCNF (informal) - Part 2 :- Superkeys and subkeys. 2NF, 3NF. BCNF (the normal form with respect to FDs).- Normalization - FDs and BCNF (formal) :- A crucial mental shift. What FDs and BCNF really are. Heaths Theorem.- Normalization - Preserving FDs :- Good and bad decompositions; why the classical normalization procedure is inadequate. Irreducible covers. 3NF and BCNF algorithms.- Normalization - FD Axiomatization :- Reasoning about FDs. Armstrongs axioms. Soundness and completeness.- Denormalization :- A definition. Denormalization considered harmful. Role of star schemas.- Normalization - JDs and 5NF (informal) :- A surprising fact. Join dependencies (JDs). A relvar in BCNF and not 5NF. Tuple forcing JDs.- Normalization - JDs and 5NF (formal) - Part 1 :- What JDs and 5NF really are. JDs implied by keys.- Normalization - JDs and 5NF (formal) - Part 2 :- A useful theorem. Update anomalies revisited.- Normalization - Implicit Dependencies - Part 1 :- JD equivalence and JD implication. Irreducible JDs. Equivalence proofs.- Normalization - Implicit Dependencies - Part 2 :- Sets of dependencies. Explicit vs. implicit dependencies.- Normalization - The Chase :- Given a set of dependencies, what dependencies are implied by those in that given set?- Normalization - MVDs and 4NF :- Another kind of dependency. Fagins Theorem. Axiomatization. Embedded dependencies.- Normalization - Other Normal Forms - Part 1 :- 6NF. 5NF revisited: another surprising fact. Redundancy free relvars.- Normalization - Other Normal Forms - Part 2 :- RFNF (ETNF); SKNF; DK/NF. The end of the road?- Orthogonality :- Normalization reviewed. A little more science: The Principle of Orthogonal Design. The relationship between orthogonality and normalization.- Redundancy - Part 1 :- Tuples vs. propositions. What is redundancy? Examples of normalized, orthogonal, redundant design.- Redundancy - Part 2 :- Dealing with redundancy: four approaches. Controlled vs. uncontrolled redundancy.- Redundancy - Part 3 :- A proposed definition. Historical notes.- The Primacy of Primary Keys :- Are primary keys necessary? The invoices and shipments example.- Redundancy Revisited :- Vincents definition. Yet another normal form. Further reading.
    It's easy, you can choose each topic you need to learn. 
    In videos, You will learn a lot of idea. It's helpful to understand easy. Because you will be able to learn from examples in video and you can rewind again and again. Wow! that nice. Anyway, You can upload them to iPad/iPhone or etc. You can watch them while you are on the bus.
    If you are students? In Database course for College or University, I believe this video will help students for understand about Normalization and Relational concept... blah blah


    One thing, this video was presented by C.J. Date (who has a stature that is unique within the database industry. C.J. is a prolific writer, and is well-known for his best-selling textbook: An Introduction to Database Systems (Addison Wesley). C.J. is an exceptionally clear-thinking writer who can lay out principles and theory in a way easily understood by his audience).


    I don't see the reason what makes this video is useless. If you work in database career, or you are studying about Database Design ,Relational Theory or Normal Forms... and you are thinking to get some stuff about them, you should determine for this stuff. 
    Written By: Surachart Opun http://surachartopun.com
    Categories: DBA Blogs

    8 Core Beliefs of extraordinary bosses

    OracleApps Epicenter - Fri, 2012-05-18 18:05
    There are many kinds of bosses. Nice bosses, nasty bosses, power-hungry bosses, placid bosses, insecure bosses and so the list goes on. So what kind of boss are you? Does your boss fits the description? Great article written by Geoffrey James on 8 Core Beliefs of Extraordinary Bosses, from article in Inc Magazine: Business is [...]
    Categories: APPS Blogs

    Learn more about Oracle’s next generation applications, Fusion Applications

    OracleApps Epicenter - Fri, 2012-05-18 18:05
    Want to learn more about Oracle's next generation applications, Fusion Applications.Here are some of the post , that helps you to understand better. ORACLE FUSION APPLICATIONS is the integration of Oracle applications such as E-Business Suite, PeopleSoft, JD Edwards & Siebel into a set of next generation applications based on open industry standards.Fusion Applications is [...]
    Categories: APPS Blogs

    “Signal 11″ : Not So Scary Anymore..

    OracleApps Epicenter - Fri, 2012-05-18 18:05
    ‘Signal 11’ is one of the most scary things in EBS developer/Apps DBA community . If you haven't encounter yet , after working couple of years in EBS, that means you are quite lucky ..kidding If you came from basic C programing skill, then you might be linking with malloc ..memory allocation , believe me, [...]
    Categories: APPS Blogs

    eAM/GIS Public APIs

    OracleApps Epicenter - Fri, 2012-05-18 18:05
    Geographical Information Systems (GIS) is software for capturing, managing, analyzing and displaying spatially referenced data. GIS makes it easier to: Locate and point to entities on a map Ask for information about the entity Enables use by company's maintenance users not skilled in IT when you are doing integration with any of GSI application, you [...]
    Categories: APPS Blogs

    Pre-requisities , Credit hold & credit check ….

    OracleApps Epicenter - Fri, 2012-05-18 18:05
    What is the main difference between Credit check and Credit Hold? Credit Hold is used to prohibit orders from being progressed beyond entry or booking, from a specific customer. It is not dependent on Credit Limit or Previous Balance or any criteria. This is normally used when you need to immediately stop all ordering for [...]
    Categories: APPS Blogs

    Do More with Oracle WebCenter to Create Engaging Online Experiences

    WebCenter Team - Fri, 2012-05-18 13:47

    Today’s guest post comes from a member of our WebCenter Evangelist team, Noël Jaffré, a Principal Technologist based in France.

    Today’s public websites are no longer purely content driven informational sites and today’s extranets are no longer strictly transactional in nature.  In many cases, your online engagement strategy may require a combination of both informational marketing content as well as online services, to engage your customers and to enable them to do business with you effectively.

    For example, financial institutions require marketing content, say on different investment options, that is designed to help convert prospects into customers, as well as robust and secure capabilities that allow customers to conduct their financial transactions.  In this case, a combination of capabilities including web experience management and portal are required to make this type of online initiative successful with the ultimate goal of creating an experience that is seamless and consistent from the customer’s perspective.


    Deliver Seamless Marketing Sites and Self-Service Extranets with Oracle WebCenter

    Deliver Seamless Marketing Sites and Self-Service Extranets with Oracle WebCenter

    So whether you take content created and managed in your web experience management solution and embed it in a transactional application using portal or native APIs, or whether transactional applications are embedded in the web experience, Oracle WebCenter provides a complete platform to design and build the best online experiences across public marketing sites, self-service extranets and intranets.

    With WebCenter you can:

    • Drive sales and loyalty with engaging cross-channel online experiences
    • Enable self-service extranets, intranets and custom application dashboards
    • Enhance productivity with social collaboration
    • Optimize information access with content management

    Want to learn more about how to do more with Oracle WebCenter, view our recent webcast.

    Watch NowDo More with Oracle WebCenter: Expand Beyond Web Experience Management

    Are you providing your customers with engaging online experiences using Oracle? If so, you probably realize that there's more to exceptional customer engagement than just Web experience management. You must also empower your business by engaging and enabling employees and partners to deliver on customers' expectations. View this on demand webcast and learn how to meet your engagement goals by doing more with Oracle WebCenter.

      View webcast now.

      Oracle VM 3.1 released

      Wim Coekaerts - Fri, 2012-05-18 13:36
      Today we formally announced the release of Oracle VM Server for x86 3.1. It is available for download from http://edelivery.oracle.com/linux. The software consists of 2 ISO images, the Oracle VM 3.1 Manager iso and Oracle VM 3.1 server iso... You can find the documentation library on the documentation website.

      Quite a few enhancements went into this release :

    • Oracle VM Manager UI enhancements to improve ease-of-use.
    • We continue to reduce the number of clicks to do actions and also have very easy to use and very streamlined configuration wizards and setup wizards. For instance for create VM or Create Server pool.

    • Storage enhancements for backup and recovery purposes.
    • It is now possible to do an nfs export on an Oracle VM server of a local/shared SAN/iscsi repository. When you have a filesystem based (ocfs2) repository with Oracle VM 3, only servers that are part of the Server pool can access the filesystem, with this new enhancement, you can define an nfs client hostname/IP address which will be allowed to do a remote nfs mount of this volume for backup purposes (or restore).

    • Using Unbreakable Enterprise Kernel 2 (2.6.39+) as the dom0 kernel
    • We now use the exact same Linux kernel for Oracle Linux with 2.6.39 (uek2) and for Oracle VM 3.1. This is possible because of all the work we have done together with Citrix/Xensource people over the last few years to get the necessary support for Xen and Linux merged into Linux. As I have mentioned in a previous blog entry, Linux mainline contains everything needed to have Linux be a complete dom0 management kernel for Xen without any additional patches. Unlike some of the FUD out there about "Xen" not being part of Linux, we have always made clear that Xen is a hypervisor. And Linux runs on top as the management/control domain kernel giving a great level of separation/isolation. In enterprise environments this is a big deal and helps us create solid, stable, secure solutions.

      The advantage for customers is that we do an incredible amount of testing on uek2 in terms of performance, network, disk io and scalability/stability in general and now Oracle VM automatically benefits from this additional testing. On top of that, for our partners, they do not have to worry about testing 2 different products in terms of drivers, since we share the exact same code base we have the exact same drivers for our hardware/storage vendors.

    • Clone many times
    • Simply the ability to say, clone a template X times in one step.

      You can find more information in the documentation set and in the release notes.