Terminé

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

en 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 :
( 123 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

%selectedBids___i_sum_sub_7% %project_currencyDetails_sign_sub_8% USD en 2 jours
(10 Commentaires)
4.1

13 freelance font une offre moyenne de $28 pour ce travail

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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(22 Commentaires)
4.7
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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(3 Commentaires)
4.2
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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(11 Commentaires)
4.1
vw7590795vw

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(1 Évaluation)
2.4
darwuin723

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% 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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% 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.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(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..

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% 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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% 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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)
0.0
%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% 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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)
0.0