ITSS 4300 Lecture Notes - Lecture 3: Microsoft Sql Server, Ibm Db2, Oracle Corporation

• School: UT-Dallas
• Department: Information Technology and Systems
• Course: ITSS 4300
• Professor: Dogan

Document Summary

Integrated store data about the relationships between the rows of data. Self-describing database is called self-describing because it stores a description of itself. Metadata self-describing data is called metadata, which is data about data. Remembers where the location of the students and define where they are: exm. Stored procedures: set of sql statements that are written that will ran again and again and again. Trigger: statements that are triggered when done something to do something, exm. Cancel the transaction, so the data saved is deleted (trigger) Server) database: queries are not physical. Users need a copy of access to see data. But not everyone needs a copy of oracle to get oracle database. Users applications running over corporate network, e-commerce applications on web. Server, web portal with reporting applications, xml web services applications sql . From existing data: analyze spreadsheets and other data tables, extract data from other databases, design using normalization principles.