Sam GoodiesSpring 2002

1
Team 4 Heather Harrison Nick Devereux Justin
Wallis Saif-ul Chowdhury Steve Gibson Tony Baker

2
SAM GOODY
Musicland Stores Corporation is a specialty
retailer of prerecorded home-entertainment
products in the United States. The company
currently operates 1328 stores (including 659 Sam
Goody stores, 406 Suncoast stores, 77 Media Play
stores, and 186 On Cue Stores) in 49 states,
Puerto Rico, and the Virgin Islands. Sam Goody
is the largest retail music chain in America.
3
SAM GOODY
We selected this database because all the items
that Sam Goodys carries, we as college students
are interested in. Even though it is a large
national chain, there is one located here in
Jonesboro which makes is easy to access. Their
Website is located at www.samgoody.com and has
many different products with a description of
each of them. The site map off the Website was
used to access the data for our presentation.
4
SAM GOODY
The database we selected is only a small portion
of a very large organization. The categories we
selected are books, video games, apparel, and
toys. These categories are things that interest
most college students. Some other categories that
could have been included are music, software,
movies, and electronics.
5
(No Transcript)
6
(No Transcript)
7
(No Transcript)
8
(No Transcript)
9
(No Transcript)
10
(No Transcript)
11
(No Transcript)
12
(No Transcript)
13
(No Transcript)
14
1
15
2
16
2
17
3
18
3
19
3
20
1
21
2
22
2
23
3
24
3
25
1
26
2
27
2
28
3
29
3
30
1
31
2
32
2
33
3
34
3
35
SAM GOODY DB ACCESS
36
SAM GOODY DB ACCESS
37
SAM GOODY DB ACCESS
38
SAM GOODY DB ACCESS
39
SAM GOODY DB ACCESS
40
SAM GOODY DB ACCESSQUERIES
41
SAM GOODY DB ACCESSQUERIES
42
SAM GOODY DB ACCESSQUERIES
43
SAM GOODY DB ACCESSQUERIES
44
SAM GOODY DB ORACLE
CREATE TABLE REWARDS_CLUB (MEMBERSHIP_NO CHAR(10)
PRIMARY KEY, POINTS DECIMAL(4,0)
) -----------------------------------------------
--- INSERT INTO REWARDS_CLUB VALUES ('8000',80) I
NSERT INTO REWARDS_CLUB VALUES ('0001',500) INSER
T INTO REWARDS_CLUB VALUES ('8050',150) INSERT
INTO REWARDS_CLUB VALUES ('3000',0)
45
SAM GOODY DB ORACLE
46
SAM GOODY DB ORACLE
47
SAM GOODY DB ORACLEQUERY
SELECT CUSTOMER.LAST, CUSTOMER.FIRST,
REWARDS_CLUB.POINTS FROM CUSTOMER,
REWARDS_CLUB WHERE CUSTOMER.MEMBERSHIP_NO
REWARDS_CLUB.MEMBERSHIP_NO
48
SAM GOODY DB ORACLEQUERY
49
Sam GoodyData Base
Mainframe of Sam Goody
Books
Apparel
Game
Toys
50
Sam Goody has been operating 659 stores around
the country in several different types of
operational mode. It has product of music,
movies, books, video games, software,
electronics, toys, apparel and more stuff. These
all contain huge amount of data, which is in
organized manner, secured, and has advanced
database system.
51
Sam Goody is in the concept of distributed
database operation. The only principle reason is
that its 659 stores have been geographically
dispersed and it is in a complex business.
Distributed database is a single logical database
that is spread physically across computers in
multiple locations that are connected by a data
communication link. Besides, distributed database
provides Sam Goody a best idea of data sharing.
Its also economical for the industry to keep the
cost lower using such database system.
52
Sam Goodys Distributed Database Environment
Heterogeneous Concept
Synchronize Distributed Data
Horizontal Vertical Partitioning
Location Transparency
Concurrency Transparency
Replication Transparency
53
One concern is questioned here how these data
administration work in Sam Goodys DBSM
environment?
54
Sam Goody Database Management System
Database (Current)
Transaction Log
Database Change log
Database (Backup)
55
In briefly, a high-level function that is
responsible for the overall management of data
resources in Sam Goody, including maintaining
corporate-wide definitions and standards. So
there are some database administrators who are
responsible for Sam Goodys physical database
design and for dealing with technical issues such
as security enforcement, database performance,
and back up and recovery.
56

