Overview

• Collecting and organizing data
• Managing data
• What is a database?
• Complications
• Assignment

• People and Data
• Data Privacy
• Surveillance Potential
• Security and Access Control
• Data Quality and Database Quality Assurance
• Just because data is in a database, is it accurate? Trustworthy? Secure? Private?
• Search engines on the Web:
• The ultimate database application?
• 800+ Web search engines (and meta-search engines)
• Search engine databases "filled" automatically via "spiders" that crawl across the Web
• Should all information be put onto the Web, or onto a corporate secureWeb server?

• Structuring -- building data models/schemas that organize data sets
• Storing -- placing data into a repository or database following the data model
• Retrieving -- selecting data from a database for display or further processing
• Updating -- modifying the value of stored data
• Archiving -- preserving data sets for historical purposes (e.g., audit, data warehousing)

• A database is:
• a collection of data objects and instance values
• represented as a single type of data model
• created, populated, and updated using a database schema definition/query language
• managed by a database management system under the control of a database administrator

• Objects: records, numbers, character strings (words, names, etc.), money, time periods, business rules, computational procedures, narrative text, messages, graphic images, photographs, animations, sound files (e.g., MP3), movies, file systems, databases, etc.

• Hierarchical (tree of relationships)
• Network (graph of relationships)
• Hypertext; the Web
• Relational (inter-related tables)
• Object-oriented ("object" hierarchies)
• Object-relational (object-oriented tables)
• Semantic network (object-relational networks)

• Database Schema
• A notation for describing data objects that conform to a particular data model
• Also called meta-data ("data about data") that can be stored within a database
• Schemas are application-specific
• Data Definition Language
• A language for creating, updating, or removing database schemas

• Database Query Language
• A language for inserting, updating, deleting, searching, selecting, and associating data values for objects modeled with database schemas.
• SQL: the Standard Query Language?
• Data Definition and DB Query Language are usually a single language (e.g., SQL-92)

• An integrated ensemble of software programs used to:
• create databases and data schemas that store object data values
• "execute" data definition and data query language commands
• provide automated services for backup, recovery, journaling, audit, and archiving of databases

• Person responsible for controlling:
• who can create, remove or access databases
• who can create or remove DB schemas
• database "integrity"
• database management services for backup, recovery, journaling, etc.

• Managing assembled collection of heterogeneous databases
• Integrating heterogeneous repositories:
• Web, network file servers, local databases, Web browser bookmark list, personal contact list on a PDA, CDROMs, DVDs, etc.
• Capture, access control and licensing of multi-media content assets (e.g., Napster vs. Morpheus or Kazaa)

• Read article on identity theft
• Search on the Web for personal information about you!
• Go to one or more Web search engines to learn who knows what about:
• Your name, home address, driver's license number,
• social security number, car/home loan number,
• credit card numbers, other personal information you value
• Develop a possible scenario for "business identity theft" and how to defend against it.
• Come prepared to discuss what you find!