Show 1.Completeness, consistency, accuracy, timeliness, uniqueness INCORRECT No answer given THE ANSWER Common characteristics of high-quality information 2.Rules that enforce basic and fundamental information-based constraints. e.g. not allowing someone to order zero pounds of raw materials from a supplier INCORRECT No answer given THE ANSWER Relational integrity constraints 3.Reveals the relationship between variables along with the nature and frequency of the relationships. INCORRECT No answer given THE ANSWER Associated detection 4.Analyzes unstructured data associated with websites to identify consumer behavior and website navigation. INCORRECT No answer given THE ANSWER Web mining 5.Analyzes unstructured data to find trends and patterns in words and sentences. INCORRECT No answer given THE ANSWER Text mining Extent of detail within information Common types of information 1. Level 2. Format 3. Granularity Different Information levels 1. Individual 2. Department 3. Enterprise Different information formats 1. Documents 2. Presentation 3. Spreadsheet 4. Database Different Information Granularities 1. Detail 2. Summary 3. Aggregate Traits of Value Information Type Timeliness Quality Governance All information contained within single business process or unit of work and primary purpose is to support daily operational tasks (Sales receipt, Airline ticket, Packing slip)
All organizational information and primary purpose is to support performing of managerial analysis task (Product statistics, Sales projections, Future growth, trends) Immediate up to date info Real time information in response to requests Information inconsistency same data element has different values Information Integrity issues when system produces incorrect, inconsistent or duplicate data 5 common characteristics of high quality info accuracy, completeness, consistency, uniqueness, timeliness Overall management of the availability, usability, integrity, and security of company data maintains info about various types of objects, people, places, events Database management system DBMS creates, reads, updates & deletes data in a database while controlling access and security. Helps users graphically design answer to question against database Structured Query Langauge asks users to write lines of code to answer questions against database the smallest or basic unit of information. It can include a customer’sname, address, email, discount rate, preferred shipping methods, product name,quantity ordered, and so on logical data structures that detail the relationships among dataelements using graphics or pictures Provides details about data compiles all of metadata about the data elements in data model Relational database model stores info in form of logically related two dimensional tables Relational management System allows users to create, read, update, and delete data stores information about person, place, thing, transaction or event data elements associated with entity collection of related data elements field that uniquely identifies given record Primary key of one table that appears as an attribute in another table and acts to provide a logical relationship between two tables Relational database for business advantages Increased Flexibility Increased scalability and performance Reduced information redundancy Increased Information integrity Increased Information security deals with physical storage of info on storage device focuses on how individual users logically access information to meet their own particular business needs duplication of data or storage of same data in multiple places measure of quality of info rules help ensure quality of info 1. relational 2. business critical Relational integrity constraints rules that enforce basic and fundamental information-based constraints. (not allow someone to create an order for a nonexistant customer) how company performs certain aspects of its business and typically results in either yes/ no or true/false Business-Critical Integrity and constraints enforce business rules vital to an organizations success and often require more insight and knowledge a person responsible for creating the original website content person responsible for updating and maintaining website content fixed data incapable of change in event of user action - includes data that change based on user actions area of a website that stores info about products in a database interactive website that constantly updates and stays relevant to the needs of customers using a database website owners can make changes without relying on MIS professionals; users can update data-driven website with little or no training Easy to Store Large Amounts of Data Data-driven websites can keep large volumes of information organized, templates, reliability and scalability. easy to eliminate human errors data driven websites trap data-entry errors, eliminating inconsistencies while ensuring all information is entered correctly logical collection of information gathered from many different operational databases that supports business analysis activities and decision making tasks Extraction, transformation, and loading (ETL) A process that extracts information from internal and external databases, transforms it using a common set of enterprise definitions, and loads it into a data warehouse. Then sends it to data mart contains subset of data warehouse information Representation of multidimensional information Information Cleansing or Scrubbing process that weeds out and
fixes or discards inconsistent, incorrect, or incomplete information determines the accuracy and completeness of data process of analyzing data to extract info not offered by raw data alone variety of techniques to find patterns and relationships in large volumes of information that predict future - already in a database or a spreadsheet do not exist in fixed location and can include text documents, PDF, voice messages, emails and so on Text Mining (Data Mining) Analyzes unstructured data to find trends/patterns in words/sentences analyzes unstructured data associated with websites to identify consumer behavior and website navigation technique used to divide info sets into mutually exclusive groups such that the members of each group are as close together as possible to one another and different groups are far apart as possible Reveals the relationship between variables with the nature and frequency of the relationships. Items such as websites and checkout scanner information detect customers buying behavior and predict future behavior by identifying affinities among customer choices of products and services Performs such functions as information correlations, distributions, calculations, and variance analysis Time-staped information collected at a particular frequency predictions based on time series information accessing large amounts of data from different management information displays info graphically so it can be easily understood describes technologies that allow users to see or visualize data to transform information into business perspective Move beyond excel graphs and charts into sophisticated analysis techniques such as pie charts, controls, instruments, maps, time series graphs and more Business intelligence dashboards Track corporate metrics such as critical success factors and key performance indicators and include advanced capabilities such as interactive controls allowing users to manipulate data for analysis What is a logical data structure that details the relationship among data elements?A logical data model establishes the structure of data elements and the relationships among them. It is independent of the physical database that details how the data will be implemented. The logical data model serves as a blueprint for used data.
What is the logical structure of data?Logical data structures are data models, and are sometimes called entity-relationship (ER) models or even entity-attribute-relationship models. Databases mirror aspects of the real world. In effect databases are computerised models - simple-structure models - of more complex processes.
What is a collection of related data elements?A database is an organized collection of interrelated data that serves a number of applications in an enterprise.
What are entities that exist to represent the relationship between two other entities?Entities that exist to represent the relationship between two or more other entities are known as composite entities.
|