1
Search for correlation of tables
source link: https://www.codesd.com/item/search-for-correlation-of-tables.html
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.
Search for correlation of tables
advertisements
Have these two tables:
TableA
ID Opt1 Opt2 Type
1 A Z 10
2 B Y 20
3 C Z 30
4 C K 40
TableB
ID Opt1 Type
1 Z 57
2 Z 99
3 X 3000
4 Z 3000
What would be a good algorithm to find arbitrary relations between these two tables? In this example, I'd like it to find the apparent relation between records containing Op1 = C in TableA and Type = 3000 in TableB.
I could think of apriori in some way, but doesn't seems too practical. what you guys say?
thanks.
It sounds like a relational data mining problem. I would suggest trying Ross Quinlan's FOIL: http://www.rulequest.com/Personal/
Related Articles
Searching for a Parallel Table in Python
This is a homework question, I got the basics down, but I can't seem to find the correct method of searching two parallel arrays. Original Question: Design a program that has two parallel arrays: a String array named people that is initialized with t
search for a 2d table in python - best method + indentation error
I have created the following 2d array (list of lists) in Python: #creating a 2d array (3 rows by 7 columns) and populating it with numbers matrix=[1,2,3,4,5,6,7],[8,9,10,11,12,13,14],[15,16,17,18,19,20,21] rows=len(matrix) #finding the max number of
Searching for a MySQL table using PHP
I am trying to create a PHP file to help search a table built in MySQL from a webpage. I have built the form, which allows the user to enter keywords into two of the search criteria and a drop-down menu for the third. However, I am having trouble wit
Search for an entire table? PHP MySQL
I have made the following search script but can only search one table column when querying the database: $query = "select * from explore where site_name like '%".$searchterm."%'"; I would like to know how I can search the entire table(
How do I search for a lookup table without loading it in memory?
Now I have a file recording the entries of a lookup table. If the number of entries is small, I can simply load this file into an STL map and perform search in my code. But what if there are many many entries? If I do it in the way above, it may caus
Search for a JSON table in Oracle
I'm trying to use the new JSON features introduced in Oracle 12.1.0.2 However I can't seem to find a way to look for a specific value in an array inside my JSON document. Consider the following table and data: create table orders ( id integer not nul
You are searching for SQL Server table design serenity checking for profile tables with dynamic columns
DOES IT MAKE SENSE TO GENERALIZE A PROFILE TABLE FOR TWO DISTINCT PROFILES IN THE SYSTEM, IN MY CASE, TEACHERS AND STUDENTS? I am doing this and just want a general sanity check regarding my design approach. Responses appreciated. Background below: W
MySQL: search for a simple table, but combining the WordPress table 'wp_usermeta' with meta_key / meta_value
As I mention in the title, I'm doing a request for latitude and longitude within a 'bid_userloc' table ... but I need to combine information from the 'wp_usermeta' table ... SET @centerLat = '48.531157'; SET @centerLng = '-123.782959'; SELECT *, ( 39
The code EF 4.1 first searches for an old table that no longer exists
I am using Entity Framework 4.1 code first. I had a table in the database with the name MaritalStatus. I deleted it and created a new table in its place called MaritalStatuses. Whenever I try to get all the records from the table I get an error: Inva
Search for data in table using ajax in ASP.net MVC
I want to display data in a table based on the search criteria in a textbox. I have implemented it without using Ajax but do not know how to call controller method using jquery and update table data. Please try to solve my problem. Thanks... Index.cs
T-SQL query to search for tasks and tables
I want to find the sql server agent jobs that operate upon a particular table. For ex: I have a table called TAB1 which is updated daily by a job called SAJ1. I need a query to extract this information.You can start with this select if the job step i
Search for a nested table for certain criteria
I have a report document that has an images array in it. Inside each image is a thumbnails array that track the thumbnails I have generated for the image. { "_id" : ObjectId("536021ba9b319f5195000004"), "images": [{ "nam
Swift: Binary search for a standard table?
I have a sorted array and want to do binary search on it. So I'm asking if something is already available in Swift library like sort etc.? Or is there a type independend version available? Of course I could write it by my own, but I like to avoid rei
Mongo search for the longest tables inside the object
I currently have objects in mongo set up like this for my application (simplified example, I removed some irrelevant fields for clarity here): { "_id" : ObjectId("529159af5b508dd71500000a"), "c" : "somecontent", &qu
Recommend
About Joyk
Aggregate valuable and interesting links.
Joyk means Joy of geeK