Datbase Model Issue

Sep 28, 2004

I need input in how to define a proper model for a certain issue.
I've got a table, testcase. Each row in table testcase relates to 1 or more statistics tables. (the statistics differ a lot , thats way I can't place them in the very samt table) Now, there are like 50 different statistics tables. And each row may only store statistics in some of them. Whats a proper model for this?

Ex: create foregin keys in testcase table (for all statistics thats like 50 foreign keys) that has a primary key in each statistics table. I then must have a dummy value in each statistics table to ensure that we do not violate the referencial integrety.

Ex: create a relation between prim.key of table testcase that has a foreign key in each statistics table.

ex: many-to-many, but this violates the referential integrety...since we relates to multiple tables on one side.

suggestions?
/Martin

View 1 Replies


ADVERTISEMENT

Report Model Deployment : The Model ID Of The Submitted Model Must Match That Of The

Dec 5, 2005

Running 2005 Beta 3 Refresh.  When I first deploy, it works fine. Subsequent deployments yield the following error:

View 9 Replies View Related

Deleting Datbase

Apr 23, 2001

how do i delete an entire database when it keeps saying that the database is currently in use?

View 3 Replies View Related

Datbase Migration

Jan 21, 2008

HI Guys

I have a vary large NS-Access database that needs to be migrated with its data to SQL Server, are there any good tools available to do this ?

How would one proceed doing this ?

View 3 Replies View Related

Datbase Design Help

Jan 25, 2008

Four Entities-
Consultant
Client
Project
Time Sheet

Relationships:
A consultant can work for many Clients at a time
A client can have many projects at a time
A Consultant may wok on many projects for many Clients
Time sheet is the time a consultant worked for a particular client on a particular project for a week.
I would appreciate if someone can help me design this database

View 3 Replies View Related

Recover Datbase

Mar 28, 2007

how can i recover sqlserver 6.5 datbase from tape.

pls help me?

View 1 Replies View Related

Build Datbase From Xsd/xml ??

Sep 13, 2006

Hello all. I have an .xsd file and a .xml file that goes with it. Are there any tools available that will build a database structure in SQL Server from either of these two files? I can't see the .xml file being of much use for building the structure, but how about the .xsd file?

View 5 Replies View Related

Datbase Mirroring Issues

Jan 12, 2008

I am going to do database mirroring for. I need to configure what needs to be installed for mirror server and witness server with OS perspective. Does Mirror server have to have same hardware and software config as Principle server?
Thanks

View 2 Replies View Related

How To: Move A Datbase From Express To Server?

Mar 10, 2006

Hello,
Thanks for reviewing my question.  I would like to know how do you bring a database from SQL Express into a SQL 2005 server?  I didn't find a way to import the SQLExpress (.mdf) file.
Many Thanks
Peter

View 2 Replies View Related

Question On Automatic Copying Table From One Datbase To Another On Same SQL Server

Apr 6, 2004

Currently have two databases. A live database and a history database. Also have the ability to purge data from the live to the history database. What I'm looking for is the ability, if the table doesn't exist in history, to automatically create the table in the history database using the format of the table within the live database. Any help would be greatly appreciated. Thanks

View 9 Replies View Related

Power Pivot :: Building A Model Based On Multinational Model With Different Languages?

Oct 19, 2015

I need to develop a language specific dwh, meaning that descriptions of products are available from a SAP system in multiple languages. English is the most important language and that is the standard. But, there are also requirements of countries that wants productdescriptions in their language. 

Productnr Productdesc Language
1            product       EN
1            produkt       DE

One option is to column the descriptions, but that is not very elegantly. I was thinking of using bridge tables to model this but you have to always select a language in a filter (I think)..

I'm thinking of a technical solution, such that when a user logs on, the language is determined and a view determines whether to pick a certain product table specific for a certain language. But then I don't have the opportunity to interchange the different language specific fields in a report (or in my case PowerPivot).

View 2 Replies View Related

Can We Pause Log Shipping, Bring Primary Db To Simple Recovery Model And Then Back To Full R Model?

Apr 25, 2008



We have the following scenario,

We have our Production server having database on which Few DTS packages execute every night. Most of them have Bulk Insert stored procedures running.

SO we have to set Recovery Model of the database to simple for that period of time, otherwise it will blow up our logs.

Is there any way we can set up log shipping between our production and standby server, but pause it for some time, set recovery model of primary db to simple, execute DTS Bulk Insert Jobs, Bring it Back to Full recovery Model AND finally bring back Log SHipping.

It it possible, if yes how can we achieve this.

If not what could be another DR solution in this scenario.

Thanks Much
Tejinder

View 6 Replies View Related

MS Time Series - Quick To Process The Model But Takes Very Long Time To Open Mining Model Viewer

Oct 27, 2007

Hi all,

