Important: Use custom search function to get better results from our thousands of pages

Use " " for compulsory search eg:"electronics seminar" , use -" " for filter something eg: "electronics seminar" -"/tag/" (used for exclude results from tag pages)

Ask More Info Of  A Seminar Ask More Info Of A Project Post Reply  Follow us on Twitter
12-06-2012, 06:01 PM
Post: #1
Advanced Querying and Information Retrieval

Advanced Querying and Information Retrieval

.ppt  AdvanceQuerying.ppt (Size: 1.06 MB / Downloads: 16)

Decision Support Systems

Decision-support systems are used to make business decisions often based on data collected by on-line transaction-processing systems.
Examples of business decisions:
what items to stock?
What insurance premium to change?
Who to send advertisements to?
Examples of data used for making decisions
Retail sales transaction details
Customer profiles (income, age, sex, etc.)

Decision-Support Systems: Overview

Data analysis tasks are simplified by specialized tools and SQL extensions
Example tasks
For each product category and each region, what were the total sales in the last quarter and how do they compare with the same quarter last year
As above, for each product category and each customer category
Statistical analysis packages (e.g., : S++) can be interfaced with databases
Statistical analysis is a large field will not study it here
Data mining seeks to discover knowledge automatically in the form of statistical rules and patterns from Large databases.
A data warehouse archives information gathered from multiple sources, and stores it under a unified schema, at a single site.
Important for large businesses which generate data from multiple divisions, possibly at multiple sites
Data may also be purchased externally

Data Analysis and OLAP

Aggregate functions summarize large volumes of data
Online Analytical Processing (OLAP)
Interactive analysis of data, allowing data to be summarized and viewed in different ways in an online fashion (with negligible delay)
Data that can be modeled as dimension attributes and measure attributes are called multidimensional data.
Given a relation used for data analysis, we can identify some of its attributes as measure attributes, since they measure some value, and can be aggregated upon. For instance, the attribute number of the sales relation is a measure attribute, since it measures the number of units sold.
Some of the other attributes of the relation are identified as dimension attributes, since they define the dimensions on which measure attributes, and summaries of measure attributes, are viewed.

Online Analytical Processing

The operation of changing the dimensions used in a cross-tab is called pivoting
Suppose an analyst wishes to see a cross-tab on item-name and color for a fixed value of size, for example, large, instead of the sum across all sizes.
Such an operation is referred to as slicing.
The operation is sometimes called dicing, particularly when values for multiple dimensions are fixed.
The operation of moving from finer-granularity data to a coarser granularity is called a rollup.
The opposite operation - that of moving from coarser-granularity data to finer-granularity data – is called a drill down.
Rating Advanced Querying and Information Retrieval Options
Share Advanced Querying and Information Retrieval To Your Friends :- Seminar Topics Bookmark
Post Reply 

Marked Categories : advanced sql querying seminars, advance querying and information, advanced querying and information retrieval decision support systems, advanced querying and information retrieval decision support system, information retrieval ppt, advanced seminar topics in information retrieval, ppt for advanced querying and information retrieval, ppt for aanced queryig information retrieval, ppt for advanced querying information retrieval, advanced querying information retrieval ppt, seminor for information retrieval systems belong to cse, advance sql seminar topics, information retrieval, information retrieval latest seminar topics,

Quick Reply
Type your reply to this message here.

Image Verification
Image Verification
(case insensitive)
Please enter the text within the image on the left in to the text box below. This process is used to prevent automated posts.

Possibly Related Threads...
Thread: Author Replies: Views: Last Post
  STUDENTS' INFORMATION SYSTEM dhanabhagya 0 272 10-02-2016 04:45 PM
Last Post: dhanabhagya
  Student Information System dhanabhagya 0 181 15-01-2016 04:06 PM
Last Post: dhanabhagya
  A Lightweight High-Performance Fault Detection Scheme for the Advanced Encryption study tips 1 911 07-11-2015 08:19 PM
Last Post: Guest
  Quantum Information Technology presentation Abstract 0 319 22-05-2015 04:00 PM
Last Post: presentation Abstract
  Embedded Systems and Information Appliances presentation Abstract 0 156 11-05-2015 03:41 PM
Last Post: presentation Abstract
  Information Protection in Academic Campuses: A Scalable Framework presentation Abstract 0 195 09-05-2015 03:54 PM
Last Post: presentation Abstract
  ADVANCED WEEE MANAGEMENT SYSTEM mkaasees 0 462 25-09-2014 02:59 PM
Last Post: mkaasees
  Visa Processing Information System Seminar Report seminar code 0 451 25-09-2014 02:31 PM
Last Post: seminar code
  Student Information System seminar report project maker 0 425 25-09-2014 11:16 AM
Last Post: project maker
Last Post: seminar code
This Page May Contain What is Advanced Querying and Information Retrieval And Latest Information/News About Advanced Querying and Information Retrieval,If Not ...Use Search to get more info about Advanced Querying and Information Retrieval Or Ask Here