Show Home Subjects Expert solutions Create Log in Sign up Upgrade to remove ads Only ₩37,125/year
Terms in this set (87)Relational A ______ database management system allows users to create, read, update, and delete data in a relational database Data element Select the two terms representing the smallest or basic unit of
information Data models ___________ are logical data structures that detail the relationships among data elements using graphics or pictures Variety Different forms of structured and unstructured data Veracity The uncertainty of data, including biases, noise, and abnormalities Volume The scale of data Velocity The analysis of streaming data as it travels around the Internet Constraints Integrity _______ are rules that help ensure the quality of information Relational integrity constraints _____________ are rules that enforce basic and fundamental information-based constraints Speech analytics Process of analyzing recorded calls to gather information; brings structure to customer interactions and exposes information buried in customer contact center interactions with an enterprise Distributed _______ computing processes and manages algorithms across many machines in a computing environment Information cleansing Select two terms that describe the process for weeding out, fixing, or discarding inconsistent, incorrect, or incomplete
information Unstructured _______ data is not defined, does not follow a specified format, and is typically free form text such as emails Attributes Select the three terms that represent the data
elements associated with an entity Structured data ___________ has a defined length, type, and format and includes numbers, dates, or strings such as Customer Address Accurate Is there an incorrect value in the information?
Complete Is a value missing from the information? Consistent Is aggregate or summary information in agreement with detailed information? Timely Is the information current with respect to business needs? Unique Is each transaction and event represented only once in the information? Real-time information Immediate,up-to-date information Editor A content ______ is the person responsible for updating and maintaining website content Association detection ________________ reveals the relationship between variables along with the nature and frequency of the relationships Transactional information Encompasses all of the information contained within a single business process or unit of work, and its primary purpose is to support daily operational tasks. Airline ticket, packing slip, sales receipt pick 3 that belong in transaction information: sales projections, future growth and trends, product statistics pick 3 that belong in analytical information: Analytical information Encompasses all organizational information, and its primary purpose is to support the performing of managerial analysis tasks Big _____ data is a collection of large, complex data sets, including structured and unstructured data, which cannot be analyzed using traditional database methods and tools Structured A ______ query language asks users to write lines of code to answer questions against a database Database management system _________________ creates, reads, updates, and deletes data in a database while controlling access and security Quality Many firms complete data ______ audits to determine the accuracy and completeness of its data Information quality Four primary traits of the value of information Incorrect data Which of the following are problems associated with dirty data Query-by-example ______ helps users graphically design the answer to a question against a database Metadata _______ provides details about data Cube Informaton ______ is the common term for the representation of multidimensional information Data scientist ________ extracts knowledge from data by performing statistical analysis, data mining, and advanced analytics on big data to identify trends, market changes, and other relevant information Classification Assigns records to one of a predefined set of classes Estimation Determines values for an unknown continuous variable behavior or estimated future value Affinity grouping Determines which things go together Clustering Segments a heterogeneous population of records into a number of more homogeneous subgroups Relational database model A ______ stores information in the form of logically related two-dimensional tables Governance Data ________ refers to the overall management of the availability, usability, integrity, and security of company data Information integrity issues ___________ occurs when a system produces incorrect, inconsistent, or duplicate data Basket Market ______ analysis analyzes such items as websites and checkout scanner information to detect customers' buying behavior and predict future behavior by identifying affinities among customers choices of products and services visualization Data ________ tools move beyond Excel graphs and charts into sophisticated analysis techniques such as pie charts, controls, instruments, maps, time-series graphs and more. It describes technologies that allow users to "see" or visualize data to transform information into a business perspective Business rule _________ defines how a company performs certain aspects of its business and typically results in either a yes/no or true/false answer Analysis paralysis _________ occurs when the user goes into an emotional state of over-analysis(over-thinking) a situation so that a decision or action is never taken, in effect paralyzing the outcome Machine-generated data _____________ is created without human intervention Inconsistent data definitions Every department had its own method for recording data so when trying to share information, data did not match and users did not get the data they really needed Lack of Data standards Managers need to perform cross-functional analysis using data from all departments, which differed in granularities, formats, and levels Poor data quality The data, if available, were often incorrect or incomplete Inadequate data usefulness Users could not get the data they needed Ineffective direct data access Most data stored in operational databases did not allow users direct access Dashboards Business intelligence ________ 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 Dictionary Data _______ compiles all of the metadata about the data elements in the data model Physical view of information ______________ deals with the physical storage of information on a storage device
Time ______ - series information is timestamped information collected at a particular frequency Mining Data _____ is the process of analyzing data to extract information not offered by the raw data alone Mart Data _____ contains a subset of data warehouse information Text analytics _______ analyzes unstructured data to find trends and patterns in words and sentences Extraction, transformation, and loading ________ is a process that extracts information from internal and external databases, transform it using a common set of enterprise definitions, and loads it into a data warehouse Information granularity ________ refers to the extent of detail withing the information Artist Data ______ is a business analytics specialist who uses visual tools to help people understand complex data Data A _____ - driven website is an interactive website kept constantly updated and relevant to the needs of its customers using a database Information redundancy ________ is the duplication of data, or the storage of the same data in multiple places Business-critical integrity constraints ________ enforces business rules vital to an organization's success and often require more insight and knowledge than relational integrity constraints Logical The ______ view of information focuses on how individual users logically access information to meet their own particular business needs Database A ______ maintains information about various types of objects, events, people Human _____-generated data is data that humans, in interaction with computers, generate Information integrity _______ meaures the quality of information Infographics _____ presents the results of data analysis, displaying the patterns, relationships, and trends in a graphical format Foreign A _____ key is a primary key of one table that appears as an attribute in another table and acts to provide a logical relationship between the two tables Cluster ________ analysis is a technique used to divide information sets into mutually exclusive groups such that the members of each group are as close together as possible to one another and the different groups are as far apart as possible Data-mining tools ______ uses a variety of techniques to find patterns and relationships in large volumes of information that predict future behavior and guide decision making Creator Content _____ is the person responsible for creating the original website content Record A _____ is a collection of related data elements Web analytics __________ analyzes unstructured data associated with website to identify consumer behavior and website navigation Entity _______ stores information about a person, place, thing, or event Static information _________ includes fixed data incapable of change in the event of a user action Advanced ______ analytics focuses on forecasting future trends and producing insights using sophisticated quantitative methods, including statistics, descriptive and predictive data mining, simulation, and optimization Systems Real-time _____ provide real-time information in response to requests Warehouse A data _____ is a logical collection of information, gathered from many different operational databases, that supports business analysis activities and decision-making tasks Inconsistency Information _______ occurs when the same data element has different values Master _______ data management is the practice of gathering data and ensuring that it is uniform, accurate, consistent, and complete Social media analytics ___________ analyzes text flowing across the internet, including unstructured text from blogs and messages real-time systems provide real-time information in response to each request Sets with similar termsMIS 180 Chapter 649 terms katiefaye4 DSS Chapter 673 terms SpencerMeares Business Driven Information system Ch.643 terms MahdiTawfik Chapter 658 terms thebassgirl96 Other sets by this creatorChapter 7, 8, 976 terms ballstatestudy HANDOUT 1, HAND OUT 2, HAND OUT 3, HAND OUT 4, HAN…50 terms ballstatestudy mgt 491 test 138 terms ballstatestudy CIS Test 1 Quiz 2, CIS Test 1 Quiz 3, CIS TEST One…93 terms ballstatestudy Other Quizlet setsbig data 2 test 2 chapter 637 terms lshepherd Slides 1 Preprocessing12 terms JuliaMazePLUS AIS Presentations 337 terms Beau0908 Accounting info systems Exam 1 (CH 1, 2, 3, 5, 6)112 terms JRYenser Related questionsQUESTION Which description most accurately describes Fireworks? 4 answers QUESTION Google's chromebook effort is a promising initiative, but so far a few consumers have adopted portable computers using the chromebook standard 2 answers QUESTION What is cloud computing services changing? 15 answers QUESTION What is a telecommunications industry specification that describes how mobile phones, computers, and personal digital assistants can be easily interconnected using a short-range wireless connection? 2 answers Which of the following systems allows users to create read update and delete?A database management system (DBMS) is system software for creating and managing databases. A DBMS makes it possible for end users to create, protect, read, update and delete data in a database.
What is used to retrieve and edit data in a relational database?A popular data manipulation language is that of Structured Query Language (SQL), which is used to retrieve and manipulate data in a relational database.
Which database system stores data in relational table?The software used to store, manage, query, and retrieve data stored in a relational database is called a relational database management system (RDBMS).
What is relational database management system in detail?A relational database management system (RDBMS or just RDB) is a common type of database that stores data in tables, so it can be used in relation to other stored datasets. Most databases used by businesses these days are relational databases, as opposed to a flat file or hierarchical database.
|