Store the speech content

[rainny]

Hi, all..

Does anybody have experiencing on store the spoken word into database?
For example, when the program hear the voice spoken by some person,
the program can store the spoken word into the database?

The database system use is MySQL.

Anybody have any idea on it?

 

[Andrew Thompson]

Hi, all..

Does anybody have experiencing on store the spoken word into database?

This problem should be broken down into (at least) two parts.
1) Capture the voice signal and determine what words were spoken.
2) Store the translated text into a database.

Plenty of people have experience with the second part, but
few will have attempted the harder part of 'speech recognition'.
This is assuming, of course, that I have understood the requirement
correctly - it is relatively easy to capture sound data and store
that (in a database or most other places) as sound data.

For example, when the program hear the voice spoken by some person,
the program can store the spoken word into the database?

The database system use is MySQL.

And although I am not very experienced with DB
development, I will point out that there are a number
of good, freely usable Java based DB's out there.

Anybody have any idea on it?

Sure, but it sounds as though you have bitten off more
than you can chew. Perhaps you should consider hiring
in extra help for this task.

 

[Andrew Thompson]

Anybody have any idea on it?

Some ideas I have for you, about discussion forums.
1) Don't send me email.
2) If you have something worth replying, put it in
a message to the forum.
3) Don't send me email (I thought it was worth
repeating).

Your email was deleted, unread.

 

[rainny]

I just want to ask is there any ways can store the translated text
into database. Although I know the 1st part is very difficult, so I
wish try to solve the 2nd part 1st which is can store the translated
text into database.

anybody know about it?

Thanks

 

[RedGrittyBrick]

I just want to ask is there any ways can store the translated text
into database. Although I know the 1st part is very difficult, so I
wish try to solve the 2nd part 1st which is can store the translated
text into database.

anybody know about it?

Storing text in a database is straightforward.
- Do you have a DBMS installed?
- Have you designed a table structure?
- Can you write JDBC statements to insert records into tables?
- What parts are you having problems with?
- What have you written so far?

 

[rainny]

ya, i install the MySQL already.

Now, the difficulties I face is I want to store the translated text
into database.
However, I don't know how to link with the database by using java.

The IDE used is NEtbean.
What I want is when I click the button, then the translated text can
store into the database.

Anybody know how to do it?

Thanks....

 

[Andrew Thompson]

ya, i install the MySQL already.

That word is 'yes'. The word I should always
be uppercase - always.

Now, the difficulties I face is I want to store the translated text
into database.

How is that a difficulty?
Which part of the process outlined by RGB
are you having trouble with?

Note that nobody here is likely to 'write the
code for you'. But if you make an effort and
hit a specific problem, then come back and
describe exactly what that problem is, there
will probably be people who can spot what you
are doing wrong.

But if you cannot manage that, I (again) suggest
you hire yourself a consultant.

However, I don't know how to link with the database by using java.

I don't think you have the faintest chance of
achieving (either part of) this task, on your
own..

Why not prove me wrong?

 

[RedGrittyBrick]

rainny wrote:

(omitted context reinstated)

[RGB wrote]

Storing text in a database is straightforward.
- Do you have a DBMS installed?

ya, i install the MySQL already.

- Have you designed a table structure?
- Can you write JDBC statements to insert records into tables?
- What parts are you having problems with?
- What have you written so far?

Now, the difficulties I face is I want to store the translated text
into database.
However, I don't know how to link with the database by using java.

The IDE used is NEtbean.
What I want is when I click the button, then the translated text can
store into the database.

Anybody know how to do it?

You didn't answer my other four questions. Please do.

Have you read http://java.sun.com/docs/books/tutorial/jdbc/basics/

 

[cfameen]

ya, i install the MySQL already.

Now, the difficulties I face is I want to store the translated text
into database.
However, I don't know how to link with the database by using java.

The IDE used is NEtbean.
What I want is when I click the button, then the translated text can
store into the database.

Anybody know how to do it?

Thanks....

@rainny

There are multiple things you have to do and know. As you explained I
understand that you need to store a text recognized from a recorded
voice into database table. So I think all you what you want is to
write Java desktop application that:
1- will keeps running in a system. ==> (you need to know how to run
Java program.)
2- record any speech through microphone and store in file. ==> (how to
record voice using Java and store in file.)
3- process/handle the recorded voice to recognize the speech. ==>
(speech recognition in Java.)
4- and after you got the word(s) in a variable, object, or whatever;
you need to store this word(s) into a database->table->record->field
that accepting text ==> (So for this you need to:
A-- Install Database System (MySql as you have)
B-- Create a Database
C-- Create a table in the database with the fields you want.
D-- Know how to connect to database in Java
E-- Know how to Insert a record into database table (using Java and
SQL).
)


I tried to summarize all the points for you as much as I can. Hope
that will help you to focus your questions or searches in a particular
point to help the people helping you.

 

[cfameen]

ya, i install the MySQL already.

Now, the difficulties I face is I want to store the translated text
into database.
However, I don't know how to link with the database by using java.

The IDE used is NEtbean.
What I want is when I click the button, then the translated text can
store into the database.

Anybody know how to do it?

Thanks....

ya, i install the MySQL already.

Now, the difficulties I face is I want to store the translated text
into database.
However, I don't know how to link with the database by using java.

The IDE used is NEtbean.
What I want is when I click the button, then the translated text can
store into the database.

Anybody know how to do it?

Thanks....

@rainny

There are multiple things you have to do and know. As you explained I
understand that you need to store a text recognized from a recorded
voice into database table. So I think all you what you want is to
write Java desktop application that:
1- will keeps running in a system. ==> (you need to know how to run
Java program.)
2- record any speech through microphone and store in file. ==> (how to
record voice using Java and store in file.)
3- process/handle the recorded voice to recognize the speech. ==>
(speech recognition in Java.)
4- and after you got the word(s) in a variable, object, or whatever;
you need to store this word(s) into a database->table->record->field
that accepting text ==> (So for this you need to:
A-- Install Database System (MySql as you have)
B-- Create a Database
C-- Create a table in the database with the fields you want.
D-- Know how to connect to database in Java
E-- Know how to Insert a record into database table (using Java and
SQL).
)


I tried to summarize all the points for you as much as I can. Hope
that will help you to focus your questions or searches in a particular
point to help the people helping you.

 

[rainny]

Hi, I answer your 4 question as following:

Yes, I design the table structure already.

No, the part I don't know is how to write the JDBC statement to insert
record into tables.
Refer to above answer.
So far,I have written until can key in all the data inside the
program.
But, how to store inside the database? This is the trigger part I face
now.

Besides, I am first time link the Java application to database, so I
don't know how to link to database and the code for inserting the data
into database.

Any helping? Please.

Thanks.

 

[Lew]

Hi, I answer your 4 question as following:

It helps to cite your quotes.

No, the part I don't know is how to write the JDBC statement to insert
record into tables.

Apparently you ignored RGB's advice:

Have you read http://java.sun.com/docs/books/tutorial/jdbc/basics/

Don't keep asking for more advice until you have followed the advice already
given.