Introduction to Database Systems - Hofstra University

Introduction To Database Systems Hofstra University-ppt Download

  • Date:09 Aug 2020
  • Views:22
  • Downloads:0
  • Size:2.36 MB

Share Presentation : Introduction To Database Systems Hofstra University

Download and Preview : Introduction To Database Systems Hofstra University

Report CopyRight/DMCA Form For : Introduction To Database Systems Hofstra University


Transcription:

Database ManagementInstructor Vinnie Costavcosta optonline netC056 Z1 Database Management Systems Vinnie Costa Hofstra University It s All In The Presentation .
After a summer long delay EastmanKodak Co has just begun shipping thegroundbreaking digital camera that within range of hotels coffee shops airport lounges offices homes and.
other wireless hot spots can deliverhigh quality pictures directly onto theInternet and into e mail boxes aroundthe globe Users of the new EasyShare One .
priced at 599 can send photosdirectly through a Wi Fi transmitter athome or work or pay 4 99 per monthto connect the camera with any of T Mobile USA s 6 000 hot spots at stores .
airports hotels and otherestablishments C056 Z1 Database Management Systems Vinnie Costa Hofstra University Internet ApplicationsC056 Z1 Database Management Systems Vinnie Costa Hofstra University.
The First Compiler and Bug Grace Murray Hopper December 9 1906 January 1 1992 was an early computer pioneer She was the firstprogrammer for the Mark I Calculator and the developer ofthe first compiler for a computer programming language .
Hopper was born Grace Brewster Murray She graduatedPhi Beta Kappa from Vassar College with a bachelor sdegree in mathematics and physics in 1928 and 1934became the first woman to receive a Ph D in mathematics She was well known for her lively and irreverent speaking.
style as well as a rich treasury of early war stories Whileshe was working on a Mark II computer at HarvardUniversity her associates discovered a moth stuck in arelay and thereby impeding operation whereupon sheremarked that they were debugging the system Though.
the term computer bug cannot be definitively attributed toAdmiral Hopper she did bring the term into popularity Theremains of the moth can be found in the group s log book atthe Naval Surface Warfare Center in Dahlgren VAhttp ei cs vt edu history Hopp... .
C056 Z1 Database Management Systems Vinnie Costa Hofstra University Lecture Overview Setup WAMP Environment Using FORMS With PHP Connecting To MySQL With PHP.
Some Handy Tools Getting Data From MySQL With PHP Other Things We Can Do From TutorialC056 Z1 Database Management Systems Vinnie Costa Hofstra University Install Apache.
http httpd apache org docs 2 0... windows html Installing apache is easy if you download theMicrosoft Installer msi package Just doubleclick on the icon to run the installation wizard .
Click next until you see the Server Informationwindow You can enter localhost for both theNetwork Domain and Server Name As for theadministrator s email address you can enteranything you want .
If using Windows XP installed Apache asService so every time I start Windows Apacheis automatically started C056 Z1 Database Management Systems Vinnie Costa Hofstra University Installing Apache.
Click the Next button and choose Typical installation Click Next onemore time and choose where you want to install Apache I installed itin the default location C Program Files Apache Group Click the Nextbutton and then the Install button to complete the installation process C056 Z1 Database Management Systems Vinnie Costa Hofstra University.
Installing Apache To see if you Apache installation was successfulopen up you browser and type http localhost orhttp 127 0 0 1 in the address bar You should seesomething like this .
C056 Z1 Database Management Systems Vinnie Costa Hofstra University Installing Apache By default Apache s document root is set to htdocs directory The document root is where you must put all your PHP or HTMLfiles so it will be process by Apache and can be seen through a.
web browser Of course you can change it to point to anydirectory you want The configuration file for Apache is stored inC Program Files Apache Group Apache2 conf httpd conf assuming you installed Apache in C Program Files ApacheGroup It s just a plain text file so you can use Notepad to edit.
For example if you want to put all your PHP or HTML files in C www just find this line in the httpd conf DocumentRoot C Program Files Apache Group Apache2 htdocs and change it to DocumentRoot C www .
After making changes to the configuration file you have to restartApache Start Programs Apache HTTP Server 2 0 ControlApache Server Restart to see the effect C056 Z1 Database Management Systems Vinnie Costa Hofstra University Installing Apache.
Another configuration you may want to change is thedirectory index This is the file that Apache will show whenyou request a directory As an example if you typehttp www php mysql tutorial co... without specifyingany file the index php file will be automatically shown .
Suppose you want apache to use index html index php ormain php as the directory index you can modify theDirectoryIndex value like this DirectoryIndex index html index php main php Now whenever you request a directory such as.
http localhost Apache will try to find the index htmlfile or if it s not found Apache will use index php In caseindex php is also not found then main php will be used C056 Z1 Database Management Systems Vinnie Costa Hofstra University 1 Installing Nvu.
www nvu com A complete Web Authoring System for LinuxDesktop users as well as Microsoft Windowsand Macintosh users to rival programs likeFrontPage and Dreamweaver .
Nvu pronounced N view for a new view makes managing a web site a snap Nowanyone can create web pages and managea website with no technical expertise orknowledge of HTML .
C056 Z1 Database Management Systems Vinnie Costa Hofstra University 1 Make A Home Page Create an index html page with Nvu Copy C Program Files ApacheGroup Apache2 htdocs to old htdocs.
Put the index html into htdocs Test with http localhost or http Explore Cascading Style Sheets CSS C056 Z1 Database Management Systems Vinnie Costa Hofstra University 1 www php net.
PHP is a popular open source reflectiveprogramming language used mainly for developingserver side applications and dynamic web content Itwas originally developed in 1994 and PHP stood for Personal Home Page In 2000 the Zend Engine was.
added and now the official meaning is the recursiveacronym PHP Hypertext Preprocessor PHP is currently one of the most popular server sidescripting systems on the Web It has been widelyadopted since the release of version 4 On the.
desktop it has been favored by some newprogrammers as a rapid prototyping environment C056 Z1 Database Management Systems Vinnie Costa Hofstra University 1 Installing PHP www php net downloads php v4.
We want to install PHP 4 4 0 and use the ZIP package Extract the PHP package PHP 4 4 0 zip package Extract the package in the directory where Apache wasinstalled C Program Files Apache Group Apache2 Change the newly created directory name to php just.
to make it shorter Then copy the file php ini dist in PHP directory to youwindows directory C Windows or C Winnt dependson where you installed Windows and rename the file tophp ini This is the PHP configuration file and we ll take.
a look what s in it later on Next move the php4ts dll file from the newly createdphp directory into the sapi subdirectory C056 Z1 Database Management Systems Vinnie Costa Hofstra University 1 Installing PHP.
Apache doesn t know that you just installed PHP Weneed to tell Apache about PHP and where to find it Open the Apache configuration file in C ProgramFiles Apache Group Apache2 conf httpd conf andadd the following three lines .
LoadModule php4 module php sapi php4apache2 dllAddType application x httpd php phpAddType application x httpd php source phps The first line tells Apache where to load the dll requiredto execute PHP and the second line means that every.
file that ends with php should be processed as a PHPfile The third line is added so that you can view yourphp file source code in the browser window Now restart Apache for the changes to take effect Start Programs Apache HTTP Server 2 0 50 .
Control Apache Server Restart C056 Z1 Database Management Systems Vinnie Costa Hofstra University 1 Installing PHP Now we want to test PHP to verify our installation Create anew file using Nvu name it hello php and put it in.
document root directory C Program Files ApacheGroup Apache2 htdocs The content of this file should be echo Hello World Note Nvu will do the php encapsulation for you Type http localhost hello php on your browser s.
address bar and if everything works well you should see thetraditional Hello World display in your browser Another common test is to create a new file namedtest php and put it in document root directory The contentof this file is .
phpinfo C056 Z1 Database Management Systems Vinnie Costa Hofstra University 1 Installing PHP phpinfo is the infamous PHP function which willspit out all kinds of stuff about PHP and your server.
configuration Type http localhost test phpon your browser s address bar and if everythingworks well you should see something like this C056 Z1 Database Management Systems Vinnie Costa Hofstra University 1 www mysql com.
dev mysql com doc MySQL Reference Manual MySQL is a multithreaded multi user SQL Structured QueryLanguage Database Management System DBMS with an estimated sixmillion installations MySQL is open source software available eitherunder the GNU General Public License GPL or under other licenses.
when the GPL is inapplicable to the intended use 1 Unlike projects such as Apache where the software is developed by apublic community and is essentially not owned by anyone MySQL isowned and sponsored by a single for profit firm the Swedish companyMySQL AB The company develops and maintains the system selling.
support and service contracts as well as commercially licensed copiesof MySQL and employing people all over the world who work togethervia the Internet Two Swedes and a Finn founded MySQL AB DavidAxmark Allan Larsson and Michael Monty Widenius 2 1 en wikipedia org wiki MySQL.
2 WikiPedia is based on MySQL There are more than 200 million queries and 1 2 millionupdates per day with peak loads of 11 000 queries per secondC056 Z1 Database Management Systems Vinnie Costa Hofstra University 1 Installing MySQL http dev mysql com downloads .
We want MySQL database server standard clients MySQL 4 1 Generally Available GA release recommended This should bring us to this page http dev mysql com downloads m... .
Scroll down to this section This is what EssentialsC056 Z1 Database Management Systems Vinnie Costa Hofstra University 1 Installing MySQL.
We will be downloading mysql essential 4 1 14 Fill in the form if you want and go to the closest USmirror The download will take a few minutes Whenfinished you should have the msi file on your desktop Double Click the newly downloaded msi file.
Accept the typical installation You ll be prompted to create a MySQL account recommended monthly newsletter save this info When the install finishes you ll get a configurationoption window Be sure it is checked .
C056 Z1 Database Management Systems Vinnie Costa Hofstra University 2 Installing MySQL We will be downloading mysql essential 4 1 14 Fill in the form if you want and go to the closest USmirror The download will take a few minutes When.
finished you should have the msi file on your desktop Double Click the newly downloaded msi file Accept the typical installation You ll be prompted to create a MySQL account recommended monthly newsletter save this info.
When the install finishes you ll get a configurationoption window Be sure it is checked C056 Z1 Database Management Systems Vinnie Costa Hofstra University 2 Installing MySQLC056 Z1 Database Management Systems Vinnie Costa Hofstra University 2.
Installing MySQLC056 Z1 Database Management Systems Vinnie Costa Hofstra University 2 Installing MySQLC056 Z1 Database Management Systems Vinnie Costa Hofstra University 2 Installing MySQL.
C056 Z1 Database Management Systems Vinnie Costa Hofstra University 2 Installing MySQLC056 Z1 Database Management Systems Vinnie Costa Hofstra University 2Another common test is to create a new file named test.php and put it in document root directory The content of this file is: <?php phpinfo(); ?> Installing PHP phpinfo() is the infamous PHP function which will spit out all kinds of stuff about PHP and your server configuration.

