Microsoft Azure Sql Database Analysis

893 WordsJan 10, 20164 Pages
My two advance topics in which I am interested are: • Microsoft Azure SQL Database: Microsoft Azure SQL Database is a cloud database service of Microsoft’s. I have worked with MSSQL Database during my job. Now I want to learn advance technology which is Sql Azure. In SQL Azure you have to use SQL Server authentication instead of Integrated Security. When you work with SQL Azure you don 't need to spend any time on security patches, disk space, moving databases between different servers to handle increased load, etc. • Real time database system: Real-time database is a database which provides the real time information because the real-time database uses real-time processing to handle workloads whose state is constantly changing. In real-time database system data objects stored in the database and transactions accessing this data have to be scheduled in accordance with real-time performance objectives. 2) a. Database Design: Database means stored a large collection of information and database design means development of a quality data model. Database design is the process of transforming a logical data model into an actual physical database. Database design is always connected with application design. Types of database design are: • Logical design: Logical design includes attributes for each entity, business entities and relationships among entities. • Physical design: physical design is the last phase of database design. Physical design include tables, indexes, default and
Open Document