Re: data modeling appointment scheduling

2018-11-04 Thread I PVP
tments? On Sun, Nov 4, 2018 at 12:46 PM I PVP mailto:i...@hotmail.com>> wrote: Could you please provide advice on the modeling approach for the following appointment scheduling scenario? I am struggling to model in an way that allows to satisfy the requirement to be able to update an

data modeling appointment scheduling

2018-11-04 Thread I PVP
Could you please provide advice on the modeling approach for the following appointment scheduling scenario? I am struggling to model in an way that allows to satisfy the requirement to be able to update an appointment, specially to be able to change the start datetime and consequently the

Re: Working With Prepared Statements

2017-08-29 Thread I PVP
Hi Shalom, If that helps.. From the documentation : "You should prepare only once, and cache the PreparedStatement in your application (it is thread-safe). If you call prepare multiple times with the same query string, the driver will log a warning” On August 29, 2017 at 12:04:34 PM, Shalom

Cassandra + Stratio’s Cassandra Lucene Index for online quering

2017-07-28 Thread I PVP
Considering that Stratio’s Cassandra Lucene Index, "..is a plugin for Apache Cassandra that extends its index functionality to provide near real time search such as ElasticSearch or Solr..". Can I use Stratio’s Cassandra Lucene Index to build a online reporting functionality within my

Re: /etc/init.d/cassandra for RHEL

2017-03-29 Thread I PVP
This one worked fine https://blog.tomas.cat/sites/default/files/cassandra.initd On March 29, 2017 at 2:17:17 AM, I PVP (i...@hotmail.com<mailto:i...@hotmail.com>) wrote: i tried using the https://github.com/apache/cassandra/blob/trunk/redhat/cassandra won’t start using my own

Re: /etc/init.d/cassandra for RHEL

2017-03-28 Thread I PVP
wrote: On 03/28/2017 10:53 PM, Michael Shuler wrote: > On 03/28/2017 09:36 PM, I PVP wrote: >> any recommend /etc/init.d/cassandra for RHEL when installing it from >> apache-cassandra-3.10-bin.tar.gz ? >> >> i goggled it but could not find anything that seems to be &qu

/etc/init.d/cassandra for RHEL

2017-03-28 Thread I PVP
any recommend /etc/init.d/cassandra for RHEL when installing it from apache-cassandra-3.10-bin.tar.gz ? i goggled it but could not find anything that seems to be "proven"

Re: Modeling Audit Trail on Cassandra

2016-03-18 Thread I PVP
Jack/Tom Thanks for answering. Here is the table definition so far: CREATE TABLE audit_trail ( auditid timeuuid, actiontype text, objecttype text, executedby uuid ( or timeuuid?), executedat timestamp, objectbefore text, objectafter text, clientipaddr text, serveripaddr text, servername text,

Modeling Audit Trail on Cassandra

2016-03-15 Thread I PVP
Hi everyone, I am looking for your feedback or advice on modeling an audit trail log table on Cassandra that stores information from tracking everything an employee changes within the application. The existing application is being migrated from mysql to Cassandra. Is text the most

RE: Modeling transactional messages

2016-03-04 Thread I PVP
be large/wide, perhaps add a time bucket to the partition key, like mm) - (domain, time bucket), objectID Set TTL on these rows (either default or with the insert) to get the purge to be automatic. Sean Durity From: I PVP [mailto:i...@hotmail.com] Sent: Thursday, March 03, 2016 7:51 PM To: u

Modeling transactional messages

2016-03-03 Thread I PVP
Hi everyone, Can anyone please let me know if I am heading to an antiparttern or somethingelse bad? How would you model the following ... ? I am migrating from MYSQL to Cassandra, I have a scenario in which need to store the content of "to be sent" transactional email messages that the

Modeling approach to widely used textual information

2016-01-14 Thread I PVP
Hi everyone, I am new to Cassandra and moving a existing myqql application to Cassandra. As a generic rule, what is the recommended approach for keeping textual information like a user_nickname, a company_name, product_title, that will potentially be updated at some time and is routinely and

Re: Modeling contact list, plain table or List

2016-01-12 Thread I PVP
city text, zip_code int, ); CREATE TABLE user ( user_id int primary key, addresses map<text, frozen > ); When I want to remove one of the addresses from a user, I can do this: cqlsh:test> delete addresses['home'] from user where user_id = 1; Hope that helps, Jon On Mon, Jan 1

Re: Modeling contact list, plain table or List

2016-01-11 Thread I PVP
The below table and materialized view will solve the SELECT requirements of my current application . The challenge now is when the user decides to DELETE one specific contact from his contact list. I could add the objectid to a composite partition key together with the userid. But that would