Database

Eddy Vluggen24-May-13 4:18

24-May-13 4:18

Daaron wrote:
is there a way to crowdsource the solution?

Filed under "Silver Bullet".

What's a VA?

Bastard Programmer from Hell Suspicious | :suss:

If you can't read my code, try converting it here[^]

jschell24-May-13 12:40

jschell

24-May-13 12:40

Eddy Vluggen wrote:
What's a VA?

Presumably the US Veterans Administration.

Richard MacCutchan24-May-13 4:19

Richard MacCutchan

24-May-13 4:19

Daaron wrote:
is there a way to crowdsource the solution?

You need to define the problem first.

Use the best guess

R. Giskard Reventlov24-May-13 5:15

R. Giskard Reventlov

24-May-13 5:15

You are getting roasted because this is entirely the wrong place to discuss this issue.

"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
Those who seek perfection will only find imperfection
nils illegitimus carborundum

me, me, me
me, in pictures

PIEBALDconsult24-May-13 11:45

PIEBALDconsult

24-May-13 11:45

What are you on about? And shouldn't it be in another forum?

I took some classes in EMR/EHR a few years back and someone from the VA spoke. They use a system called VistA. http://en.wikipedia.org/wiki/VistA[^]. (It uses Caché ! Dead | X|

)

http://www.emrandehr.com/tag/veterans-affairs/[^]

http://www.va.gov/vista_monograph/[^]

Create Mysql Music Database Help

jschell24-May-13 12:43

jschell

24-May-13 12:43

Daaron wrote:
crowdsource the solution?

Solution to what exactly?

As a guess you are referring to back claims. If so then the back log is probably caused by a lack of humans an/or effective process control. Software might help with a solution to either of those, but software itself is not a solution.

Muveen_Delhi23-May-13 22:28

Muveen_Delhi

23-May-13 22:28

Hi,

I am going to create a database in MySql to show the information on the website page.
I have data in my excel sheet it is related to Bollywood Movies / Songs.
Excel Sheet coloum details : Songs Title, Movie Name, Year, Singer, Music Director, Lyrics, Picturised, Actors, Banner,

Producer, Director, Music Company. I have Posters of Movies, pictures of all actors, Music directors, Singers etc.

Now my question is :

How can I design the database to show the record on the page.

1. If any user click on the particular Movie
the table should show the details are :

Song title | Singer | Music Director | Lyrics | Picturised

Poster of the movie will show on left / right side of the same page

2. If any user click on the particular singer
the table should show the singer's filmography details are :

Movie | Year | Music Director | Music Company

3. If any user click on the particular Movie the point no. 1 will be repeat
4. If any user click on the particular Music Director
the table should show the Music Director's filmography details are :

Movie | Year | Director | Music Company
5. If any user click on the particular Movie the point no. 1 will be repeat

it will be same for any actor, Music Director, Lyrics, Director, Banner etc..

=====
How many tables should I make and the table structure with primary / foreign key info for above said.

Thanks in advance

Muveen

Re: Create Mysql Music Database Help

Eddy Vluggen24-May-13 3:02

Re: Create Mysql Music Database Help

24-May-13 3:02

Muveen_Delhi wrote:
How many tables should I make

That depends on the design; I'd recommend to normalize the database-model, that way you'll have a guaranteed correct and consistent design. Alternatively, you can download a pre-built design on databaseanswers.org[^].

Muveen_Delhi wrote:
How can I design the database to show the record on the page.

Databases do not show things; they store things. What kind of app would use the database? A webapplication, a desktop application, something on a phone?

Bastard Programmer from Hell Suspicious | :suss:

If you can't read my code, try converting it here[^]

Muveen_Delhi24-May-13 18:08

Muveen_Delhi

24-May-13 18:08

I want to develop a website using PHP for that use I need this database.

Re: Create Mysql Music Database Help

Mycroft Holmes26-May-13 12:51

Mycroft Holmes

26-May-13 12:51

Do a search for tutorials creating a music application (book would be similar), work through the tutorial.

You question shows a dramatic lack of understanding of what you are attempting, the tutorials will deepen that understanding and allow you to ask sensible questions.

Never underestimate the power of human stupidity
RAH

INSERT - SELECT QUERY Help Needed.

codingrocks23-May-13 9:00

codingrocks

23-May-13 9:00

I have the following tables.

Table SS

SID SNAME
== =====
1 AAA
2 BBB
3 CCC

Table PP

PID PNAME
== =====
1 Phase1
2 Phase2
3 Phase3

Third table (COMP) data may look like the following.

ID SID PID
== === ===
1 1 1
2 1 2
3 1 3
4 2 1
5 2 2

ID here in third table is autoincrement. I need to insert a new record in SS table and it can have mapping to many Phases in PP table.

So I want to write a
INSERT INTO COMP (col1,col2)
SELECT (col1,col2)
FROM table...

So ultimately new records needs to be inserted into the last table with a SID map and different PID.

How can I accomplish the same?

Thanks in advance.

CodingRocks

ASP.NET,C#.NET Programmer
BANGALORE

"Winners don't do different things. They do things differently. ...

Re: INSERT - SELECT QUERY Help Needed.

Mycroft Holmes23-May-13 11:15

Mycroft Holmes

23-May-13 11:15

Assuming you have a list of PIDs you want inserted you require 3 statemants,

<pre lang="SQL">Declare @NewID int

Insert SS (fields).Values

Set @NewID = scope_identity()

insert Comp(SID,PID)
Select @NewID, PID from listofpids</pre>

