Database: Database and Information Essay

Submitted By JaniceShao
Words: 2716
Pages: 11
Open Document
Chapter 7 Databases and Data Warehouses
7.1 Databases * <<Introduction>> * The ability to understand, digest, analyze, and filter data and information is key to success for any professional in any industry. * Data are raw facts that describe the characteristics of an event. * E.g., characteristics for a sales event can include a date, item number, item description, quantity ordered, customer name, or shipping details. * Information is data converted into a meaningful and useful context. * E.g., information from sales events could include the best-selling item, the worst-selling item, the best customer, or the worst customer.

* <<Organizational Data and Information>> * E.g., Ford’s European plant. * Data and information are everywhere in an organization. When addressing a significant business issue, employees must be able to obtain and analyze all the relevant data and information available, so they can make the best decisions possible. * Organizational data and information come at different levels, formats, and “granularities.” * Granularity refers to the extent of detail within the information (fine and detailed or coarse and abstract). * Coarse granularity, or highly summarized data or information. * Fine granularity, or data or information that contains a great amount of detail. * Employees must be able to correlate the different levels, formats, and granularities of data and information when making decision. * Successfully collecting, compiling, sorting, and finally analyzing data and information from multiple levels, in varied formats, exhibiting different granularities can provide tremendous insight into how an organization is performing. * E.g., Samsung Electronics win back lost sales. * E.g., Orvis was not successful at managing data and information. * <<The Value of Transactional Data and Analytical Information>> * Transactional data compasses all of the data contained within a single business process or unit of work, and its primary purpose is to support performing daily operational task. * E.g., organizations capture and store transactional data in databases, and they use it when performing operational tasks and repetitive decisions, such as analyzing daily sales figures and production schedules to determine how much inventory to carry. * Analytical information compasses all organizational information, and its primary purpose is to support the performance of higher-level analysis tasks. * E.g., it is used when marking important ad hoc decisions such as whether the organization should build a new manufacturing plant or hire additional sales personnel. * <<The Value of Timely Data and Information>> * The need for timely data and information can change for each business decision. Timeliness is an aspect of data and information that depends on the situation. * E.g., 911 centres, stock traders, and banks, require consolidated, up-to-the-second data and information, 24 hours a day, seven days a week. * E.g., insurance and construction companies, require only daily or even weekly data and information. * Real-time is immediate. * Real-time data are immediate, up-to-date data. * Real-time information is immediate, up-to-date information. * A real-time system provides real-time transactional data and/or real-time analytical information in response to query requests. * Many organizations use real-time systems to exploit key corporate transactional data. * E.g., a survey of 1,500 chief information officers led by Gartner Group. * The growing demand for real-time data and information stems from organizations’ need to make faster and more effective decision, keep smaller inventories, operate more efficiently, and track performance more carefully. But timeliness is relative. Organizations need fresh, timely data and
Show More

Related Documents: Database: Database and Information Essay

Essay about INFORMATION SYSTEM AND DATABASE

Information Systems and Databases Information systems are computer systems that support end users, giving them access to the information. For a large number of information systems, the data is held in databases and access is via database management systems. Information systems perform a variety of tasks and these are considered in the following topics in the HSC course. While all of the information processes are represented in information systems, the emphasis in this topic is on the processes…

Words 567 - Pages 3

Difference Between Database Management And Information Retrieval System

QUESTION 1 Differentiate between Database Management System and Information Retrieval System by focusing on their functionalities DEFINITION DATABASE MANAGEMENT SYSTEM (DBMS)  Database management system program that enables users to store, modify and extract information from databases.  Software that uses a standard method of cataloguing, retrieving, and running queries on data. It also manages incoming data, organizes it, and provides ways for data to be modified, extracted by other user and…

Words 1250 - Pages 5

Database and Spreadsheet Essay

College of Technology London | DATABASE AND SPREADSHEET | Module Code: SBIT5003, Assignment 1 | Date: 15th April, 2011 – Word Count : 1496Term 3 | SAMIR BHOIR | STUDENT ID: 105065-83 UWL ID: 29002700/1 E-Mail: 105065-83@stu.ctlondon.ac.uk Submitted to: Dr. Jin Wu | Table of Content 1.0 Introduction: 3 2.0 Database Elements 3 2.1 Queries 3 2.2 Reports 4 2.3 Attributes 4 3.0 Standard Approaches of DB Design: 4 3.1 Entity – Relationship Diagram: 4 1) Entity 4…

Words 1717 - Pages 7

Database: Database and Database Management Systems Essay

A database is a table consisting ofcolumns (fields) and rows (records) where each column contains a specific attribute and each row features a certain value for the corresponding attribute. The number of columns within a single table depends on how many different types/categories of information we need to store within a database, while the number of rows is defined by the quantity of the objects that have to be introduced categorized records for. This kind of simple organization of the data in database…

Words 1052 - Pages 5

Week3VocabFillable 2 Essays

some database. Database A database is searchable. It can be both electronic and non-electronic, and database is organized by information. Many periodical databases are in full text; however, not all databases are in full text. There are only either citation or abstract. The databases is the index whether the information is available or not. A library catalog is a type of database that indicates the content of the library. Fields Specific database or catalog of a specific item or information. For…

Words 588 - Pages 3

Essay on Database Management

Database Design Paper ************ DBM/380 A database system is a program designed specifically for the purpose of allowing a large number of users to either be able to manage and organize large amounts of structured persistent data from a designer’s standpoint, or allow an end user to search through different types of data in the database, such as field’s records and files. A database system offers a unique way of changing or adding data to information systems without disrupting the current…

Words 406 - Pages 2

Database and Item Essay

Database Analysis Paper Torrey Collins CIS/207 1/24/12 Shawn Pullum What is a database? A database is designed to offer an organized mechanism for storing, managing and retrieving information…

Words 699 - Pages 3

Data Management and Decision Making Essay

Intelligence: Databases and Information Management Wienand Omta Fabiano Dalpiaz 1 drs. ing. Wienand Omta Learning Objectives      2 Describe how the problems of managing data resources in a traditional file environment are solved by a database management system. Describe the capabilities and value of a database management system. Apply important database design principles. Evaluate tools and technologies for accessing information from databases to improve business…

Words 2085 - Pages 9

Database Design Essay

Database Design Dustin Brown DBM380 March 23rd, 2015 Debra Martin Database Design Databases are a key elements of today’s business world. Almost every company in the world makes use of databases to help store, process, and utilize information to achieve various tasks and goals. To get the most out of databases companies employ database management systems. In this paper we will be taking a look at what database systems are, as well as the architecture that defines them. Before we begin it is important…

Words 773 - Pages 4

Essay about Huffman Trucking Service Request HT

service request for a database that will help the company improve efficiency and maintain records while also helping by increasing productivity. The service request includes several steps that need to be taken in order to complete this task. “The database development process consists of three major stages: requirements, design, and implementation” (Kroenke & Auer, 2012). One by one the request will be described in detail in what process are being taken to design the database that Huffman Trucking…

Words 1284 - Pages 6