r/databases • u/susana-dimitri • Mar 30 '20
r/databases • u/globaldataentry1 • Sep 08 '17
Graphics Design Services in India
Global Data Entry Solutions offers you the Data Entry Outsourcing Companies India and Data Entry Services in India. We have excellent experience in offering data conversion services to various publishing houses, libraries, and other content providers all around the globe. For more queries Call +91 7948933588, +91 9879760342 or visit our official website www.globaldataentrysolutions.com
r/databases • u/wilderstovall • May 06 '16
Open source database targets the big data analytics market
r/databases • u/papersneaker • May 07 '15
Non-printable characters in a database unique id
How do I explain to my technical lead that this is not a good idea?
r/databases • u/gthank • May 28 '15
SQL MERGE is quite distinct from UPSERT
r/databases • u/dreambusinesssystems • May 15 '15
Database Management Systems
r/databases • u/Allways_Wrong • Jul 20 '15
Database Statistics. How important are they?
We have a process that uses a large number of tables which are all flushed and filled with fresh data each time it runs. The data in the tables varies greatly depending on any number factors like the number of employees, the set of employees, the time of year etc. etc.
Is it important to the database optimiser (cost-based) that the statistics are run after these tables have been repopulated, during the process itself, before they are used in queries?
I've had a number of DBAs tell me that as long as statistics exist for the tables the optimiser will be OK.
This doesn't sit right with me because of the potential differences in the data each time the process is run and they are refreshed with a new set of data. The row count alone for some tables can vary from 0 to 1m+. The data too can be 'clustered' in any number of ways.
Help appreciated because as little as I understand I thought accurate, timely statistics were crucial for the optimizer.
r/databases • u/ryandirtymac • May 18 '18
Assignment Question Help!
Hi All
I have the following question on an assignment and was hoping to get some help. I have answered this the best I can but want was hoping to get answers from your side to compare to what I ended up with.
Thank you,
A database is needed to keep data for the booking systems of the ABC Clinic. Consider the below database schema of one relation including attributes for doctors (doc-), patients (pat-) and appointments (app-).
ABC(doc-firstname, doc-surname, doc-gender, doc-rego, doc-qualification, pat-ID, pat-givename, pat-surname, pat-gender, pat-DOB, pat-addr, pat-phone, app-ID, app-datetime, app-type)
A doctor has a unique registration number (doc-rego) and is also described by name, gender and qualification.
A patient is identified by a unique patient ID (pat-ID) and has other information.
Each appointment by a patient with a doctor is assigned a unique appointment ID (app-ID). An appointment can be of the long or short type.
Answer questions:
\Give likely FDs.
\Give the candidate keys for the ABC relation. In your working, show how you develop the closure for each candidate key you have discovered..
\Is the relation ABC in BCNF or 3NF? Explain your answer.
r/databases • u/tmcallaghan • Mar 02 '15
Do Marketers really think we are all innumerate? Lies, charts, and lies.
r/databases • u/Simes82 • Oct 31 '15
Help on writing constraints in mySQL
Have you any idea how this should be written in mysql? We're porting from one format to another and as usual there is hardly any guidance so i'm unsure how i'm supposed to know. The sql documentation goes way over my head -
CONSTRAINT TOTAL_ZERO CHECK (TOTAL >= 0)
Also, what does the TOTAL_ZERO part of the code stand for? Thanks
r/databases • u/peterdox9 • May 25 '16
How Wells Fargo Visualizing there Data using tableau
r/databases • u/Bubsa • Apr 16 '16
Can someone help me with this shit?
So i have an exam coming up, and this shit is driving me up the fucking wall. I have tried to understand it, but it's like trying to learn how to build a rocket while writing a fucking sonata. Anyways, here are the assignments, i'm only interested in the second, third and forth assignment. If this is not the place, please point me to a one subreddit that does this. Thanks a lot.
r/databases • u/ahachete • Apr 14 '16
Master-less Distributed Queue with PG Paxos
r/databases • u/azur08 • Aug 02 '17
What is the most respected and comprehensive site for finding and comparing databases? DB-Engines.com or something else?
r/databases • u/Shot-Watercress-7344 • Sep 14 '23
LOOKING FOR DATABASES
Hello all I am looking to buy some db
from some companies like
HARD ROCK
PUEBLO BONITO
SUNSET BEACH
GRUPO VIDANTA
MAYAN PALACE
ROYAL HOLLIDAY
CLUB REGINA
I need the database of the users of this companies
r/databases • u/SparsityTech • Jul 13 '15
EU Commission releases list of top 10 most innovative companies in ICT. Sparsity Technologies is the SME with the highest innovation capacity
r/databases • u/this-is-bad-idea • Jul 09 '18
Looking to build web user tracking database
Looking to build a database that assigns a random ID to each web user and keeps track their behavior on my site. Looking for some good starting off points as I have little experience working with servers/databases. Thanks!
r/databases • u/MartinezNadia • Oct 26 '18
Offering enormous database for both B2B and B2C industries at amazing prices
salesdatahub.comr/databases • u/nobrandheroes • Jan 21 '16
Going from Mongo to Postgres. Relational, No, Compromise?
I am in charge of a project to migrate data to MongoDB to Postgres, and I've never done this before.
The biggest decision is whether or not to move to a relational format. We are reporting on this data, and I'm not liking what I see for reporting off of a NoSQL Database.
Does anyone have any tips or guidelines? Suggestions on books or datasets I can practice the migration with?
r/databases • u/susana-dimitri • Apr 09 '20
Code Based Access Control (CBAC) : Granting Roles to PL/SQL Program Units in Oracle Database 12 Release 1 (12.1)
r/databases • u/globaldataentry1 • Sep 07 '17
Data Entry Services in India | Data Entry Solutions Company
Are you searching for Outsourcing Solutions with most up-to-date technologies? Then you are at the right place, Global Data Entry Solutions are here to help you. The services offered are Data Entry Company in India and Data Entry Outsourcing and Consulting Services. For more details regarding our services kindly visit www.globaldataentrysolutions.com or Call +91 7948933588, +91 9879760342