Opportunity: Probable alternative that can come in handy in various situatinos
             In computing parlance in spreadsheets,dbms functions 

scenario   : Rounding of numerical figures , for ex : 45.5,55.5,99.5

             given the scope ...for instance taking oracle into 
             consideration , the functions abs,ceil,floor return
             different values for the same function. 

Requirement: many a times while rounding off in arithematical and accounting
             terms ...for instance using abs ...may either require rounding
             of the above values to eighter "largest integer value that is equal to
             or less than a number" or "smallest integer value that is greater than
             or equal to a number" ...depending on the situation or policy.


Solution : given the requirement ...passing a flag to the ABS function
           to emulate one of the above ...proves or provides a handy
           solution

terms & conditions: for more details refer to as detailed in

http://uk.geocities.com/ravivenkatus/projects.pdf


----------------------------------------------------------------------------------------------

Terms & conditions: for more details refer to as detailed in

http://uk.geocities.com/ravivenkatus/projects.pdf,

read through the document 'opportunity_DWH_BI_product_orchrestrization.txt'


Opportunity: Integrate spread sheets(msoffice/openoffice/group ware)
             or DSS with RDBMS ....to leverage DSS on the data lying
             in the underlying schema of the Database

scenario   : Dataware housing requires providing analytical capacities to
             data from various data sources ...of which RDBMS or DBMS happens
             to be one of the source's.

Problem Statement: It should be possible to import the data and its underlying
                   relation ships from database into to various worksheets in
                   a workbook viz. each or every entity(table or view) in the
                   database to corressponding worksheet in the DSS and translating
                   relationships on data present in various worksheets in the
                   work book ....Thus giving the necessary capability to leverage
                   the DSS capabilities on the data 
                   


Solution : Given the requirement ...availability of various datamining solutions
           that undermine the E-R present in a database schema's ....

           It should be possible to write a provider or solution (ex : Ole db , udl) 
           that translates data in the Database into data in a DSS , to make
           or let the above a possibility.

           


Note: The above problem statement having been encountered in various scenarios
      and detailed in various 'Proof of concepts' as mentioned in 
      
       http://uk.geocities.com/ravivenkatus/projects.pdf
       http://ravishankarkv.tripod.com/projects.pdf
        ....apply appropriate
      'use-case' modeling and arrive at a workable and feasible solution both
       commercially and techinically viable.


----------------------------------------------------------------------------------------------
