datamodel

Converting xml schema to relational model

Do you guys know, how we can convert XML Schema to relational model? What are the steps involved? More precisely, How can we figure out what the table names, columns names and the relationships on those tables, going to be like on relational model by looking only at the XML Schema? If you have any tutorial links, examples then please sh...

Choosing data access methods in ASP.NET MVC

As I am a beginner to ASP.NET MVC, I would like to know what are the best data access methods for ASP.NET MVC? ...

REST API / DATA MODEL DESIGN - User , Account or Both Models?

Hi there, I'm having some thoughts about proper building my app and provide a good and consistent API for it but now I'm having some doubts about the user/accounts model. It's funny but if you consider some apps you will see that they treat you like user but when editing your details your are redirect to account. One good example of th...

Call Method on Every Ancestor in Python

I have an object of class 'D' in python, and I want to sequentially execute the 'run' method as defined by 'D' and each of it's ancestors ('A', 'B' and 'C'). I'm able to accomplish this like this class A(object): def run_all(self): # I prefer to execute in revere MRO order for cls in reversed(self.__class__.__mro__)...

Help setting up a data model in Core Data

Hi, I am new to Core Data, and have been trying to figure out how to set up my data model. I made a sample table to try and show how I need the data to relate. First Name Last Name Competitor Number Gender Team Competition Game Name All Time high Competition Scores Jon Doe 1 M Gamers January Don...

historical data modelling literature, methods and techniques

Howdy, Last year we launched http://tweetMp.org.au - a site dedicated to Australian politics and twitter. Late last year our politician schema needed to be adjusted because some politicians retired and new politicians came in. Changing our db required manual (SQL) change, so I was considering implementing a CMS for our admins to make...

Data model for a small CMS system

I have always wanted to make a small easy to use CMS system just for personal use and training. First thing im going to do is create the data model. So what do I need to get started? I would like to dynamically create pages, then I need a Page table. I know many CMS systems reffer to them as nodes, so I'll call it Nodes. I would also ...

Shared object between multiple JInternalFrames

What's the most efficient method of implementing a shared data object between multiple JInternalFrames on a single JDesktopPane? Not sure whether to go with singleton or can I put a data object in the JDesktopPane and access from a component? I don't want to keep separate instances of this data for each frame (lots of frames) ...

If a data model changes (an object) whats the best approach to also update the database ?

Let's say theres a Teacher object and that Teachers holds a list of Courses objects. The courses for the Teacher can change. Some get added, some get deleted. What's the best approach to update this changes in the database. 1. Right after every change, update the database. e.g.: A course get added, immediately add that into the database ...

Datamodel for a MVC learning project

Hi, I am trying to learn Microsoft MVC 2, and have in that case found a small project I wanted to deploy it on. My idea was to simulate a restaurant where you can order a table. Basics: A user can only reserve a full table, so I don't have the trouble of merging people on different tables. A person can order a table for a certain ...

Webbased data modelling and management tool

Is there a web-based tool available, where I am able to... ...define data models (like in a database admin tool) ...fill in data (in custom web forms, not too generic) with basic features like completion ...import data from CSV oder Excel Sheets ...export data to CSV or SQL ...create snapshots of my data models (versions, diff, etc.) ...

iPhone: Using a NSMutableArry in the AppDelegate as a Global Variable

What i'm trying to accomplish is to have an NSMutableArray defined in the AppDelegate. I then have two UIViewControllers. One view is responsible for displaying the array from the AppDelegate. The other view is used to add items to the array. So the array starts out to be empty. View1 doesn't display anything because the array is empty. ...

ASP.NET MVC2 - Does Html.EditorForModel() work on the nested data model?

My test shows it doesn't work. It ignores the nested data in model. Can anyone confirm this? ...

Is there any good guide for using the Cassandra Command line Interface?

I wanted to try out Cassandra, and thought the easiest way to get up and running would be via the command line. I was wondering if there is a good guide to using the cli tool that is shipped with Cassandra. I am primarily looking for options to create column families, super columns, insert sample data and query them. The documentation on...

free, recommendable Tools for data modeling?

Hello, are there free, recommendable Tools for data modeling? ERM/ORM Diagrams Creating database models (SQL SERVER 2005) As Simple to use as Visio(no license here) Code generation is only a nice to have (VB.Net) ...

What is the correct way to define application-level cascade for many-to-many relationships, using Doctrine/YAML?

Hi, I have this model definition: #/config/doctrine/schema.yml NewsArticle: options: (...) columns: (...) relations: Images: class: Image local: article_id foreign: image_id refClass: ImageToNewsArticle Image: options: (...) columns: (...) relations: NewsArticles: clas...

Problems with CoreDataBooks Example from Apple

Hi I am currently playing with CoreData and have a problem with the CoreDataBooks Example from Apple. Basically I just wanted to extend the data model. I updated the model class aswell and no compiler error, butr a crash when I want to start the example. Unresolved error Error Domain=NSCocoaErrorDomain Code=134130 UserInfo=0x1316ce0 "...

Advanced DataModel in Xcode with CoreData

Hi I have a question regarding a rather advanced DataModel which I would like to use with CoreData. Before I get into details about what I did so far, I will describe what I want to do. I have a List of Hotel Guests that stay in one Room and have Preferences. Once ready the user should select a guest and see the data and should also b...

Datamodel diagram

what are the relationships we specify in datamodel diagram? And also i have one doubt I have three tables Table A (emp Id(pk) ,name) Table B (empId(pkfk),depno(pk),department) Table C -( contain department list in office) In Table B creation I referred Fk as empid.so that i drawn relationship between Table A and TableB.But in Table...

ORM tool OR build the object to relational mapping layer manually

I am trying to determine what if any advantage or disadvantage there is to using an object to relational mapping layer like hibernate or the Microsoft Entity framework when building the data layer. Is using sql and mapping objects by hand better in the long run or is it better to leverage one of these mapping technologies? It seems ...