Computer Science 1032A/B Chapter Notes - Chapter Final: Reduced Cost, Mycin, Offshoring

58 views46 pages
Chapter 5
Intellectual Property
Form of creative endeavor that can be protected through a trademark, patent, copyright,
industrial design, or integrated circuit topography
Content Management
Management of content data
Database Management Systems (DBMS): Effectively and efficiently storing
and processing data
Presentation of content
Content Management System (CMS): organizing documents. Seek out
documents and organize access
Spreadsheet vs Database
Spreadsheets: keep lists of single concept
Databases: Keep lists that involve multiple themes
Relational Database
Easy to understand
Relationships aren’t predefined
Database can evolve as required
Relationships are implied in the data
Database
Self-describing collection of integrated records
Hierarchy of data elements
1
Unlock document

This preview shows pages 1-3 of the document.
Unlock all 46 pages and 3 million more documents.

Already have an account? Log in
Components of a Database
Tables/files + Relationships among rows in tables + Metadata
Relationships Among Records
Primary Keys: Columns that identify unique row in tables. Each table has a
key
Foreign Keys: Primary Keys from a different table
Relational database: databases using tables, primary keys and foreign keys
Metadata
Description of the structure of database
Databases are self-describing (contain description of its content)
Metadata:
oData that describes data
oMakes Databases more useful
oMakes Databases easier to use
Components of a Database Application System
Database Management System (DBMS)
Program:
Creates database, processes database, administers database
Licensed from vendors: (Access, SQL server, Oracle etc.)
2
Unlock document

This preview shows pages 1-3 of the document.
Unlock all 46 pages and 3 million more documents.

Already have an account? Log in
Function:
Creation: tables, relationships in databases
Process database
Applications use DBMS (read data, insert data, modify data, delete data)
Administration: security, backup, improve performance, removal of data no
longer needed
Different between Database and DBMS
Database: collection of tables, relationships, and metadata
DBMS: software program
Database Application
Collection (forms, reports, queries, application programs that process databases)
Form
Read/insert/modify/delete data
Reports
Shows data in structured context. Able to compute values
Queries
Comprehensive method to query data
Structured Query Language (SQL): international standard for processing database
Database Application Programs
Forms, reports and queries (standard functions)
Application Programs
3
Unlock document

This preview shows pages 1-3 of the document.
Unlock all 46 pages and 3 million more documents.

Already have an account? Log in

Get OneClass Notes+

Unlimited access to class notes and textbook notes.

YearlyBest Value
75% OFF
$8 USD/m
Monthly
$30 USD/m
You will be charged $96 USD upfront and auto renewed at the end of each cycle. You may cancel anytime under Payment Settings. For more information, see our Terms and Privacy.
Payments are encrypted using 256-bit SSL. Powered by Stripe.