Database

Data Warehouse: A Historical Perspective

E-mail Print PDF
In the 1970s the first commercial applications were built to computerize the day-to-day operations of a business. These systems were built on mainframe computers which were very expensive. Only large businesses could afford the hardware, the programmers to program them, and the operations staff to keep them running. These systems were focused on inserting new data and reading it sequentially using magnetic tapes.
 
With the invention of disk storage, the data could be accessed directly. This led to the first database management systems, which organized the data either hierarchically or in a network. These database systems were very complex. Programmers had to understand how the data was stored on the disk and navigate through the data to generate reports. Application programmers used COBOL to create custom reports. It took several days or even weeks to write the program for each new report. Reports were printed on computer paper and manually distributed to the users. There were never enough programmers, so there was always an application backlog. Once data could be accessed directly, the first on-line transaction processing (OLTP) systems were built.
Last Updated ( Friday, 15 August 2008 07:22 ) Read more...
 

Data Warehouse: What is Data Warehouse?

E-mail Print PDF
So, after all that, just what is a data warehouse and how does it fit in? A data warehouse is a database containing data from multiple operational systems that has been consolidated, integrated, aggregated, and structured so that it can be used to support the analysis and decision-making process of a business.
 
Why Do You Need a Data Warehouse?
 
Is all the information needed to run your business available when it’s needed, in the form in which it’s needed and in sufficient detail and with accuracy to base decisions upon? Or, do two users arrive at a meeting with reports that don’t match? One thinks sales for March are $500 million, and another says they are $524 million. After much analysis, you determine that different data has been used to calculate the sales in each report, and you spend considerable time trying to figure out why and correcting the problem.
 
Last Updated ( Thursday, 10 July 2008 14:49 ) Read more...
 

Data Warehouse: An Introduction to Oracle Database 10G

E-mail Print PDF

The Economic Climate Influences Technology Spending

One of the challenges of the post-dot-com bubble era that many organizations are facing is being asked to deliver more with little or no budget increase in order to improve the bottom line. You may find yourself looking for new ways to reduce technology costs, while at the same time supporting new applications and improving productivity.

In addition, in the wake of the recent corporate accounting scandals, new regulations have been put into place to enhance corporate responsibility, improve financial disclosures, and combat corporate accounting fraud. The Sarbanes-Oxley Act mandates that companies improve the overall control of the management and reporting of corporate financial information, and places the responsibility for implementing these controls
on the CEO and senior management. This in turn places new demands on the IT organization.

So, how are you able to cut costs, while at the same time improve the overall view of critical business information? How can you use your data to target opportunities, track performance, improve decision making, gain competitive edge, increase profits, and provide better financial reporting?

Consolidation

One answer may be through consolidation. Many companies are streamlining their operations by consolidating their hardware, their information, and their business practices and applications into a smaller number of centralized systems. Simplicity can then be achieved through one common infra-structure. The ability to pull together data from each part of the company provides a complete enterprise view. The data warehouse plays a critical role in this consolidation.

Last Updated ( Wednesday, 09 July 2008 15:45 ) Read more...
 

Factors Affecting the Disaster Recovery Plan

E-mail Print PDF

Ensuring the availability and integrity of the organization’s data is a database administrator’s primary responsibility. Data can be your company’s biggest asset and losing data might cost millions of dollars in lost customers and lost revenue. Having a dependable disaster recovery process is vital. It is tough to predict all possible disaster scenarios, but you can prepare for the worst and hope for the best.

Like any other activity, backups place a certain amount of overhead on the SQL Server system. Furthermore, users cannot access the database while it is being recovered. Therefore it is essential to know the factors affecting the performance of backup and restore operations and how to tune the performance of backups.

Backup is the process of copying data from the database to the backup media. If you have a valid backup you can restore the database to the state it was in when the backup was generated.

Recovery is the ability of the SQL Server database to re-run the transactions after the system failure. Changes to the data are not written to the disk immediately. Rather, transactions are initially written to the transaction log. SQL Server periodically flushes the data modifications to the disk through a process called CHECKPOINT. If a system failure occurs, SQL Server examines the transaction log at system startup. Transactions that have already been committed are saved to disk; transactions that haven’t been committed are rolled back. SQL Server cannot recover a database if the transaction log is unavailable.

Factors Affecting the Disaster Recovery Plan

Disaster recovery plans will differ significantly from one organization to the next, depending on many factors. Some of these factors are:

Last Updated ( Tuesday, 27 May 2008 09:27 ) Read more...
 

Warning: file_put_contents() [function.file-put-contents]: Only 0 of 88618 bytes written, possibly out of free disk space in /home/infoterk/public_html/mhs/new/libraries/simplepie/simplepie.php on line 7219

Warning: /home/infoterk/public_html/mhs/new/cache/dabce02cd117ef0a4ccaae9e24c38dc3.spc is not writeable in /home/infoterk/public_html/mhs/new/libraries/simplepie/simplepie.php on line 1623
Freelancer.com - New Projects
Latest projects published at Freelancer.com.
Freelancer.com
Advance SearchAdvance Search

Dukung Ubuntu

Ubuntu: For Desktops, Servers, Netbooks and in the cloud

Polls

Berapa banyak tanaman di pekarangan/rumah anda?
 
Muhammad Hari Suharto

Just for Funs...

Naik Pangkat Pagi tadi adalah waktu bincang-bincang canda dengan istriku. Begini ni critanya.Istri : Mas, kok selama ini mas ndak ada...
 

Warning: file_put_contents() [function.file-put-contents]: Only 0 of 68250 bytes written, possibly out of free disk space in /home/infoterk/public_html/mhs/new/libraries/simplepie/simplepie.php on line 7219

Warning: /home/infoterk/public_html/mhs/new/cache/688ef02f40190ecff11ffacc41cf3966.spc is not writeable in /home/infoterk/public_html/mhs/new/libraries/simplepie/simplepie.php on line 1623
Freelancer.com Delphi projects

MHSCore Logo?

 Thinking about MHSCore Logo....Laughing
MHSCore Logo?

Warning: file_put_contents() [function.file-put-contents]: Only 0 of 130938 bytes written, possibly out of free disk space in /home/infoterk/public_html/mhs/new/libraries/simplepie/simplepie.php on line 7219

Warning: /home/infoterk/public_html/mhs/new/cache/e82b35fa242816e0532cd2bbfc8525ab.spc is not writeable in /home/infoterk/public_html/mhs/new/libraries/simplepie/simplepie.php on line 1623
Freelancer.com Joomla projects

Berita Indonesia

Detik: Sungguh Begitu Hebat Orang Miskin Ahmad Juwaini - suaraPembacaTengoklah ke dalam rumah kita. Setiap hari kita selalu bergantung kepada kemampuan para pembantu yang notabene dari orang-orang miskin. Satu minggu saja rumah tangga kita t... Read more...
 

Warning: file_put_contents() [function.file-put-contents]: Only 0 of 138696 bytes written, possibly out of free disk space in /home/infoterk/public_html/mhs/new/libraries/simplepie/simplepie.php on line 7219

Warning: /home/infoterk/public_html/mhs/new/cache/ccd8c3242027452e0480b5004c8fa038.spc is not writeable in /home/infoterk/public_html/mhs/new/libraries/simplepie/simplepie.php on line 1623
Freelancer.com PHP projects

Ngisi Survey di Bayar!