ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
DataBase(DB)
2
A Database is an organized collection of interrelated data.CRUD
3
CreateReadUpdateDelete
4
A Bank DB stores data related to customers, transactions, loans etc.
5
A University DB stores data related to Students, Courses, Faculty etc.
6
7
Types of Databases:-
1.OLTP DB (Online Transaction Processing)
2.OLAP DB (Online Analytical Processing) (DWH)
8
9
10
Organization uses OLTP for running the business(day-to-day_transactions)CreateReadUpdateDelete
11
Organizations uses OLAP for Analysing the business activities
12
13
DBMS
14
Data Base Management System
15
It is a software to create and manage DB
16
DBMS is a interface between User and DB
17
18
19
Evolution of DBMS
20
Development of DBMSYearName of DBMS
21
1960File Management SystemFMS
22
1970Hierarchial or Network Data Base Management SystemHDBMS or NDBMS
23
1980Relation DBMSRDBMS
24
1990Object RelationalORDBMS
25
26
RDBMS
27
RDBMS concept was introduced by E.F.CODD
28
E.F. CODD introduced 12 rules called CODD Rules
29
A DB that supports all 12 rules called a perfect RDBMS
30
31
According to the information, the data must be organized into tables.
32
33
Database=Collection of Tables
34
Table= Collection of rows and columns
35
Row=Collection of field Values
36
Column=Collection of One Field Values
37
Learn any one of the SQL in a perfect way
38
Every table must contain a Primary Key in order to uniquely identify the records90% SQL code is same10% Keywords will changeToolsOracle SQL
39
RDBMS SoftwaresORDBMS SoftwareFromIn our Laps, client tool will be installedMicrosoft Server SQL
40
Oracle Oracle CorporationGUITeraData SQL
41
MySQLOracle CorporationGraphical User Interfece tool
42
SQL Server Microsoft CorporationSQL Developer is a UI front-end tool
43
DB2,Netezza IBMToad is also UI fron-end tool
44
POSTGRESQLPOSTGRESQL forumboth are used to pull the data from DB
45
RDSAmazonSQL Server management studio is for Micrsoft SQL Server
46
For TeraData-SQL Assistant
47
48
Other DB'S
49
TeraDataTeradata Corporation
50
SybaseSAP
51
RDBMS propertiesMangoDBNO SQL DB, 100 times faster than RDBMS
52
Easy to access and Manipulate dataRadisNo SQL DB
53
Less Redundency (Duplication of data)ElasticSearchsearch engine on Apache Lucene, Non-RDBMS NO SQL DBMS
54
More security Apache CassandraNo SQL DB, no single point of failure
55
Gurantees Data QualityMariaDBforum
56
Supports Data SharingOrientDBNo SQL DB, supports Graphs,Documents and Objects Models.
57
Supports TransactionsSQLiteBuilt upon C language, serverless light weight DBMS,
58
Amazon DynamoDBNo SQL DB, from AWS, non-RDBMS
59
Neo4jgraph DB, No SQL DB, Uses Cypher language
60
ORDBMSFirebirdLinux/Unix DB
61
Object Relational DBMSCouchDBNo SQL DB; Uses JSON,JavaScript,Regular HTTP
62
ORDBMS = RDBMS + OOPS (reusability)SAPHANAfrom SAP SE, power tool to acccess the data in a faster way. Data stores in memory but not in the disk.
63
RDBMS doesn't support reusability but ORDBMS supports reusability
64
ORDBMS supports reusability by using UDT (user define type)
65
66
Oracle up to 7 version RDBMS
67
Oracle from 8 version ORDBMS
68
69
RDBMS
70
EMP
71
empidenamesalhnostreetcitystatepin
72
73
cust
74
cidcnamehnostreetcitystatepin
75
76
Student
77
sidsnamehnostreetcitystatepin
78
79
ORDBMS
80
UDT
81
ADDRESS
82
hnostreetcitystatepin
83
84
EMP
85
empidenamesalAddress
86
87
CUST
88
cidcnameAddress
89
90
STUDENT
91
SIDSNAMEAddress
92
93
94
What is Oracle
95
Oracle is basically a RDBMS product from Oracle Corporation.
It also supports features of ORDBMS used to create and manage database.
96
97
98
DB Development Life Cycle
99
Analysis
100
 Design