What are decision support systems, PL-SQL Programming

(a) What are decision support systems, and what role do they play in the business environment?

(b) Data warehousing is defined as "a subject-oriented, integrated, non-volatile collection of data" in support of management?s decision making process.

(i) Define the term subject-oriented and support your answer with appropriate examples.

(ii) Describe the three important differences that exist between an application oriented system and a subject oriented system.

(c) Data mining is a knowledge discovery process of automated extraction of hidden predictive information from large databases.

(i) Data mining being relatively a new technology, what advantages would an Insurance company achieved for implementing such a
technique? Provide relevant examples

(ii) To better exploit data mining what are the pre-requisites for a data warehouse?

(iii) Discuss the two critical factors which can affect success with the application of data mining technology.

Posted Date: 10/24/2013 5:43:27 AM | Location : United States

Related Discussions:- What are decision support systems, Assignment Help, Ask Question on What are decision support systems, Get Answer, Expert's Help, What are decision support systems Discussions

Write discussion on What are decision support systems
Your posts are moderated
Related Questions
Using NOT NULL Besides assigning an initial value, the declarations can impose the NOT NULL constraint, as the example below shows: acct_id INTEGER(4) NOT NULL := 9999; You ca

BIOCHE M ICA L ORIGIN OF LIFE - It is generally agreed by astronomers, geologists and biologists that the earth is approximately 4500-5000 million years old. It is an

Using EXCEPTION_INIT To handle unnamed internal exceptions, you should use the OTHERS handler or the pragma EXCEPTION_INIT. The pragma is a compiler directive that can be th

Declaring Subprograms   You can declare subprograms in any PL/SQL subprogram, block, or package. But, you should declare subprograms at the end of the declarative part after a

Creating a SQL file 1. Open a new file in Notepad++ and save it to the location c:\mysql\bin, with the name lab8script.sql (the file extension should be .sql ). Add a MySQL co

Nested Tables versus Index-by Tables The Index-by tables and nested tables are just similar. For e.g.  They have similar structure and their individual elements are accessed in

Interesting properties of CROSS JOIN - SQL Compare these with the "interesting properties of JOIN", CROSS JOIN is associative but not commutative. Unlike JOIN and NATURAL JOI

Restriction in SQL Syntax: SELECT DISTINCT StudentId FROM IS_CALLED WHERE Name = 'Boris' The WHERE clause operates on the result of the FROM clause in analogo

FETCH Statement The FETCH statement retrieve rows of data one at a time from the result set of the multi-row query. The data is stored in fields or variables which correspond t

Explicit Cursors The set of rows returned by the query can include zero, one, or multiple rows, depending on how many rows meet your search criteria. Whenever a query returns