Useful Web Links - Chapter 1

needmoreneedmoreΔιαχείριση Δεδομένων

28 Νοε 2012 (πριν από 4 χρόνια και 8 μήνες)

260 εμφανίσεις

Useful Web Links
-

Chapter 1


1.

Wikipedia Database Management Systems


Wikipedia, the free encyclopedia, might be the first place to look if you need to gain insight on an
issue or topic
. The above page is a good start for 'database management systems.'

2.

MySQL


MySQL is the world's most popular open source database, recognized for its speed and reliability.
It was written and is maintained by the Swed
ish company MySQL AB, which sells support and
service contracts as well as commercially licensed copies of MySQL.

3.

A Brief History of Databases


The article provides a brief hist
ory of databases and talks about the rise of the relational
databases.

4.

How Much Information? 2003


The project estimates how much new information is created each year.

5.

Programming languages


Lists computer languages and provides links to internet resources for each of them.

6.

EIC
-

The International Electrotechnical Commission


International Electrote
chnical Commission prepares and publishes international standards for all
electrical, electronic and related technologies.

7.

A Relational Model of Data for Large Shared Data Banks


This is a link to the rev
olutionary paper by 'Edgar T. Codd' that led the foundation for relational
database systems. Larry Ellison built the Oracle database based on ideas presented by Codd in
this paper.

8.

SearchDatabase.com


This sit
e provides latest database news and a bunch of other information related to database
management systems.

9.

PostgreSQL


The PostgreSQL Global Development Group is a community of companies and people co
-
operating to
drive the development of PostgreSQL, claimed to be the world's most advanced
Open Source database software.





Useful Web Links
-

Chapter 2


1.

CODASYL Records


Records of CODASYL group
--

publications related to the work of CODASYL are
included, particularly those relating to COBOL as well as relevant standards
publications.

2.

Dr. Peter Chen


This is the homepage of Peter Chen, the originator of the entity relationship (ER)
model.

3.

The Entity
-
Relationship Model: Toward a Unified View of Data


This link ta
kes you to the landmark paper by Peter Chen ("The Entity
-
Relationship
Model: Toward a Unified View of Data", ACM Transactions on Database Systems 1:1,
March 1976).

4.

Oracle Products Centers


This site provides
a listing of all the latest Oracle products.

5.

SQL.org


This site provides an easy
-
to
-
begin interface and tutorials for beginners. It also
provides web
-
links to internet resources for various SQL products.

6.

Oracle FAQ: SQL


This FAQ provides answer to some common SQL questions.

7.

ANSI Electronic Standards Store


This link brings you to an ANSI electronic standards store.

8.

Database Description with SDM: A Semantic Database Model


This link brings you to the paper by Michael Hammer & Dennis McLeod, "Database
Description with SDM: A Semantic Database Model." (ACM Transactions o
n Database
Systems 6:3)

9.

the Business Rules Group


Originally a project within GUIDE International, the Business Rules Group is now an
independent organization. Our membership is comprised of ex
perienced practitioners
in the field of systems and business analysis methodology. We are practitioners who
work in both the public and the private sectors.

10.

Windows Database

Service: Introduction to Data Modeling


This link brings you to a data modeling tutorial at the University of Texas.



Useful Web Links
-

Chapter 3


1.

FOLDC
-

Computing Dictionary


Free Online

Dictionary of Computing
-

a detailed description of most of the relational database
terms can be found here.

2.

DB2 Product Family
-

Family Overview


DB2 is a family of relational database management

system (RDBMS) products from IBM that
serve a number of different operating system platforms.

3.

Pal's Linux RDBMS Library


This site is a compilation of the best free online readings about relational databa
ses. You'll find
links to valuable resources here, including articles, papers, and books on various aspects of
relational database management. Most of Dr. E. F. Codd's papers are found on this web site.

4.

InformIT
-

Yo
ur Online Guide to Tech Reference


Provides access to a whole new world of articles on databases.

5.

Experts
-
exchange: Databases


Experts
-
exchange is one of the most powerful IT resource channels. I
t provides access to instant
solutions for your most demanding IT problems (over 5K searchable solutions).

6.

Comparison of Oracle and Microsoft Access SQL


This site offers a comparison of Oracle
and Microsoft Access SQL.

7.

Optimizing Queries Across Diverse Data Sources


Click this link to access an article on optimizing queries across diverse data sources.


Useful Web Links
-

Chapter 4


1.

IDEF1x Overview


