Is data integrity possible without normalization?
I am working on an application that requires the storage of location information such as city, state, zip code, latitude, and longitude. I would like to ensure:
Is data integrity possible without normalization?
I am working on an application that requires the storage of location information such as city, state, zip code, latitude, and longitude. I would like to ensure:
how to model this relationship ? in ERD
I have three entities :
Set modified date = created date or null on record creation?
I’ve been following the convention of adding created and modified columns to most of my database tables. I also have been leaving the modified column as null on record creation and only setting a value on actual modification.
Designing persistence schema for BigTable on AppEngine
I have tried to design the datastore schema for a very small application. That schema would have been very simple, if not trivial, using a relational database with foreign keys, many-to-many relations, joins, etc.
Which design better when use foreign key instead of a string to store a list of id
I’m building online examination system. I have designed to table, Question and GeneralExam. The table GeneralExam contains info about the exam like name, description, duration,…
Are there examples of non CRUD approaches?
I’m a programmer but also have worked as an archivist. As archivist it’s a lot about keeping data.
What makes Java so suitable for writing NoSQL Databases
Looking at this page that aggregates the current NoSQL landscape, one can see that the majority of these projects are written in Java.
Database Schema Usage
I have a question regarding the appropriate use of SQL Server database schemas and was hoping that some database gurus might be able to offer some guidance around best practice.
NoSQL as file meta database
I am trying to implement a virtual file system structure in front of an object storage (Openstack). For availability reasons we initially chose Cassandra, however while designing file system data model, it looked like a tree structure similar to a relational model. Here is the dilemma for availability and partition tolerance we need NoSQL, but our data model is relational.