eCommerce Data

1
e-Commerce Data

• Data issues in electronic commerce.

2
e-Commerce in 2000 6.9b
3
Demographics

• 30 something years old
• College educated
• 50,000 - 60,000 income
• Modem access over telephone lines

4
e-Business functions

• Publish Information
• Accept registrations
• Execute transactions
• Connect partners

5
B2C

• Retail Storefronts
• Customer sales and transaction
• Limited client functionality
• Public access
• Poorly understood economic justification
• Customer relationship management

6
B2B

• Business to business
• Business order processing
• Supply chain management
• 100 times the retail sales volume
• Business interconnection
• EDI
• Fat client capability

7
Resource Constraints

• Managing critical resources determines data
  architectures
• Processing
• Storage
• Access/communication
• Security

8
Why Use a Database Management System?

• Storing and Retrieving Data
• Managing Metadata
• Supporting Simultaneous Data Sharing
• Providing Transaction Atomicity
• Providing Authorization and Security Services
• Increasing Programmer Productivity

9
Using Data Effectively

• Process transactions efficiently
• Access warehouse data flexibly
• Manage the data resource
• data administration
• database administration
• Global issues

10
Data Usage

• Transaction process orders
• Real Time
• Volatile
• Optimized for Update
• Warehouse discover opportunities
• Time Stamped
• Static
• Optimized for Retrieval

11
Conventional Files Cons

• Data redundancy
• Data inconsistency
• Inflexibility (program/data dependence)
• Difficulty responding to ad hoc requests
• Problems in sharing data
• Security problems

12
Definitions

• Database -organized set of files
• Database Management System - software that
  organizes, manipulates, and retrieves data stored
  in a database

13
Databases - Pros

• Reduced redundancy
• Increased data integrity
• Increased flexibility (program/data independence)
• Increased ability to respond to ad hoc requests
• Increased ability to share data
• Improved data security

14
Databases - Cons

• Increased complexity
• Slower processing speed
• Greater disk space requirements
• Higher initial development costs
• Increased vulnerability

15
Database Topology

• Centralized - all related files in one physical
  location
• Distributed - multiple locations
• External - database wholly outside organization
  but accessible by communications

16
Centralized Database
17
Centralized Databases

• Database contained in a single location
• Control of data quality and security
• Easier multi-user management
• Not scalable
• Needs substantial processing power
• Requires substantial communication

18
Distributed Databases

• Copies of a database, or portions of one, in
  multiple locations
• Problems with concurrency
• Replicated vs. partitioned
• Horizontal vs. vertical partitioning
• Consider use vs. updating

19
Distributed Database
20
External Databases

• Database managed by another organization outside
  of the company network
• Better security
• Loss of control

21
External Database
A commercial provider
22
Views of Data

• Logical
• Physical
• In database, logical view is separated from
  physical view

23

• Databases vs Files
• Relational vs Other
• Legacy/Server/Client
• Centralized/Distributed (horizontal
  vertical)/Replicated
• Multi-tier architecture
• Transaction/Warehouse