Loading presentation...

Present Remotely

Send the link below via email or IM

Copy

Present to your audience

Start remote presentation

  • Invited audience members will follow you as you navigate and present
  • People invited to a presentation do not need a Prezi account
  • This link expires 10 minutes after you close the presentation
  • A maximum of 30 users can follow your presentation
  • Learn more about this feature in our knowledge base article

Do you really want to delete this prezi?

Neither you, nor the coeditors you shared it with will be able to recover it again.

DeleteCancel

Make your likes visible on Facebook?

Connect your Facebook account to Prezi and let your likes appear on your timeline.
You can change this under Settings & Account at any time.

No, thanks

DATA BASE SYSTEM AND BUSINESS INTELLIGENCE

No description
by

jhoan baja

on 29 August 2014

Comments (0)

Please log in to add your comment.

Report abuse

Transcript of DATA BASE SYSTEM AND BUSINESS INTELLIGENCE

DATABASE SYSTEMS & BUSINESS INTELLIGENCE

DATA CLEANUP
is the process of looking for and fig inconsistencies to ensure that data is accurate and complete. It's purpose is to develop data with these characteristics.

Datebase Management Systems

is a group of programs used as an interface between a database systems.

DBMS

can range from smalll, inexpensive software packages sophisticated systems costing hundreds of thousands of dollars.
F
lat
F
ile
is a simple database program whose records have no relationship to one another. Flat File databases are often used to store and manipulates a single table or file.

Example of this is the Microsoft OneNote which is designed to let people put ideas, thoughts, and notes into a computer file.
Single User

is adatabase installed on a personal computer.

Microsoft Access and FileMaker PRo

are designed to support single-user implementation.
Multiple Users

are small,midsize,and large businesses need a multiuser DBMS's to share information throughout the organization over a network. These more powerful,expensive systems allow dozens of hundreds of people to access the same database systems at the same time;
Providing a User View

because the DBMS is responsible for a access to a database,one of the first steps in installing and using a large database involves telling the DBMS the logical and physical structure of the data and relationships among the data in the database for each user.This description is called

SCHEMA
.
Another Important step in creating a database is to establish a data dictionary, a detailed description of all data used in the database.The data dictionary contained the following data:
*Name of data item
*Alianses or other names that may be used to describe the item
*Range of values that can be used
*Type of Data
*Amount of Storage needed for the item
*Notation of the person responsible for updating it and the various users who can access it.
*List of reports.
D
A
T
A
B
A
S
E A
D
M
I
N
I
S
T
R
A
T
I
O
N
Database systems
require a skilled DBA.The role of the DBA is to plan, design, create, operate, secure, monitor, and maintain databases.
The DBA also works with programmers as they built applications to ensure that their programs comply with database management system standards and conventions.
Some organizations have also created a position called the DATA ADMINISTRATOR who is responsible for defining and implementing consistent principles for variety of data issues, including setting data standards and data definitions that apply across all the database in an organization.
Some popular DBM's for single users incle Microsoft Access and FileMaker Pro.
A new form of database as a Service (DaaS) and others as Database 2.0.

SaaS

is one in which the software is stored on a service provider's server's and accessed by the client company over a network
.
DaaS

the database is stored in a service provider's serves and accessed by the client over a network,typically the internet.
Addition to the popular database management systems were Israeli,Holocaust,
Morphbank,and iTunes.
Morphbank
allows researchers from around the worl to continually update and expand a library of over 96,000 biological images to share with the scientific commmunity and the public.
Israeli Holocaust Database
is a special-purpose database available through the Internet and contains information about three million people in 14 languages.
iTunes store music and video catalog is a special-purpose database system. When you search for your favorite artist,you are querying the database.
SCHEMAS

are entered into the DBMS via DDL or DATA DEFINITION LANGUAGE
Manipulating Data and Generating Reports

After a DBMS has been installed, employees, managers, and consumers can use it to review
reports and obtain important information. For example, the Food Allergen and Consumer
Protection Act, effective in 2006, requires that food manufacturing companies generate reports
on the ingredients, formulas, and food preparation techniques for the public. Using a
DBMS, a company can easily manage this requirement.
Database Administration
Database systems require a skilled DBA. A DBA is expected to have a clear understanding
of the fundamental business of the organization, be proficient in the use of selected database
management systems, and stay abreast of emerging technologies and new design approaches.
The role of the DBA is to plan, design, create, operate, secure, monitor, and maintain
databases. Typically, a DBA has a degree in computer science or management information
systems and some on-the-job training with a particular database product or more extensive
experience with a range of database products.
Database Administration

Database systems require a skilled DBA. A DBA is expected to have a clear understanding
of the fundamental business of the organization, be proficient in the use of selected database
management systems, and stay abreast of emerging technologies and new design approaches.
The role of the DBA is to plan, design, create, operate, secure, monitor, and maintain
databases. Typically, a DBA has a degree in computer science or management information
systems and some on-the-job training with a particular database product or more extensive
experience with a range of database products.
Popular Database Management Systems

Some popular DBMSs for single users include Microsoft Access and FileMaker Pro. The
complete database management software market encompasses software used by professional
programmers that runs on midrange, mainframe, and supercomputers. The entire market,
including IBM, Oracle, and Microsoft, generates billions of dollars per year in revenue.
Although Microsoft rules in the desktop PC software market, its share of database software
on larger computers is small.
DATABASE APPLICATIONS :)

Today’s database applications manipulate the content of a database to produce useful information.
Common manipulations are searching, filtering, synthesizing, and assimilating the
data contained in a database, using a number of database applications. These applications
allow users to link the company databases to the Internet, set up data warehouses and marts,
use databases for strategic business intelligence, place data at different locations, use online
processing and open connectivity standards for increased productivity, develop databases
with the object-oriented approach, and search for and use unstructured data, such as graphics,
audio, and video.
That's all! Thank you for watching :)
Full transcript