Summary: Principles Of Database Management
- This + 400k other summaries
- A unique study and practice tool
- Never study anything twice again
- Get the grades you hope for
- 100% sure, 100% understanding
Read the summary and the most important questions on Principles of Database Management
-
1 1. Fundamental Concepts of Database Management
This is a preview. There are 5 more flashcards available for chapter 1
Show more cards here -
File versus Database Approach to Data Management?
FILE
- duplicate and redundant info
- danger inconsistency
- strong coupling between applications and data
- hard to manage concurrency
- hard to integrate applications aimed at cross company services
DATABASE
- more efficient, consistent, easier maintenance
- loose coupling between application and data
- facilities for data quierying and retrieval (SQL) -
What is database model and instance?
The model provides a description of the database data at different levels of detail and specifies items, characteristics, relationships, constraints, storage details, etc. Specified during database design
Example:
Student(number, name, email)
Course(number, name)
Building(number, address)
State represents the data in the database at particular moment. Also called the current set of instance -
What is a data model? 4 versions
Provides a clear and unambiguous description of the data items, their relationships and various data constraints from a particular perspective.
Conceptual: provides high-level description of the data items with their characteristics and relationships. (EER and object oriented)
Logical: is a translation or mapping of the conceptual towards a specific implementation environment: CODASYL, relational, object oriented, XML or NoSQL.
Internal: represents the data's physical storage details
External: also called views, tailored towards the needs of specific applications or groups. Subsets of data. -
Explain the three layer architecture
External layer with views
-> External/logical mapping = logical data indepence
Conceptual/logical layer with data items
-> logical/internal mapping = physical data independence
Internal layer: files, disk, cloud -
Who are the database users?
1. Information architect: designs conceptual model
2. Database designer: translate conceptual into logical and internal
3. Database administrator: responsible for implementation and monitoring
4. Application developer: develops database applications
5. Business user, will run these applications -
What type of database languages?
Data definition language (DDL), to express database external, logical and internal models.
Data manipulation language (DML), to retrieve, insert, delete and modify data
Structured Query Language (SQL), offers DDL and DML statements for relational database systems -
What are the advantages of database systems and management?
Data independence
Database modeling
Managing data
Managing redundancy
Integrity rules
Concurrency
Backup and recovery facilities
Data security
Performance utilities -
Types of structured data?
Structured
- can be described by formal logical data model
- express integrity rules and enforce correctness of data
- facilitates searching, processing and analyzing
Unstructured
- no finer grained components that can be interpreted
Semi structed
- data which has structure, but irregular and volatile -
What are the three KPIs of a DBMS?
- response time denoting the time elapsed between issuing a request and the termination
- throughput rate representing the transactions per unit of time
- space utilization referring to the space utilized to store both raw and metadata -
2 2. Architecture and Classification
This is a preview. There are 8 more flashcards available for chapter 2
Show more cards here -
Parts in architecture of a dbms?
Connection and security manager
DDL compiler
Query processor
Storage manager
DBMS utilities
DBMS interfaces
- Higher grades + faster learning
- Never study anything twice
- 100% sure, 100% understanding
For my 1st exam I got a C. Then, I started looking for ways to learn better and I came across Study Smart. Since then I have scored a A+, A, A- and another A. I highly recommend it to everyone who wants to hear it. I am so happy with it!!
I was struggling to finish all my first-year subjects for 3 years. Then I discovered Study Smart, which helped me to finish all of them within 3 months.
Because of StudySmart, things are going well in many ways. Before, I always had study stress and no time for anything. Now I feel calm and confident (because of the program). I used to score a B, now I usually score an A or A+.
Hey Chris, I really want to thank you very much for developing the platform, I usually got around C for my exams, now I scored an A+, an A and a A- !!
Since using Study Smart, my average has increased significantly. I even completed a statistics course with a A+ while I'm bad at statistics. I took on extra courses this year, because of Study Smart. Thanks so much!
Ever since I started studying with StudySmart I passed all my exams !!! No more re-sits!! At first, I was happy with a pass and now I only get good grades. Many thanks!
I aced all the courses I studied with Study Smart. For law, I first scored a D, and now an A! I’m 100% sure that I’ll pass all the courses I study with Study Smart.
I always thought I studied well. My grades were fine. I could never have imagined that applying these study skills would have such a huge and direct impact on my grades, my speed and the pleasure I have in learning.
For the first time, I finally feel totally confident about the way I learn. I have the perfect overview and make great progress in terms of speed and the grades I get. Thanks, Chris!
I immediately started to enjoy learning again, and my grades soared. All of a sudden, everything went better. I highly recommend Study Smart to all students..
Being able to create my materials online made the process of studying so much smoother and quicker. I no longer have to spend a huge amount of my time on creating my summaries.
At first, my notes were a mess. Now I use Study Smart to take my notes in a perfectly structured way. It helps me to save a lot of time and do other things I enjoy.
Students that study with Study Smart get better grades. The system applies all the learning methods in such a way that both well-performing students and students who struggle perform much better.
Hi Chris, I would like to thank you very much. Last year I scored C on a course, and this year I got an A+ thanks to your method! Thank you very much!
The largest effect is that my child is more enthusiastic about school! Every parent wants their children to be happy at school, Study Smart made it happen.
In high school, I failed several exams, and that has really changed now. I actually needed this tool very much back then. Since I started studying with StudySmart, I haven't had any D's. My average score is now an A and those are results I would have never had in the past
With my old method, I passed only 3 out of 8 courses. Since I started taking my notes digitally in Study Smart, I have passed all my courses on the first try. For me, StudySmart takes away the stress of wondering if I will pass or not.
Thanks to StudySmart, I passed all my exams, and with better grades than before! On top of that, I have mastered a very good study method now, which I am confident will help me earn my degree.
