All language subtitles for [SubtitleTools.com] Oracle RDBMS - Learning Oracle 12c [Video]

af Afrikaans
ak Akan
sq Albanian
am Amharic
hy Armenian
az Azerbaijani
eu Basque
be Belarusian
bem Bemba
bn Bengali
bh Bihari
bs Bosnian
br Breton
bg Bulgarian
km Cambodian
ca Catalan
ceb Cebuano
chr Cherokee
ny Chichewa
zh-CN Chinese (Simplified)
zh-TW Chinese (Traditional)
co Corsican
hr Croatian
cs Czech
da Danish
nl Dutch
en English
eo Esperanto
et Estonian
ee Ewe
fo Faroese
tl Filipino
fi Finnish
fr French
fy Frisian
gaa Ga
gl Galician
ka Georgian
de German
el Greek
gn Guarani
gu Gujarati
ht Haitian Creole
ha Hausa
haw Hawaiian
iw Hebrew
hi Hindi
hmn Hmong
hu Hungarian
is Icelandic
ig Igbo
id Indonesian
ia Interlingua
ga Irish
it Italian
ja Japanese
jw Javanese
kn Kannada
kk Kazakh
rw Kinyarwanda
rn Kirundi
kg Kongo
ko Korean
kri Krio (Sierra Leone)
ku Kurdish
ckb Kurdish (Soranรฎ)
ky Kyrgyz
lo Laothian
la Latin
lv Latvian
ln Lingala
lt Lithuanian
loz Lozi
lg Luganda
ach Luo
lb Luxembourgish
mk Macedonian
mg Malagasy
ms Malay
ml Malayalam
mt Maltese
mi Maori
mr Marathi
mfe Mauritian Creole
mo Moldavian
mn Mongolian
my Myanmar (Burmese)
sr-ME Montenegrin
ne Nepali
pcm Nigerian Pidgin
nso Northern Sotho
no Norwegian
nn Norwegian (Nynorsk)
oc Occitan
or Oriya
om Oromo
ps Pashto
fa Persian
pl Polish
pt-BR Portuguese (Brazil)
pt Portuguese (Portugal)
pa Punjabi
qu Quechua
ro Romanian
rm Romansh
nyn Runyakitara
ru Russian
sm Samoan
gd Scots Gaelic
sr Serbian
sh Serbo-Croatian
st Sesotho
tn Setswana
crs Seychellois Creole
sn Shona
sd Sindhi
si Sinhalese
sk Slovak
sl Slovenian
so Somali
es Spanish
es-419 Spanish (Latin American)
su Sundanese
sw Swahili
sv Swedish
tg Tajik
ta Tamil
tt Tatar
te Telugu
th Thai
ti Tigrinya
to Tonga
lua Tshiluba
tum Tumbuka
tr Turkish
tk Turkmen
tw Twi
ug Uighur
uk Ukrainian
ur Urdu
uz Uzbek
vi Vietnamese
cy Welsh
wo Wolof
xh Xhosa
yi Yiddish
yo Yoruba
zu Zulu

Original subtitles

In this lesson, we'll take an overall look

at some of the features and advantages of the Oracle RDBMS.

An RDBMS, or Relational Database Management System,

allows us to quickly and safely store and retrieve data.

The Oracle RDBMS is the most popular commercial database

system in the world, and has held the largest market

share for many years.

We'll look at two main topics in this lesson--

the integration benefits of Oracle

and the structural features Oracle possesses.

One of Oracle's greatest features

is its overall commitment to interoperability.

In the days before Oracle began to gain in popularity,

most database products were siloed in such a way

to restrict them to a certain hardware platform.

When Oracle made the decision to rewrite their code

base in the C programming language,

it opened up the doors for their RDBMS

to run on many different hardware platforms.

Originally confined to mainframe systems,

the Oracle RDBMS could now run on platforms

such as Windows and Unix.

During the dotcom boom, more and more companies

began to run databases on smaller platforms

in order to have a presence on the internet.

Oracle was uniquely positioned to take

advantage of this market.

Oracle continues this commitment today

and can run on multiple distributions

of Linux, Windows, Unix, and even the Apple OS 10.

While Oracle no longer supports a product

to run natively on mainframes, it

does support Oracle on zLinux, the Linux

OS running on a mainframe.

Oracle database is supported by its own patented networking

stack.

This allows Oracle to talk natively

to databases running on different types of systems

without changing the application code.

Thus, a user running a client application on Windows

can connect to an Oracle Applications

database running on Unix without any complications.

Oracle is an industry standard ACID compliant database,

meaning that it maintains data integrity

and reliability through accepted locking standards.

Any number of database products today,

known as NoSQL databases, lack this compliance.

Although Oracle is not open source,

it is shown a commitment to a number of open technologies,

such as Linux and Java.

Oracle first offered its database for the Linux platform

as early as the late 1990s, a long time

before it was accepted as a commercially viable operating

system.

It continues to support the platform with its own Oracle

Linux product.

And although Oracle Corporation is the maintainer of the Java

programming language, Java is used

in many non-Oracle products.

Oracle has a number of structural features

that contribute to its popularity.

Customers want flexibility and high performance,

and Oracle was designed that way from the ground up.

The Oracle RDBMS uses a logical structure methodology

to store data.

That is to say that users can interact with database data

without explicitly knowing where the physical files are stored.

It supports partitioning, a high performance feature

that allows tables to be divided in such a way

that different pieces of the table

can be kept across different physical storage.

Oracle supports range, hash, and list partitioning, as well as

composite methods that use combinations of each type.

From its inception, Oracle was designed

with high performance in mind.

The Oracle architecture relies on memory caches,

areas in memory that serve a defined purpose.

This caching architecture is one of the reasons

that Oracle can scale up large databases that

are still high performance.

It might be surprising to learn that in Oracle nearly

every data operation occurs in memory, not on disk,

since memory is an order of magnitude faster than disk,

Oracle can process data at very high speeds.

One of the most interesting features

to database administrators is what's called data dictionary.

The data dictionary is a set of internal tables and views

that records nearly everything that

is happening in the database.

If you want a list of all the tables in a database,

you use the SQL language to query the data dictionary.

If you want to know what trace file

a given process is writing to, you

look in the data dictionary.

Leveraging the power of the data dictionary

is one of the database administrators greatest tools.

The primary responsibility for any database administrator

is the integrity of the data.

The data stored in the database must be fully recoverable

in the event of a catastrophe.

This area is one of Oracle's greatest strengths.

The Oracle RDBMS biomass is designed

from the ground up with a fully recoverable architecture.

Every transaction is recorded for the express

purpose of being able to replay it in the event of a failure.

Oracle even includes its own powerful tool

for backup and recovery, the Recovery Manager, or RMAN.

RMAN allows DBAs to perform cold, hot and incremental

backups and do full recoveries, or even

recoveries to a point in time.

Finally, high availability is a feature

that nearly every company demands today.

Oracle has offered a cluster database solution for decades.

Originally known as OPS, or Oracle Parallel Server,

cluster databases are designed to operate

across multiple physical machine.

In the event that one machine in the cluster of fails,

Can't find what you're looking for?
Get subtitles in any language from opensubtitles.com, and translate them here.