Page 164 - DMGT505_MANAGEMENT_INFORMATION_SYSTEM

Unit 8: Databases and Data Warehouses

8.4.4 PHP and Daffodil DB: Together? Notes

Daffodil has come up with a PHP extension module that makes Daffodil DB/One$DB compatible
with PHP. It is a database extension module driver that is required to work with Daffodil DB in
PHP. This extension module uses the capabilities of a Java database and extends it to your web
infrastructure.
By using this extensive module, PHP developers can create sophisticated data-driven web
applications having Daffodil DB as a web database in a fraction of the time and with reduced cost.
PHP extension for Daffodil DB provides a simple, yet effective means for connecting to Daffodil
DB within PHP. JVM is created using JNI invocation interface and everything runs in-process.
This PHP Extension module boosts open source activities around Daffodil DB. Moreover, open
Source stack -Linux, Apache, One$DB, and PHP; all being open source products give an ultimate
combination to web development community.
PHP is platform independent and Daffodil DB is also platform independent. PHP is free and
Daffodil DB is also free (having open source version). So What about using the powers of two
most promising technologies, PHP and Daffodil DB together?
The capabilities of Daffodil DB and PHP can make up what must be the best blend for data-
driven Websites on the globe.
Users can use PHP and the Daffodil DB database to access/store information on the web and
include it into their website. By using PHP as a front-end and Daffodil DB as a back-end web
database, users can benefit from huge savings on the licensing costs of commercial alternatives.

Here are some practical examples where PHP and Daffodil DB used together can do wonders.
Self Assessment

Fill in the blanks:
10. A ................................... stores large amount of information in an organized format that is
easily accessible from scripting languages.
11. ................................... is an open source server-side scripting language that is particularly
suited for web development and can be used to generate dynamic web content.
12. Daffodil DB can run virtually on any platform as it supports all platforms for which a
................................... is available.

8.5 Data Warehousing

Data mining potential can be enhanced if the appropriate data has been collected and stored in
a data warehouse. A data warehouse is a relational database management system (RDBMS)
designed specifically to meet the needs of transaction processing systems. It can be loosely
defined as any centralized data repository which can be queried for business benefits but this
will be more clearly defined later. Data warehousing is a new powerful technique making it
possible to extract archived operational data and overcome inconsistencies between different
legacy data formats. As well as integrating data throughout an enterprise, regardless of location,
format, or communication requirements it is possible to incorporate additional or expert
information. It is,
The logical link between what the managers see in their decision support EIS applications and the company’s
operational activities.
—John McIntyre of SAS Institute Inc.

LOVELY PROFESSIONAL UNIVERSITY 159