Evaluating the compatibality of MS-Excel spreadsheet as an alternative data source in active server pages environment / Ali Seman

The use of the database as a data source has been seen as a phenomenal growth on the Internet. The web-to-database integration is often synonymously with web-based applications to be more dynamic and interactive in manipulating the contents. However, there are limitations in the adoption of database...

Full description

Saved in:
Bibliographic Details
Main Author: Seman, Ali
Format: Research Reports
Language:English
Published: 2006
Subjects:
Online Access:https://ir.uitm.edu.my/id/eprint/49554/1/49554.pdf
https://ir.uitm.edu.my/id/eprint/49554/
Tags: Add Tag
No Tags, Be the first to tag this record!
id my.uitm.ir.49554
record_format eprints
spelling my.uitm.ir.495542021-08-13T01:45:29Z https://ir.uitm.edu.my/id/eprint/49554/ Evaluating the compatibality of MS-Excel spreadsheet as an alternative data source in active server pages environment / Ali Seman Seman, Ali Operating systems (Computers) Database management The use of the database as a data source has been seen as a phenomenal growth on the Internet. The web-to-database integration is often synonymously with web-based applications to be more dynamic and interactive in manipulating the contents. However, there are limitations in the adoption of database as the essential data source. The limitations are due to report productions, which are in the forms of tables and graphs. The tabular report requires data from many tables to be extracted from, where the graph needs a get-ready-component to populate the data through it. Moreover, the implementation of MS-Excel through web heading has its advantages of being online as well as sharing the resources all over the world. Besides that, the user can also manipulate the data locally and do it offline before putting it back to the web in order to be online. This research is to evaluate the compatibility of MS-Excel in manipulating the data through the common roles of the database such as inserting, viewing, updating and deleting the data, as well as to produce reports such as tabular reports, group reports and graphs reports. There were 26 test cases, which have been conducted to evaluate the compatibility of MS-Excel as an alternative data source. The overall results showed that MS-Excel was compatible to be an alternative data source. However, MS-Excel does not provide the data integrity constraint automatically like the database. Thus, it has to be controlled manually in order to utilize MS-Excel as a data source. 2006 Research Reports NonPeerReviewed text en https://ir.uitm.edu.my/id/eprint/49554/1/49554.pdf ID49554 Seman, Ali (2006) Evaluating the compatibality of MS-Excel spreadsheet as an alternative data source in active server pages environment / Ali Seman. [Research Reports] (Unpublished)
institution Universiti Teknologi Mara
building Tun Abdul Razak Library
collection Institutional Repository
continent Asia
country Malaysia
content_provider Universiti Teknologi Mara
content_source UiTM Institutional Repository
url_provider http://ir.uitm.edu.my/
language English
topic Operating systems (Computers)
Database management
spellingShingle Operating systems (Computers)
Database management
Seman, Ali
Evaluating the compatibality of MS-Excel spreadsheet as an alternative data source in active server pages environment / Ali Seman
description The use of the database as a data source has been seen as a phenomenal growth on the Internet. The web-to-database integration is often synonymously with web-based applications to be more dynamic and interactive in manipulating the contents. However, there are limitations in the adoption of database as the essential data source. The limitations are due to report productions, which are in the forms of tables and graphs. The tabular report requires data from many tables to be extracted from, where the graph needs a get-ready-component to populate the data through it. Moreover, the implementation of MS-Excel through web heading has its advantages of being online as well as sharing the resources all over the world. Besides that, the user can also manipulate the data locally and do it offline before putting it back to the web in order to be online. This research is to evaluate the compatibility of MS-Excel in manipulating the data through the common roles of the database such as inserting, viewing, updating and deleting the data, as well as to produce reports such as tabular reports, group reports and graphs reports. There were 26 test cases, which have been conducted to evaluate the compatibility of MS-Excel as an alternative data source. The overall results showed that MS-Excel was compatible to be an alternative data source. However, MS-Excel does not provide the data integrity constraint automatically like the database. Thus, it has to be controlled manually in order to utilize MS-Excel as a data source.
format Research Reports
author Seman, Ali
author_facet Seman, Ali
author_sort Seman, Ali
title Evaluating the compatibality of MS-Excel spreadsheet as an alternative data source in active server pages environment / Ali Seman
title_short Evaluating the compatibality of MS-Excel spreadsheet as an alternative data source in active server pages environment / Ali Seman
title_full Evaluating the compatibality of MS-Excel spreadsheet as an alternative data source in active server pages environment / Ali Seman
title_fullStr Evaluating the compatibality of MS-Excel spreadsheet as an alternative data source in active server pages environment / Ali Seman
title_full_unstemmed Evaluating the compatibality of MS-Excel spreadsheet as an alternative data source in active server pages environment / Ali Seman
title_sort evaluating the compatibality of ms-excel spreadsheet as an alternative data source in active server pages environment / ali seman
publishDate 2006
url https://ir.uitm.edu.my/id/eprint/49554/1/49554.pdf
https://ir.uitm.edu.my/id/eprint/49554/
_version_ 1709671429073534976
score 13.154949