On a real time messaging application, I want to control if incoming message is unique. For this purpose, I am planning to insert a hash of incoming message as unique key in db and check if I get unique key exception. (ORA-00001 in oracle). Is this an efficient way or is there a better way to consider for this case ? For ones who want to know, program is written in java and as a db we use oracle.
Checking uniqueness on real time application
93 Views Asked by cacert At
1
There are 1 best solutions below
Related Questions in ORACLE
- Column displays each count
- MAX and GROUP BY - SQL
- Best Practice for adding columns to a Table in Oracle database
- Updating an Oracle row with value from same row
- Retrieving data from Oracle database
- Ibatis execute update sql on oracle, it is not working and no exceptions
- Building an sql execution plan history
- Implementation of Rank and Dense Rank in MySQL
- how to update the date field for this specific condition using oracle query?
- Oracle stored procedure wrapping compile error with inline comments
- Android: How to connect oracle database using Android Java code?
- SQL Conditional Join on Columns
- Multi value wildcard search in ibatis
- Get count of consecutive days meeting a given criteria
- How to update the metadata of a layer in Oracle imported through FME Workbench?
Related Questions in SOFTWARE-DESIGN
- how to measure Software as a services performace
- Why does the main function returns unexpected execution result?
- How to wrap my head around Object Oriented Design
- Specifying static and dynamic sizes at compile time
- Do unused imports in java effects performance and consume memory?
- Where to put the association model -> view model?
- Why doesn't JavaScript get its own thread in common browsers?
- Am I overusing the Singleton pattern?
- ASP .NET MVC Application UML class diagram
- I want to automate a daily task, need certain info from pdf to go into specific areas of an excel file
- Small table to Big table update
- Message in side client visual basic application?
- How to deal with multiple composed/related conditions?
- Programmatically grouping and typehinting different classes
- How can I measure the quality of my software architecture?
Related Questions in UNIQUE-KEY
- How to generate unique secure random string in PHP?
- Solr 5.1.0: How to set the unique key via Schema API
- MySQL: is primary key unique by default?
- Creating Unique Key in Entity Framework Model First approach
- UPDATE MySQL table with HAVING clause
- What's the best way to get address difference between a class variable and the starting address of a class object?
- Multivalued dependency confusion
- Identifying documents by multiple unique keys in solr
- mySQL UPDATE while ignoring table constraints
- MySQL: Is it mandatory to create a `Unique Key` when you have 2 `Primary Keys` in a table?
- How to Generate random numbers without the same number
- Adding unique key/index to table and its influence on existing records
- Can we have a table with no primary key but a composite unique key on multiple columns in entity framework?
- Does an empty SQL table have a superkey? Does every SQL table have one?
- Find or insert based on unique key with Hibernate
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
If you're trying to get around the performance problem of uniqueness tests on very large strings, then this is a decent way of achieving it, yes.
You might need a way to deal with hash collisions, though, as the presence of a unique key would prevent different messages having the same hash from loading. One way would be to check for existing matching hashes and do a comparison test against the full text of the message. It would keep your index size down as you'd index on the hash not the message text, but Ii would not be completely foolproof as two identical messages could be loaded by different sessions if the timing was exactly right (or wrong, depending on your perspective).