Transcript Database Environments

Database
Environments
Assignment Two
By Benjamin Turner
4/10/2016
What’s Covered
• Different Database Models
• What is a Commercial Environment
• Commercial Database Environment
•
•
•
•
Costs incurred
Database Hardware and Software
Maintenance
Training
• Integrating Platforms and Systems
• Impact of Database to Commercial Companies
4/10/2016
What’s Covered
• What is a Non-Commercial Environment
• Non-Commercial Database Environment
•
•
•
•
Costs incurred
Database Hardware and Software
Maintenance
Training
• Integrating Platforms and Systems
• Impact of Database to non-Commercial
Companies
4/10/2016
What are Databases?
In computing, a database can be
defined as a structured collection
of records or data that is stored in
a computer so that a program can
consult it to answer queries.
4/10/2016
Different Database Models
• Hierarchical Model
The hierarchical database model is an inverted
tree-like structure. The tables of this model
take on a child-parent relationship. Each child
table has a single parent table, and each
parent table can have multiple child tables.
4/10/2016
Hierarchical Model
4/10/2016
Different Database Models
• Network Model
The network database model is essentially a
refinement of the hierarchical database
model. The network model allows child tables
to have more than one parent, thus creating a
networked-like table structure. Multiple
parent tables for each child allows for manyto-many relationships, in addition to one-tomanyrelationships
4/10/2016
Network Model
4/10/2016
Different Database Models
• Relational Model
The relational database model improves on
the restriction of a hierarchical structure, not
completely abandoning the hierarchy of data,
as shown in. Any table can be accessed
directly without having to access all parent
objects
4/10/2016
Relational Model
4/10/2016
4/10/2016
What is a Commercial Database?
A Commercial Database is used by a commercial
Company to store and query data. This data can be
customer’s, Employees, Stock details and any other
data the company needs to store in their operations.
The Commercial Company is created with profit in mind
and uses the database for its commercial values. Theses
types of databases can have a small amount of
involvement in the company’s operations or the
company can fully rely on the database’s functionality
for its operations.
4/10/2016
Different Commercial Databases
Online
•
•
•
•
•
•
Internet Search Engines
Online Catalogs
Mobiles Phone Sales
Property Sales
Marketing and Advertising
Online Retail Shopping
4/10/2016
Internal
•
•
•
•
•
•
Employees Records
Customers Records
Stock Details
Finances Details
Counter Till Operations
Statistics Details
Database Costs Incurred
Hardware
•
•
•
•
•
•
•
•
•
Servers
Storage (Hard drives)
Routers
Switches
Printers and Scanners
Online (Internet)
Computer systems
Cabling Infrastructure
WAN Infrastructure
4/10/2016
•
•
•
•
•
•
•
•
Software
Bespoke
Applications
Enterprise One (Accounts)
Oracle (Database software)
Networking Software
Operating Systems
Anti Virus
Firewalls (Network
Security)
Databases Costs Incurred
•
•
•
•
Maintenance
Replacement of
Components
Replacement of New
systems
IT Technicians (Carrying out
maintenance tasks)
Networks Manager
(maintaining network
infrastructure)
4/10/2016
•
•
•
•
•
Training
Systems training
Database training (Using
the database's interface)
Application training (Using
office types software)
Operational Training
(Specific training)
Health and safety
Integrating Systems and Platforms
Systems
•
•
•
•
•
•
•
•
Orders
Tele Sales
HR department
Support
Marketing
Dispatch
Finance
Management
4/10/2016
•
•
•
•
•
•
Platforms
Application
Operating system
Networks Operating
systems
Bespoke
Hardware compatibility
Security (Firewall and Anti
Virus protection)
Advantages & Disadvantages
Advantages
• Reduced data redundancy
• Reduced updating errors and
increased consistency
• Greater data integrity and
independence from applications
programs
• Improved data access to users
through use of host and query
languages
• Improved data security
• Reduced data entry, storage, and
retrieval costs
• Facilitated development of new
applications program
4/10/2016
Disadvantages
• Database systems are complex,
difficult, and time-consuming to
design
• Substantial hardware and
software start-up costs
• Damage to database affects
virtually all applications
programs
• Extensive conversion costs in
moving form a file-based system
to a database system
• Initial training required for all
programmers and users
What is a Non-Commercial
Environments ?
This policy, mainly extracted from law of Great Britain and Canada,
addresses the conditions that an entity must meet to qualify as a nonprofit organization for purposes of the non-commercial licensing.
When determining whether an entity is a non-profit organisation, the
entity must meet all of the following conditions:
•It was organised solely for non-profit purposes.
•It is in fact operated solely for non-profit purposes.
•It does not distribute or otherwise make available for the
personal benefit of any member any of its income.
4/10/2016
Non-Commercial Database
Environments
•
•
•
•
•
•
Members Clubs
Libraries
Fundraising Groups
Charities
Non-commercial radio stations
Community News papers
4/10/2016
Databases Costs Incurred
Hardware
•
•
•
•
•
Servers
Routers
Modems
Computer systems
Cabling (Ethernet)
4/10/2016
Software
• Database MySQL (Free
database software)
• Operating Software
(Possibly Licensed)
• Application (Open
Office Free software)
• Security (Anti-Virus and
Firewalls)
Integrating systems and platforms
Systems
• Fundraising
Department
• Members Details
• Event and project
details
• Sponsors Details
4/10/2016
Platforms
• Application
• Operating system
• Networks Operating
systems
• Bespoke
• Hardware compatibility
• Security (Firewall and
Anti Virus protection)
Databases Overview
As discussed in this presentation, the database is a very
important tool to all types of organisations. The database
helps each type of organize their required data for their
individual operational requirement.
Database management system has become an important
tool to the commercial environment, because of the
requirements of the commercial company’s operations, and
has become a valuable tool in today’s commercial market.
4/10/2016
Referencing
http://www.dotnetspider.com/Database-Tutorial-122.aspx
http://alkaline.vestris.com/docs/alkaline/vestris-noncommercial.html
http://www.unixspace.com/context/databases.html
Please see Database
Environments Report
By Benjamin Turner
4/10/2016