473,561 Members | 3,751 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

database design help

Hello,

I am trying to design a system for people to submit a series of documents to a
project. I want users to have the ability to submit updates to any documents, so
that there should be a history (or sequence) for each document. I think in terms of
python data structures, so the relational database organization is not all that clear
to me (so I am trying to learn it!). I am using buzhug, but the concept should be
the same in any rdb.

So my conceptual structure would look something like:

project1:
document 1, document 1a, document 1b
document 2
document 3, document 3a

project 2:
document 4, document 4a

etc...

I want to be able to query the history of any single document, so I can get a list of
document 1, 1a, and 1b. or document 3 and 3a, etc...

So I have something like this (omitting a few lines, for clarity) to set up the
record structure:

users.create((' name',str),
('email',str))

project.create( ('description', str),
('label',str),
('creation_date ',date),
('submitter',us ers))

documents.creat e(('filename',s tr),
('submit',date) ,
('submitter',us ers),
('type',str),
('project',proj ect))

with this structure, I can get a project with a series of documents, but each
document doesn't have a history. My first thought (with Python data structures) is
to use a list, but that's not an rdb concept. Do I make something like:

document_sequen ces.create(('na me',str),('proj ect',project))

and then change documents so that it contains not only a project field, but a
document_sequen ce field? Am I thinking about this correctly?

Is there a resource I can read that goes through any of this?
thanks,
Brian Blais


--
-----------------

bb****@bryant.e du
http://web.bryant.edu/~bblais

Jun 23 '07 #1
1 1094
Jim
It sounds to me that you want Subversion. There is a Python binding
if you have anything you'd need to do beyond what already comes with
the system (there are a variety of web interfaces already out there,
for instance, so I don't know that you'd need to do anything extra).
Just google "subversion ".

Jim

Jun 24 '07 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

34
7045
by: yensao | last post by:
Hi, I have a hard time to understand difference and similarities between Relational database model and the Object-Oriented model. Can somebody help me with this? Thank you in advance. Yensao
3
4498
by: Rushikesh | last post by:
I am designing a WEB BASED Accounting Software with ASP and SQL Server. For this I need some help for the Database design. My design is as follows. I)User table: User_id, UserName..... Users (e.g. John Smith) Each User would contain a following Group of tables a)Customers
2
1520
by: hplloyd | last post by:
I am fairly new to VB.NET programming but have built many database applications in Access SQL Server etc. I need to find a good book or other reference material that will help me take my OO programing skills to the next level. I can build forms and bind data to them from SQL server, but somehow this seems not to be the best way to use an OO...
2
1400
by: Mike Farmer | last post by:
I know I ran across the solution to this before, but I'm drawing a blank now. I designed a database that is used by one person. He keeps trying to make changes to the design and then I get called in to fix the problem. In the past he has been caught intentionally changing my work, then complaining to management that the database didn't work....
5
1993
by: William Wisnieski | last post by:
Hello Everyone, I'm really stuck on how to design this application, so I thought I'd see if anyone had any general ideas on how to proceed. I'd say I'm an intermediate level Access developer. I volunteered to help my kid's school (a small non-profit) with a tremendous need they have for a complete student administration database. I've...
1
1422
by: ILCSP | last post by:
Hi,this has been bothering me for a while now. I have 2 MS Access 2000 databases, the real one that everybody uses (in the NT network) and the one I use to design new stuff. After I test the new forms on mine, I import them to the real database so everybody can use it. However, some of the code that works perfectly in my design database...
4
2911
by: dgleeson3 | last post by:
Hello all I am creating a VB.Net distributed SQL server 2005 application. Each computer in the system has a database with a table of users and their telephone numbers. Each computer has a unique 4 digit identifying code. The central server runs an application which reads the database table on each computer.
10
3341
by: Les Desser | last post by:
In article <fcebdacd-2bd8-4d07-93a8-8b69d3452f3e@s50g2000hsb.googlegroups.com>, The Frog <Mr.Frog.to.you@googlemail.comMon, 14 Apr 2008 00:45:10 writes Not sure if I quite follow that. 1. Data encrypted by AES key 2. AES key encrypted with Asymmetric public key (?)
7
1157
by: Jonathan Wood | last post by:
I've been given a spec that seems unwieldy to me. As I'm pretty new to DB design, I would appreciated any input this spec. The site has three types of users: ADMIN, RESELLERS, and CLIENTS. The database will be storing ITEMS and COLLECTIONS (COLLECTIONS are lists of the ITEMS). First, ADMIN users are to be able to create a MASTER LIST of...
1
2331
by: abhijitbkulkarni | last post by:
Hello, I am designing a .NET database application that uses 3 tier architecture. Starting initially, this application will be desktop application but I will convert it into a website later but design that I am planning should support both version. Development Environment : VS2008, C# Currently Database supported are MS SQL Server 2005 and...
0
7562
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...
1
7608
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
0
7926
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
0
6198
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
1
5465
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...
0
5181
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...
0
3613
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...
0
3594
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
2058
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.