Hi Everyone,
I need an opinion here on storing data for a program I am working on the
processes DICOM images. Essentially, my program stores 25-45 (it varies
depending on the user) ranges of pixel values to search the image for.
Currently, I am using a .MDF database that requires SQL Express to be
installed. For only 25-45 records it seems like overkill to me. That
being said, I love the ability to easily update records, delete, add, etc.
Does anyone have any thoughts on whether I should explore other methods
for storing this data? If so, what is it? The key is to be able to
easily allow for modifications and additions.
Thank you,
Lint Radley 6 1303
I need an opinion here on storing data for a program I am working on the
processes DICOM images. Essentially, my program stores 25-45 (it varies
depending on the user) ranges of pixel values to search the image for.
Currently, I am using a .MDF database that requires SQL Express to be
installed. For only 25-45 records it seems like overkill to me. That being
said, I love the ability to easily update records, delete, add, etc.
Does anyone have any thoughts on whether I should explore other methods
for storing this data? If so, what is it? The key is to be able to easily
allow for modifications and additions.
What about XML? You can store your data in a strongly-typed dataset and
read/write via "DataSet.ReadXm l()" and "DataSet.WriteX ml()". You therefore
have the benefit of the native ADO.NET classes which provides adequate
RDBMS-like functionality with no external DB req'd. Keep in mind that you
lose the benefits of a full-blown RDBMS but for a small app it works very
well IMHO.
Hi Larry,
I will look into this. I had thought about XML but didn't go too far
into checking the solution for suitability. Sounds like from your
description you can still bind to it?
Thanks,
Lint Radley
Larry Smith wrote:
>I need an opinion here on storing data for a program I am working on the processes DICOM images. Essentially, my program stores 25-45 (it varies depending on the user) ranges of pixel values to search the image for.
Currently, I am using a .MDF database that requires SQL Express to be installed. For only 25-45 records it seems like overkill to me. That being said, I love the ability to easily update records, delete, add, etc.
Does anyone have any thoughts on whether I should explore other methods for storing this data? If so, what is it? The key is to be able to easily allow for modifications and additions.
What about XML? You can store your data in a strongly-typed dataset and
read/write via "DataSet.ReadXm l()" and "DataSet.WriteX ml()". You therefore
have the benefit of the native ADO.NET classes which provides adequate
RDBMS-like functionality with no external DB req'd. Keep in mind that you
lose the benefits of a full-blown RDBMS but for a small app it works very
well IMHO.
"Lint Radley" <sc********@for wardbounding.co mwrote in message
news:WwtSi.907$ uE4.459@trnddc0 7...
Hi Larry,
I will look into this. I had thought about XML but didn't go too far into
checking the solution for suitability. Sounds like from your description
you can still bind to it?
UI controls can be bound to an ADO.NET DataTable. The DataTable natively
understands XML, and can read and write to/from XML files directly: http://msdn2.microsoft.com/en-us/lib...e.readxml.aspx http://msdn2.microsoft.com/en-us/lib....writexml.aspx
If you are unfamiliar with ADO.NET, consider that a standard approach to
working with data is to query a database and load data into a DataSet or
DataTable via an ADO.NET DataAdapter instance. Note that a DataSet is
basically a container for DataTable objects. Data lives only in DataTables -
and never directly in a DataSet. To over simplify, you can pretty much think
of a DataSet as an in-memory relational database, as you can set up
DataRelations amongst contained DataTables. Anyway, you then bind your UI
components to the DataSet (specifying the particular DataTable) or a
DataView, or bind directly to a DataTable (DataTables are not required to
exist within a DataSet). The user can then update the data in the
DataTable(s) (perhaps via contained in a DataSet). You then persist the
changes back to the database with an ADO.NET DataAdapter instance.
Keep in mind that (1) DataTables have no clue as to where their data came
from. And (2) because DataTables natively store their data as in-memory XML,
they are capable of reading and writing directly to XML files on disk (no
need to get data from a typical database like MS Access or SQL Server). The
two links above have overloads you can use to read and write directly
to/from XML files on disk.
-HTH
Hi Mac,
I really appreciate your write up here. I will be reading up on this
tomorrow. Thanks! :-)
Lint Radley
Mac McMicMac wrote:
"Lint Radley" <sc********@for wardbounding.co mwrote in message
news:WwtSi.907$ uE4.459@trnddc0 7...
>Hi Larry,
I will look into this. I had thought about XML but didn't go too far into checking the solution for suitability. Sounds like from your description you can still bind to it?
UI controls can be bound to an ADO.NET DataTable. The DataTable natively
understands XML, and can read and write to/from XML files directly:
http://msdn2.microsoft.com/en-us/lib...e.readxml.aspx
http://msdn2.microsoft.com/en-us/lib....writexml.aspx
If you are unfamiliar with ADO.NET, consider that a standard approach to
working with data is to query a database and load data into a DataSet or
DataTable via an ADO.NET DataAdapter instance. Note that a DataSet is
basically a container for DataTable objects. Data lives only in DataTables -
and never directly in a DataSet. To over simplify, you can pretty much think
of a DataSet as an in-memory relational database, as you can set up
DataRelations amongst contained DataTables. Anyway, you then bind your UI
components to the DataSet (specifying the particular DataTable) or a
DataView, or bind directly to a DataTable (DataTables are not required to
exist within a DataSet). The user can then update the data in the
DataTable(s) (perhaps via contained in a DataSet). You then persist the
changes back to the database with an ADO.NET DataAdapter instance.
Keep in mind that (1) DataTables have no clue as to where their data came
from. And (2) because DataTables natively store their data as in-memory XML,
they are capable of reading and writing directly to XML files on disk (no
need to get data from a typical database like MS Access or SQL Server). The
two links above have overloads you can use to read and write directly
to/from XML files on disk.
-HTH
This is what I do.
I create a directory like
DataStores\
and put things like
dicom.xml
and i do this
create a strong dataset
add a few rows using code and using the strong typed methods
ds.WriteXml(fil eName);
look at it in notepad. save it in dicom.xml
then use the ds.ReadXml when I need it.
(as a previous person has said)
Its for my very very static data. But still updateable if need be.
"Larry Smith" <no_spam@_nospa m.comwrote in message
news:uI******** ******@TK2MSFTN GP02.phx.gbl...
>I need an opinion here on storing data for a program I am working on the processes DICOM images. Essentially, my program stores 25-45 (it varies depending on the user) ranges of pixel values to search the image for.
Currently, I am using a .MDF database that requires SQL Express to be installed. For only 25-45 records it seems like overkill to me. That being said, I love the ability to easily update records, delete, add, etc.
Does anyone have any thoughts on whether I should explore other methods for storing this data? If so, what is it? The key is to be able to easily allow for modifications and additions.
What about XML? You can store your data in a strongly-typed dataset and
read/write via "DataSet.ReadXm l()" and "DataSet.WriteX ml()". You therefore
have the benefit of the native ADO.NET classes which provides adequate
RDBMS-like functionality with no external DB req'd. Keep in mind that you
lose the benefits of a full-blown RDBMS but for a small app it works very
well IMHO.
On Sat, 20 Oct 2007 18:00:07 GMT, Lint Radley
<sc********@for wardbounding.co mwrote:
>Hi Everyone,
I need an opinion here on storing data for a program I am working on the processes DICOM images. Essentially, my program stores 25-45 (it varies depending on the user) ranges of pixel values to search the image for.
Currently, I am using a .MDF database that requires SQL Express to be installed. For only 25-45 records it seems like overkill to me. That being said, I love the ability to easily update records, delete, add, etc.
Does anyone have any thoughts on whether I should explore other methods for storing this data? If so, what is it? The key is to be able to easily allow for modifications and additions.
Thank you,
Lint Radley
You can also use a small footprint database, which are basically DLLs
that you reference for the database functionality rather than full hog
databases.
There are several of these:
- SQL Lite
- SQL Server Compact Edition
- VistaDB
*Vista DB is not free
-- http://bytes.thinkersroom.com This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Keith Morris |
last post by:
Hi all! I'm creating a mini CMS that will store content in a MySQL
database. What I am trying to do is parse the content and replace
certain keywords with a link. The keywords and associated links are
kept in a MySQL table.
Here is an example.
$keyword = "Widgets Technology Co.";
$location = "http://www.widgets.com/about";
|
by: abcd |
last post by:
kutthaense Secretary Djetvedehald H. Rumsfeld legai predicted eventual
vicmadhlary in Iraq mariyu Afghmadhlaistmadhla, kaani jetvedehly after "a
ljetvedehg, hard slog," mariyu vede legai pressed Pentagjetvedeh
karuvificials madhla reachathe strategy in karkun campaign deshatinst
terrorism.
"mudivae maretu winning or losing karkun global varti jetvedeh terror?" Mr.
Rumsfeld adugued in a recent memormariyuum. vede velli jetvedeh madhla...
|
by: jeff brubaker |
last post by:
Hello,
Currently we have a database, and it is our desire for it to be able
to store millions of records. The data in the table can be divided up
by client, and it stores nothing but about 7 integers.
| table |
| id | clientId | int1 | int2 | int 3 | ... |
Right now, our benchmarks indicate a drastic increase in performance
if we divide the data into different tables. For example,...
|
by: JollyK |
last post by:
Hello everyone...
I have created a user-control that has a fairly complex datagrid (with
template columns) which includes localization, custom paging, sorting,
filtering, searching, caching, options to add, edit, and delete record, and
then enabling and disabling links inside the datagrid based on different
conditions. Everything is working fine now. I have hand-coded everything and
the total length of my code-behind file is around 1900...
|
by: penguin732901 |
last post by:
A database keeps track of invoices (date, amount, balance, category,
etc) and advertisements (size, text, sponsored by, date entered etc)
(among other things).
Sometimes, an advertisement is sponsored by more than one person, so
each one gets an invoice for his or her share of the advertisement,
done by a button to an append query when the ad is created.
Thought 1: Store the ADID in Comment field of tblInvoices.
| |
by: Matik |
last post by:
Hi to everyone,
My problem is, that I'm not so quite sure, which way should I go.
The user is inputing by second part application a long string (let's
say 128 characters), which are separated by semiclon.
Example:
A20;BU;AC40;MA50;E;E;IC;GREEN
|
by: arunbalait |
last post by:
Hi all.
I want to store about 300 crore records into sql server. Is it possible?
Whats the actual memory capacity of sql server for storing records..?
How many max amount of records can I able to store?
Plz let me know immediately
|
by: webcm123 |
last post by:
I'm looking for a good method of securing ratings. Cookies lock isn't
sufficient. In addition to cookies I would need something else. I'm
introducing some ways.
-= Storing rates inside seperate tables =-
Seperate tables (artrates, filerates, imgrates) will contain:
ID of item | rate | user | IP
1 rate = 1 record. Field USER will filled if only registered users can
|
by: sumedh..... |
last post by:
In a compiler there are 36bits for a word and to store a character
8bits are needed. In this to store a character two words appended.
Then for storing k characters string,how many words are needed?
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |