Monday, June 29, 2009

Why would I want to access the data warehouse when I have a mainframe computing system?

Your computing system is set up to handle subject specific day to day business and transaction processing, such as payroll or course registration. The reports created in this type of system are specific to the subject matter. The benefits to putting your data into the data warehouse include:
 Merging subject specific data together to create information
 Standardizing data across the University
 Improving turnaround time for reporting
 Lowering costs because you can produce your own reports instead of costly, centrally printed and distributed mainframe reports
 Sharing data or allowing others to easily access your data will free staff from the tasks of extracting data and reporting for other departments or colleges

Sunday, June 28, 2009

Definitions of OLAP on the Web:

  • On-line retrieval and analysis of data to reveal business trends and statistics not directly visible in the data directly retrieved from a data warehouse. Also known as multidimensional analysis.
  • Online Analytical Processing or OLAP provides multidimensional, summarized views of business data and is used for reporting, analysis, modeling and planning for optimizing the business. SQL Server supports OLAP via Analysis Services. Analysis Services can be used to work with data warehouses or data marts designed for sophisticated enterprise intelligence systems. These systems process queries required to discover trends and analyze critical factors. ...
  • Online Analytical Processing
  • On-line analytical processing. OLAP is defined as providing fast access to shared multi-dimensional data. OLAP is a term used to generically refer to software and applications that provide users with the ability to store and access data in multi-dimensional cubes. (See also Multi-Dimensional Analysis and Cubes.)
  • On-Line Analytical Processing. A category of applications and technologies for collecting, managing, processing and presenting multidimensional data for analysis and management purposes.
  • On-line Analytical Processing. Information analysis that pass the FASMI test: Fast Analysis of Multidimensional Information.
  • On-Line Analytical Processing. OLAP should be designed to provide end users a quick way of slicing and dicing the data.
  • OLAP (online analytical processing) enables a user to easily and selectively extract and view data from different points-of-view.
  • “Drilling down” on various data dimensions to gain a more detailed view of the data. For instance, a user might begin by looking at North American sales and then drill down on regional sales, then sales by state, and then sales by major metro area. Enables a user to view different perspectives of the same data to facilitate decision-making.
  • On-Line Analytical Processing, originally introduced in 1994 in a paper by EF Codd, is a decision support counterpart to On-Line Transaction Processing. OLAP allows users to derive information and business intelligence from Data Warehouse systems by providing tools for querying and analyzing the information in the Warehouse. IN particular, OLAP allows multidimensional views and analysis of the data for decision support processes.
  • (online analytical processing) A technology that uses multidimensional structures to provide rapid access to data for analysis. OLAP data sets for Project Server are stored in SQL Server tables and managed with Project Web Access and SQL Server Analysis Services. See also: cube
  • A multidimensional, multi-user, client/server computing environment for users who need to analyze consolidated enterprise data in real time. OLAP systems feature zooming, data pivoting, complex calculations, trend analyses, and data modeling.
  • Software that assists in fast analysis of data stored in databases or data warehouses across multiple dimensions.
  • OLAP is an acronym for online analytical processing. It is an approach to quickly provide the answer to complex database queries. It is used in business reporting for sales, marketing, management reporting, data mining and similar areas. Some people have suggested that an alternative and perhaps more descriptive term to describe the concept of OLAP is Fast Analysis of Shared Multidimensional Information, or FASMI.

Saturday, June 27, 2009

Definitions of decision tree on the Web:

  • Definitions of decision tree on the Web:

    Is a listing of all the possible outcomes of an expression. Typically decision trees are for boolean expressions.
  • A graphical representation of all possible outcomes and the paths by which they may be reached; often used in classification tasks. The top layer consists of input nodes (eg, meteorological observations and data). Decision nodes determine the order of progression through the graph. The leaves of the tree are all possible outcomes or classifications, while the root is the final outcome (for example, a weather prediction or climate classification). ...
  • A decision analysis tool that represents multiple collections of rules in the form of branches on a tree, that lead to a larger value or class.
  • form of flow diagram in which readers are routed according to their response to questions, usually consisting of graphic rectangles and diamonds connected with lines and arrows.
  • A predictive model based on a branching series of tests. Each test examines the value of a single column in the data and uses it to determine the next test to apply. The results of all tests determine which label to predict.
  • A diagram consisting of nodes and branches that depicts the information for a decision problem. (page 790)
  • In decision theory (for example risk management), a decision tree is a graph of decisions and their possible consequences, (including resource costs and risks) used to create a plan to reach a goal. Decision trees are constructed in order to help with making decisions.

Friday, June 26, 2009

