Podcast
Questions and Answers
What type of data do social networks like Facebook and Twitter collect?
What type of data do social networks like Facebook and Twitter collect?
- Only financial transactions
- Only communications among people
- Information about people and their communications (correct)
- Only web pages for searching purposes
What is the purpose of search engines like Google and Bing collecting their own repository of web pages?
What is the purpose of search engines like Google and Bing collecting their own repository of web pages?
- For social networking
- To collect information about people
- For searching purposes (correct)
- To provide personalized services
What is a characteristic of Big Data storage systems?
What is a characteristic of Big Data storage systems?
- Involving large clusters of distributed computers (correct)
- Storing only small amounts of data
- Using only SQL systems
- Using a single computer for storage
What is a recent development in the field of database technology?
What is a recent development in the field of database technology?
What is an example of a service industry that uses database technology?
What is an example of a service industry that uses database technology?
What is a recent application of database technology?
What is a recent application of database technology?
What is a primary function of a DBMS in terms of defining a database?
What is a primary function of a DBMS in terms of defining a database?
What is an example of a modification operation in a DBMS?
What is an example of a modification operation in a DBMS?
What is the primary concern of applications interacting with a database?
What is the primary concern of applications interacting with a database?
What is an additional function that a DBMS may provide?
What is an additional function that a DBMS may provide?
What is an example of a mini-world entity in a UNIVERSITY environment?
What is an example of a mini-world entity in a UNIVERSITY environment?
What is the purpose of a transaction in a DBMS?
What is the purpose of a transaction in a DBMS?
What is a primary method of accessing a database?
What is a primary method of accessing a database?
What is a primary function of a DBMS in terms of multiple users?
What is a primary function of a DBMS in terms of multiple users?
What is the relationship between a STUDENT and a SECTION?
What is the relationship between a STUDENT and a SECTION?
What is the credit hour for the COURSE 'Intro to Computer Science'?
What is the credit hour for the COURSE 'Intro to Computer Science'?
What is the prerequisite for the COURSE 'Data Structures'?
What is the prerequisite for the COURSE 'Data Structures'?
Which INSTRUCTOR teaches the SECTION with Section_identifier 102?
Which INSTRUCTOR teaches the SECTION with Section_identifier 102?
What is a database?
What is a database?
What is the department offering the COURSE 'Intro to Computer Science'?
What is the department offering the COURSE 'Intro to Computer Science'?
What is data?
What is data?
What is the relationship between a COURSE and a DEPARTMENT?
What is the relationship between a COURSE and a DEPARTMENT?
What is a mini-world?
What is a mini-world?
What is the Semester of the SECTION with Section_identifier 112?
What is the Semester of the SECTION with Section_identifier 112?
What is a Database Management System (DBMS)?
What is a Database Management System (DBMS)?
What is the relationship between a STUDENT and a DEPARTMENT?
What is the relationship between a STUDENT and a DEPARTMENT?
What is a Database System?
What is a Database System?
What type of databases are focused on in the first part of the course?
What type of databases are focused on in the first part of the course?
What is an example of a traditional database application?
What is an example of a traditional database application?
What is NOT an example of a more recent database application?
What is NOT an example of a more recent database application?
What is the data type of the 'Student_number' column in the database catalog?
What is the data type of the 'Student_number' column in the database catalog?
What is the role of database administrators?
What is the role of database administrators?
What is the type of 'Course_number' in the database catalog?
What is the type of 'Course_number' in the database catalog?
What is the primary role of database designers?
What is the primary role of database designers?
Who are the 'Workers Behind the Scene' in the context of database users?
Who are the 'Workers Behind the Scene' in the context of database users?
What is the data type of the 'Major' column in the database catalog?
What is the data type of the 'Major' column in the database catalog?
What is the primary responsibility of those who use and control the database content?
What is the primary responsibility of those who use and control the database content?
What is the relation name that the 'Course_name' column belongs to in the database catalog?
What is the relation name that the 'Course_name' column belongs to in the database catalog?
Study Notes
Recent Developments
- Social networks (e.g. Facebook, Twitter) capture information about people, communications, and shared content (posts, tweets, photos, videos)
- Search engines (e.g. Google, Bing, Yahoo) collect web pages for searching purposes
- New technologies manage vast amounts of web data:
- Big Data storage systems with distributed computers
- NOSQL (Not Only SQL) systems
- Large data centers using thousands of machines ("cloud")
Impact of Databases and Database Technology
- Businesses: Banking, Insurance, Retail, Transportation, Healthcare, Manufacturing
- Service industries: Financial, Real-estate, Legal, Electronic Commerce, Small businesses
- Education: E-learning
- Recently impacted: Social Networks, Environmental and Scientific Applications, Medicine and Genetics
- Personalized applications: based on smart mobile devices
Basic Definitions
- Database: a collection of related data
- Data: known facts with implicit meaning
- Mini-world: part of the real world for which data is stored in a database
- Database Management System (DBMS): software for creating and maintaining a computerized database
- Database System: DBMS software, data, and applications
Types of Databases and Database Applications
- Traditional applications: Numeric and Textual Databases
- More recent applications: Multimedia, Geographic Information Systems (GIS), Biological and Genome Databases, Data Warehouses, Mobile databases, Real-time and Active Databases
Typical DBMS Functionality
- Define a database in terms of data types, structures, and constraints
- Save initial database contents on secondary storage medium
- Manipulate the database: retrieval, modification, and access control
- Processing and sharing by concurrent users and application programs
Application Activities Against a Database
- Applications interact with a database by generating queries and transactions
- Queries access different parts of data and formulate the result of a request
- Transactions read data and update certain values or generate new data and store it in the database
- Applications must not allow unauthorized users to access data
Additional DBMS Functionality
- DBMS may provide protection or security measures to prevent unauthorized access
- Presentation and visualization of data
- Maintenance of the database and associated programs over the lifetime of the database application
Example of a Database (with a Conceptual Data Model)
- Mini-world: part of a UNIVERSITY environment
- Entities: STUDENTs, COURSEs, SECTIONs, DEPARTMENTs, INSTRUCTORs
- Relationships: SECTIONs are of specific COURSEs, STUDENTs take SECTIONs, etc.
Example of a Simple Database
- COURSE table with columns: Course_name, Course_number, Credit_hours, Department
- SECTION table with columns: Section_identifier, Course_number, Semester, Year, Instructor
Database Users
- Actors on the scene:
- Database administrators: responsible for authorizing access, coordinating use, and monitoring efficiency
- Database designers: responsible for defining content, structure, constraints, and functions or transactions
Studying That Suits You
Use AI to generate personalized quizzes and flashcards to suit your learning preferences.
Description
This quiz covers recent developments in data management, including social networks and search engines, and their role in collecting and storing vast amounts of data. Topics include Facebook, Twitter, Google, and more.
