En cours

Advice needed: Best way of implementing a scenario in SQL database

Dear expert,

This small project is looking for a suggestion for the best way of implementing a scenario in database.

I have a asp.net C# website. I want to trace the movement of the user from page to page and store it in my SQL database. Currently I am creating a session variable which will be appending the name of the each page, every time a user browse through my site. Refer the following.

Say I have 5 pages.

1) mypage_1

2) mypage_2

3) mypage_3

4) mypage_4

5) mypage_5

If the user browse in the following sequence, 1, 3, 4, 2, 3, 5, my session variable looks like the following.

String usermovement = "user_donald->mypage_1->mypage_3->mypage_4->mypage_2->mypage_3->mypage_5

Once the session is expiring, this session variable is stored SQL database as a single string of text. Later when I want to trace the flow of user visited page, I read the database entry and split the sting based on the "->"

Even though it works, it is not the efficient way of storage in sql because it is hard for querying something of following sort.

select all users who moved from 'mypage_3 to mypage_4'.

With the current implemetation, I have to read the whole database with 100,000+ users string, parse it, order it and analyse it, which take a really long time.

Given this situation, what is the best way of achieving it? what is the right architecture to implement?

Thanks in advance.

Compétences : Programmation de bases de données

Voir plus : suspect sql database help needed, 339251 magento advice needed hour, advice writers needed, quick advice needed based programmer, health advice writers needed, relationship advice writers needed, best sql database designer worked, advice writer needed, writers needed love advice, backup sql database windows application, sql database schema stored, sql database schema stored procedure, web page sql database input, web front end sql database, deploy sql database sql express, repair wordpress sql database, dynamic link php sql database, net backup sql database, recieve sms text mesages sql database, import sql database web developer, javascript sql database, news scroller sql database, customer software needed, software needed, php programmer needed

Concernant l'employeur :
( 108 commentaires ) United States, Korea, Republic of

N° du projet : #12630798

Décerné à :

sumon355

Hello, As an database expert, i am very much interested to help you for your required scenario. I have a better plan which is definitely the standard way of doing this type of thing. Looking forward to have a positive Plus

40 $ USD en 2 jours
(4 Commentaires)
3.0

14 freelance ont fait une offre moyenne de 27 $ pour ce travail

Grunty

Hello, I can envision two methods worth considering, each one better suited to one of two diverging goals -- easy storage, as opposed to easy retrieval (query). If interested, I look forward to your awarding the proj Plus

25 $ USD en 1 jour
(2 Commentaires)
4.1
point5nyble

Hello, I have been working with a MNC based company since last ~ 6 years, as an IT BI DWH Professional. The project is a BI DWH project which covers 3 layers of BI (ETL, Data warehouse & Reporting) and helped me Plus

35 $ USD en 1 jour
(18 Commentaires)
4.4
shahzaib121

Hi Dear I have a lot of experience in DataBases ,Data Warehous,DB2 , Teradata etc . I am DataBases + Warehouse certified from Oracle,postgresSQL,SQL SERVER , Access. I have done many work in Requirements analysis , Plus

30 $ USD en 3 jours
(7 Commentaires)
3.8
mauricemarinus

Hi there.. You are right. Its perhaps not the best way to store it IF you want to query your database using standard query techniques but that doesnt mean to say it wont work ... :) I can definitely think of somethin Plus

15 $ USD en 1 jour
(1 Commentaire)
1.9
darwuin723

Programador innovador y visionario,trabajo con diferentes lenguajes de programacion tanto para web como para el desarrollo de aplicaciones [url removed, login to view] gusta crear proyectos innovadores que le entregen al cliente un plus Plus

55 $ USD en 2 jours
(0 Commentaires)
0.0
adudez96

The answer I propose is simple in theory. It should however involve a bit of an overhaul of your session storing in the database, and hence I may need a couple details regarding your database. I have studied algori Plus

24 $ USD en 1 jour
(0 Commentaires)
0.0
erndsglts

i have 6 years experience on Qt ,c++ and SQL, create database class using singleton design pattern.

25 $ USD en 1 jour
(0 Commentaires)
0.0
vw7590795vw

Please review my profile. I have 7.1 years experience in SQL Server. Please let me know when we will start.

10 $ USD en 5 jours
(0 Commentaires)
0.0
iNoorShaik

I have great experience when comes to SQL programming. I have an idea on it, we can discuss over call/chat..

10 $ USD en 1 jour
(0 Commentaires)
0.0
nirmalkumarpp

I have 7+ years of experience in analysis, design and development of client/server, webbased and n-tier application. Expert in developing web applications in Microsoft Visual Studio .Net IDE using C#.Net 2.0/3.5/4.0, W Plus

30 $ USD en 3 jours
(0 Commentaires)
0.0
themrah

I ll give you a database table structure and i ll describe that how you can insert datas and query for datas

25 $ USD en 1 jour
(0 Commentaires)
0.0
20 $ USD en 1 jour
(0 Commentaires)
0.0
asadiqbalse

Dear Sir/Madam, We already worked on this and ready to start the development after checking out the project details. We are specialized in web development, web design, mobile app development, Graphics Design, E-comm Plus

30 $ USD en 1 jour
(0 Commentaires)
0.0