I have MS Time Seeries model using a database of over a thousand products each of which has hundreds of cases. It amazingly takes only a few minutes to finish processing the model, but when I click Mining Model Viewer to view the models, it takes many hours to show up. Once the window is open, I can choose model for different products almost instantly. Is this normal?

View 1 Replies View Related

Connected Model Vs. Disconnected Model

Aug 10, 2005

hi !!i have a question about the connected and disconnected model to access the Sql server DB.......i know that there is better to choose one rather than the other in some situantions and there is no better model in all cases...... os i hope you can help me to decide what shall i choose...i will use the DB to connect to Web services and read data from the DB and wrtie some data back.......i do not know that to use ..... i hope you advise me and tell me about the rules that will allow me to choose  what model to choose .... i appreciate your help!!Thanks !!!

View 2 Replies View Related

Error While Trying To Load The Mining Model In The Mining Model Viewer

Nov 15, 2006

I get the following error when I try to load the mining model in the mining model viewer

Query (1, 6) The '[System].[Microsoft].[AnalysisServices].[System].[DataMining].[NeuralNet].[GetAttributeValues]' function does not exist.

I get a similar error when I try to load the Load Mining Accuracy Chart

Failed to execute the query due to the following error:

Query (1, 6) The '[System].[Microsoft].[AnalysisServices].[System].[DataMining].[AllOther].[GenerateLiftTableUsingDatasource]' function does not exist.

I have OWC 11 installed. What am I missing here?

Thanks

View 7 Replies View Related

Model DB

Jun 6, 2001

Hello,

I just installed the enterprise edition of MS SQL Server 2000 in model database there are no store procedure. whereas in MS SQL Server 7.0 there are 18 SP so when I create the new db there is no SP only the one which I've created. Is it normal or did I miss something in installing

Thanks

Rea

View 1 Replies View Related

RUP & DB Model

Apr 9, 2008

Hi,

I'm new in SQL server DBA and in my company. There are about 40 applications in my company and since there's no DB document available, my boss has asked me to prepare a full documentation package about DB schema of each application. I'm going to use RUP method for that but I'm not sure of including which information in the package.

Any idea is appreciated

View 7 Replies View Related

Model Db

Apr 5, 2006

hi

I have changed the initial size of the model DB , now I want to change it again , but I want to make it smaller than the one it is currently can i do that

When I go the EM & try changing the file size it says :-

The new DBFile size must be larger than the current size

Regards
aki

View 2 Replies View Related

Pb In System Db "model"

May 7, 2002

Hi there,
My problem is : No de system stocked procedure in the system db "model".
What should I do to visualise theses sp.

any help will be appreciated.

Thanks in advance

View 1 Replies View Related

DTS - Recovery Model

Jan 31, 2003

SQL Server 2000 SP3.
Prior to SP3 the recovery model was switched to simple during transfer (Copy object task) and changed back to the previouis setting after DTS was complete.
Nice thing because performance was increased and T-Log was keep small.

Now I assume that the recovery model is switched to bulk-logged causing the T-Log to explode, to be onest not in all my databases.

1.Is my interpretation regarding recovery model correct?
2.Does anybody knows the reason of this change?

Any suggestion is really appreciate.
Thank you very much - kind regards.

View 2 Replies View Related

System Db "model"

May 7, 2002

Hi there,
My problem is : No de system stocked procedure in the system db "model".
What should I do to visualise theses sp.

any help will be appreciated.

Thanks in advance

View 1 Replies View Related

Recovery Model

May 31, 2002

Hello,
I'm new to MS SQL Server I want to know which recovery model is good, Full or Bulk Logged as I'm doing full backup at 11:00 PM and diffential Backup at 12:30 PM and from 8:00 AM to 6:00 PM 15 min log backups.
Please guide me which recovery model should I choose.

Thanks
Lara

View 1 Replies View Related

Help With Security Model

Jun 10, 2004

Hi all,

I need some sugestions from all of you about setting up security model in
our SQL2000 box.

The server was setup using Mixed mode. However, all the applications
(web and MS access) access the server using "sa" userid.

There are several databases in our server. Ex: (DB1,DB2,DB3,DB4 and DB5)

Application 1: need read/write access to DB1,DB2 and DB3
Application 2: need read/write access to DB5
Application 3: need read/write access to DB4 and DB3

Should I set up three userids and give them the dbo access to those
database that they need to use?

Does that make any sense to you?

Thank you for all your suggestion

View 5 Replies View Related

Model Db During Restore

Nov 26, 2004

