DEFINATION OF DATABASE
DATABASE
Database is a collection of data or we can say information that is stored on a computer system. Data may include Name, age , height ,address ,business or mobile number.
In database data and information are stored in a large amount. so that if we are in need of that information we can easily access that information.
Database relationship helps in sharing and maintaining the data . For storing information many software’s are used for example MS EXCEL .
In database information is stored in the form of tables and rows .Inside data there can be so many types of tables and columns inserted for storing information.
There are so many popular websites who are daily making the use of database websites like facebook.com which all of us are known for and is a very popular website .Make use of databases. Facebook stores our data in the form of mobile numbers , profile pictures and data about our friends ,messages etc .
If we search for a person on facebook then they make use of that database for showing results.
A database is a data structure that stores organized information. Most databases contain multiple tables, which may each include several different fields. For example, a company database may include tables for products, employees, and financial records. .
INTRODUCTION TO DATABASE
In this article we will try to help you understand databases in a more simple way .On Google you will find many information regarding databases .But here we will give a more simplified Definition to database.
which is easy to understand. These details include employee record , transaction record ,salary details and product details etc .
It is very helpful for companies to have data about their customers and workers who are working on that particular company.
So ,we can say about database is that database is a data structured which is use to collect the information and this information is use for easier access ,managing data ,updating various things
We can say that databases are a type of computer structure that will save data, manage data, protect data and that can deliver data . most of the database contains multiple tables.
for example a company can use database and can include tables for products
,employees, and financial records.
Why create database (database creation)
Why we need data in our database
(online databases online database software)
We can simply say that in simple words we need a database because we can use it for having information, sorting the data ,manipulating the data and in some ways we database to collect, store, retrieve , sort , graph and for doing such things we need data in our database.
online databases for students
We need a database because the database is designed in such a way that it can collect , store and access that data.
A database is very important for companies because it can help them in storing pertinent details.
These details include employee record ,transaction record , salary details and product details etc .It is very helpful for companies to have data about their customers and workers who are working on that particular company.
DATABASE MANAGEMENT SYSTEMS (DBMS)
Database managementsystem (DBMS) is a type of computer program which is designed for storing information and runs data operations required by the users .This management system is mostly used in accounting and customer systems.
online database for small business
free business information database
Here is a list of seven common database management systems:
free business research databases
free online database creator
Depending upon the usage requirements, there are following types of databases available in the market:
database types
Centralized database.
Distributed database.
Personal database.
End-user database.
Commercial database.
Nasal database.
Operational database.
Relational database.
You can learn about this type by clicking on the names for further detailed information
ADVANTAGES of database
1. It has the ability to store large amount of data
This is the big advantage of database because large companies need
large amount of data to be stored.
2. We can easily share information.
Databases allow us to share information so companies can share information with other companies .We can share different data at the same time .
3.Faster access to the information
The information from the database is obtained very fastly and very easily . it gives us a chance for providing better customer service.
4.Increasing productivity
Allowing access to faster information can save lot of time and
have increased productivity .this access to information
can allow you to work faster and increase productivity in our company .
5. It requires very less storage space
Information is always store online so it occupies very less storage space
you will have certain document work that has to be done on paper. We can scan all documents and store the information online .It makes our task very easy.
6.It keeps our information very secured
A database contains serial parts to depend on users.
we can limit certain access to some users .In this way the information
is kept very secure and confidential data will be secured
7, very easy maintenance
As the information is stored digitally it is easy and economical for maintenance .
database schema a
high-level explanation of database architecture. Understanding the underlying
logic and concepts behind database management really makes it easier to
understand the more technical aspects of ERD further down the road.
Imagine if your database was far more
fleshed out than our simple example. Like if you had separate tables for
Shipping Address, Billing Addresses, Credit Cards, Shipping Info, etc. Trying
to make sense of a large database when you’re in the database can be very
taxing. It’s much easier to visualize it through an ERD. And that’s a super
fast process with Lucid chart’s ERD import tool.
You’ve got an idea for how your database is
going to work, and you flesh it all out in a diagram. And the awesome thing is
that when you’re done concepting, the diagram itself can be translated into the
code that forms the actual database. You don’t have to manually recreate your concept
in database form.
Database oracle In this illustration, the root's data
dictionary only contains Oracle system metadata While each PDB's data
dictionary contains user metadata.
MCDB
is a single-instance CDB with the following PDBs: ERP, DW, and SALES
STNDBY
is a standby CDB for CDBRAC. Notice that it has the same PDBs.
MCDB
has the ERP, DW, and SALES PDBs. CDBRAC has the SERVICES, HR, and
MARKETINGPDBs. Let's go back to MCDB.
the
SOURCE_FILE_NAME_CONVERT clause is required Because the source files were moved
from their original location To the new location on the CDBRAC system. After we
plug in the CDB, let's open it with an ALTER PLUGGABLE DATABASE statement
And
a FILE_NAME_CONVERT clause converts the files from the seed's location to the
new location. After that, we open the PDB
The
CDBRAC CDB has the original PDBs plus the PDBs we've added: SALES, SALES_TEST,
and CRM. Now let's look at the standby database STNDBY.
I hope by reading the above article you are now able to have some information about databases.
You guys like the above article then comment down below and also share with your friends.
.
0 Comments:
Post a Comment