Difference between revisions of "DD Class1"

Revision as of 04:34, 25 January 2007

Into and Data Design

Read Syllabus

DD Syllabus

C# Review

Important c# concepts

• OOP Class2 C# fundamentals
• OOP Class3 Control Structures
• OOP Class4 Classes and Objects
• OOP Class7 Polymorphism fancy arrays

If you feel you need help with c# I strongly suggest getting and reading

Learning C# ,Jesse Liberty O'Reilly & Associates;
(September 2002), ISBN: 0596003765

History of Databases

Flat Files

Hierarchical Databases

http://en.wikipedia.org/wiki/List_of_hierarchical_database_management_systems

Network Databases

Relational Databases

http://en.wikipedia.org/wiki/Relational_database

http://en.wikipedia.org/wiki/Comparison_of_relational_database_management_systems

Object DataBases

http://en.wikipedia.org/wiki/List_of_object-relational_database_management_systems

Microsoft API's

MDAC Microsoft Data Access Components

http://msdn.microsoft.com/data/learning/MDAC/

ODBC

Data access in c. Mature open protocol

OLEDB

Data access in c++. More abstract. Fast

ADO

Built on top of OLEDB to allow access from other Languages

ADO.NET

.NET Data api. Based on XML

ADO.NET 2

Part of ASP.NET 2

70% reduction in code

ASP.NET and ADO.NET Exmaples

XML File full of cheese

http://iam.colum.edu/DD/gbrowser.php?file=/classsource/class1/XMLCheese.xml

The New way. This example uses a flat file as a Data Source

HelloData.aspx Source

The Old way.

HelloDataOld.aspx Source

Homework

• Read Intro and Chapter 1 'Data Modeling Past and Present' in Beginning Database Design (BDD)

• Read Intro and Chapter 1 'Introduction to ASP.NET 2.0 with ADO.NET' in Beginning ASP.NET 2.0 Databases (BAD)

• Install Visual Studio Pro 2005
  • PC Requirements Windows XP sp2 or Vista
  • OS X requirements
    • Microsoft Virtual PC (in the msdnaa library)
    • Windows XP sp2 (in the msdnaa library)