Relational DB Model For An Engineering Applicaiton

Aug 6, 2007

I'm not sure where to post this - but, I'm a DBA trying to do some modeling for a client developing an Engineering applciation.

There is a lot of interaction at the application layer between external systems and the database - I'm trying to find some ideas or templates of how others designing for a similar functionality did this.

THere are real-time displays for engineering equipment where the database must interact with different states of the equipment. The user enters search criteria for data stored in the database, and results and real-time attributes are displayed.

THis seems to be similar to a manufacturing model, but I'm struggling. I'm used to doing models for OLTP or business reporting databases. Part of the problem may be that there doesn't seem to be a good way to translate relational concepts to engineers. There are a lot of requests for bit fields.

Can anyone reccomend a reference I might look at to get some ideas on how to mesh the modeling of external processes with the database? A simple flow model doesn't seem to work (either technically or as a communication tool - I'm not sure which)

View 3 Replies


ADVERTISEMENT

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

SQL Delete Statement In Relational Model

Nov 5, 2006

Hi,

I have a large database with complex relations and I just can't figure out how to delete a single record and all its relations across database (not to mention that I can't understand why can't the DELETE statement work just like the SELECT).

It would be impossible to let you know the structure through this message, but let's say that I have 5 tables in which there are relations like this (all the tables contains a unique ID for each record, but not all contains info of the main record):

Production -> ProductionTypes
Sales -> ProductionTypes
Production -> Sales
Sales -> Personnel
Personnel --> Orders
Orders --> Financial

I hope we agree that if I delete the ProductionID.Production directly, there will be no way to know which Financial.Commission I have to delete because I just can't insert the ProductionID in every table on the database.

What do I have to do ? I just couldn't find any solid information regarding this subject on the net.

Many many thanks in advance !

George



 

View 3 Replies View Related

Create A Relational Diagram From Non-relational Database

Aug 4, 2005

Hi all,
I am trying to create a diagram for our database, during the creating, I create some of the relationships which were not there(basically our original database is not relational database, that's why I am doing it)
So sometimes I have to chage data type in order to create a relationship for the coloumns in different tables. i.e. change char(16) to varchar(7) (I checked the field that make sure all the data in this field is <= 7 characters)

But when I saved the diagram, there is an error message that state:
Errors were encountered during the save process. Some of your database objects are not saved on your diagram.

'agent' table saved successfully
'VisitUSA' table
- Unable to create relationship 'FK_VisitUSA_agent'.
ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]ALTER TABLE statement conflicted with COLUMN FOREIGN KEY constraint 'FK_VisitUSA_agent'. The conflict occurred in database 'CMC', table 'agent', column 'AgentCode'.

What does that mean? is it caused by some of the agentcode data in VisitUSA table which is not in agent table?
Thanks!
Betty

View 3 Replies View Related

Reverse Engineering SPs

Mar 8, 1999

Does anyone know of a way to determine the code of a stored procedure that was built with encryption? I inherited a db with many of these and we are not sure which version of the source code exists on the server. Alternatively, can I compile a new SP and compare it to the old one in any way other than testing lots of data?

thanks in advance.

View 1 Replies View Related

Reverse Engineering And Output

Nov 18, 1999

Two Question

1. Is there a stored procedure, or a way to reverse engineer a database? I have a lot of legacy dbs that I have inherited that I need to create a recovery system for. Part of this is creating the scripts to build all of the tables and I would like to automate it.

2. How can I output the results of a stored procedure to a text file? When I run sp_configure I would like that information to go to a text file.

Thanks in advance
Ken Earley

View 3 Replies View Related

Script To Reverse Engineering Schema

Feb 21, 2006

Hi,I'd like to reverse engineer the schema definitions in the SQL Serveron a daily basis and store them in a version control system.Could anyone please let know if there are any tools to reverse engineerthe entire schema definitions in the SQL server. I'd like somethinglike the perl script 'dbschema.pl' for the Sybase ASE.Regards,Dellit.

View 3 Replies View Related

