Sony Database

1
Sony Database

• Team 2
• Terry Bobo
• Charlie ONeal
• Kathy Brackenrich
• Amit Ahuja
• Bill Garner

2
Why Sony?

• Well Known
• Interesting to students
• Evolving in technology
• Successful
• Good example of distributed database

3
Description Of Database (i)

• Heterogeneous Distributed Database
• One Master Database
• Interactions between databases
• Multiple Database Management systems running at
  each site
• Location transparency
• Local autonomy

4
Sony Entertainment

• 3 Categories chosen
• PlayStation .....Terry Bobo
• TelevisionBill Garner
• Movies and Music...Amit Ahuja

5
Sony Diagrams (ii iii)

• PlayStation
• ER Diagrams and EER Diagrams
• By Terry Bobo

6
Sony PlayStation ER diagram
7
Sony PlayStation EER Diagram
8
Comparison of ER ERR PlayStation Diagrams

• The EER diagram, unlike the ER diagram has
  subtypes of PLAYSTATION_I and PLAYSTATION_II
  extending from the supertype, CONSOLE. These
  subtypes are disjoint, complete, and
  PLAYSTATION_I was has attributes of CD and
  CD_ID_Number, and PLAYSTATION_II has attributes
  of CD/DVD_Player, CD_ID_Number, and DVD_ID_Number.

9
Sony Diagrams (ii iii)

• Movies/Music
• ER Diagrams and EER Diagrams
• By Amit Ahuja

10
Movie and Music

• Major entities
• Customer
• Audio
• Video
• Invoice
• Credit check department
• Invoice declination

11
(No Transcript)
12
(No Transcript)
13
Sony Diagrams (ii iii)

• Televisions
• ER Diagrams and EER Diagrams
• By Bill Garner

14
(No Transcript)
15
(No Transcript)
16
Sony Object Oriented DiagramsUSA/ International
(iv)

• By Kathy Brackenrich

17
(No Transcript)
18
(No Transcript)
19
(No Transcript)
20
SonyNormalization

• (iv)

21
(No Transcript)
22
(No Transcript)
23
(No Transcript)
24
(No Transcript)
25
(No Transcript)
26
(No Transcript)
27
(No Transcript)
28
(No Transcript)
29
(No Transcript)
30
Sony

• MS ACCESS
• ORACLE (v)
• By Charlie ONeal

