Dr P Sreenivasa Kumar
I I T Madras
Prof P Sreenivasa Kumar
Department of CS&E, IITM
What is a Database?
A collection of related pieces of data:
Representing/capturing the information a
7000+ Learners already benefited from www.HadoopExam.com
Professional Training for BigData and Apache Hadoop
While watching we promise you will say WOW! At least once
Accelerate Your and Organization Hadoop Education
Apache Hadoop is increasingly being ad
Something's You should Know before using this Utility
New Question Set
For Selecting New Question Set
For Selecting Next Question
For Selecting Previous Question
Question Number against
1. Two devices are in network if
a) a process in one device is able to exchange information with a process in another device
b) a process is running on both devices
c) PIDs of the processes running of different devices are same
PROCESS : AP001
Manage the IT Management Framework
Management Practice APO01.06 : Define information (data) and System
Define and implement procedures to ensure the integrity and consistency of all data
stored in electronic form,such as database
Hardening Windows Server 2008
1. Configure a Secuirty Policy:
Install Security Configuration Wizard through Add and remove windows
detect ports and services, and configure registry and audit
settings according to the server's role.
Listed below are the activities associated with each of the governance and management practices in COBIT 5.
The activities are sorted in the order in which they appear in COBIT 5: Enabling Processes.
RACI Chart Board of Directors
Evaluate risk management.
Direct risk management.
Monitor risk management.
Chief Executive Chief
CENTRAL POWER RESEARCH INSTITUTE (CPRI)
(Government of India Society, Ministry of Power)
Consultancy Services for ERP Implementation
(Bidding through e-Tender mode only)
Request for Proposal (RfP)
Appointment of Consultant
THIS PAGE IS LEFT BLANK INTE
Windows Server 2012 R2 Hardening Checklist
The hardening checklists are based on the comprehensive checklists produced by CIS. The Information Security Office has distilled the CIS lists
down to the most critical steps for your systems, with a particular
Governance under The Companies Act,2013
Companies Act, 2013
Section 149, Schedule IV
The Company and independent directors shall
abide by the provision specified in Schedule IV,
which includes the roles and functio
Database Design and Normal Forms
coming up with a good schema is very important
How do we characterize the goodness of a schema ?
If two or more alternative schemas are available
how do we compare them ?
What are the problems with bad sche
File Organization and Indexing
The data of a RDB is ultimately stored in disk files
Disk space management:
Should Operating System services be used ?
Should RDBMS manage the disk space by itself ?
2nd option is preferred as RDBMS requires complete
The SQL Standard
SQL Structured Query Language
a standard that specifies how
a relational schema is created
data is inserted / updated in the relations
data is queried
transactions are started and stopped
programs access data in the relations
and a host
Proposed by Edgar. F. Codd (1923-2003) in the early
seventies. [ Turing Award 1981 ]
Most of the modern DBMS are relational.
Simple and elegant model with a mathematical basis.
Led to the development of a theory of data depen
Tuple Relational Calculus ( TRC )
Procedural Query language
query specification involves giving a step by step process of
obtaining the query result
e.g., relational algebra
usage calls for detailed knowledge of the operators involved
Dr P Sreenivasa Kumar
CS&E Dept I I T Madras
Entity-Relationship (E/R) Model
Widely used conceptual level data model
proposed by Peter P Chen in 1970s
Data model to describe the database system at the requirement
Developer training was great.
I believe Cloudera is the best
vendor evangelizing the Big
Data movement and doing
a great service in promoting
Hadoop in the industry. Thanks
for all your help getting me
started on this journey.