This site provides a detailed overview of IDEF1X, another data modeling standard. The site also
allows you to download the full standard report of IDEF1X and others methods.

2.

National Institute of Standards and Technology


NIST, a non
-
regulatory federal agency within the U.S. Commerce Department's Technology
Administration, develops and promotes measurement, standards, and technology to enhance
p
roductivity, facilitate trade, and improve the quality of life. NIST released IDEF1X as a standard
for data modeling.

3.

Visio 2003 Product Information


This site is a logical place
to start for those new to Microsoft Visio Professional. It provides an
overview of the product, new features, and various video tours.

4.

Charles W. Bachman Papers


This link directs you to

a list of all the papers published by C. W. Bachman, the developer of the
Crow's Foot Model
. (Bibliographical information is also provided.)

5.

CASE tool index


This URL provides links

to hundreds of CASE tools used by software engineers and database
designers. The site also provides a long list of vendors and a contact description for each.

6.

CASE Tool Information


This site pro
vides links to various CASE tools used for object
-
oriented design and analysis, and
for educational use. A short description of each tool is also provided.

7.

Software Design Center


This site hosts data modeling tutorials by SmartDraw, makers of the popular drawing program.

Useful Web Links
-

Chapter 5


1.

Database Normalization Basics


A normalization expl
anation by Microsoft is available at this site.

2.

SQL by Design: Why You Need Database Normalization


This site offers a good explanation of why you need normalization to help prod
uce good database
designs.

3.

SearchDatabase.techtarget.com


A collection of normalization links is available at searchdatabase.techtarget.com.

4.

SQL Server database coding conventions


This site provides naming conventions for SQL Server along with a long list of best practices with
database programming (esp. SQL Server security best practices).

5.

Access Solutions


This web site lists Leszynski/Reddick's Guidelines for Access, the most commonly used naming
convention for Access objects.

6.

Microsoft Consulting Services Naming Conventions for Visual Basic


Naming conventions are often a matter of personal preference. This webpage provides naming
conventions for Visual Basic from Microsoft Consulting Serv
ices.

7.

Overview of Normalization


This site provides an overview of normalization up to fifth normal form. The puppy example
follows the overview from the first normal form to the fifth no
rmal form.

8.

Dr. Edgar Frank Codd


A bibliography of Edgar F. Codd is included on this page. The site also links to Codd's twelve
OLAP rules and his lectures and published papers.

9.

Are SQL Server, DB2, and Oracle really relational?


This site hosts the article "Are SQL Server, DB2, and Oracle really relational?" by
Handelshögskolan . In this article, Codd's twe
lve rules are used as a benchmark to check if the
three systems are relational in nature. The author also provides recommendations on
improvements that would move the systems closer to the requirements.

10.

Microsoft SQL Sever 7.0 Help Guide


The entire help guide of Microsoft SQL Sever 7.0 is made available online and in downloadable
format. The guide helps users to migrate from MS
-
Access or Oracle to SQL Server.

Useful Web Links
-

Chapter
6


1.

SQL standard


Download the latest ANSI documents on SQL standards. The site also provides links to various
SQL readings and tutorials.

2.

XML
-
Related Specifications


XSQL is the combination of XML (Extensible Markup Language) and SQL (Structured Query
Language) to provide a language and database independent means for storing SQL queries,
clauses and query results. This ANSI d
ocument defines ways in which Database Language SQL
can be used in conjunction with XML.

3.

ASCII
-

References


This site lists the ASCII codes and their corresponding decimal, octal and hex values. In addit
ion,
other related links are provided for students who want to know more about ASCII codes.

4.

NeedSQL
-

Free SQL Database System written in PHP


This site hosts a free SQL
-
based database system written in

PHP created to help PHP
programmers who want their programs to use flat file system to store data and at the same time
manipulate that data using Structured Query Language.

5.

Microsoft Jet SQL


This URL hosts the Microsoft Jet SQL Quick Reference. Jet SQL is a version of SQL created by
Microsoft and the database engine behind Microsoft's Access. This reference provides a
comprehensive listing of all the functions, stateme
nts, clauses, operations and declarations.

6.

Fundamental Microsoft Jet SQL for Access 2000


Fundamental Microsoft Jet SQL for Access 2000 is the first article in a series of
articles made
available by Microsoft. Links to intermediate and advanced articles on the same topic are
provided at the Web page.

7.

SQLCourse

SQL Tutorial


These
sites are two great online introductory SQL tutorials.

8.

A Gentle Introduction to SQL


This is a web site with information about SQL commands and functions.

Useful Web Links
-

Chapter 7


1.

SQL Reference


IBM DB2 SQL Reference is a downloadable book that can be used by programmers, database
administrators, and general users. It is primarily a reference manual to be used for information

on
relational database concepts, language elements, and functions.

2.

SQL Quiz


This URL provides an online hands
-
on SQL quiz to see how much knowledge you have gained
and where you can improve. Note
: The quiz is not official and is intended to be used only for your
personal practice.

3.

SQL Server 2000 vs. Oracle 9i


In this article, a comparison is made between SQL Serv
er 2000 with Oracle 9i Database
regarding price, performance, platforms supported, SQL dialects and products limits.

4.

DevGuru SQL Syntax Introduction


Transact
-
SQL

(TSQL) Syntax Charts display syntaxes of various TSQL statements. TSQL is
supported by Microsoft SQL server and Sybase. Also, follow the link to learn some skills beyond
the basics of SQL.

5.

Comparison of Oracle and Microsoft Access SQL


This site shows the difference between Oracle SQL and the SQL generated by Microsoft Access
when using the QBE interface. It is useful to know how Access SQL differs from the more
standa
rd SQL of Oracle.

6.

SQL FAQ


This site provides a well
-
documented FAQ about SQL. The FAQ explains the differences in
various versions of SQL standards and provides variou
s tips on query optimization.


Useful Web Links
-

Chapter 8


1.

System Analysis and Design

This link brings you to
System Analysis and Design

by Tran Thi Phien. The entire book is onlin
e
and describes in detail the System Design Life Cycle (SDLC) and various tools used during the
process.

2.

Popkin Software: System Architect


System Architect manufactured by Popkin Softwar
e is a modeling application designed to provide
tools necessary for development of enterprise systems. It is a close rival of Microsoft Visio
Professional.

3.

Just Enough Structured Analysis


This site hous
es the book
Just Enough Structured Analysis

by Edward Yourdon. The entire book
is online and describes in detail the modeling tools, analysis process and the follow
-
up issues.

4.

Dotnet
Coders
-

Guide to UML Diagrams


UML is a modeling language for specifying, visualizing, constructing, and documenting the
artifacts of a system
-
intensive process. This site discusses various types of structured and
behavioral diagrams.

5.

Database Design: The Semantic Modeling Approach


Database Design: The Semantic Modeling Approach by Naphtali D. Rishe
-

The entire book is
online and looks at the database designing process from a semantic

point of view. Author
discusses various data models including hierarchical, network and object
-
oriented data models.

6.

Database Design: The Logical ERD


The article f
ocuses on database designing and forming a logical ERD. It further extends to
explain how adjustments can be made to a model and how one can move to physical modeling
step
-
by
-
step.



Useful Web Links
-

Chapter 9


1.

Concurrency Control and Recovery in Database Systems


Concurrency Control and Recovery in Database Systems

by Philip A. Bernstein, Vassos
Hadzilacos, and Nathan Goodman is made available in its entirety online.

2.

Concurrency Control


This site describes the behavior of the PostgreSQL database system when two or more sessions
try to access the same data at the same time. Application of concurrency control in PostgreSQL
is discussed in detail.

3.

Advanced SQL Server Locking


SQL Server has a number of lock types and different granularities on these locks. The article
provides an applied viewpoint to th
e locking mechanisms as they are used in SQL server.

4.

Concurrency in Object
-
Oriented Programming Languages


Concurrency in Object
-
Oriented Programming Languages

by Michael Papathomas sy
nthesizes
the research done in concurrency control and discusses how it is integrated with programming
languages.

5.

DB2 Help


The IBM DB2 Universal Database Help Guide
provides help on DB2 and describes how the
locking and recovery mechanisms work.

6.

DBAsupport.com


The article presents a basic introduction to transaction processing in PL/SQL and

primarily
focuses on the Autonomous transaction processing feature of PL/SQL. Also, the changes made
in oracle 9i are discussed.

7.

Optimistic Locking with Concurrency in Oracle


The article presents
two ways of locking in Oracle: Pessimistic and Optimistic. The author
presents different problems with pessimistic locking and discusses how optimistic locking can be
gained via concurrency.

Useful Web Links
-

Chapter 10


1.

A Survey Report for High
-
Speed Network Impact on DDBMS

A Survey Report for High
-
Speed Network Impact on DDBMS

by Ning Zhang is an introduction to
high
-
speed networks and lightweight (low overhead) protocols. Al
so, this article provides an
analysis on how we can incorporate application level protocols to DDBMS.

