Database Application Design Recommendations?

Mar 22, 2012

The main purpose of the my app that I need your help with is, to deliver an always (or close to) up to date a list of files for the user to choose from for a variety of common purposes. For instance, opening the selected file in its native client editor application so the user can make changes. Another purposes would be to print the file, and I have others.

If nothing else (meaning recommendations for a better design that still keep my desired in mind) I'd like ideas on how to update my complex DataSet (background processing options, what's the most efficeient/quickest way to update my DataSet) as the list of files changes while my app is running and my app is designed to never close due to the long amount of time it take to load it initially.

The list must be always kept up to date while my app is running because not only the intial loading of data takes a lot of time but updates (new/modified/deleted) could potentially take too long depending on not only how much data to update/add (new files) but how efficeient my code is in updating the list. To be perfectly clear: If a new file is created then it need to be somehow (automatically preferably or manually i.e. button code) add to the list. If a file is deleted then it needs to bet removed from the list. And if the file has changed, perhaps some of it metadata or thumbnail image have changes so update the file's data in the list. All of which (new/modified/deleted) need to be as real-time as possble without degrading the server too much and without the user waiting more than a handful of seconds.

Listing all the files as quick as possible whether that be with or without metadata initially is very important because most of the time the user is going to filter (or scroll the list by typing) for a partial file name. Once the user filters/scrolls to the desired file there's a very good chance that he/she isn't even interested in the metadata, most of the time the user wants my app to open the selected file in its native client editor application so he/she can view or modify the file. The initial
load time of the data doesn't concern me as much as updates because the user can possibly do other things while it initially loads all the data as long as it not too long (more than a few minutes). From there the updates will either be automatic if possible (most desirable from a users standpoint) or the user initiated (e.g. button). Plus I'm thinking the updates might need to be done with a few different background processes (multiple threads) because I think I need one for periodic updates (e.g. every
15 minutes) and one background process for page updates meaning whatever the user has either scrolled to or filtered for, more accurately all files currently display to the user will be systematically update in the background so the user can still operate my app.

I'm currently using SqlDataAdapter.Fill to fill a DataSet object variable (which is bound [BindingSource] to a DataGridview control) to first populate the DataSet from the SQL query and then prorgammatically adds records (DataRow) for local files but please make recommendations. I don't mind big changes or starting over if necessary, I just want the best app possible based on the aforementioned criteria. I'm not sure if it complicates matters but I've also added custom columns in the DataSet for some special needs (thumbnail of files, booleans for tracking custom statuses). For the local files I'm currently populating the DataSet prorammatically (iterating a path/file string collect made by System.IO.Directory.GetFiles) since the list is first (and very quickly) populated with Vault files (which is always a far larger list than the local files) so . Again, I don't have to take this direction, make recommendations.

View 11 Replies


ADVERTISEMENT

Students Trainings Windows Application - Database Design ?

Nov 24, 2010

I am developing a new application for Students Training. how the database design should be? And could you provide a sample application similar to my requirement? Following is the requirement of the Application, The objectives of the program or application are:

Get Information about the total number of students trained in all company's department

Get Information about the total number of students who were either withdrew/ apologized /rejected

Anticipate of the future needs for student's work placement opportunities (numbers of students as well as the majors)

On light of the objectives mentioned above I consider the following data for the application preparation: Company's Department Needs Department Major Number of students for each major Supervisor Mobile Number

If it is possible when entering students details the program will automatically register him/her in the Department that has vacant place and already fit the requirements of the certain department-Internship Information.

View 11 Replies

Database - Design And Deploy A Data Driven Desktop Application?

Jun 28, 2011

I am designing a desktop application that will be driven by local data. I am trying to determine the best way to accomplish this. The database would contain about 10-12 tables if I use a database and I would imagine no more than 10000 records in any one table (but honestly 99% of users would not have more than 1000 records). I am thinking about using SQL Server Compact.

Is this a good solution? I can certainly include this in my installation, but I am just wondering if anyone knows of a better solution? If this is the best solution, how would you suggest that I create the tables upon deployment? Should I just run "queries" with create table statements in them from my vb application or include a database file or what?

View 1 Replies

Recommendations For Zone OCR SDK's?

Mar 24, 2011

recommend a zone ocr sdk package. What i would like to accomplish is to automatically import a set of images, pdf or jpg, and then apply zone ocr to each image to extract data into a database. I have already looked at and spoken to Lead Tools and it does seem like they have everything that i would need but by the time you add up all the modules / addons needed, the cost is just too high for our small shop.

View 3 Replies

VB Book Recommendations

Aug 2, 2009

I was wondering what books/items you guys would recommend to read in regards to VB programming and/or programming in general.

