Facebook has cooked into their search some features that are unique -- possibly some are patented, even? The features I speak of are driven by three distinct requirements: The fact that their database is gigantic, and they can't just JOIN their way over to the data they need as they need it, as you can, typically in a single-homed busi...
Hi all, I'm working with a pretty nasty looking, but non-changable db. We've got a table, called "Locations" with column, "Position" This column has values like "A SHELF 5" Which means "Case A, Shelf 5". In an ideal world, I'd have a Case and Shelf column, with the values "A" and 5, respectively. What I'm wondering, is if there's a...
CREATE TABLE IF NOT EXISTS `mydb`.`MATCHES` ( `idMatch` INT NOT NULL , `idChampionship` INT NOT NULL , `idWinningTeam` INT NOT NULL , `idWLoosingTeam` INT NOT NULL , `date` TIMESTAMP NULL DEFAULT NULL , `goalsWinningTeam` INT NULL DEFAULT -1 , `goalsLoosingTeam` INT NULL DEFAULT -1 , `played` CHAR NULL DEFAULT 'Y' ...
Lets say you are dealing with your normal contact database (you know... name, phone number, address, email, etc...). If you're concerened about this locally, it's generally not a big issue to deal with, but when we look at international sets it is. Looking at the phone number system, you would think it's simple, but it's really not. In ...
I want to allow users to create their resume online. Resume creation will have some steps. After first step resume will be saved. He can input data for other steps later on or he can move to next step after first step. Step 1 Personal Info: title name address phone email step 2 Employment History: career objective Recent position Prev...
Hello, I have a table with the following structure: WorkerPersons ------------------------------- ID (PK) PersonID (Indicates which version of Person the record describes) SomeColumn1 (data specific to Worker) SomeColumn2 (data specific to Person) .... SomeColumnN ------------------------------- As you can see, it's a den...
In the attached picture there's a symbol I don't understand. To understand additive functional dependency I need to know what the symbol means. Please advice? It's the symbol where it says: "Suppose that X ⊇ Y and that..." ⊇ = ? Thanks! ...
A college keeps details about a student and the various modules that the student has studied. These details compromise Registration number, Name, Address, Tutor Number, Tutor Name, Diploma Code, Diploma Name and repeating fields for module code and module name and result. Normalize the relation. ...
The SAT algorithm requires you to find the normal of each edge of each shape (essentially a vector perpendicular to the edge vector) to be used as the separating axes. This can be done very simply... (x,y) => (-y,x) OR (x,y) => (y,-x) Which should be used in the SAT algorithm? This is essentially a question of whether the left hand n...
hey all, i need help in a topic to which am a newbie. i currently registered for a pattern recognition course, i have this binary pattern given in the attached pic , and i am asked to find algorithms that will: -a) smooth the pattern -b) normalize the size of the pattern -c) correct its slant i am not asking for someone to solve it fo...
is this in 3NF ? create table movies( id numeric primary key not null default autoincrement, name varchar(50) not null, release-date Date, price numeric, rating numeric, length numeric, description varchar(1500) ); create table movies( id numeric primary key, name varchar(20) ); create table genre( name varc...
Hi, I am really struggling to normalise a Client Meeting form. The details are as follows Client_Name, Client_phone (Normalised) Date, Time, Location, Person_met, location, key_notes, Staff (repeating groups) In 1st NF, I know the Client_Name (given a client_ID key) would be the foreign key in the repeated group, but I don't know w...
I'm working on a API that will accept addresses in searches. We would like to use Google's geocoding service to normalize the addresses before submitting the search criteria to our search engine. This caught my attention: http://code.google.com/apis/maps/documentation/geocoding/index.html#Limits "Note: the Geocoding API may only be u...
I want to normalize PCM WAV files from client side(Silverlight). I am using ASP.NET MVC on the server side. And I found a C program here https://neon1.net/prog/normalizer.html Does anyone know that if there are similar C# libraries that I can use directly? ...
Here's a tricky normalization/SQL/Database Design question that has been puzzling us. I hope I can state it correctly. You have a set of activities. They are things that need to be done -- a glorified TODO list. Any given activity can be assigned to an employee. Every activity also has an enitity for whom the activity is to be perf...
Hi, I am trying to work out how to improve the scoring of solr search results. My application needs to take the score from the solr results and display a number of “stars” depending on how good the result(s) are to the query. 5 Stars = almost/exact down to 0 stars meaning not matching the search very well, e.g. only one element hits. ...
If I have a large table with a column which has a rather limited range of values (e.g. < 100), is it reasonable to divide this table into several tables with names tied to that column value? E.g. a table like with columns: table "TimeStamps": [Id] [DeviceId] [MessageCounter] [SomeData] where [DeviceId] is the "limited range" column w...
I have loaded a huge CSV dataset -- Eclipse's Filtered Usage Data using PostgreSQL's COPY, and it's taking a huge amount of space because it's not normalized: three of the TEXT columns is much more efficiently refactored into separate tables, to be referenced from the main table with foreign key columns. My question is: is it faster to ...
Hi guys, heres the situation. I have a table called as maps coordinates the schema is like below: map_coordinates: item | item_id | latitude | longitude The idea is that this table contains a list of coordinates of different items, they could be a note, a classifieds post, an event etc. I want to be able to set it up so I have a resul...
Hi everybody, Could I ask you about a SPARQL query on an Ontology. I have a family.owl file is the ontology build from protege 3.4 with data: Lan haschild Tuấn, Tùng haschild Tuấn. I use Java and CORESE API on site (http://www-sop.inria.fr/edelweiss/software/corese/v2_4_0/manual/index.php#coreseapi ) to query the family.owl above. W...