DD Class1

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/

OLEDB

Data access in c++. More abstract. Fast

ODBC

Data access in c. Mature open protocol

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

LINQ

language-integrated query. Native data access library extend c# and vb.net to provide naticve access to sql. http://msdn.microsoft.com/en-us/netframework/aa904594.aspx

Data Servers

Client/Server Model

Older model with dedicated clients

OLTP

OnLine Transaction Processing

ADO.NET used the Data Provider and Data Consumer model.

ASP.NET and ADO.NET Examples

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. If also has ZERO code.

HelloData.aspx Source

The Old way.

The old model usually involved

• Connection
• DataAdapter or DataReader
• Command
• DataSet
• DataTable
• Bindable Controls

HelloDataOld.aspx Source

In class

Make HelloData.aspx and HelloDataOld.aspx

Homework

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

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

Install Client tool for MSSQL 2005

if you have trouble becuase on an exsisting MSDE or MSSQLExpress install try the SKUUPGRADE=1  argument
<cd-drive letter>:\servers\setup.exe SKUUPGRADE=1

http://msdn.microsoft.com/en-us/library/ms403393(SQL.90).aspx

• Modify the http://iam.colum.edu/DD/gbrowser.php?file=/classsource/class1/XMLCheese.xml and the HelloData.aspx page to show some of your own data