View 9 Replies

Database Connectivity - Design The Database In Access2003 And Forms

Jun 3, 2010

I m working on an school management application, i design the database in access2003 and forms in vb.net2005. but i dont have any idea about the database conectivity. with the help of a book to connect with the db but i cannot save the data in the mdb file. in my application 1 add the followin buttons add new record modify record delete search using id or enrolment no.

View 1 Replies

Animation Control Recommendations?

Apr 3, 2011

What would you recommend as an easy-to-use animated .gif control?

View 2 Replies

Build Machine Configuration Recommendations?

Aug 21, 2009

We have a new build machine to start using for our programming team. We are still trying to figure out how we want to organize everything to get the best configuration for building EXEs and DLLs.

We are using VB6 and VB.Net 2005, and VSS2005.

We were thinking of making working folders set for each project, release and support tickets. Does anyone have experience with a similar set up? What were your likes/dislikes?

View 2 Replies

Education Recommendations For Visual Basic

Apr 19, 2009

I am a student a couple of weeks from completing my first Visual Basic class. I have a 100% score so far. Plus I am really enjoying the class and learning VB. We use Visual Studio Professional 2008 at school. I have also installed that product on my own pc from the DreamSpark site. I'd like to continue my education with VB. However, there are no classes this summer in VB at school. I was wondering if there might be some online tutorials or books that I could use to keep moving forward. I have good discipline for learning without being in a classroom.

Generally, what I like is something that shows the key points about a new topic. Gives an example of how the topic might be used in an application. Shows a code sample or two. And then gives programming assignments that use that topic. So that I can then write the applications. One of my educational goals would be to start through the Microsoft Certification process.

View 1 Replies

Text / Reference Book Recommendations?

Sep 7, 2011

I programmed in Basic, Fortran and PL1 many years ago. I now am developing a complex Excel application that needs use of VB macros. I've recorded and modified several VB macros so far, but have gone beyond my skill level trying to use VB indexed variables that link back to a spreadsheet. What text/reference book would you recommend for my level of skill? I'm not trying to become an expert -- just need help with approaches and correct syntax to simple programming issues if, while, indirectly addressed variables, etc.

View 2 Replies

C# - Recommendations For A Hex Viewer Control For Windows.Forms?

Mar 25, 2010

I need ability to display content in Hex View, like this from WinHex

Offset 0 1 2 3 4 5 6 7 8 9 A B C D E F
00000000 EF BB BF 0D 0A 4D 69 63 72 6F 73 6F 66 74 20 56 ..Microsoft V
00000010 69 73 75 61 6C 20 53 74 75 64 69 6F 20 53 6F 6C isual Studio Sol

[code]....

View 3 Replies

Design For .NET Scheduler Application?

Jan 27, 2010

I wish to develop an application in VB.NET to provide to following functionality and hope you can give me some pointers on which direction to take.I need some kind of "server" type component which sits in the background monitoring request from users and performing various task. (this component can be install locally or centrally)
The users submit an instruction to the "server" to perform a certain task at a designated date and time. (or perform the task straight away)

The "server" would perform the task at the desired date and time and inform the user the result of the task.I have thought of using a central database to which the user writes the instructions. The "server" could read from the database to obtain the instructions, and write the result back to the database.

I want a fast reaction to the instructions, so the "server" must poll the database every few seconds; I fear this may be detrimental to performance. Also how do I get the server to perform the task at the desired time? Again checking all outstanding tasks against the current time is not very efficient, so I thought about utilising the Windows Scheduler, but I am not sure of the best way of integrating this functionality.

View 2 Replies

VS 2008 Application Design Opinions?

Sep 17, 2009

I am making a small application for a friend, to help her update her website. The website is a very simple one, using a menu (table of links) in one frame, and the content in the other frame. The content consists merely of pictures, with some information (text) below each picture. Because my friend has no clue how to change her website (let alone upload it and the images to the right FTP folders), I decided to make an application that does that for her.

I had decided on the following design, but now I'm having second thoughts whether or not it's a good idea:

1. I use a Database to store the information and path to each picture.

2. I generate the content HTML files completely from scratch every time an update is required, retrieving the image path + info from the database and generating the correct HTML code from it.

3. I save the HTML files and upload them + all the images they use to the FTP.

She can now add, remove and/or edit any items in her website, in each category, and it works fine at the moment. But there are a few problems:

1. When she decides to remove a picture (from the database), the actual image will stay on the FTP server. She only has a maximum of 100 MB capacity, so having 50 unused images on there is not very efficient. To remedy this, I simply remove all the images before uploading the new website, so there will only ever exist the current images.

