schema

An erlang database schema generator

Is there a way I can generate a database schema from an erlang application like I can do with hibernate. ...

Regression testing for schema (xsd) equivalence

Hi all, I am thinking about rewriting a schema with lots of standalone complex types in it, into one where the complex types extend other base types more sensibly. The rationale for this is partly conceptual - because most of these types are specific instances of a domain object with a definite hierarchical structure - and partly pract...

What is the MySQL equivalent of a PostgreSQL 'schema'?

I have a PostgreSQL database whose tables are divided amongst a number of schemas. Each schema has a different set of access controls; for example, one schema might be read-only to regular users, while they are allowed to create tables on another. Schemas also act as namespaces, so users don't have to worry about duplicating existing t...

Table structure: some "columns" to be saved as a single text-type field with json structure, alternative: separate table but concerned with performance

Here the deal: I've got a table Billing, which is basically a receipt (for different types of transaction). The app has a feature that you can create new charges (well, all charges except for tax and other constants). Since there would be a dynamic number of charges, we decided to store the charges for a billing on a single text field wi...

XML Schema - only one element should have attribute set to true

How can i define an boolean attribute that can be set "true" only in one element. Following snippet must be invalid. <products> <product featured="yes">Prod 1</product> <product featured="yes">Prod 2</product> </products> ...

Should I break a larger mysql table into multiple?

I have a pretty large social network type site I have working on for about 2 years (high traffic and 100's of files) I have been experimenting for the last couple years with tweaking things for max performance for the traffic and I have learned a lot. Now I have a huge task, I am planning to completely re-code my social network so I am...

Composite foreign keys

This comes up a lot for me. In SQL Server 2008, I have 3 tables. 2 with unique keys and 1 which is a mapping between them. Example: People Events Schedule ------ ------ -------- PersonId EventId ScheduleId Name Place PersonId EventId Rsvp ScheduleId isn't needed if I make a com...

Sharepoint: Modify the page template of views

Hi I have a sharepoint list with several views. I can modify the view pages (such as AllItems.aspx) via the sharepoint designer. However I would prefer to modify the underlying template instead. Now I could directly modify the default view page template located in templates\pages\viewpage.aspx but this would affect the whole sharepoint...

My rails migrations won't run, and I can't deploy my rails app. How can I start over?

At some point in my rails development I started making database changes (e.g. dropping or altering columns/tables) without using rails migrations. So now I get errors when I try to deploy my rails app from scratch. blaine@blaine-laptop ~/tmp/rbjacolyte $ rake db:migrate (in /home/blaine/tmp/rbjacolyte) == AddHashToTrack: migrating ====...

Is it necessary to design relational tables differently if they might reside in several databases?

I'm in the process of designing the database schema for an application that in the future could involve spreading some tables over several databases due to the number of entries a single user might make. I'm currently designing table relationships keeping common best practices in mind, but I'm not thinking about server architecture, tabl...

What are the resources or tools used to manage temporal data in key-value stores?

I'm considering using MongoDB or CouchDB on a project that needs to maintain historical records. But I'm not sure how difficult it will be to store historical data in these databases. For example, in his book "Developing Time-Oriented Database Applications in SQL," Richard Snodgrass points out tools for retrieving the state of data as ...

XSD key/keyref beginner question

I'm trying to implement a very simple XML schema constraint. The idref attribute on elements of type <batz> should only be allowed to have a value that matches the id attribute on at least one element <bar>. If that doesn't make any sense to you then please just look at the example XML-document below, I think it actually ex...

Database Design Inquiry

I'm making a trivia webapp that will feature both standalone questions, and 5+ question quizzes. I'm looking for suggestions for designing this model. Should a quiz and its questions be stored in separate tables/objects, with a key to tie them together, or am I better off creating the quiz as a standalone entity, with lists stored for ...

Drop role in SQL Server database?

I am trying to drop one of the role in my SQL Server database. I dropped all the members from the role and when i tried to drop role i got this error message: Msg 15138, Level 16, State 1, Line 13 The database principal owns a schema in the database, and cannot be dropped. Does anyone know why? I checked the Owned Schema and it only h...

Validating only part of XML document using schema?

Hi all, Is it possible to write a schema allowing mixing validated XML with just well-formed XML? Case in point is a data transfer application where requests consist of a bunch of meta-data (which we'd like to validate) and record-specific information (which is validated separately from the XML in the business logic, because the XML req...

How to store multiple items in database. Confused with database structure

I had a select box where the user will select the list of cities they travelled. After that the admin will search for the users with particular cities. I am very confused with the structure of the database. There are totally 300 cities. Creating column for each city and store it with boolean on or off, looks a childish technique. Any o...

Visualize Rails schema.rb with tool/plugin/script

I am looking for a tiny tool/script/plugin to visualize my Rails schema.rb file so that our project does not have to maintain a separate diagram manually. Do you have any experiences on that subject? ...

is there a common example SQL schema that shows all the major cardinalities?

I'm writing up documentation for a tool that works with SQL schemas. It would make sense for the documentation to use a common example schema rather than making up a new one. Any recommendations for one that's already defined somewhere? Ideally it would come from a problem domain most readers are already familiar with; have an examp...

What version numbering scheme to use?

I'm looking for a version numbering scheme that expresses the extent of change, especially compatiblity. Apache APR, for example, use the well known version numbering scheme <major>.<minor>.<patch> example: 4.5.11 Maven suggests a similar but more detailed schema: <major>.<minor>.<patch>-<qualifier>-<build number> example: 4.5.11...

retrieve FoxPro 7.0 database schema

I need to obtain a list of tables in a Visual Fox Pro database. (7.0) This is what I'm doing.... but it's not working or I'm not doing it right... DataFactory dataFactory = new DataFactory(); dataFactory.CreateOldStarbaseConnection(); dataFactory.OpenOldStarbaseConnection(); OleDbConnection oldStarbaseConnection = dataFactory.OldStarb...