Hello, i have no specific problem but i just want to know your opinion on the issue. Last week I tested my recovery scenario and after installing new server i successfully restored master db. Then I tried to start server, but it wouldn't come up because physical path of model db in master..sysdatabases table didn't correspond to the actual location of db on new server, so that tempdb couldn't be created from model db on server startup. I started server without recovering dbs with exception of master using trace -T3608. Now I hoped that I could restore model using MOVE clause but it gave me error saying that restore operation needs to use temporary table in tempdb. To break this vicious circle I used model db files from installation CD and put them to the expected location. After two restarts server accepted the files and I went on restoring msdb and user databases. But I'm sure I must be missing something and there must be better way to do this but i haven't been able to find anything relating to this problem. Thank you for your input. mojza

View 1 Replies View Related

Model DB Problem..

Oct 31, 2005

attempted to move my Model and msdb database files to a different drive on the server. I did the following:
* Restarted SQL Server 2K with the -T3608 startup parameter
* successfully detached msdb and model DBs
* moved the msdbdata.mdf, msdblog.ldf, model.mdf and modellog.ldf
files to their new homes
* successfully reattached model and msdb

When I take away the -T3808 startup parameter and restart SQL Server, I do not see the model database in the db list in enterprise manager eventhough my 'attach' seemed to work. Now I get the following error when i try and query against the Model database using query analyzer:

"Could not locate entry in sysdatabases for database 'model'. No entry found with that name. Make sure that the name is entered correctly"

Also, when I look in the sysaltfiles table in Master, I see no reference whatsoever to the Model DB

What did I do wrong?

View 1 Replies View Related

Best Recovery Model

Jan 11, 2006

What would be the best Recovery Model for: a database which is 4 gig in size and imports via MSAccess queries and also stored procedures approximately 400,000 meg of data each month (and some other update queries are run against it) and it is also queried off of for totals on weekly basis?

The problem is that the SQL Server box only has 512 meg of memory and the tranlog on this database grows tremendously each import and when update queries are run against it. This tends to slow things down a bit on our other databases. We are getting a new SQL Server box but until then, what would be the best recovery model? I currently have it as Bulk-Logged and allow the tranlog to grow by 10% (with a base of 250 meg). The tranlog grows to up to 5-10 gig and in order to shrink it, I have to change the recovery model to Simple, and then back to Bulk-Logged in order to shrink it (I've tried all the dbcc shrinkdatabase, dbcc shrinkfile, dbcc showcontig, and dbcc checkdb commands as well as BACKUP LOG dbName WITH TRUNCACTE_ONLY and nothing will shrink it unless I change the recovery model to simple.)

View 2 Replies View Related

Nested Set Model

Jan 30, 2006

hi guys,

i have the following category table...

CREATE TABLE [dbo].[categories] (
[cat_id] [int] IDENTITY (1, 1) NOT NULL ,
[dModified] [datetime] NULL ,
[dCreated] [datetime] NULL ,
[cat_parent_id] [int] NULL ,
[cat_lft] [int] NULL ,
[cat_rgt] [int] NULL ,
[cat_image] [varchar] (255) COLLATE Latin1_General_CI_AS NULL ,
[cat_sort_order] [int] NULL
) ON [PRIMARY]
GO

i now wish to add a levels column which indicates (funnily enough :)) which level each record is on starting from 1.

is there a query i can use which will output for me the levels based on the child/parent relationship?

regards
mike

View 3 Replies View Related

I Cant Create A Model

Sep 6, 2006

I try to create relational database but i cant develop a model. after i create a database i will create an OLAP cube for my project.i dont want to complex model but i cant create a simple database. it may be marketing, CRM or another. i dont know what fields and tables i should create. i saw sample databases such as northwind and foodmart but i must create original database for my project. please help meeeeee

View 1 Replies View Related

Data Model

May 17, 2007

Hi,
I am finding nice examples data model of CMS. Do you know any link to data model phorum or any link to data model examples(nice)?
Thanks

View 3 Replies View Related

Data Model?

Jun 16, 2008

Why would we need to know the data model to write queries?

Sorry but its been a long time since I've worked with databases and I don't remember!

Could anybody lead me in the right direction please?

View 1 Replies View Related

Data Model?

Jun 16, 2008

Why would we need a data model to write queries?

Sorry but its been a loong time since I've worked with databases and I barely remember.

Could anybody lead me in the right direction please?

Thanks.

View 1 Replies View Related

Recovery Model

Mar 3, 2008

I can't understand what is diff between simple & bulk-logged recovery
model

View 1 Replies View Related

Relational Model And XML

Jul 20, 2005

Hi,This question has been bothering me for some time. A lot of peopleseem to "think" XML is the king of data problems, and I've heard thatnext version of SQL Server is going to have a strong XML flavor,meantime, I seem to get the impression that a large number ofhard-core relational model gurus do not seem to be that impressed withXML (technical value of this extra layer seems to be limited whilebusiness value might be substantial for instance, more software work,more disk space requirement etc. etc.). What's your take on this?Generality or specifics, all welcome. One specific question is, howcan XML supplement relational model?Thanks.

View 12 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved