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: 20)

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 ic engines by senthil pdf free download Guest 1 0 28-04-2017 03:15 PM
Last Post: jaseela123
  puri sharma kalia advanced inorganic chemistry pdf Guest 1 331 28-04-2017 02:33 PM
Last Post: jaseela123
  sagari pradushan information in marathi Guest 1 273 27-04-2017 02:19 PM
Last Post: jaseela123
Thumbs Up soil pollution information in marathi wikipedia Guest 1 372 27-04-2017 09:57 AM
Last Post: jaseela123
  polly house information in marathi Guest 1 328 26-04-2017 04:27 PM
Last Post: jaseela123
  content based video retrieval system matlab code Guest 2 887 25-04-2017 02:41 PM
Last Post: jaseela123
Wink advanced ic engine book in dr senthil author download Guest 1 0 25-04-2017 02:13 PM
Last Post: jaseela123
  ppt on performance and emission characteristics jatropha and pongamia biodiesel Guest 0 0 23-04-2017 02:00 PM
Last Post: Guest
  information about automatic machines for 11th oc project Guest 1 215 21-04-2017 03:34 PM
Last Post: jaseela123
  information on automatic machines Guest 1 287 21-04-2017 02:53 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