Resume

Summary Lecture Slides & Notes - Business Data Management (30K312-B-6)

2 fois vendu

Cours
Business Data Management (30K312B6)

Établissement
Tilburg University (UVT)

Book
Fundamentals of Database Systems

This document contains all the lecture slides and notes of the course 'Business Data Management (30K312-B-6)', given at Tilburg University as an elective course. This document contains everything needed for the exam and is complete (for the theory part you still need to do the programming and ETL p...

[Montrer plus]

Aperçu 4 sur 94 pages

Voir l'exemple

Livre entier ? Non
Quels chapitres sont résumés ? Everything needed for the exam
Publié le 17 décembre 2023
Nombre de pages 94
Écrit en 2023/2024
Type Resume

ebe
economics
economie
bedrijfseconomie
business economics
business data
business data management
data analysis
uvt
tilburg university

Titre de l’ouvrage:Fundamentals of Database Systems

Auteur(s):Ramez Elmasri

Édition:2008
ISBN:9788131716250
Édition:Inconnu

Établissement
Tilburg University (UVT)
Cours
Bedrijfseconomie
Cours
Business Data Management (30K312B6)

Dee25

Membre depuis 3 année 108 documents vendus

6,49 €

Ajouter au panier

Ajouter au liste de veux

Garantie de satisfaction à 100%
Disponible immédiatement après paiement
En ligne et en PDF
Tu n'es attaché à rien

Lecture 1
Chapter 1 Databases

Traditional applications:
● numeric and textual databases

More recent applications:
● Multimedia databases
● Geographic information systems (GIS) (google maps)
● Data warehouses
● Mobile databases, online analytical processing (OLAP)
● Real-time and active databases
● Big data

Basic definitions:
● Data:
○ Known facts that can be recorded and have an implicit meaning
● Database:
○ A collection of related data
● Mini-world:
○ Some part of the real world about which data is stored in a database. For
example, student grades and transcripts at a university.
● Database management system (DBMS):
○ A software package/system to facilitate the creation and maintenance of a
computerized database
● Database system:
○ The DBMS software together with the data itself. Sometimes, the applications
are also included

Properties of a database:
- A database represents some aspects of the real world (Mini world or universe of
discourse (UoD)
- A database is a logically coherent collection of data with some inherent meaning
- A database is designed, built, and populated with data for a specific purpose

The DBMS is a general purpose software system that facilitates the process of defining,
constructing, manipulating and sharing databases among various users and applications.

,Typical DBMS functionality
● Define a particular database in terms of its structures, data types, and constraints
● Construct or load the initial database contents on a storage medium
● Manipulating the database:
○ Retrieval: querying, generating reports
○ Modification: insertions, deletions and updates to its content
● Sharing by a set of concurrent users and application programs - yet, keeping all data
valid and consistent

● DBMS may additionally provide:
○ Presentation and visualization of data (table and graphs)
○ Protection or security measures to prevent unauthorized access
○ Maintenance of the database and associated programs over the lifetimes of
the database application
● Applications interact with a database by generating:
○ Queries: that access different parts of data and formulate the result of a
request
○ Transactions: that may read some data and “update” certain values or
generate new data and store that in the database
● Applications can define data authorisation for users
● Applications can keep up with requirements change over time

Example of a database
● Mini-world for the example:
○ List out the main entities in “university” mini-world
■ STUDENTS
■ COURSE
■ SECTION (of COURSEs)
■ GRADE REPORT
■ PREREQUISITE
● Some university concepts:
○ List out the main properties/attributes to describe each STUDENT, COURSE,
SECTION, GRADE REPORT, PREREQUISITE
○ For example: STUDENT: student’s name, student number, and major
○ COURSE: course name, course number, credit hours, and department
○ SECTION: section identifier, course number, semester, year, and instructor
○ GRADE REPORT: student number, section identifier, grade
○ PREREQUISITE: course number prerequisite number
● Some university relationships
○ SECTIONs are of specific COURSEs
○ STUDENTs take SECTIONs
○ COURSEs have prerequisite COURSEs
○ STUDENTs have GRADE REPORTs

,Design of a new application for an existing database or design of a brand new database
starts off with a phase called requirements specification and analysis. These
requirements are documented in detail and transformed into a conceptual design that can
be represented and manipulated using some computerized tools so that it can be easily
maintained, modified, and transformed into a database implementation. The design is then
translated to a logical design that can be expressed in a data model implemented in a
commercial DBMS. The final stage is physical design, during which further specifications
are provided for storing and accessing the database.

In traditional file processing, each user defines and implements the files needed for a
specific software application as part of programming the application. In the database
approach, a single repository maintains data that is defined once and then accessed by
various users repeatedly through queries, transactions, and application programs.

, The main characteristics of the database approach versus the file-processing approach are
the following:
■ Self-describing nature of a database system
■ Insulation between programs and data, and data abstraction
■ Support of multiple views of the data
■ Sharing of data and multi user transaction processing

Main characteristics of the database approach
● Self-describing nature of a database system:
○ The description is called meta-data
○ A DBMS catalog stores the description of a particular database (e.g. data
structures, types and constraints)
○ This allows the DBMS software to work with different database applications
○ Some newer systems such as a few NOSQL systems need no meta-data:
they store the data definition within its structure making it self-describing

Main characteristics of the database approach
● Insulation between programs and data:
○ Called program-data independence
● Data abstraction:
○ A data model is used to hide storage details and the present the users with a
conceptual view of the database
● Support of multiple views of the data:
○ Each user may see a different view of the database, which describes only the
data of interest to that user
● Sharing of data and multi-user transaction processing:
○ Allowing a set of concurrent users to retrieve from and to update the
database
○ OLTP (Online transaction processing) is a major part of database
applications. This allows hundreds of concurrent transactions to execute per
second.
○ Concurrency control within the DBMS guarantees that each transaction is
correctly executed or aborted

Les avantages d'acheter des résumés chez Stuvia:

Qualité garantie par les avis des clients

Les clients de Stuvia ont évalués plus de 700 000 résumés. C'est comme ça que vous savez que vous achetez les meilleurs documents.

L’achat facile et rapide

Vous pouvez payer rapidement avec iDeal, carte de crédit ou Stuvia-crédit pour les résumés. Il n'y a pas d'adhésion nécessaire.

Focus sur l’essentiel

Vos camarades écrivent eux-mêmes les notes d’étude, c’est pourquoi les documents sont toujours fiables et à jour. Cela garantit que vous arrivez rapidement au coeur du matériel.

Foire aux questions

Qu'est-ce que j'obtiens en achetant ce document ?

Vous obtenez un PDF, disponible immédiatement après votre achat. Le document acheté est accessible à tout moment, n'importe où et indéfiniment via votre profil.

Garantie de remboursement : comment ça marche ?

Notre garantie de satisfaction garantit que vous trouverez toujours un document d'étude qui vous convient. Vous remplissez un formulaire et notre équipe du service client s'occupe du reste.

Auprès de qui est-ce que j'achète ce résumé ?

Stuvia est une place de marché. Alors, vous n'achetez donc pas ce document chez nous, mais auprès du vendeur Dee25. Stuvia facilite les paiements au vendeur.

Est-ce que j'aurai un abonnement?

Non, vous n'achetez ce résumé que pour 6,49 €. Vous n'êtes lié à rien après votre achat.

Peut-on faire confiance à Stuvia ?

4.6 étoiles sur Google & Trustpilot (+1000 avis)

68175 résumés ont été vendus ces 30 derniers jours

Fondée en 2010, la référence pour acheter des résumés depuis déjà 15 ans

Commencez à vendre!

Resume

Summary Lecture Slides & Notes - Business Data Management (30K312-B-6)

Infos sur le Document

Sujets

Livre connecté

École, étude et sujet

Vendeur

Avis reçus

Aperçu du contenu