CIS4365: Database Applications
Fall, 2017

Database Administration References

Site: http://www2.fms.indiana.edu/users/cshelton/oracle/server.815/a67784/ds_ch2.htm
bulletThis is an article that Oracle has published highlighting some issues of concern for a DBA when administering their database systems
Site: http://searchdatabase.techtarget.com/sDefinition/0,,sid13_gci214169,00.html
bulletThe site most of the information a beginner needs.
Site: http://www.canberra.edu.au/~sam/whp/datadict.html
bulletA very informative website.
Site: http://databases.about.com/cs/administration/
bulletOn this page you can find many different articles, reviews and downloads regarding, database administration and databbase management systems
Site: http://www.martinfowler.com/articles/evodb.html
bulletThis web page gives you a background on database design. It gives a good basic explanation on the concepts of database design.
Site: http://www.jmu.edu/computing/dba/dbprocs.shtml
bulletThis site has a wealth of information on database administration that can be browsed on their documentation pages. They state that anything you find you can use and are welcome to it, as long as you are sure to give James Madison University the credit for it.
Site: http://www.mysql.com/doc/en/MySQL_Database_Administration.html
bulletThis is a useful website. It has a variety of information that is helpful in learning how to administer a database. There is information on command line options, running multiple SQL servers, security guidelines and access control, user account management, disaster prevention and recovery, executing queries from a binary log, and a lot more helpful information.
Site: http://www.yourwindow.to/security-policies/ref030502.htm
bulletThis web page addresses database security issues in a very neat way. It is simple but entertaining at the same time. I certaintly enjoyed this site. The information given is short and straight to the point.
Site:  http://www.niehs.nih.gov/ctb/dbta/oracledb.htm 
bulletGoo site this gives you the functions of database Administration
Site: http://mysql.progen.com.tr/index.html
bulletThis website is a great source for SQL and database administration. It also has current and up to date articles in the world of database administration.
Site: http://www.sswug.org/
bulletIt contains a lot of info related to database administration as well as tips.
Site: www.dbafavorites.com/
bulletThis site provides access to the tools used by Database Administrators. It has several categories like Backup & Recovery software, Data Analyzing tools, Database Administration tools, DBMS software, Developer tools, Import/Export tools, Performance, Tuning and Monitoring tools, Reporting tools, Security tools, SQL tools, Web related software, and Miscellaneous software. I would think that this site may be helpful to DBA’s.

 