2. When her site gets larger, the amount of images will increase, possibly to about 80 MB. I don't think she'll want to wait for 80 MB in pictures to upload when she only changed a typo in one of the picture's descriptions.In the past, the whole site is uploaded at once without considering which changes were made, so that wasn't very good. I decided to keep track of which categories were changed, and only upload the categories that have been changed. This reduces the amount of images to upload, but there still could be around 10 MB in a single category, which is acceptable but still not ideal.

3. The images she has chosen have to remain on her computer, because they are uploaded again every time she updates here site. If she removes them, they will not be found and cannot be uploaded. Now, the images would still be on the server, so there really isn't any need for her to keep the images. But, due to point 1, they get deleted, so I don't have them anymore.

View 2 Replies

Multilingual Database Design In Sql?

Jan 11, 2012

Need a procedure in SQL for translate a datatable in English to Arabic .I am having English table which is having category ID ,Code etc upto 25 columns in the SQL Database.We want to translate this table to arabic when user opts for Arabic .So need a procedure to convert this English table to Arabic.Do i want to use google translator for this case . Then how will it is linked with database .

View 1 Replies

Application Design Suggestions For A HotKey Manager?

Jul 12, 2011

I simply want to create an application that can save each n every keystroke pressed from the keyboard and then user will be able to assign it a hotkey. And then whenever user presses that hotkey the data that is relevent/linked with that hotkey should be pasted into the active window e.g. notepad, ms word, email etc. I have developed it on my own everything is working fine but whenever I hit the assigned hotkey it wont stop sending data to the active window maybe because of timer.

View 8 Replies

Change A Classic Windows Application Design NET?

Jun 21, 2010

Using visual studio 2008 environment, i would like to change a classic windows application design, so i'm wondering if there is an idea a bout this. i've find some skins like irriskins ( www.sunisoft.com ), but i'ts not what i'm looking for.

View 1 Replies

FAQ Describing Its True Advantages In VB Application Design?

Jul 7, 2011

I simply leave the GUID text blank in Properties/ Application. Can someone give the advantages of using the GUID? I have done a few searches on Google and VBFORUMS but have not found a FAQ describing its true advantages in VB Application design.

View 3 Replies

Design Id Card Using Data From Database?

May 18, 2012

i try using both detail view and form view but they are not flexible enough to place my picture where i want it

View 1 Replies

Design Pattern For Database Interaction?

Mar 12, 2012

I've been studying design patterns off-and-on now for a project I've recently been working on. I've been fortunate with this last one not to have to work with databases, but will soon have an opportunity.

View 8 Replies

Sql Server :: Database Design And Normalization?

Mar 29, 2011

I am developing an "AddressBook" like project in VB.NET. While developing database in SQL Server2005, i want to follow the principals of normalization and keep its degree of normalization as high as possible. Fields i am using are these.

Create table AddressBook_Contact
(
Contact_ID int Primary Key,FirstName varchar(15),MiddleName varchar(15),LastName

[code]......

View 3 Replies

[OOD] Class Design For With Database Back End

Feb 6, 2010

I was hoping that I could get some guidance from some of you guys on Object Design with Database back ends. I am trying to build what could be considered to be my first full scale application, which is a student tracker (simplification). While I have a reasonable idea of how I would go about designing the classes for the system, the bit that I don't know how to do is, how I would go about getting the data to and from the database.

For example with my other applications, I have done a couple of things;

1) Gathered all the data when the application started up, creating the objects then. Then when the application closed sending the data back to the database.

2) Have the code which deals with getting the data in the specific class, so the student class for example would take only one constructor argument which would be the studentID, then the class code would connect to the database and populate the object fields as appropriate.

3) Variations of the above. I have also looked into LINQ, which seems like it would be very useful if you don't expect your classes to deal with any business logic and just data, but I suppose it would be possible to create a wrapper class that would include the business logic.

[Code]....

View 1 Replies

[OOD] Class Design For With Database Back End?

Mar 11, 2010

I was hoping that I could get some guidance from some of you guys on Object Design with Database back ends.I am trying to build what could be considered to be my first full scale application, which is a student tracker (simplification). While I have a reasonable idea of how I would go about designing the classes for the system, the bit that I don't know how to do is, how I would go about getting the data to and from the database

View 3 Replies

C# - Class Design For Reports In .NET Application That Use A Conglomeration Of Data?

Jul 20, 2011

I can articulate my question well enough to get some clear and usable feedback here. I have reports (like paper reports) in my .NET application that have data bound to them. Typically the reports are a combination of many data elements across several busniess entites that may not all relate through an Inheritance hierarcy, etc. This makes it difficult to get all the needed data placed together to bind to the report.

