Explore BrainMass
Share

Explore BrainMass

    PHP and MySQL Benefits of relational databases

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    What are the benefits of using relational databases in the development of interactive web applications? What is redundant data and why should it be avoided in a relational database?

    © BrainMass Inc. brainmass.com October 9, 2019, 11:32 pm ad1c9bdddf
    https://brainmass.com/computer-science/memory-management/php-mysql-benefits-of-relational-databases-259778

    Solution Preview

    PHP and MySQL Benefits of relational databases
    What are the benefits of using relational databases in the development of interactive web applications? What is redundant data and why should it be avoided in a relational database?

    SQL allows users to access data in relational database management systems, such as Oracle, Sybase, Informix, Microsoft SQL Server, Access, and others, by allowing users to describe the data the user wishes to see. SQL also allows users to define the data in a database, and manipulate that data. The SQL used is "ANSI", or standard SQL.

    SQL is designed for a specific, limited purpose — querying data contained in a relational database. As such, it is a set-based, declarative computer language rather than an imperative language such as C or BASIC which, being programming languages, are designed to solve a much broader set of problems. Language extensions such as PL/SQL are designed to address this by turning SQL into a full-fledged programming language while maintaining the advantages of SQL. Another approach is to allow programming language code to be embedded in and interact with the database. For example, Oracle and others include Java in the database, while PostgreSQL allows functions to be written in a wide variety of languages, including Perl, Tcl, and C.
    sQL has keywords is the Data Definition Language (DDL). ...

    Solution Summary

    This solution helps explain the benefits of using relational databases in the development of interactive web applications. It discusses redundant data and why it should be avoided in relational database.

    $2.19