The query tag has no wiki summary.
3
votes
1answer
153 views
NLP - Queries using semantic wildcards in full text searching, maybe with Lucene?
Let's say I have a big corpus (for example in english or an arbitrary language), and I want to perform some semantic search on it. For example I have the query:
"Be careful: [art] armada of [sg] is ...
4
votes
1answer
44 views
How to model and query spatial responsibilites of company local branches
what are best practices, to model and query spatial responsibilities of company local branches?
My company has many local branches which are all in general responsible for 1 city. This is the easiest ...
0
votes
1answer
307 views
Is python lambda “really formal” λ-calculus or just share the name?
Now and then I use the Python lambda. Is it so formal that it is safe to say that you can do formal lambda calculus with it? I just used it but I didn't fully understand whether the python lambda and ...
1
vote
1answer
93 views
Is Neo4j graph database sufficient to itself for all query types?
Neo4j eases relationship traversals => especially useful for a social network for instance.
But are there any scenarios when it's advised to associate an additional relational database (or other ...
17
votes
7answers
13k views
How do I make complex SQL queries easier to write?
I'm finding it very difficult to write complex SQL queries involving joins across many (at least 3-4) tables and involving several nested conditions. The queries I'm being asked to write are easily ...
2
votes
1answer
93 views
Best design for a memory resident tool
I apologize if this tends more toward design that programming, but here goes.
What design would you recommend for a database that is
Memory resident
Must run on windows, linux and (at a stretch) ...
2
votes
2answers
103 views
How to programmatically construct textual query
Here is a query language, more specifically, it's JQL, you can use it in Jira, to search for issues, it's something like SQL, but quite simpler.
My case is that, I need to construct such queries ...
4
votes
6answers
434 views
Should I have a separate method for Update(), Insert(), etc., or have a generic Query() that would be able to handle all of these? [closed]
I'm currently trying to write a class library for a connection to a database. Looking over it, there are several different types of queries: Select From, Update, Insert, etc.
My question is, what ...
2
votes
2answers
147 views
Better way to search for text in two columns
Here is the scenario. I am making a custom blogging software for my site. I am implementing a search feature. It's not very sophisticated - basically it just takes the search phrase entered and runs ...
1
vote
2answers
745 views
Designing complex query builders in java/jpa/hibernate
I need to build complex sql queries programatically, based on large filter conditions.
For example, below are few sample/hypothitical filter conditions, based on which i need to fetch users
Country: ...
1
vote
1answer
108 views
“t-sql” tool for csv files?
Is there a tool that allows to query files based on the following criteria, and change them?
creation date
filenames (e.g. filetypeA_YYYYMMDD_data2.blah)
file content
For the example, the workflow ...
2
votes
1answer
312 views
Querying key/value store
I don't know whether this question is reasonably answerable (and therefore will be closed), but I will take my chances: What are the possible problems (and solutions), one might encounter, when ...
0
votes
1answer
28 views
Users and roles: Where to put queryUsersWithRole()?
I have two model classes User and Role and two managers/DAOs (UserManager and RoleManager) plus a method which gives me all users with a certain role (List<User> getUsersWithRole(Role)).
In ...
27
votes
11answers
1k views
Why don't relational databases support returning information in a nested format?
Suppose I'm building a blog that I want to have posts and comments. So I create two tables, a 'posts' table with an autoincrementing integer 'id' column, and a 'comments' table that has a foreign key ...
37
votes
12answers
2k views
Should experienced programmers know database queries?
There are so many programmers out there who are also an expert at Query writing and Database design.
Should this be a core requirement to be an expert programmer or software engineer?
Though there ...
