Find Jobs
Hire Freelancers

Adress-Database & Data-Management

€30-250 EUR

Completed
Posted over 9 years ago

€30-250 EUR

Paid on delivery
We have a Dataset of 500'000 records from different sources. These records have to be normalized and assigned to categories, according to NOGA 2008 (General Classification of Economic Activities). For more information about NOGA, see this link: [login to view URL] The goal is to store all raw records in a database and assign it to minimum one NOGA-Category. The result must be possible to find all records related to a category-search. Each record MUST match a category and must be assigned accordingly. The raw records are stored in a CSV (see attachment). The attributes are Name\tZip\tLocality\tCategories. The Data-File is anonymized. Some lines are empty, they have also to be categorized. If more than one category matches, they have to be separated by a pipe "|" This project is one work package out of many and can be considered as entry-point for more work.
Project ID: 6753385

About the project

23 proposals
Remote project
Active 9 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Hi, The database is ready (it is in SQL Server 2014). Here are a few screenshots: [login to view URL] [login to view URL] There are however, 101966 records that don't have any category in your text file. How should I handle those? Should a create an "Uncategorized" default category? Please contact me to talk details. Best, Sergiu
€100 EUR in 0 day
5.0 (2 reviews)
2.6
2.6
23 freelancers are bidding on average €190 EUR for this job
User Avatar
A proposal has not yet been provided
€277 EUR in 3 days
5.0 (100 reviews)
7.6
7.6
User Avatar
hi. I've 2 years experience working with C#. I have already built applications using databases (MySQL, MS-SQL, MS-Access etc) and I have also built applications to utilize CSV, Text and Excel files. I can create a database for you and also an application which will pick all the records from the CSV or Text file and store them into the database. I have a few questions in my mind and I would like to discuss further with you before we begin. I'm very interested in this task and I have the skills to accomplish it for you. let's do it. I like to have long term working relations with my employers and I have been successful with it. hope to have a good business with you :) waiting for your response...
€250 EUR in 7 days
5.0 (96 reviews)
6.9
6.9
User Avatar
Hello, Well, I did get a great practical experience with SQL databases (mostly with MS SQL Server and SQLite), so I could utilize some of my code snippets and ready-to-use code blocks for your project as well. Regards to this particular project... The database could be pretty simple for now. So there should be a table tblCategory with some category ID as a primary key and the table, say, tblRawRecord with records referenced to these IDs (may be different implementation). Then, a simple SQL request could extract/search all raw records for a specified category(categories). The table tblCategory will be populated in the process of the loading/inserting if these textual raw records into the database. There will be checking for unique of a category name during the process of loading. Ok, it's brief description only, we could discuss more details after start the actual work for this project. More things will be more clear after we design/implement the database schema. By the way, it sounds very interesting for me if we could continue our collaboration for your further tasks/projects. Bye.
€222 EUR in 5 days
5.0 (31 reviews)
6.4
6.4
User Avatar
Hi, I have gone through your project description in detail and feel comfortable in taking it forward. I can help you in normalizing and categorizing shared data in the database and you can have form for maintaining data and also related reports of it. For the purpose of project, I will use MS Access database as development tool. Waiting for your response to talk further in detail and plan out work activity. Thanks.
€188 EUR in 5 days
4.9 (103 reviews)
5.9
5.9
User Avatar
Hi, Myself dinesh expert in asp.net, c# and sql server with 10 yrs of experience in software development. Developed various web applications for finance, insurance , education and research domain. Let me know your requiremnet in detail. Awaiting for your positive response. Thanks and regards...dinesh.
€250 EUR in 3 days
4.6 (27 reviews)
5.5
5.5
User Avatar
Hi, Please feel free to discuss the project with me ............................................................................ Thanks, Murtaza
€250 EUR in 3 days
5.0 (11 reviews)
4.5
4.5
User Avatar
A proposal has not yet been provided
€155 EUR in 3 days
4.7 (14 reviews)
4.1
4.1
User Avatar
Hi. I am a Senior .NET Developer living in Paris, I have read your specifications and i want to help you to realize your project. I have habit to manager ad organize data from several source and format.. I invite you to see in my folio the kind of application i have realize for an idea. You can contact me for any questions else. Kind regards
€130 EUR in 3 days
5.0 (5 reviews)
3.3
3.3
User Avatar
Предложение еще не подано
€194 EUR in 7 days
5.0 (5 reviews)
3.0
3.0
User Avatar
Hi, Though I'm an occasional freelancer, but what I do, I do it with utmost passion. I'm programming since my age of 13. I'm a First Class First Computer Engineer and have participated in numerous programming contests. Algorithm is one of my area of interest. I don't freelance for money, because I am a faculty member in a university and I teach algorithms and database management. Some things need to be clarified: 1. Which database system do you require to be used - MySQL or SQL Server? 2. Do you want it as a web application or desktop application? 3. Do you require to build a front-end for the system, or just an API? 4. How would I assign a category to the records with no category? Your attached link does not clarify it. 5. How do you want the normalization? As an OLAP (analytical) or OLTP (transactional). As I found in the data file, Name and Zip has Many to One cardinality, Zip and Locality has Many to One cardinality and Name to Categories Has One to Many cardinality. What do you think of the following table schemas? 1. Categories(cat_id, cat_name) 2. Zips(zip, locality) 3. Locality(name, zip) 4. Records(name, cat_id) If you expect to search the records using the category as the key, then I think these schemas should do the job faster than any other.
€166 EUR in 3 days
5.0 (1 review)
2.2
2.2
User Avatar
A proposal has not yet been provided
€222 EUR in 3 days
5.0 (1 review)
2.4
2.4
User Avatar
This is Amol working as Business Development Executive in a leading Website Design & Software Solutions company based in Nashik, India. Development Executive in a leading Website Design & Software Solutions company based in Nashik, India. Thanks MDA TECH SYS
€111 EUR in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Dear Sir/Madam, We take projects on following. We have a dedicated team of 7 developers on below technologies Programming Languages: C, C++, C#, MATLAB, Java, php Databases: SQL Server 2005/2008 R2, MySQL, Oracle 10g Web Services: Web Services, WCF Web Server Technology: HTML5, CSS3, JavaScript, ASP.NET IDE: Visual Studio 2008/2010/2012/2013, Android Studio, phpStorm, MPLABX, KEIL, MATLAB Design Pattern: MVP, MVC, MVVM, Observer Pattern UI: WPF, WinForms Markup Language: XML Logging: log4Net 1.2.13 Regards APlus Intellisoft Solutions Pvt. Ltd
€155 EUR in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello Myself Vivek D. I would like to tell you I have experience of 6 years in Software Development and can assure you to complete your work with less cost and accuracy.
€155 EUR in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
This is my first bid in freelancer. I have 10+ years of software development experience. I am eager looking for my first opportunity to make a mark on freelancer.
€155 EUR in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
i did applications using c# and xslt , i learned sql and C# programming and i have an experience in these language ,i will do my best to achieve this task on time
€155 EUR in 3 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of SWITZERLAND
Zurich, Switzerland
5.0
6
Payment method verified
Member since Feb 9, 2012

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.