2.

Using Specification
-
Driven Concepts for Distributed Data Management

and Dissemination


Using Specification
-
Driven Concepts for Distributed Data Management and Dissemination

by M.
Brian Blake presents an architectural design to implement a DDBMS using XML, Java Servlets,
XSL and RDBMS.

3.

Data Replication


The article discusses proven architectural approaches that one can follow to create nearly
-
identical copies of the data and to manage the integrity of the copies if they can be u
pdated at
both the source and target within a replication interval.

4.

Group of Parallel and Distributed Processing


The GPPD (Group of Parallel and Distributed Processing) is a research group which has several
p
rojects concerning parallel and distributed processing. Research areas include cluster
computing, image processing, multi
-
agent systems, object
-
oriented distributed languages.

5.

SETI@home


SETI@home is a
scientific experiment that uses distributed processing via Internet
-
connected
computers in the Search for Extraterrestrial Intelligence (SETI). Many such projects have
emerged lately, harnessing the processing power of millions of idle computers over the I
nternet.

6.

Distributed Database Concepts


This site discusses the Oracle's distributed database architecture and how heterogeneous
distributed databases can be built. Also ou
tlined are the processes of developing and
administering an Oracle distributed database system.

Useful Web Links
-

Chapter 11


1.

Object
-
oriented database articles and pr
oducts


This site houses facts on object
-
oriented database architecture, product comparison, and
selection. The articles section provides an extensive overview of object database technology and
its use with object
-
oriented programming languages.

2.

object
-
oriented
-

internet resources


This site provides links to archives of papers on real
-
time object
-
oriented systems. The links lead
to various research projects currently in progress.

3.

The Journal of Object
-
Oriented Programming


The Journal of Object
-
Oriented Programming was founded in 1987, and continued to publish
through the fall of 2001. Here, you can get a sampling of some of the key documents from th
e
history of object
-
oriented programming.

4.

The Third Manifesto


The Web site centers on the concepts pioneered by two database gurus: C. J. Date and Hugh
Darwen. Pascal describes this site as "a site focuse
d on database education
--

as distinct from
product
-
specific training
--

and should be, therefore, useful, regardless of which DBMS software
is used."

5.

Mapping obje
cts to relational databases


Mapping Objects to Relational Databases

by Scott W. Ambler presents the basics of mapping
objects to relational databases, and introduces the steps that lead to successful and easy storage
of objects in relational databases.

6.

InterSystems Cache
-

Cache Technology
-

White Papers


This site discusses the major approaches to resolving the impedance mismatch between OO
languages and RDBMSs. The
author examines various approaches with the help of examples
and figures.

7.

Object Management Group


The Object Management Group (OMG) was formed to create a component
-
based software
marketplace by accelerating the introdu
ction of standardized object software.

8.

Back to the Relational Future


Back to the Relational Future

by C. J. Date is described by the author as 'The Third Manifesto.' A
short synopsis on printed book

is also made available.

Useful Web Links
-

Chapter 12


1.

Inmon Associates, Inc.


This is the Web site of Bill Inmon, the father of data warehousing. The site provides free access
to articles, white
papers, and newsletters authored by Bill Inmon.

2.

Ralph Kimball Associates and Kimball University


This site provides free access to articles, white papers and other publications authored by Ralph
Kimball.

3.

The Data Warehousing Information Center


This site is a collection of one practitioner's essays on data warehousing, decision support, and
business intelligence.

4.

Mondrian components


Mondrian is an open source OLAP server written in Java. It enables you to interactively analyze
very large datasets stored in SQL databases without writing SQL.

5.

Data Mining Group


The Data Mining Group (DMG) is an independent, vendor led group which develops data mining
standards, such as the Predictive Model Markup Language (PMML).

6.

OLAPinfo


A non
-
commercial platform for OLAP
-
interested pe
ople and an information center for OLAP and
Data
-
Warehouse, this site provides a very good collection of links to whitepapers, projects and
newsgroups related to OLAP and Data Warehouse.

7.

The OLAP Report


This web
site provides information about OLAP vendors, products and applications.

8.

CC DW RR
-

German OLAP and Data Warehouse Forum


This site contains links to white papers, (research) organizations, companies and

product related
to Data Warehousing, On
-
Line Analytical Processing (OLAP), and Data Mining. The site presents
information in both English and German.

Useful Web Links
-

Chapter 13


1.

World Wide Web Consortium


