Отменен

Data Usage Statistics

Given nothing more than a database (SQL Server, Oracle, mySQL, etc) produce a table of data usage statistics, as follows:

1) Use the database schema to figure outs its tables and columns

2) For each column, count the number of records that are filled in or missing

3) For each filled in column, count the number of occurances for each different value BUT only if the number of different values is below a certain percentage of totall number or records counted so far

4) Produce a table containing: Table, Column, Value, Number of Value occurances

As part of your bid, please indicate what tools/languages you intend to use. Please do not include algorithms, etc.

******************************************

Due to requests for clarifications, I'm attaching a txt file.

******************************************

## Deliverables

1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.

2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):

a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.

b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.

3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).

* * *This broadcast message was sent to all bidders on Thursday Aug 11, 2005 8:41:54 AM:

********************************************

To answer some of the questions asked, here is an update:

********************************************

For each table in the database an SQL script would need to be created, dealing with a given table and all of the fields in that table table.

Lets assume that one of the tables is "customer" and that it has 100,000 records with just the following 3 fields: Id (numeric), Name (text), Country (character).

Furthermore, lets assume that all of the customers are only in Canada (CA) and United States (US).

The final result would be a table of answers that would look something like this:

TABLE FIELD VALUE OCCURANCES

customer (blank) (count) 100,000

customer Id (null) 1

Id (zero) 1

Id (filled) 99,9 98

customer Name (null) 1,000

Name (blank) 2,000

Name (filled) 97,000

customer Country (null) 100

Country (blank) 200

Country CA 10,000

Country US 89,700

So, one of the tricks would be to first process a subset of say some 1000 records, in order to determine that there too many unique values for Id and Name fields and that they should be dropped from "unique value" counting.

In this case only (null), (blank) and (filled) would be counted - "filled" being all records with values other than null and zero (for Id) and blank (for Name).

In the above 1000 record subset the threshold might be 100 or less unique values per field. Both 1000 and 100 should be some sort of parameters.

The input is all of a tables and fields in a given database and the ou tput is one single table (with the above 4 columns) preferably in a newly created standalone database (as permissions might not allow its creation within the database being queried).

Using the above 100,000 record customer table with 3 fields, there would be just 100,000 "database hits" for records and not 300,000 of them.

Proecedurally speaking, one would get a record once, process it for each of the 3 fields and then process the next record, etc.

## Platform

Please make suggestions.

Навыки: Управление базами данных, Техника, Microsoft Access, MySQL, Oracle, PHP, Архитектура ПО, Тестирование ПО, SQL, Visual Foxpro

Показать больше: what is the use of package in oracle, what is oracle package, what is an algorithms, use case creation, text algorithms, statistics algorithms, sql code oracle, schema update, php script null, make a statistics site, get web statistics, data and algorithms, data algorithms, customer table, algorithms data, oracle sql number, b in statistics, statistics, statistics work, php oracle mysql, oracle data, get a coder canada, engineering statistics, character figure, c++ statistics

О работодателе:
( 0 отзыв(-а, -ов) ) Canada

ID проекта: #3844645

33 фрилансеров(-а) в среднем готовы выполнить эту работу за $187

asselsolutions

See private message.

$170 USD за 30 дней(-я)
(65 отзывов(-а))
7.1
shaddadfalcon

See private message.

$12.75 USD за 30 дней(-я)
(110 отзывов(-а))
7.0
ahmedkhalif

See private message.

$17 USD за 30 дней(-я)
(34 отзывов(-а))
5.8
contactvikasvw

See private message.

$85 USD за 30 дней(-я)
(112 отзывов(-а))
5.5
jeffreymcarthur

See private message.

$170 USD за 30 дней(-я)
(13 отзывов(-а))
5.5
genas

See private message.

$42.5 USD за 30 дней(-я)
(51 отзывов(-а))
5.3
excathedravw

See private message.

$255 USD за 30 дней(-я)
(12 отзывов(-а))
5.2
ExcellentJobs

See private message.

$85 USD за 30 дней(-я)
(31 отзывов(-а))
4.9
ruska

See private message.

$68 USD за 30 дней(-я)
(23 отзывов(-а))
4.7
russellsharp

See private message.

$85 USD за 30 дней(-я)
(10 отзывов(-а))
4.4
argeussolutions

See private message.

$127.5 USD за 30 дней(-я)
(5 отзывов(-а))
3.1
micah26

See private message.

$63.75 USD за 30 дней(-я)
(2 отзывов(-а))
2.2
dobrinescu

See private message.

$42.5 USD за 30 дней(-я)
(2 отзывов(-а))
1.5
gargvipul

See private message.

$93.5 USD за 30 дней(-я)
(2 отзывов(-а))
0.3
gustavogils

See private message.

$212.5 USD за 30 дней(-я)
(0 отзывов(-а))
0.0
robertobidinski

See private message.

$2125 USD за 30 дней(-я)
(0 отзывов(-а))
0.0
darshv

See private message.

$76.5 USD за 30 дней(-я)
(0 отзывов(-а))
0.0
hvgy2k

See private message.

$17 USD за 30 дней(-я)
(0 отзывов(-а))
0.0
terminatorhvm

See private message.

$42.5 USD за 30 дней(-я)
(0 отзывов(-а))
0.0
stephanporancea

See private message.

$467.5 USD за 30 дней(-я)
(0 отзывов(-а))
0.0