|
That query won't work in Sql, nor any database-implementation that I know of. It's either a relational, or an object-oriented database.
"Object relational" sounds like theory to me.
jojoba20 wrote: which some OO fans would describe as overly complex logic. Some OO fans should do their homework. Relational is a way of modelling, like object-oriented. One can't become "more like" the other, since it's two different ways of looking at stuff.
jojoba20 wrote: In an object-relational database, one might see something like this, where the data types and expressions such as BirthDay() are user-defined. Right.
Creating functions doesn't make it "object-relational".
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
|
|
|
|
|
thanks for your help!
in which management i can have object-oriented database ?
i wanna to design object oriented database BUT i dont know in which platform or management i can do that ??????
thanks in advanced!
|
|
|
|
|
|
thanks but is there any software that i can make(create) FOODB (Fuzzy Object Oriented DataBase) for SQL ?
I am seeking for software to create the DB first.
I am confuzed!
Thanks in advanced!
|
|
|
|
|
I have no idea, but I gave you a Google search with lots of links, it's up to you to go through them and see if any contain what you are looking for.
Veni, vidi, abiit domum
|
|
|
|
|
thanks
I have searched that before but doesnt get any thing!
|
|
|
|
|
So maybe there isn't any.
Veni, vidi, abiit domum
|
|
|
|
|
jojoba20 wrote: is there any software that i can make(create) FOODB (Fuzzy Object Oriented DataBase) for SQL ? There is no such thing as a "fuzzy" object oriented database. The example you lnked to does not apply to an existing product.
jojoba20 wrote: I am seeking for software to create the DB first. Simply use SQL Server and you can create databases. Why does it need be "fuzzy"?
jojoba20 wrote: I am confuzed! ..because you're looking for something that does not exist.
"Fuzzy object-relational"? What kind of data are you going to store that you're interested in that collection of buzzwords?
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
|
|
|
|
|
so how to use the code bellow ?
I wanna have Object Oriented DataBase (In an object-relational database, one might see something like this, where the data types and expressions such as BirthDay() are user-defined.)
this is example code for creating Table but give error in SQL Server Management 2008 !
CREATE TABLE Customers (
Id Cust_Id NOT NULL PRIMARY KEY,
Name PersonName NOT NULL,
DOB DATE NOT NULL
);
SELECT Formal( C.Name )
FROM Customers C
WHERE BirthDay ( C.DOB ) = TODAY;
|
|
|
|
|
jojoba20 wrote: so how to use the code bellow ? The code from the example is not real code.
jojoba20 wrote: I wanna have Object Oriented DataBase Then download one.
jojoba20 wrote: In an object-relational database Object-relational is nonsense.
jojoba20 wrote: this is example code for creating Table but give error in SQL Server Management 2008 ! That's not example code, it's a made-up example. Sql Server is not an object oriented database and is not a fuzzy database. One talks to it using Sql, or using an ORM.
The example sql statement is a pack o' nonsense. I mean, convert C.DOB to a birthday? If you need a function, create one in SQL. There are dozens of manuals on how one creates a function and how to use that function in a query. Real examples, not converting X to X. Even the "formal" function is something that's standard SQL.
1) it's not a real life example
2) it's not real code
3) you don't need it
I'm convinced of 3 since you haven't named a single argument that says "need". I only read "want" from someone who cannot explain what it is he needs.
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
|
|
|
|
|
Have a read of this wiki page: Object Orientated database systems.[^]
as you can see the example you have been given come from here! the examples from this wiki page show that the SQL was and is written around database servers such as postgres etc.
The code like Eddy has said wont work on SQL Server!
The create table [^] statement is incorrect as you haven't specified the correct datatypes.
The Select statement wont work either, why? because you would need to create User definded functions[^] for Formal and BirthDay
for further reading Relational database systems (RDBMS)[^]
Every day, thousands of innocent plants are killed by vegetarians.
Help end the violence EAT BACON
|
|
|
|
|
jojoba20 wrote: how to use fuzzy object oriented database sql?
Based on your responses and the other responses to you...
The FIRST step is to define exactly what the above term means.
|
|
|
|
|
Thanks all!
SO Finally :
There isnt any management (or database server or Tools ) for creating Object-Oriented DataBases ?
|
|
|
|
|
yes this Google search shows a wiki page object orientated databases[^].
There is a huge list there.
Every day, thousands of innocent plants are killed by vegetarians.
Help end the violence EAT BACON
|
|
|
|
|
i have got this from my sir.
SELECT <attribute list> FROM < Class1 with threshold1, Class2 with threshold2, ... , Classm with thresholdm> WHERE <Att1 = Val1 WITH Thold=τ1 WITH Weight=w1 , Att2 = Val2 WITH Thold=τ2 WITH Weight=w2 , ... , Attn = Valn WITH Thold=τn WITH Weight=wn>
|
|
|
|
|
I have no experience with actually coding object orientated databases or even using them, I just know that they exist.
What I would suggest find out which database engine you are to use and then have a look at it's documentation.
Every day, thousands of innocent plants are killed by vegetarians.
Help end the violence EAT BACON
|
|
|
|
|
jojoba20 wrote: i have got this from my sir. It's called a witch-hunt. Did he make up this example himself, or did he simply come across something? It's a lousy way of researching.
Object oriented databases exist; you can download an open-source version and give it a whirl.
The query looks like he should be introduced to LINQ. Since it still does not explain what he is trying or needs, we can only guess. He's being "fuzzy", and will thus only receive fuzzy answers.
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
|
|
|
|
|
Hi,
I am using MySQL, PHP and PDO to insert a support ticket. Inserting works fine but I want to get the ticket_id after insertions using OUT from the stored procedure. Can you please help.
here is my stored procedure followed by my PDO code for INSERT.
CREATE DEFINER=`jassimdb`@`%.%` PROCEDURE `sp_add_new_ticket`(IN param_ticket_name varchar(255), IN param_ticket_email varchar(255), IN param_ticket_subject varchar(255), IN param_ticket_message text, OUT param_record_identity int)
BEGIN
INSERT INTO support_tickets (ticket_guid, ticket_name, ticket_email, ticket_subject) VALUES (UUID(), param_ticket_name, param_ticket_email, param_ticket_subject);
SET param_record_identity = LAST_INSERT_ID();
INSERT INTO support_ticket_messages (ticket_id, support_ticket_message) VALUES (LAST_INSERT_ID(), param_ticket_message);
END
$mysql_query = $mysql_connection->prepare("CALL sp_add_new_ticket(:param_ticket_name, :param_ticket_email, :param_ticket_subject, :param_ticket_message)");
$mysql_query->bindParam(':param_ticket_name', $ticket_name, PDO::PARAM_STR);
$mysql_query->bindParam(':param_ticket_email', $ticket_email, PDO::PARAM_STR);
$mysql_query->bindParam(':param_ticket_subject', $ticket_subject, PDO::PARAM_STR);
$mysql_query->bindParam(':param_ticket_message', $ticket_message, PDO::PARAM_STR);
$mysql_query->execute();
Thanks,
Jassim[^]
Technology News @ www.JassimRahma.com
|
|
|
|
|
Jassim Rahma wrote: Can you please help. Your primary key seems to be a GUID, not an auto-increment field. LAST_INSERT_ID only works for identity-fields.
Manual[^]
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
|
|
|
|
|
it is a numeric not GUID.
Technology News @ www.JassimRahma.com
|
|
|
|
|
Methinks "ticket_guid" is an odd name for a numeric.
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
|
|
|
|
|
Hi,
I am using PDO in MySQL to insert a ticket. I want to return the ticket number which is the primary key (auto increment) but it's always returning zero.
here is the code I am using:
$mysql_query = $mysql_connection->prepare("CALL sp_add_new_ticket(:param_ticket_name, :param_ticket_email, :param_ticket_subject, :param_ticket_message)");
$mysql_query->bindParam(':param_ticket_name', $ticket_name, PDO::PARAM_STR);
$mysql_query->bindParam(':param_ticket_email', $ticket_email, PDO::PARAM_STR);
$mysql_query->bindParam(':param_ticket_subject', $ticket_subject, PDO::PARAM_STR);
$mysql_query->bindParam(':param_ticket_message', $ticket_message, PDO::PARAM_STR);
$mysql_query->execute();
$ticket_number = $mysql_connection->lastInsertId();
Please help...
Jassim[^]
Technology News @ www.JassimRahma.com
|
|
|
|
|
What happens when you use an insert statement rather than the stored procedure?
|
|
|
|
|
Can you check if record in inserted in table ? or try using insert statement directly
|
|
|
|
|
Hello everyone.
I've got a problem in oracle.
I have a oracle database on a OracleLinux OS (Server A),and a Microsoft SQL Server on another server that has Windwos 2008 R2 as OS (Server B).
I want to connect to SQL Server via oracle and insert some data to it's tables (from server A to server B).
Any suggestions?
|
|
|
|