Find Jobs
Hire Freelancers

Adress-Database & Data-Management

€30-250 EUR

Terminado
Publicado hace más de 9 años

€30-250 EUR

Pagado a la entrega
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.
ID del proyecto: 6753385

Información sobre el proyecto

23 propuestas
Proyecto remoto
Activo hace 9 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
Adjudicado a:
Avatar del usuario
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 en 0 día
5,0 (2 comentarios)
2,6
2,6
23 freelancers están ofertando un promedio de €190 EUR por este trabajo
Avatar del usuario
A proposal has not yet been provided
€277 EUR en 3 días
5,0 (100 comentarios)
7,6
7,6
Avatar del usuario
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 en 7 días
5,0 (96 comentarios)
6,9
6,9
Avatar del usuario
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 en 5 días
5,0 (31 comentarios)
6,4
6,4
Avatar del usuario
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 en 5 días
4,9 (103 comentarios)
5,9
5,9
Avatar del usuario
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 en 3 días
4,6 (27 comentarios)
5,5
5,5
Avatar del usuario
Hi, Please feel free to discuss the project with me ............................................................................ Thanks, Murtaza
€250 EUR en 3 días
5,0 (11 comentarios)
4,5
4,5
Avatar del usuario
A proposal has not yet been provided
€155 EUR en 3 días
4,7 (14 comentarios)
4,1
4,1
Avatar del usuario
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 en 3 días
5,0 (5 comentarios)
3,3
3,3
Avatar del usuario
Предложение еще не подано
€194 EUR en 7 días
5,0 (5 comentarios)
3,0
3,0
Avatar del usuario
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 en 3 días
5,0 (1 comentario)
2,2
2,2
Avatar del usuario
A proposal has not yet been provided
€222 EUR en 3 días
5,0 (1 comentario)
2,4
2,4
Avatar del usuario
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 en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 en 5 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 en 5 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 en 3 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de SWITZERLAND
Zurich, Switzerland
5,0
6
Forma de pago verificada
Miembro desde feb 9, 2012

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.