Site: http://www.microsoft.com/sql/evaluation/features/simple.asp
bulletDatabases must be tuned in order to achieve optimal end-user performance. Since there is no single correct way to tune a database that satisfies all end users, databases generally are tuned to match the specific usage patterns of the data. The biggest challenge facing database administrators (DBAs) in this area is that the usage patterns of the data change frequently as new tools and new users access the data in different ways. This website offers a variety of links from an introduction of database administration to more advance features of this topic.
Site: http://www.tc.umn.edu/~hause011/
bulletThis site has information about db administrator tools and software articles. It explains well various topics related to db administration and the problem faced. It describes many codes that will help db administrator in managing databases.
Site: http://searchdatabase.techtarget.com/bestWebLinks/0,289521,sid13_tax281662,00.html
bulletI think its a good site because you can just go to the information that you want. They even pose questions which get you thinking about the database administration. The site it self does not have a lot of information but it guides to where you can get what you are looking for. Overall its a plain site but it is effective and I thought it was nice. It was simple I can look for what I want instead of a lot of information all at once which I may not want.
Site: http://www.inf.fu-berlin.de/lehre/SS03/datenbanken/unterlagen/dbs03-23-TAConCtrl-2-6.pdf
bulletThis is a nice presentation about the concurrency controls in transaction management. Provides further details about the concurrency controls.
Site: http://databases.about.com/cs/administration/
bulletmuch worth looking into
bulletThis webpage contains many links to interesting sites that contain information related to database administration, including articles, manuals, as well as more commercial sites.
Site: http://searchdatabase.techtarget.com/bestWebLinks/0,289521,sid13_tax281570,00.html
bulletThis site has lot's of cool articles about different database administration tasks
Site: http://otn.oracle.com/products/manageability/database/index.html
bulletThis is a good paper if you are looking for Oracle database administration. It covers database installation Tuning the database, and Backup & Recovery.
Site: http://philip.greenspun.com/panda/databases-choosing
bulletThis is a good page that gives you an overall picture of what database administration is. It runs thru the whole process of developing a database.
Site: http://www.crtinc.com/dba/database_admin.html
bulletThis website describes the challenge and obstacles of DBA. It also provides some information related to remote database administration.
Site:  http://www.tc.umn.edu/~hause011/article/Export_MS_Access.html
bulletEasy to read instructions to export MS Access data to other databases with minimal user intervention
Site: http://www.developer.com/db/print.php/718491
bulletI found this article very clear about what a DBA should be, and it has good tips about each of the main topics for DBAs. Its focused on MS SQL Server, but still a good article.
Site: http://www.oracle.com/oramag/oracle/99-Mar/index.html?29rec.html
bulletThis website provides information on how to manage the elements you'll need for a database recovery and how to practice database recovery before a real disaster hits.
Site: http://www.datamodel.org/DataModelDictionary.html
bulletA complete dictionary of database terms and how they work.
Site: http://www.sleepycat.com/docs/ref/transapp/atomicity.html
bulletWhile this site has a limited scope, it fully explaines the aspect of data atomicity and why it is important.
Site: http://www.orsweb.com/downloads/sql/database_administration/
bulletAs the title implies, this site has lots of helpful resources for Oracle DBA work. The scripts are probably particularly useful. A nice web reference for Oracle database administration.
Site: http://www.dbazine.com/yen3.html
bulletThis article provides information on how to use Oracle 9i's new fine grain auditing to monitor who is accessing data.
bulletThis website gives very good examples to explain what a DBA is and what they do. One part is titles "A Day in the Life of a DBA" so this website is informative and easy reading.
Site: http://tahiti.oracle.com/
bulletthis site provides a complete information about the oracle database, in particular information related to Database Administration
Site: http://www.exforsys.com/career-center/career-tracks/career-track-database-administrator.html
bulletAn article dealing with the responsibilities of Database Administrators. It covers needed education, on the job responsibilities and current salary standards.
Site: http://www.connexions-direct.com/jobs4u/index.cfm?pid=45&catalogueContentID=109
bulletIf a student wishes to pursue a career in database administration, this is a website to look at. It gives what is expected of a DBA, and what a typical DBA career life is like.
Site: http://www.orafaq.com/faqdba.htm
bulletIncludes the general questions about database administration , which will be helpful in clarifying some basic doubts about database administration
Site: http://databases.about.com/od/administration/Database_Administration.htm
bulletThis site provides a number of links which gives information about database administration.
Site: http://www.primedatabasemanagement.com/databaseadministratortasks.html
bulletThese are some of the responsibilities and duties of a Database administrator
bulletThis page answers "What is database administration ?"
Site: http://www.blurtit.com/q696748.html
bulletThis page innumerates the duties of a Database Administrator
Site: http://www.firebirdsql.org/manual/migration-mssql-db-admin.html
bulletshowing the difference of how it is used here and explanation
bulletThis web site give basic differences in database administration as in SQL and Firebird.
Site: http://oracle.ittoolbox.com/topics/t.asp?t=381&p=381&h1=381
bulletthere were many references given with brief data
Site: http://en.wikipedia.org/wiki/Database_administration_and_automation
bulletVery informative reference on database administration and management.
Site: http://www.bls.gov/oco/ocos042.htm
bulletGood page that states characteristics among Computer Scientists and Database Administrators.
Site: http://www.siue.edu/~dbock/cmis450/databaseadministration.htm
bulletits give basics concepts and explains with examples