The World Wi
de Web Consortium (W3C) develops interoperable technologies (specifications,
guidelines, software, and tools) for the Web.

2.

XML.org


Introduced in June 1999 by OASIS, this is the site for the non
-
profit Organization for t
he
Advancement of Structured Information Systems.

3.

Center for Research in Electronic Commerce


The Center for Research in Electronic Commerce web site provides links to various resources
and centers around the wo
rld that specialize in electronic commerce. It also provides access to
working papers, research reports etc.

4.

E
-
Commerce Times


The E
-
Commerce Times provides daily original editorial content, with full coverag
e of e
-
business
and technology news and information.

5.

IBM Software: Payment Processing


This site describes how the Secure Electronic Transactions (SET) works
. The author covers
secure electronic transaction essentials: authentication, interaction among the components, and
certificates.

6.

IBM Payment Suite: Cryptography and
SET


This site describes and compares the Secure Socket Layer (SSL) protocol and the Secure
Electronic Transaction (SET) protocol. The author covers secure electronic transaction
essentials: authentication, hierarchies of trust, and encryption.

7.

Advisory Commission on Electronic Commerce


The Advisory Commission on Electronic Commerce was created by Congress and tasked with
producing recommendations on electronic commerce and tax policy.

8.

E
-
Business Research Center


This is a link to the e
-
business research center at
cio.com
. Articles listed at this portal are more
applied and targeted towards the needs of CIOs (Chief Information Officers) and other
informati
on executives.

9.

UMBC Institute for Global Electronic Commerce


The Institute for Global Electronic Commerce, drawing upon expertise and input from the
corporate and university communities, is designed to promote the

electronic transmission of
commercial transactions through the connection of companies and universities and through the
creation of new entities.

Useful Web Links
-

Chapter 14


1.

The CGI Resource Index


This si
te provides links to documentation, books, programs and other CGI resources.

2.

Application Programming Interface


This site offers a brief overview of the Application Programming Interface (AP
I) technology. It also
provides references on the complementary technologies.

3.

Open Database Connectivity Without Compromise


Open Database Connectivity (ODBC) without Compromise

by Ki
ngsley Idehen presents the
theory behind ODBC and its real world application. Some common mistakes have been pointed
out (a good place to start for beginners!).

4.

Macromedia ColdFusion MX 6.1


T
his is the home of ColdFusion. On this site, you can download the trial version of the product. It
also provides access to all the related documentation and product support.

5.

MSDN Library: Dynamic
-
Link Libraries


This site houses an overview of Dynamic Link Libraries (DLLs) that provides information on how
to create and use dynamic libraries. Dynamic
-
Link Library Reference lists all the elements used in
dynamic l
inking.

6.

The Source for Java Technology


This site is the source for java technology. As per sun Microsystems, "Java technology is a
portfolio of products that are based on the power of networks and the idea

that the same software
should run on many different kinds of systems and devices."

7.

SYS
-
CON Media

The Cold Fusion Journal is an online resource dedicated to Cold Fusion application development
and other l
eading web technologies such as Java, XML, .NET, Web Sphere, Web Logic, Linux.

Useful Web Links
-

Chapter 15


1.

Oracle Certified Professional Program


The Oracle9i Database Admini
strator Certified Professional (OCP) credential is granted by Oracle
and is the premier certification for professionals who administer Oracle9i and other DBMSs.

2.

Microsoft Certified Dat
abase Administrator


Microsoft Certified Database Administrator (MCDBA) credential is the certification for
professionals who implement and administer databases, especially SQL server.

3.

IBM

Certified Database Administrator


IBM also provides its own certification for DB2 Universal Database. The certification is known as
IBM Certified Database Administrator
-

DB2 UDB V8.1 for Linux, UNIX and Windows.

4.

Database Administration Made Easy with Oracle9i


Database Administration Made Easy with Oracle9i

discusses in detail how one could administer
the databases via the enterprise manager. The white

paper discusses various important functions
like memory management, space management, transaction management, etc.

5.

How Not to be a DBA
-

The Top 20 Mistakes


This site houses How Not to be a DBA
-

The Top 20 Mistakes

by Rachel Carmichael: Before
starting something, it's always a good idea to know what not to do. This paper discusses twenty
common mistakes that any new database administrator should avoid.

6.

Performance Tuning Guidelines for the Beginner Oracle DBA


Performance Tuning Guidelines for the Beginner Oracle DBA

by S. Georgson is an excellent
paper for beginners who are just learning Oracle. The paper discusses various aspects o
f
database administration.