Mar 12, 2012
The article, “Five Tips to Improve Data Quality”, by Joel Curry, talks about the methods of managing data and the benefits of keeping high quality of data. First of all, accurate data is very important to businesses because the data can help businesses analysis and predict a possible outcome in the future. Second, organised data can [...]
Mar 4, 2012
The article, “A Design Technique: Data Integration Modeling”, by Anthony David Giordano, talks about converting logical data integration models to physical data model. The author describes that logical data integration modeling determines the extraction, data quality, transformations, and loads. Meanwhile, the target based data integration design in physical data integration models ensure various components will perform optimally. [...]
Feb 27, 2012
This article, “Data Mart vs Data Warehouse”, by Justin Swanhart, talks about his experience of data mart and data warehouse and then point out the advantage of each tool. First, in his point of view, he mentions that data warehouse is actually a relational database schema that stores data from an operational system. Also, he [...]
Feb 20, 2012
The article, “Writing SQL Statements That Use Joins to Combine Data from Multiple Tables”, is briefly related to our this week class materials which are combining data from multiple tables by using joins. Where clause is used to bring data from more than one table into a set of query. If it does not include [...]
Feb 13, 2012
In the article, “Referential Integrity Tips”, by Burleson, talks about the functionality of referential integrity in Oracle. Referential integrity can be used to make sure that valid data can be enforced with constraints, and relationships in schema are enforced properly. In addition, Burleson mentions that there are several types of constraints which can be used [...]
Feb 6, 2012
The article, “Physical Database Design Consideration”, by Greg Larsen, talks about what data type should be considered while designing a physical database. The author mentions that selecting a correct data type for a column determines the database performance and the cost of changing application code in future. First of all, two character data types, “fixed [...]
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 [...]
Jan 23, 2012
The article, “How to Draw an Architectural Data Model in UML”, by David C. Hay, talks about the differences of UML model and ER model. At the beginning of the article, the author described the development of entity/relationship data model which was formalized in 1970′s. Two decades later, the Unified Modeling Language (UML) was officially [...]
Jan 15, 2012
The article, “Why does Data Modeling Take so Long”, by Jonathan G. Geiger, is an answer to the question asked by one of the attendees at a conference. The author explains that data modeling is used for designing data structures for businesses. Also, he mentions that when we begin building data modeling work, we should [...]
Jan 8, 2012
The article talks about the pros and cons of the various relational database management system products and solutions. It mentions that there are different types of database management systems which are Desktop, Server, Web-enabled, Cloud DBaaS and Open Source. The most economic one is Desktop because it is low cost and suitability for single-users or non-interactive Web application batch processes. Also, [...]
