Database Reference
In-Depth Information
Figure 2-17: Two beauties of Oracle i.e. Data Integrity and Data
Consistency. Having a clear concept about the following two terms is
really essential because these two terms are widely used in all RDBMS.
Whenever you come across “Data Integrity” just say in your
mind that the author or speaker is referring to all different sorts
of constraints. Being a DBA, it will be one of your jobs to take
all possible steps for having data integrity in the database
because if it is an enterprise wide system, users from all over the
world will interact with the system. For any given instance some
request would be coming to Oracle instance to insert new records
others would be to update certain records and just think for a
moment if you would not be having all these different kinds of
constraints, then there would be lots of redundancy of
information, lots of errors etc. It's like filling a form online and
you are allowed to enter date of birth in the zip code field.
In short all these constraints available in Oracle, help attaining
maximum data integrity. Another term that is used widely in all
sorts of RDBMS (Relational Database Management Systems)
not only just Oracle is “Data Consistency”. It means that
everyone connected to Oracle Instance will see the consistent
view of information. Oracle has very beautiful built-in locking
mechanism. Above all Oracle takes care of this by default
magnificently but if you want you can configure and override the
default configuration. Transactional changes will only made
Search WWH ::
Custom Search