31
(No Transcript)
32
DATABASE TABE DEFINATIONS
33
TABLE DEFINATIONS CONT.
34
SQL SELECT C.CUSTOMER_NUMBER, C.FIRST, C.LAST,
O.ORDER_NUMBER, 2 O.BALANCE 3 FROM
CUSTOMER_S2 C, ORDERS_S2 O 4 WHERE
C.CUSTOMER_NUMBER O.CUSTOMER_NUMBER CUSTOM
FIRST LAST ORDER_N
BALANCE ------ --------- -----------
-------
--------- 126459 SHUG KNIGHT
BY4321 34.98 336987 BRIANA
BANKS ZO4743
35.57 862641 SNOOP DOGG AL2462
119.96 623471 ERIC
CARTMAN LB4643 149.97 969894
TRISH STRATUS WD5372
73.94 724568 BOB KNIGHT IT0820
23.99 643626 SARAH M. GELLAR
DK5265 26.98 756354
JESSICA SIMPSON HD6823
45.94 134435 WILL FERREL UD4256
113.97 463598 CHRIS ROCK
SL3841 44.97 264665
HANNIBAL LECTOR PD4636
44.97 11 rows selected.
35
SQL INSERT INTO CUSTOMER_S2 2 VALUES 3
('985655','HEFNER','HUGH','3745 PARADISE
LN.','PLAYBOY','CA','35355','QL3782') 1 row
created. SQL SELECT 2 FROM
CUSTOMER_S2 CUSTOM LAST FIRST
STREET
CITY STA ZIP_CODE
ORDER_N ------ ----------- ---------
-------------------------
-------------- - ---
--------- ------- 126459 KNIGHT
SHUG 187 DEATH ROW LN.
COMPTON CA. 93695
BY4321 336987 BANKS BRIANA
69 LOVERS LN. L.A.
CA. 72689
ZO4743 862641 DOGG SNOOP
420 STICKY ICKY AVE. LONGBEACH CA.
77420 AL2462 623471 CARTMAN
ERIC 4 CHEESY POOF LN.
SOUTH PARK CO. 23641
LB4643 969894 STRATUS TRISH
1821 TREASURE TRAIL RD. BOSTON
MA. 94632 WD5372 724568 KNIGHT
BOB 589 GENERAL AVE.
LUBBOCK TX. 68430
IT0820 643626 GELLAR SARAH M.
297 BUFFY AVE. NEW
YORK NY. 66289
DK5265 756354 SIMPSON JESSICA
4643 LEGAL LN.
LUBBOCK, TX 68430
HD6823 134435 FERREL WILL
1476 SPARTIN LN. QUEENS
NY. 95466
UD4256 463598 ROCK CHRIS
641 BUCKY AVE. SEATTLE
WA. 53213
SL3841 264665 LECTOR HANNIBAL 2925
CANNIBAL CIR. BALTIMORE MD.
79621 PD4636 985655 HEFNER
HUGH 3745 PARADISE LN.
PLAYBOY CA. 35355
QL3782 12 rows selected.
36
SQL ALTER TABLE CUSTOMER_S2 2 ADD CREDIT_CARD
CHAR(5) Table altered.
SQL UPDATE CUSTOMER_S2 2 SET CREDIT_CARD
'DSCV' 3 WHERE CUSTOMER_NUMBER '862641' 1
row updated. SQL UPDATE CUSTOMER_S2 2 SET
CREDIT_CARD 'MC' 3 WHERE CUSTOMER_NUMBER
'623471' 1 row updated. SQL UPDATE CUSTOMER_S2
2 SET CREDIT_CARD 'MC' 3 WHERE
CUSTOMER_NUMBER '463598' 1 row updated.
SQL UPDATE CUSTOMER_S2 2 SET CREDIT_CARD
'DSCV' 3 WHERE CUSTOMER_NUMBER '623471' 1
row updated. SQL UPDATE CUSTOMER_S2 2 SET
CREDIT_CARD 'DSCV' 3 WHERE CUSTOMER_NUMBER
'862641' 1 row updated.
37
SQL SELECT 2 FROM CUSTOMER_S2 CUSTOM LAST
FIRST STREET
CITY STA
ZIP_CODE ORDER_N CREDI ------ -----------
---------
-------------------------
--------------- --- -------- -
------- ----- 126459 KNIGHT
SHUG 187 DEATH ROW LN.
COMPTON CA. 93695 BY4321
VISA 336987 BANKS BRIANA 69
LOVERS LN. L.A.
CA. 72689 ZO4743
VISA 862641 DOGG SNOOP
420 STICKY ICKY AVE. LONGBEACH CA.
77420 AL2462 DSCV 623471 CARTMAN
ERIC 4 CHEESY POOF LN.
SOUTH PARK CO. 23641 LB4643
DSCV 969894 STRATUS TRISH
1821 TREASURE TRAIL RD. BOSTON
MA. 94632 WD5372 VISA 724568 KNIGHT
BOB 589 GENERAL AVE.
LUBBOCK TX. 68430
IT0820 VISA 643626 GELLAR SARAH M.
297 BUFFY AVE.
NEW YORK NY. 66289 DK5265
MC 756354 SIMPSON JESSICA 4643
LEGAL LN. LUBBOCK
TX 68430 HD6823 VISA 134435
FERREL WILL 1476 SPARTIN
LN. QUEENS NY.
95466 UD4256 VISA 463598 ROCK
CHRIS 641 BUCKY AVE.
SEATTLE WA. 53213
SL3841 MC 264665 LECTOR
HANNIBAL 2925 CANNIBAL CIR.
BALTIMORE MD. 79621 PD4636
VISA 985655 HEFNER HUGH
3745 PARADISE LN. PLAYBOY
CA. 35355 QL3782 VISA 12 rows
selected.
38
Sony

• Application of Advanced database concepts
• Amit Ahuja

39

• Sony Corporation being a very large organization
  has its braches located in each and every part of
  the world. The database system of Sony is very
  complex and is highly organized. The database
  system of Sony can be mainly divided into 3 main
  databases on the basis of their product type. The
  database system of Sony can be classified into a
  Data warehouse where the 3 level data warehouse
  architecture is used to organize heterogeneous
  data sources.

40

• The database system of Sony is a Data warehouse
  because it basically correlates to the definition
  of data warehouse which is mentioned in Modern
  Database Management 5th edition. As per the
  definition a data warehouse is a "A subject
  oriented, integrated, time-variant, nonvolatile
  collection of data used in support of management
  decision-making processes." After analyzing the
  database system of Sony it was found that it had
  all the features of a data warehouse.

41

• Firstly, the database system is divided into 3
  basic databases namely Movies/Audio, Television
  sets and Play station. The division is made on
  the basis of a subject and in this case it is the
  type of product each of these 3 databases relate
  to a product type that Sony sells. This makes the
  database system of Sony very subject oriented.

42

• Secondly, when developing the ER and EER
  diagrams we found that major entities and
  attributes of all the ER and EER diagrams were
  the same and related to one and another. The
  entities such as Customer, Order / Invoice
  Declination and Order are there in some form or
  the other in each and every ER and EER diagram.
  This basically establishes the fact that the
  database system of Sony is very integrated.

43

• Thirdly, the website of Sony only shows the
  latest and current products. The older ones are
  not shown in the website this basically proves
  that the databases of Sony follow a particular
  time dimension.

44

• Finally we can say that the data of Sony is
  nonvolatile as it cannot be updated by the end
  user (customer) directly as to make a particular
  purchase Sony transfers the transaction to
  another site that www.amazon.com. This
  establishes the fact the databases of Sony are
  only updated and refreshed by Sony employees
  using their operational system.

45

• All the above points prove that the database
  system of Sony is organized in a form of a data
  warehouse. The Sony database system is also a
  heterogeneous distributed database as being a
  large organization it has many subsidiaries
  located in different parts of the world. These
  subsidiaries have to maintain a database, which
  is suitable to their needs and is customized
  according to the wants of the end users, which in
  this case is the customer. These databases act as
  a local site for the specified regions. These
  various databases are maintained and updated in
  accordance to a master database that is located
  at the main head quarters of Sony making it a
  heterogeneous database.

46

• The main question that arises after such detailed
  analysis is - How can a database system of a
  corporation be a heterogeneous one and at the
  same time be a data warehouse? The solution to
  this question lies in Principle 2 of Data
  warehousing of Modern Database Management, which
  states, " Large organizations with many
  HETEROGENEOUS data sources should adopt a three
  level DATA WAREHOUSE architecture." This
  basically concludes that it is possible for Sony
  to have heterogeneous data sources if it has
  adopted the 3 level data warehouse architecture.

47

• Now that we have proved that Sonys System is
  heterogeneous and at the same time a data
  warehouse there are other features that can be
  highlighted.

48

•  
• Sonys system has synchronous databases as the
  data, which is held by them, has to be updated
  all the time. There is evidence for this when a
  person accesses their web site. If the data on
  the web page wasnt kept up to date the end user
  in this case the customer wouldnt know about the
  latest products that Sony has for sale. Since the
  user wouldnt know what is latest for sale he
  might not find any thing attractive from the
  older products and might not make a purchase,
  which is a serious loss for Sony.

49

• Sonys System replicates its data for the
  following reasons -
• Since Sonys database system has a particular
  time dimension data timeliness is very important
  for it. It cannot show out dated data as this
  would lead to a lot of loss to the company

50

• Being a very large corporation Sony has an
  extremely large and a very detailed database
  system, which pointed out to us that its DBMS has
  all the capabilities that are required to support
  a query that references data from more than one
  node. Further evidence to this point is given
  when a person tries to search the Sonys web page
  for a particular product. He is accessing the
  database of Sony by performing a search from his
  PC, which acts as a node, which is connected, to
  the server of Sony.

51

• Many people might be accessing the web site at
  the same time and would be sending their search
  queries to the database system.
• Results to these queries are provided by the
  database system in matter of minutes thereby
  illustrating the database systems capabilities.

52

• Since the database system of Sony has
  heterogeneous sources it becomes essential for it
  to use replication as replication of data would
  save time and would increase efficiency of the
  entire database system.

53
Conclusion and Summary

• Some advantages and disadvantages of Sonys
  database system.
• Advantages -
• Very Efficient and organized database system.
• Fast response provided by the database system.
• Satisfies the organizations data requirements.

54

• Disadvantages
• Very complex and difficult to understand.
• High maintenance costs due to the complexity
  of the system.

55
What does the future hold?

• Sonys SDR-4X robot can remember peoples faces
  and can even dance the disco.
• Voice recognition photographic memory
• Extensive vocabulary
• Sensors on feet for stability

56
SDR-4x dancing robots from Sony --- The Future is
in their hands
SDR-3x the prototype used to develop SDR-4x
57

• Amit Ahujas Question
• Why is the database system of Sony considered a
  Data warehouse?

58
Charlies Question

• If you were wanting to add a column to the
  customer table called CREDIT_CARD what would be
  the SQL command to do so? Also what would be the
  SQL command to enter VISA as the credit card type
  for all customers?

59
Terrys Question

• What type of database does Sony have and define
  that type.

60
Kathys Question

• What is meant by the key the whole key and
  nothing but the key? Give examples using Sonys
  normalization schemas.

61
Billys Question
Why are subtypes needed for televisions and what
are the benefits of using subtypes?
.