Module 23: Technology & Strategies

.aac:

a file format that is similar to mp3 but integrates digital rights support following Apple standards;

.wma:

a file format that is similar to mp3 but integrates digital rights support following Microsoft standards.

What are rows and columns called in a relational database?

rows = tuples columns = attributes tuples in a table share the same attributes

What are the advantages to using an SQL approach?

security protects against data loss and corruption

How is .png different from .jpg?

similar to .jpg, but includes the notion of transparency;

What is the role of an interpreter for script languages?

the interpreter reads the source text from top to bottom and generates and runs the binary code piece by piece.

Explain the usage of .jpg/ .jpeg.

uses a standard compression format to reduce image storage size w/ some quality loss - Popular and compliant (web-ready) - no transparency support

.mov:

video compression file format following Apple standards;

.wmv

video compression file format following Microsoft standards.

For images what 3 standard formats are best viewed in most browsers?

- .jpg or jpeg: - .png - .gif

What useful functions of programing languages does JavaScript provide?

- variable manipulation (Boolean, integers, floats, and characters); - basic data structure (strings, arrays); - iteration commands (for, while); - modularity (function); - decision commands (if, switch).

What are the three functions of the DBMS?

1. Creates the structural that data will adhere to. Making data organized and consistent 2. DBMS provides help to load the data into the framework 3. Provides additional support such as tacking users and providing log in information

What is frequently used to interact with with a DBMS in a web context?

A Structured Query Language (SQL)

What is a compiler?

A compiler is a special program that acts as a translator between the two files.

What is the definition of a scripting language?

A programming language that executes standard programing commands within the end user device.

What is a relational database?

A relational database is a set of tables that have predefined relationships between them.

What is ACID and what does it do?

Atomicity means that each transaction (a sequence of one or more SQL operations) is treated as a unit. Consistency means that only valid data that follows all rules can be written in the database. Isolation means that unfinished transactions remain isolated. Durability means that the data is saved by the system even if the transaction fails.

What is the second step in the process for setting up a DBMS ?

Code into the HTML/CSS/JS web page calls for the side-server PHP language that will dialogue with (i.e., issue commands to) the MySQL DBMS running on the server

What is the third step in the process for setting up a DBMS ?

Code into the HTML/CSS/JS web page commands to handle the returns from the MySQL DBMS.

What are scripting languages ideally suited for due to them simplifying the processing of text?

Dynamic generation of HTML pages

What is the first step in the process for setting up a DBMS ?

Install the MySQL DBMS on the server machine

What language is most commonly used as a client-side scripting language in web development?

JavaScript

What is MySQL?

MySQL is an open-source, relational DBMS that provides a Structured Query Language access to a database widely used in many applications, including website servers.

What is the common approach to provide database connectivity to websites?

MySQL relational DBMS and PHP interface

What makes NoSQL databases scalability cheaper and easier then SQL databases?

NoSQL databases can be run across several servers

How does a DBMS retrieve data?

Query Creates one or more indexes

How do script languages differ from other programming languages?

Software can be written directly using scripting languages, with less source text.

What is a compilation?

The process of converting source text to binary code

What may happen if you prevent your browser to run JavaScript?

The website will not render

How is NoSQL different from SQL?

They can store and process unstructured data (data from social media, photos, MP3 files, etc.), offering developers more flexibility and greater scalability.

PHP, Perl, Ruby, Python, and JavaScript are used on _______________ to implement dynamic websites and web applications.

Web server

.mp3

a very efficiently compressed file format that equates to 10% of an uncompressed file;

.mp4 or .mpeg4:

an extension of .jpeg (motion .jpeg) intended to compress sequenced images;

.avi

audio video interleave; provides different compression levels according to the individual standards used for audio and video;