Structured Query Language (SQL) is a language for managing data in relational database management systems. This tag is for general SQL programming questions; it is not for Microsoft SQL Server (for this, use the sql-server tag), nor does it refer to specific dialects of SQL on its own.
2
votes
2answers
104 views
Is there some rationale behind SQL's lack of closure for what are standard operations in imperative languages?
Is there some historical or practical reason why SQL (or more specifically T-SQL in my case) does not support the closure property in many areas where many other language families like C do?
(That ...
2
votes
2answers
101 views
How To Design Time Slot Based App
I have got a responsibility of designing an app which allocates time slots for doctors booking.
The scenario is like, there'll be entry for doctors and their time slot for each days. For E.g.
...
1
vote
1answer
31 views
sql - How do I add child of child when dependent on parent
I'm building a wpf application which interacts with a sql database.
I'm confused about adding children of children in my window.
For example.. I just created a fishing trip so my fishing trip doesnt ...
1
vote
2answers
96 views
What is application SQL? [on hold]
I am currently working with a third party database trying to pull some data out of it. It is a complex system and the SQL is quite complex.
I emailed the vendor to ask them to take a look at my SQL ...
-2
votes
2answers
81 views
c# sql - filtering user content based on role [on hold]
I have a table of Users and a table of UserRoles and FishingTrips.
A user may have more than one role and each role that a user is assigned to has a supervisor which is another user. This user can be ...
1
vote
1answer
32 views
User, user Role and user Info, data base design problem
I am creating an application that will manage job interviews and help the employers to choose the job seekers based on a ranking system that's based on some user info.
I've created a database that has ...
7
votes
2answers
107 views
Seeking benefits of both SQL and binary files in a data storage scheme
I'm looking for some input on how to keep certain benefits of both a binary file and a SQL database in an interesting data storage problem.
I have a legacy custom binary file format that is ...
-7
votes
0answers
29 views
TVP or cursor? What is better for performance? [duplicate]
I am populating a cursor with a max of 65 inserts, all for a single input variable for a sp. In terms of performance, should I use a table-valued parameter instead? I use them both, but I just would ...
-3
votes
2answers
41 views
Can a value in a tsql field be conditional based on another field? [closed]
Forgive me if this doesn't make sense, I'm still relatively new to database concepts.
I have a form which users can create 'events' in. The form allows users to specify WHEN they want an event to ...
4
votes
1answer
51 views
Creating a service to to run logic / queries and update a table vs. running logic / queries on client refreshes
I'm not sure if this is a thing. I'm sorry about the ambiguous title--I wasn't really sure how to explain it. Basically I have a ASP.NET web page that runs two SQL queries and does some logic to ...
2
votes
2answers
46 views
When do I prefer a local DB over serialization for local data storage?
I recently started developing a small calendar application, in which I can add and view several calendar entries, which contain several data like name, date, alarm settings and so on.
Those values ...
-1
votes
2answers
61 views
SQL query - split and run parallely?
I have a master table T1 which has 1000 records and a ColRef a key column.
There are lots other tables all linked by ColRef.
I have a Stored procedure which takes few hours to process.
I want to ...
0
votes
1answer
85 views
How to setup multiple queries with slight differences
I'm writing a page that will show the user statistical data about some of our products. Basically the user can get results between a specific time frame, and also add on other data to lookup by.
For ...
1
vote
1answer
29 views
Dynamic form builder with serialised sql storage
I have a requirement whereby my users will need to be able to build their own forms. Which they can specify different datatypes:
Text
DateTime
Checkboxes
All customisable mandatory/optional.
I've ...
-2
votes
1answer
33 views
Get database after sql crash [closed]
One of the hard drive in my office's NT server was crashed two weeks ago. I had installed MS-SQL in c: and the data was stored in d:. The hard crased was c:. Thus I replaced the crashed hard drive ...
0
votes
2answers
52 views
Term OR word for specific type of a SQL table
I am looking for a Term/Word for specific type of tables.
I have tried to search a lot, but I could not come up with best search terms for this.
Tables that hold some master information, such as ...
0
votes
1answer
19 views
Best Azure Solution for Complex Search Index
I need to perform quick searches against a combination of tags while including date ranges:
Example:
Users
who have requested notifications
who did not respond to a notification sent at least 3 ...
1
vote
0answers
45 views
SQL - Locating closest value in a set
I have a table that contains the percentiles from a reference data set.
CREATE TABLE [Core].[RiskFactor](
[SpecialtyCode] [char](2) NOT NULL,
[RiskCategoryId] [int] NOT NULL,
[Percentile] [tinyint] ...
6
votes
2answers
129 views
Does it make sense to use a cursor for complex business logic?
I am dealing with a pretty extensive data set. After a few joins, the foundation table has something like 40 columns. The next 40 columns will all be calculated. I am trying to keep my Java clean of ...
-1
votes
2answers
90 views
Does sql use hastables for indexes? [closed]
Are there other ways of indexing?,
Which are the more used?
Does sql have an standard for indexes, it uses hash tables?
2
votes
4answers
104 views
Data Model - How to better model this circular reference
I'm designing the data model for a project where users can create documents, save revisions of that document that can be reverted to, and publish documents. The basic data model I have right now is ...
1
vote
1answer
142 views
Getting data from a database with the MVC model
I am creating an application which will have a very large database to draw it's information from (a student registration system to be exact). The database is created with Microsoft SQL Server if that ...
3
votes
3answers
146 views
How to test data based on SQL queries?
I'm trying to set up a test framework for (SQL) datasets that get updated daily. I want to write assertions that involve comparisons between two tables–for example, the sum of column visitors in the ...
2
votes
1answer
219 views
How is one or more aggregate function implemented in most SQL engines?
In the book Database Fundamentals, Silberschatz. It is explained that aggregate functions can be calculated on the march.
This make sense. What it means is that for calculating the maximun, average ...
-1
votes
3answers
192 views
What to do with database foreign keys in an entity class?
I know that an attribute defines the state of an object. So, is it correct to keep attributes that don't define the state of an object of a class?
For example, I have an Employee class, which has ...
7
votes
4answers
244 views
Encapsulation for complex queries
I tried asking this question first on StakOverflow in a more concrete manner, but after being pointed here I realized I should rephrase it in more general terms; however, you can still review the ...
-1
votes
2answers
231 views
Registration form with email verification
Can someone point me in the right direction: I need to make a website with a registration form, to create accounts with e-mail verification, to write the forms content in a database table or something ...
2
votes
0answers
57 views
ODBC 3 Multiple Statements vs Multiple Connections
So right now I have a single thread to handle all the requests for the database. Let's say I have 400 requests per second for logins / logouts / other stuff, and 400 requests per second which are only ...
0
votes
1answer
67 views
Why storing a payroll in XML type field would be good or bad
We have a PAYROLL issues by the client to make it dynamic i.e. to make the whole process computerized.
It includes:
Employees
Allowances (Scale wise, which could change yearly or monthly or ...
0
votes
3answers
114 views
Getting RowCount without wasting resources
I have a large SQL query that relates 6-7 different tables and returns fourteen different rows as distinct sets, in a union with an equally-large query, that at times can return over a thousand ...
1
vote
0answers
96 views
SQL Query and Java Constant Abuse?
I am currently charged with taking over a lot of code that is written with fields names placed into Java constant at the top of the file, and then the SQL queries constructed using string ...
1
vote
1answer
78 views
auto generated web CMS for pre-existing SQL db?
What I'm looking for is a way to auto-generate a simple web-based CMS for a simple pre-existing SQL database. To be used by 'app administrators', not the general public.
Something that:
allows ...
1
vote
0answers
47 views
More scalable alternative to a transaction-per.request in a SQL+REST stack?
I'm new in web programming with SQL database. So please forgive my ignorance.
I'm using some modern framework to make a REST server with a SQL database. I'm using transaction only when I think I need ...
2
votes
2answers
343 views
SQL query or C# .net code for csv files import?
My aim here is to find out the best possible and feasible solution for my dilemma. I want to import some csv file (may contain around 50~60K records) into database after some manipulation into the ...
0
votes
0answers
16 views
Conceptually, how should a unidirectional multivalued relationship be implemented?
Ok, I'm trying not to upset the programmers list, but not so successful so far. My apologies. I'm trying to understand, conceptually and based on experience, which is the correct way for a JPA ...
4
votes
2answers
103 views
Why are triggers seen as a last resort to solve multiple paths in cascading deletes?
There is a problem using ON DELETE CASCADE on foreign keys in a SQL database if there are multiple paths from the root foreign key to the leaf. The way around this seems to be to replace the ON DELETE ...
2
votes
2answers
145 views
Why use JSON dataset rather than SQL Query?
A colleague was asking me to explain a system information flow, as they are having problems with the wrong information being presented. It seems that what they have created is a custom built website, ...
0
votes
1answer
135 views
Relationship between REST APIs and Databases [duplicate]
I've been studying databases and rest APIs lately and I have a question about the relationship between the two.
Imagine I have a database with three tables, STUDENTS, ENROLLED, and CLASSES.
STUDENTS ...
0
votes
0answers
105 views
Best practices for dashboard of near real-time analytics
I’m currently building a dashboard to view some analytics about the data generated by my company's product.
We use MySQL as our database. The SQL queries to generate the analytics from the raw live ...
2
votes
4answers
104 views
Keeping a ratio column that's the division between two other columns
I'm about to build a SQL table where I want to store currency orders. That means that I need to store how much I paid for a certain quantity, and the ratio between both quantities. So for example:
...
0
votes
0answers
18 views
SQL data model for nested milestones/timframes
I'm currently weighing different approaches to a data model and I'm curious what others would do.
The main nugget of info is ACTIVITIES, which belong to a chain of milestone time releases.
Stages
...
0
votes
0answers
90 views
Options for implementing database and programming logic for statistics application?
I am implementing a statistics driven web application. The statistics relate to sporting events.
Right now I have a postgresql database with a table that holds a row for each match. This is a ...
-1
votes
1answer
54 views
Querying Results from End of the table
Normal behavior of the SQL Table is to add new rows in end of the table. I want to query results of single row only.
So mysql command is
SELECT id FROM users WHERE country='india' LIMIT 1
this ...
0
votes
0answers
16 views
When would I choose a Lucene/MSFT Search of SQL to store Spatial data?
I need to store the locations of stores and allow customers to query nearby businesses, with a varying amount of filters.
The filters in the Search world seem to be named "facets"
What reasoning ...
4
votes
0answers
101 views
Using mysql 5.7 Json Columns for EAV
I am developing an e-commerce product and I have been able to implement all functionality and am left with allowing users to create additional attributes for a product. Right Now I have two options.
...
0
votes
0answers
106 views
Advice on program performance after changes
So, the situation is like this:
For the past two years, I have implemented a class in c# which is used to filter different fields from different tables in database (SQL), for reporting purposes. Now ...
0
votes
0answers
50 views
Use vb.net sql reader as a Delegate to gather Data
Is there a way to use a sub to create a loop, but change the content of the inside of the loop?
I don't know what I don't know. I keep looking at this code and I have a feeling that it's possible.
...
0
votes
1answer
158 views
Designing Pricing table (RDBMS agnostic)
I'm designing a pricelist table for my database.
It will include Customer, Model, Start_date, End_date, Price, Currency, RRP
When I update a new pricelist which is sent every now and then (maybe ...
42
votes
8answers
6k views
Is the use of NoSQL Databases impractical for large datasets where you need to search by content?
I've been learning about NoSQL Databases for a week now.
I really understand the advantages of NoSQL Databases and the many use cases they are great for.
But often people write their articles as if ...
4
votes
2answers
91 views
How to represent a collection with capacity in a database?
Concerning normalization of a one to many relationship, I am not sure how to represent a collection with a specified capacity in a database. I can think of two ways to represent an entity A with a ...
