Feb 6, 2012
My article was on the differences of logical database modeling versus physical database modeling. It begins by briefly describing the two before jumping into full detail of each individually. For logical modeling it’s mostly what we have learned in class already. It’s gathering the requirements, entities, relationships and conveying them into a model. The deliverables [...]
By Kevin Quihuiz Category: Database Design and Development (CIS 305) Tags: logical database, physical database
Feb 6, 2012
The article I read talks about the procedure that can successfully convert a logical data model into a physical data model, particularly in a warehouse setting. The article describes some of the necessary steps that can help convert the data successfully. The article talks about the rules that are necessary to follow when creating logical [...]
By Jamal Akbar Category: Database Design and Development (CIS 305) Tags: converting, Data, Data Model, Database, Important steps, logical database, physical database
Feb 4, 2012
In database analysis and design, there are three major steps that are followed: conceptual design, logical design, and physical design. The author of the article explains that there is a need to extend and include a fourth step: implementation design. This step would come in after the logical design and before the physical design. The [...]
By Penny Poon Category: Database Design and Development (CIS 305) Tags: Conceptual database model, Database, implementation, logical database, physical database
Jan 28, 2012
The article, “Relational Database Normalization Process”, talks about normalization standing an important role in the relational database because it ensures data are logically stored, eliminates duplicated data, and increases the speed of processing data, so that database system can be accurate and efficient. When a database is normalized, the article suggests users to start from the [...]
By Polun Lee Category: Database Design and Development (CIS 305) Tags: logical database, normalization, relational databases
Jan 27, 2012
The authors of this article discussed how physical database design is under-studied because database administrators have to maintain databases on a daily basis. The idea is to design databases that could adjust themselves to the characteristics of applications, such as indexing definitions or automatically gathering information from SQL workloads. The authors explain that self-tuning logical [...]
By Penny Poon Category: Database Design and Development (CIS 305) Tags: Database Design, logical database, null values, redundant data, SQL
Oct 30, 2011
Summary: The article talks about the advances of database design and modeling and how it is a necessary skill. Then it goes on to question whether different data models have different rates of accuracy and whether the data model can have all the design information for a database. The author states that there are limits [...]
By Alexander Vu Category: Database Design and Development (CIS 305) Tags: Database, Database Design, Design, logical, logical database, physical, physical database, reference data, referential data