Related Presentations

Topic 3 Agriculture and Food Hofstra University

Topic 3 – Agriculture and Food. A – Food Models. B – Food Production and Trade. ... McKay uses a pig lifespan of 400 days, and thus notes that if you want to eat a pound of pork every day, 400 lb of pig must be alive at any given time (one pound for each day, so that the rate of pig production matches the rate of consumption ...

18 Views0 Downloads

Hofstra Law Home Page Maurice A Deane School of Law

black’s law dictionary. old chief. prosecution wanted to introduce def’s entire record of previous criminal conviction. defendant said no it would be too prejudicial . these are 2 opposing views. question for the court.

9 Views0 Downloads

Educate 08 Hofstra University

For newspapers, TV, or the Internet, you should do a comparison the same day. For magazines, the same week. Be sure to examine at least 4 sources in the same medium. Present your findings to the class. Display a variety of election data on an interactive bulletin board, inviting students to respond with other data that supports or refutes claims.

6 Views0 Downloads

Network Security Hofstra University

A firewall is inserted between the premises network and the Internet Establishes a perimeter Provides a choke point where security and audits can be imposed Single computer system or a set of systems can perform the firewall function Good Fences Make Good Neighbors – Robert Frost, “Mending Wall” Design Goals All traffic, from inside to ...

6 Views0 Downloads

sites hofstra edu

A - Definitions. Types of Resources. The Renewable / Non-Renewable Dichotomy. Energy. Resources, Technology and Society. What are the major types of resources and what do they imp

5 Views0 Downloads

Suzanne Dagger Hofstra University

Skills and Getting the Job. First Time Planners . Get foot in the door with resumes, interviews, and networking. They MUST demonstrate focus, knowledge, and skills in order to beat out experienced candidates

8 Views0 Downloads

Network Security cs hofstra edu

Network Security Conventional Encryption Caesar Cipher Basic Types of Ciphers Transposition ciphers – rearrange bits or characters in the data Substitution ciphers – replace bits, characters, or blocks of characters with substitutes “Rail-Fence” Cipher Encryption Methods The essential technology underlying virtually all automated network and computer security applications is ...

1 Views0 Downloads

Database Models Flat Files and the Relational Database

Database Models: Flat Files and the Relational Database Objectives: Understand the fundamental structure of the relational database model Learn the circumstances under which it is a better choice than the flat file

27 Views0 Downloads

Database Security with focus on Hyperion Database

Hyperion application security determines user access to products using the concept of roles. A role is a set of permissions that determines user access to product functions. User directories store information about the users who can access Hyperion products. Both the Authentication and the authorization processes utilize user information.

23 Views0 Downloads

Introduction to Database Systems

Database design: logical design---select suitable data model physical design---select suitable indexing d. Access management design: how to serve large-scale users? e. Efficiency concern: how to manage large-scale data set? Ramakrishnan & Gehrke Summary DBMS used to maintain, query large datasets.

29 Views0 Downloads

CS186 Introduction to Database Systems

Title: CS186: Introduction to Database Systems Last modified by: Joe Hellerstein Document presentation format: On-screen Show Other titles: Arial Times New Roman Tahoma Times Book Antiqua Osaka Bradley Hand ITC TT-Bold Lucida Sans Unicode Symbol Monotype Sorts lecture1.key CS186: Introduction to Database Systems Queries for Today What: Database Systems Then What: Database Systems Today What ...

21 Views0 Downloads

Introduction to Database Systems EPFL

Introduction to Information Systems SSC, Semester 6 Lecture 01 Staff Instructors: Karl Aberer, BC 108, karl aberer at epfl ch Philippe Cudré-Mauroux, BC 114, philippe cudre-mauroux at epfl ch Office hours: by appointment TAs: Gleb Skobeltsyn (exercises) Martin Rubli (project) Communications Web page: lsirww.epfl.ch Lectures will be available here Homeworks and solutions will be posted here ...

35 Views0 Downloads