473,666 Members | 1,991 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Multidimensiona l array question

I am trying to develop a multidimensiona l array for use of searching a very
large database. I understand the concept of one and two dimensional arrays
but this project would include up to 12 or 13 criteiras for the search. The
engine needs to be user friendly for general public use so the SQL/query path
method is not really an option for me. I have heard or read about
multidimensiona l cube arrays and am not sure if this is a viable method for
my project.

Any suggestions or code that might be usable would be greatly appreciated.
Mar 1 '06 #1
3 1341
Hi BobbyS,

I'm not 100% sure I understand what you're asking. Are you looking to
provide 12 or 13 variables to a search method and expect results to be
returned?

Adam

--
Adam May
Sydney, Australia
MCSD.Net
"BobbyS" wrote:
I am trying to develop a multidimensiona l array for use of searching a very
large database. I understand the concept of one and two dimensional arrays
but this project would include up to 12 or 13 criteiras for the search. The
engine needs to be user friendly for general public use so the SQL/query path
method is not really an option for me. I have heard or read about
multidimensiona l cube arrays and am not sure if this is a viable method for
my project.

Any suggestions or code that might be usable would be greatly appreciated.

Mar 1 '06 #2
Yes I am.

"Adam May" wrote:
Hi BobbyS,

I'm not 100% sure I understand what you're asking. Are you looking to
provide 12 or 13 variables to a search method and expect results to be
returned?

Adam

--
Adam May
Sydney, Australia
MCSD.Net
"BobbyS" wrote:
I am trying to develop a multidimensiona l array for use of searching a very
large database. I understand the concept of one and two dimensional arrays
but this project would include up to 12 or 13 criteiras for the search. The
engine needs to be user friendly for general public use so the SQL/query path
method is not really an option for me. I have heard or read about
multidimensiona l cube arrays and am not sure if this is a viable method for
my project.

Any suggestions or code that might be usable would be greatly appreciated.

Mar 1 '06 #3

"BobbyS" <Bo****@discuss ions.microsoft. com> wrote in message
news:32******** *************** ***********@mic rosoft.com...
I am trying to develop a multidimensiona l array for use of searching a very
large database. I understand the concept of one and two dimensional arrays
but this project would include up to 12 or 13 criteiras for the search.
The
engine needs to be user friendly for general public use so the SQL/query
path
method is not really an option for me. I have heard or read about
multidimensiona l cube arrays and am not sure if this is a viable method
for
my project.

Any suggestions or code that might be usable would be greatly appreciated.


This is general advice, but IMO these approaches are always costly in time.
Even multiple criteria SQL searches are expensive. I have always found it
faster to search on the most restrictive criteria, using that to build a
list of record indexes, then select from that list slowly restricting until
you have a final list which you can then use to select the tuples you
require.

So I would use SELECT INDEX FROM TABLE WHERE FIELD < CONSTANT1 AND FIELD >
CONSTANT2 and repeat until I got the final list.

There is a belief abroad that database systems are magical and can perform
complex searches instantly. This belief is not supported by experience.

Mar 4 '06 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

5
10900
by: Rob Tweed | last post by:
Probably a simple question but I can't find the answer anyway. Specifically, is it possible to copy a multidimensional array into the $_SESSION array - ie a deep clone of all keys and data? I naively assumed that $_SESSION = $myArray ; would work but it doesn't appear to work. Is there a single function
9
6665
by: Charles Banas | last post by:
i've got an interesting peice of code i'm maintaining, and i'd like to get some opinions and comments on it, hopefully so i can gain some sort of insight as to why this works. at the top of the function (which was translated from Fortran code), among other heinous and numerous declarations, is this bit: static float bbuff; static int bkey; static int buse;
3
1867
by: matthewburton | last post by:
Hi everyone, I'm trying to write a program that will search a body of text and replace certain words (say, A, B, and C) with different words that I think are more appropriate (A1, B1 and C1). I have a feeling that I need to do this through a multidimensional array. Am I on the right track? thanks, matt
2
1681
by: Allen Maki | last post by:
Hi Everybody, I am new to VC.NET and I need your help. I would like the array to print characters as '.'s (dots) instead of 0s as in (see below in front of //------>>>>>. I tried to use casting like this:
23
1500
by: drazet | last post by:
hi,all i have a question about multidimensional array. int w,(*pw); pw=w; is *(pw+1) wrong?why? and *(w+2),pw and *(pw+2) mean?
2
4482
by: oopsatwork | last post by:
Ok...so, I have been outside of the C world for a _very_ long time...but not so long as to remember how to do multidimensional arrays. So, let me state that I know how to malloc pointers to pointers and then malloc my data space. This question is NOT about that. I need to keep a dynamically sized (a result of command line options) matrix in a shared memory segment created via shmget and attached via shmat. My first instinct was to do...
6
1947
by: themadme | last post by:
hi, im trying to create a multidimensional array and then pass along a few funcitons. this is the way i have created, im sure its the correct way of doing it? // TerrainMapData is struct TerrainMapData **TerrainData ; TerrainData = new TerrainMapData *;
0
4470
by: Szabolcs Borsanyi | last post by:
Dear All, there have been several threads on multidimensional arrays and pointers to arrays, there is still something I could not fully understand. (My point here I have raised already, but stayed unanswered) Let's have an array. float A;
12
5640
by: filippo nanni | last post by:
Hello everybody, my question is this: I have two multidimensional arrays and I have to create a third one (for later use) from comparing these two. Here is my example code: //BEGIN CODE var myGroups = ,,]; var myProducts = ,,,]; var newGroups = new Array();//Resulting Array function main() { for(i=0; i<myGroups.length; i++){
9
4494
by: Slain | last post by:
I need to convert a an array to a multidimensional one. Since I need to wrok with existing code, I need to modify a declaration which looks like this In the .h file int *x; in a initialize function: x = new int;
0
8356
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,...
0
8781
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
8551
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
8640
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
7386
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
5664
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
1
2771
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
2
2011
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
2
1776
bsmnconsultancy
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...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.