So what I have done before are make 'Report' classes with data elements specific to supporting the reports they are bound to, and on the back end might be tied to specially created Stored Procedures that bring this data back (maybe several joins across many tables to get the right data needed). So if I was to make an analogy to the database world, I am essentially 'denormailizing' the data structure to get all of this data into a single class to make it easy to bind to the report.

However on the hard line OOP concepts and architecture design, one could say that a report is just another 'thing' to bind data to, and its class should not be designed just to suit the needs of data binding. In this thought process, I would actually need to make my class design be able to create the relationships needed to get all of the data together properly to still be bound, but not create any special 'Report' classes. I find this difficult to do sometimes. It is much easier to create these relationships in the back end stored procedures and then just output the resultset to be almost immediately bound to the report.

So what is the right way to solve this? If I create these specialized report classes with really no behavior, am I introducing an anti-pattern like the Anemic Domain Model?I could use some feedback, and please speak up if my question and scenarios did not make sense.

View 1 Replies

Design Templete Of Application Software That Name Is InsordOutword System

Jun 21, 2010

I need the design templete of the application software that name is InsordOutword system..

View 1 Replies

IDE :: Design An Application In 2005 That Will Retrieve Pictures On A Form?

Aug 29, 2010

i need to design an application in visual basic 2005 that will retrieve pictures on a form. PS: All pictures should be located in a combo box! And the number of pictures are 2000.I've started with cmb.Items.Add("pic1") but that really tiresome to write 2000 codes.

View 9 Replies

Make An Application For Beta Testers In Design Group?

Sep 6, 2011

I'm trying to make an application for beta testers in my design group so that they can easily send their reports back to the developers. Designing the user interface is not the problem.it's the coding. What I want to do is let the user select a radio button for the project they are testing, then fill in some text fields, select options, etc regarding the project tests, then when they are done, click "submit" and it will either send the data to a specific email address (internally coded, not input by the user) or send the data in a text file to a directory on my server. (whichever method works/is easier) I'm not the best programmer, so don't yell at me if I'm slow to understand anything, LOL.

View 3 Replies

Create Database User Interface Design?

Mar 31, 2012

I am designing a database using access 2010 and I ve been asked to design the user interface with Visual basic.I actually have designed tables and their relationship and did some queries according to the requirements. how do I create user interface in VB from this point knowing I don't have any form and report designed in access?

View 6 Replies

Design Approach For Utilizing Data From A Database

Nov 6, 2011

There exists a database that holds information on each planet in the solar system. The database has multiple tables.The program intends to access this data to display it to the user in a variety of manners. The program does not intend to manipulate the data at its source, though calculations on two fields may be performed to determine certain display characteristics.What is the optimal method for accessing the data?My initial approach, (read: gut feeling, no research) was to take each related row of data from the database and create an object of a custom class based on the data. So you might wind up with:[code]Then use these objects to perform whatever actions the program needed to. I ran into a lot of problems trying to implement this, so that I believe my design approach is fundamentally flawed.

View 1 Replies

Loop/design - Looping Through A Database With Pdf Locations

Sep 14, 2011

I am looping through a database with pdf locations. The application is button click event driven. The problem I am having is that I display a pdf. If the user clicks on the button then the pdf information is inserted into a database and the loop should be taking me to the next pdf. However, this loop does not seem to give what I need. What ends up happening is the first pdf gets displayed twice. I think mainly because I display the first pdf onload, but when I click the button it agrees and grabs the first item from the database. And it ends up falling behind because its restarting the query and I cant quite figure out how to get the button to catch the first displayed pdf, or skip it entirely since I am using a welcome pdf. So on the welcome pdf that is supposed to be displayed initially the user clicks agree and it agrees to the welcome pdf instead of just skipping it. I am not quite sure how to just move past the pdf.

public sub onload()
display the welcome pdf
end sub

[CODE]...

Now if I run the code without the loop it works fine. I just end up having to run the app however many pdfs I have in my database.

query data
display data
insert data
Windows.Forms.Application.Exit()

To display pdfs I imported the com control for adobe so pdfs get displayed like this:

axacropdf1.src = my.mysettings.default.readpath & pdflocation

pdflocation is passed from a query fill.

I think I have an underlying design issue which probably precedes the loop.

View 4 Replies

Screen Interface And Database Design View?

Apr 3, 2012

I am using visual studio 2008 professional edition, and i need some help in my assignment project.below are my screen interface and my database design view, relationship view, and coding and this is my coding Private Sub Button3_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button3.Click

[Code]...

View 3 Replies







Copyrights 2005-15 www.BigResource.com, All rights reserved