Business Driven Information Systems 2e

1929 days ago, 679 views
PowerPoint PPT Presentation
Business Driven Data Frameworks 2e. Section 6 DATABASES AND Information Distribution centers. Area 6.1. DATABASE Basics. Hierarchical Data. Data is all over the place in an association Information are crude actualities that depict the attributes of an occasion

Presentation Transcript

Slide 1

Business Driven Information Systems 2e CHAPTER 6 DATABASES AND DATA WAREHOUSES

Slide 2


Slide 3

Organizational Information is wherever in an association Data are crude truths that depict the attributes of an occasion Sales occasion – date, thing number, thing portrayal, amount requested, client name, shipping points of interest Information is information changed over into a significant and helpful setting Sales occasion – best/most noticeably bad offering thing, best/most noticeably awful client Employees must have the capacity to get and break down the a wide range of levels, arrangements, and granularities of authoritative data to settle on choices Successfully gathering, aggregating, sorting, and dissecting data can give gigantic understanding into how an association is performing

Slide 4

Organizational Information GREAT BUSINESS DECISIONS – Julius Reuter Uses Carrier Pigeons to Transfer Information In 1850, the possibility that sending and getting data could include business esteem was conceived. Julius Reuter started a business that crossed over any barrier amongst Belgium and Germany. Reuter constructed one of the principal data administration organizations based on the commence that clients would be set up to pay for data that was opportune and exact. Reuter utilized bearer pigeons to forward securities exchange and item costs from Brussels to Germany.

Slide 5

Organizational Information Customers immediately understood that with the early receipt of indispensable data they could make fortunes. The individuals who had cash in question in the stock exchange were set up to pay abundantly for early data from a trustworthy source, regardless of the possibility that it was a pigeon. Inevitably, Reuter's business developed from 45 pigeons to more than 200 pigeons. In the end the broadcast crossed over any barrier between Brussels to Germany, and Reuter's splendidly imagined impermanent syndication was shut.

Slide 6

Organizational Information Levels, arrangements, and granularities

Slide 7

The Value of Transactional and Analytical Information

Slide 8

The Value of Transactional and Analytical Information

Slide 9

The Value of Timely Information Transactional data – envelops the greater part of the data contained inside a solitary business process or unit of work, and its main role is to bolster the performing of day by day operational undertakings Analytical data – incorporates all hierarchical data, and its basic role is to bolster the performing of administrative examination assignments

Slide 10

The Value of Timely Information Organizations catch and store value-based data in databases and utilize it when performing operational errands and dreary choices, for example, breaking down every day deals reports and creation plans Transactional data illustrations incorporate pulling back money from an ATM, making an aircraft reservation, buying stocks

Slide 11

The Value of Timely Information Analytical data incorporates value-based data Includes outside authoritative data, for example, market, industry, and monetary conditions Used to settle on specially appointed choices Includes patterns, deals, item measurements, and future development projections Could likewise incorporate cost/advantage investigation, deals gauge, advertise patterns, industry patterns, and controls

Slide 12

The Value of Timely Information Timeliness is a part of data that relies on upon the circumstance Real-time data – prompt, state-of-the-art data Real-time framework – gives constant data in light of inquiry solicitations

Slide 13

The Value of Quality Information Business choices are just tantamount to the nature of the data used to settle on the choices You never need to wind up utilizing innovation to help you settle on an awful choice speedier

Slide 14

The Value of Quality Information Business choices are just on a par with the nature of the data used to settle on the choices Characteristics of superb data include: Accuracy Are every one of the qualities revise? Is the name spelled effectively? Is the dollar sum recorded legitimately? Fulfillment Are any of the qualities missing? Is the address finish including road, city, state, and postal district? Consistency Is total or rundown data in concurrence with definite data? Do every aggregate field rise to the genuine aggregate of the individual fields? Uniqueness Is every exchange, element, and occasion spoken to just once in the data? Are there any copy clients? Auspiciousness Is the data current regarding the business necessities? Is data refreshed week by week, day by day, or hourly?

Slide 15

The Value of Quality Information Low quality data case

Slide 16