Reporting Services Engineering Notation

Jun 1, 2007

In Reporting Services, is it possible to display a field in Engineering Notation or Scientific notation? I guess can do it by adding a format code, can somebody tell me the format for those notations.

Thanks

View 1 Replies View Related

Relational Tables Are Not Relational After Exported From My Sql Server To Host Sql Server

Dec 25, 2007

hello,
I am beginner for asp.net and sql server. I used Sql server manegement studio full version and I exported my aspnetdb which was created by VS2005 to my host sql server. I have a question: 
relational tables are not relational no longer. I noticed that when I created database diagram. what is wrong by exporting?
thanks for your helps...

View 3 Replies View Related

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

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

Relational Databases

Oct 3, 2007

I have a membership database and a profile database with a userid column in both.  The foreign key is in the profile database where i want a persons profile details to go like location,occupation and what not.  How do I make it so when a new user registers a userId is created in the profile database that matched the userid in the membership database so i can query out profile details based on a registered members userid?

View 6 Replies View Related

Help With Relational Query - Many To Many

Jun 21, 2005

Hi all! I am working on a piece of SQL at the moment and I'm getting a little confused. I have 3 tables: Items, Attributes and a table linking them. I have 5 attributes and an item can have any of the 5 attributes. So my linking table holds the ItemID and the AttributeID and there can be 1-5 entries for each Item. A user can search for items based on Attributes; so they can tick 5 checkboxes that represent the 5 Attributes. So I need to build a query based on their choices. At the moment I'm using:Select * FROM ItemsINNER JOIN linking on Link_ItemID = Item_IDWHERE Link_AttributeID IN (10, 13, 17)But this brings out the Item that have either AttributeID of 10 or 13 or 17 whereas I need it to pull out ONLY items that have a AttributeID of 10 AND 13 AND 17.Can anyone help with this query? Sorry if this is badly worded. The solutions is prolly something really simple I have overlooked... :SI've also tried:Select * FROM ItemsINNER JOIN linking on Link_ItemID = Item_IDWHERE Link_AttributeID = 10 AND AttributeID = 13 etcBut obviously that won't work! :s

View 2 Replies View Related

Relational Database

Apr 22, 2006

Hi
 
I'm using  VB.NET,ADO.NET in ASP.NET .
 
Microsoft .Net framework 1.0 
 
Windows 2000
 
Visual Studio IDE
 
and SQLServer.
 
I have to create to tables as
 
Table1 contains ID,Name
Table2 contains ID,Marks,Foreign Key ie Primary key of the table Table1.
 
Give me an information how to create these two tables in SQLServer (I know how to create a table but i don't know how to create a table which includes Foreign Key.)
 
Then using Dataset i want to display the records as Name,Marks which are stored in two tables.
 
I have studied that in ADO Join query and record set object is used but it gives a problems and it is not good when we want to transfer the data between two applications or pages but dataset solves all those problems.
 
Give me an information about it.
 
Kindly help me
 
Thanks in advance
 
Regards.

View 3 Replies View Related

Relational Databases

Jun 18, 2001

what is the difference in making relational databases in SQL vs. Access? Do you need to make them if you will be using ColdFusion? What do the other fields in minor tables need to be in order to connect them to a major table when it will all be based on a number that is in the major table? i'm kind of confused on this issue...Thanks!

View 1 Replies View Related

Relational Design

Nov 10, 2004

I have a database with 3 tables in a many to many relationship.

EmployeeGamingLicense
EmployeeDocuments
EmployeeRenewals

I created the third table to hold the employeerenewal dates, I did this because I cant have repeating vaules in the primary table. I am just making sure that my course of action is the correct one. The purpose of the Employeerenewals is to give the users an indication that a certain renewal has been processed, because in the past there was several hundred that were not processed. The problem was that the users had no way of knowing this. What I was thinking was having the primary table calculate a renewal date based off the finalsuit and show the results in the Employeerenewals with a yes of no drop down. Now the yes or no drop down box will be give the users their red flag if the renewals have been processed or not.

Does that make sense??

Thanks guys :)

