BISQL # 83 – Laymen to SQL Developer # 7 – Assignment #1 – Part #6 – Storage manager, Query Processing ,Transaction Management and Internals
Hi friends,
Lets continuing from my last post of Assignment 1 ..
- BISQL # 77 – Laymen to SQL Developer # 6 – Assignment #1 – Part #5 – Database Schemes ,Database Instances and Some Basic Definitions
- BISQL # 76 – Laymen to SQL Developer # 5 – Assignment #1 – Part #4 – What is Data Independence and All information related to Data Independence in DBMS
- BISQL # 75– Laymen to SQL Developer # 4 – Assignment #1 – Part #3 – What is Data Abstraction and All information related to Data Abstraction in DBMS
- BISQL # 72 – Laymen to SQL Developer # 3 – Assignment #1 – Part #2 – Why DBMS or What are Limitations of file processing systems
- BISQL # 69 – Laymen to SQL Developer # 1 – Introduction to brand New SQL Server Zero to Basics Series
- BISQL # 70 – Laymen to SQL Developer # 2 – Assignment #1 – Part #1–Introduction to Data and database Why Database exist ?
In this article we are covering
- What is Storage manager ?
- Issues in Storage Manger
- Query Processing
- Query Processing Unit
- Query Processing Details
- What is Transaction Management ?
- Database System Internals
- Database Architecture components
- What is Storage manager ?
Storage manager is a program module that provides the interface between the low-level data stored in the database and the application programs and queries submitted to the system.
The storage manager is responsible to the following tasks:
- Interaction with the file manager
- Efficient storing, retrieving and updating of data
- When I was kid I am confused is storage manger is humane being n all
..- But it just program module which will help you when u don’t aware of it !!!
Issues in Storage Manger:
- Storage access
- File organization
- Indexing and hashing
- Parsing and translation
- Optimization
- Evaluation
Query Processing
Query Processing Unit 
Query Processing Details
Alternative ways of evaluating a given query
- Equivalent expressions
- Different algorithms for each operation
Cost difference between a good and a bad way of evaluating a query can be enormous
Need to estimate the cost of operations
- Depends critically on statistical information about relations which the database must maintain
- Need to estimate statistics for intermediate results to compute cost of complex expressions
What is Transaction Management ?
- What if the system fails?
- What if more than one user is concurrently updating the same data?
- A transaction is a collection of operations that performs a single logical function in a database application
- Transaction-management component ensures that the database remains in a consistent (correct) state despite system failures (e.g., power failures and operating system crashes) and transaction failures.
- Concurrency-control manager controls the interaction among the concurrent transactions, to ensure the consistency of the database.
Database System Internals
Database Architecture components
The architecture of a database systems is greatly influenced by
the underlying computer system on which the database is running:
- Centralized
- Client-server
- Parallel (multi-processor)
- Distributed
Thanks for visiting my blog !!
Hope you will like this post on Database Schemes ,Database Instances and Some Basic Definitions.
If you really like reading my blog and understood at lest few thing then please don’t forget to subscribe my blog .
If you wan daily link and analysis or interesting link go to following website which will give @ your inbox please subscribe our following link resource blog
Where todays links are
-
January 31, 2012 at 11:21 pmList of Monthly post of MS BI,SQL & Link Blog – January 2012 « (B)usiness (I)ntelligence Mentalist
-
January 31, 2012 at 11:22 pmList of Monthly post of MS BI,SQL & Link Blog – January 2012 « SQL Server Mentalist
-
May 29, 2012 at 7:41 amBISQL #97 – Laymen to SQL Developer # 9 – Assignment #2 – Relational Model, Schema, Attribute, Database, Key & Relational Query « SQL Server Mentalist
SQL Server Mentalist 