Batch vs Real-time processing

hye....

now we are back......

with new information....

Batch vs Real-time processing..... 

Information systems are designed as a combination........

 of real-time and batch processing subsystems.....

Real-time processing is daily work......

 Also called online processing........

 it means that the database is updated as soon as a transaction is received.......

For example........ 

A sales order depletes inventory.......

 a stock sale updates the last close........

 a pledge adds to the fund raising balance........

 Transaction processing keeps business records up-to-date .....

the moment transactions are keyed into or transmitted ...

Batch processing is end of cycle..........

 A month-end report is batch processing as is printing payroll checks.......

There are many jobs that can be more economically processed at the end of a cycle........

 For example........

 the electronic transactions for telephone calls.......

 are stored in the computer until month end........

 when they are matched .....

against the customer tables for updating......

 with all the other telephone transactions at the same time.

that a little bit about it....

that all from us....

see ya....

Best regards,

structure of DBMS

hey..

in this post

im here to share with you about 

structure of DBMS

based on this page that i got it..

for your information..

database management system (DBMS)

~~~~~~~

are actually interface between user and database

~~~~~~~

perform various operations on database

but, 

what help DBMS to perform this all various operation?

^^ dont worry..i will tell you..

~~~~~~~

components of DBMS 

help to perform all these requested operations

on the database and 

provide necessary data to the users

DDL Compiler

Data Description Language compiler

it processes schema definitions specified in DDL

DML Compiler and Query optimizer

The DML commands 

such as insert, update, delete, retrieve from the application program

sent 

to the DML compiler 

for compilation 

into object code for database access

then

optimized the best way execute query by query optimizer

and

send to data manager

Data Manager

central software component of DBMS

========================

here we go..

just that for this post!!

see you again..

Best regards,

comparison tool can keep your data..

hye u all...

today i would like share with u,something that maybe help u to safe your databse~

okey!

usually when starting a new project or changing over to a new software program,

 your company's important data will need to be transferred without hassle.

 Database comparison tools make it easy to transfer data or convert a database no matter large or small the database. 

So whether you own a small accounting office, a busy grocery store or factory, it's important to have a safe method of transferring and comparing your data.

Transfer without Error

Data must be transferred or migrated to a new location while remaining in tact.

 You can't risk losing important information such as customer names and phone numbers, or accounting data.

 Your company probably relies heavily on the integrity and accuracy of your database. That's why using data compare tools for a smooth transition is so important.

Reduce Time Frame

You might be overwhelmed with the thought of transferring a large database from one location to another, or even from one type of software to another.

 But thanks to professional tools that compare databases such as Cross-Database Studio, this process can be completed speedily. 

Your database developers can implement the tools and transfer your data in just a few hours or less.

 The data transfer will be quick, but you won't have to worry about loss of data during the process.

How It Works

Database comparison tools have several functions to make your data transfer go smoothly. 

Using these tools, your developer will first generate SQL synchronization or migration scripts. Then he can select the schema objects that need to be migrated. Once selected, migration scripts will need to be created for the selected database objects and saved into an export file. The SQL scripts can be previewed and edited as needed. The next step will be to copy the export file to an offsite location and execute it.

Schema Comparison a Cinch

DB compare tools make schema comparison a cinch once your transfer has been completed. These enable you to compare data to make sure no discrepancies exist. The comparison can be assigned to happen during the night hours when the company is closed or any time that's convenient for your operations. Scheduling capabilities enable you to use the tools whenever it is convenient without actually having someone present at all times.

With database comparison tools such as Cross-Database Studio, your database transfer will not interfere with users as they operate the computers. The package will be compressed to reduce transfer and upload time, the tools can be used again and again, and maintained per product version.

Use database comparison tools

to synchronize a database, accomplish database replication and more. Diff database software, Cross-Database Studio and other tools can be ordered online for your convenience. Start enjoying the freedom and flexibility these tools.

resources from here!

DBMS

Assalammualaikum and good morning everyone...
i hope today is more better than yesterday...=)
today, i want to share about DBMS environment..


do you know what DBMS is..?
DBMS stands for Database Management System
it is a software system that enables users to define, create, maintain, and control access to the database..




there are 5 components of DBMS Environment
which is 

Hardware
can range from a PC to a network of computers
~~
Software
operating system, network software and also the application programs
~~
Data
used by the organization and a description of this data called the schema
~~
Procedures
instructions and rules that should be applied to the design and use of the database and DBMS
~~
People
all users of the database system
system and database administrators, database designers, system analysts and programmers and end users




now, i gonna tell you about...

the functions of DBMS


data storage management
- creates and manages complex structures required for data storage
- stores database in multiple physical data files
~~
data transformation and presentation
- transforms data entered to conform to required data structures
- transforms physically retrieved data to conform to user's logical expectations
~~
security management
creates a security system that enforces user security and data privacy
~~
multiuser access control
uses sophisticated algorithms to ensure concurrent access does not affect integrity
~~
backup and recovery management
provides backup and data recovery to ensure data safety and integrity


and...


the advantages of DBMS


- improved data sharing
- improved data security
- better data integration
- minimized data inconsistency
- improved data accessibility and responsiveness
- improved decision making
- increased end-user productivity
- control of data redundancy
- more information from the same amount of data
- enforcement of standards
- economy of scale
- balance conflicting requirements
- increased productivity
- improved maintenance through data independence
- increased concurrency
- improved backup and recovery services


but...


 it also had some
disadvantages of DBMS
such as..


- complexity
- size
- cost of DBMS
- additional hardware costs
- cost of conversion
- performance
- higher impact of a failure


i get this information for 
Database Principles : Fundamentals of Design, Implementation, and Management
Ninth Edition
Carlos Coronel, Steven Morris, and Peter Rob


Thank You...(^_^)


Best regards,

data??

hey guys!!

need me again...

hye3....

eh...now,

 i want to share with you

about data..

did you familiar with word 'data'??

===================================================

yeah!! 

data is one of the part of information system

but!!!

what is it mean???

data 

Representation of facts, concepts, or instructions 

in a formalized manner suitable for 

communication, interpretation, or processing by humans or by automatic means

and,

what about database??

database

A collection of related information, 

like employee names, addresses, and phone numbers. 

It is organized so that a computer program 

can quickly select the desired pieces of information 

and display them for you.

eh??wait a minutes!!

not just only about data and database

we are also need to know 

about database management system..

what is database management system?

database management system (DBMS)

To organize, manage, and retrieve data. 

DBMS programs have five subsystems:

~one~ 

DBMS engine

~two~

data definition

~three~

data manipulation

~four~

applications generation

~five~

data administration

================================================

eitteeee....

hey...i also want to share about

WHY WE NEED DATABASE??

~1~

We need to share data of all kinds between users (except for very small systems), between tools working on them, and usually between different computers. All should be able to work with the same set of data.

~2~

We need persistent storage and storage must be reliable.

~3~

Several users and/or several tools must be able to safely access the same data concurrently.

~4~

A DBMS may provide more efficient access to large amounts of data, through indexing and other optimizations.

~5~

A DBMS and its data model provides an abstraction; we do not need to care about the physical storage format.

~6~

A DBMS may also be used for communication between different users or applications.

==================================

i get all this information from

+__+

and 

^___^

thanks for both page for give me good information

and help me to share this information!!!!

Best regards,