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.
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.
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
13 freelance font une offre moyenne de $28 pour ce travail
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
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
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
Please review my profile. I have 7.1 years experience in SQL Server. Please let me know when we will start.
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
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
i have 6 years experience on Qt ,c++ and SQL, create database class using singleton design pattern.
I have great experience when comes to SQL programming. I have an idea on it, we can discuss over call/chat..
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
I ll give you a database table structure and i ll describe that how you can insert datas and query for datas
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