Never underestimate the power of human stupidity
RAH

Hey need help of adding data T__T

Al Arcilla23-May-13 4:54

Al Arcilla

23-May-13 4:54

EDIT: I Guess this makes my problem clearer
i have 2 tables
Mother with Columns (Name,NameKey)
and Children with Columns(child,childkey,Mother.NameKey)

i want to connect 2 tables
and insert many children in 1 mother
is this code possible? can't try it right now

 insert into children(mother.namekey,child)<br />
values<br />
(Select namekey from mother where name='TELMA'),BEN,RON,DONNA)<br />

i know my codes above have errors even w/o trying it.
i just want to know how to make that happen and get this output
MOTHER- CHILDREN
TELMA..............BEN
............................RON
...........................Donna

modified 24-May-13 22:59pm.

Re: Hey need help of adding data T__T

Simon_Whale23-May-13 5:16

Simon_Whale

23-May-13 5:16

Have you tried (have assumed that this is SQL Server)

SQL

insert into family (children) values
select 'ben'
union
select 'ron'
union
select 'donna'

Every day, thousands of innocent plants are killed by vegetarians.

Help end the violence EAT BACON

Re: Hey need help of adding data T__T

Eddy Vluggen24-May-13 0:23

Re: Hey need help of adding data T__T

24-May-13 0:23

Al Arcilla wrote:
i have a table family

columns (MOTHER,CHILDREN)

How did you create it? Can you post the CREATE TABLE statement?

Al Arcilla wrote:
how can i have an output like that?

Is the problem in getting the "output" based on the data, or getting the data in the table?

Al Arcilla wrote:
this is the code i try i know this will not work

What does "not work" mean? Did it execute succesfull or throw an exception? If there was an error, which one? Can you post it?

I'm going to guess that your "mother" column isn't a primary key, nor an identity. In that case, it'll need a value when you do the insert;

SQL

INSERT INTO [family] (MOTHER,CHILDREN)
  VALUES ("Mother", "Ben");

Bastard Programmer from Hell Suspicious | :suss:

If you can't read my code, try converting it here[^]

Al Arcilla26-May-13 3:50

Al Arcilla

26-May-13 3:50

UP for my question

disributed database (in one computer(at sql 2008)/two server)؟?

22majid2222-May-13 19:44

22majid22

22-May-13 19:44

Hi
how can Implementation
disributed database (in one computer(at sql 2008)/two server)؟?

Thanks

m.shamshirgaran@stu.semnaniau.ac.ir

Re: disributed database (in one computer(at sql 2008)/two server)؟?

Mycroft Holmes22-May-13 22:07

Mycroft Holmes

22-May-13 22:07

2 things, do NOT put your email in a forum message, edit it out ASAP. If someone needs to get to you directly they can use the email option at the bottom of the posting.

Define what you mean by <code>distributed</code> you can install 2 instances of SQL server on the same machine this could simulate a distributed environment but you need to be more explicit.

Never underestimate the power of human stupidity
RAH

Select in SP slower than non-SP ?

Saxet22-May-13 7:16

Saxet

22-May-13 7:16

I have this SQL Server 2012 trivial stored procedure:

SQL

CREATE PROCEDURE usp_SelectCompany
AS
BEGIN
	SET NOCOUNT ON
	SELECT * FROM Company
END

and in a SSMS window, I execute this commands below to discover my SP is much slower than directly executing SELECT * from Company, even after the SP is run once to compile it.

SQL

-- create temp table so SSMS results output doesn't interfere too much with with query execution time 
SELECT * INTO #Company FROM Company WHERE 1=0

-- run the SP once to ensure that is is compiled
INSERT #Company EXEC usp_SelectCompany

PRINT 'Start Time:  ' + cast(sysdatetime() as varchar)
INSERT #Company EXEC usp_SelectCompany
PRINT 'SP Time:     ' + cast(sysdatetime() as varchar)
INSERT #Company SELECT * FROM Company
PRINT 'Select Time: ' + cast(sysdatetime() as varchar)

Here is the output:

(0 row(s) affected)

(127733 row(s) affected)
Start Time:  2013-05-22 11:56:57.7208741

(127733 row(s) affected)
SP Time:     2013-05-22 11:57:03.2067327

(127733 row(s) affected)
Select Time: 2013-05-22 11:57:04.0015524

I note that the SP executes in 5.4858586 seconds, and the direct "select" statement only takes 0.7948197 seconds, or about 7 times slower.

Can anyone explain this behavior?

Eddy Vluggen22-May-13 7:36

22-May-13 7:36

Saxet wrote:
Can anyone explain this behavior?

I can't, but a wild guess would be the optimizer (select and insert vs. insert and exec some proc).

What's the timing when you move the insert-statement inside the sproc?

Bastard Programmer from Hell Suspicious | :suss:

If you can't read my code, try converting it here[^]

Saxet22-May-13 8:03

Saxet

22-May-13 8:03

It's better (1.0295934 seconds), but still slower than the select in the SSMS window.

Start Time:  2013-05-22 12:51:03.6580584
End Time:     2013-05-22 12:51:04.6876518

Eddy Vluggen22-May-13 8:20

22-May-13 8:20

Saxet wrote:
It's better (1.0295934 seconds), but still slower than the select in the SSMS window.

The server has to do some things that can be skipped when being fed the statement directly, like looking up the access-rights to the sproc. So yes, compared to a simple query, it'd be a (small) bit slower.

Bastard Programmer from Hell Suspicious | :suss:

If you can't read my code, try converting it here[^]