Definitions of metadata on the Web:

  • Data that is used to describe other data. Data definitions are sometimes referred to as metadata. Examples of metadata include schema, table, index, view and column definitions.
  • Metadata is information about a particular data set which may describe, for example, how, when, and by whom it was received, created, accessed, and/or modified and how it is formatted. Some metadata, such as file dates and sizes, can easily be seen by users; other metadata can be hidden or embedded and unavailable to computer users who are not technically adept. Metadata is generally not reproduced in full form when a document is printed. ...
  • Informational data about the data, included in a signal's data stream.
  • data about data. Metadata describes how and when and by whom a particular set of data was collected, and how the data is formatted. Metadata is essential for understanding information stored in data warehouses and has become increasingly important in XML-based Web applications.
  • Data about data, or information known about the image in order to provide access to the image. Usually includes information about the intellectual content of the image, digital representation data, and security or rights management information.
  • "data about data" describe the content, quality, condition, and other characteristics of data. Metadata is vital in helping potential users to find needed data and determine whether a data set will meet their needs before they spend the time and money to obtain and process it. This information will often include some of the following:
  • Data about data. Index-type information pertaining to the entire data set rather than the objects within the data set. Metadata usually includes the date, source, map projection, scale, resolution, accuracy, and reliability of the information, as well as data about the format and structure of the data set.
  • Data about data. Includes information describing aspects of actual data items, such as name, format, content, and the control of or over data.
  • structured data about data, which may include information about the author, title and subject of web resources. Metadata is added in the section of the webpage or is stored in a database. It is available for searching but is not displayed on the page.
  • Data about other data, commonly divided into descriptive metadata such as bibliographic information, structural metadata about formats and structures, and administrative metadata, which is used to manage information.
  • Summary information regarding other information being presented. Metadata can describe any type of information resource and service, users can gain access to information about resources that are not available on-line for full text searching including: electronic documents, databases, collections of printed books, microforms, government information services, etc. Terms used for the subject field in the Newsroom must be referenced from the Government of Canada Core Subject Thesaurus.
  • (1) Information about a data set which is provided by the data supplier or the generating algorithm and which provides a description of the content, format, and utility of the data set. Metadata provide criteria which may be used to select data for a particular scientific investigation. (2) Information describing a data set, including data user guide, descriptions of the data set in directories, and inventories, and any additional information required to define the relationships among these. ...
  • Data which describes other data. For example, a description of a database in terms of its structure and the relationship between the entities in it. (www.oxford Open Access Digital works that are made available often at no cost to the reader on the public Internet for purposes of education and research. (US Association of Research Libraries:
  • information describing the characteristics of data. Data or information about data. Descriptive information about an organization’s data, data activities, systems, and holdings.
  • Data (information) about data. Term which describes the data.
  • means any additional or bibliographic information about one or more of the data collections, as notified to the End User from time to time. Metadata may be supplied by electronic means.
  • the reference information about how the data is collected
  • Data about data. Metadata in HGL refers to documentation that describes the data layers themselves. All metadata in HGL adheres to the Federal Geographic Data Committee Content Standard for Geospatial Metadata.
  • Metadata is a description or definition of electronic data, or data about data. Often, metadata can only be accessed in certain viewing modes. Metadata can include descriptive HTML tags (see Meta Tag) and information about when a document was created, and what changes have been made on that document.
  • Information about data set. Metadata for geographical data may include the source of the data; its creation date and format; its projection, scale, resolution, and accuracy; and its reliability with regards to some standard. See data dictionary.
  • Data that describe a dataset to allow others to find and evaluate it.
  • Data about data. How the structures and calculation rules are stored, plus, possibly, additional information on data sources, definitions, quality, transformations, date of last update, user access privileges, etc.
  • A set of information that fully describes each data file in the archive. Metadata stored in the KOA database includes: FITS header keyword values (both those written by the telescope, and those added by the archive processing software); file location information; spatial coordinates and spatial bin assignments; proprietary period information; and certain transformations of original FITS keyword values (for instance, RA and DEC are stored as decimal values; the original FITS sexagesimal ...
  • Metadata is the structured description of an object or collection of objects and is similar to what is found in a standard cataloging record. There are three kinds of metadata:
  • A description of data.
  • data about data; "a library catalog is metadata because it describes publications"
  • Metadata (Greek: meta-+data "information") means data about data. While this definition is commonly offered, it is also commonly not helpful. An example is a library catalog card, which contains data about the nature and location of a book: It is data about the data in the book referred to by the card.
  • Metadata is the name of a US corporation and a registered trademark in the United States.