i have this menu in javaScript: menu[1] = { id: 'menu1', //use unique quoted id (quoted) REQUIRED!! fontsize: '100%', // express as percentage with the % sign linkheight: 22, // linked horizontal cells height hdingwidth: 210, // heading - non linked horizontal cells width // Finished configuration. Use default valu...
I was able to import data through solr DIH. In my database I have 4 tables: threads: id, user_id, country_id tags: id thread_tag_map: thread_id, tag_id countries: id posts: id, thread_id i want each document in solr to consist of: thread_id tag_id country_id post_id for example: thread_id: 1 tag_id: 23 tag_id: 34 country_id: ...
I have a table structure like this (vertical design). I can have unlimited number of attributes (eg: city, phone etc.) for each user. Table: tbl_UserAttributes ┌────────┬───────────┬────────────┐ | UserID │ FieldName │ Value | ├────────┼───────────┼────────────┤ │ 341 │ city │ MyCity1 │ │ 772 │ phone │ 1234567890...
in my solr index i have in each document: tag_name thread_name i have no id for unique key and i cant turn it off because then solr says that queryelevationcomponent needs one. even if i add tag_id or thread_id it wont work because they got identical id. tag.id = 1 and thread.id = 1. how should i get around this issue? ...
I have a large (multi-GB) data file exported from an Oracle table. I want to import this data into another Oracle instance, but I want the table name to be different from the original table. Is this possible? How? Both importing and exporting systems are Oracle 11g. The table includes a BLOB column, if this makes any difference. Th...
Hi I am trying to import various pipe delimited files using php 5.2 into a mysql database. I am importing various formats of piped data and my end goal is to try put the different data into a suitably normalised data structure but need to do some post processing on the data to put it into my model correctly. I thought the best way to do...
I want to know that the distributed database system Bigtable is object oriented? ...
Preface: I don't have experience with rules engines, building rules, modeling rules, implementing data structures for rules, or whatnot. Therefore, I don't know what I'm doing or if what I attempted below is way off base. I'm trying to figure out how to store and process the following hypothetical scenario. To simplify my problem, say t...
i dont get 1-n relationship. have read some aritcles but still cant figure it out. i get 1-many, 1:1 and many-to-many. but what does 1-n mean? ...
i want to make my threads content searchable with full text search engines like solr. but i wonder one thing. should i index just the thread.title, thread.body and post.body or should i index username, created date, nr of posts, views, country, region and city too that belongs to thread? i mean when an user search for a thread he will ...
I received a bunch of CSV files from a client (that appear to be a database dump), and many of the columns have weird characters like this: Alain Lefèvre Angèle Dubeau & La PietàThat's seems like an awful lot of characters to represent an é. Does anyone know what encoding would produce that many characters for ...
Because ther eis a lot in there..and "time" is big number. ...
I had this problem some years ago and back then I implemented a "different logic" in order to deliver the project but the doubt remains in my mind and hopefully with your help I'll be able to understand it now. Suppose I have some scheduled events on my database that may or may not spawn over several days: id event start ...
I'm trying to make a versioning system for database entries. I thought of fully storing only the last version of an entry and using reverse-deltas for storing the changes. While there is a lot of wiki software that has a diff function, i found none that has a patch function. How do they revert to an older version of an entry? I'm asking ...
is it generally acceptable to store relational data in an rdbms like mysql, and place, lets say, arbitrary relationship data in a separate graph database system like neo4j? what about primary keys referenced in one db to another? or, another example: using mongodb for log data when mysql is the primary database platform for the applicati...
in mysql i have two tables tableA col1 col2 SIM1 ..........col24 ----------------------------------- a x 1 5 b y 1 3 c z 0 2 d g 2 1 tableB colA colB SIM2 ------------------- x g 1 y f 0 x s 0 y e 2...
Hi, I'm exploring all the options to persist user settings. The artilce in the url http://stackoverflow.com/questions/803245/user-specific-settings-files-for-a-windows-form-application-local-xml-file-or-da convinced me to store the settings into a db as my application is a standalone communicating with a DB. Is there any provider class ...
I am new to jdbc and i'm try to connect to by database form IDE.The code below is what i wrote; private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) { try { DriverManager.registerDriver(new org.apache.derby.jdbc.ClientDriver()); Connection conn=DriverManager.ge...
This is a math problem, but I'm sure this must come up in some programming scenarios, at least I hope so, and I was wondering if there was a name for this type of situation: Suppose I have 7 items in a series. For the sake of this example, let's use days of the week. I would like a user to submit which days of the week they plan to come...
I have a web page (ASP.NET, ASCX) which has to show some contents of a database. The choice of contents is determined by some variable, say x. So, if x=1, I show the first column of a given database table, if x=2 I show the second column and so on. I am told that I need to use a thing called "placeholder". Can anyone show me how to do...