POLICIES, PROCEDURES, STANDARDS
DATA PLANNING
DATA CONFLICT RESOLUTION
DATA REPOSITORY
INTERNAL MARKETTING
Database Administrator
DATA SECURITY PRIVACY
DATA BACK-UP RECOVERY
HARWARE SOFTWARE SELECTION
57
Advances in computer technology and the rapid
evolution of graphical users interfaces,
networking, and communication have changed the
way business use computing systems to meet ever
more demanding business needs.
58
Personal computers (desktop, laptops) linked
through networks that support workgroup computing
are the norm. Mainframe applications have been
rewritten to run in client/server environments
and take advantage of the greater cost
effectiveness of networks and personal computers
and workstations.
59
Sam Goody also has stayed with these new
innovations for the need of the strategies that
it necessary to fit its own business
environments, which has been filled by
client/server solution.
60
The reason Sam Goody is online with the new
technologies today because it offers flexibility,
scalability and extensibility. Advance business
plans also call for client/server solutions that
enable Sam Goody to represent itself on the World
Wide Web.
61
Puerto Rico Location
Newark Location
Jonesboro Location
LAN/ WAN
Sam Goody Application Server
Sam Goody Data base Server
Sam Goody Data
62
DATABASE ACCESS
DATABASE STORAGE
DATABASE PROCESS
AVOID NETWORK TRAFFIC
IMPROVED CLIENT/SERVER ARCHITECTURE
63
Sam Goody has focused on Internet database
servers. HTML and HTML form, Web browsers, and
Web servers are basic tools in which all
processes are done.
64
E-COMMERCE SECURITY FOR SAM GOODY
SYSTEM-LEVEL SECURITY
DATABASE-LEVEL PASSWORD SECURITY
SECURE CLEINT/SERVER COMMUNICATION
65
Sam Goody is promised to its own users and to its
customers to provide highly developed systems for
delivering information. It understands that the
success depends based on the changing of
information technology environment in which
business operates demands ever more immediate
access to data. Sam Goody also realizes that the
gain from competitive advantage requires the
process of decision making acceleration which
needs right information at the right place, right
time, and which is also easily accessible. This
is only possible by having very structured Data
warehouse.
66
Source (File)
Sam Goody Enterprise Data Warehouse
Newark Database
Transformation and Integration
Selection and Aggregation
Jonesboro Database
 
Sam Goody Data Mart
Source (External)
Sam Goody Data Mart
Query and Analysis
Software System with Model
Data Mining Analytical Tools
User Interface
67
SUMMARY AND CONCLUSIONS
Sam Goody, owned by Musicland, is a large
retailer of many items, from music, to movies and
T-shirts. For the work done on this project, we
selected only a small portion of their database
books, apparel, video games, and toys. These
items were all shown in the ER and OO diagrams,
and were all combined in the EER diagram. We
also showed how normalization can be used to help
database administrators. Microsoft Access was
the main tool we used to create the database
although there was some work done in Oracle.
68
SUMMARY AND CONCLUSIONS
For the most ideal data sharing, they use a
distributed database with the heterogeneous
concept. There is also location transparency,
local autonomy, and synchronized distributed
data. Along with that, they have replication
transparency and concurrency transparency to help
them out. They use both horizontal and vertical
partitioning to help them access data.
69
SUMMARY AND CONCLUSIONS
The Sam Goody DBMS contains a large number of
data sources so they use an enterprise data
warehouse. The enterprise data warehouse is not
access by end users, employees, but instead they
use data that has been derived from the warehouse
and stored in a data mart.
70
SUMMARY AND CONCLUSIONS
Sam Goody stays up to date with technology to
provide the best service to customers and other
end users. Their data administrators make the
system efficient with data policies, procedures,
internal marketing, standards, planning, and good
managing of the data repository. They also have
a good security system that provides
authorization and authentication. This entire
project just provides a small sample and overview
of the Sam Goody database.
71
HEATHERS QUESTION
What are some of the advantages Sam Goody has by
using a distributed database?
72
HEATHERS ANSWER
With a distributed database, there is increased
reliability and availability of data, local
control by users over their data, modular
(incremental) growth, reduced communications
costs, and faster response to request for data.
73
JUSTINS QUESTION
Why do many of the diagrams in the Sam Goodys
database look so similar?
74
JUSTINS ANSWER
The diagrams of the different databases from Sam
Goodys look similar because being in a retail
business, many of the things are held as a
constant. Such of which include the customer
attributes, payment option, specials, and for the
most part the Sam Goody store itself. The main
thing that tends to change is the individual
product itself, like books, games, apparel, and
toys. Some of the database is homogenous. For
example, books will have its own ISBN number,
etc.
75
NICKS QUESTION
What is the third normalization form for customer
broken down into from the start in first
normalization form for books?
76
NICKS ANSWER
The third normalization form for customer is
broken down into customer, customer address,
rewards club, payment, invoice, and product
option from the first normalization form in
books.
77
STEVES QUESTION
Suppose there needed to be a recall on Luigi's
Mansion for the Gamecube system. What could be
done to find out who bought them and how to get a
hold of them?
78
STEVES ANSWER
A query could be performed to found out who
bought the game, along with their phone number to
call them to tell them about the recall.
79
SAIF-ULS QUESTION
What are data administrators doing in Sam Goody
to protect their e-commerce security?
80
SAIF-ULS ANSWER

• System-level password security User names and
  passwords are typically used to identify and
  authorize users when they wish to connect with
  the system.
• Database-level password security most
  client/server DBMS have database level password
  security that is similar to system-level password
  security. Administrators made it possible to
  pass through authentication information from the
  operating system authentication capability.
• Secure client/server communication Encryption,
  transforming readable data into unreadable,
  helping Sam Goodys administrators to ensure
  secure client/server communication.

81
TONYS QUESTION
Why does Sam Goody use a data mart?
82
TONYS ANSWER
A data mart is a data warehouse that is limited
in scope. Its contents are obtained by selecting
and (where appropriate) summarizing data from
enterprise data warehouse. Each data mart is
customized for the decision-support applications
of a particular end-user group.
83
THE END