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)

Thread Rating:
  • 0 Votes - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Advanced Querying and Information Retrieval
Post: #1

Advanced Querying and Information Retrieval

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

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.

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
  advanced less flammable transformer insulating fluid ppt Guest 1 0 Yesterday 11:13 AM
Last Post: dhanabhagya
  sound pollution information in marathi language pdf file Guest 3 5,654 12-01-2018 12:09 PM
Last Post: dhanabhagya
  marathi language information 11th commerce o c project Guest 0 0 03-01-2018 06:45 PM
Last Post: Guest
  information speed breaker in marathi Guest 1 0 28-11-2017 10:13 AM
Last Post: jaseela123
Heart collection of seals of different joint stock companies and the relevant information Guest 1 0 18-11-2017 11:32 AM
Last Post: jaseela123
  Development of College Information System Guest 1 325 17-11-2017 11:44 AM
Last Post: jaseela123
  vyasan mukti information in marathi Guest 1 1,261 17-11-2017 11:26 AM
Last Post: jaseela123
  ppt presentation for seminar wireless accident information system using gsm and gps Guest 1 213 14-10-2017 12:43 PM
Last Post: jaseela123
  advanced hydrogen fueled internal combustion engines ppt Guest 1 212 12-10-2017 11:26 AM
Last Post: jaseela123
  advanced composite materials ppt Guest 1 168 11-10-2017 01:28 PM
Last Post: jaseela123
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