Nov 27, 2011
Summary: With cloud computing taking over the industry, the amount of efficiency and reliability with organizations has increased. Salseforce.com has released a stand-alone product built in the cloud that gives developers access to the cloud platform of their choice. This ultimately gives more flexibility to the developers when they are developing a database application either [...]
Nov 20, 2011
Summary: Large organizations use various types of data in their daily operations and in doing so they utilize a number to databases to store their data. The structure that facilitates this process flow of information is referred to as n-tier architecture. The reason this structure has an nth capability is because multiple databases can be [...]
Nov 13, 2011
Summary: When implementing a database, there are a number of factors to be considered. Each factor has its own pro’s and con’s which ultimately determine what style of database will be chosen. One of the main factors involved when discussing databases is data storage, efficiency and file compression. This was a feature that Microsoft felt [...]
Nov 7, 2011
Summary: As the year comes to a close, old products are being pushed off the line and the new updated material will usher in a new era of computing, and by that I mean this will bring about new features which make the user experience much more usable. In this case I am referring to [...]
Oct 30, 2011
Summary: A crucial part of physical data modeling relies on good design of both the logical architecture as well as the physical construct. Data types are used to act as constraints for the data being used in the database. The business rules will determine the data type as per the requirements. To adjust for the [...]
Oct 23, 2011
Summary: When developing a logical data model there are certain constraints that must be held between strong and weak entities. One of the constraints between the entities is called a referential integrity constraint. Below is an example that author Lockwood Lyon gives is the referential integrity constraint between both strong and weak entities: The CUSTOMER [...]
Oct 16, 2011
Summary: When solving a design issue with the business rules, Entity relationship diagrams are used to consolidate given objects in the business process. The author discusses the concepts of the deeper level of taxonomy in database design, otherwise known as an Enhanced Entity Relationship diagram. The weaker entities are known as a subtype which is [...]
Oct 9, 2011
Summary When a business is looking to increase the ROI, new investments are made and new technologies are used. In the case of businesses that are online, data is increasing at an ever expanding rate and the ability to scale with the demand is slowly being met. Data Warehouses and Data Marts are being used [...]
Oct 2, 2011
Summary: When implementing a database, one must have the proper tools to design the structure in accordance with best practices. To do so, CASE tools must be used as a guide for developers to properly implement the database. Currently, there are a number of CASE tools in the marketplace, but the ones mentioned in the [...]
Oct 2, 2011
Summary: As Netflix slowly takes over the online video market, there needs to be some type in-house redesign in their back-end infrastructure to accommodate for this demand. The company intends to do so by implementing a NoSQL style of architecture for a number of reasons. Yury Izrailevsky, Netflix’s Director of Cloud and Systems Infrastructure, stated [...]
