Click to learn more about author Michael Blaha. A symmetric relationship is a self-relationship with the same multiplicity and role name on each end. Symmetric relationships are acceptable for conceptual models. But they are problematic for logical and physical models – you should rework the model to eliminate them. An Example For an example, consider […]
Grading Database Quality, Part 1: Database Designs
While working on database projects, we often find ourselves doing reverse engineering. Reverse engineering is the inverse to normal development. Developers start with an application and work backwards to understand the software and infer its intent. Reverse engineering can apply to a variety of artifacts, such as hardware, programming code, and databases. Our focus here […]
3 Key Advantages of NoSQL Databases
by Angela Guess Christopher Tozzi recently wrote in The VAR Guy, “[R]elational databases are great if you know ahead of time what structure your data will take, and have a sense of how much data you need to store. But what if your storage needs are less predictable? What if they need to be highly […]
NoSQL vs. SQL: It’s About the Performance and Scale
Learn more about Dale Kim. If you’re an application developer with years of experience in relational database management systems (RDBMS) and SQL, you might still use those trusted technologies for most of your application needs. But you might be hearing a lot about NoSQL databases, and how they can be a better fit for your […]
Why ‘Relational Databases Don’t Handle Big Data Well’
Chris Preimesberger recently opined for eWeek, “Enterprises are confronting the reality of big, fast, varied and changing data. It’s no longer about managing a small number of systems, but rather hundreds of systems and petabytes of data. Smart companies know that managing large volumes of structured and unstructured data, known as big data, is crucial […]