Database Administration ( 1 Oct. 2012 )



Data dictionary made up from
·         sys
·         basetables
·         views


there are more than 3600 database views
Sir choosed about 30 views to teach us
following 3 were discussed today

·         system resources views
·         system performance monitory views
·         security related views
more detail and commands are in slides provided by sir in hard form









.

Comments

Post a Comment

Popular posts from this blog

Code for Database Connection confirmation PHP+HTML

<html> <head> <title> web page 2</title> </head> <body> <?php error_reporting(0); $con=mysql_connect("localhost","root",""); if($con){     mysql_select_db('one',$con); echo "connection successfully"; } else{     echo "connection fail"; } $id=$_REQUEST['id']; $name=$_REQUEST['name']; $email=$_REQUEST['email']; $password=$_REQUEST['password']; $query="INSERT INTO `db1`.`one` (`id`, `name`, `email`, `password`) VALUES (NULL, '$name', '$email', '$password'); "; $r = mysql_query($query); if($r) {echo "inserted";} else {echo "error";} ?> </body> </html>
Read more

Database connect with php

<?php error_reporting(0); include("db.php"); if($_REQUEST['id'] != ""){ $id = $_REQUEST['id'] ; $del = "delete  from one where id = $id"; $dd = mysql_query($del);     } $q = "select * from one;"; $res = mysql_query($q); ?> <html> <head> <title>3rd page</title> </head> <body> <table border="2" cellpadding="2" cellspacing="2"> <tr> <td>ID</td> <td>Name</td> <td>Email</td> <td>Password</td> <td>Delete</td> <td>Edit</td> </tr> <?php while($row = mysql_fetch_array($res)){ ?> <tr> <td><?php echo $row['id']; ?></td> <td><?php echo $row['name']; ?></td> <td><?php echo $row['email']; ?></td> <td><?php echo $row['password']; ?></td> <td><button onClick=...
Read more

New Slides

Notes of Network Security                             Data Encryption Standard   Click here for for further detail on DES   Assignment of Re search method........ Performance of Windows XP, Windows Vista and Apple's Leopard Computers under a Denial of Service Attack  IT PM slides ...... 6) 4- M ar _ Estimate Cost determine Budget 7) 25-mar-2013 _ Quality management 8) 9-Aprl-2013_Procurement Management     The assignments from lecture slides are following 1) Requirement traceability matrix. 2) WBS 3) WBS Dictionary 4)   Gantt Chart 5) Network Diagram 6) Milestone Chart 7) RACI CHART 8) Organizational Break Down structure   9) Issue Log   Click h ere for Rest of the templates  Please discuss in case of any ambiguity.  
Read more