The tag has no wiki summary.

learn more… | top users | synonyms

53
votes
6answers
3k views

Is this a ridiculous way to structure a DB schema, or am I completely missing something?

I have done a fair bit of work with relational databases, and think I understand the basic concepts of good schema design pretty well. I recently was tasked with taking over a project where the DB was ...
19
votes
1answer
354 views

How should HTML data formats be applied in everyday situations?

Given Google's shift towards a stronger focus on page markup data, how do the data formats used in Schema.org work alongside those for Microformats? How do these (and other specs) compliment each ...
9
votes
8answers
422 views

Refactoring or upgrading databases to handle new features

Several responses to a database schema question, suggested an additional table to normalize a database for a feature that is not part of the current requirements (A UserDepartment table to allow for a ...
8
votes
4answers
2k views

Are database schema migrations a problem in production environments?

In discussions about NoSQL vs SQL databases, I sometimes hear that companies prefer to use schemaless NoSQL databases because it is problematic to migrate the schema to a new version. But is that ...
8
votes
3answers
635 views

How to manage database schema changes in open source project releases

I manage an open source PHP/MySQL web application used by a few K-12 schools and some colleges. I'm also the project's only developer. While it used to be little more than a source download of an ...
6
votes
12answers
2k views

Over normalization in database

Currently I am working on creating a new database schema as part of a major new product. Our previous customer address records (in a previous product) look something like this in our current schema ...
6
votes
6answers
732 views

What's the difference between using RDFS/OWL versus XML?

I was wondering what advantages the ontology languages of RDFS/OWL has over using a tagging/markup system (such as http://www.schema.org/) for managing and creating metadata?
6
votes
1answer
256 views

Is there a well grounded theory on backward and forward compatibility of formats, languages, grammars and vocabularies?

I have a friend who has the specific problem of building a case against the use of a custom HTML <wrapper> tag in some site's markup. Now, intuitively we can answer that use of such a tag is ...
4
votes
3answers
267 views

How would you represent an object that can be of multiple types, when storing it as a document in MongoDB?

Somewhat related to this question, say that I have an object category which, depending on which type of object I have, has different restrictions on what it contains. (if you can reword the previous ...
3
votes
1answer
222 views

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. Just to give a bit of ...
3
votes
1answer
324 views

Are XML Schemas bad for constantly evolving file formats?

I'm struggling with a client-server project where I have Java apps out on the Internet that store data to a backend server. The format of this data is well-defined, but the project is constantly ...
3
votes
2answers
65 views

How to handle unexpected schema changes to production database

Is it a common or normal practice to encounter schema changes, especially renamed or removed columns, in a production database, without having been notified of the change? If unexpected schema ...
3
votes
1answer
203 views

Design considerations on JSON schema for scalars with a consistent attachment property

I'm trying to create a JSON schema for the results of doing statistical analysis based on disparate pieces of data. The current schema I have looks something like this: { // Basic key ...
3
votes
1answer
162 views

Database Schema for Pricing Products (packages, promotions, qty based, limited time offer…)

I'm working on a new point of sale for a company that products for different prices depending on the product mix. All products have a base price. To explain my problem, I will use the following ...
3
votes
1answer
227 views

What are the advantages of having a built-in datatype in a data interchange format over not having it?

Due to the requirement of a project we had to develop a data interchange format with a built in data types. The format served the purpose well in the scope of that project. But I was thinking that ...
2
votes
2answers
154 views

What problems can happen if an XML file is not backed by a schema?

What is a XML schema in plain simple terms? What will be the problem if an XML doesn't have a schema defined? An example can be very helpful.
2
votes
5answers
935 views

Should I use a unit testing framework to validate XML documents?

From http://www.w3.org/XML/Schema: [XML Schemas] provide a means for defining the structure, content and semantics of XML documents. I'm using an XML Schema (XSD) to validate several large XML ...
2
votes
2answers
529 views

What's the best way to modularize a User schema so it's generic

I have a database design question. Basically I want to be able to create a schema for a User model, then use this User model in other models that extend User but I want to design it in such a way that ...
2
votes
3answers
165 views

Tracking correct order details in commerce database when modifying 'products'

I am implementing an ecommerce database. This is slightly different than most as the 'products' that are for sale are for services provided. For example a user (vendor) of the system may define a ...
1
vote
1answer
73 views

Database Schema Data Independence [closed]

I'm currently reading about database schemas about how the three-level ANSI-SPARC architecture works and i'm a bit confused about a concept it's talking about. My question is what would happen if an ...
1
vote
1answer
359 views

Working with Multiple XML Schema Classes in C#

I'm working with a data import process in C#, which takes a zip file filled with XML files and saves specific data points into a database. This is accomplished by loading the XML data into classes ...
1
vote
0answers
160 views

How to choose which schema design for a tree structured domain model

I have the following classes that I want to store. public class StorableObject { public string Id { get; set; } } public class User : StorableObject { public string Name { get; set; } } ...
0
votes
1answer
531 views

Practical mysql schema advice for eCommerce store - Products & Attributes

I am currently planning my first eCommerce application (mySQL & Laravel Framework). I have various products, which all have different attributes. Describing products very simply, Some will have a ...
0
votes
2answers
403 views

Common test cases for XML schema validator

I just wrote my first SAX-based (Java) XML schema validator, where you pass it a schema URL (pointing to the .xsd file), and an XML instance, and it determines whether or not that instance is valid or ...
0
votes
0answers
51 views

JSON schemas vs dynamic typing [on hold]

What are some pros and cons of using JSON schemas versus allowing messages to be completely untyped, or bundling types along with attribute values in the JSON documents themselves? How strong is the ...
0
votes
0answers
57 views

Schemaless NoSQL RESTful design?

In a recent project; I used MongoDB with MongoEngine (an ORM/ODM for Python). This allowed me to specify schema in a central "Model". My new project I am hosting on Windows Azure; and there is no ...
0
votes
0answers
24 views

Using a single table for identity and metadata

I'm in the early design phase of a project to provide an e-commerce platform that will require several entities to be modelled, products, customers, orders, CMS pages, etc. They will all have a few ...
0
votes
0answers
121 views

DRY on API specifcations?

When developing a new RESTful application, I generally: Define tests Define routes [ e.g.: RESTful CRUD; namespaced on /api/users ] Define models [ e.g.: "Users" ] Define forms [ e.g.: in ...
0
votes
0answers
33 views

Naming objects and properties clearly without exposing implementation details

I'm re-architecting an iOS mobile app that consumes an API with somewhat haphazard and oftentimes slow performance. The reason for the slowness is because the API is actually a layer on top of a ...
-2
votes
2answers
137 views

Copyright in a database schema using a licenced windows application [closed]

I work for a company that has bought a licence for a windows client software that allows only 20 running clients per company. I am trying to find a way around this 20 user restriction by programming ...