View 1 Replies View Related

Relational Databases

Sep 4, 2006

Hi
I am developing a website current and i have a database that seems to be growing very rapidly..
I would like to ask if anyone knows of any good tutorials/examples on relational databases?
Also does anyone know of any good database design tutorials/examples?

If it helps i am using Microsoft Visual Web Developer

Thanks

If you think you know it all?! You know nothing!

View 3 Replies View Related

Relational Database

Apr 26, 2007

If I have a table that contains default values or a constant values do I have to relate it to my other tables that might need them. Thanks in advance.

===============
JSC0624
===============

View 2 Replies View Related

A Many-to-many Relational Problem

Jun 15, 2007

My question:
How to have an unknown number of authors returned for a list of books, with the multiple authors being returned on the SAME row as each book

My table structure:

Table A - Books
-------------------
BookID | BookName
-------------------
1 | Book One

Table B -
RelatingTable
-------------------
BookID | AuthorID
-------------------
1 | 60
1 | 61

Table C - Authors
-------------------
AuthorID | AuthorName
-------------------
60 | Bob
61 | Joe


My query:

SELECT * FROM Books, RelatingTable, Authors AS a
INNER JOIN Books AS b ON b.BookID = r.BookID
INNER JOIN RelatedTable AS r ON r.AuthorID = a.AuthorID


Output I am getting:

-------------------------------------------------------------------------
b.BookID | b.BookName | r.BookID | r.AuthorID | a.AuthorID | a.AuthorName
---------|------------|----------|------------|------------|-------------
1 | Book One | 1 | 60 | 60 | Bob
1 | Book One | 1 | 61 | 61 | Joe
-------------------------------------------------------------------------


Desired output:

-----------------------------------------------------------------------------------------------------------------------------------------------------
b.BookID | b.BookName | r.BookID[0] | r.AuthorID[0] | a.AuthorID[0] | a.AuthorName[0] | r.BookID[1] | r.AuthorID[1] | a.AuthorID[1] | a.AuthorName[1]
---------|------------|-------------|---------------|---------------|-----------------|-------------|---------------|---------------|----------------
1 | Book One | 1 | 60 | 60 | Bob | 1 | 61 | 61 | Joe
-----------------------------------------------------------------------------------------------------------------------------------------------------


The desired output does not have to be like an array - I only assume thats what it would need to be

If you can post anything to help me get in the right direction I would really appreciate it
Thanks for your time!

View 11 Replies View Related

Relational Database

Feb 16, 2006

Hi,I have a very simple question.In what cases are relational databases necessary?Are they really necessary in cases where only asingle type of query is to be performed based on one uniquefield or can we just put all fields together in a single databaseand just access them through that unique field?

View 6 Replies View Related

SQL - Relational Database

Jun 27, 2007

Hi guys,

What is a "Relational Database"?

Thanks,

Aldo.

View 1 Replies View Related

Relational Data And RDA

Aug 1, 2006

I have a few questions for you guys. I have a client
application that can be offline or online. While offline, records can be added and need to be later synced to production.


I will use rda to pull the table down, and this is working fine. Now what if I
have multiple tables where I want a foreign key relationship?

With rda I can only pull down one table at a time from
everything I've read. Now say create a constraint after pulling the two or more tables down. While in offline mode I create a new record on two seperate tables with foreign key/primary key relationship.



When I do the push to the server will it automatically
update the foreign key reference (locally) to the right one on the production
server? Or will I get a duplicate primary key error? On the production server the primary key will be different because of the identity. This is very important because I will have multiple clients.

Thanks in advance

View 1 Replies View Related

Designing Relational Tables

Sep 22, 2007

