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

scenario   : Rouding 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


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

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) 
           that translates data in the Database into data in a DSS , to make
           or let the above a possibility.

           It would be a notable or worthy option ...to denote data or define
           schema while developing ERP solutions and other enterprise database 
           solutions at the schema level , so that at later stage's this would
           or can be utilized for DATAMING or BI or DWH purposes.

           Similarly it would be good option on the above lines to denot or
           classify or publish table's as part of dictionary or similar such
           catalogs ...where data within the entities (tables or objects) are
           basis for interpretation ...where in tools , utilities, schema or
           catalogues can extract and interpret such data ...kind a XML at 
           the relational level.


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 , rationalization to arrive at a workable and feasible
       solutions both commercially and techinically viable.


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