The Value of Quality Information Issue 1: Without a first name it is difficult to correspond this client with clients in different databases (Sales, Marketing, Billing, Customer Service) to pick up a contend client see (CRM) Issue 2: Without a total road address there is no conceivable approach to speak with this client by means of mail or conveyances. A request may sit in a distribution center sitting tight for the entire address before delivery. The organization has invested energy and cash preparing a request that may never be finished Issue 3: If this is a similar client, the organization will squander cash conveying two arrangements of advancements and notices to similar clients. It may likewise send two indistinguishable requests and need to bring about the cost of one request being returned Issue 4: This is a decent case of where cleaning information is troublesome in light of the fact that this could possibly be a mistake. There are ordinarily when a telephone and a fax have a similar number. Since the telephone number is additionally in the email address field, odds are that the number is incorrect Issue 5: The business would have no chance to get of speaking with this client by means of email Issue 6: The organization could decide the region code in view of the client's address. This requires some serious energy, which costs the organization cash. This is a justifiable reason motivation to guarantee that data is entered accurately the first run through. All off base data should be settled, which costs time and cash

Slide 17

Understanding the Costs of Poor Information The four essential wellsprings of low quality data include: Customers deliberately enter incorrect data to shield their protection Information from various frameworks have diverse passage gauges and organizations Call focus administrators enter shortened or mistaken data coincidentally or to spare time Third gathering and outer data contains irregularities, errors, and blunders

Slide 18

Understanding the Costs of Poor Information Potential business impacts coming about because of low quality data include: Inability to precisely track clients Difficulty distinguishing profitable clients Inability to recognize offering openings Marketing to nonexistent clients Difficulty following income because of erroneous solicitations Inability to fabricate solid client connections

Slide 19

Understanding the Costs of Poor Information Poor data could bring about the SCM framework to arrange excessively stock from a provider in light of off base requests Poor data could bring about a CRM framework to send a costly limited time thing, (for example, a natural product wicker bin) to the wrong address of one of its best clients What happens when you have the powerlessness to assemble solid client connections? Diminished dealer control

Slide 20

Understanding the Benefits of Good Information High quality data can essentially enhance the odds of settling on a decent choice Good choices can specifically affect an association's primary concern

Slide 21

Relational Database Fundamentals Information is wherever in an association Information is put away in databases Database – keeps up data about different sorts of articles (stock), occasions (exchanges), individuals (workers), and spots (stockrooms)

Slide 22

Relational Database Fundamentals Database models include: Hierarchical database show – data is composed into a tree-like structure (utilizing guardian/youngster connections) in a manner that it can't have an excessive number of connections Network database display – an adaptable method for speaking to objects and their connections Relational database demonstrate – stores data as legitimately related two-dimensional tables

Slide 23

DATABASE ADVANTAGES Database points of interest from a business viewpoint incorporate Increased adaptability Increased versatility and execution Reduced data repetition Increased data uprightness (quality) Increased data security Spreadsheet impediments Limited number of lines and sections (Excel - 65,536 lines by 256 segments) Once you utilize more than 65,536 lines you have outgrown your spreadsheet Only one clients can get to the spreadsheet Users can see all data in the spreadsheet Users can change all data in the spreadsheet

Slide 24

RELATIONAL DATABASE FUNDAMENTALS Entity – a man, put, thing, exchange, or occasion about which data is put away The lines in each table contain the substances In Figure 6.5 CUSTOMER incorporates Dave's Sub Shop and Pizza Palace elements Entity class (table) – a gathering of comparative elements In Figure 6.5 CUSTOMER, ORDER, ORDER LINE, DISTRIBUTOR, and PRODUCT element classes

Slide 25

RELATIONAL DATABASE FUNDAMENTALS Attributes (fields, segments) – qualities or properties of an element class The segments in each table contain the traits In Figure 6.5 characteristics for CUSTOMER include: Customer ID Customer Name Contact Name Phone Possible different traits: Address Fax E-mail Cell telephone

Slide 26

Keys and Relationships Primary keys and outside keys recognize the different elements (tables) in the database Primary key – a field (or gathering of fields) that extraordinarily distinguishes a given element in a table Foreign key – an essential key of one table that shows up a property i