Hi, not sure if this is the right forum for this question.
 I am creating relational tables for the first time in sql server express. I will have an orderItems table and an orders table. the MenuItems table is the problem. It is a catalogue of books. There will be about ten columns. all are unique to each book. i.e isbn number, title, author, publisher etc. but ten columns seems to be quite cumbersome. it may be easier to break the table down into two tables (i.e. primary details and secondary details perhaps) However to populate the table in the first place it would be easier to have it as one table instead of opening and closing 2 tables Adding the odd book to the two tables in the future would not be a problem. so the question is can i create a table and then brak it into two relational tables afterwards. If so how do i do this. this is my foirst go at relational tables and i am still trying to get a handle on visualising them. If my logic is up the wall please let me know....
Nick

View 2 Replies View Related

SQLDataSource Relational Data

Nov 14, 2005

I am just now starting the switch from .NET 1.1 to .NET 2.0.  I really like the new way of using the SQLDataSource and setting up Views declaratively as opposed to doing it all in code, which brings me to my question.In some of my applications I have a single Stored Procedure return multiple result sets to a single DataSet where I have a DataRelation set up.  Then I can have nested DataGrids that use the GetChildRows() method to filter the results to display the hierarchical data.  I would like to do something similar with the SQLDataSource and GridViews but haven't found a way to get multiple result sets.One thought I had was to create a Strongly Typed Dataset and then use the ObjectDataSource object, but I still didn't see a way to get child rows out of the datasource.  I've seen an example that uses a <FilterParameter> to get nested data, but there is an extra trip made to the server for each parent item as it just put an extra parameter in the WHERE clause of the query.

View 1 Replies View Related

OLAP Relational Structure

Sep 28, 2005

I am building a data warehousing solution without using analysis services or OLAP or OLTP....

Dont ask why ... but I have to....


Ok so which table structure would be better ?


dimention 1|dimention 2|dimention 3|matrix 1|matrix 2|matrix 3|matrix 4....


or


dimention 1|dimention 2|dimention 3|matrix name|matrix value



I prefer the second one....

View 14 Replies View Related

Converting Relational Data In XML??

Apr 2, 2008

Hello everyone

When converting From Relational data into XML which
method ie RAW, AUTO, PATH, EXPLICIT is mostly used and why please

Regards

Rob

View 5 Replies View Related

Relational Algebra Question

Apr 24, 2007

This is a bit of a trivial question, since I know how to actually create the code in SQL. Hope this is the right section to post it in too, since it sort of concerns design I guess..

My problem is how to I represent the following SQL query in relational algebra:

SELECT *
FROM Staff;

Since I'm using SELECT, I assume I use selection to represent it, so would it be as "ó(Staff)" [using the sigma symbol, in case it doesn't show]? But as I'm not specifying a predicate since I wish to select all fields in Staff, would it be simply represented as "Staff"?

I appreciate any help... it's been baffling me for a while

View 2 Replies View Related

Query Help Please (relational Algebra)

Dec 12, 2007

Hotel(hotelno, hotelname ,city)
Room(roomNo, hotelNo,type,price)

i need the reltional algebra to list the price and type of rooms in the hilton hotel
thanx

View 5 Replies View Related

Relational Data Transfer In DTS

Jul 20, 2005

Hi Please help for this simple problemDTS Transfer or any other method?I have Customer_Order Table and customer_Order_Details Table.For OrderID = 1, I have 3 rows of Order Details.I want to transferCustomer_Order Table for OrderID 1 in DTS, the system should transferOrder Table as well as Order details table Rows for ORderID =1.How to customize in DT or is there any way to get this data to transferfrom source DB to Dest DB?KAMAL KUMAR V--Posted via http://dbforums.com

View 1 Replies View Related

Insert On Relational Tables

Apr 7, 2008

I understand the basics for doing an insert. Their seems to be many ways of achieving the same thing in .net. I have used the tableadpaters and sqlcommand functionality to achieve this. My one question is how foregin keys should be created in associated tables. EG so if i create a new record entry in one table and the primary key for that entry is a foreign key in another table, do I need to call 2 table adapters, or run 2 sqlcommands(taking the primary key from the first traction and use this in the next transaction)?

Any help or direction for some good tutorials on this would be much appreciated.

Thanks

Mark

View 4 Replies View Related







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