DAT601 | Jesse Drummond | 2018

FINAL CLASS For this final class todd is discussing the requirements for our milestone 3 once again, in further details, he has suggested that sections of our SQL code is written into procedures. Procedures for Creating, Inserting and then procedures for each transaction required. When referring to our SQL code within our document it is fine to refer to our SQL text file instead of writing them out in the document. Within our SQL file I need to remember to separate my procedures with comments and clearly label each one. Next we are going into Server permissions, users and logins. What's the difference between them? GRANT Grants are used to give permissions to specific operations concerning chosen element/s of the database, grants are given to specific users of the databases procedures and functions. For our assignments we are creating users, todd suggested our users be given permission to view a 'view' of the database which pertains to the information they req...

Today's lesson pertained to an explanation of the Milestone three steps to get everyone on the same page before Todd started into a talk about database file structures and the different structures they may take. The following discussion resulted in a lot of in-depth information regarding storage sizes that is ideally relevant to the estimation of database storage size task we have to complete within milestone 3. The rest of the class has been assigned to milestone 3 work.

Today's lesson pertains to more information regarding physical database design. An index is used to speed up the performance of queries. It does this by reducing the number of database data pages that have to be visited/scanned. In SQL Server, a clustered index determines the physical order of data in a table. There can be only one clustered index per table (the clustered index IS the table). Today we have been advised to bring headphones in order to use a lynda.com tutorial as part of our learning today. Before this Todd has shown us a video explaining the concept of b-trees which is the system that indexes use to map references to data rows within a database, indexes can be clustered or non-clustered layout. Non-Clustered Indexes A non-clustered index doesn’t sort the physical data inside the table. In fact, a non-clustered index is stored at one place and table data is stored in another place. This is similar to a textbook where the book content is located in one pla...

Today's lesson began with an introduction talk about the transactional analysis we will be doing for our Milestone 3 report, Todd emphasized that we can do this in crows foot notation unlike the example showed us which was in crows foot notation instead. Todd explained that we are interested in bytes, not bits. Understanding transactions are our primary topic, throughout understanding transactions we need to understand the expected frequency of a particular transaction, the relation sand attributes access and the types of access, time constraints imposed on the transaction such as within 1s. If a transaction fails no changes should be made to the db. Transaction maps are interesting and used to show the path our transactions take through our database. A tabular form of this transactional analysis can be made using the same data shown on the transaction map as well as some additional details to show the transaction in an in-depth sense. One of ...