BASICS:
DBMS – DATA BASE MANAGEMENT SYSTEM.
RDBMS -- RELATIONAL DBMS
DATA --- Collection of Files.
Files .txt (Notepad)
.doc(Ms-Word)
.ppt(Ms- PowerPoint)
.xls (Ms- Excel)
.pdf(Acrobat)
And some more example you can find in the below links for file extensions
http://www.fileinfo.com/filetypes/common
http://en.wikipedia.org/wiki/List_of_file_formats
DATA BASE:
Logical container to store the data in the form of tables, objects & Procedures, functions etc.
ODBC Open Data base Connectivity.
2- Tier Architecture :
FRONT END ODBC BACK END
Java, .Net (Developers) DATABASE
(SQL, MYSQL, DB2, SYBASE, FOXPRO)
Database Developers
It is named as 2-Tier Architecture because it has Front end and Back end.
Example:
Front End -- >> Gmail’s Home page (User Interface page)
Back End -- > > Data stored here (Your emails and data files, attachments etc)
If you’re using java, then it’s JDBC connectivity.
ADO. NET connectivity is for DOT NET.
3 – Tier Architecture:
APPLICATION SOFTWARE
|
|
FRONT END ODBC BACK END
(Developers) DATABASE
(SQL, MYSQL, DB2, SYBASE, FOXPRO)
Database Developers
It is named as 3-Tier Architecture because it has
Application Software, Front end and Back end.
APPLICATION SOFTWARE:
Application software, also known as an application or an "app", is computer softwaredesigned to help the user to perform specific tasks. Examples include enterprise software, accounting software, office suites, graphics software and media players. Many application programs deal principally with documents. Apps may be bundled with the computer and its system software, or may be published separately. Some users are satisfied with the bundled apps and need never install one.
4 – Tier Architecture:
APPLICATION SOFTWARE
(Desktop Applications)
|
|
FRONT END ODBC BACK END
(Developers) DATABASE
(SQL, MYSQL, DB2, SYBASE, FOXPRO)
|
| Database Developers
Web Browser
(ASP. NET, PHP)
It is named as 4-Tier Architecture because it has
Application Software, Front end, Back end and Web Browser.
DATABASE MANAGEMENT SYSTEM (DBMS)
There are 3- types of DBMS:
HDBMS -- Hierarchal DBMS
NDBMS -- Network ’’
RDBMS -- Relational ’’
RDMS -- 12 Rules (E F CODD RULES).
http://en.wikipedia.org/wiki/Types_of_DBMS
RDBMS ----
ORACLE – PL/SQL -- 80% Market (Platform Independent) -12 EF Codd Rules
SQL SERVER -- 20% market
MS ACCESS
MY SQL
DB2
SYBASE
FOXPRO
PORT GRE SQL
Oracle PL/SQL follows 12 EF codd Rules.
http://en.wikipedia.org/wiki/Codd's_12_rules
DB2, FOXPRO, PORT GRE SQL follows only 4/5 E F CODD RULES.
Platform Independent: It works on any platform (UNIX, Linux, and Windows).
GUI – GRAPHICAL USER INTERFACE (Windows 7/XP)
NOT GUI – Command prompt.
ORACLE stands for
OAK RIDGE AUTOMATIC COMPUTER LOGICAL ENGINE.
ORACLE
1. USER.
2. DEVELOPER.
3. ADMIN/ADMINISTRATOR.
USER -- SQL knowledge is enough.
DEVELOPER -- SQL, PL/SQL knowledge is enough.
ADMIN - He should know the following point below:
1. Sql
2. Pl/Sql
3. How to take a backup.
4. Maintenance of data
5. Tuning
6. Restore
7. Replication
8. Data Guard
Replication is the process of sharing information so as to ensure consistency between redundant resources, such as software or hardware components, to improve reliability, fault-tolerance, or accessibility.
Data Guard:
Providing the security to database.
ORACLE FLAVOURS
1. ENTERPRISE EDITION – This is for Companies.
2. EXPRESS EDITION (XE) – This is for STANDALONE (for single users/Single system).
3. STANDARD EDITION – This is for globally.
4. WORK GROUP – This is for Office purpose.
VERSIONS OF ORACLE:
1979 – Version 1
1990 – 6.0 Version
1995 – 7.0
1996 – 7.1
1997 – 7.2
1998 – 8i (‘i’ stands for internet. It is a first internet version and platform independent).
2000 – 9i
2004 –10g (‘g’ stands for GRID COMPUTING).
2007 – 11g
Grid computing is a term referring to the combination of computer resources from multiple administrative domains to reach a common goal.
http://ss64.com/ora/syntax-versions.html
No comments:
Post a Comment