|
I have a huge database (3 million records) that I need to de-duplicate by street address every month. With non-conforming addresses like (123 S. Ventnor Blvd, 123 South Ventnor Boulevard NW, etc.), de-duping is a pain. I'd like to find an algorithm with whatever lookup tables are necessary to convert all of the addresses to USPS format like you find in CASS certified addresses, so they can be compared. Anybody ever done that and have some clues?
|
|
|
|
|
hi,
I am to develop a 2d self assembler as my college project... I searched a lot and found some many papers on this subject. But all of them are full of theory and none of them said anything about the implementation part...
Could someone help me with these or atleast direct me to some specific place where I can more info on 2d self assemblers.
Thank you
|
|
|
|
|
Sai Yasodharan wrote: I am to develop a 2d self assembler as my college project
You do understand that this means YOU are expected to do the work?
MVP 2010 - are they mad?
|
|
|
|
|
Are you kidding? It means he has to find a way to get it done. For sure self does not refer to him?
Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles]
I only read code that is properly formatted, adding PRE tags is the easiest way to obtain that. [The QA section does it automatically now, I hope we soon get it on regular forums as well]
|
|
|
|
|
I know I must do the work... I m just here to get some help or guide from the experts, who already played with 2D SELF ASSEMBLERS, if any. Also help in the sense not the program, just some info on how to start and which way to proceed
|
|
|
|
|
Sai Yasodharan wrote: I know I must do the work.
Well you could start by doing some research; remember Google is your friend and also the best starting place. It is almost impossible for anyone to respond to your question, these forums are for technical questions rather than teaching. The tutorials can be found in the published articles which you should also take a look at.
MVP 2010 - are they mad?
|
|
|
|
|
|
Hello Sirs,
How to find the compression type of jpeg, when we give one sample input jpeg file the output result is this image contains (ex.) xxxx compression type. How to identify it .?
please replay
 Failure is Success If we learn from it!!
|
|
|
|
|
Well it looks like you have to look up the Huffman table for the image it's marked at:
DHT 0xFFC4 variable size Define Huffman Table(s) - Specifies one or more Huffman tables.
A bit more can be found about this at this site:
JPEG Huffman Coding Tutorial[^]
The wiki explains it a little also:
JPEG Wiki[^]
|
|
|
|
|
Hi
I am planning to implement a custom version control system.
Is there anyway to represent physical directory structure in database?
Or should I represent them using 'tree' data structure?
If using tree data structure, how can I save the contents of tree to an external file??
thanks
fadi
|
|
|
|
|
Yes,
I have done this quite often there are several ways of doing this, it mostly depends on how you plan on searching the db or how you want to maintain the data. The obvious approach is to use a column file directory:
c:\mydir\thisdir\nextdir\and-so-on
This can make it a head ache if you need indexing.
The approach I used for indexing is to use a treemap where I had two colums a and b; a is the parent and b the child. you can build a directory structure this way easily. The problem with this approach is using SQL with it. You have to load the whole tree in memory in a tree map in the application then modify it and post it back or update the 'dirty' sections after you make changes to the tree.
|
|
|
|
|
i have model for intrusion prevention system i want to simulte it
|
|
|
|
|
What does this have to do with an algorithm? If you can explain that you might get an answer to your question.
|
|
|
|
|
I am attempting to symbolically determine the roots of the 6th and 7th order Legendre polynomials. I started this task by tackling the 6th order polynomial as follows:
P6 = 1/16 * (231x^6 - 315x^4 + 105x^2 - 5)
I first started solving this equation by substituting u=x^2 and went down the path of solving the resulting cubic equation for u, then taking the square root to convert the solution back to x. The first solution I came up with was:
±√[2/33 * (120 - ∛{-15/7 * [751323 - 11√(-3442911)]} - ∛{-15/7 * [751323 + 11√(-3442911)]})]
However, this equation yields the value 0.23982861022165, but the known good value is 0.238619186083197[^]
I tested the result I am getting using the calculator found here[^], and got the same result as my symbolic solution above (be sure to take the square root of the result to convert back to values of x instead of u). Does anyone know why I am coming up with the wrong answer here? I would really appreciate some assistance, as I have grown tired of staring at my solution, searching for the problem. Thanks,
Sounds like somebody's got a case of the Mondays
-Jeff
modified on Wednesday, January 13, 2010 4:32 PM
|
|
|
|
|
Nevermind... I'm just an idiot. Note to self: (x/16) * (16/y) != (16*x)/y 
The solution is actually:
±√[1/3 * (15/11 - ∛{-40/9317 * [9 + 11√(-54)]} - ∛{-40/9317 * [9 - 11√(-54)]})]
Thanks to anyone who was planning to help,
Sounds like somebody's got a case of the Mondays
-Jeff
|
|
|
|
|
|
That is a really handy site! You wouldn't happen to know how to determine the roots of higher-order polynomials to n-significant figures, would you? For example, when I plug in the following Legendre polynomial, I only get the roots to 6-significant digits.
(46189x^10 - 109395x^8 + 90090x^6 - 30030x^4 + 3465x^2 - 63) / 256
I can't figure out how to run this query so I get the "more digits" option for the roots. This isn't really an algorithm question, but I figured you may have some insight since you recommended that site. Thanks,
Sounds like somebody's got a case of the Mondays
-Jeff
|
|
|
|
|
|
Yes, there are a lot of really good math programs out there. if you know Python then go with Sage. If not I would go with Maximia.
~TheArch
|
|
|
|
|
Now ihave do this
select a from table_a where aa=123
select b from table_a where aa=32
select sum(aa) as c from table_a where aa=44
select sum(bb) as d from table_a where aa=88
i want to select them just use one SQL.not use union,because i want to show them like this :
a b c d
1 2 32 32
23 43 54 564
32 43 64 45
show four fields,not one,it's difficulty for me,i have done all day long,everyone who can teach me ?very apprciate!!
|
|
|
|
|
Cross posting is considered bad form here. Your question is SQL related and you've posted it the SQL forum.
You measure democracy by the freedom it gives its dissidents, not the freedom it gives its assimilated conformists.
|
|
|
|
|
Hi
Is there any algorithm to check if a binary tree
(not BST,just a binary tree with max two childs for each parent)
is AVL tree?
Regards
|
|
|
|
|
|
An AVL tree's height will be limited to 1.44*Log2(n), so why not calculate the height and then if it is over the max height then it's not AVL.
Here is a PFD to calculate the height:
AVL Trees[^]
Hope this helps....
~TheArch
|
|
|
|
|
Hi there, I have an algorithm which searches a graph for Hamiltonian cycles. A graph is a bunch of nodes, with edges (connected with probability p each). A Hamiltonian cycle is a path along the edges from one node back to itself- passing through each node precisely once.
My algorithm currently does the following procedure:
starts at node 1
tries to increase the path to 2 vertices, call it 1,final node.
Algorithm:
if final node in path has a neighbour not already in the path, extend it by going to the first neigbhour it has in a list
if final node has no neighbours then remove final node and search the list of (final node - 1) for other potential neighbours.
(output if Path has length n and final node is connected to node 1)
This algorithm has a worst case complexity of n!. I.e if there n nodes and it visits everypath but can't find a hamiltonian cycle.
But what would be the average case running time given n and p?
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
